equal
deleted
inserted
replaced
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 ALTER TABLE {{TABLE_PREFIX}}logs ADD COLUMN is_draft smallint NOT NULL DEFAULT 0; |
6 |
6 |
7 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; |
8 @ALTER TABLE {{TABLE_PREFIX}}users DROP user_timezone; |
8 @ALTER TABLE {{TABLE_PREFIX}}users DROP user_timezone; |
9 ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_timezone int NOT NULL DEFAULT 0; |
9 ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_timezone int NOT NULL DEFAULT 1440; |
10 |
10 |
11 ALTER TABLE {{TABLE_PREFIX}}themes |
11 ALTER TABLE {{TABLE_PREFIX}}themes |
12 ADD COLUMN group_list text DEFAULT NULL, |
12 ADD COLUMN group_list text DEFAULT NULL, |
13 ADD COLUMN group_policy varchar(5) NOT NULL DEFAULT 'deny', |
13 ADD COLUMN group_policy varchar(5) NOT NULL DEFAULT 'deny', |
14 ADD CHECK (group_policy IN ('allow', 'deny')); |
14 ADD CHECK (group_policy IN ('allow', 'deny')); |