diff -r f5718d7c2a6a -r ec90736b9cb9 install/schemas/upgrade/1.1.1-1.1.2-postgresql.sql --- a/install/schemas/upgrade/1.1.1-1.1.2-postgresql.sql Sun Feb 17 20:19:17 2008 -0500 +++ b/install/schemas/upgrade/1.1.1-1.1.2-postgresql.sql Mon Feb 18 16:27:28 2008 -0500 @@ -6,6 +6,10 @@ ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_rank int NOT NULL DEFAULT 1, ADD COLUMN user_timezone int NOT NULL DEFAULT 0; +ALTER TABLE {{TABLE_PREFIX}}themes + ADD COLUMN group_list text DEFAULT NULL, + ADD COLUMN group_policy varchar(5) NOT NULL DEFAULT 'deny', + ADD CHECK (group_policy IN ('allow', 'deny')); CREATE TABLE {{TABLE_PREFIX}}ranks( rank_id SERIAL,