install/schemas/upgrade/1.1.1-1.1.2-postgresql.sql
changeset 413 6607cd646d6d
parent 410 9db359d6e60c
child 430 ec90736b9cb9
equal deleted inserted replaced
412:4746dd07cc48 413:6607cd646d6d
     1 -- Enano CMS
     1 -- Enano CMS
     2 -- Upgrade schema - Enano 1.1.1 - 1.1.2
     2 -- Upgrade schema - Enano 1.1.1 - 1.1.2
     3 
     3 
     4 ALTER TABLE {{TABLE_PREFIX}}logs ADD COLUMN log_id SERIAL, ADD PRIMARY KEY ( log_id );
     4 ALTER TABLE {{TABLE_PREFIX}}logs ADD COLUMN log_id SERIAL, ADD PRIMARY KEY ( log_id );
       
     5 ALTER TABLE {{TABLE_PREFIX}}logs ADD COLUMN is_draft smallint NOT NULL DEFAULT 0;
     5 
     6 
     6 ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_rank int NOT NULL DEFAULT 1,
     7 ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_rank int NOT NULL DEFAULT 1,
     7                                   ADD COLUMN user_timezone int NOT NULL DEFAULT 0;
     8                                   ADD COLUMN user_timezone int NOT NULL DEFAULT 0;
     8 
     9 
     9 CREATE TABLE {{TABLE_PREFIX}}ranks(
    10 CREATE TABLE {{TABLE_PREFIX}}ranks(