[Mapbender-commits] r2062 - in branches/2.5/resources/db: mysql
postgresql update
svn_mapbender at osgeo.org
svn_mapbender at osgeo.org
Tue Feb 5 16:36:54 EST 2008
Author: mschulz
Date: 2008-02-05 16:36:54 -0500 (Tue, 05 Feb 2008)
New Revision: 2062
Modified:
branches/2.5/resources/db/mysql/mysql_schema.sql
branches/2.5/resources/db/postgresql/pgsql_schema.sql
branches/2.5/resources/db/update/update_mysql_db.sql
branches/2.5/resources/db/update/update_postgresql_db.sql
Log:
added sld related changes
Modified: branches/2.5/resources/db/mysql/mysql_schema.sql
===================================================================
--- branches/2.5/resources/db/mysql/mysql_schema.sql 2008-02-05 15:00:27 UTC (rev 2061)
+++ branches/2.5/resources/db/mysql/mysql_schema.sql 2008-02-05 21:36:54 UTC (rev 2062)
@@ -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,12 @@
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;
Modified: branches/2.5/resources/db/postgresql/pgsql_schema.sql
===================================================================
--- branches/2.5/resources/db/postgresql/pgsql_schema.sql 2008-02-05 15:00:27 UTC (rev 2061)
+++ branches/2.5/resources/db/postgresql/pgsql_schema.sql 2008-02-05 21:36:54 UTC (rev 2062)
@@ -153,7 +153,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,19 @@
md_topic_category_code_de character varying(255)
);
+--
+-- 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
--
@@ -1065,7 +1078,30 @@
ALTER TABLE ONLY wms_srs
ADD CONSTRAINT wms_srs_ibfk_1 FOREIGN KEY (fkey_wms_id) REFERENCES wms(wms_id) ON UPDATE CASCADE ON DELETE CASCADE;
+--
+-- 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;
+
+
--
-- add missing primary keys
@@ -1092,6 +1128,7 @@
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
Modified: branches/2.5/resources/db/update/update_mysql_db.sql
===================================================================
--- branches/2.5/resources/db/update/update_mysql_db.sql 2008-02-05 15:00:27 UTC (rev 2061)
+++ branches/2.5/resources/db/update/update_mysql_db.sql 2008-02-05 21:36:54 UTC (rev 2062)
@@ -154,3 +154,30 @@
ADD CONSTRAINT gui_kml_id_fkey_gui_id FOREIGN KEY (fkey_gui_id)
REFERENCES gui(gui_id) MATCH SIMPLE ON UPDATE CASCADE ON DELETE CASCADE;
+--
+-- new SLD 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;
+
+-- 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;
+
+--
+-- add sld related columns
+--
+ALTER TABLE gui_wms ADD COLUMN gui_wms_sldurl varchar(255) NOT NULL default '';
+ALTER TABLE wms ADD COLUMN wms_supportsld boolean NULL;
+ALTER TABLE wms ADD COLUMN wms_userlayer boolean NULL;
+ALTER TABLE wms ADD COLUMN wms_userstyle boolean NULL;
+ALTER TABLE wms ADD COLUMN wms_remotewfs boolean NULL;
\ No newline at end of file
Modified: branches/2.5/resources/db/update/update_postgresql_db.sql
===================================================================
--- branches/2.5/resources/db/update/update_postgresql_db.sql 2008-02-05 15:00:27 UTC (rev 2061)
+++ branches/2.5/resources/db/update/update_postgresql_db.sql 2008-02-05 21:36:54 UTC (rev 2062)
@@ -240,3 +240,38 @@
ALTER TABLE ONLY gui_kml
ADD CONSTRAINT gui_kml_id_fkey_gui_id FOREIGN KEY (fkey_gui_id) REFERENCES gui(gui_id) ON UPDATE CASCADE ON DELETE CASCADE;
+--
+-- 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;
+--
+-- add sld related columns
+--
+alter table gui_wms add column gui_wms_sldurl character varying(255) DEFAULT ''::character varying NOT NULL;
+alter table wms add column wms_supportsld boolean;
+alter table wms add column wms_userlayer boolean;
+alter table wms add column wms_userstyle boolean;
+alter table wms add column wms_remotewfs boolean;
More information about the Mapbender_commits
mailing list