[Mapbender-commits] r4015 - in trunk/mapbender: . sql

[svn_mapbender at osgeo.org]

Author: verenadiewald
Date: 2009-06-09 10:48:36 -0400 (Tue, 09 Jun 2009)
New Revision: 4015

Added:
   trunk/mapbender/sql/
   trunk/mapbender/sql/insert_wfs_conf.sql
   trunk/mapbender/sql/insert_wfs_conf_element.sql
   trunk/mapbender/sql/update_wfs_conf.sql
   trunk/mapbender/sql/update_wfs_conf_element.sql
Log:
sqls for new wfs configuration

Added: trunk/mapbender/sql/insert_wfs_conf.sql
===================================================================
--- trunk/mapbender/sql/insert_wfs_conf.sql	                        (rev 0)
+++ trunk/mapbender/sql/insert_wfs_conf.sql	2009-06-09 14:48:36 UTC (rev 4015)
@@ -0,0 +1,16 @@
+INSERT INTO wfs_conf (
+	wfs_conf_abstract,
+	fkey_wfs_id,
+	fkey_featuretype_id,
+	g_label,
+	g_label_id,
+	g_button,
+	g_button_id,
+	g_style,
+	g_buffer,
+	g_res_style,
+	wfs_conf_description,
+	wfs_conf_type
+) VALUES (
+	$1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12
+)

Added: trunk/mapbender/sql/insert_wfs_conf_element.sql
===================================================================
--- trunk/mapbender/sql/insert_wfs_conf_element.sql	                        (rev 0)
+++ trunk/mapbender/sql/insert_wfs_conf_element.sql	2009-06-09 14:48:36 UTC (rev 4015)
@@ -0,0 +1,25 @@
+INSERT INTO wfs_conf_element (
+	fkey_wfs_conf_id,
+	f_id,
+	f_geom,
+	f_search,
+	f_pos,
+	f_style_id,
+	f_toupper,
+	f_label,
+	f_label_id,
+	f_show,
+	f_respos,
+	f_form_element_html,
+	f_edit,
+	f_mandatory,
+	f_auth_varname,
+	f_operator,
+	f_show_detail,
+	f_min_input,
+	f_helptext,
+	f_category_name
+) VALUES (
+	$1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, 
+	$13, $14, $15, $16, $17, $18, $19, $20
+)
\ No newline at end of file

Added: trunk/mapbender/sql/update_wfs_conf.sql
===================================================================
--- trunk/mapbender/sql/update_wfs_conf.sql	                        (rev 0)
+++ trunk/mapbender/sql/update_wfs_conf.sql	2009-06-09 14:48:36 UTC (rev 4015)
@@ -0,0 +1,12 @@
+UPDATE wfs_conf SET 
+wfs_conf_abstract = $1,
+g_label = $2,
+g_label_id = $3,
+g_button = $4,
+g_button_id = $5,
+g_style = $6,
+g_buffer = $7,
+g_res_style = $8,
+wfs_conf_description = $9,
+wfs_conf_type = $10
+WHERE wfs_conf_id = $11

Added: trunk/mapbender/sql/update_wfs_conf_element.sql
===================================================================
--- trunk/mapbender/sql/update_wfs_conf_element.sql	                        (rev 0)
+++ trunk/mapbender/sql/update_wfs_conf_element.sql	2009-06-09 14:48:36 UTC (rev 4015)
@@ -0,0 +1,20 @@
+UPDATE wfs_conf_element SET 
+f_geom = $1,
+f_search = $2,
+f_pos = $3,
+f_style_id = $4,
+f_toupper = $5,
+f_label = $6,
+f_label_id = $7,
+f_show = $8,
+f_respos = $9,
+f_form_element_html = $10,
+f_edit = $11,
+f_mandatory = $12,
+f_auth_varname = $13,
+f_operator = $14,
+f_show_detail = $15,
+f_min_input = $16,
+f_helptext = $17,
+f_category_name = $18
+WHERE f_id = $19
\ No newline at end of file