# HG changeset patch # User Raimund Renkert # Date 1467635030 -7200 # Node ID 5fdc6feabedb4e9cf5f5bdfed2c4c1c96af07e94 # Parent 042437ce8f51dc1f9d251767e2f6f565cbfda31a Updated values. diff -r 042437ce8f51 -r 5fdc6feabedb db_schema/stammdaten_schema.sql --- a/db_schema/stammdaten_schema.sql Mon Jul 04 14:18:42 2016 +0200 +++ b/db_schema/stammdaten_schema.sql Mon Jul 04 14:23:50 2016 +0200 @@ -285,8 +285,8 @@ INSERT INTO query_type VALUES(2, 'messprogramm'); INSERT INTO query_type VALUES(3, 'ort'); INSERT INTO query_type VALUES(4, 'probenehmer'); -INSERT INTO query_type VALUES(5, 'datensatz_erzeuger'); -INSERT INTO query_type VALUES(6, 'messprogramm_kategorie'); +INSERT INTO query_type VALUES(5, 'datensatzerzeuger'); +INSERT INTO query_type VALUES(6, 'messprogrammkategorie'); CREATE TABLE favorite ( @@ -311,10 +311,10 @@ type character varying(10) NOT NULL ) INSERT INTO filter_type VALUES(0, 'text'); -INSERT INTO filter_type VALUES(0, 'listmst'); -INSERT INTO filter_type VALUES(0, 'listnetz'); -INSERT INTO filter_type VALUES(0, 'listumw'); -INSERT INTO filter_type VALUES(0, 'liststatus'); +INSERT INTO filter_type VALUES(1, 'listmst'); +INSERT INTO filter_type VALUES(2, 'listnetz'); +INSERT INTO filter_type VALUES(3, 'listumw'); +INSERT INTO filter_type VALUES(4, 'liststatus'); CREATE TABLE filter_value (