Database Changes 2.5

From MapbenderWiki

Contents 1 Database Changes in Mapbender 2.5 2 How to Update your GUIs from Mapbender 2.4.5 to Mapbender 2.5 2.1 update the e_title column 2.2 modul tabs: Title of the Tab is handles by the e_title of the element 2.3 change element_var from var to php 2.4 delete deprecated elements from gui_element 2.5 geometry.js is now added as modul and is not a single element anymore 2.6 keyhandler 2.7 e_title for every element that is handled in the tab element

Database Changes in Mapbender 2.5

en: You find the Database Changes in the svn. Have a look at the following link:

de: Die Datenbankänderungen finden Sie unter dem folgenden Link:

PostgreSQL

http://trac.osgeo.org/mapbender/browser/branches/2.5/resources/db/update/update_postgresql_db.sql

MySQL

http://trac.osgeo.org/mapbender/browser/branches/2.5/resources/db/update/update_mysql_db.sql

NOTICE: that the MySQL changes are not integrated completely yet. The function gettext has to be written.

How to Update your GUIs from Mapbender 2.4.5 to Mapbender 2.5

Notice: This description is still under construction. If you have any enhancements, please tell the dev-list

1. run the update SQL file to create new tables, columns, function gettext ...
2. follow the instruction to update you existing applications

update the e_title column

• due to i18n the tooltiptextes are handles by the new column e_title. The definition of the title in the e_attributes field has to be removed
• set e_title in table gui_element for all gui_elements used in the 'tabs' module
• delete the tab_titles from table gui_element_vars
• set the var_type of the tab_ids in table gui_element_vars from 'var' to 'php_var'

Update gui_element set e_title = mynew.e_title from gui_element as mynew where gui_element.e_id = mynew.e_id and mynew.fkey_gui_id = 'gui' and gui_element.fkey_gui_id != 'gui' and gui_element.fkey_gui_id != 'gui1' and gui_element.fkey_gui_id != 'gui2' and gui_element.fkey_gui_id != 'gui_digitize'; Update gui_element set e_title = mynew.e_title from gui_element as mynew where gui_element.e_id = mynew.e_id and mynew.fkey_gui_id = 'gui1' and gui_element.fkey_gui_id != 'gui' and gui_element.fkey_gui_id != 'gui1' and gui_element.fkey_gui_id != 'gui2' and gui_element.fkey_gui_id != 'gui_digitize'; Update gui_element set e_title = mynew.e_title from gui_element as mynew where gui_element.e_id = mynew.e_id and mynew.fkey_gui_id = 'gui2' and gui_element.fkey_gui_id != 'gui' and gui_element.fkey_gui_id != 'gui1' and gui_element.fkey_gui_id != 'gui2' and gui_element.fkey_gui_id != 'gui_digitize'; Update gui_element set e_title = mynew.e_title from gui_element as mynew where gui_element.e_id = mynew.e_id and mynew.fkey_gui_id = 'gui_digitize' and gui_element.fkey_gui_id != 'gui' and gui_element.fkey_gui_id != 'gui1' and gui_element.fkey_gui_id != 'gui2' and gui_element.fkey_gui_id != 'gui_digitize';

modul tabs: Title of the Tab is handles by the e_title of the element

• this is why the element_var tab_titles[n] can be deleted

Delete from gui_element_vars where fkey_e_id ='tabs' and var_name LIKE 'tab_titles[%';

change element_var from var to php

Update gui_element_vars set var_type='php_var' where fkey_e_id ='tabs' and var_name LIKE 'tab_ids[%' and var_type='var';

delete deprecated elements from gui_element

• delete element ajax
• delete element geometry

DELETE FROM gui_element WHERE e_id = 'ajax'; DELETE FROM gui_element WHERE e_id = 'geometry';

geometry.js is now added as modul and is not a single element anymore

Select * from gui_element where e_mb_mod ='geometry.js' ; update gui_element set e_mb_mod = 'geometry.js' where e_id = 'digitize'; update gui_element set e_mb_mod = 'geometry.js' where e_id = 'gazetteerWFS'; update gui_element set e_mb_mod = 'geometry.js' where e_id = 'setSpatialRequest'; update gui_element set e_mb_mod = 'geometry.js' where e_id = 'digitize';

keyhandler

• modul does not work and causes errors in IE

Delete from gui_element where e_id='keyHandler';

e_title for every element that is handled in the tab element