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, |