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

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

144 bytes added , 13 November 2009

canmove, Confirmed users

1,173

edits

@@ Line 57: / Line 57: @@
 <pre>
-create table users
+CREATE TABLE `users` (
-(
+  id int(11) NOT NULL PRIMARY KEY auto_increment,
- username varchar(32) primary key,
+  username varbinary(32) NOT NULL,
- md5 varbinary(32),
+  md5 varbinary(32) default NULL,
- email varbinary(64),
+  email varbinary(64) default NULL,
- status tinyint,
+  location text,
- location text,
+  shard varbinary(32) default NULL,
- alert text
+  status tinyint(4) default '1',
-) engine=InnoDB;
+  alert text,
-</pre>
+) ENGINE=InnoDB;</pre>
 Constants:
@@ Line 82: / Line 82: @@
 <pre>
-insert into users values ('username', md5('password'), null, 1, null);
+insert into users (username, md5, status) values ('username', md5('password'), 1);
 </pre>