Mercurial > dive4elements > gnv-client
diff gnv-artifacts/doc/schema/externalinterface_schema.sql @ 494:292f0c8d356c
Do some Bugfixes after testing the Schema and Testdata against an Oracle 10.2 DBMS.
gnv-artifacts/trunk@571 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Tue, 19 Jan 2010 12:45:51 +0000 |
| parents | be53566c1640 |
| children | 4c6d2b4df3ae |
line wrap: on
line diff
--- a/gnv-artifacts/doc/schema/externalinterface_schema.sql Tue Jan 19 10:58:46 2010 +0000 +++ b/gnv-artifacts/doc/schema/externalinterface_schema.sql Tue Jan 19 12:45:51 2010 +0000 @@ -52,9 +52,6 @@ ALTER TABLE layer_has_parameter ADD PRIMARY KEY (id_mapservice,id_layer,id_parameter); -ALTER TABLE layer_has_parameter ADD (CONSTRAINT fk_layer_has_parameter1) - FOREIGN KEY (id_mapservice) - REFERENCES fis_has_mapservice(id_mapservice); /** * Lookuptabelle ob ein Mapservice genau einen Parameter darstellt.