Mercurial > lada > lada-server

annotate db_schema/stammdaten_init_sequences.sql @ 1332:65ed13ff9945 2.6.1

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Changed authorization for Messprogramm. * Added 'readonly' flag * Only user with function '4' and the corresponding 'netzbetreiber' are allowed to edit. * User authorized to create a 'probe' are allowed to generate proben.
author Raimund Renkert <raimund.renkert@intevation.de>
date Wed, 29 Mar 2017 14:25:56 +0200
parents 4c6f8984ff03
children
rev   line source
1197
4c6f8984ff03 Fixed setup db script.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 1191
diff changeset
1 SET search_path TO stammdaten;
4c6f8984ff03 Fixed setup db script.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 1191
diff changeset
2
1191
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
3 SELECT pg_catalog.setval('auth_id_seq', (SELECT max(id) FROM stammdaten.auth), true);
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
4
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
5 SELECT pg_catalog.setval('auth_lst_umw_id_seq', (SELECT max(id) FROM auth_lst_umw) , true);
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
6
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
7 SELECT pg_catalog.setval('datenbasis_id_seq', (SELECT max(id) FROM datenbasis), true);
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
8
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
9 SELECT pg_catalog.setval('datensatz_erzeuger_id_seq', (SELECT max(id) FROM datensatz_erzeuger), true);
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
10
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
11 SELECT pg_catalog.setval('deskriptor_umwelt_id_seq', (SELECT max(id) FROM deskriptor_umwelt), true);
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
12
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
13 SELECT pg_catalog.setval('deskriptoren_id_seq', (SELECT max(id) FROM deskriptoren), true);
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
14
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
15 SELECT pg_catalog.setval('favorite_id_seq', 1, false);
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
16
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
17 SELECT pg_catalog.setval('filter_id_seq', (SELECT max(id) FROM filter), true);
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
18
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
19 SELECT pg_catalog.setval('filter_value_id_seq', 1, false);
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
20
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
21 SELECT pg_catalog.setval('koordinaten_art_id_seq', (SELECT max(id) FROM koordinaten_art), true);
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
22
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
23 SELECT pg_catalog.setval('kta_id_seq', (SELECT max(id) FROM kta), true);
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
24
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
25 SELECT pg_catalog.setval('lada_user_id_seq', 1, false);
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
26
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
27 SELECT pg_catalog.setval('mess_einheit_id_seq', (SELECT max(id) FROM mess_einheit), true);
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
28
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
29 SELECT pg_catalog.setval('messgroesse_id_seq', (SELECT max(id) FROM messgroesse), true);
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
30
1197
4c6f8984ff03 Fixed setup db script.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 1191
diff changeset
31 SELECT pg_catalog.setval('messgroessen_gruppe_id_seq', (SELECT max(id) FROM messgroessen_gruppe), true);
1191
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
32
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
33 SELECT pg_catalog.setval('messprogramm_kategorie_id_seq', (SELECT max(id) FROM messprogramm_kategorie), true);
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
34
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
35 SELECT pg_catalog.setval('ort_id_seq', (SELECT max(id) FROM ort), true);
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
36
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
37 SELECT pg_catalog.setval('pflicht_messgroesse_id_seq', (SELECT max(id) FROM pflicht_messgroesse), true);
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
38
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
39 SELECT pg_catalog.setval('probenart_id_seq', (SELECT max(id) FROM probenart), true);
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
40
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
41 SELECT pg_catalog.setval('probenehmer_id_seq', (SELECT max(id) FROM probenehmer), true);
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
42
1197
4c6f8984ff03 Fixed setup db script.
Raimund Renkert <raimund.renkert@intevation.de>
parents: 1191
diff changeset
43 SELECT pg_catalog.setval('query_id_seq', (SELECT max(id) FROM query), true);
1191
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
44
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
45 SELECT pg_catalog.setval('result_id_seq', (SELECT max(id) FROM result), true);
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
46
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
47 SELECT pg_catalog.setval('staat_id_seq', (SELECT max(id) FROM staat), true);
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)