install/schemas/upgrade/1.1.1-1.1.2-mysql.sql
author Dan
Sat, 01 Mar 2008 23:02:05 -0500
changeset 471 7906fb190fc1
parent 430 ec90736b9cb9
child 494 6c78cc456091
permissions -rw-r--r--
Implemented all security features on theme disabling and ACLs; added clean_key mode to login API to clean unused encryption keys
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
410
9db359d6e60c Added upgrade schema files for 1.1.1 -> current (1.1.2-dev)
Dan
parents:
diff changeset
     1
-- Enano CMS
9db359d6e60c Added upgrade schema files for 1.1.1 -> current (1.1.2-dev)
Dan
parents:
diff changeset
     2
-- Upgrade schema - Enano 1.1.1 - 1.1.2
9db359d6e60c Added upgrade schema files for 1.1.1 -> current (1.1.2-dev)
Dan
parents:
diff changeset
     3
9db359d6e60c Added upgrade schema files for 1.1.1 -> current (1.1.2-dev)
Dan
parents:
diff changeset
     4
ALTER TABLE {{TABLE_PREFIX}}logs ADD COLUMN log_id int(15) NOT NULL auto_increment, ADD PRIMARY KEY ( log_id );
413
6607cd646d6d Added autosave functionality and resurrected the old toolbar code that was added about a year ago but never uesd.
Dan
parents: 410
diff changeset
     5
ALTER TABLE {{TABLE_PREFIX}}logs ADD COLUMN is_draft tinyint(1) NOT NULL DEFAULT 0;
410
9db359d6e60c Added upgrade schema files for 1.1.1 -> current (1.1.2-dev)
Dan
parents:
diff changeset
     6
9db359d6e60c Added upgrade schema files for 1.1.1 -> current (1.1.2-dev)
Dan
parents:
diff changeset
     7
ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_rank int(12) UNSIGNED NOT NULL DEFAULT 1,
9db359d6e60c Added upgrade schema files for 1.1.1 -> current (1.1.2-dev)
Dan
parents:
diff changeset
     8
                                  ADD COLUMN user_timezone int(12) UNSIGNED NOT NULL DEFAULT 0;
9db359d6e60c Added upgrade schema files for 1.1.1 -> current (1.1.2-dev)
Dan
parents:
diff changeset
     9
422
ca37fcd08c4e Fixed user -> user_id transition for enano_tags table
Dan
parents: 413
diff changeset
    10
ALTER TABLE {{TABLE_PREFIX}}tags CHANGE user user_id mediumint(8) NOT NULL DEFAULT 1;
430
ec90736b9cb9 Started (but disabled) work on the new theme manager, 1.1.2 is being released with this thing halfway done.
Dan
parents: 422
diff changeset
    11
ALTER TABLE {{TABLE_PREFIX}}themes
ec90736b9cb9 Started (but disabled) work on the new theme manager, 1.1.2 is being released with this thing halfway done.
Dan
parents: 422
diff changeset
    12
  ADD COLUMN group_list text DEFAULT NULL,
ec90736b9cb9 Started (but disabled) work on the new theme manager, 1.1.2 is being released with this thing halfway done.
Dan
parents: 422
diff changeset
    13
  ADD COLUMN group_policy ENUM('allow', 'deny') NOT NULL DEFAULT 'deny';
422
ca37fcd08c4e Fixed user -> user_id transition for enano_tags table
Dan
parents: 413
diff changeset
    14
410
9db359d6e60c Added upgrade schema files for 1.1.1 -> current (1.1.2-dev)
Dan
parents:
diff changeset
    15
CREATE TABLE {{TABLE_PREFIX}}ranks(
9db359d6e60c Added upgrade schema files for 1.1.1 -> current (1.1.2-dev)
Dan
parents:
diff changeset
    16
  rank_id int(12) NOT NULL auto_increment,
9db359d6e60c Added upgrade schema files for 1.1.1 -> current (1.1.2-dev)
Dan
parents:
diff changeset
    17
  rank_title varchar(63) NOT NULL DEFAULT '',
9db359d6e60c Added upgrade schema files for 1.1.1 -> current (1.1.2-dev)
Dan
parents:
diff changeset
    18
  rank_style varchar(255) NOT NULL DEFAULT '',
9db359d6e60c Added upgrade schema files for 1.1.1 -> current (1.1.2-dev)
Dan
parents:
diff changeset
    19
  PRIMARY KEY ( rank_id )
9db359d6e60c Added upgrade schema files for 1.1.1 -> current (1.1.2-dev)
Dan
parents:
diff changeset
    20
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
9db359d6e60c Added upgrade schema files for 1.1.1 -> current (1.1.2-dev)
Dan
parents:
diff changeset
    21
9db359d6e60c Added upgrade schema files for 1.1.1 -> current (1.1.2-dev)
Dan
parents:
diff changeset
    22
CREATE TABLE {{TABLE_PREFIX}}captcha(
9db359d6e60c Added upgrade schema files for 1.1.1 -> current (1.1.2-dev)
Dan
parents:
diff changeset
    23
  code_id int(12) NOT NULL auto_increment,
9db359d6e60c Added upgrade schema files for 1.1.1 -> current (1.1.2-dev)
Dan
parents:
diff changeset
    24
  session_id varchar(40) NOT NULL DEFAULT '',
9db359d6e60c Added upgrade schema files for 1.1.1 -> current (1.1.2-dev)
Dan
parents:
diff changeset
    25
  code varchar(64) NOT NULL DEFAULT '',
9db359d6e60c Added upgrade schema files for 1.1.1 -> current (1.1.2-dev)
Dan
parents:
diff changeset
    26
  session_data text,
9db359d6e60c Added upgrade schema files for 1.1.1 -> current (1.1.2-dev)
Dan
parents:
diff changeset
    27
  source_ip varchar(39),
9db359d6e60c Added upgrade schema files for 1.1.1 -> current (1.1.2-dev)
Dan
parents:
diff changeset
    28
  user_id int(12),
9db359d6e60c Added upgrade schema files for 1.1.1 -> current (1.1.2-dev)
Dan
parents:
diff changeset
    29
  PRIMARY KEY ( code_id )
9db359d6e60c Added upgrade schema files for 1.1.1 -> current (1.1.2-dev)
Dan
parents:
diff changeset
    30
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
9db359d6e60c Added upgrade schema files for 1.1.1 -> current (1.1.2-dev)
Dan
parents:
diff changeset
    31
9db359d6e60c Added upgrade schema files for 1.1.1 -> current (1.1.2-dev)
Dan
parents:
diff changeset
    32
INSERT INTO {{TABLE_PREFIX}}ranks(rank_id, rank_title, rank_style) VALUES
9db359d6e60c Added upgrade schema files for 1.1.1 -> current (1.1.2-dev)
Dan
parents:
diff changeset
    33
  (1, 'user_rank_member', ''),
9db359d6e60c Added upgrade schema files for 1.1.1 -> current (1.1.2-dev)
Dan
parents:
diff changeset
    34
  (2, 'user_rank_mod', 'font-weight: bold; color: #00AA00;'),
9db359d6e60c Added upgrade schema files for 1.1.1 -> current (1.1.2-dev)
Dan
parents:
diff changeset
    35
  (3, 'user_rank_admin', 'font-weight: bold; color: #AA0000;');
9db359d6e60c Added upgrade schema files for 1.1.1 -> current (1.1.2-dev)
Dan
parents:
diff changeset
    36