[Mapbender-commits] r1955 - branches/mapbender_sld/resources/db/mysql

[svn_mapbender at osgeo.org]

Author: mschulz
Date: 2008-01-09 10:04:49 -0500 (Wed, 09 Jan 2008)
New Revision: 1955

Modified:
   branches/mapbender_sld/resources/db/mysql/mysql_schema.sql
Log:
added mysql sld definitions

Modified: branches/mapbender_sld/resources/db/mysql/mysql_schema.sql
===================================================================
--- branches/mapbender_sld/resources/db/mysql/mysql_schema.sql	2008-01-09 13:13:33 UTC (rev 1954)
+++ branches/mapbender_sld/resources/db/mysql/mysql_schema.sql	2008-01-09 15:04:49 UTC (rev 1955)
@@ -167,6 +167,7 @@
   gui_wms_exceptionformat varchar(50) NOT NULL default '',
   gui_wms_epsg varchar(50) NOT NULL default '',
   gui_wms_visible smallint(6) NOT NULL default '1',
+  gui_wms_sldurl varchar(255) NOT NULL default '',
   KEY gui_index (fkey_gui_id),
   KEY wms_index (fkey_wms_id)
 ) TYPE=InnoDB;
@@ -333,6 +334,22 @@
 
 -- --------------------------------------------------------
 
+-- 
+-- SLD Editor data table
+--
+
+CREATE TABLE sld_user_layer (
+    sld_user_layer_id int(11) NOT NULL auto_increment,
+    fkey_mb_user_id int(11) NOT NULL default '0',
+    fkey_layer_id int(11) NOT NULL default '0',
+    fkey_gui_id varchar(50) NOT NULL default '',
+    sld_xml text,
+    use_sld tinyint(1) default '0',
+    PRIMARY KEY (sld_user_layer_id)
+) TYPE=InnoDB;
+
+-- --------------------------------------------------------
+
  -- 
  -- new table translation: new table for translations
  -- 
@@ -707,6 +724,10 @@
 ALTER TABLE wms ADD wms_mb_getcapabilies_doc text NULL;
 ALTER TABLE wms ADD wms_owner int(11) NULL;
 ALTER TABLE wms ADD wms_timestamp int(11) NULL;
+ALTER TABLE wms ADD wms_supportsld boolean NULL;
+ALTER TABLE wms ADD wms_userlayer boolean NULL;
+ALTER TABLE wms ADD wms_userstyle boolean NULL;
+ALTER TABLE wms ADD wms_remotewfs boolean NULL;
 ALTER TABLE layer ADD layer_abstract text NULL;
 
 
@@ -737,6 +758,13 @@
 ADD CONSTRAINT wms_md_topic_category_fkey_wms_id_fkey  FOREIGN KEY (fkey_wms_id)
 REFERENCES wms (wms_id) MATCH SIMPLE ON UPDATE CASCADE ON DELETE CASCADE;
 
+-- constraints for new table sld_user_layer
+ALTER TABLE sld_user_layer
+  ADD CONSTRAINT sld_user_layer_ibfk1 FOREIGN KEY (fkey_mb_user_id) REFERENCES mb_user (mb_user_id) ON DELETE CASCADE ON UPDATE CASCADE,
+  ADD CONSTRAINT sld_user_layer_ibfk2 FOREIGN KEY (fkey_layer_id) REFERENCES layer (layer_id) ON DELETE CASCADE ON UPDATE CASCADE,
+  ADD CONSTRAINT sld_user_layer_ibfk3 FOREIGN KEY (fkey_gui_id) REFERENCES gui (gui_id) ON DELETE CASCADE ON UPDATE CASCADE;
+
+
 -- wms_owner has to be set
 -- Update wms set wms_owner =1;