Database Schema History

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