Difference between revisions of "Heureka database upgrade script 0.6.0.1"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
+ | [[:Category:Database scripts|Back to scripts]] | ||
<pre> | <pre> | ||
IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = '0.6.0.0' OR ApplicationVersion = '0.6.0.0' ) = 0 | IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = '0.6.0.0' OR ApplicationVersion = '0.6.0.0' ) = 0 |
Latest revision as of 16:03, 14 July 2009
IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = '0.6.0.0' OR ApplicationVersion = '0.6.0.0' ) = 0 BEGIN PRINT 'Wrong Version of database. You must upgrade to version 0.6.0.0 before running this script.'; END ELSE BEGIN IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'InvTreatmentHistory') BEGIN DROP TABLE InvTreatmentHistory END IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'InvSitePosition') BEGIN DROP TABLE InvSitePosition END IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'InvTree') BEGIN DROP TABLE InvTree END IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'InvTreeDead') BEGIN DROP TABLE InvTreeDead END IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'InvTreeSample') BEGIN DROP TABLE InvTreeSample END IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'InvPlantBi') BEGIN DROP TABLE InvPlantBi END IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'InvPlantMain') BEGIN DROP TABLE InvPlantMain END IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'InvReferenceUnitTree') BEGIN DROP TABLE InvReferenceUnitTree END IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'InvReferenceUnitPlant') BEGIN DROP TABLE InvReferenceUnitPlant END IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'InvReferenceUnitSiteData') BEGIN DROP TABLE InvReferenceUnitSiteData END IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'InvReferenceUnit') BEGIN DROP TABLE InvReferenceUnit END IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'InvCorrectionFactor') BEGIN DROP TABLE InvCorrectionFactor END IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'InvTreatmentUnit') BEGIN DROP TABLE InvTreatmentUnit END IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'InvTreatmentUnitHistory') BEGIN DROP TABLE InvTreatmentUnitHistory END IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'InvSitePosition') BEGIN DROP TABLE InvSitePosition END SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[InvTreatmentUnit]( [StandObjectGUID] [uniqueidentifier] NOT NULL, [StratificationGUID] [uniqueidentifier] NOT NULL, [Description] [nvarchar](max) NOT NULL, [AreaFactor] [real] NULL, [InventoryYear] [int] NOT NULL, [Area] [real] NOT NULL, [Spacing] [int] NOT NULL, [SurveyorCode] [int] NOT NULL, [P1] [int] NOT NULL, [P2] [int] NOT NULL, [P3] [int] NOT NULL, [PlotRadiusPlant] [int] NOT NULL, [PlotRadiusTree] [int] NOT NULL, [Checked] [int] NULL, CONSTRAINT [InvTreatmentUnit_PK] PRIMARY KEY CLUSTERED ( [StandObjectGUID] ASC, [StratificationGUID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], UNIQUE NONCLUSTERED ( [StandObjectGUID] ASC, [StratificationGUID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] /****** Object: Table [dbo].[InvTreeSample] Script Date: 06/11/2009 07:33:01 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[InvTreeSample]( [TreeSampleGUID] [uniqueidentifier] NOT NULL, [ReferenceUnitTreeGUID] [uniqueidentifier] NOT NULL, [StratificationGUID] [uniqueidentifier] NOT NULL, [DateInsert] [datetime] NULL, [IsSampleTree] [int] NOT NULL, [TreeId] [int] NOT NULL, [TypeCode] [int] NOT NULL, [SCode] [int] NOT NULL, [SpeciesCode] [int] NOT NULL, [Diameter] [real] NULL, [Height] [real] NULL, [Age] [int] NULL, [Quality] [int] NULL, [Damage] [int] NULL, [DistA] [real] NULL, [DistB] [real] NULL, [DistC] [real] NULL, [Angel] [real] NULL, [XCoordinate] [real] NULL, [YCoordinate] [real] NULL, [Distance] [real] NULL, CONSTRAINT [InvTreeSample_PK] PRIMARY KEY CLUSTERED ( [TreeSampleGUID] ASC, [StratificationGUID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], UNIQUE NONCLUSTERED ( [TreeSampleGUID] ASC, [StratificationGUID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] /****** Object: Table [dbo].[InvTree] Script Date: 06/11/2009 07:32:45 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[InvTree]( [TreeGUID] [uniqueidentifier] NOT NULL, [ReferenceUnitTreeGUID] [uniqueidentifier] NOT NULL, [StratificationGUID] [uniqueidentifier] NOT NULL, [DateInsert] [datetime] NULL, [Distance] [real] NULL, [IsSampleTree] [int] NOT NULL, [TreeId] [int] NOT NULL, [TypeCode] [int] NOT NULL, [SpeciesCode] [int] NOT NULL, [Diameter] [real] NULL, [DistA] [real] NULL, [DistB] [real] NULL, [DistC] [real] NULL, [Angel] [real] NULL, [XCoordinate] [real] NULL, [YCoordinate] [real] NULL, CONSTRAINT [InvTree_PK] PRIMARY KEY CLUSTERED ( [TreeGUID] ASC, [StratificationGUID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [UQ__InvTree__167A2832] UNIQUE NONCLUSTERED ( [TreeGUID] ASC, [StratificationGUID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] /****** Object: Table [dbo].[InvPlantBi] Script Date: 06/11/2009 07:32:07 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[InvPlantBi]( [PlantGUID] [uniqueidentifier] NOT NULL, [ReferenceUnitPlantGUID] [uniqueidentifier] NOT NULL, [StratificationGUID] [uniqueidentifier] NOT NULL, [DateInsert] [datetime] NULL, [PlantId] [int] NOT NULL, [SpeciesCode] [int] NOT NULL, [Height] [real] NULL, [Stems] [real] NOT NULL, CONSTRAINT [InvPlantBi_PK] PRIMARY KEY CLUSTERED ( [PlantGUID] ASC, [StratificationGUID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], UNIQUE NONCLUSTERED ( [PlantGUID] ASC, [StratificationGUID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] /****** Object: Table [dbo].[InvPlantMain] Script Date: 06/11/2009 07:32:11 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[InvPlantMain]( [PlantGUID] [uniqueidentifier] NOT NULL, [ReferenceUnitPlantGUID] [uniqueidentifier] NOT NULL, [StratificationGUID] [uniqueidentifier] NOT NULL, [DateInsert] [datetime] NOT NULL, [PlantId] [int] NOT NULL, [SpeciesCode] [int] NOT NULL, [Height] [real] NULL, CONSTRAINT [InvPlantMain_PK] PRIMARY KEY CLUSTERED ( [PlantGUID] ASC, [StratificationGUID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], UNIQUE NONCLUSTERED ( [PlantGUID] ASC, [StratificationGUID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] /****** Object: Table [dbo].[InvCorrectionFactor] Script Date: 06/11/2009 07:32:04 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[InvCorrectionFactor]( [StandObjectGUID] [uniqueidentifier] NOT NULL, [StratificationGUID] [uniqueidentifier] NOT NULL, [CorrectionType] [int] NOT NULL, [SpeciesGroup] [int] NOT NULL, [CorrectionFactor] [float] NOT NULL, CONSTRAINT [PK_InvCorrFactor] PRIMARY KEY CLUSTERED ( [StandObjectGUID] ASC, [StratificationGUID] ASC, [CorrectionType] ASC, [SpeciesGroup] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] /****** Object: Table [dbo].[InvReferenceUnit] Script Date: 06/11/2009 07:32:18 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[InvReferenceUnit]( [ReferenceUnitGUID] [uniqueidentifier] NOT NULL, [StratificationGUID] [uniqueidentifier] NOT NULL, [StandObjectGUID] [uniqueidentifier] NOT NULL, [PlotNr] [int] NOT NULL, [InventoryYear] [int] NOT NULL, [Altitude] [int] NULL, [ClimateCode] [int] NULL, [ImpedimentPercentage] [real] NULL, [GPSCordEast] [real] NULL, [GPSCordNorth] [real] NULL, [TCordEast] [real] NULL, [TCordNorth] [real] NULL, [HPCordEast] [real] NULL, [HPCordNorth] [real] NULL, [Checked] [int] NULL, [SiteIndex] [real] NULL, [TotalBasalArea] [real] NULL, CONSTRAINT [InvReferenceUnit_PK] PRIMARY KEY CLUSTERED ( [ReferenceUnitGUID] ASC, [StratificationGUID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], UNIQUE NONCLUSTERED ( [ReferenceUnitGUID] ASC, [StratificationGUID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] /****** Object: Table [dbo].[InvReferenceUnitSiteData] Script Date: 06/11/2009 07:32:30 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[InvReferenceUnitSiteData]( [ReferenceUnitSiteDataGUID] [uniqueidentifier] NOT NULL, [ReferenceUnitGUID] [uniqueidentifier] NOT NULL, [StratificationGUID] [uniqueidentifier] NOT NULL, [Peat] [bit] NULL, [SoilMoistCode] [int] NULL, [LaterW] [int] NULL, [TextureCode] [int] NULL, [SoilDepth] [int] NULL, [GroundLayerCode] [int] NULL, [VegitationTypeCode] [int] NULL, [Ditch] [bit] NULL, [Direction] [int] NULL, [DominantSpeciesCode] [int] NULL, [GroundCondition] [int] NULL, [Boulder] [int] NULL, [Slope] [int] NULL, [SmallTreesP] [int] NULL, [SmallTreesS] [int] NULL, [SmallTreesB] [int] NULL, [SmallTreesOther] [int] NULL, [DamageCause] [int] NULL, [DamagePercentage] [int] NULL, [Split] [bit] NULL, CONSTRAINT [InvReferenceUnitSiteData_PK] PRIMARY KEY CLUSTERED ( [ReferenceUnitSiteDataGUID] ASC, [StratificationGUID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [UQ__InvReferenceUnit__09202D14] UNIQUE NONCLUSTERED ( [ReferenceUnitSiteDataGUID] ASC, [StratificationGUID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] /****** Object: Table [dbo].[InvReferenceUnitPlant] Script Date: 06/11/2009 07:32:21 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[InvReferenceUnitPlant]( [ReferenceUnitPlantGUID] [uniqueidentifier] NOT NULL, [ReferenceUnitGUID] [uniqueidentifier] NOT NULL, [StratificationGUID] [uniqueidentifier] NOT NULL, [ImpedimentPercentage] [real] NULL, [RejuvenationProposal] [int] NULL, [CleaningProposal] [int] NULL, CONSTRAINT [InvReferenceUnitPlant_PK] PRIMARY KEY CLUSTERED ( [ReferenceUnitPlantGUID] ASC, [StratificationGUID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], UNIQUE NONCLUSTERED ( [ReferenceUnitPlantGUID] ASC, [StratificationGUID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] /****** Object: Table [dbo].[InvTreeDead] Script Date: 06/11/2009 07:32:53 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[InvTreeDead]( [TreeDeadGUID] [uniqueidentifier] NOT NULL, [ReferenceUnitGUID] [uniqueidentifier] NOT NULL, [StratificationGUID] [uniqueidentifier] NOT NULL, [DateInsert] [datetime] NULL, [TreeId] [int] NOT NULL, [Position] [int] NOT NULL, [SpeciesCode] [int] NOT NULL, [Diameter] [real] NULL, [DecayClass] [int] NOT NULL, [HeightToBreak] [int] NULL, [PartLength1] [int] NULL, [TopDiameter1] [int] NULL, [PartLength2] [int] NULL, [TopDiameter2] [int] NULL, [PartLength3] [int] NULL, [TopDiameter3] [int] NULL, [PartLength4] [int] NULL, [TopDiameter4] [int] NULL, [PileLength] [int] NULL, [Stems] [int] NULL, CONSTRAINT [InvTreeDead_PK] PRIMARY KEY CLUSTERED ( [TreeDeadGUID] ASC, [StratificationGUID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], UNIQUE NONCLUSTERED ( [TreeDeadGUID] ASC, [StratificationGUID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] /****** Object: Table [dbo].[InvTreatmentHistory] Script Date: 06/12/2009 11:53:08 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[InvTreatmentHistory]( [TreatmentHistoryGUID] [uniqueidentifier] NOT NULL, [ReferenceUnitGUID] [uniqueidentifier] NOT NULL, [StratificationGUID] [uniqueidentifier] NOT NULL, [TreatmentTypeCode] [int] NOT NULL, [YearsSinceTreatment] [int] NOT NULL ) ON [PRIMARY] /****** Object: Table [dbo].[InvSitePosition] Script Date: 06/12/2009 11:53:06 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[InvSitePosition]( [SitePositionGUID] [uniqueidentifier] NOT NULL, [ReferenceUnitGUID] [uniqueidentifier] NOT NULL, [StratificationGUID] [uniqueidentifier] NOT NULL, [Direction] [int] NULL, [PositionTypeCode] [int] NULL, [MaturityClassCode] [int] NULL, CONSTRAINT [InvSitePosition_PK] PRIMARY KEY CLUSTERED ( [SitePositionGUID] ASC, [StratificationGUID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], UNIQUE NONCLUSTERED ( [SitePositionGUID] ASC, [StratificationGUID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] /****** Object: Table [dbo].[InvReferenceUnitTree] Script Date: 06/11/2009 07:32:33 ******/ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[InvReferenceUnitTree]( [ReferenceUnitTreeGUID] [uniqueidentifier] NOT NULL, [ReferenceUnitGUID] [uniqueidentifier] NOT NULL, [StratificationGUID] [uniqueidentifier] NOT NULL, [EvenAgedCode] [int] NOT NULL, [MeanAgeBreastHeight] [real] NULL, [QualityPine] [int] NULL, [QualitySpruce] [int] NULL, CONSTRAINT [InvReferenceUnitTree_PK] PRIMARY KEY CLUSTERED ( [ReferenceUnitTreeGUID] ASC, [StratificationGUID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], UNIQUE NONCLUSTERED ( [ReferenceUnitTreeGUID] ASC, [StratificationGUID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] /****** Object: ForeignKey [FK_InvCorrectionFactor_TreatmentUnit] Script Date: 06/11/2009 07:32:04 ******/ ALTER TABLE [dbo].[InvCorrectionFactor] WITH CHECK ADD CONSTRAINT [FK_InvCorrectionFactor_TreatmentUnit] FOREIGN KEY([StandObjectGUID], [StratificationGUID]) REFERENCES [dbo].[InvTreatmentUnit] ([StandObjectGUID], [StratificationGUID]) ALTER TABLE [dbo].[InvCorrectionFactor] CHECK CONSTRAINT [FK_InvCorrectionFactor_TreatmentUnit] /****** Object: ForeignKey [FK_PlantBi_ReferenceUnitPlan] Script Date: 06/11/2009 07:32:08 ******/ ALTER TABLE [dbo].[InvPlantBi] WITH CHECK ADD CONSTRAINT [FK_PlantBi_ReferenceUnitPlan] FOREIGN KEY([ReferenceUnitPlantGUID], [StratificationGUID]) REFERENCES [dbo].[InvReferenceUnitPlant] ([ReferenceUnitPlantGUID], [StratificationGUID]) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE [dbo].[InvPlantBi] CHECK CONSTRAINT [FK_PlantBi_ReferenceUnitPlan] /****** Object: ForeignKey [FK_PlantMain_ReferenceUnitPlant] Script Date: 06/11/2009 07:32:11 ******/ ALTER TABLE [dbo].[InvPlantMain] WITH CHECK ADD CONSTRAINT [FK_PlantMain_ReferenceUnitPlant] FOREIGN KEY([ReferenceUnitPlantGUID], [StratificationGUID]) REFERENCES [dbo].[InvReferenceUnitPlant] ([ReferenceUnitPlantGUID], [StratificationGUID]) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE [dbo].[InvPlantMain] CHECK CONSTRAINT [FK_PlantMain_ReferenceUnitPlant] /****** Object: ForeignKey [FK_ReferenceUnit_TreatmentUnit] Script Date: 06/11/2009 07:32:18 ******/ ALTER TABLE [dbo].[InvReferenceUnit] WITH CHECK ADD CONSTRAINT [FK_ReferenceUnit_TreatmentUnit] FOREIGN KEY([StandObjectGUID], [StratificationGUID]) REFERENCES [dbo].[InvTreatmentUnit] ([StandObjectGUID], [StratificationGUID]) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE [dbo].[InvReferenceUnit] CHECK CONSTRAINT [FK_ReferenceUnit_TreatmentUnit] /****** Object: ForeignKey [FK_ReferenceUnitPlant_ReferenceUnit] Script Date: 06/11/2009 07:32:21 ******/ ALTER TABLE [dbo].[InvReferenceUnitPlant] WITH CHECK ADD CONSTRAINT [FK_ReferenceUnitPlant_ReferenceUnit] FOREIGN KEY([ReferenceUnitGUID], [StratificationGUID]) REFERENCES [dbo].[InvReferenceUnit] ([ReferenceUnitGUID], [StratificationGUID]) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE [dbo].[InvReferenceUnitPlant] CHECK CONSTRAINT [FK_ReferenceUnitPlant_ReferenceUnit] /****** Object: ForeignKey [FK_ReferenceUnitSiteData_ReferenceUnit] Script Date: 06/11/2009 07:32:30 ******/ ALTER TABLE [dbo].[InvReferenceUnitSiteData] WITH CHECK ADD CONSTRAINT [FK_ReferenceUnitSiteData_ReferenceUnit] FOREIGN KEY([ReferenceUnitGUID], [StratificationGUID]) REFERENCES [dbo].[InvReferenceUnit] ([ReferenceUnitGUID], [StratificationGUID]) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE [dbo].[InvReferenceUnitSiteData] CHECK CONSTRAINT [FK_ReferenceUnitSiteData_ReferenceUnit] /****** Object: ForeignKey [FK_ReferenceUnitTree_ReferenceUnit] Script Date: 06/11/2009 07:32:33 ******/ ALTER TABLE [dbo].[InvReferenceUnitTree] WITH CHECK ADD CONSTRAINT [FK_ReferenceUnitTree_ReferenceUnit] FOREIGN KEY([ReferenceUnitGUID],[StratificationGUID]) REFERENCES [dbo].[InvReferenceUnit] ([ReferenceUnitGUID], [StratificationGUID]) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE [dbo].[InvReferenceUnitTree] CHECK CONSTRAINT [FK_ReferenceUnitTree_ReferenceUnit] /****** Object: ForeignKey [FK_Tree_ReferenceUnitTree] Script Date: 06/11/2009 07:32:45 ******/ ALTER TABLE [dbo].[InvTree] WITH CHECK ADD CONSTRAINT [FK_Tree_ReferenceUnitTree] FOREIGN KEY([ReferenceUnitTreeGUID], [StratificationGUID]) REFERENCES [dbo].[InvReferenceUnitTree] ([ReferenceUnitTreeGUID], [StratificationGUID]) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE [dbo].[InvTree] CHECK CONSTRAINT [FK_Tree_ReferenceUnitTree] /****** Object: ForeignKey [FK_TreeDead_ReferenceUnit] Script Date: 06/11/2009 07:32:53 ******/ ALTER TABLE [dbo].[InvTreeDead] WITH CHECK ADD CONSTRAINT [FK_TreeDead_ReferenceUnit] FOREIGN KEY([ReferenceUnitGUID], [StratificationGUID]) REFERENCES [dbo].[InvReferenceUnit] ([ReferenceUnitGUID], [StratificationGUID]) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE [dbo].[InvTreeDead] CHECK CONSTRAINT [FK_TreeDead_ReferenceUnit] /****** Object: ForeignKey [FK_TreeSample_ReferenceUnitTree] Script Date: 06/11/2009 07:33:02 ******/ ALTER TABLE [dbo].[InvTreeSample] WITH CHECK ADD CONSTRAINT [FK_TreeSample_ReferenceUnitTree] FOREIGN KEY([ReferenceUnitTreeGUID], [StratificationGUID]) REFERENCES [dbo].[InvReferenceUnitTree] ([ReferenceUnitTreeGUID], [StratificationGUID]) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE [dbo].[InvTreeSample] CHECK CONSTRAINT [FK_TreeSample_ReferenceUnitTree] /****** Object: ForeignKey [FK_TreatmentHistory_ReferenceUnit] Script Date: 06/12/2009 11:53:09 ******/ ALTER TABLE [dbo].[InvTreatmentHistory] WITH CHECK ADD CONSTRAINT [FK_TreatmentHistory_ReferenceUnit] FOREIGN KEY([ReferenceUnitGUID], [StratificationGUID]) REFERENCES [dbo].[InvReferenceUnit] ([ReferenceUnitGUID], [StratificationGUID]) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE [dbo].[InvTreatmentHistory] CHECK CONSTRAINT [FK_TreatmentHistory_ReferenceUnit] /****** Object: ForeignKey [FK_SitePosition_ReferenceUnit] Script Date: 06/12/2009 11:53:06 ******/ ALTER TABLE [dbo].[InvSitePosition] WITH CHECK ADD CONSTRAINT [FK_SitePosition_ReferenceUnit] FOREIGN KEY([ReferenceUnitGUID], [StratificationGUID]) REFERENCES [dbo].[InvReferenceUnit] ([ReferenceUnitGUID], [StratificationGUID]) ON UPDATE CASCADE ON DELETE CASCADE ALTER TABLE [dbo].[InvSitePosition] CHECK CONSTRAINT [FK_SitePosition_ReferenceUnit] -- Update Version Table UPDATE Version SET ApplicationVersion = '0.6.0.1'; PRINT 'Success! Database upgrade to version 0.6.0.1'; END