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