Difference between revisions of "Heureka database upgrade script 0.6.0.0"

From Heureka Wiki
Jump to navigation Jump to search
 
(One intermediate revision by the same user not shown)
(No difference)

Latest revision as of 15:43, 14 July 2009

Back to scripts 

IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = '0.5.4.4') = 0
BEGIN
		PRINT 'Wrong Version of database. You must upgrade to version 0.5.4.4 before running this script.';
		SELECT ApplicationVersion FROM VERSION;
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
	/****** Object:  Table [dbo].[InvTreatmentUnit]    Script Date: 06/11/2009 07:32:39 ******/
	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
	)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,
		[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
	)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
	)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,
		[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
	)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
	)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,
		[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
	)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
	)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,
		[DateInsert] [datetime] NOT NULL,
		[PlantId] [int] NOT NULL,
		[SpeciesCode] [int] NOT NULL,
		[Height] [real] NULL,
	 CONSTRAINT [InvPlantMain_PK] PRIMARY KEY CLUSTERED 
	(
		[PlantGUID] 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
	)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
	)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,
		[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
	)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
	)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,
		[ImpedimentPercentage] [real] NULL,
		[RejuvenationProposal] [int] NULL,
		[CleaningProposal] [int] NULL,
	 CONSTRAINT [InvReferenceUnitPlant_PK] PRIMARY KEY CLUSTERED 
	(
		[ReferenceUnitPlantGUID] 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
	)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,
		[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
	)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
	)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,
		[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,
		[Direction] [int] NULL,
		[PositionTypeCode] [int] NULL,
		[MaturityClassCode] [int] NULL,
	 CONSTRAINT [InvSitePosition_PK] PRIMARY KEY CLUSTERED 
	(
		[SitePositionGUID] 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
	)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,
		[EvenAgedCode] [int] NOT NULL,
		[MeanAgeBreastHeight] [real] NULL,
		[QualityPine] [int] NULL,
		[QualitySpruce] [int] NULL,
	 CONSTRAINT [InvReferenceUnitTree_PK] PRIMARY KEY CLUSTERED 
	(
		[ReferenceUnitTreeGUID] 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
	)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])
	REFERENCES [dbo].[InvTreatmentUnit] ([StandObjectGUID])
	;
	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])
	REFERENCES [dbo].[InvReferenceUnitPlant] ([ReferenceUnitPlantGUID])
	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])
	REFERENCES [dbo].[InvReferenceUnitPlant] ([ReferenceUnitPlantGUID])
	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])
	REFERENCES [dbo].[InvTreatmentUnit] ([StandObjectGUID])
	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])
	REFERENCES [dbo].[InvReferenceUnit] ([ReferenceUnitGUID])
	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])
	REFERENCES [dbo].[InvReferenceUnit] ([ReferenceUnitGUID])
	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])
	REFERENCES [dbo].[InvReferenceUnit] ([ReferenceUnitGUID])
	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])
	REFERENCES [dbo].[InvReferenceUnitTree] ([ReferenceUnitTreeGUID])
	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])
	REFERENCES [dbo].[InvReferenceUnit] ([ReferenceUnitGUID])
	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])
	REFERENCES [dbo].[InvReferenceUnitTree] ([ReferenceUnitTreeGUID])
	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])
	REFERENCES [dbo].[InvReferenceUnit] ([ReferenceUnitGUID])
	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])
	REFERENCES [dbo].[InvReferenceUnit] ([ReferenceUnitGUID])
	ON UPDATE CASCADE
	ON DELETE CASCADE
	;
	ALTER TABLE [dbo].[InvSitePosition] CHECK CONSTRAINT [FK_SitePosition_ReferenceUnit]
	;

	-- Update version

	UPDATE Version SET ApplicationVersion = '0.6.0.0';
	PRINT 'Success! Database upgrade to version 0.6.0.0';

END
Retrieved from "https://www.heurekaslu.se/w/index.php?title=Heureka_database_upgrade_script_0.6.0.0&oldid=2767"