-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathsecpro.sql
92 lines (75 loc) · 3.22 KB
/
secpro.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
/*
SQLyog Community Edition- MySQL GUI v6.15
MySQL - 5.6.17 : Database - secpro
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*Table structure for table `appsettings` */
CREATE TABLE `appsettings` (
`userid` int(11) DEFAULT NULL,
`uploadmode` int(11) DEFAULT NULL,
`gpsdata` int(11) DEFAULT NULL,
`mediafrequency` int(11) DEFAULT NULL,
`gpsfrequency` int(11) DEFAULT NULL,
UNIQUE KEY `userid_UNIQUE` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `groupdata` */
CREATE TABLE `groupdata` (
`groupid` int(11) NOT NULL AUTO_INCREMENT,
`accmgrid` int(11) DEFAULT NULL,
`groupstatus` int(11) DEFAULT NULL,
`groupname` varchar(100) DEFAULT NULL,
`groupdataaccess` int(11) DEFAULT NULL,
`groupprivacy` int(11) DEFAULT NULL,
`groupcreated` datetime DEFAULT NULL,
`groupmediafrequency` int(11) DEFAULT NULL,
`groupgpsfrequency` int(11) DEFAULT NULL,
PRIMARY KEY (`groupid`),
UNIQUE KEY `groupid_UNIQUE` (`groupid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `groupusersmapping` */
CREATE TABLE `groupusersmapping` (
`groupid` int(11) DEFAULT NULL,
`userid` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `sessiondata` */
CREATE TABLE `sessiondata` (
`sessionid` int(11) NOT NULL AUTO_INCREMENT,
`userid` int(11) DEFAULT NULL,
`sessionname` varchar(100) DEFAULT NULL,
`sessiontype` int(11) DEFAULT NULL,
`sessionstart` datetime DEFAULT NULL,
`sessionend` datetime DEFAULT NULL,
`comments` text,
PRIMARY KEY (`sessionid`),
UNIQUE KEY `sessionid_UNIQUE` (`sessionid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Table structure for table `userdata` */
CREATE TABLE `userdata` (
`id` int(100) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier',
`email` varchar(50) NOT NULL COMMENT 'email address',
`username` varchar(100) DEFAULT NULL COMMENT 'username for login purpose',
`password` varchar(64) DEFAULT NULL,
`userstatus` int(5) DEFAULT NULL COMMENT 'active, inactive, blocked',
`usertype` int(5) DEFAULT NULL COMMENT 'normal, admin',
`logintype` int(5) DEFAULT NULL COMMENT 'email, google, facebook, twitter',
`registeredon` timestamp NULL DEFAULT NULL COMMENT 'timestamp of registration',
`firstname` varchar(50) DEFAULT NULL,
`lastname` varchar(50) DEFAULT NULL,
`profilelink` varchar(50) DEFAULT NULL COMMENT 'male, female, other',
`phone` varchar(20) DEFAULT NULL,
`registeredusing` int(5) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
/*Table structure for table `verificationlinks` */
CREATE TABLE `verificationlinks` (
`linkId` int(11) NOT NULL AUTO_INCREMENT,
`userId` int(11) DEFAULT NULL,
`verificationLink` varchar(60) DEFAULT NULL,
PRIMARY KEY (`linkId`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;