[Mapbender-commits] r1981 - trunk/mapbender/resources/db/update
svn_mapbender at osgeo.org
svn_mapbender at osgeo.org
Fri Jan 18 05:04:58 EST 2008
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;
+
More information about the Mapbender_commits
mailing list