install/schemas/postgresql_stage2.sql
changeset 430 ec90736b9cb9
parent 413 6607cd646d6d
child 436 242353360e37
--- a/install/schemas/postgresql_stage2.sql	Sun Feb 17 20:19:17 2008 -0500
+++ b/install/schemas/postgresql_stage2.sql	Mon Feb 18 16:27:28 2008 -0500
@@ -82,8 +82,11 @@
   theme_id varchar(63),
   theme_name text,
   theme_order smallint NOT NULL DEFAULT '1',
-  DEFAULT_style varchar(63) NOT NULL DEFAULT '',
-  enabled smallint NOT NULL DEFAULT '1'
+  default_style varchar(63) NOT NULL DEFAULT '',
+  enabled smallint NOT NULL DEFAULT '1',
+  group_list text DEFAULT NULL,
+  group_policy varchar(5) NOT NULL DEFAULT 'deny',
+  CHECK (group_policy IN ('allow', 'deny'))
 );
 
 CREATE TABLE {{TABLE_PREFIX}}users(