[Mapbender-commits] r2013 - branches/2.5/resources/db/update

svn_mapbender at osgeo.org svn_mapbender at osgeo.org
Tue Jan 22 09:52:47 EST 2008 

Author: astrid_emde
Date: 2008-01-22 09:52:47 -0500 (Tue, 22 Jan 2008)
New Revision: 2013

Modified:
   branches/2.5/resources/db/update/update_mysql_db.sql
Log:
table translation inserts 

Modified: branches/2.5/resources/db/update/update_mysql_db.sql
===================================================================
--- branches/2.5/resources/db/update/update_mysql_db.sql	2008-01-22 14:17:51 UTC (rev 2012)
+++ branches/2.5/resources/db/update/update_mysql_db.sql	2008-01-22 14:52:47 UTC (rev 2013)
@@ -4,20 +4,63 @@
 -- notice language plpgsql has to be installed
 -- 
 
+INSERT INTO gui_mb_group (fkey_gui_id, fkey_mb_group_id, mb_group_type) VALUES ('admin_de_services', 20, '');
+INSERT INTO gui_mb_group (fkey_gui_id, fkey_mb_group_id, mb_group_type) VALUES ('admin_en_services', 20, '');
+
 --
+-- table mb_monitort: new columns for mb_monitor
+--
+ALTER TABLE mb_monitor ADD COLUMN image int(11);
+ALTER TABLE mb_monitor ADD COLUMN map_url varchar(2048);
+
+
+--
+-- WFS database handling
+-- enhancement of the datadase structure concerning WFS metadata (same solution like for WMS) 
+--
+ALTER table wfs add wfs_getcapabilities_doc text;
+ALTER table wfs add wfs_upload_url varchar(255);
+ALTER table wfs add fees varchar(255);
+ALTER table wfs add accessconstraints text;
+ALTER table wfs add individualname varchar(255);
+ALTER table wfs add positionname varchar(255);
+ALTER table wfs add providername varchar(255);
+ALTER table wfs add city varchar(255);
+ALTER table wfs add deliverypoint varchar(255);
+ALTER table wfs add administrativearea varchar(255);
+ALTER table wfs add postalcode varchar(255);
+ALTER table wfs add voice varchar(255);
+ALTER table wfs add facsimile varchar(255);
+ALTER table wfs add electronicmailaddress varchar(255);
+ALTER table wfs add wfs_mb_getcapabilities_doc text;
+ALTER table wfs add wfs_owner int(11);
+ALTER table wfs add wfs_timestamp int(11)
+ALTER table wfs add country varchar(255);
+
+
+--
 -- table wfs_conf_element: change in WFS configuration: access to geometries may now be restricted
 --
- ALTER TABLE wfs_conf_element ADD COLUMN f_auth_varname VARCHAR(50) NULL;
+ALTER TABLE wfs_conf_element ADD COLUMN f_auth_varname VARCHAR(50) NULL;
 ALTER TABLE wfs_conf_element ADD COLUMN f_show_detail int4;
 --
 -- table gui_element: new column for translation
 --
  ALTER TABLE gui_element ADD COLUMN e_title VARCHAR(255) NULL;
 
+
+--
+-- new table layer_load_count
+--
+CREATE TABLE layer_load_count (
+ fkey_layer_id int(11), 
+ load_count int(11)
+);
+
+
 -- 
 -- new table translation: new table for translations
 -- 
-
  CREATE TABLE translations
  (
    trs_id int(11) NOT NULL auto_increment,
@@ -40,40 +83,74 @@
 --
 
 INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Pan', 'Ausschnitt verschieben');
-INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Measure distance
-', 'Streckenabschnittsmessung');
 INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Display complete map', 'gesamte Karte anzeigen');
-INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Zoom in', 'ZoomIn');
-INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Zoom out', 'ZoomOut');
-INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Back', 'Zurück');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Zoom in', 'In die Karte hineinzoomen');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Zoom out', 'Aus der Karte herauszoomen');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Back', 'Zurück');
 INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Forward', 'Nach vorne');
 INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Coordinates', 'Koordinaten anzeigen');
-INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Zoom by rectangle', 'Ausschnitt wählen');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Zoom by rectangle', 'Ausschnitt wählen');
 INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Redraw', 'Neu laden oder Tastatur: Leertaste');
 INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Query', 'Datenabfrage');
-INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Change password', 'Passwort ändern');
-INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Logout', 'Ausgang');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Logout', 'Abmelden');
 INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'WMS preferences', 'WMS Einstellungen');
-INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Adding WMS', 'WMS hinzufgen');
-INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Adding WMS from List', 'WMS von Liste hinzufügen');
-INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Adding WMS from filtered list', 'WMS von gefilteter Liste hinzuf�gen');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Adding WMS from filtered list', 'WMS von gefilteter Liste hinzufügen');
 INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Set map center', 'Kartenmittelpunkt setzen');
 INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Help', 'Hilfe');
 INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Show WMS infos', 'Anzeige von WMS Informationen');
 INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Save workspace as web map context document', 'Ansicht als Web Map Context Dokument speichern');
-INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Resize Mapsize', 'Bildschirmgröße anpassen');
-INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Load WMC', 'WMC laden');
-INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Rubber', 'Radiergummi');
-INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Get Area', 'Fläche berechnen');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Resize Mapsize', 'Bildschirmgröße anpassen');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Rubber', 'Skizze löschen');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Get Area', 'Fläche berechnen');
 INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Close Polygon', 'Polygon schliessen');
-INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Move back to your GUI list', 'Zurück zur GUI Liste');
-INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Legend', 'Legende');   
-INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Print', 'Druck');  
-INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Imprint', 'Impressum');  
-INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Maps', 'Karten');  
-INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Search', 'Suche');  
-INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Meetingpoint', 'Treffpunkt');  
-INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Metadatasearch', 'Metadatensuche'); 
- 
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Move back to your GUI list', 'Zurück zur GUI Liste');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Legend', 'Legende');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Print', 'Druck');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Imprint', 'Impressum');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Maps', 'Karten');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Search', 'Suche');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Meetingpoint', 'Treffpunkt');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Metadatasearch', 'Metadatensuche');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Adding WMS', 'WMS hinzufügen');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Adding WMS from List', 'WMS aus Liste hinzufügen');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Info', 'Info');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Change Projection', 'Projektion ändern');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Copyright', 'Copyright');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Digitize', 'Digitalisierung');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Overview', 'Übersichtskarte');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Drag Mapsize', 'Karte vergrößern');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Mapframe', 'Kartenfenster');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Navigation Frame', 'Navigationsfenster');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Scale Select', 'Auswahl des Maßstabes');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Scale Text', 'Maßstab per Texteingabe');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Scalebar', 'Maßstabsleiste');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Set Background', 'Hintegrundkarte auswählen');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Zoom to Coordinates', 'Zu den Koordinaten zoomen');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Change Password', 'Passwort ändern');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Load a web map context document', 'laden eines Web Map Context Dokumentes');
+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 int(11) NOT NULL auto_increment,
+    fkey_mb_user_id int(11) NOT NULL,
+    fkey_gui_id varchar(50) NOT NULL,
+    kml_doc text NOT NULL,
+    kml_name varchar(64),
+    kml_description text,
+    kml_timestamp int(11) NOT NULL,
+       PRIMARY KEY (kml_id)
+);
 
+
+ALTER TABLE gui_kml
+ADD CONSTRAINT gui_kml_fkey_mb_user_id  FOREIGN KEY (fkey_mb_user_id)
+REFERENCES mb_user(mb_user_id) MATCH SIMPLE ON UPDATE CASCADE ON DELETE CASCADE;
+
+ALTER TABLE gui_kml
+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;
+

More information about the Mapbender_commits mailing list