[Mapbender-commits] r1981 - trunk/mapbender/resources/db/update

[svn_mapbender at osgeo.org]

Author: astrid_emde
Date: 2008-01-18 05:04:57 -0500 (Fri, 18 Jan 2008)
New Revision: 1981

Modified:
   trunk/mapbender/resources/db/update/update_postgresql_db.sql
Log:
dbchanges for mapbender 2.5

Modified: trunk/mapbender/resources/db/update/update_postgresql_db.sql
===================================================================
--- trunk/mapbender/resources/db/update/update_postgresql_db.sql	2008-01-17 13:37:27 UTC (rev 1980)
+++ trunk/mapbender/resources/db/update/update_postgresql_db.sql	2008-01-18 10:04:57 UTC (rev 1981)
@@ -55,11 +55,14 @@
 -- grant root access to default wfs
 UPDATE wfs SET wfs_owner = 1;
 
-
+--
+-- new table gui_wfs_conf
+--
 CREATE TABLE gui_wfs_conf (
     fkey_gui_id character varying(50) DEFAULT ''::character varying NOT NULL,
     fkey_wfs_conf_id integer DEFAULT 0 NOT NULL
 );
+
 ALTER TABLE ONLY gui_wfs_conf
     ADD CONSTRAINT pk_fkey_wfs_conf_id PRIMARY KEY (fkey_gui_id, fkey_wfs_conf_id);
    
@@ -91,9 +94,15 @@
 ALTER TABLE ONLY wfs_featuretype_keyword
     ADD CONSTRAINT fkey_featuretype_id_fkey_keyword_id FOREIGN KEY (fkey_featuretype_id) REFERENCES wfs_featuretype(featuretype_id) ON UPDATE CASCADE ON DELETE CASCADE;
 
+--
+-- new table layer_load_count
+--
+CREATE TABLE layer_load_count (
+ fkey_layer_id int4, 
+ load_count int8
+);
 
 
-
 --
 -- table wfs_conf_element: change in WFS configuration: access to geometries may now be restricted
 --
@@ -126,6 +135,8 @@
 
 CREATE INDEX msgid_idx ON translations(msgid);
 
+
+
 -- 
 -- new function gettext for easy translations
 -- 
@@ -204,4 +215,25 @@
 INSERT INTO translations (locale, msgid, msgstr) VALUES ('de ', 'Logo', 'Logo');
 INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Measure distance', 'Streckenabschnittsmessung');
 
+--
+-- new table gui_kml
+--
+CREATE TABLE gui_kml (
+    kml_id serial,
+    fkey_mb_user_id integer NOT NULL,
+    fkey_gui_id character varying(50) NOT NULL,
+    kml_doc text NOT NULL,
+    kml_name character varying(64),
+    kml_description text,
+    kml_timestamp integer NOT NULL
+);
 
+ALTER TABLE ONLY gui_kml
+    ADD CONSTRAINT mb_gui_kml_pkey PRIMARY KEY (kml_id);
+
+ALTER TABLE ONLY gui_kml
+    ADD CONSTRAINT gui_kml_fkey_mb_user_id FOREIGN KEY (fkey_mb_user_id) REFERENCES mb_user(mb_user_id) ON UPDATE CASCADE ON DELETE CASCADE;
+
+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;
+