[Mapbender-commits] r6782 -
trunk/mapbender/resources/db/pgsql/UTF-8/update
svn_mapbender at osgeo.org
svn_mapbender at osgeo.org
Mon Aug 23 05:02:46 EDT 2010
Author: armin11
Date: 2010-08-23 09:02:46 +0000 (Mon, 23 Aug 2010)
New Revision: 6782
Modified:
trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql
Log:
Adoptions to store urls to geodatasets in different formats (kml/georss) in the mapbender database. It should also be possible to chache this resources and serve them from mapbender.
Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql 2010-08-23 06:42:49 UTC (rev 6781)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql 2010-08-23 09:02:46 UTC (rev 6782)
@@ -608,9 +608,9 @@
-- jQuery UI
INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url)
-SELECT gui.gui_id,'jq_ui',1,1,'The jQuery UI core','','','','',NULL ,NULL ,NULL ,NULL ,NULL ,'','','','','../extensions/jquery-ui-1.7.2.custom/development-bundle/ui/min.ui.core.js','','',''
-FROM gui WHERE gui.gui_id NOT LIKE 'admin%' AND gui.gui_id NOT LIKE 'wms%' AND gui.gui_id
-NOT IN (SELECT fkey_gui_id FROM gui_element
+SELECT gui.gui_id,'jq_ui',1,1,'The jQuery UI core','','','','',NULL ,NULL ,NULL ,NULL ,NULL ,'','','','','../extensions/jquery-ui-1.7.2.custom/development-bundle/ui/min.ui.core.js','','',''
+FROM gui WHERE gui.gui_id NOT LIKE 'admin%' AND gui.gui_id NOT LIKE 'wms%' AND gui.gui_id
+NOT IN (SELECT fkey_gui_id FROM gui_element
WHERE e_id = 'jq_ui');
INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type)
@@ -2563,17 +2563,17 @@
-- draggable in map applications
INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url)
-SELECT gui.gui_id,'jq_ui_draggable',5,1,'Draggable from the jQuery UI framework','','','','',NULL ,NULL ,NULL ,NULL ,NULL ,'','','','','../extensions/jquery-ui-1.8.1.custom/development-bundle/ui/minified/jquery.ui.draggable.min.js','','jq_ui,jq_ui_mouse,jq_ui_widget','http://jqueryui.com/demos/draggable/'
-FROM gui WHERE gui.gui_id NOT LIKE 'admin%' AND gui.gui_id NOT LIKE 'wms%' AND gui.gui_id
-NOT IN (SELECT fkey_gui_id FROM gui_element
+SELECT gui.gui_id,'jq_ui_draggable',5,1,'Draggable from the jQuery UI framework','','','','',NULL ,NULL ,NULL ,NULL ,NULL ,'','','','','../extensions/jquery-ui-1.8.1.custom/development-bundle/ui/minified/jquery.ui.draggable.min.js','','jq_ui,jq_ui_mouse,jq_ui_widget','http://jqueryui.com/demos/draggable/'
+FROM gui WHERE gui.gui_id NOT LIKE 'admin%' AND gui.gui_id NOT LIKE 'wms%' AND gui.gui_id
+NOT IN (SELECT fkey_gui_id FROM gui_element
WHERE e_id = 'jq_ui_draggable');
-- resize map applications
INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url)
-SELECT gui.gui_id,'jq_ui_resizable',5,1,'Resizable from the jQuery UI framework','','','','',NULL ,NULL ,NULL ,NULL ,NULL ,'','','','../plugins/jq_ui_resizable.js','../extensions/jquery-ui-1.8.1.custom/development-bundle/ui/minified/jquery.ui.resizable.min.js','','jq_ui,jq_ui_mouse,jq_ui_widget','http://jqueryui.com/demos/resizable/'
-FROM gui WHERE gui.gui_id NOT LIKE 'admin%' AND gui.gui_id NOT LIKE 'wms%' AND gui.gui_id
-NOT IN (SELECT fkey_gui_id FROM gui_element
+SELECT gui.gui_id,'jq_ui_resizable',5,1,'Resizable from the jQuery UI framework','','','','',NULL ,NULL ,NULL ,NULL ,NULL ,'','','','../plugins/jq_ui_resizable.js','../extensions/jquery-ui-1.8.1.custom/development-bundle/ui/minified/jquery.ui.resizable.min.js','','jq_ui,jq_ui_mouse,jq_ui_widget','http://jqueryui.com/demos/resizable/'
+FROM gui WHERE gui.gui_id NOT LIKE 'admin%' AND gui.gui_id NOT LIKE 'wms%' AND gui.gui_id
+NOT IN (SELECT fkey_gui_id FROM gui_element
WHERE e_id = 'jq_ui_resizable');
-- add new column gui_layer_title
@@ -2581,3 +2581,84 @@
-- fill gui_layer_title with layer_titles from layer
UPDATE gui_layer SET gui_layer_title = (SELECT layer_title FROM layer WHERE gui_layer.fkey_layer_id = layer.layer_id);
+--adoptions for managing georss/kml urls and data in the mapbender database
+-- Table: datalink
+
+-- DROP TABLE datalink;
+
+CREATE TABLE datalink
+(
+ datalink_id serial NOT NULL,
+ datalink_type character varying(50) NOT NULL DEFAULT ''::character varying, --georss,kml,gml,geojson
+ datalink_type_version character varying(50) NOT NULL DEFAULT ''::character varying, --1.0,3.x?
+ datalink_url text,
+ datalink_owner integer,
+ datalink_timestamp integer,
+ datalink_timestamp_create integer,
+ datalink_timestamp_last_usage integer,
+ datalink_abstract text,
+ datalink_title character varying(255) NOT NULL DEFAULT ''::character varying,
+ datalink_data text, --maybe we want a data access for inspire and the data should stand on the geoportal cause the institutions have no webserver
+ --the following things have s.th. todo with metadata and maybe edited or filled or may not be present
+ datalink_network_access integer,
+ datalink_owsproxy character varying(50),
+ fees character varying(255),
+ accessconstraints text,
+ epsg character varying(50) NOT NULL DEFAULT ''::character varying,
+ minx double precision DEFAULT 0,
+ miny double precision DEFAULT 0,
+ maxx double precision DEFAULT 0,
+ maxy double precision DEFAULT 0,
+ CONSTRAINT pk_datalink_id PRIMARY KEY (datalink_id),
+--delete orphaned datalinks automatically
+ CONSTRAINT datalink_owner_fkey FOREIGN KEY (datalink_owner)
+ REFERENCES mb_user (mb_user_id) MATCH SIMPLE
+ ON UPDATE CASCADE ON DELETE CASCADE
+)
+WITH (
+ OIDS=FALSE
+);
+ALTER TABLE datalink OWNER TO postgres;
+
+
+-- Table: datalink_keyword
+
+-- DROP TABLE datalink_keyword;
+
+CREATE TABLE datalink_keyword
+(
+ fkey_datalink_id integer NOT NULL,
+ fkey_keyword_id integer NOT NULL,
+ CONSTRAINT pk_datalink_keyword PRIMARY KEY (fkey_datalink_id, fkey_keyword_id),
+ CONSTRAINT fkey_keyword_id_fkey_datalink_id FOREIGN KEY (fkey_keyword_id)
+ REFERENCES keyword (keyword_id) MATCH SIMPLE
+ ON UPDATE CASCADE ON DELETE CASCADE,
+ CONSTRAINT fkey_datalink_id_fkey_keyword_id FOREIGN KEY (fkey_datalink_id)
+ REFERENCES datalink (datalink_id) MATCH SIMPLE
+ ON UPDATE CASCADE ON DELETE CASCADE
+)
+WITH (
+ OIDS=FALSE
+);
+ALTER TABLE datalink_keyword OWNER TO postgres;
+
+-- Table: datalink_md_topic_category
+
+-- DROP TABLE datalink_md_topic_category;
+
+CREATE TABLE datalink_md_topic_category
+(
+ fkey_datalink_id integer NOT NULL,
+ fkey_md_topic_category_id integer NOT NULL,
+ CONSTRAINT datalink_md_topic_category_fkey_datalink_id_fkey FOREIGN KEY (fkey_datalink_id)
+ REFERENCES datalink (datalink_id) MATCH SIMPLE
+ ON UPDATE CASCADE ON DELETE CASCADE,
+ CONSTRAINT datalink_md_topic_category_fkey_md_topic_category_id_fkey FOREIGN KEY (fkey_md_topic_category_id)
+ REFERENCES md_topic_category (md_topic_category_id) MATCH SIMPLE
+ ON UPDATE CASCADE ON DELETE CASCADE
+)
+WITH (
+ OIDS=FALSE
+);
+ALTER TABLE datalink_md_topic_category OWNER TO postgres;
+
More information about the Mapbender_commits
mailing list