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 

     6 ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_rank int(12) UNSIGNED NOT NULL DEFAULT 1,

     7                                   ADD COLUMN user_timezone int(12) UNSIGNED NOT NULL DEFAULT 0;

     8 

     9 CREATE TABLE {{TABLE_PREFIX}}ranks(

    10   rank_id int(12) NOT NULL auto_increment,

    11   rank_title varchar(63) NOT NULL DEFAULT '',

    12   rank_style varchar(255) NOT NULL DEFAULT '',

    13   PRIMARY KEY ( rank_id )

    14 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;

    15 

    16 CREATE TABLE {{TABLE_PREFIX}}captcha(

    17   code_id int(12) NOT NULL auto_increment,

    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 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;

    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