Labs/Weave/User/1.0/Setup: Difference between revisions

Labs/Weave/User/1.0/Setup (view source)

37 bytes removed , 27 April 2010

→‎Mysql: It changed in 1.0

4

edits

@@ Line 42: / Line 42: @@
 <pre>
-CREATE TABLE `users` (
+create table users (
-  id int(11) NOT NULL PRIMARY KEY auto_increment,
+ id int(11) NOT NULL PRIMARY KEY auto_increment,
-  username varbinary(32) NOT NULL,
+ username varchar(32),
-  md5 varbinary(64) default NULL,
+ password_hash varbinary(128),
-  email varbinary(64) default NULL,
+ email varbinary(64),
-  location text,
+ status tinyint(4) default '1',
-  status tinyint(4) default '1',
+ alert text,
-  alert text,
+ reset varbinary(32) default null
-  reset varchar(32)
+) engine=InnoDB;</pre>
-) ENGINE=InnoDB;</pre>
 Constants: