| 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 | -- | |
