1 CREATE DATABASE members; |
1 CREATE DATABASE members; |
2 GRANT ALL ON members.* TO 'www-data'@'localhost'; |
2 GRANT ALL ON members.* TO 'www-data'@'localhost'; |
3 |
|
4 CREATE TABLE `members`.`creds` ( |
3 CREATE TABLE `members`.`creds` ( |
5 `uid` int(8) unsigned NOT NULL auto_increment, |
4 `uid` int(8) unsigned NOT NULL auto_increment, |
6 `username` varchar(20) NOT NULL default 'anon', |
5 `username` varchar(20) NOT NULL default 'anon', |
7 `password_md5` varchar(32) NOT NULL default '5f4dcc3b5aa765d61d8327deb882cf99' COMMENT 'default password = password', |
6 `password_md5` varchar(32) NOT NULL default '5f4dcc3b5aa765d61d8327deb882cf99' COMMENT 'default password = password', |
8 PRIMARY KEY (`uid`), |
7 PRIMARY KEY (`uid`), |
9 KEY `new_index` (`uid`) |
8 KEY `new_index` (`uid`) |
10 ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED |
9 ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED |
11 |
|
12 CREATE TABLE `members`.`groups` ( |
10 CREATE TABLE `members`.`groups` ( |
13 `gid` int(8) unsigned NOT NULL, |
11 `gid` int(8) unsigned NOT NULL, |
14 `groupname` varchar(20) character set utf8 NOT NULL, |
12 `groupname` varchar(20) character set utf8 NOT NULL, |
15 PRIMARY KEY (`gid`) |
13 PRIMARY KEY (`gid`) |
16 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
14 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
17 |
|
18 CREATE TABLE `members`.`requests_tbl` ( |
15 CREATE TABLE `members`.`requests_tbl` ( |
19 `req_ID` varchar(32) collate utf8_unicode_ci NOT NULL, |
16 `req_ID` varchar(32) collate utf8_unicode_ci NOT NULL, |
20 `uid` int(8) unsigned NOT NULL, |
17 `uid` int(8) unsigned NOT NULL, |
21 `req_val` varchar(1024) collate utf8_unicode_ci NOT NULL, |
18 `req_val` varchar(1024) collate utf8_unicode_ci NOT NULL, |
22 `req_response` tinyint(1) NOT NULL, |
19 `req_response` tinyint(1) NOT NULL, |
23 `req_created` date NOT NULL, |
20 `req_created` date NOT NULL, |
24 PRIMARY KEY (`req_ID`), |
21 PRIMARY KEY (`req_ID`), |
25 KEY `new_index` (`uid`), |
22 KEY `new_index` (`uid`), |
26 CONSTRAINT `new_fk_constraint10` FOREIGN KEY (`uid`) REFERENCES `creds` (`uid`) ON UPDATE CASCADE |
23 CONSTRAINT `new_fk_constraint10` FOREIGN KEY (`uid`) REFERENCES `creds` (`uid`) ON UPDATE CASCADE |
27 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='InnoDB free: 3072 kB; (`user_ID`) REFER `members/creds`(`uid`)' |
24 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='InnoDB free: 3072 kB; (`user_ID`) REFER `members/creds`(`uid`)' |
28 |
|
29 CREATE TABLE `members`.`sessions` ( |
25 CREATE TABLE `members`.`sessions` ( |
30 `sid` varchar(32) NOT NULL, |
26 `sid` varchar(32) NOT NULL default '06D5VlLQTbM57LL7IBMW38yHkFpb1XVa', |
31 `sid_dir` varchar(32) NOT NULL, |
27 `sid_dir` varchar(32) NOT NULL default '06D5VlLQTbM57LL7IBMW38yHkFpb1XVa', |
32 `uid` int(8) unsigned NOT NULL, |
28 `uid` int(8) unsigned NOT NULL, |
33 `signature` varchar(20) NOT NULL, |
29 `signature` varchar(20) NOT NULL, |
34 `timeout_date` datetime NOT NULL, |
30 `timeout_date` datetime NOT NULL, |
35 `expiration_date` datetime NOT NULL, |
31 `expiration_date` datetime NOT NULL, |
36 PRIMARY KEY (`sid`), |
32 `enum` int(8) unsigned NOT NULL auto_increment, |
|
33 PRIMARY KEY (`enum`), |
37 KEY `new_fk_constraint` (`uid`), |
34 KEY `new_fk_constraint` (`uid`), |
38 CONSTRAINT `new_fk_constraint` FOREIGN KEY (`uid`) REFERENCES `creds` (`uid`) ON UPDATE CASCADE |
35 CONSTRAINT `new_fk_constraint` FOREIGN KEY (`uid`) REFERENCES `creds` (`uid`) ON UPDATE CASCADE |
39 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC |
36 ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC |
40 |
|
41 CREATE TABLE `members`.`tracking` ( |
37 CREATE TABLE `members`.`tracking` ( |
42 `uid` int(8) unsigned NOT NULL, |
38 `uid` int(8) unsigned NOT NULL, |
43 `client_ip_address` varchar(15) NOT NULL, |
39 `client_ip_address` varchar(15) NOT NULL, |
44 `download_date` datetime NOT NULL, |
40 `download_date` datetime NOT NULL, |
45 `download_path` varchar(255) NOT NULL, |
41 `download_path` varchar(255) NOT NULL, |
46 `download_size` int(8) unsigned NOT NULL, |
42 `download_size` int(8) unsigned NOT NULL, |
47 KEY `new_fk_constraint3` (`uid`), |
43 KEY `new_fk_constraint3` (`uid`), |
48 CONSTRAINT `new_fk_constraint12` FOREIGN KEY (`uid`) REFERENCES `creds` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE |
44 CONSTRAINT `new_fk_constraint12` FOREIGN KEY (`uid`) REFERENCES `creds` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE |
49 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED |
45 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED |
50 |
|
51 CREATE TABLE `members`.`uid_gid` ( |
46 CREATE TABLE `members`.`uid_gid` ( |
52 `uid` int(8) unsigned NOT NULL, |
47 `uid` int(8) unsigned NOT NULL, |
53 `gid` int(8) unsigned NOT NULL, |
48 `gid` int(8) unsigned NOT NULL default '0', |
54 PRIMARY KEY (`uid`), |
49 `enum` int(8) unsigned NOT NULL auto_increment, |
55 KEY `new_index` USING BTREE (`uid`), |
50 PRIMARY KEY USING BTREE (`enum`) |
56 KEY `new_fk_constraint9` USING BTREE (`gid`), |
51 ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='InnoDB free: 4096 kB; (`uid`) REFER `members/creds`(`uid`)' |
57 CONSTRAINT `new_fk_constraint2` FOREIGN KEY (`uid`) REFERENCES `creds` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE |
|
58 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 4096 kB; (`uid`) REFER `members/creds`(`uid`)' |
|
59 |
|