[Mapbender-commits] r1930 - branches/mapbender_sld/resources/db/update

[svn_mapbender at osgeo.org]

Author: mschulz
Date: 2007-12-18 09:35:47 -0500 (Tue, 18 Dec 2007)
New Revision: 1930

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

Modified: branches/mapbender_sld/resources/db/update/update_postgresql_db.sql
===================================================================
--- branches/mapbender_sld/resources/db/update/update_postgresql_db.sql	2007-12-18 14:28:19 UTC (rev 1929)
+++ branches/mapbender_sld/resources/db/update/update_postgresql_db.sql	2007-12-18 14:35:47 UTC (rev 1930)
@@ -203,5 +203,32 @@
 INSERT INTO translations (locale, msgid, msgstr) VALUES ('de ', 'Logo', 'Logo');
 INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Measure distance', 'Streckenabschnittsmessung');
 
+--
+-- new sld_user_layer 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
+);
+ALTER TABLE sld_user_layer ADD CONSTRAINT pk_sld_user_layer PRIMARY KEY  (sld_user_layer_id);
+--
+-- 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;