Database Changes

Database Change

Reason

Revision

New version 4000

New column for MAPS table – ‘openatinitialextent’

store the value indicating when a map should be loaded at initial extent

New column for MAPS table – ‘showZoomSlider’

determine if zoom slider should be shown

New column for MAPS table – ‘mapLods’

show json encode map lod values

Remove 'zoom.slider' from Settings table

Remove existing global setting for zoom slider

New table - SOLRSEARCHMAPLYR

store map layers selected to index in Solr

New table - SOLRJDBCSEARCH

store the jdbc queries to index in Solr

Remove ‘northarrow’ from Settings table

North arrow no longer supported

Remove 'map.pan.arrows'

Map pan arrows no longer supported

Remove 'start.tab'

Start tab no longer supported. Replaced by new side panel functionality

Remove 'mds.urls' and 'mds.levels.of.detail' from Settings

mds foundation maps no longer set in Dekho Admin.

New column for SESSIONS table - sessionprop

store key value for sessions

Remove 'exportselectiontoshpfile' from TOOL table

Not supported

Update TOOL to TOOLTYPE

Various other tools changes have taken place to cater for the changes in tools to the panel bar

Iterate through role ids in ROLERESOURCE table and INSERT new SELECTION tool if the role had any selection tools previously and DELETE old Selection tools

Changes to selection tool

Iterate through map ids in MAPCAPABILITY table and INSERT new SELECTION tool if the map had any selection tools previously and DELETE old Selection tools

Changes to selection tool

Remove toolnames 'selectbypoint', 'selectbycircle', 'selectbyline', 'selectbyrectangle', 'selectbypolygon', 'selectbyselection', 'selectionmode', 'clearselection' from TOOL table

Delete old Selection tools from TOOL table

Rename setting ‘apptype’ to ‘panel.startup’

The ‘apptype’ setting is renamed to ‘panel.startup’

Remove setting ‘map.service.buttons’

Not needed anymore

Merge relines and measure tools. Tables updated are MAPCAPABILITY and ROLERESOURCE

Redlines and measurements now combined into Reline/Measure tool

Remove toolname ‘measure’

Measure tool is a part of Redline/Measure tool

Remove unused entries from MAPCAPABILITY and ROLERESOURCE table

Clean up MAPCAPABILITY and ROLERESOURCE tables

Remove setting ‘select.point.tolerance’

Not used anymore. The tolerance setting is now used from server.properties file

Remove setting ‘zoomtocoordinate.min.scale’

Not used anymore

PARAMETERS column in ‘help’ tool updated to use a new link

Link to Users Guide is changed so the ‘help’ tool is updated


Version 3.2.2 to 3.2.3