[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