| 1 | -- Drop tables
|
|---|
| 2 | DROP TABLE IF EXISTS uir_adr_posta CASCADE;
|
|---|
| 3 | DROP TABLE IF EXISTS uir_adr_posta_h CASCADE;
|
|---|
| 4 | DROP TABLE IF EXISTS uir_adr_oblast CASCADE;
|
|---|
| 5 | DROP TABLE IF EXISTS uir_adr_oblast_h CASCADE;
|
|---|
| 6 | DROP TABLE IF EXISTS uir_adr_kraj CASCADE;
|
|---|
| 7 | DROP TABLE IF EXISTS uir_adr_kraj_h CASCADE;
|
|---|
| 8 | DROP TABLE IF EXISTS uir_adr_okres CASCADE;
|
|---|
| 9 | DROP TABLE IF EXISTS uir_adr_okres_h CASCADE;
|
|---|
| 10 | DROP TABLE IF EXISTS uir_adr_orp CASCADE;
|
|---|
| 11 | DROP TABLE IF EXISTS uir_adr_orp_h CASCADE;
|
|---|
| 12 | DROP TABLE IF EXISTS uir_adr_pou CASCADE;
|
|---|
| 13 | DROP TABLE IF EXISTS uir_adr_pou_h CASCADE;
|
|---|
| 14 | DROP TABLE IF EXISTS uir_adr_obec CASCADE;
|
|---|
| 15 | DROP TABLE IF EXISTS uir_adr_obec_h CASCADE;
|
|---|
| 16 | DROP TABLE IF EXISTS uir_adr_pobvod CASCADE;
|
|---|
| 17 | DROP TABLE IF EXISTS uir_adr_pobvod_h CASCADE;
|
|---|
| 18 | DROP TABLE IF EXISTS uir_adr_sobvod CASCADE;
|
|---|
| 19 | DROP TABLE IF EXISTS uir_adr_sobvod_h CASCADE;
|
|---|
| 20 | DROP TABLE IF EXISTS uir_adr_nobvod CASCADE;
|
|---|
| 21 | DROP TABLE IF EXISTS uir_adr_nobvod_h CASCADE;
|
|---|
| 22 | DROP TABLE IF EXISTS uir_adr_mcast CASCADE;
|
|---|
| 23 | DROP TABLE IF EXISTS uir_adr_mcast_h CASCADE;
|
|---|
| 24 | DROP TABLE IF EXISTS uir_adr_cobce CASCADE;
|
|---|
| 25 | DROP TABLE IF EXISTS uir_adr_cobce_h CASCADE;
|
|---|
| 26 | DROP TABLE IF EXISTS uir_adr_ulice CASCADE;
|
|---|
| 27 | DROP TABLE IF EXISTS uir_adr_ulice_h CASCADE;
|
|---|
| 28 | DROP TABLE IF EXISTS uir_adr_objekt CASCADE;
|
|---|
| 29 | DROP TABLE IF EXISTS uir_adr_objekt_h CASCADE;
|
|---|
| 30 | DROP TABLE IF EXISTS uir_adr_adresa CASCADE;
|
|---|
| 31 | DROP TABLE IF EXISTS uir_adr_adresa_h CASCADE;
|
|---|
| 32 | DROP TABLE IF EXISTS uir_adr_obec_d CASCADE;
|
|---|
| 33 | DROP TABLE IF EXISTS uir_adr_vazba CASCADE;
|
|---|
| 34 | DROP TABLE IF EXISTS uir_adr_cob_prev CASCADE;
|
|---|
| 35 | DROP TABLE IF EXISTS uir_adr_zmen_atr CASCADE;
|
|---|
| 36 | DROP TABLE IF EXISTS uir_adr_zmen_zaz CASCADE;
|
|---|
| 37 | DROP TABLE IF EXISTS uir_adr_verze CASCADE;
|
|---|
| 38 | DROP TABLE IF EXISTS uir_adr_stav_db CASCADE;
|
|---|
| 39 | -- Create tables
|
|---|
| 40 | CREATE TABLE uir_adr_posta (
|
|---|
| 41 | psc NUMERIC(5) NOT NULL,
|
|---|
| 42 | nazev VARCHAR(48) NOT NULL,
|
|---|
| 43 | zkratka VARCHAR(16) NOT NULL,
|
|---|
| 44 | stav NUMERIC(1) NOT NULL,
|
|---|
| 45 | vznik_dne DATE,
|
|---|
| 46 | vznik_info VARCHAR(254),
|
|---|
| 47 | zanik_dne DATE,
|
|---|
| 48 | zanik_info VARCHAR(254)
|
|---|
| 49 | );
|
|---|
| 50 | CREATE TABLE uir_adr_posta_h (
|
|---|
| 51 | psc NUMERIC(5) NOT NULL,
|
|---|
| 52 | plati_do DATE NOT NULL,
|
|---|
| 53 | nazev VARCHAR(48) NOT NULL,
|
|---|
| 54 | zkratka VARCHAR(16) NOT NULL,
|
|---|
| 55 | info VARCHAR(254)
|
|---|
| 56 | );
|
|---|
| 57 | CREATE TABLE uir_adr_oblast (
|
|---|
| 58 | oblast_kod NUMERIC(2) NOT NULL,
|
|---|
| 59 | nuts2 VARCHAR(4) NOT NULL,
|
|---|
| 60 | nazev VARCHAR(32) NOT NULL,
|
|---|
| 61 | zkratka VARCHAR(16) NOT NULL,
|
|---|
| 62 | stav NUMERIC(1) NOT NULL,
|
|---|
| 63 | vznik_dne DATE,
|
|---|
| 64 | vznik_info VARCHAR(254),
|
|---|
| 65 | zanik_dne DATE,
|
|---|
| 66 | zanik_info VARCHAR(254)
|
|---|
| 67 | );
|
|---|
| 68 | CREATE TABLE uir_adr_oblast_h (
|
|---|
| 69 | oblast_kod NUMERIC(2) NOT NULL,
|
|---|
| 70 | plati_do DATE NOT NULL,
|
|---|
| 71 | nuts2 VARCHAR(4) NOT NULL,
|
|---|
| 72 | nazev VARCHAR(32) NOT NULL,
|
|---|
| 73 | zkratka VARCHAR(16) NOT NULL,
|
|---|
| 74 | info VARCHAR(254)
|
|---|
| 75 | );
|
|---|
| 76 | CREATE TABLE uir_adr_kraj (
|
|---|
| 77 | kraj_kod NUMERIC(3) NOT NULL,
|
|---|
| 78 | nuts3 VARCHAR(5) NOT NULL,
|
|---|
| 79 | oblast_kod NUMERIC(2) NOT NULL,
|
|---|
| 80 | nazev VARCHAR(32) NOT NULL,
|
|---|
| 81 | zkratka VARCHAR(16) NOT NULL,
|
|---|
| 82 | stav NUMERIC(1) NOT NULL,
|
|---|
| 83 | vznik_dne DATE,
|
|---|
| 84 | vznik_info VARCHAR(254),
|
|---|
| 85 | zanik_dne DATE,
|
|---|
| 86 | zanik_info VARCHAR(254)
|
|---|
| 87 | );
|
|---|
| 88 | CREATE TABLE uir_adr_kraj_h (
|
|---|
| 89 | kraj_kod NUMERIC(3) NOT NULL,
|
|---|
| 90 | plati_do DATE NOT NULL,
|
|---|
| 91 | nuts3 VARCHAR(5) NOT NULL,
|
|---|
| 92 | oblast_kod NUMERIC(2) NOT NULL,
|
|---|
| 93 | nazev VARCHAR(32) NOT NULL,
|
|---|
| 94 | zkratka VARCHAR(16) NOT NULL,
|
|---|
| 95 | info VARCHAR(254)
|
|---|
| 96 | );
|
|---|
| 97 | CREATE TABLE uir_adr_okres (
|
|---|
| 98 | okres_kod NUMERIC(4) NOT NULL,
|
|---|
| 99 | nazev VARCHAR(32) NOT NULL,
|
|---|
| 100 | zkratka VARCHAR(16) NOT NULL,
|
|---|
| 101 | stav NUMERIC(1) NOT NULL,
|
|---|
| 102 | vznik_dne DATE,
|
|---|
| 103 | vznik_info VARCHAR(254),
|
|---|
| 104 | zanik_dne DATE,
|
|---|
| 105 | zanik_info VARCHAR(254),
|
|---|
| 106 | nuts4 VARCHAR(6) NOT NULL,
|
|---|
| 107 | kraj_kod NUMERIC(3)
|
|---|
| 108 | );
|
|---|
| 109 | CREATE TABLE uir_adr_okres_h (
|
|---|
| 110 | okres_kod NUMERIC(4) NOT NULL,
|
|---|
| 111 | plati_do DATE NOT NULL,
|
|---|
| 112 | nazev VARCHAR(32) NOT NULL,
|
|---|
| 113 | zkratka VARCHAR(16) NOT NULL,
|
|---|
| 114 | info VARCHAR(254),
|
|---|
| 115 | nuts4 VARCHAR(6) NOT NULL,
|
|---|
| 116 | kraj_kod NUMERIC(3)
|
|---|
| 117 | );
|
|---|
| 118 | CREATE TABLE uir_adr_orp (
|
|---|
| 119 | orp_kod NUMERIC(4) NOT NULL,
|
|---|
| 120 | kodorp_csu NUMERIC(4),
|
|---|
| 121 | kraj_kod NUMERIC(3) NOT NULL,
|
|---|
| 122 | nazev VARCHAR(48) NOT NULL,
|
|---|
| 123 | zkratka VARCHAR(16) NOT NULL,
|
|---|
| 124 | stav NUMERIC(1) NOT NULL,
|
|---|
| 125 | vznik_dne DATE,
|
|---|
| 126 | vznik_info VARCHAR(254),
|
|---|
| 127 | zanik_dne DATE,
|
|---|
| 128 | zanik_info VARCHAR(254)
|
|---|
| 129 | );
|
|---|
| 130 | CREATE TABLE uir_adr_orp_h (
|
|---|
| 131 | orp_kod NUMERIC(4) NOT NULL,
|
|---|
| 132 | plati_do DATE NOT NULL,
|
|---|
| 133 | kodorp_csu NUMERIC(4),
|
|---|
| 134 | kraj_kod NUMERIC(3) NOT NULL,
|
|---|
| 135 | nazev VARCHAR(48) NOT NULL,
|
|---|
| 136 | zkratka VARCHAR(16) NOT NULL,
|
|---|
| 137 | info VARCHAR(254)
|
|---|
| 138 | );
|
|---|
| 139 | CREATE TABLE uir_adr_pou (
|
|---|
| 140 | pou_kod NUMERIC(4) NOT NULL,
|
|---|
| 141 | kodpou_csu NUMERIC(5),
|
|---|
| 142 | orp_kod NUMERIC(4) NOT NULL,
|
|---|
| 143 | nazev VARCHAR(48) NOT NULL,
|
|---|
| 144 | zkratka VARCHAR(16) NOT NULL,
|
|---|
| 145 | stav NUMERIC(1) NOT NULL,
|
|---|
| 146 | vznik_dne DATE,
|
|---|
| 147 | vznik_info VARCHAR(254),
|
|---|
| 148 | zanik_dne DATE,
|
|---|
| 149 | zanik_info VARCHAR(254)
|
|---|
| 150 | );
|
|---|
| 151 | CREATE TABLE uir_adr_pou_h (
|
|---|
| 152 | pou_kod NUMERIC(4) NOT NULL,
|
|---|
| 153 | plati_do DATE NOT NULL,
|
|---|
| 154 | kodpou_csu NUMERIC(5),
|
|---|
| 155 | orp_kod NUMERIC(4) NOT NULL,
|
|---|
| 156 | nazev VARCHAR(48) NOT NULL,
|
|---|
| 157 | zkratka VARCHAR(16) NOT NULL,
|
|---|
| 158 | info VARCHAR(254)
|
|---|
| 159 | );
|
|---|
| 160 | CREATE TABLE uir_adr_obec (
|
|---|
| 161 | obec_kod NUMERIC(6) NOT NULL,
|
|---|
| 162 | okres_kod NUMERIC(4) NOT NULL,
|
|---|
| 163 | nazev VARCHAR(48) NOT NULL,
|
|---|
| 164 | zkratka VARCHAR(16) NOT NULL,
|
|---|
| 165 | stav NUMERIC(1) NOT NULL,
|
|---|
| 166 | vznik_dne DATE,
|
|---|
| 167 | vznik_info VARCHAR(254),
|
|---|
| 168 | zanik_dne DATE,
|
|---|
| 169 | zanik_info VARCHAR(254),
|
|---|
| 170 | nuts5 VARCHAR(12) NOT NULL,
|
|---|
| 171 | pou_kod NUMERIC(4)
|
|---|
| 172 | );
|
|---|
| 173 | CREATE TABLE uir_adr_obec_h (
|
|---|
| 174 | obec_kod NUMERIC(6) NOT NULL,
|
|---|
| 175 | plati_do DATE NOT NULL,
|
|---|
| 176 | okres_kod NUMERIC(4) NOT NULL,
|
|---|
| 177 | nazev VARCHAR(48) NOT NULL,
|
|---|
| 178 | zkratka VARCHAR(16) NOT NULL,
|
|---|
| 179 | info VARCHAR(254),
|
|---|
| 180 | nuts5 VARCHAR(12) NOT NULL,
|
|---|
| 181 | pou_kod NUMERIC(4)
|
|---|
| 182 | );
|
|---|
| 183 | CREATE TABLE uir_adr_pobvod (
|
|---|
| 184 | pobvod_kod NUMERIC(3) NOT NULL,
|
|---|
| 185 | obec_kod NUMERIC(6) NOT NULL,
|
|---|
| 186 | nazev VARCHAR(32) NOT NULL,
|
|---|
| 187 | zkratka VARCHAR(16) NOT NULL,
|
|---|
| 188 | stav NUMERIC(1) NOT NULL,
|
|---|
| 189 | vznik_dne DATE,
|
|---|
| 190 | vznik_info VARCHAR(254),
|
|---|
| 191 | zanik_dne DATE,
|
|---|
| 192 | zanik_info VARCHAR(254)
|
|---|
| 193 | );
|
|---|
| 194 | CREATE TABLE uir_adr_pobvod_h (
|
|---|
| 195 | pobvod_kod NUMERIC(3) NOT NULL,
|
|---|
| 196 | plati_do DATE NOT NULL,
|
|---|
| 197 | obec_kod NUMERIC(6) NOT NULL,
|
|---|
| 198 | nazev VARCHAR(32) NOT NULL,
|
|---|
| 199 | zkratka VARCHAR(16) NOT NULL,
|
|---|
| 200 | info VARCHAR(254)
|
|---|
| 201 | );
|
|---|
| 202 | CREATE TABLE uir_adr_sobvod (
|
|---|
| 203 | sobvod_kod NUMERIC(3) NOT NULL,
|
|---|
| 204 | cislo NUMERIC(2),
|
|---|
| 205 | obec_kod NUMERIC(6) NOT NULL,
|
|---|
| 206 | nazev VARCHAR(32) NOT NULL,
|
|---|
| 207 | zkratka VARCHAR(16) NOT NULL,
|
|---|
| 208 | stav NUMERIC(1) NOT NULL,
|
|---|
| 209 | vznik_dne DATE,
|
|---|
| 210 | vznik_info VARCHAR(254),
|
|---|
| 211 | zanik_dne DATE,
|
|---|
| 212 | zanik_info VARCHAR(254)
|
|---|
| 213 | );
|
|---|
| 214 | CREATE TABLE uir_adr_sobvod_h (
|
|---|
| 215 | sobvod_kod NUMERIC(3) NOT NULL,
|
|---|
| 216 | plati_do DATE NOT NULL,
|
|---|
| 217 | cislo NUMERIC(2),
|
|---|
| 218 | obec_kod NUMERIC(6) NOT NULL,
|
|---|
| 219 | nazev VARCHAR(32) NOT NULL,
|
|---|
| 220 | zkratka VARCHAR(16) NOT NULL,
|
|---|
| 221 | info VARCHAR(254)
|
|---|
| 222 | );
|
|---|
| 223 | CREATE TABLE uir_adr_nobvod (
|
|---|
| 224 | nobvod_kod NUMERIC(3) NOT NULL,
|
|---|
| 225 | nuts4 VARCHAR(6) NOT NULL,
|
|---|
| 226 | obec_kod NUMERIC(6) NOT NULL,
|
|---|
| 227 | nazev VARCHAR(32) NOT NULL,
|
|---|
| 228 | zkratka VARCHAR(16) NOT NULL,
|
|---|
| 229 | stav NUMERIC(1) NOT NULL,
|
|---|
| 230 | vznik_dne DATE,
|
|---|
| 231 | vznik_info VARCHAR(254),
|
|---|
| 232 | zanik_dne DATE,
|
|---|
| 233 | zanik_info VARCHAR(254)
|
|---|
| 234 | );
|
|---|
| 235 | CREATE TABLE uir_adr_nobvod_h (
|
|---|
| 236 | nobvod_kod NUMERIC(3) NOT NULL,
|
|---|
| 237 | plati_do DATE NOT NULL,
|
|---|
| 238 | nuts4 VARCHAR(6) NOT NULL,
|
|---|
| 239 | obec_kod NUMERIC(6) NOT NULL,
|
|---|
| 240 | nazev VARCHAR(32) NOT NULL,
|
|---|
| 241 | zkratka VARCHAR(16) NOT NULL,
|
|---|
| 242 | info VARCHAR(254)
|
|---|
| 243 | );
|
|---|
| 244 | CREATE TABLE uir_adr_mcast (
|
|---|
| 245 | mcast_kod NUMERIC(6) NOT NULL,
|
|---|
| 246 | obec_kod NUMERIC(6) NOT NULL,
|
|---|
| 247 | pobvod_kod NUMERIC(3),
|
|---|
| 248 | typ NUMERIC(1) NOT NULL,
|
|---|
| 249 | nazev VARCHAR(48) NOT NULL,
|
|---|
| 250 | zkratka VARCHAR(16) NOT NULL,
|
|---|
| 251 | stav NUMERIC(1) NOT NULL,
|
|---|
| 252 | vznik_dne DATE,
|
|---|
| 253 | vznik_info VARCHAR(254),
|
|---|
| 254 | zanik_dne DATE,
|
|---|
| 255 | zanik_info VARCHAR(254),
|
|---|
| 256 | sobvod_kod NUMERIC(3),
|
|---|
| 257 | nobvod_kod NUMERIC(3)
|
|---|
| 258 | );
|
|---|
| 259 | CREATE TABLE uir_adr_mcast_h (
|
|---|
| 260 | mcast_kod NUMERIC(6) NOT NULL,
|
|---|
| 261 | plati_do DATE NOT NULL,
|
|---|
| 262 | obec_kod NUMERIC(6) NOT NULL,
|
|---|
| 263 | pobvod_kod NUMERIC(3),
|
|---|
| 264 | typ NUMERIC(1) NOT NULL,
|
|---|
| 265 | nazev VARCHAR(48) NOT NULL,
|
|---|
| 266 | zkratka VARCHAR(16) NOT NULL,
|
|---|
| 267 | info VARCHAR(254),
|
|---|
| 268 | sobvod_kod NUMERIC(3),
|
|---|
| 269 | nobvod_kod NUMERIC(3)
|
|---|
| 270 | );
|
|---|
| 271 | CREATE TABLE uir_adr_cobce (
|
|---|
| 272 | cobce_kod NUMERIC(6) NOT NULL,
|
|---|
| 273 | obec_kod NUMERIC(6) NOT NULL,
|
|---|
| 274 | nazev VARCHAR(48) NOT NULL,
|
|---|
| 275 | zkratka VARCHAR(16) NOT NULL,
|
|---|
| 276 | stav NUMERIC(1) NOT NULL,
|
|---|
| 277 | vznik_dne DATE,
|
|---|
| 278 | vznik_info VARCHAR(254),
|
|---|
| 279 | zanik_dne DATE,
|
|---|
| 280 | zanik_info VARCHAR(254)
|
|---|
| 281 | );
|
|---|
| 282 | CREATE TABLE uir_adr_cobce_h (
|
|---|
| 283 | cobce_kod NUMERIC(6) NOT NULL,
|
|---|
| 284 | plati_do DATE NOT NULL,
|
|---|
| 285 | obec_kod NUMERIC(6) NOT NULL,
|
|---|
| 286 | nazev VARCHAR(48) NOT NULL,
|
|---|
| 287 | zkratka VARCHAR(16) NOT NULL,
|
|---|
| 288 | info VARCHAR(254)
|
|---|
| 289 | );
|
|---|
| 290 | CREATE TABLE uir_adr_ulice (
|
|---|
| 291 | ulice_kod NUMERIC(7) NOT NULL,
|
|---|
| 292 | obec_kod NUMERIC(6) NOT NULL,
|
|---|
| 293 | nazev VARCHAR(48) NOT NULL,
|
|---|
| 294 | zkratka VARCHAR(16) NOT NULL,
|
|---|
| 295 | stav NUMERIC(1) NOT NULL,
|
|---|
| 296 | vznik_dne DATE,
|
|---|
| 297 | vznik_info VARCHAR(254),
|
|---|
| 298 | zanik_dne DATE,
|
|---|
| 299 | zanik_info VARCHAR(254)
|
|---|
| 300 | );
|
|---|
| 301 | CREATE TABLE uir_adr_ulice_h (
|
|---|
| 302 | ulice_kod NUMERIC(7) NOT NULL,
|
|---|
| 303 | plati_do DATE NOT NULL,
|
|---|
| 304 | obec_kod NUMERIC(6) NOT NULL,
|
|---|
| 305 | nazev VARCHAR(48) NOT NULL,
|
|---|
| 306 | zkratka VARCHAR(16) NOT NULL,
|
|---|
| 307 | info VARCHAR(254)
|
|---|
| 308 | );
|
|---|
| 309 | CREATE TABLE uir_adr_objekt (
|
|---|
| 310 | objekt_kod NUMERIC(9) NOT NULL,
|
|---|
| 311 | cobce_kod NUMERIC(6) NOT NULL,
|
|---|
| 312 | cisdom_typ NUMERIC(1) NOT NULL,
|
|---|
| 313 | cisdom_hod NUMERIC(4) NOT NULL,
|
|---|
| 314 | stav NUMERIC(1) NOT NULL,
|
|---|
| 315 | vznik_dne DATE,
|
|---|
| 316 | vznik_info VARCHAR(254),
|
|---|
| 317 | zanik_dne DATE,
|
|---|
| 318 | zanik_info VARCHAR(254),
|
|---|
| 319 | mcast_kod NUMERIC(6),
|
|---|
| 320 | idob NUMERIC(10)
|
|---|
| 321 | );
|
|---|
| 322 | CREATE TABLE uir_adr_objekt_h (
|
|---|
| 323 | objekt_kod NUMERIC(9) NOT NULL,
|
|---|
| 324 | plati_do DATE NOT NULL,
|
|---|
| 325 | cobce_kod NUMERIC(6) NOT NULL,
|
|---|
| 326 | cisdom_typ NUMERIC(1) NOT NULL,
|
|---|
| 327 | cisdom_hod NUMERIC(4) NOT NULL,
|
|---|
| 328 | info VARCHAR(254),
|
|---|
| 329 | mcast_kod NUMERIC(6)
|
|---|
| 330 | );
|
|---|
| 331 | CREATE TABLE uir_adr_adresa (
|
|---|
| 332 | adresa_kod NUMERIC(9) NOT NULL,
|
|---|
| 333 | objekt_kod NUMERIC(9) NOT NULL,
|
|---|
| 334 | ulice_kod NUMERIC(7),
|
|---|
| 335 | cisor_hod NUMERIC(3),
|
|---|
| 336 | cisor_pis VARCHAR(1),
|
|---|
| 337 | psc NUMERIC(5) NOT NULL,
|
|---|
| 338 | stav NUMERIC(1) NOT NULL,
|
|---|
| 339 | vznik_dne DATE,
|
|---|
| 340 | vznik_info VARCHAR(254),
|
|---|
| 341 | zanik_dne DATE,
|
|---|
| 342 | zanik_info VARCHAR(254),
|
|---|
| 343 | pcd NUMERIC(10),
|
|---|
| 344 | x NUMERIC(8),
|
|---|
| 345 | y NUMERIC(7)
|
|---|
| 346 | );
|
|---|
| 347 | CREATE TABLE uir_adr_adresa_h (
|
|---|
| 348 | adresa_kod NUMERIC(9) NOT NULL,
|
|---|
| 349 | plati_do DATE NOT NULL,
|
|---|
| 350 | objekt_kod NUMERIC(9) NOT NULL,
|
|---|
| 351 | ulice_kod NUMERIC(7),
|
|---|
| 352 | cisor_hod NUMERIC(3),
|
|---|
| 353 | cisor_pis VARCHAR(1),
|
|---|
| 354 | psc NUMERIC(5) NOT NULL,
|
|---|
| 355 | info VARCHAR(254)
|
|---|
| 356 | );
|
|---|
| 357 | CREATE TABLE uir_adr_obec_d (
|
|---|
| 358 | obec_kod NUMERIC(6) NOT NULL,
|
|---|
| 359 | adresa_kod NUMERIC(9) NOT NULL,
|
|---|
| 360 | jmeno VARCHAR(40),
|
|---|
| 361 | telefon VARCHAR(40),
|
|---|
| 362 | e_mail VARCHAR(50)
|
|---|
| 363 | );
|
|---|
| 364 | CREATE TABLE uir_adr_vazba (
|
|---|
| 365 | vazba_id NUMERIC(7) NOT NULL,
|
|---|
| 366 | mcast_kod NUMERIC(6),
|
|---|
| 367 | cobce_kod NUMERIC(6) NOT NULL,
|
|---|
| 368 | ulice_kod NUMERIC(7),
|
|---|
| 369 | psc NUMERIC(5) NOT NULL
|
|---|
| 370 | );
|
|---|
| 371 | CREATE TABLE uir_adr_cob_prev (
|
|---|
| 372 | kodcob NUMERIC(6) NOT NULL,
|
|---|
| 373 | plati_od DATE NOT NULL,
|
|---|
| 374 | plati_do DATE NOT NULL,
|
|---|
| 375 | cobce_kod NUMERIC(6) NOT NULL,
|
|---|
| 376 | mcast_kod NUMERIC(6)
|
|---|
| 377 | );
|
|---|
| 378 | CREATE TABLE uir_adr_verze (
|
|---|
| 379 | ver_cislo NUMERIC(5) NOT NULL,
|
|---|
| 380 | ver_zsj VARCHAR(5),
|
|---|
| 381 | cas_uzav TIMESTAMP
|
|---|
| 382 | );
|
|---|
| 383 | CREATE TABLE uir_adr_zmen_zaz (
|
|---|
| 384 | zmena_id NUMERIC(9) NOT NULL,
|
|---|
| 385 | ver_cislo NUMERIC(5) NOT NULL,
|
|---|
| 386 | tabulka NUMERIC(2) NOT NULL,
|
|---|
| 387 | prim_klic VARCHAR(21) NOT NULL,
|
|---|
| 388 | operace NUMERIC(1) NOT NULL,
|
|---|
| 389 | dokum VARCHAR(10) NOT NULL
|
|---|
| 390 | );
|
|---|
| 391 | CREATE TABLE uir_adr_zmen_atr (
|
|---|
| 392 | zmena_id NUMERIC(9) NOT NULL,
|
|---|
| 393 | pozice NUMERIC(2) NOT NULL,
|
|---|
| 394 | hodnota VARCHAR(254)
|
|---|
| 395 | );
|
|---|
| 396 | CREATE TABLE uir_adr_stav_db (
|
|---|
| 397 | verze_db_1 NUMERIC(2) NOT NULL,
|
|---|
| 398 | verze_db_2 NUMERIC(2) NOT NULL
|
|---|
| 399 | );
|
|---|
| 400 | -- Set right encoding for csv
|
|---|
| 401 | \encoding WIN1250
|
|---|
| 402 | -- Load tables data from csv
|
|---|
| 403 | \copy uir_adr_adresa from 'adresa.csv' delimiter as ',' csv quote as ''''
|
|---|
| 404 | \copy uir_adr_adresa_h from 'adresa_h.csv' delimiter as ',' csv quote as ''''
|
|---|
| 405 | \copy uir_adr_cob_prev from 'cob_prev.csv' delimiter as ',' csv quote as ''''
|
|---|
| 406 | \copy uir_adr_cobce from 'cobce.csv' delimiter as ',' csv quote as ''''
|
|---|
| 407 | \copy uir_adr_cobce_h from 'cobce_h.csv' delimiter as ',' csv quote as ''''
|
|---|
| 408 | \copy uir_adr_kraj from 'kraj.csv' delimiter as ',' csv quote as ''''
|
|---|
| 409 | \copy uir_adr_kraj_h from 'kraj_h.csv' delimiter as ',' csv quote as ''''
|
|---|
| 410 | \copy uir_adr_mcast from 'mcast.csv' delimiter as ',' csv quote as ''''
|
|---|
| 411 | \copy uir_adr_mcast_h from 'mcast_h.csv' delimiter as ',' csv quote as ''''
|
|---|
| 412 | \copy uir_adr_nobvod from 'nobvod.csv' delimiter as ',' csv quote as ''''
|
|---|
| 413 | \copy uir_adr_nobvod_h from 'nobvod_h.csv' delimiter as ',' csv quote as ''''
|
|---|
| 414 | \copy uir_adr_obec from 'obec.csv' delimiter as ',' csv quote as ''''
|
|---|
| 415 | \copy uir_adr_obec_d from 'obec_d.csv' delimiter as ',' csv quote as ''''
|
|---|
| 416 | \copy uir_adr_obec_h from 'obec_h.csv' delimiter as ',' csv quote as ''''
|
|---|
| 417 | \copy uir_adr_objekt from 'objekt.csv' delimiter as ',' csv quote as ''''
|
|---|
| 418 | \copy uir_adr_objekt_h from 'objekt_h.csv' delimiter as ',' csv quote as ''''
|
|---|
| 419 | \copy uir_adr_oblast from 'oblast.csv' delimiter as ',' csv quote as ''''
|
|---|
| 420 | \copy uir_adr_oblast_h from 'oblast_h.csv' delimiter as ',' csv quote as ''''
|
|---|
| 421 | \copy uir_adr_okres from 'okres.csv' delimiter as ',' csv quote as ''''
|
|---|
| 422 | \copy uir_adr_okres_h from 'okres_h.csv' delimiter as ',' csv quote as ''''
|
|---|
| 423 | \copy uir_adr_orp from 'orp.csv' delimiter as ',' csv quote as ''''
|
|---|
| 424 | \copy uir_adr_orp_h from 'orp_h.csv' delimiter as ',' csv quote as ''''
|
|---|
| 425 | \copy uir_adr_pobvod from 'pobvod.csv' delimiter as ',' csv quote as ''''
|
|---|
| 426 | \copy uir_adr_pobvod_h from 'pobvod_h.csv' delimiter as ',' csv quote as ''''
|
|---|
| 427 | \copy uir_adr_posta from 'posta.csv' delimiter as ',' csv quote as ''''
|
|---|
| 428 | \copy uir_adr_posta_h from 'posta_h.csv' delimiter as ',' csv quote as ''''
|
|---|
| 429 | \copy uir_adr_pou from 'pou.csv' delimiter as ',' csv quote as ''''
|
|---|
| 430 | \copy uir_adr_pou_h from 'pou_h.csv' delimiter as ',' csv quote as ''''
|
|---|
| 431 | \copy uir_adr_sobvod from 'sobvod.csv' delimiter as ',' csv quote as ''''
|
|---|
| 432 | \copy uir_adr_sobvod_h from 'sobvod_h.csv' delimiter as ',' csv quote as ''''
|
|---|
| 433 | \copy uir_adr_stav_db from 'stav_db.csv' delimiter as ',' csv quote as ''''
|
|---|
| 434 | \copy uir_adr_ulice from 'ulice.csv' delimiter as ',' csv quote as ''''
|
|---|
| 435 | \copy uir_adr_ulice_h from 'ulice_h.csv' delimiter as ',' csv quote as ''''
|
|---|
| 436 | \copy uir_adr_vazba from 'vazba.csv' delimiter as ',' csv quote as ''''
|
|---|
| 437 | \copy uir_adr_verze from 'verze.csv' delimiter as ',' csv quote as ''''
|
|---|
| 438 | -- \copy uir_adr_zmen_atr from 'zmen_atr.csv' delimiter as ',' csv quote as ''''
|
|---|
| 439 | -- \copy uir_adr_zmen_zaz from 'zmen_zaz.csv' delimiter as ',' csv quote as ''''
|
|---|
| 440 | -- Portax extensions
|
|---|
| 441 | ALTER TABLE uir_adr_verze add column cas_importu TIMESTAMP;
|
|---|
| 442 | DELETE FROM uir_adr_verze WHERE cas_uzav IS NULL;
|
|---|
| 443 | UPDATE uir_adr_verze set cas_importu=NOW();
|
|---|
| 444 | -- Primary keys:
|
|---|
| 445 | ALTER TABLE uir_adr_posta ADD CONSTRAINT xpkposta PRIMARY KEY (psc);
|
|---|
| 446 | ALTER TABLE uir_adr_posta_h ADD CONSTRAINT xpkposta_h PRIMARY KEY (psc,plati_do);
|
|---|
| 447 | ALTER TABLE uir_adr_oblast ADD CONSTRAINT xpkoblast PRIMARY KEY (oblast_kod);
|
|---|
| 448 | ALTER TABLE uir_adr_oblast_h ADD CONSTRAINT xpkoblast_h PRIMARY KEY (oblast_kod,plati_do);
|
|---|
| 449 | ALTER TABLE uir_adr_kraj ADD CONSTRAINT xpkkraj PRIMARY KEY (kraj_kod);
|
|---|
| 450 | ALTER TABLE uir_adr_kraj_h ADD CONSTRAINT xpkkraj_h PRIMARY KEY (kraj_kod,plati_do);
|
|---|
| 451 | ALTER TABLE uir_adr_okres ADD CONSTRAINT xpkokres PRIMARY KEY (okres_kod);
|
|---|
| 452 | ALTER TABLE uir_adr_okres_h ADD CONSTRAINT xpkokres_h PRIMARY KEY (okres_kod,plati_do);
|
|---|
| 453 | ALTER TABLE uir_adr_orp ADD CONSTRAINT xpkorp PRIMARY KEY (orp_kod);
|
|---|
| 454 | ALTER TABLE uir_adr_orp_h ADD CONSTRAINT xpkorp_h PRIMARY KEY (orp_kod,plati_do);
|
|---|
| 455 | ALTER TABLE uir_adr_pou ADD CONSTRAINT xpkpou PRIMARY KEY (pou_kod);
|
|---|
| 456 | ALTER TABLE uir_adr_pou_h ADD CONSTRAINT xpkpou_h PRIMARY KEY (pou_kod,plati_do);
|
|---|
| 457 | ALTER TABLE uir_adr_obec ADD CONSTRAINT xpkobec PRIMARY KEY (obec_kod);
|
|---|
| 458 | ALTER TABLE uir_adr_obec_h ADD CONSTRAINT xpkobec_h PRIMARY KEY (obec_kod,plati_do);
|
|---|
| 459 | ALTER TABLE uir_adr_pobvod ADD CONSTRAINT xpkpobvod PRIMARY KEY (pobvod_kod);
|
|---|
| 460 | ALTER TABLE uir_adr_pobvod_h ADD CONSTRAINT xpkpobvod_h PRIMARY KEY (pobvod_kod,plati_do);
|
|---|
| 461 | ALTER TABLE uir_adr_sobvod ADD CONSTRAINT xpksobvod PRIMARY KEY (sobvod_kod);
|
|---|
| 462 | ALTER TABLE uir_adr_sobvod_h ADD CONSTRAINT xpksobvod_h PRIMARY KEY (sobvod_kod,plati_do);
|
|---|
| 463 | ALTER TABLE uir_adr_nobvod ADD CONSTRAINT xpknobvod PRIMARY KEY (nobvod_kod);
|
|---|
| 464 | ALTER TABLE uir_adr_nobvod_h ADD CONSTRAINT xpknobvod_h PRIMARY KEY (nobvod_kod,plati_do);
|
|---|
| 465 | ALTER TABLE uir_adr_mcast ADD CONSTRAINT xpkmcast PRIMARY KEY (mcast_kod);
|
|---|
| 466 | ALTER TABLE uir_adr_mcast_h ADD CONSTRAINT xpkmcast_h PRIMARY KEY (mcast_kod,plati_do);
|
|---|
| 467 | ALTER TABLE uir_adr_cobce ADD CONSTRAINT xpkcobce PRIMARY KEY (cobce_kod);
|
|---|
| 468 | ALTER TABLE uir_adr_cobce_h ADD CONSTRAINT xpkcobce_h PRIMARY KEY (cobce_kod,plati_do);
|
|---|
| 469 | ALTER TABLE uir_adr_ulice ADD CONSTRAINT xpkulice PRIMARY KEY (ulice_kod);
|
|---|
| 470 | ALTER TABLE uir_adr_ulice_h ADD CONSTRAINT xpkulice_h PRIMARY KEY (ulice_kod,plati_do);
|
|---|
| 471 | ALTER TABLE uir_adr_objekt ADD CONSTRAINT xpkobjekt PRIMARY KEY (objekt_kod);
|
|---|
| 472 | ALTER TABLE uir_adr_objekt_h ADD CONSTRAINT xpkobjekt_h PRIMARY KEY (objekt_kod,plati_do);
|
|---|
| 473 | ALTER TABLE uir_adr_adresa ADD CONSTRAINT xpkadresa PRIMARY KEY (adresa_kod);
|
|---|
| 474 | ALTER TABLE uir_adr_adresa_h ADD CONSTRAINT xpkadresa_h PRIMARY KEY (adresa_kod,plati_do);
|
|---|
| 475 | ALTER TABLE uir_adr_obec_d ADD CONSTRAINT xpkobec_d PRIMARY KEY (obec_kod);
|
|---|
| 476 | ALTER TABLE uir_adr_vazba ADD CONSTRAINT xpkvazba PRIMARY KEY (vazba_id);
|
|---|
| 477 | ALTER TABLE uir_adr_cob_prev ADD CONSTRAINT xpkcob_prev PRIMARY KEY (kodcob,plati_od);
|
|---|
| 478 | ALTER TABLE uir_adr_verze ADD CONSTRAINT xpkverze PRIMARY KEY (ver_cislo);
|
|---|
| 479 | ALTER TABLE uir_adr_zmen_zaz ADD CONSTRAINT xpkzmen_zaz PRIMARY KEY (zmena_id);
|
|---|
| 480 | ALTER TABLE uir_adr_zmen_atr ADD CONSTRAINT xpkzmen_atr PRIMARY KEY (zmena_id,pozice);
|
|---|
| 481 | -- Unique keys:
|
|---|
| 482 | ALTER TABLE uir_adr_vazba ADD CONSTRAINT xak1vazba UNIQUE (cobce_kod, psc, ulice_kod, mcast_kod);
|
|---|
| 483 | ALTER TABLE uir_adr_cob_prev ADD CONSTRAINT xak1cob_prev UNIQUE (cobce_kod, mcast_kod, plati_od);
|
|---|
| 484 | ALTER TABLE uir_adr_zmen_zaz ADD CONSTRAINT xak1zmen_zaz UNIQUE (tabulka, prim_klic, ver_cislo);
|
|---|
| 485 | -- Foreign keys:
|
|---|
| 486 | ALTER TABLE uir_adr_posta_h ADD CONSTRAINT posta_posta_h FOREIGN KEY (psc) REFERENCES uir_adr_posta;
|
|---|
| 487 | ALTER TABLE uir_adr_oblast_h ADD CONSTRAINT oblast_oblast_h FOREIGN KEY (oblast_kod) REFERENCES uir_adr_oblast;
|
|---|
| 488 | ALTER TABLE uir_adr_kraj ADD CONSTRAINT oblast_kraj FOREIGN KEY (oblast_kod) REFERENCES uir_adr_oblast;
|
|---|
| 489 | ALTER TABLE uir_adr_kraj_h ADD CONSTRAINT kraj_kraj_h FOREIGN KEY (kraj_kod) REFERENCES uir_adr_kraj;
|
|---|
| 490 | ALTER TABLE uir_adr_kraj_h ADD CONSTRAINT oblast_kraj_h FOREIGN KEY (oblast_kod) REFERENCES uir_adr_oblast;
|
|---|
| 491 | ALTER TABLE uir_adr_okres ADD CONSTRAINT kraj_okres FOREIGN KEY (kraj_kod) REFERENCES uir_adr_kraj;
|
|---|
| 492 | ALTER TABLE uir_adr_okres_h ADD CONSTRAINT okres_okres_h FOREIGN KEY (okres_kod) REFERENCES uir_adr_okres;
|
|---|
| 493 | ALTER TABLE uir_adr_okres_h ADD CONSTRAINT kraj_okres_h FOREIGN KEY (kraj_kod) REFERENCES uir_adr_kraj;
|
|---|
| 494 | ALTER TABLE uir_adr_orp ADD CONSTRAINT kraj_orp FOREIGN KEY (kraj_kod) REFERENCES uir_adr_kraj;
|
|---|
| 495 | ALTER TABLE uir_adr_orp_h ADD CONSTRAINT orp_orp_h FOREIGN KEY (orp_kod) REFERENCES uir_adr_orp;
|
|---|
| 496 | ALTER TABLE uir_adr_orp_h ADD CONSTRAINT kraj_orp_h FOREIGN KEY (kraj_kod) REFERENCES uir_adr_kraj;
|
|---|
| 497 | ALTER TABLE uir_adr_pou ADD CONSTRAINT orp_pou FOREIGN KEY (orp_kod) REFERENCES uir_adr_orp;
|
|---|
| 498 | ALTER TABLE uir_adr_pou_h ADD CONSTRAINT pou_pou_h FOREIGN KEY (pou_kod) REFERENCES uir_adr_pou;
|
|---|
| 499 | ALTER TABLE uir_adr_pou_h ADD CONSTRAINT orp_pou_h FOREIGN KEY (orp_kod) REFERENCES uir_adr_orp;
|
|---|
| 500 | ALTER TABLE uir_adr_obec ADD CONSTRAINT okres_obec FOREIGN KEY (okres_kod) REFERENCES uir_adr_okres;
|
|---|
| 501 | ALTER TABLE uir_adr_obec ADD CONSTRAINT pou_obec FOREIGN KEY (pou_kod) REFERENCES uir_adr_pou;
|
|---|
| 502 | ALTER TABLE uir_adr_obec_h ADD CONSTRAINT obec_obec_h FOREIGN KEY (obec_kod) REFERENCES uir_adr_obec;
|
|---|
| 503 | ALTER TABLE uir_adr_obec_h ADD CONSTRAINT okres_obec_h FOREIGN KEY (okres_kod) REFERENCES uir_adr_okres;
|
|---|
| 504 | ALTER TABLE uir_adr_obec_h ADD CONSTRAINT pou_obec_h FOREIGN KEY (pou_kod) REFERENCES uir_adr_pou;
|
|---|
| 505 | ALTER TABLE uir_adr_pobvod ADD CONSTRAINT obec_pobvod FOREIGN KEY (obec_kod) REFERENCES uir_adr_obec;
|
|---|
| 506 | ALTER TABLE uir_adr_pobvod_h ADD CONSTRAINT pobvod_pobvod_h FOREIGN KEY (pobvod_kod) REFERENCES uir_adr_pobvod;
|
|---|
| 507 | ALTER TABLE uir_adr_pobvod_h ADD CONSTRAINT obec_pobvod_h FOREIGN KEY (obec_kod) REFERENCES uir_adr_obec;
|
|---|
| 508 | ALTER TABLE uir_adr_sobvod ADD CONSTRAINT obec_sobvod FOREIGN KEY (obec_kod) REFERENCES uir_adr_obec;
|
|---|
| 509 | ALTER TABLE uir_adr_sobvod_h ADD CONSTRAINT sobvod_sobvod_h FOREIGN KEY (sobvod_kod) REFERENCES uir_adr_sobvod;
|
|---|
| 510 | ALTER TABLE uir_adr_sobvod_h ADD CONSTRAINT obec_sobvod_h FOREIGN KEY (obec_kod) REFERENCES uir_adr_obec;
|
|---|
| 511 | ALTER TABLE uir_adr_nobvod ADD CONSTRAINT obec_nobvod FOREIGN KEY (obec_kod) REFERENCES uir_adr_obec;
|
|---|
| 512 | ALTER TABLE uir_adr_nobvod_h ADD CONSTRAINT nobvod_nobvod_h FOREIGN KEY (nobvod_kod) REFERENCES uir_adr_nobvod;
|
|---|
| 513 | ALTER TABLE uir_adr_nobvod_h ADD CONSTRAINT obec_nobvod_h FOREIGN KEY (obec_kod) REFERENCES uir_adr_obec;
|
|---|
| 514 | ALTER TABLE uir_adr_mcast ADD CONSTRAINT obec_mcast FOREIGN KEY (obec_kod) REFERENCES uir_adr_obec;
|
|---|
| 515 | ALTER TABLE uir_adr_mcast ADD CONSTRAINT pobvod_mcast FOREIGN KEY (pobvod_kod) REFERENCES uir_adr_pobvod;
|
|---|
| 516 | ALTER TABLE uir_adr_mcast ADD CONSTRAINT sobvod_mcast FOREIGN KEY (sobvod_kod) REFERENCES uir_adr_sobvod;
|
|---|
| 517 | ALTER TABLE uir_adr_mcast ADD CONSTRAINT nobvod_mcast FOREIGN KEY (nobvod_kod) REFERENCES uir_adr_nobvod;
|
|---|
| 518 | ALTER TABLE uir_adr_mcast_h ADD CONSTRAINT mcast_mcast_h FOREIGN KEY (mcast_kod) REFERENCES uir_adr_mcast;
|
|---|
| 519 | ALTER TABLE uir_adr_mcast_h ADD CONSTRAINT obec_mcast_h FOREIGN KEY (obec_kod) REFERENCES uir_adr_obec;
|
|---|
| 520 | ALTER TABLE uir_adr_mcast_h ADD CONSTRAINT pobvod_mcast_h FOREIGN KEY (pobvod_kod) REFERENCES uir_adr_pobvod;
|
|---|
| 521 | ALTER TABLE uir_adr_mcast_h ADD CONSTRAINT sobvod_mcast_h FOREIGN KEY (sobvod_kod) REFERENCES uir_adr_sobvod;
|
|---|
| 522 | ALTER TABLE uir_adr_mcast_h ADD CONSTRAINT nobvod_mcast_h FOREIGN KEY (nobvod_kod) REFERENCES uir_adr_nobvod;
|
|---|
| 523 | ALTER TABLE uir_adr_cobce ADD CONSTRAINT obec_cobce FOREIGN KEY (obec_kod) REFERENCES uir_adr_obec;
|
|---|
| 524 | ALTER TABLE uir_adr_cobce_h ADD CONSTRAINT cobce_cobce_h FOREIGN KEY (cobce_kod) REFERENCES uir_adr_cobce;
|
|---|
| 525 | ALTER TABLE uir_adr_cobce_h ADD CONSTRAINT obec_cobce_h FOREIGN KEY (obec_kod) REFERENCES uir_adr_obec;
|
|---|
| 526 | ALTER TABLE uir_adr_ulice ADD CONSTRAINT obec_ulice FOREIGN KEY (obec_kod) REFERENCES uir_adr_obec;
|
|---|
| 527 | ALTER TABLE uir_adr_ulice_h ADD CONSTRAINT ulice_ulice_h FOREIGN KEY (ulice_kod) REFERENCES uir_adr_ulice;
|
|---|
| 528 | ALTER TABLE uir_adr_ulice_h ADD CONSTRAINT obec_ulice_h FOREIGN KEY (obec_kod) REFERENCES uir_adr_obec;
|
|---|
| 529 | ALTER TABLE uir_adr_objekt ADD CONSTRAINT cobce_objekt FOREIGN KEY (cobce_kod) REFERENCES uir_adr_cobce;
|
|---|
| 530 | ALTER TABLE uir_adr_objekt ADD CONSTRAINT mcast_objekt FOREIGN KEY (mcast_kod) REFERENCES uir_adr_mcast;
|
|---|
| 531 | ALTER TABLE uir_adr_objekt_h ADD CONSTRAINT objekt_objekt_h FOREIGN KEY (objekt_kod) REFERENCES uir_adr_objekt;
|
|---|
| 532 | ALTER TABLE uir_adr_objekt_h ADD CONSTRAINT cobce_objekt_h FOREIGN KEY (cobce_kod) REFERENCES uir_adr_cobce;
|
|---|
| 533 | ALTER TABLE uir_adr_objekt_h ADD CONSTRAINT mcast_objekt_h FOREIGN KEY (mcast_kod) REFERENCES uir_adr_mcast;
|
|---|
| 534 | ALTER TABLE uir_adr_adresa ADD CONSTRAINT objekt_adresa FOREIGN KEY (objekt_kod) REFERENCES uir_adr_objekt;
|
|---|
| 535 | ALTER TABLE uir_adr_adresa ADD CONSTRAINT ulice_adresa FOREIGN KEY (ulice_kod) REFERENCES uir_adr_ulice;
|
|---|
| 536 | ALTER TABLE uir_adr_adresa ADD CONSTRAINT posta_adresa FOREIGN KEY (psc) REFERENCES uir_adr_posta;
|
|---|
| 537 | ALTER TABLE uir_adr_adresa_h ADD CONSTRAINT adresa_adresa_h FOREIGN KEY (adresa_kod) REFERENCES uir_adr_adresa;
|
|---|
| 538 | ALTER TABLE uir_adr_adresa_h ADD CONSTRAINT objekt_adresa_h FOREIGN KEY (objekt_kod) REFERENCES uir_adr_objekt;
|
|---|
| 539 | ALTER TABLE uir_adr_adresa_h ADD CONSTRAINT ulice_adresa_h FOREIGN KEY (ulice_kod) REFERENCES uir_adr_ulice;
|
|---|
| 540 | ALTER TABLE uir_adr_adresa_h ADD CONSTRAINT posta_adresa_h FOREIGN KEY (psc) REFERENCES uir_adr_posta;
|
|---|
| 541 | ALTER TABLE uir_adr_obec_d ADD CONSTRAINT obec_obec_d FOREIGN KEY (obec_kod) REFERENCES uir_adr_obec;
|
|---|
| 542 | ALTER TABLE uir_adr_obec_d ADD CONSTRAINT adresa_obec_d FOREIGN KEY (adresa_kod) REFERENCES uir_adr_adresa;
|
|---|
| 543 | ALTER TABLE uir_adr_vazba ADD CONSTRAINT mcast_vazba FOREIGN KEY (mcast_kod) REFERENCES uir_adr_mcast;
|
|---|
| 544 | ALTER TABLE uir_adr_vazba ADD CONSTRAINT cobce_vazba FOREIGN KEY (cobce_kod) REFERENCES uir_adr_cobce;
|
|---|
| 545 | ALTER TABLE uir_adr_vazba ADD CONSTRAINT ulice_vazba FOREIGN KEY (ulice_kod) REFERENCES uir_adr_ulice;
|
|---|
| 546 | ALTER TABLE uir_adr_vazba ADD CONSTRAINT posta_vazba FOREIGN KEY (psc) REFERENCES uir_adr_posta;
|
|---|
| 547 | ALTER TABLE uir_adr_cob_prev ADD CONSTRAINT cobce_cob_prev FOREIGN KEY (cobce_kod) REFERENCES uir_adr_cobce;
|
|---|
| 548 | ALTER TABLE uir_adr_cob_prev ADD CONSTRAINT mcast_cob_prev FOREIGN KEY (mcast_kod) REFERENCES uir_adr_mcast;
|
|---|
| 549 | ALTER TABLE uir_adr_zmen_zaz ADD CONSTRAINT verze_zmen_zaz FOREIGN KEY (ver_cislo) REFERENCES uir_adr_verze;
|
|---|
| 550 | ALTER TABLE uir_adr_zmen_atr ADD CONSTRAINT zmen_zaz_zmen_atr FOREIGN KEY (zmena_id) REFERENCES uir_adr_zmen_zaz;
|
|---|
