|
329
|
1 /* roster access model was badly used, we rename it to publisher-roster */ |
|
|
2 |
|
|
3 ALTER TABLE nodes DROP CONSTRAINT nodes_access_model_check; |
|
|
4 UPDATE nodes SET access_model = 'publisher-roster' WHERE access_model = 'roster'; |
|
|
5 ALTER TABLE nodes ADD CHECK (access_model IN ('open', 'publisher-roster', 'whitelist', 'publish-only', 'self-publisher')); |
|
|
6 |
|
|
7 ALTER TABLE items DROP CONSTRAINT items_access_model_check; |
|
|
8 UPDATE items SET access_model = 'publisher-roster' WHERE access_model = 'roster'; |
|
|
9 ALTER TABLE items ADD CHECK (access_model IN ('open', 'publisher-roster', 'whitelist')); |
|
|
10 |
|
|
11 ALTER TABLE affiliations DROP CONSTRAINT affiliations_affiliation_check; |
|
|
12 ALTER TABLE affiliations ADD CHECK (affiliation IN ('outcast', 'member', 'publisher', 'owner')); |
|
|
13 |
|
|
14 CREATE TABLE item_jids_authorized ( |
|
|
15 item_jids_authorized_id serial PRIMARY KEY, |
|
|
16 item_id integer NOT NULL references items ON DELETE CASCADE, |
|
|
17 jid text NOT NULL, |
|
|
18 UNIQUE (item_id,jid) |
|
|
19 ); |
|
|
20 |
|
|
21 CREATE TABLE item_languages ( |
|
|
22 item_languages_id serial PRIMARY KEY, |
|
|
23 item_id integer NOT NULL references items ON DELETE CASCADE, |
|
|
24 language text NOT NULL, |
|
|
25 UNIQUE (item_id,language) |
|
|
26 ); |
|
|
27 |
|
|
28 UPDATE metadata SET value='2' WHERE key='version'; |
