--- 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,