|
1 CREATE DATABASE members; |
|
2 GRANT ALL ON members.* TO 'www-data'@'localhost'; |
|
3 |
1 CREATE TABLE `members`.`creds` ( |
4 CREATE TABLE `members`.`creds` ( |
2 `uid` int(8) unsigned NOT NULL auto_increment, |
5 `uid` int(8) unsigned NOT NULL auto_increment, |
3 `username` varchar(20) NOT NULL default 'anon', |
6 `username` varchar(20) NOT NULL default 'anon', |
4 `password_md5` varchar(32) NOT NULL default '5f4dcc3b5aa765d61d8327deb882cf99' COMMENT 'default password = password', |
7 `password_md5` varchar(32) NOT NULL default '5f4dcc3b5aa765d61d8327deb882cf99' COMMENT 'default password = password', |
5 PRIMARY KEY (`uid`), |
8 PRIMARY KEY (`uid`), |
10 `gid` int(8) unsigned NOT NULL, |
13 `gid` int(8) unsigned NOT NULL, |
11 `groupname` varchar(20) character set utf8 NOT NULL, |
14 `groupname` varchar(20) character set utf8 NOT NULL, |
12 PRIMARY KEY (`gid`) |
15 PRIMARY KEY (`gid`) |
13 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
16 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
14 |
17 |
15 CREATE TABLE `members`.`groups` ( |
|
16 `gid` int(8) unsigned NOT NULL, |
|
17 `groupname` varchar(20) character set utf8 NOT NULL, |
|
18 PRIMARY KEY (`gid`) |
|
19 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
|
20 |
|
21 CREATE TABLE `members`.`requests_tbl` ( |
18 CREATE TABLE `members`.`requests_tbl` ( |
22 `req_ID` int(8) unsigned NOT NULL auto_increment, |
19 `req_ID` varchar(32) collate utf8_unicode_ci NOT NULL, |
23 `uid` int(8) unsigned NOT NULL, |
20 `uid` int(8) unsigned NOT NULL, |
24 `req_val` varchar(1024) collate utf8_unicode_ci NOT NULL, |
21 `req_val` varchar(1024) collate utf8_unicode_ci NOT NULL, |
25 `req_response` tinyint(1) NOT NULL, |
22 `req_response` tinyint(1) NOT NULL, |
26 `req_created` date NOT NULL, |
23 `req_created` date NOT NULL, |
27 PRIMARY KEY (`req_ID`), |
24 PRIMARY KEY (`req_ID`), |
28 KEY `new_index` (`uid`), |
25 KEY `new_index` (`uid`), |
29 CONSTRAINT `new_fk_constraint10` FOREIGN KEY (`uid`) REFERENCES `creds` (`uid`) ON UPDATE CASCADE |
26 CONSTRAINT `new_fk_constraint10` FOREIGN KEY (`uid`) REFERENCES `creds` (`uid`) ON UPDATE CASCADE |
30 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='InnoDB free: 3072 kB; (`user_ID`) REFER `members/creds`(`uid`)' |
27 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='InnoDB free: 3072 kB; (`user_ID`) REFER `members/creds`(`uid`)' |
31 |
28 |
32 CREATE TABLE `members`.`sessions` ( |
29 CREATE TABLE `members`.`sessions` ( |
33 `sid` varchar(32) NOT NULL, |
30 `sid` varchar(32) NOT NULL, |
34 `sid_dir` varchar(32) NOT NULL, |
31 `sid_dir` varchar(32) NOT NULL, |
35 `uid` int(8) unsigned NOT NULL, |
32 `uid` int(8) unsigned NOT NULL, |
36 `signature` varchar(20) NOT NULL, |
33 `signature` varchar(20) NOT NULL, |
37 `timeout_date` datetime NOT NULL, |
34 `timeout_date` datetime NOT NULL, |
38 `expiration_date` datetime NOT NULL, |
35 `expiration_date` datetime NOT NULL, |
39 `req_ID` int(8) unsigned NOT NULL, |
|
40 PRIMARY KEY (`sid`), |
36 PRIMARY KEY (`sid`), |
41 KEY `new_fk_constraint` (`uid`), |
37 KEY `new_fk_constraint` (`uid`), |
42 CONSTRAINT `new_fk_constraint` FOREIGN KEY (`uid`) REFERENCES `creds` (`uid`) ON UPDATE CASCADE |
38 CONSTRAINT `new_fk_constraint` FOREIGN KEY (`uid`) REFERENCES `creds` (`uid`) ON UPDATE CASCADE |
43 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC |
39 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC |
44 |
40 |