Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/doc/schema/externalinterface_testdata.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 | 3784cf498ab7 |
| children | 4c6d2b4df3ae |
comparison
equal
deleted
inserted
replaced
| 493:cef17cc90fd0 | 494:292f0c8d356c |
|---|---|
| 1 INSERT INTO fis_has_mapservice (id_fis,id_mapservice) VALUES | 1 INSERT INTO fis_has_mapservice (id_fis,id_mapservice) VALUES ('modeldata','BSH_IMS_Prediction_Model_Salinity'); |
| 2 ('modeldata','BSH_IMS_Prediction_Model_Salinity'), | 2 INSERT INTO fis_has_mapservice (id_fis,id_mapservice) VALUES ('marnet','BSH_IMS_Marine_Environment_Monitoring_Network'); |
| 3 ('marnet','BSH_IMS_Marine_Environment_Monitoring_Network'); | |
| 4 | 3 |
| 5 INSERT INTO mapservice_has_parameter(id_mapservice,id_parameter) VALUES | 4 INSERT INTO mapservice_has_parameter(id_mapservice,id_parameter) VALUES ('BSH_IMS_Prediction_Model_Salinity',2); |
| 6 ('BSH_IMS_Prediction_Model_Salinity',2); | |
| 7 | 5 |
| 8 INSERT INTO layer_has_parameter(id_mapservice,id_layer,id_group,id_parameter) VALUES | 6 INSERT INTO layer_has_parameter(id_mapservice,id_layer,id_group,id_parameter) VALUES ('BSH_IMS_Marine_Environment_Monitoring_Network', 'Sealevel', null, ?); |
| 9 ('BSH_IMS_Marine_Environment_Monitoring_Network', 'Sealevel', null, ?), | 7 INSERT INTO layer_has_parameter(id_mapservice,id_layer,id_group,id_parameter) VALUES ('BSH_IMS_Marine_Environment_Monitoring_Network', 'Temperature', null, 1); |
| 10 ('BSH_IMS_Marine_Environment_Monitoring_Network', 'Temperature', null, 1), | 8 INSERT INTO layer_has_parameter(id_mapservice,id_layer,id_group,id_parameter) VALUES ('BSH_IMS_Marine_Environment_Monitoring_Network', 'Salinity', null, 2); |
| 11 ('BSH_IMS_Marine_Environment_Monitoring_Network', 'Salinity', null, 2), | 9 INSERT INTO layer_has_parameter(id_mapservice,id_layer,id_group,id_parameter) VALUES ('BSH_IMS_Marine_Environment_Monitoring_Network', 'OxygenSaturation', null, 31); |
| 12 ('BSH_IMS_Marine_Environment_Monitoring_Network', 'OxygenSaturation', null, 31), | 10 INSERT INTO layer_has_parameter(id_mapservice,id_layer,id_group,id_parameter) VALUES ('BSH_IMS_Marine_Environment_Monitoring_Network', 'Current', null, ?); |
| 13 ('BSH_IMS_Marine_Environment_Monitoring_Network', 'Current', null, ?); |