From 864e7e690fd08106bd514c8899faa6c4a77bfbee Mon Sep 17 00:00:00 2001 From: Mike Macgirvin Date: Wed, 28 Jul 2010 23:15:10 -0700 Subject: verified registrations working --- database.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) (limited to 'database.sql') diff --git a/database.sql b/database.sql index 55dcaeb13..ca9485777 100644 --- a/database.sql +++ b/database.sql @@ -316,3 +316,13 @@ CREATE TABLE IF NOT EXISTS `user` ( `pwdreset` char(255) NOT NULL, PRIMARY KEY (`uid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; + + +CREATE TABLE IF NOT EXISTS `register` ( + `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, + `hash` CHAR( 255 ) NOT NULL , + `created` DATETIME NOT NULL , + `uid` INT(11) UNSIGNED NOT NULL, + `password` CHAR(255) NOT NULL, + PRIMARY KEY (`id`) +) ENGINE = MYISAM DEFAULT CHARSET=utf8; \ No newline at end of file -- cgit v1.2.3