Peder at 14:03, 14 July 2009

2009-07-14T14:03:07Z

Peder at 13:41, 14 July 2009

2009-07-14T13:41:12Z

Peder at 13:37, 14 July 2009

2009-07-14T13:37:34Z

Cawa2: New page: Back to scripts

 IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = '0.6.0.0' OR ApplicationVersion = '0.6.0.0' ) = 0 BEGIN 	PRINT 'Wro...

2009-06-24T12:29:09Z

New page: Back to scripts <pre> IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = '0.6.0.0' OR ApplicationVersion = '0.6.0.0' ) = 0 BEGIN PRINT 'Wro...

New page

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

</pre>
[[Category:Database]]

← Older revision		Revision as of 14:03, 14 July 2009
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

← Older revision		Revision as of 13:41, 14 July 2009
Line 1:		Line 1:
−	~~[[Heureka database upgrade 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

← Older revision		Revision as of 13:37, 14 July 2009
Line 537:		Line 537:

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

Heureka database upgrade script 0.6.0.1 - Revision history

Peder at 14:03, 14 July 2009

Peder at 13:41, 14 July 2009

Peder at 13:37, 14 July 2009

Cawa2: New page: Back to scripts
IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = '0.6.0.0' OR ApplicationVersion = '0.6.0.0' ) = 0 BEGIN PRINT 'Wro...