Difference between revisions of "Heureka database upgrade script 0.6.0.2"
Jump to navigation
Jump to search
(New page: Back to scripts <pre> IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = '0.6.0.1') = 0 BEGIN PRINT 'Wrong Version of database. You must up...) |
|||
Line 66: | Line 66: | ||
</pre> | </pre> | ||
− | [[Category:Database]] | + | [[Category:Database scripts]] |
Revision as of 15:38, 14 July 2009
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