https://www.heurekaslu.se/w/index.php?action=history&feed=atom&title=Heureka_database_upgrade_script_0.7.0.0 2026-05-05T20:48:29Z Revision history for this page on the wiki MediaWiki 1.35.13 https://www.heurekaslu.se/w/index.php?title=Heureka_database_upgrade_script_0.7.0.0&diff=2974&oldid=prev 2009-08-21T12:50:12Z

<p>New page: <a href="/wiki/Category:Database_scripts" title="Category:Database scripts"> Back to scripts</a> &lt;pre&gt; IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = &#039;0.6.0.2&#039; OR ApplicationVersion = &#039;0.6.0.3&#039; OR ApplicationVersion = &#039;0.7....</p> <p><b>New page</b></p><div>[[:Category:Database scripts | Back to scripts]]<br /> &lt;pre&gt;<br /> IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = '0.6.0.2' OR ApplicationVersion = '0.6.0.3' OR ApplicationVersion = '0.7.0.0') = 0<br /> BEGIN<br /> PRINT 'Wrong Version of database. You must upgrade to version 0.6.0.2 before running this script.';<br /> END<br /> ELSE <br /> BEGIN <br /> <br /> -- 1. Rename columns in InitialState_StatisticsData<br /> <br /> IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'InitialState_StatisticsData' AND COLUMN_NAME = 'Volume_ConfidenceInterval')<br /> BEGIN<br /> exec sp_rename 'InitialState_StatisticsData.Volume_ConfidenceInterval', 'VolumeStdDev', 'COLUMN';<br /> exec sp_rename 'InitialState_StatisticsData.Diameter_ConfidenceInterval', 'DiameterStdDev', 'COLUMN';<br /> exec sp_rename 'InitialState_StatisticsData.Age_ConfidenceInterval', 'AgeStdDev', 'COLUMN';<br /> exec sp_rename 'InitialState_StatisticsData.Stems_ConfidenceInterval', 'StemsStdDev', 'COLUMN';<br /> exec sp_rename 'InitialState_StatisticsData.Height_ConfidenceInterval', 'HeightStdDev', 'COLUMN';<br /> <br /> exec sp_rename 'InitialState_StatisticsData.Volume_StandardError', 'VolumeStdErr', 'COLUMN';<br /> exec sp_rename 'InitialState_StatisticsData.Diameter_StandardError', 'DiameterStdErr', 'COLUMN';<br /> exec sp_rename 'InitialState_StatisticsData.Age_StandardError', 'AgeStdErr', 'COLUMN';<br /> exec sp_rename 'InitialState_StatisticsData.Stems_StandardError', 'StemsStdErr', 'COLUMN';<br /> exec sp_rename 'InitialState_StatisticsData.Height_StandardError', 'HeightStdErr', 'COLUMN';<br /> <br /> exec sp_rename 'InitialState_StatisticsData.Volume_TotalPerHa', 'VolumeAvg', 'COLUMN';<br /> exec sp_rename 'InitialState_StatisticsData.Stems_TotalPerHa', 'StemsAvg', 'COLUMN';<br /> exec sp_rename 'InitialState_StatisticsData.Diameter_MeanValue', 'DiameterAvg', 'COLUMN';<br /> exec sp_rename 'InitialState_StatisticsData.Age_MeanValue', 'AgeAvg', 'COLUMN';<br /> exec sp_rename 'InitialState_StatisticsData.Height_MeanValue', 'HeightAvg', 'COLUMN';<br /> END<br /> <br /> -- 2. Add columns for sample plot to TreatmentUnit and InitialState_TreatmentUnit<br /> <br /> IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'TreatmentUnit' AND COLUMN_NAME = 'IsSamplePlot')<br /> BEGIN <br /> ALTER TABLE [TreatmentUnit] ADD<br /> [IsSamplePlot] [bit] NOT NULL CONSTRAINT [DF_TreatmentUnit_IsSamplePlot] DEFAULT ((0)),<br /> [IsCircular] [bit] NOT NULL CONSTRAINT [DF_TreatmentUnit_IsCircular] DEFAULT ((0))<br /> <br /> ALTER TABLE [InitialState_TreatmentUnit] ADD<br /> [IsSamplePlot] [bit] NOT NULL CONSTRAINT [DF_InitialState_TreatmentUnit_IsSamplePlot] DEFAULT ((0))<br /> END<br /> <br /> -- 3. Add columns to InitialState<br /> <br /> IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'InitialState_ForestData' AND COLUMN_NAME = 'ArithmeticMeanAgeTotal')<br /> BEGIN <br /> ALTER TABLE [InitialState_ForestData] ADD<br /> [ArithmeticMeanAgeTotal] [float] NULL,<br /> [ArithmeticMeanAgeTotalExclOverstorey] [float] NULL<br /> <br /> ALTER TABLE [InitialState_PredictionUnit] ADD<br /> [ArithmeticMeanAgeTotal] [float] NULL<br /> END<br /> <br /> -- 4. Change site index in StandObject<br /> <br /> ALTER TABLE StandObject<br /> DROP CONSTRAINT [DF_StandObject_SiteIndex]<br /> <br /> ALTER TABLE StandObject<br /> ALTER COLUMN [SiteIndex] [real] NULL <br /> <br /> ALTER TABLE StandObject<br /> ADD CONSTRAINT [DF_StandObject_SiteIndex] DEFAULT ((0)) FOR [SiteIndex]<br /> <br /> -- 5. Add column for meanHeightArithmetic to ReferenceUnit<br /> <br /> IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ReferenceUnit' AND COLUMN_NAME = 'MeanHeightArithmetic')<br /> BEGIN<br /> ALTER TABLE [ReferenceUnit] ADD<br /> [MeanHeightArithmetic] [real] NULL<br /> END<br /> <br /> -- 6. Add column for SampleDesign to InvTreatmentUnit<br /> <br /> IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'InvTreatmentUnit' AND COLUMN_NAME = 'SampleDesign')<br /> BEGIN<br /> ALTER TABLE [InvTreatmentUnit] ADD<br /> [SampleDesign] [varchar](50) NULL<br /> END<br /> <br /> -- Update Version Table<br /> <br /> UPDATE Version SET ApplicationVersion = '0.7.0.0';<br /> <br /> PRINT 'Success! Database upgrade to version 0.7.0.0';<br /> END<br /> <br /> <br /> &lt;/pre&gt;<br /> [[Category:Database scripts]]</div>

Cawa2