Heureka database upgrade script 0.5.4.1
Jump to navigation
Jump to search
IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = '0.5.4.0' OR ApplicationVersion = '0.5.4.1') = 0 BEGIN PRINT 'Wrong Version of database. You must upgrade to version 0.5.4.0 before running this script.'; SELECT ApplicationVersion FROM VERSION; END ELSE BEGIN -- 1. Add new columns to StandObject IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'StandObject' AND COLUMN_NAME = 'AreaLevel2') BEGIN ALTER TABLE [dbo].[StandObject] ADD [AreaLevel2] [nvarchar](50) NULL, [AreaLevel3] [nvarchar](50) NULL, [Register] [int] NULL END -- 2. Add new column to StratificationDomain IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'StratificationDomain' AND COLUMN_NAME = 'PriorityNo') BEGIN ALTER TABLE [dbo].[StratificationDomain] ADD [PriorityNo] [int] NULL END -- Update version UPDATE Version SET ApplicationVersion = '0.5.4.1'; PRINT 'Success! Database upgrade to version 0.5.4.1'; END