Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql-spatial.sql @ 5514:4c4fed23693f
Cosmetic scheme change. Qualify the unknown name of sectie and sobek
author | Andre Heinecke <aheinecke@intevation.de> |
---|---|
date | Thu, 28 Mar 2013 15:56:24 +0100 |
parents | ef3517905e6e |
children | 0aaed46a88be |
comparison
equal
deleted
inserted
replaced
5513:ef3517905e6e | 5514:4c4fed23693f |
---|---|
248 | 248 |
249 CREATE TABLE sectie_kinds ( | 249 CREATE TABLE sectie_kinds ( |
250 id int PRIMARY KEY NOT NULL, | 250 id int PRIMARY KEY NOT NULL, |
251 name VARCHAR(64) NOT NULL | 251 name VARCHAR(64) NOT NULL |
252 ); | 252 ); |
253 INSERT INTO sectie_kinds (id, name) VALUES (0, 'Unbekannt'); | 253 INSERT INTO sectie_kinds (id, name) VALUES (0, 'SECTIE Unbekannt'); |
254 INSERT INTO sectie_kinds (id, name) VALUES (1, 'Flussschlauch'); | 254 INSERT INTO sectie_kinds (id, name) VALUES (1, 'Flussschlauch'); |
255 INSERT INTO sectie_kinds (id, name) VALUES (2, 'Uferbank'); | 255 INSERT INTO sectie_kinds (id, name) VALUES (2, 'Uferbank'); |
256 INSERT INTO sectie_kinds (id, name) VALUES (3, 'Überflutungsbereich'); | 256 INSERT INTO sectie_kinds (id, name) VALUES (3, 'Überflutungsbereich'); |
257 | 257 |
258 CREATE TABLE sobek_kinds ( | 258 CREATE TABLE sobek_kinds ( |
259 id int PRIMARY KEY NOT NULL, | 259 id int PRIMARY KEY NOT NULL, |
260 name VARCHAR(64) NOT NULL | 260 name VARCHAR(64) NOT NULL |
261 ); | 261 ); |
262 INSERT INTO sobek_kinds (id, name) VALUES (0, 'Unbekannt'); | 262 INSERT INTO sobek_kinds (id, name) VALUES (0, 'SOBEK Unbekannt'); |
263 INSERT INTO sobek_kinds (id, name) VALUES (1, 'Stromführend'); | 263 INSERT INTO sobek_kinds (id, name) VALUES (1, 'Stromführend'); |
264 INSERT INTO sobek_kinds (id, name) VALUES (2, 'Stromspeichernd'); | 264 INSERT INTO sobek_kinds (id, name) VALUES (2, 'Stromspeichernd'); |
265 | 265 |
266 CREATE TABLE boundary_kinds ( | 266 CREATE TABLE boundary_kinds ( |
267 id int PRIMARY KEY NOT NULL, | 267 id int PRIMARY KEY NOT NULL, |