# HG changeset patch
# User Andre Heinecke <aheinecke@intevation.de>
# Date 1364470686 -3600
# Node ID 1488227b97b7ef4e9f059b1de1a5813151cb87f3
# Parent  773899d002340506353b758db7ab2fa9e446a983
Minor scheme change. Update kind names to their UI representation.

update axis_kinds set name='aktuelle Achse' where id=1;
update cross_section_track_kinds set name='aktuelle Querprofilspuren' where id=1;
update floodplain_kinds set name='aktuelle Talaue' where id=1;

diff -r 773899d00234 -r 1488227b97b7 flys-backend/doc/schema/oracle-spatial.sql
--- a/flys-backend/doc/schema/oracle-spatial.sql	Thu Mar 28 12:04:53 2013 +0100
+++ b/flys-backend/doc/schema/oracle-spatial.sql	Thu Mar 28 12:38:06 2013 +0100
@@ -5,7 +5,7 @@
     name VARCHAR(64)
 );
 INSERT INTO axis_kinds(id, name) VALUES (0, 'Unbekannt');
-INSERT INTO axis_kinds(id, name) VALUES (1, 'Aktuell');
+INSERT INTO axis_kinds(id, name) VALUES (1, 'aktuelle Achse');
 INSERT INTO axis_kinds(id, name) VALUES (2, 'Sonstige');
 
 -- Geodaesie/Flussachse+km/achse
@@ -54,7 +54,7 @@
     name VARCHAR(64)
 );
 INSERT INTO cross_section_track_kinds(id, name) VALUES (0, 'Sonstige');
-INSERT INTO cross_section_track_kinds(id, name) VALUES (1, 'Aktuell');
+INSERT INTO cross_section_track_kinds(id, name) VALUES (1, 'aktuelle Querprofilspuren');
 
 CREATE SEQUENCE CROSS_SECTION_TRACKS_ID_SEQ;
 CREATE TABLE cross_section_tracks (
@@ -137,7 +137,7 @@
     name VARCHAR(64)
 );
 INSERT INTO floodplain_kinds(id, name) VALUES (0, 'Sonstige');
-INSERT INTO floodplain_kinds(id, name) VALUES (1, 'Aktuell');
+INSERT INTO floodplain_kinds(id, name) VALUES (1, 'aktuelle Talaue');
 
 CREATE SEQUENCE FLOODPLAIN_ID_SEQ;
 CREATE TABLE floodplain(
diff -r 773899d00234 -r 1488227b97b7 flys-backend/doc/schema/postgresql-spatial.sql
--- a/flys-backend/doc/schema/postgresql-spatial.sql	Thu Mar 28 12:04:53 2013 +0100
+++ b/flys-backend/doc/schema/postgresql-spatial.sql	Thu Mar 28 12:38:06 2013 +0100
@@ -5,7 +5,7 @@
     name VARCHAR(64)
 );
 INSERT INTO axis_kinds(id, name) VALUES (0, 'Unbekannt');
-INSERT INTO axis_kinds(id, name) VALUES (1, 'Aktuell');
+INSERT INTO axis_kinds(id, name) VALUES (1, 'aktuelle Achse');
 INSERT INTO axis_kinds(id, name) VALUES (2, 'Sonstige');
 
 -- Geodaesie/Flussachse+km/achse
@@ -41,7 +41,7 @@
     name VARCHAR(64)
 );
 INSERT INTO cross_section_track_kinds(id, name) VALUES (0, 'Sonstige');
-INSERT INTO cross_section_track_kinds(id, name) VALUES (1, 'Aktuell');
+INSERT INTO cross_section_track_kinds(id, name) VALUES (1, 'aktuelle Querprofilspuren');
 
 CREATE SEQUENCE CROSS_SECTION_TRACKS_ID_SEQ;
 CREATE TABLE cross_section_tracks (
@@ -102,7 +102,7 @@
     name VARCHAR(64)
 );
 INSERT INTO floodplain_kinds(id, name) VALUES (0, 'Sonstige');
-INSERT INTO floodplain_kinds(id, name) VALUES (1, 'Aktuell');
+INSERT INTO floodplain_kinds(id, name) VALUES (1, 'aktuelle Talaue');
 
 CREATE SEQUENCE FLOODPLAIN_ID_SEQ;
 CREATE TABLE floodplain (