Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql.sql @ 1217:d5e39c16fd2a
Schema: Fixed location of 'Peilungsjahre' in HYKs
flys-backend/trunk@2343 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Sun, 17 Jul 2011 10:24:20 +0000 |
| parents | 32ee9babe42c |
| children | 1dbafbba50ea |
comparison
equal
deleted
inserted
replaced
| 1216:f8b5c37f15e4 | 1217:d5e39c16fd2a |
|---|---|
| 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, | |
| 302 description VARCHAR(256) NOT NULL | 301 description VARCHAR(256) NOT NULL |
| 303 ); | 302 ); |
| 304 | 303 |
| 305 CREATE SEQUENCE HYK_ENTRIES_ID_SEQ; | 304 CREATE SEQUENCE HYK_ENTRIES_ID_SEQ; |
| 306 | 305 |
| 307 CREATE TABLE hyk_entries ( | 306 CREATE TABLE hyk_entries ( |
| 308 id int PRIMARY KEY NOT NULL, | 307 id int PRIMARY KEY NOT NULL, |
| 309 hyk_id int NOT NULL REFERENCES hyks(id), | 308 hyk_id int NOT NULL REFERENCES hyks(id), |
| 310 km NUMERIC NOT NULL, | 309 km NUMERIC NOT NULL, |
| 310 measure TIMESTAMP, | |
| 311 UNIQUE (hyk_id, km) | 311 UNIQUE (hyk_id, km) |
| 312 ); | 312 ); |
| 313 | 313 |
| 314 CREATE SEQUENCE HYK_FORMATIONS_ID_SEQ; | 314 CREATE SEQUENCE HYK_FORMATIONS_ID_SEQ; |
| 315 | 315 |