install/schemas/upgrade/1.1.1-1.1.2-mysql.sql
changeset 1259 49db7495f6b8
parent 1258 d972b1276d95
child 1260 cd72bcd83401
--- a/install/schemas/upgrade/1.1.1-1.1.2-mysql.sql	Thu Jul 01 18:25:04 2010 -0400
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,36 +0,0 @@
--- Enano CMS
--- Upgrade schema - Enano 1.1.1 - 1.1.2
-
-ALTER TABLE {{TABLE_PREFIX}}logs ADD COLUMN log_id int(15) NOT NULL auto_increment, ADD PRIMARY KEY ( log_id );
-ALTER TABLE {{TABLE_PREFIX}}logs ADD COLUMN is_draft tinyint(1) NOT NULL DEFAULT 0;
-
-ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_rank int(12) UNSIGNED NOT NULL DEFAULT 1;
-ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_timezone int(12) UNSIGNED NOT NULL DEFAULT 1440;
-
-@ALTER TABLE {{TABLE_PREFIX}}tags CHANGE user user_id mediumint(8) NOT NULL DEFAULT 1;
-ALTER TABLE {{TABLE_PREFIX}}themes
-  ADD COLUMN group_list text DEFAULT NULL,
-  ADD COLUMN group_policy ENUM('allow', 'deny') NOT NULL DEFAULT 'deny';
-
-CREATE TABLE {{TABLE_PREFIX}}ranks(
-  rank_id int(12) NOT NULL auto_increment,
-  rank_title varchar(63) NOT NULL DEFAULT '',
-  rank_style varchar(255) NOT NULL DEFAULT '',
-  PRIMARY KEY ( rank_id )
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-CREATE TABLE {{TABLE_PREFIX}}captcha(
-  code_id int(12) NOT NULL auto_increment,
-  session_id varchar(40) NOT NULL DEFAULT '',
-  code varchar(64) NOT NULL DEFAULT '',
-  session_data text,
-  source_ip varchar(39),
-  user_id int(12),
-  PRIMARY KEY ( code_id )
-) CHARACTER SET `utf8` COLLATE `utf8_bin`;
-
-INSERT INTO {{TABLE_PREFIX}}ranks(rank_id, rank_title, rank_style) VALUES
-  (1, 'user_rank_member', ''),
-  (2, 'user_rank_mod', 'font-weight: bold; color: #00AA00;'),
-  (3, 'user_rank_admin', 'font-weight: bold; color: #AA0000;');
-