Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql-spatial.sql @ 5013:eecd1ebba128 dami
SCHEMA CHANGE: removed obsolete table 'lines' from spatial schema (now 'hws_lines')
| author | Tom Gottfried <tom.gottfried@intevation.de> |
|---|---|
| date | Tue, 19 Feb 2013 09:57:57 +0100 |
| parents | ee52faa6b7ac |
| children | 808718c6de97 |
comparison
equal
deleted
inserted
replaced
| 5010:ee52faa6b7ac | 5013:eecd1ebba128 |
|---|---|
| 37 name VARCHAR(64), | 37 name VARCHAR(64), |
| 38 path VARCHAR(256) | 38 path VARCHAR(256) |
| 39 ); | 39 ); |
| 40 SELECT AddGeometryColumn('cross_section_tracks', 'geom', 31467, 'LINESTRING', 2); | 40 SELECT AddGeometryColumn('cross_section_tracks', 'geom', 31467, 'LINESTRING', 2); |
| 41 ALTER TABLE cross_section_tracks ALTER COLUMN id SET DEFAULT NEXTVAL('CROSS_SECTION_TRACKS_ID_SEQ'); | 41 ALTER TABLE cross_section_tracks ALTER COLUMN id SET DEFAULT NEXTVAL('CROSS_SECTION_TRACKS_ID_SEQ'); |
| 42 | |
| 43 | |
| 44 -- Geodaesie/Linien/rohre-und-spreen | |
| 45 CREATE SEQUENCE LINES_ID_SEQ; | |
| 46 CREATE TABLE lines ( | |
| 47 id int PRIMARY KEY NOT NULL, | |
| 48 river_id int REFERENCES rivers(id) ON DELETE CASCADE, | |
| 49 kind VARCHAR(16) NOT NULL, | |
| 50 z FLOAT8 DEFAULT 0, | |
| 51 name VARCHAR(64), | |
| 52 path VARCHAR(256) | |
| 53 ); | |
| 54 SELECT AddGeometryColumn('lines', 'geom', 31467, 'LINESTRING', 3); | |
| 55 ALTER TABLE lines ALTER COLUMN id SET DEFAULT NEXTVAL('LINES_ID_SEQ'); | |
| 56 -- 'kind': | |
| 57 -- 0: ROHR1 | |
| 58 -- 1: DAMM | |
| 59 | 42 |
| 60 | 43 |
| 61 -- Geodaesie/Bauwerke/Wehre.shp | 44 -- Geodaesie/Bauwerke/Wehre.shp |
| 62 CREATE SEQUENCE BUILDINGS_ID_SEQ; | 45 CREATE SEQUENCE BUILDINGS_ID_SEQ; |
| 63 CREATE TABLE buildings ( | 46 CREATE TABLE buildings ( |