diff -r d972b1276d95 -r 49db7495f6b8 install/schemas/upgrade/postgresql/1125.sql --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/install/schemas/upgrade/postgresql/1125.sql Thu Jul 01 20:24:19 2010 -0400 @@ -0,0 +1,5 @@ +ALTER TABLE {{TABLE_PREFIX}}users_extra ADD COLUMN date_format varchar(32) NOT NULL DEFAULT 'F d, Y'; +ALTER TABLE {{TABLE_PREFIX}}users_extra ADD COLUMN time_format varchar(32) NOT NULL DEFAULT 'G:i'; +ALTER TABLE {{TABLE_PREFIX}}lockout ADD COLUMN username varchar(255) NOT NULL DEFAULT ''; +ALTER TABLE {{TABLE_PREFIX}}logs ADD COLUMN author_uid int NOT NULL DEFAULT 1; +UPDATE {{TABLE_PREFIX}}logs SET author_uid = 1;