Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-spatial.sql @ 5162:94c3eb995bf6
Fixed broken insert statements for axis_kinds.
| author | Sascha L. Teichmann <teichmann@intevation.de> |
|---|---|
| date | Fri, 01 Mar 2013 20:52:31 +0100 |
| parents | a9658d43b621 |
| children | 31fd42400c84 |
comparison
equal
deleted
inserted
replaced
| 5161:a8d8ea1f2a5c | 5162:94c3eb995bf6 |
|---|---|
| 2 | 2 |
| 3 CREATE TABLE axis_kinds( | 3 CREATE TABLE axis_kinds( |
| 4 id NUMBER PRIMARY KEY NOT NULL, | 4 id NUMBER PRIMARY KEY NOT NULL, |
| 5 name VARCHAR(64) | 5 name VARCHAR(64) |
| 6 ); | 6 ); |
| 7 INSERT INTO axis_kinds(id, name, use_for_caclulation) VALUES (0, 'Unbekannt'); | 7 INSERT INTO axis_kinds(id, name) VALUES (0, 'Unbekannt'); |
| 8 INSERT INTO axis_kinds(id, name, use_for_caclulation) VALUES (1, 'Aktuell'); | 8 INSERT INTO axis_kinds(id, name) VALUES (1, 'Aktuell'); |
| 9 INSERT INTO axis_kinds(id, name, use_for_caclulation) VALUES (2, 'Sonstige'); | 9 INSERT INTO axis_kinds(id, name) VALUES (2, 'Sonstige'); |
| 10 | 10 |
| 11 -- Geodaesie/Flussachse+km/achse | 11 -- Geodaesie/Flussachse+km/achse |
| 12 CREATE SEQUENCE RIVER_AXES_ID_SEQ; | 12 CREATE SEQUENCE RIVER_AXES_ID_SEQ; |
| 13 CREATE TABLE river_axes( | 13 CREATE TABLE river_axes( |
| 14 OGR_FID NUMBER(38), | 14 OGR_FID NUMBER(38), |