Mercurial > lada > lada-server
comparison db_schema/stammdaten_schema.sql @ 1023:5fdc6feabedb schema-update
Updated values.
author | Raimund Renkert <raimund.renkert@intevation.de> |
---|---|
date | Mon, 04 Jul 2016 14:23:50 +0200 |
parents | 042437ce8f51 |
children | 8e5dcf7156c5 |
comparison
equal
deleted
inserted
replaced
1022:042437ce8f51 | 1023:5fdc6feabedb |
---|---|
283 INSERT INTO query_type VALUES(0, 'probe'); | 283 INSERT INTO query_type VALUES(0, 'probe'); |
284 INSERT INTO query_type VALUES(1, 'messung'); | 284 INSERT INTO query_type VALUES(1, 'messung'); |
285 INSERT INTO query_type VALUES(2, 'messprogramm'); | 285 INSERT INTO query_type VALUES(2, 'messprogramm'); |
286 INSERT INTO query_type VALUES(3, 'ort'); | 286 INSERT INTO query_type VALUES(3, 'ort'); |
287 INSERT INTO query_type VALUES(4, 'probenehmer'); | 287 INSERT INTO query_type VALUES(4, 'probenehmer'); |
288 INSERT INTO query_type VALUES(5, 'datensatz_erzeuger'); | 288 INSERT INTO query_type VALUES(5, 'datensatzerzeuger'); |
289 INSERT INTO query_type VALUES(6, 'messprogramm_kategorie'); | 289 INSERT INTO query_type VALUES(6, 'messprogrammkategorie'); |
290 | 290 |
291 | 291 |
292 CREATE TABLE favorite ( | 292 CREATE TABLE favorite ( |
293 id serial PRIMARY KEY, | 293 id serial PRIMARY KEY, |
294 user_id integer NOT NULL REFERENCES lada_user, | 294 user_id integer NOT NULL REFERENCES lada_user, |
309 CREATE TABLE filter_type ( | 309 CREATE TABLE filter_type ( |
310 id serial PRIMARY KEY, | 310 id serial PRIMARY KEY, |
311 type character varying(10) NOT NULL | 311 type character varying(10) NOT NULL |
312 ) | 312 ) |
313 INSERT INTO filter_type VALUES(0, 'text'); | 313 INSERT INTO filter_type VALUES(0, 'text'); |
314 INSERT INTO filter_type VALUES(0, 'listmst'); | 314 INSERT INTO filter_type VALUES(1, 'listmst'); |
315 INSERT INTO filter_type VALUES(0, 'listnetz'); | 315 INSERT INTO filter_type VALUES(2, 'listnetz'); |
316 INSERT INTO filter_type VALUES(0, 'listumw'); | 316 INSERT INTO filter_type VALUES(3, 'listumw'); |
317 INSERT INTO filter_type VALUES(0, 'liststatus'); | 317 INSERT INTO filter_type VALUES(4, 'liststatus'); |
318 | 318 |
319 | 319 |
320 CREATE TABLE filter_value ( | 320 CREATE TABLE filter_value ( |
321 id serial PRIMARY KEY, | 321 id serial PRIMARY KEY, |
322 user_id integer NOT NULL REFERENCES lada_user, | 322 user_id integer NOT NULL REFERENCES lada_user, |