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 (2010-02-05)
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

http://dive4elements.wald.intevation.org