Mercurial > lada > lada-server
comparison db_schema/stammdaten_data_messgroesse.sql @ 1311:5549c214e816 release-2.5
remove s12 from stammdaten.deskriptor_umwelt and update stammdaten
| author | Michael Stanko <mstanko@bfs.de> |
|---|---|
| date | Thu, 09 Mar 2017 15:16:31 +0100 |
| parents | 3923b41f8783 |
| children | f012a6240d76 |
comparison
equal
deleted
inserted
replaced
| 1295:1f47e9fa10c4 | 1311:5549c214e816 |
|---|---|
| 2 | 2 |
| 3 -- | 3 -- |
| 4 -- PostgreSQL database dump | 4 -- PostgreSQL database dump |
| 5 -- | 5 -- |
| 6 | 6 |
| 7 -- Dumped from database version 9.5.1 | 7 -- Dumped from database version 9.6.2 |
| 8 -- Dumped by pg_dump version 9.5.0 | 8 -- Dumped by pg_dump version 9.6.2 |
| 9 | |
| 10 -- Started on 2016-03-31 11:38:13 | |
| 11 | 9 |
| 12 SET statement_timeout = 0; | 10 SET statement_timeout = 0; |
| 13 SET lock_timeout = 0; | 11 SET lock_timeout = 0; |
| 12 SET idle_in_transaction_session_timeout = 0; | |
| 14 SET client_encoding = 'UTF8'; | 13 SET client_encoding = 'UTF8'; |
| 15 SET standard_conforming_strings = on; | 14 SET standard_conforming_strings = on; |
| 16 SET check_function_bodies = false; | 15 SET check_function_bodies = false; |
| 17 SET client_min_messages = warning; | 16 SET client_min_messages = warning; |
| 17 SET row_security = off; | |
| 18 | 18 |
| 19 SET search_path = stammdaten, pg_catalog; | 19 SET search_path = stammdaten, pg_catalog; |
| 20 | 20 |
| 21 -- | 21 -- |
| 22 -- TOC entry 4695 (class 0 OID 535754) | 22 -- Data for Name: messgroesse; Type: TABLE DATA; Schema: stammdaten; Owner: postgres |
| 23 -- Dependencies: 260 | |
| 24 -- Data for Name: messgroesse; Type: TABLE DATA; Schema: stammdaten; Owner: lada | |
| 25 -- | 23 -- |
| 26 | 24 |
| 27 COPY messgroesse (id, beschreibung, messgroesse, default_farbe, idf_nuklid_key, ist_leitnuklid, eudf_nuklid_id, kennung_bvl) FROM stdin; | 25 COPY messgroesse (id, beschreibung, messgroesse, default_farbe, idf_nuklid_key, ist_leitnuklid, eudf_nuklid_id, kennung_bvl) FROM stdin; |
| 28 56 Mangan Mn 54 175175075 Mn54 f 50 1925054 | 26 56 Mangan Mn 54 175175075 Mn54 f 50 1925054 |
| 29 57 Mangan Mn 56 \N Mn56 f \N \N | 27 57 Mangan Mn 56 \N Mn56 f \N \N |
| 906 608 Iridium Ir 191m \N Ir191m f \N \N | 904 608 Iridium Ir 191m \N Ir191m f \N \N |
| 907 606 Iridium Ir 190m1 \N Ir190m f \N \N | 905 606 Iridium Ir 190m1 \N Ir190m f \N \N |
| 908 1039 Gesamt-Radon-Aktivität Rn-Gesamt \N \N f \N \N | 906 1039 Gesamt-Radon-Aktivität Rn-Gesamt \N \N f \N \N |
| 909 1040 Nullmessung (QS bei LIMS) Nullmessung \N \N f \N \N | 907 1040 Nullmessung (QS bei LIMS) Nullmessung \N \N f \N \N |
| 910 1041 Temperatur Temperatur \N \N f \N \N | 908 1041 Temperatur Temperatur \N \N f \N \N |
| 909 890 Iod, elementar und organisch gebunden I 131GO \N I131GO f \N \N | |
| 910 891 Iod, elementar und organisch gebunden I 133GO \N I133GO f \N \N | |
| 911 892 Iod, elementar und organisch gebunden I 135GO \N I135GO f \N \N | |
| 911 \. | 912 \. |
| 913 | |
| 914 | |
| 915 -- | |
| 916 -- Name: messgroesse_id_seq; Type: SEQUENCE SET; Schema: stammdaten; Owner: postgres | |
| 917 -- | |
| 918 | |
| 919 SELECT pg_catalog.setval('messgroesse_id_seq', 1041, true); | |
| 920 | |
| 921 | |
| 922 -- | |
| 923 -- PostgreSQL database dump complete | |
| 924 -- | |
| 925 |