equal
deleted
inserted
replaced
1 -- Enano CMS |
1 -- Enano CMS |
2 -- Upgrade schema - Enano 1.1.1 - 1.1.2 |
2 -- Upgrade schema - Enano 1.1.1 - 1.1.2 |
3 |
3 |
4 ALTER TABLE {{TABLE_PREFIX}}logs ADD COLUMN log_id SERIAL, ADD PRIMARY KEY ( log_id ); |
4 ALTER TABLE {{TABLE_PREFIX}}logs ADD COLUMN log_id SERIAL, ADD PRIMARY KEY ( log_id ); |
|
5 ALTER TABLE {{TABLE_PREFIX}}logs ADD COLUMN is_draft smallint NOT NULL DEFAULT 0; |
5 |
6 |
6 ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_rank int NOT NULL DEFAULT 1, |
7 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 ADD COLUMN user_timezone int NOT NULL DEFAULT 0; |
8 |
9 |
9 CREATE TABLE {{TABLE_PREFIX}}ranks( |
10 CREATE TABLE {{TABLE_PREFIX}}ranks( |