| commit | author | age | ||
| 0b6bed | 1 | CREATE SEQUENCE domain_option_id_seq |
| PH | 2 | INCREMENT BY 1 |
| 3 | NO MAXVALUE | |
| 4 | NO MINVALUE | |
| 5 | CACHE 1; | |
| 6 | ||
| 7 | CREATE TABLE domain_option ( | |
| 8 | domain_option_id integer DEFAULT nextval(('"domain_option_id_seq"'::text)::regclass) NOT NULL, | |
| 9 | domain_option_name character varying(50) NOT NULL | |
| 10 | ); | |
| 11 | ||
| 85a879 | 12 | ALTER TABLE ONLY domain_option |
| PH | 13 | ADD CONSTRAINT domain_option_uniq UNIQUE (domain_option_id); |
| 14 | ||
| 01425c | 15 | CREATE UNIQUE INDEX ON domain_option ( domain_option_name ); |
| PH | 16 | |
| 0b6bed | 17 | CREATE TABLE domain__domain_option ( |
| 85a879 | 18 | domain_option_id integer NOT NULL, |
| PH | 19 | domain_id integer NOT NULL |
| 0b6bed | 20 | ); |
| PH | 21 | |
| 85a879 | 22 | CREATE UNIQUE INDEX unique_domain__domain_option ON domain__domain_option USING btree (domain_option_id, domain_id); |
| PH | 23 | |
| 0b6bed | 24 | ALTER TABLE ONLY domain__domain_option |
| PH | 25 | ADD CONSTRAINT domain_option_id_fkey FOREIGN KEY (domain_option_id) |
| 26 | REFERENCES domain_option(domain_option_id) DEFERRABLE; | |
| 27 | ||
| 28 | ALTER TABLE ONLY domain__domain_option | |
| 29 | ADD CONSTRAINT domain_id_fkey FOREIGN KEY (domain_id) | |
| 30 | REFERENCES domain(domain_id) DEFERRABLE; | |
