# HG changeset patch
# User Dan
# Date 1215835643 14400
# Node ID 0122f538c242530c719e5363c5caa4aa8136cdb1
# Parent  e9c04ed3290fabcb4021f675aec5c4d1005dc11d
Hopefully fixed user_timezone bug in PostgreSQL upgrade

diff -r e9c04ed3290f -r 0122f538c242 install/schemas/upgrade/1.1.1-1.1.2-postgresql.sql
--- a/install/schemas/upgrade/1.1.1-1.1.2-postgresql.sql	Wed Jul 09 23:44:19 2008 -0400
+++ b/install/schemas/upgrade/1.1.1-1.1.2-postgresql.sql	Sat Jul 12 00:07:23 2008 -0400
@@ -5,7 +5,8 @@
 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;
-@ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_timezone int NOT NULL DEFAULT 0;
+@ALTER TABLE {{TABLE_PREFIX}}users DROP user_timezone;
+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,
@@ -25,7 +26,7 @@
   code varchar(64) NOT NULL DEFAULT '',
   session_data text,
   source_ip varchar(39),
-  user_id int(12),
+  user_id int,
   PRIMARY KEY ( code_id )
 );