diff -r 4746dd07cc48 -r 6607cd646d6d install/schemas/upgrade/1.1.1-1.1.2-postgresql.sql --- a/install/schemas/upgrade/1.1.1-1.1.2-postgresql.sql Mon Feb 11 14:33:49 2008 -0500 +++ b/install/schemas/upgrade/1.1.1-1.1.2-postgresql.sql Tue Feb 12 00:37:46 2008 -0500 @@ -2,6 +2,7 @@ -- Upgrade schema - Enano 1.1.1 - 1.1.2 ALTER TABLE {{TABLE_PREFIX}}logs ADD COLUMN log_id SERIAL, ADD PRIMARY KEY ( log_id ); +ALTER TABLE {{TABLE_PREFIX}}logs ADD COLUMN is_draft smallint NOT NULL DEFAULT 0; ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_rank int NOT NULL DEFAULT 1, ADD COLUMN user_timezone int NOT NULL DEFAULT 0;