[Mapbender-commits] r1928 - branches/mapbender_sld/resources/db/postgresql

[svn_mapbender at osgeo.org]

Author: mschulz
Date: 2007-12-18 08:58:15 -0500 (Tue, 18 Dec 2007)
New Revision: 1928

Modified:
   branches/mapbender_sld/resources/db/postgresql/pgsql_schema.sql
Log:
merge: added missing sld table definition

Modified: branches/mapbender_sld/resources/db/postgresql/pgsql_schema.sql
===================================================================
--- branches/mapbender_sld/resources/db/postgresql/pgsql_schema.sql	2007-12-18 13:43:06 UTC (rev 1927)
+++ branches/mapbender_sld/resources/db/postgresql/pgsql_schema.sql	2007-12-18 13:58:15 UTC (rev 1928)
@@ -356,6 +356,19 @@
 );
 
 
+-- 
+-- SLD Editor data table
+--
+
+CREATE TABLE sld_user_layer (
+    sld_user_layer_id serial NOT NULL,
+    fkey_mb_user_id integer NOT NULL,
+    fkey_layer_id integer NOT NULL,
+    fkey_gui_id character varying,
+    sld_xml text,
+    use_sld smallint
+);
+
  -- 
  -- new table translation: new table for translations
  -- 
@@ -516,7 +529,11 @@
     contactelectronicmailaddress character varying(255),
     wms_mb_getcapabilies_doc text,
     wms_owner integer,
-    wms_timestamp integer
+    wms_timestamp integer,
+    wms_supportsld boolean,
+    wms_userlayer boolean,
+    wms_userstyle boolean,
+    wms_remotewfs boolean    
 );
 
 
@@ -967,6 +984,30 @@
 
 
 --
+-- Name: sld_user_layer_ibfk_1; Type: FK CONSTRAINT; Schema: public; Owner: admin
+--
+
+ALTER TABLE ONLY sld_user_layer
+    ADD CONSTRAINT sld_user_layer_ibfk_1 FOREIGN KEY (fkey_mb_user_id) REFERENCES mb_user(mb_user_id) ON UPDATE CASCADE ON DELETE CASCADE;
+
+
+--
+-- Name: sld_user_layer_ibfk_2; Type: FK CONSTRAINT; Schema: public; Owner: admin
+--
+
+ALTER TABLE ONLY sld_user_layer
+    ADD CONSTRAINT sld_user_layer_ibfk_2 FOREIGN KEY (fkey_layer_id) REFERENCES layer(layer_id) ON UPDATE CASCADE ON DELETE CASCADE;
+
+
+--
+-- Name: sld_user_layer_ibfk_3; Type: FK CONSTRAINT; Schema: public; Owner: admin
+--
+
+ALTER TABLE ONLY sld_user_layer
+    ADD CONSTRAINT sld_user_layer_ibfk_3 FOREIGN KEY (fkey_gui_id) REFERENCES gui(gui_id) ON UPDATE CASCADE ON DELETE CASCADE;
+
+
+--
 -- TOC entry 1771 (class 2606 OID 47913469)
 -- Dependencies: 1735 1264 1266
 -- Name: wfs_conf_element_ibfk_1; Type: FK CONSTRAINT; Schema: public; Owner: admin
@@ -1092,7 +1133,9 @@
 
 ALTER TABLE mb_log ADD CONSTRAINT pk_mb_log PRIMARY KEY  (id); 
 
+ALTER TABLE sld_user_layer ADD CONSTRAINT pk_sld_user_layer PRIMARY KEY  (sld_user_layer_id);
 
+
  -- 
  -- new function gettext for easy translations
  --