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