install/schemas/upgrade/1.1.1-1.1.2-mysql.sql
changeset 1259 49db7495f6b8
parent 1258 d972b1276d95
child 1260 cd72bcd83401
equal deleted inserted replaced
1258:d972b1276d95 1259:49db7495f6b8
     1 -- Enano CMS
       
     2 -- Upgrade schema - Enano 1.1.1 - 1.1.2
       
     3 
       
     4 ALTER TABLE {{TABLE_PREFIX}}logs ADD COLUMN log_id int(15) NOT NULL auto_increment, ADD PRIMARY KEY ( log_id );
       
     5 ALTER TABLE {{TABLE_PREFIX}}logs ADD COLUMN is_draft tinyint(1) NOT NULL DEFAULT 0;
       
     6 
       
     7 ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_rank int(12) UNSIGNED NOT NULL DEFAULT 1;
       
     8 ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_timezone int(12) UNSIGNED NOT NULL DEFAULT 1440;
       
     9 
       
    10 @ALTER TABLE {{TABLE_PREFIX}}tags CHANGE user user_id mediumint(8) NOT NULL DEFAULT 1;
       
    11 ALTER TABLE {{TABLE_PREFIX}}themes
       
    12   ADD COLUMN group_list text DEFAULT NULL,
       
    13   ADD COLUMN group_policy ENUM('allow', 'deny') NOT NULL DEFAULT 'deny';
       
    14 
       
    15 CREATE TABLE {{TABLE_PREFIX}}ranks(
       
    16   rank_id int(12) NOT NULL auto_increment,
       
    17   rank_title varchar(63) NOT NULL DEFAULT '',
       
    18   rank_style varchar(255) NOT NULL DEFAULT '',
       
    19   PRIMARY KEY ( rank_id )
       
    20 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
       
    21 
       
    22 CREATE TABLE {{TABLE_PREFIX}}captcha(
       
    23   code_id int(12) NOT NULL auto_increment,
       
    24   session_id varchar(40) NOT NULL DEFAULT '',
       
    25   code varchar(64) NOT NULL DEFAULT '',
       
    26   session_data text,
       
    27   source_ip varchar(39),
       
    28   user_id int(12),
       
    29   PRIMARY KEY ( code_id )
       
    30 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
       
    31 
       
    32 INSERT INTO {{TABLE_PREFIX}}ranks(rank_id, rank_title, rank_style) VALUES
       
    33   (1, 'user_rank_member', ''),
       
    34   (2, 'user_rank_mod', 'font-weight: bold; color: #00AA00;'),
       
    35   (3, 'user_rank_admin', 'font-weight: bold; color: #AA0000;');
       
    36