Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql.sql @ 1212:dd948530fd57
Schema: Added missing columns in HYK tables.
flys-backend/trunk@2338 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Fri, 15 Jul 2011 14:33:12 +0000 |
| parents | c12b5fbd33e8 |
| children | 32ee9babe42c |
comparison
equal
deleted
inserted
replaced
| 1211:f08fe480092c | 1212:dd948530fd57 |
|---|---|
| 296 CREATE SEQUENCE HYKS_ID_SEQ; | 296 CREATE SEQUENCE HYKS_ID_SEQ; |
| 297 | 297 |
| 298 CREATE TABLE hyks ( | 298 CREATE TABLE hyks ( |
| 299 id int PRIMARY KEY NOT NULL, | 299 id int PRIMARY KEY NOT NULL, |
| 300 river_id int NOT NULL, | 300 river_id int NOT NULL, |
| 301 measure TIMESTAMP, | |
| 301 description VARCHAR(256) NOT NULL | 302 description VARCHAR(256) NOT NULL |
| 302 ); | 303 ); |
| 303 | 304 |
| 304 CREATE SEQUENCE HYK_ENTRIES_ID_SEQ; | 305 CREATE SEQUENCE HYK_ENTRIES_ID_SEQ; |
| 305 | 306 |
| 306 CREATE TABLE hyk_entries ( | 307 CREATE TABLE hyk_entries ( |
| 307 id int PRIMARY KEY NOT NULL, | 308 id int PRIMARY KEY NOT NULL, |
| 308 hyk_id int NOT NULL REFERENCES hyks(id), | 309 hyk_id int NOT NULL REFERENCES hyks(id), |
| 309 km NUMERIC NOT NULL, | 310 km NUMERIC NOT NULL, |
| 311 distance_vl NUMERIC NOT NULL, | |
| 312 distance_hf NUMERIC NOT NULL, | |
| 313 distance_vr NUMERIC NOT NULL, | |
| 310 UNIQUE (hyk_id, km) | 314 UNIQUE (hyk_id, km) |
| 311 ); | 315 ); |
| 312 | 316 |
| 313 CREATE SEQUENCE HYK_FORMATIONS_ID_SEQ; | 317 CREATE SEQUENCE HYK_FORMATIONS_ID_SEQ; |
| 314 | 318 |