Mercurial > lada > lada-server
view db_schema/stammdaten_data_auth_lst_umw.sql @ 1287:3383ca19f7a5
Fixed query to find ort by staat.
author | Raimund Renkert <raimund.renkert@intevation.de> |
---|---|
date | Wed, 08 Feb 2017 12:01:07 +0100 |
parents | 3923b41f8783 |
children |
line wrap: on
line source
\set ON_ERROR_STOP on -- -- PostgreSQL database dump -- -- Dumped from database version 9.5.1 -- Dumped by pg_dump version 9.5.0 -- Started on 2016-03-31 11:38:13 SET statement_timeout = 0; SET lock_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SET check_function_bodies = false; SET client_min_messages = warning; SET search_path = stammdaten, pg_catalog; -- -- TOC entry 4672 (class 0 OID 535684) -- Dependencies: 235 -- Data for Name: auth_lst_umw; Type: TABLE DATA; Schema: stammdaten; Owner: lada -- COPY auth_lst_umw (id, mst_id, umw_id) FROM stdin; 1 20050 F11 2 20050 F21 3 20050 I11 4 20050 I13 5 20050 I14 6 20050 N11 7 20050 N14 8 20050 N15 9 20050 N2B 10 20050 N3Z 11 20050 N5 12 20050 N8 13 20050 N96 14 20050 N97 15 20050 N9G 16 20050 N9H 17 20050 N9J 18 20050 N9N 19 20050 N2Y 20 20050 N43 21 20050 N53 22 20050 N54 23 20050 N56 24 20050 N95 25 20050 N9D 26 20050 N9I 27 20050 NZ 28 20050 F5 29 20050 F7 30 20050 N2 31 20050 N24 32 20050 N2A 33 20050 N2Z 34 20050 N52 35 20050 N83 36 20050 N87 37 20050 N91 38 20050 N93 39 20050 B36 40 20050 F41 41 20050 F5Z 42 20050 N12 43 20050 N13 44 20050 N21 45 20050 N22 46 20050 N27 47 20050 N29 48 20050 N4 49 20050 N42 50 20050 N44 51 20050 N46 52 20050 N55 53 20050 N94 54 20050 N9B 55 20050 B31 56 20050 B32 57 20050 B33 58 20050 B35 59 20050 F31 60 20050 F6 61 20050 F61 62 20050 F62 63 20050 I15 64 20050 N1 65 20050 N25 66 20050 N28 67 20050 N31 68 20050 N51 69 20050 N9A 70 20050 B34 71 20050 F12 72 20050 N23 73 20050 N2C 74 20050 N45 75 20050 N5Z 76 20050 N82 77 20050 N85 78 20050 N92 79 20050 N9C 80 20050 N9E 81 20050 N9F 82 20050 NZ1 83 20050 NZ2 84 20050 NZZ 85 20050 I12 86 20050 N3 87 20050 N41 88 20050 N4Z 89 20050 N86 90 20050 N98 91 20050 N9K 92 20050 N9M 93 20050 F51 94 20050 F52 95 20050 F63 96 20050 F71 97 20050 N26 98 20050 N81 99 20050 N84 100 20050 N99 101 20050 N9L 102 20040 N64 103 20040 N9P 104 20040 N61 105 20040 N9R 106 20040 N65 107 20040 N6 108 20040 N9O 109 20040 N62 110 20040 N63 111 20040 N9Q 112 20020 G23 113 20020 G13 114 20020 G22 115 20020 G11 116 20020 G12 117 20020 G21 118 20110 I21 119 20110 I32 120 20110 Z33 121 20110 I31 122 20110 Z35 123 20110 I22 124 20110 Z31 125 20110 Z34 126 20110 Z32 127 20090 B12 128 20090 B22 129 20090 B11 130 20090 B21 131 20090 L12 132 20090 L22 133 20090 L31 134 20090 L53 135 20090 L11 136 20090 L21 137 20090 L41 138 20090 L43 139 20090 L51 140 20090 L52 141 20060 A13 142 20060 A31 143 20060 G41 144 20060 G5 145 20060 A41 146 20060 N73 147 20060 N71 148 20060 N72 149 20060 A51 150 20060 A53 151 20060 A21 152 20060 A22 153 20060 A23 154 20060 A24 155 20060 G51 156 20060 GZ1 157 20060 G52 158 20060 N7 159 20060 A52 160 20060 G53 161 20060 A11 162 20060 A12 163 20030 G32 164 20030 G31 165 20030 G33 166 20010 L41 167 20010 L54 168 20010 L43 169 20010 L51 170 20010 L53 171 20010 M 172 20010 L31 173 20010 L52 174 20120 L63 175 20120 L42 176 20120 L62 177 20120 L61 \.