install/schemas/upgrade/1.1.1-1.1.2-postgresql.sql
changeset 410 9db359d6e60c
child 413 6607cd646d6d
equal deleted inserted replaced
409:267be9e394c2 410:9db359d6e60c
       
     1 -- Enano CMS
       
     2 -- Upgrade schema - Enano 1.1.1 - 1.1.2
       
     3 
       
     4 ALTER TABLE {{TABLE_PREFIX}}logs ADD COLUMN log_id SERIAL, ADD PRIMARY KEY ( log_id );
       
     5 
       
     6 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 
       
     9 CREATE TABLE {{TABLE_PREFIX}}ranks(
       
    10   rank_id SERIAL,
       
    11   rank_title varchar(63) NOT NULL DEFAULT '',
       
    12   rank_style varchar(255) NOT NULL DEFAULT '',
       
    13   PRIMARY KEY ( rank_id )
       
    14 );
       
    15 
       
    16 CREATE TABLE {{TABLE_PREFIX}}captcha(
       
    17   code_id SERIAL,
       
    18   session_id varchar(40) NOT NULL DEFAULT '',
       
    19   code varchar(64) NOT NULL DEFAULT '',
       
    20   session_data text,
       
    21   source_ip varchar(39),
       
    22   user_id int(12),
       
    23   PRIMARY KEY ( code_id )
       
    24 );
       
    25 
       
    26 INSERT INTO {{TABLE_PREFIX}}ranks(rank_id, rank_title, rank_style) VALUES
       
    27   (1, 'user_rank_member', ''),
       
    28   (2, 'user_rank_mod', 'font-weight: bold; color: #00AA00;'),
       
    29   (3, 'user_rank_admin', 'font-weight: bold; color: #AA0000;');
       
    30