[Mapbender-commits] r3362 -
branches/2.5/resources/db/postgresql/iso/update
svn_mapbender at osgeo.org
svn_mapbender at osgeo.org
Fri Dec 19 08:54:09 EST 2008
Author: christoph
Date: 2008-12-19 08:54:09 -0500 (Fri, 19 Dec 2008)
New Revision: 3362
Added:
branches/2.5/resources/db/postgresql/iso/update/update_2.4.5_to_2.5_pgsql_ISO-8859-1.sql
Log:
changed encoding
Added: branches/2.5/resources/db/postgresql/iso/update/update_2.4.5_to_2.5_pgsql_ISO-8859-1.sql
===================================================================
--- branches/2.5/resources/db/postgresql/iso/update/update_2.4.5_to_2.5_pgsql_ISO-8859-1.sql (rev 0)
+++ branches/2.5/resources/db/postgresql/iso/update/update_2.4.5_to_2.5_pgsql_ISO-8859-1.sql 2008-12-19 13:54:09 UTC (rev 3362)
@@ -0,0 +1,539 @@
+--
+-- database changes in version 2.5
+--
+-- notice language plpgsql has to be installed
+--
+
+
+-- How to install plpgsql?
+-- createlang plpgsql mapbender
+
+
+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_monitor: new columns for mb_monitor
+--
+ALTER TABLE mb_monitor ADD COLUMN image int4;
+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 character varying(255);
+ALTER table wfs add fees character varying(255);
+ALTER table wfs add accessconstraints text;
+ALTER table wfs add individualname character varying(255);
+ALTER table wfs add positionname character varying(255);
+ALTER table wfs add providername character varying(255);
+ALTER table wfs add city character varying(255);
+ALTER table wfs add deliverypoint character varying(255);
+ALTER table wfs add administrativearea character varying(255);
+ALTER table wfs add postalcode character varying(255);
+ALTER table wfs add voice character varying(255);
+ALTER table wfs add facsimile character varying(255);
+ALTER table wfs add electronicmailaddress character varying(255);
+ALTER table wfs add wfs_mb_getcapabilities_doc text;
+ALTER table wfs add wfs_owner integer;
+ALTER table wfs add wfs_timestamp integer;
+ALTER table wfs add country character varying(255);
+
+ALTER TABLE wfs ALTER COLUMN wfs_title SET NOT NULL;
+ALTER TABLE wfs ALTER COLUMN wfs_title SET DEFAULT ''::character varying;
+
+ALTER TABLE wfs ALTER COLUMN wfs_version SET NOT NULL;
+ALTER TABLE wfs ALTER COLUMN wfs_version SET DEFAULT ''::character varying;
+
+ALTER TABLE wfs ALTER COLUMN wfs_getcapabilities SET NOT NULL;
+ALTER TABLE wfs ALTER COLUMN wfs_getcapabilities SET DEFAULT ''::character varying;
+
+alter table wfs_featuretype add column featuretype_searchable integer default 1;
+alter table wfs_featuretype add column featuretype_abstract character varying(50);
+
+-- 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);
+
+ALTER TABLE ONLY gui_wfs_conf
+ ADD CONSTRAINT gui_wfs_conf_ibfk_1 FOREIGN KEY (fkey_gui_id) REFERENCES gui(gui_id) ON UPDATE CASCADE ON DELETE CASCADE;
+
+ALTER TABLE ONLY gui_wfs_conf
+ ADD CONSTRAINT gui_wfs_conf_ibfk_2 FOREIGN KEY (fkey_wfs_conf_id) REFERENCES wfs_conf(wfs_conf_id) ON UPDATE CASCADE ON DELETE CASCADE;
+
+-- insert wfs confs into gui digitize
+INSERT INTO gui_wfs_conf (fkey_gui_id, fkey_wfs_conf_id) VALUES ('gui_digitize', 1);
+INSERT INTO gui_wfs_conf (fkey_gui_id, fkey_wfs_conf_id) VALUES ('gui_digitize', 3);
+INSERT INTO gui_wfs_conf (fkey_gui_id, fkey_wfs_conf_id) VALUES ('gui_digitize', 4);
+INSERT INTO gui_wfs_conf (fkey_gui_id, fkey_wfs_conf_id) VALUES ('gui_digitize', 2);
+
+
+
+--
+-- new table wfs_featuretype_keyword:
+--
+CREATE TABLE wfs_featuretype_keyword (
+ fkey_featuretype_id integer NOT NULL,
+ fkey_keyword_id integer NOT NULL
+);
+
+ALTER TABLE ONLY wfs_featuretype_keyword
+ ADD CONSTRAINT fkey_keyword_id_fkey_featuretype_id FOREIGN KEY (fkey_keyword_id) REFERENCES keyword(keyword_id) ON UPDATE CASCADE ON DELETE CASCADE;
+
+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
+--
+ALTER TABLE wfs_conf add COLUMN wfs_conf_description text;
+
+
+--
+-- table wfs_conf_element: change in WFS configuration: access to geometries may now be restricted
+--
+ALTER TABLE wfs_conf_element ADD COLUMN f_show_detail int4;
+ALTER TABLE wfs_conf_element ADD COLUMN f_operator VARCHAR(50);
+
+ALTER TABLE ONLY wfs_conf
+ ADD CONSTRAINT wfs_conf_ibfk_2 FOREIGN KEY (fkey_featuretype_id) REFERENCES wfs_featuretype(featuretype_id) ON UPDATE CASCADE ON DELETE CASCADE;
+
+--
+-- table gui_element: new element for table admin1 to edit wfs settings
+--
+INSERT INTO gui_element(fkey_gui_id, e_id, e_pos, e_public, e_comment, 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) VALUES('admin1','WFS',2,1,'edit wfs settings','a','','href = "../javascripts/mod_wfs_client.html" target="AdminFrame"',10,1005,250,20,NULL ,'font-family: Arial, Helvetica, sans-serif; font-size : 12px; text-decoration : none; color: #808080;','EDIT WFS','a','','','','AdminFrame','');
+
+
+--
+-- new table translation: new table for translations
+--
+
+CREATE TABLE translations
+(
+ trs_id serial PRIMARY KEY not null,
+ locale varchar(8),
+ msgid varchar(512),
+ msgstr varchar(512)
+);
+
+CREATE INDEX msgid_idx ON translations(msgid);
+
+
+
+ CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql'
+ HANDLER plpgsql_call_handler;
+--
+-- new function gettext for easy translations
+--
+CREATE OR REPLACE FUNCTION gettext(locale_arg "text", string "text")
+RETURNS "varchar" AS
+$BODY$
+DECLARE
+ msgstr varchar(512);
+ trl RECORD;
+BEGIN
+ -- RAISE NOTICE '>%<', locale_arg;
+
+ SELECT INTO trl * FROM translations
+ WHERE trim(from locale) = trim(from locale_arg) AND msgid = string;
+ -- we return the original string, if no translation is found.
+ -- this is consistent with gettext's behaviour
+ IF NOT FOUND THEN
+ RETURN string;
+ ELSE
+ RETURN trl.msgstr;
+ END IF;
+END;
+$BODY$
+ LANGUAGE 'plpgsql' VOLATILE;
+
+--
+-- new entries for table translations
+--
+
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Pan', 'Ausschnitt verschieben');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Display complete map', 'gesamte Karte anzeigen');
+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', 'Zurueck');
+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 waehlen');
+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', 'Logout', 'Abmelden');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'WMS preferences', 'WMS Einstellungen');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Adding WMS from filtered list', 'WMS von gefilteter Liste hinzufuegen');
+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', 'Bildschirmgroesse anpassen');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Rubber', 'Skizze loeschen');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Get Area', 'Flaeche 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', 'Zurueck 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 hinzufuegen');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Adding WMS from List', 'WMS aus Liste hinzufuegen');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Info', 'Info');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Change Projection', 'Projektion aendern');
+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', 'UEbersichtskarte');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Drag Mapsize', 'Karte vergroessern');
+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 Massstabes');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Scale Text', 'Massstab per Texteingabe');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Scalebar', 'Massstabsleiste');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('de', 'Set Background', 'Hintegrundkarte auswaehlen');
+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 aendern');
+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 ('bg', 'Pan', '???????? ????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Display complete map', '?????? ?????? ?????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Zoom in', '?????? ??????? ? ??-???? ?????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Zoom out', '?????? ??????? ? ??-?????? ?????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Back', '?????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Forward', '??????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Coordinates', '??????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Zoom by rectangle', '??????? ??????? ? ????????? ??????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Redraw', '????????? ??? ?? ????????????: ?????? ????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Query', '????? ??? ???????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Logout', '????? ?? ??????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'WMS preferences', 'WMS ?????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Adding WMS from filtered list', '?????? WMS ?? ?????? ??????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Set map center', '??????? ?????? ?? ?????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Help', '?????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Show WMS infos', '?????? WMS ??????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Save workspace as web map context document', '?????? ???????? ???????? ???? Web Map Context ????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Resize Mapsize', '??????? ?????????? ?? ???????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Rubber', '??????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Get Area', '??????? ????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Close Polygon', '??????? ???????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Move back to your GUI list', '????? ??? ??????? ? ?????????? (GUI)');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Legend', '???????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Print', '?????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Imprint', '???????? ????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Maps', '?????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Search', '???????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Meetingpoint', '????? ?? ?????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Metadatasearch', '??????? ?? ?????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Adding WMS', '?????? WMS');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Adding WMS from List', '?????? WMS ?? ??????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Info', '??????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Change Projection', '??????? ????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Copyright', '???????? ?????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Digitize', '??????????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Overview','??????? ?????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Drag Mapsize', '??????? ??????? ?? ???????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Mapframe', '????? ?? ???????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Navigation Frame', '???????????? ?????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Scale Select', '????? ?? ?????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Scale Text', '?????? ?????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Scalebar', '??????? ?????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Set Background', '?????? ?????? ???????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Zoom to Coordinates', '?????? ??????? ????? ?????????? ??????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Change Password', '??????? ??????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Load a web map context document', '?????? Web Map Context ????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Logo', '?????? ????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('bg', 'Measure distance', '?????? ??????????');
+
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Pan', '??????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Display complete map', '???????? ??????? ?????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Zoom in', 'Zoom In');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Zoom out', 'Zoom Out');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Back', '????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Forward', '???????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Coordinates', '?????????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Zoom by rectangle', '???? ??? ?????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Redraw', '????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Query', '??????? ???????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Logout', '??????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'WMS preferences', '??????? ?? ??????? ??? WMS');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Adding WMS from filtered list', '???????? WMS ??? ?? ????????????? ????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Set map center', '?? ??????????? ?????? ??????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Help', '???????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Save workspace as web map context document', 'Ansicht als Web Map Context Dokument speichern');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Rubber', '?? ???????- ???????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Close Polygon', '?? ??????? ????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ( 'gr', 'Move back to your GUI list', '?????????? ??? GUI ?????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Print', '????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Maps', ' ??????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Adding WMS', '???????? WMS');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Adding WMS from List', '???????? WMS ??? ??? ????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Copyright', 'Copyright');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Navigation Frame', 'Navigationsfenster');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Load a web map context document', 'laden eines Web Map Context Dokumentes');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Measure distance', '??????? ?????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Meetingpoint', '?????? ??????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Info', '???????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Digitize', '???????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Change Projection', '?????? ????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Set Background', '??????? ??????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Overview', '?????????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Change Password', '?????? ????????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Scalebar', '??????? ????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr ', 'Logo', '????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Zoom to Coordinates', '??????? ?? ?????????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Scale Text', '??????? ????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Show WMS infos', '??????? WMS ???????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Legend', '???????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Search', '?????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Resize Mapsize', '?????? ???????? ?????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Drag Mapsize', '?????? ???????? ????? ?? ????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Mapframe', '??????? ?????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Get Area', '??????? ????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Imprint', '?????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Scale Select', '??????? ????????');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('gr', 'Metadatasearch', '????????? ??? Metadata');
+
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Pan', 'Selectie verschuiven');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Display complete map', 'Hele kaart tonen');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Zoom in', 'Inzoomen');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Zoom out', 'Uitzoomen');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Back', 'Terug');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Forward', 'Voorwaarts');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Coordinates', 'Koordinaten tonen');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Zoom by rectangle', 'Zoom rechthoek-selectie');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Redraw', 'Opfrissen of toetsenbord : spatiebalk');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Query', 'Data opvragen');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Logout', 'Afmelden');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'WMS preferences', 'WMS instellingen');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Adding WMS from filtered list', 'WMS van gefilterte lijst toevoegen');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Set map center', 'Kaartmiddelpunt aangeven');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Help', 'Help');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Show WMS infos', 'Tonen van WMS Informatie');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Save workspace as web map context document', 'zicht als Web map context dokument bewaren');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Resize Mapsize', 'beeldschermgrote aanpassen');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Rubber', 'schets verwerpen');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Get Area', 'oppervlakte berekenen');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Close Polygon', 'Polygoon sluiten');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Move back to your GUI list', 'Terug naar GUI lijst');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Legend', 'Legende');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Print', 'Drukken');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Imprint', 'Impressum');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Maps', 'Kaarten');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Search', 'Zoek');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Meetingpoint', 'Trefpunt');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Metadatasearch', 'Zoeken naar Metadata');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Adding WMS', 'WMS toevoegen');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Adding WMS from List', 'WMS uit lijst toevoegen');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Info', 'Informatie');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Change Projection', 'Projektie veranderen');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Copyright', 'Copyright');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Digitize', 'Digitaliseren');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Overview', 'overzichtskaart');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Drag Mapsize', 'Kaart vergroten');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Mapframe', 'Kaartvenster');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Navigation Frame', 'Navigeervenster');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Scale Select', 'Schaal selecteren');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Scale Text', 'Schaal via tekstingave');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Scalebar', 'Schaalbalk');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Set Background', 'Achtergrond selecteren');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Zoom to Coordinates', 'Naar koordinaten zoomen');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Change Password', 'Paswoord wijzigen');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Load a web map context document', 'Laad een Web Map Context Dokument');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Logo', 'Logo');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('nl', 'Measure distance', 'Meet afstand');
+
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Pan', 'Sposta dettaglio');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Display complete map', 'Mostra tutta la mappa');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Zoom in', 'Ingrandisci');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Zoom out', 'Riduci');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Back', 'Indietro');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Forward', 'Avanti');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Coordinates', 'Mostra coordinate');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Zoom by rectangle', 'Seleziona dettaglio');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Redraw', 'Ridisegna oppure, da tastiera: spazio');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Query', 'Interroga');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Logout', 'Logout');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'WMS preferences', 'Impostazioni WMS');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Adding WMS from filtered list', 'Aggiungi un WMS da una lista filtrata');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Set map center', 'Fissa il centro della mappa');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Help', 'Aiuto');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Show WMS infos', 'Mostra informazioni sul WMS');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Save workspace as web map context document', 'Salva vista come documento di Web Map Context');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Resize Mapsize', 'Adatta la dimensione della mappa');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Rubber', 'Cancella bozza');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Get Area', 'Calcola area');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Close Polygon', 'Chiudi poligono');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Move back to your GUI list', 'Torna alla lista delle GUI');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Legend', 'Legenda');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Print', 'Stampa');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Imprint', 'Colophon');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Maps', 'Mappe');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Search', 'Cerca');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Meetingpoint', 'Punti di incontro');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Metadatasearch', 'Ricerca metadati');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Adding WMS', 'Aggiungi WMS');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Adding WMS from List', 'Aggiungi WMS da lista');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Info', 'Info');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Change Projection', 'Cambia proiezione');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Copyright', 'Copyright');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Digitize', 'Digitalizza');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Overview', 'Mappa di insieme');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Drag Mapsize', 'Cambia dimensione mappa');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Mapframe', 'Quadro della mappa');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Navigation Frame', 'Quadro di navigazione');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Scale Select', 'Scelta della scala');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Scale Text', 'Scala dei testi');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Scalebar', 'Scala di riferimento');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Set Background', 'Seleziona mappa di sfondo');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Zoom to Coordinates', 'Ingrandisci alle coordinate');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Change Password', 'Cambia password');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Load a web map context document', 'Carica un documento Web Map Context');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Logo', 'Logo');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('it', 'Measure distance', 'Misura distanza');
+
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Pan', 'Desplazamiento');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Display complete map', 'Desplazamiento');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Zoom in', 'Zoom +');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Zoom out', 'Zoom -');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Back', 'Zoom previo');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Forward', 'Zoom siguiente');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Coordinates', 'Mostrar coordenadas');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Zoom by rectangle', 'Zoom rectangulo');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Redraw', 'Refrescar');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Query', 'Busqueda de datos');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Logout', 'Terminar');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'WMS preferences', 'Ajuste WMS');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Adding WMS from filtered list', 'Anadir WMS desde lista filtrada');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Set map center', 'Centrar');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Help', 'Ayuda');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Show WMS infos', 'Mostrar informacion sobre WMS');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Save workspace as web map context document', 'Guardar vista como fichero Web Map Context');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Resize Mapsize', 'Modificar el tamano de mapa');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Rubber', 'Borrar');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Get Area', 'Calcular area');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Close Polygon', 'Cerrar poligono');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Move back to your GUI list', 'Volver a la lista WMS');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Legend', 'Leyenda');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Print', 'Imprimir');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Imprint', 'Aviso legal');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Maps', 'Mapas');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Search', 'Busqueda');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Meetingpoint', 'Lugar de reunion');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Metadatasearch', 'Busqueda de datos meta');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Adding WMS', 'Anadir WMS');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Adding WMS from List', 'Anadir WMS desde lista');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Info', 'Informacion');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Change Projection', 'Cambiar projecto');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Copyright', 'Copyright');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Digitize', 'Digitalizacion');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Overview', 'Mapa de vision general');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Drag Mapsize', 'Ampilar vista de mapa');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Mapframe', 'Ventana de mapa');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Navigation Frame', 'Ventana de navigacion');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Scale Select', 'Selecionar escala');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Scale Text', 'Teclar escala');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Scalebar', 'Fraja de escala');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Set Background', 'Poner el fondo');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Zoom to Coordinates', 'Zoom en coordenadas');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Change Password', 'Cambiar clave');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Load a web map context document', 'Cargar un documento de Web Map Context');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Logo', 'Logo');
+INSERT INTO translations (locale, msgid, msgstr) VALUES ('es', 'Measure distance', 'Medir distancias');
+
+--
+-- 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;
+
+--
+-- new sld_user_layer table
+--
+CREATE TABLE sld_user_layer (
+ sld_user_layer_id serial NOT NULL,
+ fkey_mb_user_id integer NOT NULL,
+ fkey_layer_id integer NOT NULL,
+ fkey_gui_id character varying,
+ sld_xml text,
+ use_sld smallint
+);
+ALTER TABLE sld_user_layer ADD CONSTRAINT pk_sld_user_layer PRIMARY KEY (sld_user_layer_id);
+--
+-- Name: sld_user_layer_ibfk_1; Type: FK CONSTRAINT; Schema: public; Owner: admin
+--
+ALTER TABLE ONLY sld_user_layer
+ ADD CONSTRAINT sld_user_layer_ibfk_1 FOREIGN KEY (fkey_mb_user_id) REFERENCES mb_user(mb_user_id) ON UPDATE CASCADE ON DELETE CASCADE;
+--
+-- Name: sld_user_layer_ibfk_2; Type: FK CONSTRAINT; Schema: public; Owner: admin
+--
+ALTER TABLE ONLY sld_user_layer
+ ADD CONSTRAINT sld_user_layer_ibfk_2 FOREIGN KEY (fkey_layer_id) REFERENCES layer(layer_id) ON UPDATE CASCADE ON DELETE CASCADE;
+--
+-- Name: sld_user_layer_ibfk_3; Type: FK CONSTRAINT; Schema: public; Owner: admin
+--
+ALTER TABLE ONLY sld_user_layer
+ ADD CONSTRAINT sld_user_layer_ibfk_3 FOREIGN KEY (fkey_gui_id) REFERENCES gui(gui_id) ON UPDATE CASCADE ON DELETE CASCADE;
+--
+-- add sld related columns
+--
+alter table gui_wms add column gui_wms_sldurl character varying(255) DEFAULT ''::character varying NOT NULL;
+alter table wms add column wms_supportsld boolean;
+alter table wms add column wms_userlayer boolean;
+alter table wms add column wms_userstyle boolean;
+alter table wms add column wms_remotewfs boolean;
+
+--
+-- opacity handeling
+--
+ALTER TABLE gui_wms ADD COLUMN gui_wms_opacity INT DEFAULT 100;
+
+UPDATE gui_element SET e_mb_mod = 'mod_addWMSgeneralFunctions.js' WHERE e_id = 'addWMS';
+
+ALTER TABLE gui_element ALTER COLUMN e_js_file TYPE character varying(255);
+ALTER TABLE gui_element ALTER COLUMN e_mb_mod TYPE character varying(255);
+ALTER TABLE wms ALTER COLUMN fees TYPE text;
+ALTER TABLE wms RENAME COLUMN wms_mb_getcapabilies_doc TO wms_mb_getcapabilities_doc;
+
More information about the Mapbender_commits
mailing list