Database Schema History

Jump to bottom Edit New page

Andrew Buck edited this page Jul 11, 2017 · 2 revisions

Using Version 3.1 as a baseline, here are the changes to the GPV Configuration schema since 2014

Version 4.1 (GPV41_SQLServer_Upgrade.SQL - upgrades to GPV configuration schema version 3.1)

remove AllowMapTabScroll and AllowDataTabScroll from GPVApplication
rename Function to FunctionName in GPVLayerFunction
rename TextFont to FontFamily, TextSize to FontSize and TextBold to FontBold in GPVPrintTemplateContent
create GPVSearch
create GPVSearchInputField

Version 5.0 (GPV50_SQLServer_Upgrade.SQL - upgrades to GPV configuration schema version 4.1)

add DefaultFunctionTab, DefaultTool, MetaDescription and MetaKeywords to GPVConfiguration
delete BaseMapID from Layer
delete BaseMapID and ShowBaseMapInLegend from MapTab
create MapTabTileGroup table
create Setting table
create TileGroup table
create TileLayer table
add collation to key fields in copied tables
GPVSetting content

Home | Security | Database Schema | Web.config Settings | Stored Procedures | URL Syntax