Mercurial > dive4elements > gnv-client

annotate gnv-artifacts/doc/schema/externalinterface_testdata.sql @ 557:05fcb3c553fd 0.4

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
merged geo-backend/0.4
author Thomas Arendsen Hein <thomas@intevation.de>
date Fri, 28 Sep 2012 12:13:50 +0200
parents 292f0c8d356c
children 4c6d2b4df3ae
rev   line source
494
292f0c8d356c Do some Bugfixes after testing the Schema and Testdata against an Oracle 10.2 DBMS.
Tim Englich <tim.englich@intevation.de>
parents: 489
diff changeset
1 INSERT INTO fis_has_mapservice (id_fis,id_mapservice) VALUES ('modeldata','BSH_IMS_Prediction_Model_Salinity');
292f0c8d356c Do some Bugfixes after testing the Schema and Testdata against an Oracle 10.2 DBMS.
Tim Englich <tim.englich@intevation.de>
parents: 489
diff changeset
2 INSERT INTO fis_has_mapservice (id_fis,id_mapservice) VALUES ('marnet','BSH_IMS_Marine_Environment_Monitoring_Network');
489
3784cf498ab7 Added Database-Schema and Testdata for the MapViewer-Interface
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
3
494
292f0c8d356c Do some Bugfixes after testing the Schema and Testdata against an Oracle 10.2 DBMS.
Tim Englich <tim.englich@intevation.de>
parents: 489
diff changeset
4 INSERT INTO mapservice_has_parameter(id_mapservice,id_parameter) VALUES ('BSH_IMS_Prediction_Model_Salinity',2);
489
3784cf498ab7 Added Database-Schema and Testdata for the MapViewer-Interface
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
5
494
292f0c8d356c Do some Bugfixes after testing the Schema and Testdata against an Oracle 10.2 DBMS.
Tim Englich <tim.englich@intevation.de>
parents: 489
diff changeset
6 INSERT INTO layer_has_parameter(id_mapservice,id_layer,id_group,id_parameter) VALUES ('BSH_IMS_Marine_Environment_Monitoring_Network', 'Sealevel', null, ?);
292f0c8d356c Do some Bugfixes after testing the Schema and Testdata against an Oracle 10.2 DBMS.
Tim Englich <tim.englich@intevation.de>
parents: 489
diff changeset
7 INSERT INTO layer_has_parameter(id_mapservice,id_layer,id_group,id_parameter) VALUES ('BSH_IMS_Marine_Environment_Monitoring_Network', 'Temperature', null, 1);
292f0c8d356c Do some Bugfixes after testing the Schema and Testdata against an Oracle 10.2 DBMS.
Tim Englich <tim.englich@intevation.de>
parents: 489
diff changeset
8 INSERT INTO layer_has_parameter(id_mapservice,id_layer,id_group,id_parameter) VALUES ('BSH_IMS_Marine_Environment_Monitoring_Network', 'Salinity', null, 2);
292f0c8d356c Do some Bugfixes after testing the Schema and Testdata against an Oracle 10.2 DBMS.
Tim Englich <tim.englich@intevation.de>
parents: 489
diff changeset
9 INSERT INTO layer_has_parameter(id_mapservice,id_layer,id_group,id_parameter) VALUES ('BSH_IMS_Marine_Environment_Monitoring_Network', 'OxygenSaturation', null, 31);
292f0c8d356c Do some Bugfixes after testing the Schema and Testdata against an Oracle 10.2 DBMS.
Tim Englich <tim.englich@intevation.de>
parents: 489
diff changeset
10 INSERT INTO layer_has_parameter(id_mapservice,id_layer,id_group,id_parameter) VALUES ('BSH_IMS_Marine_Environment_Monitoring_Network', 'Current', null, ?);
http://dive4elements.wald.intevation.org