Heureka database upgrade script 0.5.4.1

Back to scripts

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