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, |