410
+ − 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 );
413
6607cd646d6d
Added autosave functionality and resurrected the old toolbar code that was added about a year ago but never uesd.
Dan
diff
changeset
+ − 5
ALTER TABLE {{TABLE_PREFIX}}logs ADD COLUMN is_draft tinyint(1) NOT NULL DEFAULT 0;
410
+ − 6
494
+ − 7
ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_rank int(12) UNSIGNED NOT NULL DEFAULT 1;
1159
a1cca4472a58
Set up more sensible defaults (UTC, DST off) for timezone preferences. Also modified enano_date() to properly include GMT offsets when timezone characters are used. Fixes issue 4.
Dan
diff
changeset
+ − 8
ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_timezone int(12) UNSIGNED NOT NULL DEFAULT 1440;
410
+ − 9
788
ac081c826715
When will that stupid user -> user_id bug stop REARING ITS UGLY HEAD. DIE! DIE! DIE! DIE! DIE!
Dan
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
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
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
diff
changeset
+ − 13
ADD COLUMN group_policy ENUM('allow', 'deny') NOT NULL DEFAULT 'deny';
422
+ − 14
410
+ − 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