--- 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 )
 );