Mercurial > lada > lada-server
comparison db_schema/stammdaten_data_netzbetreiber.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 4703 (class 0 OID 535781) | |
| 23 -- Dependencies: 269 | |
| 24 -- Data for Name: netz_betreiber; Type: TABLE DATA; Schema: stammdaten; Owner: lada | |
| 25 -- | |
| 26 | |
| 27 COPY netz_betreiber (id, netzbetreiber, idf_netzbetreiber, is_bmn, mailverteiler, aktiv) FROM stdin; | |
| 28 X ausländ. Messnetze \N t X t | |
| 29 PA Park R t PA t | |
| 30 A BfS (Spuren) A t A t | |
| 31 B vTI \N t B t | |
| 32 D BfS/ZdB D t D t | |
| 33 E BfE \N t E t | |
| 34 F FhG \N t F f | |
| 35 G BfG \N t G t | |
| 36 H BSH \N t H t | |
| 37 I BfS (LSt. AB) \N t I t | |
| 38 L BfS (LSt. TW ...) \N t L t | |
| 39 M BMUB \N t M t | |
| 40 N MRI \N t N t | |
| 41 S Sonstige \N t S t | |
| 42 T PTB \N t T t | |
| 43 U BfS (ABI) U t U t | |
| 44 W DWD W t W t | |
| 45 Z BfS (ODL) Z t Z t | |
| 46 01 Schleswig-Holstein a f 01 t | |
| 47 02 Hamburg b f 02 t | |
| 48 03 Niedersachsen c f 03 t | |
| 49 04 Bremen d f 04 t | |
| 50 05 Nordrhein-Westfalen e f 05 t | |
| 51 06 Hessen f f 06 t | |
| 52 07 Rheinland-Pfalz g f 07 t | |
| 53 08 Baden-Württemberg h f 08 t | |
| 54 09 Bayern i f 09 t | |
| 55 10 Saarland j f 10 t | |
| 56 11 Berlin k f 11 t | |
| 57 12 Brandenburg l f 12 t | |
| 58 13 Mecklenburg-Vorpommern m f 13 t | |
| 59 14 Sachsen n f 14 t | |
| 60 15 Sachsen-Anhalt o f 15 t | |
| 61 16 Thüringen p f 16 t | |
| 62 18 Endlager (Bundesaufsicht) r f 18 t | |
| 63 19 ZdB-Testnetz s f 19 t | |
| 64 17 Bundeswehr q f 17 t | |
| 65 \. |