Mercurial > lada > lada-server
comparison db_schema/stammdaten_data_auth.sql @ 1191:3923b41f8783
reorganize db setup
| author | Michael Stanko <mstanko@bfs.de> |
|---|---|
| date | Fri, 25 Nov 2016 22:25:13 +0100 |
| parents | |
| children |
comparison
equal
deleted
inserted
replaced
| 1190:69865fa2292f | 1191:3923b41f8783 |
|---|---|
| 1 \set ON_ERROR_STOP on | |
| 2 | |
| 3 -- | |
| 4 -- PostgreSQL database dump | |
| 5 -- | |
| 6 | |
| 7 -- Dumped from database version 9.5.1 | |
| 8 -- Dumped by pg_dump version 9.5.0 | |
| 9 | |
| 10 -- Started on 2016-03-31 11:38:13 | |
| 11 | |
| 12 SET statement_timeout = 0; | |
| 13 SET lock_timeout = 0; | |
| 14 SET client_encoding = 'UTF8'; | |
| 15 SET standard_conforming_strings = on; | |
| 16 SET check_function_bodies = false; | |
| 17 SET client_min_messages = warning; | |
| 18 | |
| 19 SET search_path = stammdaten, pg_catalog; | |
| 20 | |
| 21 -- | |
| 22 -- TOC entry 4670 (class 0 OID 535676) | |
| 23 -- Dependencies: 232 | |
| 24 -- Data for Name: auth; Type: TABLE DATA; Schema: stammdaten; Owner: lada | |
| 25 -- | |
| 26 | |
| 27 COPY auth (id, ldap_group, netzbetreiber_id, mst_id, labor_mst_id, funktion_id) FROM stdin; | |
| 28 1 Imis_world \N \N \N 0 | |
| 29 2 mst_06010 06 06010 06010 0 | |
| 30 3 mst_06060 06 06060 06060 0 | |
| 31 4 mst_11010 11 11010 11010 0 | |
| 32 5 mst_12010 12 12010 12010 0 | |
| 33 6 mst_12020 12 12020 12020 0 | |
| 34 7 mst_06_status 06 06010 06010 1 | |
| 35 8 mst_06-status 06 06060 06060 1 | |
| 36 9 mst_11010_status 11 11010 11010 1 | |
| 37 10 mst_12010_status 12 12010 12010 1 | |
| 38 11 mst_12020_status 12 12020 12020 1 | |
| 39 16 land_06_status 06 06112 \N 2 | |
| 40 17 land_11_status 11 11042 \N 2 | |
| 41 21 land_12_status 12 12032 \N 2 | |
| 42 22 lst_kiel \N 20050 \N 3 | |
| 43 23 lst_fisch \N 20040 \N 3 | |
| 44 24 land_06_stamm 06 \N \N 4 | |
| 45 \. |