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 );
|
|
5 |
|
|
6 |
ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_rank int NOT NULL DEFAULT 1,
|
|
7 |
ADD COLUMN user_timezone int NOT NULL DEFAULT 0;
|
|
8 |
|
|
9 |
CREATE TABLE {{TABLE_PREFIX}}ranks(
|
|
10 |
rank_id SERIAL,
|
|
11 |
rank_title varchar(63) NOT NULL DEFAULT '',
|
|
12 |
rank_style varchar(255) NOT NULL DEFAULT '',
|
|
13 |
PRIMARY KEY ( rank_id )
|
|
14 |
);
|
|
15 |
|
|
16 |
CREATE TABLE {{TABLE_PREFIX}}captcha(
|
|
17 |
code_id SERIAL,
|
|
18 |
session_id varchar(40) NOT NULL DEFAULT '',
|
|
19 |
code varchar(64) NOT NULL DEFAULT '',
|
|
20 |
session_data text,
|
|
21 |
source_ip varchar(39),
|
|
22 |
user_id int(12),
|
|
23 |
PRIMARY KEY ( code_id )
|
|
24 |
);
|
|
25 |
|
|
26 |
INSERT INTO {{TABLE_PREFIX}}ranks(rank_id, rank_title, rank_style) VALUES
|
|
27 |
(1, 'user_rank_member', ''),
|
|
28 |
(2, 'user_rank_mod', 'font-weight: bold; color: #00AA00;'),
|
|
29 |
(3, 'user_rank_admin', 'font-weight: bold; color: #AA0000;');
|
|
30 |
|