Peder at 14:02, 14 July 2009

2009-07-14T14:02:23Z

Peder at 13:38, 14 July 2009

2009-07-14T13:38:26Z

Peder: New page: Back to scripts

 IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = '0.6.0.1') = 0 BEGIN 	PRINT 'Wrong Version of database. You must up...

2009-07-14T12:06:43Z

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...

New page

[[Heureka database upgrade scripts | Back to scripts]]
<pre>
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

</pre>
[[Category:Database]]

← Older revision		Revision as of 13:38, 14 July 2009
Line 66:		Line 66:

	</pre>		</pre>
−	[[Category:Database]]	+	[[Category:Database scripts]]

Heureka database upgrade script 0.6.0.2 - Revision history

Peder at 14:02, 14 July 2009

Peder at 13:38, 14 July 2009

Peder: New page: Back to scripts
IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = '0.6.0.1') = 0 BEGIN PRINT 'Wrong Version of database. You must up...

@@ Line 1: / Line 1: @@
-[[Heureka database upgrade scripts | Back to scripts]]
+[[:Category:Database scripts | Back to scripts]]
 <pre>
 IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = '0.6.0.1') = 0