# HG changeset patch
# User Alex Mcmahon <alex.mcmahon@cs.tcd.ie>
# Date 1273514969 -3600
# Node ID b013d6ae280c0d819c0a4e309958c6d7eda3ccb2
# Parent  3ad193634e5d37ffda4a083aa1f40afbbee1533e
schema correction

diff -r 3ad193634e5d -r b013d6ae280c mysql_apache/mysql_members_schema
--- a/mysql_apache/mysql_members_schema	Tue Jul 07 19:14:12 2009 +0100
+++ b/mysql_apache/mysql_members_schema	Mon May 10 19:09:29 2010 +0100
@@ -1,17 +1,18 @@
 CREATE DATABASE members;
 GRANT ALL ON members.* TO 'www-data'@'localhost';
+SET PASSWORD FOR 'www-data'@localhost = PASSWORD('www-data');
 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=1 DEFAULT CHARSET=utf8 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
+) 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,
@@ -21,7 +22,7 @@
   PRIMARY KEY  (`req_ID`),
   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`)'
+) 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 default '06D5VlLQTbM57LL7IBMW38yHkFpb1XVa',
   `sid_dir` varchar(32) NOT NULL default '06D5VlLQTbM57LL7IBMW38yHkFpb1XVa',
@@ -33,7 +34,7 @@
   PRIMARY KEY  (`enum`),
   KEY `new_fk_constraint` (`uid`),
   CONSTRAINT `new_fk_constraint` FOREIGN KEY (`uid`) REFERENCES `creds` (`uid`) ON UPDATE CASCADE
-) ENGINE=InnoDB AUTO_INCREMENT=1 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,
@@ -42,10 +43,10 @@
   `download_size` int(8) unsigned NOT NULL,
   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
+) 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 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`)'
+) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='InnoDB free: 4096 kB; (`uid`) REFER `members/creds`(`uid`)';