Mercurial > dive4elements > river
diff flys-backend/doc/schema/postgresql.sql @ 1214:32ee9babe42c
Schema: Argh! Added distance_{vl|hf|vr} to
wrong table.
flys-backend/trunk@2340 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Fri, 15 Jul 2011 15:53:33 +0000 |
| parents | dd948530fd57 |
| children | d5e39c16fd2a |
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql.sql Fri Jul 15 15:36:59 2011 +0000 +++ b/flys-backend/doc/schema/postgresql.sql Fri Jul 15 15:53:33 2011 +0000 @@ -308,9 +308,6 @@ id int PRIMARY KEY NOT NULL, hyk_id int NOT NULL REFERENCES hyks(id), km NUMERIC NOT NULL, - distance_vl NUMERIC NOT NULL, - distance_hf NUMERIC NOT NULL, - distance_vr NUMERIC NOT NULL, UNIQUE (hyk_id, km) ); @@ -322,6 +319,9 @@ hyk_entry_id int NOT NULL REFERENCES hyk_entries(id), top NUMERIC NOT NULL, bottom NUMERIC NOT NULL, + distance_vl NUMERIC NOT NULL, + distance_hf NUMERIC NOT NULL, + distance_vr NUMERIC NOT NULL, UNIQUE (hyk_entry_id, formation_num) );