diff db_schema/stammdaten_schema.sql @ 1258:cb88ab44c2be

add code to stamdaten.ort_typ
author Michael Stanko <mstanko@bfs.de>
date Wed, 25 Jan 2017 14:14:58 +0100
parents f094aca05cf2
children a356b818389a
line wrap: on
line diff
--- a/db_schema/stammdaten_schema.sql	Tue Jan 17 17:29:11 2017 +0100
+++ b/db_schema/stammdaten_schema.sql	Wed Jan 25 14:14:58 2017 +0100
@@ -400,7 +400,8 @@
 
 CREATE TABLE ort_typ (
     id smallint PRIMARY KEY,
-    ort_typ character varying(60)
+    ort_typ character varying(60),
+    code character varying(3)
 );
 
 CREATE TABLE kta (
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)