Mercurial > dive4elements > gnv-client
annotate gnv-artifacts/doc/schema/externalinterface_testdata.sql @ 489:3784cf498ab7
Added Database-Schema and Testdata for the MapViewer-Interface
gnv-artifacts/trunk@565 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Mon, 18 Jan 2010 14:17:25 +0000 |
| parents | |
| children | 292f0c8d356c |
| rev | line source |
|---|---|
|
489
3784cf498ab7
Added Database-Schema and Testdata for the MapViewer-Interface
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
1 INSERT INTO fis_has_mapservice (id_fis,id_mapservice) VALUES |
|
3784cf498ab7
Added Database-Schema and Testdata for the MapViewer-Interface
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
2 ('modeldata','BSH_IMS_Prediction_Model_Salinity'), |
|
3784cf498ab7
Added Database-Schema and Testdata for the MapViewer-Interface
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
3 ('marnet','BSH_IMS_Marine_Environment_Monitoring_Network'); |
|
3784cf498ab7
Added Database-Schema and Testdata for the MapViewer-Interface
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
4 |
|
3784cf498ab7
Added Database-Schema and Testdata for the MapViewer-Interface
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
5 INSERT INTO mapservice_has_parameter(id_mapservice,id_parameter) VALUES |
|
3784cf498ab7
Added Database-Schema and Testdata for the MapViewer-Interface
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
6 ('BSH_IMS_Prediction_Model_Salinity',2); |
|
3784cf498ab7
Added Database-Schema and Testdata for the MapViewer-Interface
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
7 |
|
3784cf498ab7
Added Database-Schema and Testdata for the MapViewer-Interface
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
8 INSERT INTO layer_has_parameter(id_mapservice,id_layer,id_group,id_parameter) VALUES |
|
3784cf498ab7
Added Database-Schema and Testdata for the MapViewer-Interface
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
9 ('BSH_IMS_Marine_Environment_Monitoring_Network', 'Sealevel', null, ?), |
|
3784cf498ab7
Added Database-Schema and Testdata for the MapViewer-Interface
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
10 ('BSH_IMS_Marine_Environment_Monitoring_Network', 'Temperature', null, 1), |
|
3784cf498ab7
Added Database-Schema and Testdata for the MapViewer-Interface
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
11 ('BSH_IMS_Marine_Environment_Monitoring_Network', 'Salinity', null, 2), |
|
3784cf498ab7
Added Database-Schema and Testdata for the MapViewer-Interface
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
12 ('BSH_IMS_Marine_Environment_Monitoring_Network', 'OxygenSaturation', null, 31), |
|
3784cf498ab7
Added Database-Schema and Testdata for the MapViewer-Interface
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
13 ('BSH_IMS_Marine_Environment_Monitoring_Network', 'Current', null, ?); |