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 SERIAL, 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 smallint NOT NULL DEFAULT 0;
410
+ − 6
494
+ − 7
ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_rank int NOT NULL DEFAULT 1;
625
+ − 8
@ALTER TABLE {{TABLE_PREFIX}}users DROP user_timezone;
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
+ − 9
ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_timezone int NOT NULL DEFAULT 1440;
494
+ − 10
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 varchar(5) NOT NULL DEFAULT 'deny',
ec90736b9cb9
Started (but disabled) work on the new theme manager, 1.1.2 is being released with this thing halfway done.
Dan
diff
changeset
+ − 14
ADD CHECK (group_policy IN ('allow', 'deny'));
410
+ − 15
+ − 16
CREATE TABLE {{TABLE_PREFIX}}ranks(
+ − 17
rank_id SERIAL,
+ − 18
rank_title varchar(63) NOT NULL DEFAULT '',
+ − 19
rank_style varchar(255) NOT NULL DEFAULT '',
+ − 20
PRIMARY KEY ( rank_id )
+ − 21
);
+ − 22
+ − 23
CREATE TABLE {{TABLE_PREFIX}}captcha(
+ − 24
code_id SERIAL,
+ − 25
session_id varchar(40) NOT NULL DEFAULT '',
+ − 26
code varchar(64) NOT NULL DEFAULT '',
+ − 27
session_data text,
+ − 28
source_ip varchar(39),
625
+ − 29
user_id int,
410
+ − 30
PRIMARY KEY ( code_id )
+ − 31
);
+ − 32
+ − 33
INSERT INTO {{TABLE_PREFIX}}ranks(rank_id, rank_title, rank_style) VALUES
+ − 34
(1, 'user_rank_member', ''),
+ − 35
(2, 'user_rank_mod', 'font-weight: bold; color: #00AA00;'),
+ − 36
(3, 'user_rank_admin', 'font-weight: bold; color: #AA0000;');
+ − 37
1151
8f0cbce6d5f3
Fixed ranks table under PostgreSQL. FIXME, only affects new installations and upgrades, if this bug is encountered in the wild we might want to look at auto-integrating a fix.
Dan
diff
changeset
+ − 38
-- For some reason this is required, it came up in my QA testing on a2hosting
8f0cbce6d5f3
Fixed ranks table under PostgreSQL. FIXME, only affects new installations and upgrades, if this bug is encountered in the wild we might want to look at auto-integrating a fix.
Dan
diff
changeset
+ − 39
SELECT NEXTVAL('{{TABLE_PREFIX}}ranks_rank_id_seq'::regclass);
8f0cbce6d5f3
Fixed ranks table under PostgreSQL. FIXME, only affects new installations and upgrades, if this bug is encountered in the wild we might want to look at auto-integrating a fix.
Dan
diff
changeset
+ − 40