Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-spatial.sql @ 5495:1488227b97b7
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;
| author | Andre Heinecke <aheinecke@intevation.de> |
|---|---|
| date | Thu, 28 Mar 2013 12:38:06 +0100 |
| parents | 8b29a94ebdd8 |
| children | ef3517905e6e |
comparison
equal
deleted
inserted
replaced
| 5494:773899d00234 | 5495:1488227b97b7 |
|---|---|
| 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) VALUES (0, 'Unbekannt'); | 7 INSERT INTO axis_kinds(id, name) VALUES (0, 'Unbekannt'); |
| 8 INSERT INTO axis_kinds(id, name) VALUES (1, 'Aktuell'); | 8 INSERT INTO axis_kinds(id, name) VALUES (1, 'aktuelle Achse'); |
| 9 INSERT INTO axis_kinds(id, name) 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( |
| 52 CREATE TABLE cross_section_track_kinds( | 52 CREATE TABLE cross_section_track_kinds( |
| 53 id NUMBER PRIMARY KEY NOT NULL, | 53 id NUMBER PRIMARY KEY NOT NULL, |
| 54 name VARCHAR(64) | 54 name VARCHAR(64) |
| 55 ); | 55 ); |
| 56 INSERT INTO cross_section_track_kinds(id, name) VALUES (0, 'Sonstige'); | 56 INSERT INTO cross_section_track_kinds(id, name) VALUES (0, 'Sonstige'); |
| 57 INSERT INTO cross_section_track_kinds(id, name) VALUES (1, 'Aktuell'); | 57 INSERT INTO cross_section_track_kinds(id, name) VALUES (1, 'aktuelle Querprofilspuren'); |
| 58 | 58 |
| 59 CREATE SEQUENCE CROSS_SECTION_TRACKS_ID_SEQ; | 59 CREATE SEQUENCE CROSS_SECTION_TRACKS_ID_SEQ; |
| 60 CREATE TABLE cross_section_tracks ( | 60 CREATE TABLE cross_section_tracks ( |
| 61 OGR_FID NUMBER(38), | 61 OGR_FID NUMBER(38), |
| 62 GEOM MDSYS.SDO_GEOMETRY, | 62 GEOM MDSYS.SDO_GEOMETRY, |
| 135 CREATE TABLE floodplain_kinds( | 135 CREATE TABLE floodplain_kinds( |
| 136 id NUMBER PRIMARY KEY NOT NULL, | 136 id NUMBER PRIMARY KEY NOT NULL, |
| 137 name VARCHAR(64) | 137 name VARCHAR(64) |
| 138 ); | 138 ); |
| 139 INSERT INTO floodplain_kinds(id, name) VALUES (0, 'Sonstige'); | 139 INSERT INTO floodplain_kinds(id, name) VALUES (0, 'Sonstige'); |
| 140 INSERT INTO floodplain_kinds(id, name) VALUES (1, 'Aktuell'); | 140 INSERT INTO floodplain_kinds(id, name) VALUES (1, 'aktuelle Talaue'); |
| 141 | 141 |
| 142 CREATE SEQUENCE FLOODPLAIN_ID_SEQ; | 142 CREATE SEQUENCE FLOODPLAIN_ID_SEQ; |
| 143 CREATE TABLE floodplain( | 143 CREATE TABLE floodplain( |
| 144 OGR_FID NUMBER(38), | 144 OGR_FID NUMBER(38), |
| 145 GEOM MDSYS.SDO_GEOMETRY, | 145 GEOM MDSYS.SDO_GEOMETRY, |