equal
deleted
inserted
replaced
8 private_key text, |
8 private_key text, |
9 public_key text, |
9 public_key text, |
10 PRIMARY KEY ( key_id ) |
10 PRIMARY KEY ( key_id ) |
11 ); |
11 ); |
12 |
12 |
13 ALTER TABLE {{TABLE_PREFIX}}session_keys MODIFY COLUMN source_ip varchar(39) NOT NULL DEFAULT '127.0.0.1'; |
|
14 ALTER TABLE {{TABLE_PREFIX}}themes DROP group_policy, ADD COLUMN group_policy varchar(9) NOT NULL DEFAULT 'allow_all', ADD CHECK ( group_policy IN ('allow_all', 'whitelist', 'blacklist') ); |
13 ALTER TABLE {{TABLE_PREFIX}}themes DROP group_policy, ADD COLUMN group_policy varchar(9) NOT NULL DEFAULT 'allow_all', ADD CHECK ( group_policy IN ('allow_all', 'whitelist', 'blacklist') ); |
15 |
14 |
|
15 ALTER TABLE {{TABLE_PREFIX}}session_keys ALTER COLUMN source_ip TYPE varchar(39), |
|
16 ADD CHECK ( source_ip IS NOT NULL ), |
|
17 ALTER COLUMN source_ip SET DEFAULT '127.0.0.1'; |
|
18 |