install/schemas/upgrade/1.1.1-1.1.2-postgresql.sql
changeset 494 6c78cc456091
parent 430 ec90736b9cb9
child 625 0122f538c242
--- a/install/schemas/upgrade/1.1.1-1.1.2-postgresql.sql	Fri Mar 07 01:27:28 2008 -0500
+++ b/install/schemas/upgrade/1.1.1-1.1.2-postgresql.sql	Sat Mar 08 12:12:27 2008 -0500
@@ -4,8 +4,9 @@
 ALTER TABLE {{TABLE_PREFIX}}logs ADD COLUMN log_id SERIAL, ADD PRIMARY KEY ( log_id );
 ALTER TABLE {{TABLE_PREFIX}}logs ADD COLUMN is_draft smallint NOT NULL DEFAULT 0;
 
-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}}users ADD COLUMN user_rank int NOT NULL DEFAULT 1;
+@ALTER TABLE {{TABLE_PREFIX}}users 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',