Heureka database upgrade script 0.5.4.2

Back to scripts

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


	-- 1. Add new columns to InvTreatmentUnit
	IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'InvTreatmentUnit' AND COLUMN_NAME = 'TreatmentUnitParentGUID')
	BEGIN
	 ALTER TABLE [dbo].[InvTreatmentUnit] ADD
	  [TreatmentUnitParentGUID] [uniqueidentifier] NULL
	END
 
	-- 2. Add new columns to StandInventory
	IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'StandInventory' AND COLUMN_NAME = 'P1')
	BEGIN
 	ALTER TABLE [dbo].[StandInventory] ADD
 	 [P1] [float] NULL
	END
	IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'StandInventory' AND COLUMN_NAME = 'P2')
	BEGIN
	 ALTER TABLE [dbo].[StandInventory] ADD
	  [P2] [float] NULL
	END
	IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'StandInventory' AND COLUMN_NAME = 'P3')
	BEGIN
	 ALTER TABLE [dbo].[StandInventory] ADD
	  [P3] [float] NULL
	END
	IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'StandInventory' AND COLUMN_NAME = 'StratumNo')
	BEGIN
	  ALTER TABLE [dbo].[StandInventory] ADD
	  [StratumNo] [int] NULL
	END
	IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'StandInventory' AND COLUMN_NAME = 'RepresentativeArea')
	BEGIN
	   ALTER TABLE [dbo].[StandInventory] ADD
	  [RepresentativeArea] [float] NULL
	END
	-- Update version

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

END