Mercurial > lada > lada-server
comparison db_schema/stammdaten_schema.sql @ 891:d4d768295068
Removed column 'query_id' from filter_value table.
| author | Raimund Renkert <raimund.renkert@intevation.de> |
|---|---|
| date | Fri, 19 Feb 2016 14:23:58 +0100 |
| parents | fa7278bd8d73 |
| children | d465094946ef |
comparison
equal
deleted
inserted
replaced
| 890:dec1e63a2ffe | 891:d4d768295068 |
|---|---|
| 270 NO MAXVALUE | 270 NO MAXVALUE |
| 271 CACHE 1; | 271 CACHE 1; |
| 272 | 272 |
| 273 CREATE TABLE filter_value ( | 273 CREATE TABLE filter_value ( |
| 274 id integer PRIMARY KEY DEFAULT nextval('filter_value_id_seq'::regclass), | 274 id integer PRIMARY KEY DEFAULT nextval('filter_value_id_seq'::regclass), |
| 275 query_id integer NOT NULL, | |
| 276 user_id integer NOT NULL, | 275 user_id integer NOT NULL, |
| 277 filter_id integer NOT NULL, | 276 filter_id integer NOT NULL, |
| 278 value text | 277 value text |
| 279 ); | 278 ); |
| 280 | 279 |
| 854 ADD CONSTRAINT filter_value_filter_id_fkey FOREIGN KEY (filter_id) REFERENCES filter(id); | 853 ADD CONSTRAINT filter_value_filter_id_fkey FOREIGN KEY (filter_id) REFERENCES filter(id); |
| 855 | 854 |
| 856 | 855 |
| 857 | 856 |
| 858 ALTER TABLE ONLY filter_value | 857 ALTER TABLE ONLY filter_value |
| 859 ADD CONSTRAINT filter_value_query_id_fkey FOREIGN KEY (query_id) REFERENCES query(id); | |
| 860 | |
| 861 | |
| 862 | |
| 863 ALTER TABLE ONLY filter_value | |
| 864 ADD CONSTRAINT filter_value_user_id_fkey FOREIGN KEY (user_id) REFERENCES lada_user(id); | 858 ADD CONSTRAINT filter_value_user_id_fkey FOREIGN KEY (user_id) REFERENCES lada_user(id); |
| 865 | 859 |
| 866 | 860 |
| 867 | 861 |
| 868 ALTER TABLE ONLY deskriptoren | 862 ALTER TABLE ONLY deskriptoren |