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