# HG changeset patch
# User Alex McMahon <alex.mcmahon@cs.tcd.ie>
# Date 1243001350 -3600
# Node ID 1c27769b843598f50586e75ca6cb8250998f57ba
# Parent  e506cab7f83a103e3ba48a2af669a2fb708e18e3
schema change - request_ID now varchar(32)

diff -r e506cab7f83a -r 1c27769b8435 mysql_apache/mysql_members_schema
--- a/mysql_apache/mysql_members_schema	Thu May 21 17:11:18 2009 +0100
+++ b/mysql_apache/mysql_members_schema	Fri May 22 15:09:10 2009 +0100
@@ -1,3 +1,6 @@
+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',
@@ -12,14 +15,8 @@
   PRIMARY KEY  (`gid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8
 
-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` int(8) unsigned NOT NULL auto_increment,
+  `req_ID` varchar(32) collate utf8_unicode_ci NOT NULL,
   `uid` int(8) unsigned NOT NULL,
   `req_val` varchar(1024) collate utf8_unicode_ci NOT NULL,
   `req_response` tinyint(1) NOT NULL,
@@ -27,7 +24,7 @@
   PRIMARY KEY  (`req_ID`),
   KEY `new_index` (`uid`),
   CONSTRAINT `new_fk_constraint10` FOREIGN KEY (`uid`) REFERENCES `creds` (`uid`) ON UPDATE CASCADE
-) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='InnoDB free: 3072 kB; (`user_ID`) REFER `members/creds`(`uid`)'
+) 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,
@@ -36,7 +33,6 @@
   `signature` varchar(20) NOT NULL,
   `timeout_date` datetime NOT NULL,
   `expiration_date` datetime NOT NULL,
-  `req_ID` int(8) unsigned NOT NULL,
   PRIMARY KEY  (`sid`),
   KEY `new_fk_constraint` (`uid`),
   CONSTRAINT `new_fk_constraint` FOREIGN KEY (`uid`) REFERENCES `creds` (`uid`) ON UPDATE CASCADE