Heureka database upgrade script 0.5.2.1

Back to scripts

IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = '0.5.2' OR ApplicationVersion = '0.5.2.1' ) = 0
BEGIN
	PRINT 'Wrong Version of database. You must upgrade to version 0.5.2 before running this script.';
	SELECT ApplicationVersion FROM VERSION;
END
ELSE 
BEGIN

	-- 1. Add new columns for to InitialState_SiteData and InitialState_PredictionUnit

	IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'InitialState_SiteData' AND COLUMN_NAME = 'SoilMoistCode')
	BEGIN
		ALTER TABLE [dbo].[InitialState_SiteData] ADD
			[SoilMoistCode] [int] NULL,
			[Peat] [bit] NULL
	END

	IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'InitialState_PredictionUnit' AND COLUMN_NAME = 'SoilMoistCode')
	BEGIN
		ALTER TABLE [dbo].[InitialState_PredictionUnit] ADD
			[SoilMoistCode] [int] NULL,
			[Peat] [bit] NULL
	END

	-- Update Version Table

	UPDATE Version SET ApplicationVersion = '0.5.2.1';

	PRINT 'Success! Database upgrade to version 0.5.2.1';

END