Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql-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 int PRIMARY KEY NOT NULL, | 4 id int 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 ( |
| 39 CREATE TABLE cross_section_track_kinds( | 39 CREATE TABLE cross_section_track_kinds( |
| 40 id int PRIMARY KEY NOT NULL, | 40 id int PRIMARY KEY NOT NULL, |
| 41 name VARCHAR(64) | 41 name VARCHAR(64) |
| 42 ); | 42 ); |
| 43 INSERT INTO cross_section_track_kinds(id, name) VALUES (0, 'Sonstige'); | 43 INSERT INTO cross_section_track_kinds(id, name) VALUES (0, 'Sonstige'); |
| 44 INSERT INTO cross_section_track_kinds(id, name) VALUES (1, 'Aktuell'); | 44 INSERT INTO cross_section_track_kinds(id, name) VALUES (1, 'aktuelle Querprofilspuren'); |
| 45 | 45 |
| 46 CREATE SEQUENCE CROSS_SECTION_TRACKS_ID_SEQ; | 46 CREATE SEQUENCE CROSS_SECTION_TRACKS_ID_SEQ; |
| 47 CREATE TABLE cross_section_tracks ( | 47 CREATE TABLE cross_section_tracks ( |
| 48 id int PRIMARY KEY NOT NULL, | 48 id int PRIMARY KEY NOT NULL, |
| 49 river_id int REFERENCES rivers(id) ON DELETE CASCADE, | 49 river_id int REFERENCES rivers(id) ON DELETE CASCADE, |
| 100 CREATE TABLE floodplain_kinds( | 100 CREATE TABLE floodplain_kinds( |
| 101 id int PRIMARY KEY NOT NULL, | 101 id int PRIMARY KEY NOT NULL, |
| 102 name VARCHAR(64) | 102 name VARCHAR(64) |
| 103 ); | 103 ); |
| 104 INSERT INTO floodplain_kinds(id, name) VALUES (0, 'Sonstige'); | 104 INSERT INTO floodplain_kinds(id, name) VALUES (0, 'Sonstige'); |
| 105 INSERT INTO floodplain_kinds(id, name) VALUES (1, 'Aktuell'); | 105 INSERT INTO floodplain_kinds(id, name) VALUES (1, 'aktuelle Talaue'); |
| 106 | 106 |
| 107 CREATE SEQUENCE FLOODPLAIN_ID_SEQ; | 107 CREATE SEQUENCE FLOODPLAIN_ID_SEQ; |
| 108 CREATE TABLE floodplain ( | 108 CREATE TABLE floodplain ( |
| 109 id int PRIMARY KEY NOT NULL, | 109 id int PRIMARY KEY NOT NULL, |
| 110 river_id int REFERENCES rivers(id) ON DELETE CASCADE, | 110 river_id int REFERENCES rivers(id) ON DELETE CASCADE, |