Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-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 | 16afd4613f9d |
comparison
equal
deleted
inserted
replaced
| 5513:ef3517905e6e | 5514:4c4fed23693f |
|---|---|
| 240 -- HWS Points lookup tables | 240 -- HWS Points lookup tables |
| 241 CREATE TABLE sectie_kinds ( | 241 CREATE TABLE sectie_kinds ( |
| 242 id NUMBER PRIMARY KEY NOT NULL, | 242 id NUMBER PRIMARY KEY NOT NULL, |
| 243 name VARCHAR(64) NOT NULL | 243 name VARCHAR(64) NOT NULL |
| 244 ); | 244 ); |
| 245 INSERT INTO sectie_kinds (id, name) VALUES (0, 'Unbekannt'); | 245 INSERT INTO sectie_kinds (id, name) VALUES (0, 'SECTIE Unbekannt'); |
| 246 INSERT INTO sectie_kinds (id, name) VALUES (1, 'Flussschlauch'); | 246 INSERT INTO sectie_kinds (id, name) VALUES (1, 'Flussschlauch'); |
| 247 INSERT INTO sectie_kinds (id, name) VALUES (2, 'Uferbank'); | 247 INSERT INTO sectie_kinds (id, name) VALUES (2, 'Uferbank'); |
| 248 INSERT INTO sectie_kinds (id, name) VALUES (3, 'Überflutungsbereich'); | 248 INSERT INTO sectie_kinds (id, name) VALUES (3, 'Überflutungsbereich'); |
| 249 | 249 |
| 250 CREATE TABLE sobek_kinds ( | 250 CREATE TABLE sobek_kinds ( |
| 251 id NUMBER PRIMARY KEY NOT NULL, | 251 id NUMBER PRIMARY KEY NOT NULL, |
| 252 name VARCHAR(64) NOT NULL | 252 name VARCHAR(64) NOT NULL |
| 253 ); | 253 ); |
| 254 INSERT INTO sobek_kinds (id, name) VALUES (0, 'Unbekannt'); | 254 INSERT INTO sobek_kinds (id, name) VALUES (0, 'SOBEK Unbekannt'); |
| 255 INSERT INTO sobek_kinds (id, name) VALUES (1, 'Stromführend'); | 255 INSERT INTO sobek_kinds (id, name) VALUES (1, 'Stromführend'); |
| 256 INSERT INTO sobek_kinds (id, name) VALUES (2, 'Stromspeichernd'); | 256 INSERT INTO sobek_kinds (id, name) VALUES (2, 'Stromspeichernd'); |
| 257 | 257 |
| 258 CREATE TABLE boundary_kinds ( | 258 CREATE TABLE boundary_kinds ( |
| 259 id NUMBER PRIMARY KEY NOT NULL, | 259 id NUMBER PRIMARY KEY NOT NULL, |