Mercurial > dive4elements > gnv-client
changeset 601:4c6d2b4df3ae
Changes id_layer of Table layerhasparameter from literal to number.
gnv-artifacts/trunk@659 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Tim Englich <tim.englich@intevation.de> |
|---|---|
| date | Fri, 05 Feb 2010 10:36:46 +0000 |
| parents | cf4ddf41197f |
| children | 6409847e203e |
| files | gnv-artifacts/ChangeLog gnv-artifacts/doc/schema/externalinterface_schema.sql gnv-artifacts/doc/schema/externalinterface_testdata.sql |
| diffstat | 3 files changed, 17 insertions(+), 6 deletions(-) [+] |
line wrap: on
line diff
--- a/gnv-artifacts/ChangeLog Fri Feb 05 09:58:50 2010 +0000 +++ b/gnv-artifacts/ChangeLog Fri Feb 05 10:36:46 2010 +0000 @@ -1,5 +1,15 @@ 2010-02-05 Tim Englich <tim.englich@intevation.de> + * doc/schema/externalinterface_testdata.sql: + Changed the Testdata for layerhasparameter according to the the changes of + the Tablestructure. + * doc/schema/externalinterface_schema.sql: + Changed id_layer Column in Table layerhasparameter from literal to number. + And added Column Layername to this Table. + This is nessessary because the Identifcation of an Layer is not the name + but the ID. + +2010-02-05 Tim Englich <tim.englich@intevation.de> * doc/conf/products/horizontalcrosssection/conf_mesh.xml: ISSUE167 Fixed Bug in Konfiguration. Now Regionfilters can be used without running
--- a/gnv-artifacts/doc/schema/externalinterface_schema.sql Fri Feb 05 09:58:50 2010 +0000 +++ b/gnv-artifacts/doc/schema/externalinterface_schema.sql Fri Feb 05 10:36:46 2010 +0000 @@ -45,7 +45,8 @@ */ create table layer_has_parameter( id_mapservice varchar2(100 char) not null, /* TODO maximale Länge bestimmen und ggf. anpassen.*/ - id_layer varchar2(30 char) not null, /* TODO maximale Länge bestimmen und ggf. anpassen.*/ + id_layer NUMBER(10) not null, /* TODO maximale Länge bestimmen und ggf. anpassen.*/ + layer_name varchar2(30 char) not null, /* TODO maximale Länge bestimmen und ggf. anpassen.*/ id_group varchar2(30 char ), /* TODO maximale Länge bestimmen und ggf. anpassen.*/ id_parameter NUMBER(10) not null /* Referenz zur Tabelle MEDIAN.PARAMETER */ );
--- a/gnv-artifacts/doc/schema/externalinterface_testdata.sql Fri Feb 05 09:58:50 2010 +0000 +++ b/gnv-artifacts/doc/schema/externalinterface_testdata.sql Fri Feb 05 10:36:46 2010 +0000 @@ -3,8 +3,8 @@ INSERT INTO mapservice_has_parameter(id_mapservice,id_parameter) VALUES ('BSH_IMS_Prediction_Model_Salinity',2); -INSERT INTO layer_has_parameter(id_mapservice,id_layer,id_group,id_parameter) VALUES ('BSH_IMS_Marine_Environment_Monitoring_Network', 'Sealevel', null, ?); -INSERT INTO layer_has_parameter(id_mapservice,id_layer,id_group,id_parameter) VALUES ('BSH_IMS_Marine_Environment_Monitoring_Network', 'Temperature', null, 1); -INSERT INTO layer_has_parameter(id_mapservice,id_layer,id_group,id_parameter) VALUES ('BSH_IMS_Marine_Environment_Monitoring_Network', 'Salinity', null, 2); -INSERT INTO layer_has_parameter(id_mapservice,id_layer,id_group,id_parameter) VALUES ('BSH_IMS_Marine_Environment_Monitoring_Network', 'OxygenSaturation', null, 31); -INSERT INTO layer_has_parameter(id_mapservice,id_layer,id_group,id_parameter) VALUES ('BSH_IMS_Marine_Environment_Monitoring_Network', 'Current', null, ?); \ No newline at end of file +INSERT INTO layer_has_parameter(id_mapservice,id_layer,layer_name,id_group,id_parameter) VALUES ('BSH_IMS_Marine_Environment_Monitoring_Network', 1, 'Sealevel', null, ?); +INSERT INTO layer_has_parameter(id_mapservice,id_layer,layer_name,id_group,id_parameter) VALUES ('BSH_IMS_Marine_Environment_Monitoring_Network', 2, 'Temperature', null, 1); +INSERT INTO layer_has_parameter(id_mapservice,id_layer,layer_name,id_group,id_parameter) VALUES ('BSH_IMS_Marine_Environment_Monitoring_Network', 3, 'Salinity', null, 2); +INSERT INTO layer_has_parameter(id_mapservice,id_layer,layer_name,id_group,id_parameter) VALUES ('BSH_IMS_Marine_Environment_Monitoring_Network', 4, 'OxygenSaturation', null, 31); +INSERT INTO layer_has_parameter(id_mapservice,id_layer,layer_name,id_group,id_parameter) VALUES ('BSH_IMS_Marine_Environment_Monitoring_Network', 5, 'Current', null, ?); \ No newline at end of file