--- a/install/schemas/mysql_stage2.sql	Sat Apr 26 17:25:28 2008 -0400
+++ b/install/schemas/mysql_stage2.sql	Sun May 04 21:57:48 2008 -0400
@@ -110,8 +110,10 @@
   user_has_avatar tinyint(1) NOT NULL DEFAULT 0,
   avatar_type ENUM('jpg', 'png', 'gif') NOT NULL DEFAULT 'png',
   user_registration_ip varchar(39),
-  user_rank int(12) UNSIGNED NOT NULL DEFAULT 1,
+  user_rank int(12) UNSIGNED DEFAULT NULL,
   user_timezone int(12) UNSIGNED NOT NULL DEFAULT 0,
+  user_title varchar(64) DEFAULT NULL,
+  user_group mediumint(5) NOT NULL DEFAULT 1,
   PRIMARY KEY  (user_id)
 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
 
@@ -376,7 +378,8 @@
 INSERT INTO {{TABLE_PREFIX}}ranks(rank_id, rank_title, rank_style) VALUES
   (1, 'user_rank_member', ''),
   (2, 'user_rank_mod', 'font-weight: bold; color: #00AA00;'),
-  (3, 'user_rank_admin', 'font-weight: bold; color: #AA0000;');
+  (3, 'user_rank_admin', 'font-weight: bold; color: #AA0000;'),
+  (4, 'user_rank_guest', '');
 
 INSERT INTO {{TABLE_PREFIX}}groups(group_id,group_name,group_type,system_group) VALUES(1, 'Everyone', 3, 1),
   (2,'Administrators',3,1),