Index: lams_common/db/sql/create_lams_11_tables.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/sql/create_lams_11_tables.sql,v
diff -u -r1.138.2.6.2.5 -r1.138.2.6.2.6
--- lams_common/db/sql/create_lams_11_tables.sql	31 Mar 2010 19:15:33 -0000	1.138.2.6.2.5
+++ lams_common/db/sql/create_lams_11_tables.sql	31 Mar 2010 22:08:41 -0000	1.138.2.6.2.6
@@ -295,7 +295,7 @@
      , enable_flash TINYINT(1) DEFAULT 1
 	 , lams_community_token VARCHAR(255)
  	 , lams_community_username VARCHAR(255)
- 	 , timezone VARCHAR(64)
+ 	 , timezone VARCHAR(255)
      , PRIMARY KEY (user_id)
      , INDEX (authentication_method_id)
      , CONSTRAINT FK_lams_user_1 FOREIGN KEY (authentication_method_id)
@@ -960,7 +960,7 @@
 )TYPE=InnoDB;
 
 CREATE TABLE lams_timezone (
-       id VARCHAR(30) NOT NULL UNIQUE
+       id VARCHAR(255) NOT NULL UNIQUE
      , PRIMARY KEY (id)
 )TYPE=InnoDB;
 
Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02030403.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/dbupdates/Attic/patch02030403.sql,v
diff -u -r1.1.2.2 -r1.1.2.3
--- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02030403.sql	31 Mar 2010 19:15:34 -0000	1.1.2.2
+++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02030403.sql	31 Mar 2010 22:08:41 -0000	1.1.2.3
@@ -2,7 +2,7 @@
 
 -- 	LDEV-2544 Default Timezones
 CREATE TABLE lams_timezone (
-       id VARCHAR(30) NOT NULL UNIQUE
+       id VARCHAR(255) NOT NULL UNIQUE
      , PRIMARY KEY (id)
 )TYPE=InnoDB;
 
@@ -41,7 +41,7 @@
 INSERT INTO lams_timezone (id) VALUES ('Pacific/Kiritimati');
 
 
-ALTER TABLE lams_user MODIFY COLUMN timezone VARCHAR(64);
+ALTER TABLE lams_user MODIFY COLUMN timezone VARCHAR(255);
 
 UPDATE lams_user SET timezone='Etc/GMT+12' WHERE timezone='0';
 UPDATE lams_user SET timezone='Etc/GMT+11' WHERE timezone='1';