Heureka database upgrade script 0.6.0.2
Jump to navigation
Jump to search
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