install/schemas/postgresql_stage2.sql
changeset 555 ac4c6a7f01d8
parent 541 acb7e23b6ffa
child 621 68f8a9cc0a18
--- a/install/schemas/postgresql_stage2.sql	Mon May 12 00:59:46 2008 -0400
+++ b/install/schemas/postgresql_stage2.sql	Fri May 16 12:22:26 2008 -0400
@@ -129,6 +129,7 @@
   user_job text,
   user_hobbies text,
   email_public smallint NOT NULL DEFAULT 0,
+  disable_js_fx smallint NOT NULL DEFAULT 0,
   PRIMARY KEY ( user_id ) 
 );
 
@@ -204,8 +205,9 @@
   group_id SERIAL,
   group_name varchar(64),
   group_type smallint NOT NULL DEFAULT 1,
-  PRIMARY KEY ( group_id ),
-  system_group smallint NOT NULL DEFAULT 0 
+  system_group smallint NOT NULL DEFAULT 0,
+  group_rank int DEFAULT NULL,
+  PRIMARY KEY ( group_id )
 );
 
 CREATE TABLE {{TABLE_PREFIX}}group_members(