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

[svn_mapbender at osgeo.org]

Author: mschulz
Date: 2007-07-12 12:02:53 -0400 (Thu, 12 Jul 2007)
New Revision: 1489

Modified:
   branches/mapbender_sld/resources/db/postgresql/pgsql_schema.sql
Log:
added sld relevant fields/tables

Modified: branches/mapbender_sld/resources/db/postgresql/pgsql_schema.sql
===================================================================
--- branches/mapbender_sld/resources/db/postgresql/pgsql_schema.sql	2007-07-12 15:43:49 UTC (rev 1488)
+++ branches/mapbender_sld/resources/db/postgresql/pgsql_schema.sql	2007-07-12 16:02:53 UTC (rev 1489)
@@ -152,7 +152,8 @@
     gui_wms_featureinfoformat character varying(50) DEFAULT ''::character varying NOT NULL,
     gui_wms_exceptionformat character varying(50) DEFAULT ''::character varying NOT NULL,
     gui_wms_epsg character varying(50) DEFAULT ''::character varying NOT NULL,
-    gui_wms_visible integer DEFAULT 1 NOT NULL
+    gui_wms_visible integer DEFAULT 1 NOT NULL,
+    gui_wms_sldurl character varying(255) DEFAULT ''::character varying NOT NULL
 );
 
 
@@ -355,7 +356,20 @@
 );
 
 
+-- 
+-- SLD Editor data table
 --
+
+CREATE TABLE sld_user_layer (
+    id serial NOT NULL,
+    mb_user_id integer NOT NULL,
+    layer_id integer NOT NULL,
+    sld_xml text,
+    use_sld smallint
+);
+
+
+--
 -- TOC entry 1262 (class 1259 OID 47913270)
 -- Dependencies: 4
 -- Name: wfs; Type: TABLE; Schema: public; Owner: admin; Tablespace: 
@@ -1080,3 +1094,5 @@
 
 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  (id);
+