Heureka database upgrade script 0.6.0.1

From Heureka Wiki
Jump to navigation Jump to search

Back to scripts 

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
Retrieved from "https://www.heurekaslu.se/w/index.php?title=Heureka_database_upgrade_script_0.6.0.1&oldid=2787"