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 \.
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)