diff -r 58852672ff12 -r 68f8a9cc0a18 install/schemas/upgrade/1.1.3-1.1.4-postgresql.sql --- a/install/schemas/upgrade/1.1.3-1.1.4-postgresql.sql Wed Jul 09 21:04:51 2008 -0400 +++ b/install/schemas/upgrade/1.1.3-1.1.4-postgresql.sql Wed Jul 09 22:40:41 2008 -0400 @@ -40,3 +40,6 @@ -- Disable JS effects column ALTER TABLE {{TABLE_PREFIX}}users_extra ADD COLUMN disable_js_fx smallint NOT NULL DEFAULT 0; +-- Add "grv" avatar type +ALTER TABLE {{TABLE_PREFIX}}users DROP CONSTRAINT {{TABLE_PREFIX}}users_avatar_type_check; +ALTER TABLE {{TABLE_PREFIX}}users ADD CONSTRAINT {{TABLE_PREFIX}}users_avatar_type_check CHECK ( avatar_type IN ( 'png', 'gif', 'jpg', 'grv' ) );