diff -r d972b1276d95 -r 49db7495f6b8 install/schemas/upgrade/postgresql/1123.sql --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/install/schemas/upgrade/postgresql/1123.sql Thu Jul 01 20:24:19 2010 -0400 @@ -0,0 +1,4 @@ +ALTER TABLE {{TABLE_PREFIX}}session_keys ADD COLUMN key_type smallint NOT NULL DEFAULT 0; +UPDATE {{TABLE_PREFIX}}session_keys SET key_type = 2 WHERE auth_level > 2; +ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_dst varchar(11) NOT NULL DEFAULT '0;0;0;0;60'; +ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_rank_userset smallint NOT NULL DEFAULT 0;