tim@489: INSERT INTO fis_has_mapservice (id_fis,id_mapservice) VALUES
tim@489: ('modeldata','BSH_IMS_Prediction_Model_Salinity'),
tim@489: ('marnet','BSH_IMS_Marine_Environment_Monitoring_Network');
tim@489: 
tim@489: INSERT INTO mapservice_has_parameter(id_mapservice,id_parameter) VALUES
tim@489: ('BSH_IMS_Prediction_Model_Salinity',2);
tim@489: 
tim@489: INSERT INTO layer_has_parameter(id_mapservice,id_layer,id_group,id_parameter) VALUES
tim@489: ('BSH_IMS_Marine_Environment_Monitoring_Network', 'Sealevel', null, ?),
tim@489: ('BSH_IMS_Marine_Environment_Monitoring_Network', 'Temperature', null, 1),
tim@489: ('BSH_IMS_Marine_Environment_Monitoring_Network', 'Salinity', null, 2),
tim@489: ('BSH_IMS_Marine_Environment_Monitoring_Network', 'OxygenSaturation', null, 31),
tim@489: ('BSH_IMS_Marine_Environment_Monitoring_Network', 'Current', null, ?);