Mercurial > dive4elements > river
changeset 470:f4afea9b7537
Forget ',' in schema.
flys-backend/trunk@1709 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Fri, 15 Apr 2011 15:28:35 +0000 |
| parents | b5ca22aae092 |
| children | 3570e4af8cb2 |
| files | flys-backend/ChangeLog flys-backend/doc/schema/postgresql.sql |
| diffstat | 2 files changed, 6 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- a/flys-backend/ChangeLog Fri Apr 15 14:30:54 2011 +0000 +++ b/flys-backend/ChangeLog Fri Apr 15 15:28:35 2011 +0000 @@ -1,3 +1,7 @@ +2011-04-15 Sascha L. Teichmann <sascha.teichmann@intevation.de> + + * doc/schema/postgresql.sql: Forget ',' in schema. + 2011-04-15 Sascha L. Teichmann <sascha.teichmann@intevation.de> * src/main/java/de/intevation/flys/model/Wst.java (determineMinMaxQ):
--- a/flys-backend/doc/schema/postgresql.sql Fri Apr 15 14:30:54 2011 +0000 +++ b/flys-backend/doc/schema/postgresql.sql Fri Apr 15 15:28:35 2011 +0000 @@ -114,7 +114,7 @@ CREATE TABLE discharge_tables ( id int PRIMARY KEY NOT NULL, gauge_id int NOT NULL REFERENCES gauges(id), - kind int NOT NULL DEFAULT 0 + kind int NOT NULL DEFAULT 0, time_interval_id int REFERENCES time_intervals(id), -- TODO: better checks @@ -140,7 +140,7 @@ id int PRIMARY KEY NOT NULL, river_id int NOT NULL REFERENCES rivers(id), description VARCHAR(256) NOT NULL, - kind int NOT NULL DEFAULT 0 + kind int NOT NULL DEFAULT 0, -- TODO: more meta infos UNIQUE (river_id, description) );