Mercurial > lada > lada-server
comparison db_schema/lada_messprogramm.sql @ 1319:512616ea3228 release-2.5
fix somme test data
| author | Michael Stanko <mstanko@bfs.de> |
|---|---|
| date | Thu, 23 Mar 2017 09:02:26 +0100 |
| parents | |
| children | 739ad8e78fca |
comparison
equal
deleted
inserted
replaced
| 1317:3ac30d816c9a | 1319:512616ea3228 |
|---|---|
| 1 \set ON_ERROR_STOP on | |
| 2 | |
| 3 -- | |
| 4 -- PostgreSQL database dump | |
| 5 -- | |
| 6 | |
| 7 -- Dumped from database version 9.5.2 | |
| 8 -- Dumped by pg_dump version 9.5.2 | |
| 9 | |
| 10 -- Started on 2016-05-04 09:10:49 CEST | |
| 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 = land, pg_catalog; | |
| 20 | |
| 21 -- | |
| 22 -- TOC entry 4684 (class 0 OID 1170769) | |
| 23 -- Dependencies: 286 | |
| 24 -- Data for Name: messprogramm; Type: TABLE DATA; Schema: land; Owner: postgres | |
| 25 -- | |
| 26 | |
| 27 ALTER TABLE messprogramm DISABLE TRIGGER ALL; | |
| 28 | |
| 29 COPY messprogramm (id, test, mst_id, labor_mst_id, datenbasis_id, ba_id, gem_id, media_desk, mpl_Id, umw_id, probenart_id, probenintervall, teilintervall_von, teilintervall_bis, intervall_offset, gueltig_von, gueltig_bis, probe_nehmer_id, probe_kommentar, letzte_aenderung) FROM stdin; | |
| 30 \. | |
| 31 | |
| 32 | |
| 33 ALTER TABLE messprogramm ENABLE TRIGGER ALL; | |
| 34 | |
| 35 -- | |
| 36 -- TOC entry 4701 (class 0 OID 0) | |
| 37 -- Dependencies: 285 | |
| 38 -- Name: messprogramm_id_seq; Type: SEQUENCE SET; Schema: land; Owner: postgres | |
| 39 -- | |
| 40 | |
| 41 SELECT pg_catalog.setval('messprogramm_id_seq', 1, false); | |
| 42 | |
| 43 | |
| 44 -- | |
| 45 -- TOC entry 4685 (class 0 OID 1170813) | |
| 46 -- Dependencies: 287 | |
| 47 -- Data for Name: messprogramm_mmt; Type: TABLE DATA; Schema: land; Owner: postgres | |
| 48 -- | |
| 49 | |
| 50 ALTER TABLE messprogramm_mmt DISABLE TRIGGER ALL; | |
| 51 | |
| 52 COPY messprogramm_mmt (id, messprogramm_id, mmt_id, messgroessen, letzte_aenderung) FROM stdin; | |
| 53 \. | |
| 54 | |
| 55 | |
| 56 ALTER TABLE messprogramm_mmt ENABLE TRIGGER ALL; | |
| 57 | |
| 58 -- | |
| 59 -- TOC entry 4702 (class 0 OID 0) | |
| 60 -- Dependencies: 288 | |
| 61 -- Name: messprogramm_mmt_id_seq; Type: SEQUENCE SET; Schema: land; Owner: postgres | |
| 62 -- | |
| 63 | |
| 64 SELECT pg_catalog.setval('messprogramm_mmt_id_seq', 1, false); | |
| 65 |