Heureka database upgrade script 0.5.2

Back to scripts

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

	--1. Add columns to StandObject
	IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'StandObject' AND COLUMN_NAME = 'LastRegenerationYear')
	BEGIN
		ALTER TABLE StandObject ADD
			[LastRegenerationYear] [int] NULL
	END


	-- 2. Remove columns from StandObject
	IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'StandObject' AND COLUMN_NAME = 'TotalStandAge')
	BEGIN
		ALTER TABLE StandObject DROP COLUMN
			[TotalStandAge],
			[CleaningHistory],
			[FertilizationHistory]
	END

	--3. Rename InitialState_QModelData
	IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'InitialState_QModelData')
	BEGIN
		exec sp_rename 'InitialState_QModelData', 'InitialState_CarbonAndNitrogenData'
	END

	-- Update Version Table

	UPDATE Version SET ApplicationVersion = '0.5.2';

	PRINT 'Success! Database upgrade to version 0.5.2';

END