436
|
1 |
-- Enano CMS
|
|
2 |
-- Upgrade schema: 1.1.2 - 1.1.3
|
|
3 |
|
|
4 |
-- Storing obscenely huge integers as strings since that's how php processes them.
|
|
5 |
|
|
6 |
CREATE TABLE {{TABLE_PREFIX}}diffiehellman (
|
|
7 |
key_id SERIAL,
|
|
8 |
private_key text,
|
|
9 |
public_key text,
|
|
10 |
PRIMARY KEY ( key_id )
|
|
11 |
);
|
468
|
12 |
|
|
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') );
|
|
14 |
|
624
|
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 |
|