Mercurial > lada > lada-server
diff 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 |
line wrap: on
line diff
--- a/db_schema/stammdaten_schema.sql Fri Feb 19 14:00:17 2016 +0100 +++ b/db_schema/stammdaten_schema.sql Fri Feb 19 14:23:58 2016 +0100 @@ -272,7 +272,6 @@ CREATE TABLE filter_value ( id integer PRIMARY KEY DEFAULT nextval('filter_value_id_seq'::regclass), - query_id integer NOT NULL, user_id integer NOT NULL, filter_id integer NOT NULL, value text @@ -856,11 +855,6 @@ ALTER TABLE ONLY filter_value - ADD CONSTRAINT filter_value_query_id_fkey FOREIGN KEY (query_id) REFERENCES query(id); - - - -ALTER TABLE ONLY filter_value ADD CONSTRAINT filter_value_user_id_fkey FOREIGN KEY (user_id) REFERENCES lada_user(id);