Heureka database upgrade script 0.6.0.2

Back to scripts

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

	-- 1. Recreate Table Cliques

	IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'Cliques')
	BEGIN
		DROP TABLE [dbo].[Cliques]
	END

	CREATE TABLE [dbo].[Cliques](
		[CliqueGUID] [uniqueidentifier] NOT NULL,
		[AreaGUID] [uniqueidentifier] NOT NULL,
		[TreatmentUnitGUID] [uniqueidentifier] NOT NULL
	) ON [PRIMARY]

	ALTER TABLE [dbo].[Cliques]  WITH NOCHECK ADD  CONSTRAINT [FK_Cliques_Area] FOREIGN KEY([AreaGUID])
	REFERENCES [dbo].[Area] ([AreaGUID])

	ALTER TABLE [dbo].[Cliques] CHECK CONSTRAINT [FK_Cliques_Area]

	ALTER TABLE [dbo].[Cliques]  WITH NOCHECK ADD  CONSTRAINT [FK_Cliques_TreatmentUnit] FOREIGN KEY([TreatmentUnitGUID])
	REFERENCES [dbo].[TreatmentUnit] ([TreatmentUnitGUID])

	ALTER TABLE [dbo].[Cliques] CHECK CONSTRAINT [FK_Cliques_TreatmentUnit]


	-- 2. Recreate Table HarvestClusters

	IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'HarvestClusters')
	BEGIN
		DROP TABLE [dbo].[HarvestClusters]
	END

	CREATE TABLE [dbo].[HarvestClusters](
		[HarvestClusterGUID] [uniqueidentifier] NOT NULL,
		[AreaGUID] [uniqueidentifier] NOT NULL,
		[TreatmentUnitGUID] [uniqueidentifier] NOT NULL
	) ON [PRIMARY]

	ALTER TABLE [dbo].[HarvestClusters]  WITH NOCHECK ADD  CONSTRAINT [FK_HarvestClusters_Area] FOREIGN KEY([AreaGUID])
	REFERENCES [dbo].[Area] ([AreaGUID])

	ALTER TABLE [dbo].[HarvestClusters] CHECK CONSTRAINT [FK_HarvestClusters_Area]

	ALTER TABLE [dbo].[HarvestClusters]  WITH NOCHECK ADD  CONSTRAINT [FK_HarvestClusters_TreatmentUnit] FOREIGN KEY([TreatmentUnitGUID])
	REFERENCES [dbo].[TreatmentUnit] ([TreatmentUnitGUID])

	ALTER TABLE [dbo].[HarvestClusters] CHECK CONSTRAINT [FK_HarvestClusters_TreatmentUnit]



	-- Update Version Table

	UPDATE Version SET ApplicationVersion = '0.6.0.2';

	PRINT 'Success! Database upgrade to version 0.6.0.2';
END