commit | author | age
|
b127d6
|
1 |
-- Migrate database from version 2.1 to version 2.2 |
PB |
2 |
-- |
|
3 |
-- domain options |
|
4 |
-- |
|
5 |
CREATE SEQUENCE domain_option_id_seq |
|
6 |
INCREMENT BY 1 |
|
7 |
NO MAXVALUE |
|
8 |
NO MINVALUE |
|
9 |
CACHE 1; |
|
10 |
|
|
11 |
CREATE TABLE domain_option ( |
|
12 |
domain_option_id integer DEFAULT nextval(('"domain_option_id_seq"'::text)::regclass) NOT NULL, |
|
13 |
domain_option_name character varying(50) NOT NULL |
|
14 |
); |
|
15 |
|
|
16 |
ALTER TABLE ONLY domain_option |
|
17 |
ADD CONSTRAINT pk_domain_option PRIMARY KEY (domain_option_id); |
|
18 |
|
|
19 |
CREATE UNIQUE INDEX domain_option_name_idx ON domain_option USING btree ( domain_option_name ); |
|
20 |
|
|
21 |
CREATE TABLE domain__domain_option ( |
|
22 |
domain_option_id integer NOT NULL, |
|
23 |
domain_id integer NOT NULL |
|
24 |
); |
|
25 |
|
|
26 |
ALTER TABLE ONLY domain__domain_option |
|
27 |
ADD CONSTRAINT pk_domain__domain_option PRIMARY KEY (domain_option_id, domain_id); |
|
28 |
|
|
29 |
ALTER TABLE ONLY domain__domain_option |
|
30 |
ADD CONSTRAINT domain_option_id_fkey FOREIGN KEY (domain_option_id) |
|
31 |
REFERENCES domain_option(domain_option_id) DEFERRABLE; |
|
32 |
|
|
33 |
ALTER TABLE ONLY domain__domain_option |
|
34 |
ADD CONSTRAINT domain_id_fkey FOREIGN KEY (domain_id) |
|
35 |
REFERENCES domain(domain_id) DEFERRABLE; |
|
36 |
|
|
37 |
-- |
|
38 |
-- table: domain_option |
|
39 |
-- |
|
40 |
INSERT INTO domain_option (domain_option_name) |
|
41 |
VALUES ('backupmxforexternalmx'); |
|
42 |
INSERT INTO domain_option (domain_option_name) |
|
43 |
VALUES ('greylisting'); |
|
44 |
INSERT INTO domain_option (domain_option_name) |
|
45 |
VALUES ('htdocsfallback'); |
|
46 |
INSERT INTO domain_option (domain_option_name) |
|
47 |
VALUES ('includes'); |
|
48 |
INSERT INTO domain_option (domain_option_name) |
|
49 |
VALUES ('indexes'); |
|
50 |
INSERT INTO domain_option (domain_option_name) |
|
51 |
VALUES ('multiviews'); |
|
52 |
-- |
|
53 |
-- new domain options settings |
|
54 |
-- |
|
55 |
-- existing default = ON |
|
56 |
-- |
|
57 |
INSERT INTO domain__domain_option SELECT domain_option_id, domain_id |
|
58 |
FROM domain, domain_option |
|
59 |
WHERE domain_option.domain_option_name = 'greylisting' ; |
|
60 |
INSERT INTO domain__domain_option SELECT domain_option_id, domain_id |
|
61 |
FROM domain, domain_option |
|
62 |
WHERE domain_option.domain_option_name = 'htdocsfalback' ; |
|
63 |
INSERT INTO domain__domain_option SELECT domain_option_id, domain_id |
|
64 |
FROM domain, domain_option |
|
65 |
WHERE domain_option.domain_option_name = 'includes' ; |
|
66 |
INSERT INTO domain__domain_option SELECT domain_option_id, domain_id |
|
67 |
FROM domain, domain_option |
|
68 |
WHERE domain_option.domain_option_name = 'indexes' ; |
|
69 |
INSERT INTO domain__domain_option SELECT domain_option_id, domain_id |
|
70 |
FROM domain, domain_option |
|
71 |
WHERE domain_option.domain_option_name = 'multiviews' ; |
|
72 |
-- |
|
73 |
-- existing default = OFF |
|
74 |
-- |
|
75 |
DELETE FROM domain__domain_option USING domain_option |
|
76 |
WHERE domain__domain_option.domain_option_id = domain_option.domain_option_id |
|
77 |
AND domain_option.domain_option_name = 'backupmxforexternalmx' ; |
|
78 |
-- |
|
79 |
-- End of migratino to version 2.2 |
|
80 |
-- |