--- a/mysql_apache/mysql_members_schema Tue Jun 23 13:41:45 2009 +0100
+++ b/mysql_apache/mysql_members_schema Tue Jul 07 19:14:12 2009 +0100
@@ -1,20 +1,17 @@
CREATE DATABASE members;
GRANT ALL ON members.* TO 'www-data'@'localhost';
-
CREATE TABLE `members`.`creds` (
`uid` int(8) unsigned NOT NULL auto_increment,
`username` varchar(20) NOT NULL default 'anon',
`password_md5` varchar(32) NOT NULL default '5f4dcc3b5aa765d61d8327deb882cf99' COMMENT 'default password = password',
PRIMARY KEY (`uid`),
KEY `new_index` (`uid`)
-) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED
-
+) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED
CREATE TABLE `members`.`groups` (
`gid` int(8) unsigned NOT NULL,
`groupname` varchar(20) character set utf8 NOT NULL,
PRIMARY KEY (`gid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
-
CREATE TABLE `members`.`requests_tbl` (
`req_ID` varchar(32) collate utf8_unicode_ci NOT NULL,
`uid` int(8) unsigned NOT NULL,
@@ -25,19 +22,18 @@
KEY `new_index` (`uid`),
CONSTRAINT `new_fk_constraint10` FOREIGN KEY (`uid`) REFERENCES `creds` (`uid`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='InnoDB free: 3072 kB; (`user_ID`) REFER `members/creds`(`uid`)'
-
CREATE TABLE `members`.`sessions` (
- `sid` varchar(32) NOT NULL,
- `sid_dir` varchar(32) NOT NULL,
+ `sid` varchar(32) NOT NULL default '06D5VlLQTbM57LL7IBMW38yHkFpb1XVa',
+ `sid_dir` varchar(32) NOT NULL default '06D5VlLQTbM57LL7IBMW38yHkFpb1XVa',
`uid` int(8) unsigned NOT NULL,
`signature` varchar(20) NOT NULL,
`timeout_date` datetime NOT NULL,
`expiration_date` datetime NOT NULL,
- PRIMARY KEY (`sid`),
+ `enum` int(8) unsigned NOT NULL auto_increment,
+ PRIMARY KEY (`enum`),
KEY `new_fk_constraint` (`uid`),
CONSTRAINT `new_fk_constraint` FOREIGN KEY (`uid`) REFERENCES `creds` (`uid`) ON UPDATE CASCADE
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC
-
+) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC
CREATE TABLE `members`.`tracking` (
`uid` int(8) unsigned NOT NULL,
`client_ip_address` varchar(15) NOT NULL,
@@ -47,13 +43,9 @@
KEY `new_fk_constraint3` (`uid`),
CONSTRAINT `new_fk_constraint12` FOREIGN KEY (`uid`) REFERENCES `creds` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED
-
CREATE TABLE `members`.`uid_gid` (
`uid` int(8) unsigned NOT NULL,
- `gid` int(8) unsigned NOT NULL,
- PRIMARY KEY (`uid`),
- KEY `new_index` USING BTREE (`uid`),
- KEY `new_fk_constraint9` USING BTREE (`gid`),
- CONSTRAINT `new_fk_constraint2` FOREIGN KEY (`uid`) REFERENCES `creds` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE
-) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 4096 kB; (`uid`) REFER `members/creds`(`uid`)'
-
+ `gid` int(8) unsigned NOT NULL default '0',
+ `enum` int(8) unsigned NOT NULL auto_increment,
+ PRIMARY KEY USING BTREE (`enum`)
+) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='InnoDB free: 4096 kB; (`uid`) REFER `members/creds`(`uid`)'