install/schemas/upgrade/1.1.1-1.1.2-mysql.sql
changeset 423 990ccfb20120
parent 422 ca37fcd08c4e
child 430 ec90736b9cb9
equal deleted inserted replaced
421:dbae4d327846 423:990ccfb20120
     4 ALTER TABLE {{TABLE_PREFIX}}logs ADD COLUMN log_id int(15) NOT NULL auto_increment, ADD PRIMARY KEY ( log_id );
     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;
     5 ALTER TABLE {{TABLE_PREFIX}}logs ADD COLUMN is_draft tinyint(1) NOT NULL DEFAULT 0;
     6 
     6 
     7 ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_rank int(12) UNSIGNED NOT NULL DEFAULT 1,
     7 ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_rank int(12) UNSIGNED NOT NULL DEFAULT 1,
     8                                   ADD COLUMN user_timezone int(12) UNSIGNED NOT NULL DEFAULT 0;
     8                                   ADD COLUMN user_timezone int(12) UNSIGNED NOT NULL DEFAULT 0;
       
     9 
       
    10 ALTER TABLE {{TABLE_PREFIX}}tags CHANGE user user_id mediumint(8) NOT NULL DEFAULT 1;
     9 
    11 
    10 CREATE TABLE {{TABLE_PREFIX}}ranks(
    12 CREATE TABLE {{TABLE_PREFIX}}ranks(
    11   rank_id int(12) NOT NULL auto_increment,
    13   rank_id int(12) NOT NULL auto_increment,
    12   rank_title varchar(63) NOT NULL DEFAULT '',
    14   rank_title varchar(63) NOT NULL DEFAULT '',
    13   rank_style varchar(255) NOT NULL DEFAULT '',
    15   rank_style varchar(255) NOT NULL DEFAULT '',