install/schemas/mysql_stage2.sql
changeset 555 ac4c6a7f01d8
parent 541 acb7e23b6ffa
child 621 68f8a9cc0a18
--- a/install/schemas/mysql_stage2.sql	Mon May 12 00:59:46 2008 -0400
+++ b/install/schemas/mysql_stage2.sql	Fri May 16 12:22:26 2008 -0400
@@ -128,6 +128,7 @@
   user_job text,
   user_hobbies text,
   email_public tinyint(1) NOT NULL DEFAULT 0,
+  disable_js_fx tinyint(1) NOT NULL DEFAULT 0,
   PRIMARY KEY ( user_id ) 
 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
 
@@ -203,8 +204,9 @@
   group_id mediumint(5) UNSIGNED NOT NULL auto_increment,
   group_name varchar(64),
   group_type tinyint(1) NOT NULL DEFAULT 1,
-  PRIMARY KEY ( group_id ),
-  system_group tinyint(1) NOT NULL DEFAULT 0 
+  system_group tinyint(1) NOT NULL DEFAULT 0,
+  group_rank int(12) unsigned DEFAULT NULL,
+  PRIMARY KEY ( group_id )
 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
 
 CREATE TABLE {{TABLE_PREFIX}}group_members(