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

[svn_mapbender at osgeo.org]

Author: mschulz
Date: 2007-07-12 12:06:31 -0400 (Thu, 12 Jul 2007)
New Revision: 1490

Modified:
   branches/mapbender_sld/resources/db/mysql/mysql_schema.sql
Log:
added sld relevant fields/tables

Modified: branches/mapbender_sld/resources/db/mysql/mysql_schema.sql
===================================================================
--- branches/mapbender_sld/resources/db/mysql/mysql_schema.sql	2007-07-12 16:02:53 UTC (rev 1489)
+++ branches/mapbender_sld/resources/db/mysql/mysql_schema.sql	2007-07-12 16:06:31 UTC (rev 1490)
@@ -166,6 +166,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;
@@ -332,7 +333,22 @@
 
 -- --------------------------------------------------------
 
+-- 
+-- Tabellenstruktur für Tabelle `sld_user_layer`
 --
+
+CREATE TABLE sld_user_layer (
+    id int(11) NOT NULL auto_increment,
+    mb_user_id int(11) NOT NULL default '0',
+    layer_id int(11) NOT NULL default '0',
+    sld_xml longtext default NULL,
+    use_sld int(4) default NULL,
+    PRIMARY KEY  (id)
+) TYPE=InnoDB;
+
+-- --------------------------------------------------------
+
+--
 -- Tabellenstruktur für Tabelle `wfs`
 --