Heureka database upgrade script 0.8.0.1

Back to scripts

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

	-- 1. Add new columns to InitialState_BiomassData

	IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'InitialState_BiomassData' AND COLUMN_NAME = 'AboveGroundMassTotal')
	BEGIN
		ALTER TABLE InitialState_BiomassData ADD
			[AboveGroundMassTotal] [float] NULL,
			[BelowGroundMassTotal] [float] NULL

	END



	-- Update Version Table

	UPDATE Version SET ApplicationVersion = '0.8.0.1';
	PRINT 'Success! Database upgrade to version 0.8.0.1';
END