install/schemas/upgrade/migration/1.0-1.1-mysql.sql
changeset 406 7468a663315f
parent 377 bb3e6c3bd4f4
child 497 ecb636490702
--- a/install/schemas/upgrade/migration/1.0-1.1-mysql.sql	Fri Feb 08 12:16:43 2008 -0500
+++ b/install/schemas/upgrade/migration/1.0-1.1-mysql.sql	Fri Feb 08 23:20:20 2008 -0500
@@ -14,6 +14,7 @@
 ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_has_avatar tinyint(1) NOT NULL;
 ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN avatar_type ENUM('jpg', 'png', 'gif') NOT NULL;
 ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_registration_ip varchar(39);
+ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_timezone int(12) NOT NULL DEFAULT 0;
 ALTER TABLE {{TABLE_PREFIX}}comments ADD COLUMN ip_address varchar(39);
 
 CREATE TABLE {{TABLE_PREFIX}}lockout(