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