Mercurial > lada > lada-server
comparison db_schema/stammdaten_init_sequences.sql @ 1191:3923b41f8783
reorganize db setup
| author | Michael Stanko <mstanko@bfs.de> |
|---|---|
| date | Fri, 25 Nov 2016 22:25:13 +0100 |
| parents | |
| children | 4c6f8984ff03 |
comparison
equal
deleted
inserted
replaced
| 1190:69865fa2292f | 1191:3923b41f8783 |
|---|---|
| 1 SELECT pg_catalog.setval('auth_id_seq', (SELECT max(id) FROM stammdaten.auth), true); | |
| 2 | |
| 3 SELECT pg_catalog.setval('auth_lst_umw_id_seq', (SELECT max(id) FROM auth_lst_umw) , true); | |
| 4 | |
| 5 SELECT pg_catalog.setval('datenbasis_id_seq', (SELECT max(id) FROM datenbasis), true); | |
| 6 | |
| 7 SELECT pg_catalog.setval('datensatz_erzeuger_id_seq', (SELECT max(id) FROM datensatz_erzeuger), true); | |
| 8 | |
| 9 SELECT pg_catalog.setval('deskriptor_umwelt_id_seq', (SELECT max(id) FROM deskriptor_umwelt), true); | |
| 10 | |
| 11 SELECT pg_catalog.setval('deskriptoren_id_seq', (SELECT max(id) FROM deskriptoren), true); | |
| 12 | |
| 13 SELECT pg_catalog.setval('favorite_id_seq', 1, false); | |
| 14 | |
| 15 SELECT pg_catalog.setval('filter_id_seq', (SELECT max(id) FROM filter), true); | |
| 16 | |
| 17 SELECT pg_catalog.setval('filter_value_id_seq', 1, false); | |
| 18 | |
| 19 SELECT pg_catalog.setval('koordinaten_art_id_seq', (SELECT max(id) FROM koordinaten_art), true); | |
| 20 | |
| 21 SELECT pg_catalog.setval('kta_id_seq', (SELECT max(id) FROM kta), true); | |
| 22 | |
| 23 SELECT pg_catalog.setval('lada_user_id_seq', 1, false); | |
| 24 | |
| 25 SELECT pg_catalog.setval('mess_einheit_id_seq', (SELECT max(id) FROM mess_einheit), true); | |
| 26 | |
| 27 SELECT pg_catalog.setval('messgroesse_id_seq', (SELECT max(id) FROM messgroesse), true); | |
| 28 | |
| 29 SELECT pg_catalog.setval('messgroessen_gruppe_id_seq', (SELECT max(id) FROM messgreossen_gruppe), true); | |
| 30 | |
| 31 SELECT pg_catalog.setval('messprogramm_kategorie_id_seq', (SELECT max(id) FROM messprogramm_kategorie), true); | |
| 32 | |
| 33 SELECT pg_catalog.setval('ort_id_seq', (SELECT max(id) FROM ort), true); | |
| 34 | |
| 35 SELECT pg_catalog.setval('pflicht_messgroesse_id_seq', (SELECT max(id) FROM pflicht_messgroesse), true); | |
| 36 | |
| 37 SELECT pg_catalog.setval('probenart_id_seq', (SELECT max(id) FROM probenart), true); | |
| 38 | |
| 39 SELECT pg_catalog.setval('probenehmer_id_seq', (SELECT max(id) FROM probenehmer), true); | |
| 40 | |
| 41 SELECT pg_catalog.setval('query_id_seq', SELECT max(id) FROM query), true); | |
| 42 | |
| 43 SELECT pg_catalog.setval('result_id_seq', (SELECT max(id) FROM result), true); | |
| 44 | |
| 45 SELECT pg_catalog.setval('staat_id_seq', (SELECT max(id) FROM staat), true); |