Difference between revisions of "Heureka database upgrade script 0.5.4.2"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
− | [[ | + | [[:Category:Database scripts | Back to scripts]] |
<pre> | <pre> | ||
Line 52: | Line 52: | ||
</pre> | </pre> | ||
− | [[Category:Database]] | + | [[Category:Database scripts]] |
Latest revision as of 15:44, 14 July 2009
IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = '0.5.4.1') = 0 BEGIN PRINT 'Wrong Version of database. You must upgrade to version 0.5.4.1 before running this script.'; SELECT ApplicationVersion FROM VERSION; END ELSE BEGIN -- 1. Add new columns to InvTreatmentUnit IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'InvTreatmentUnit' AND COLUMN_NAME = 'TreatmentUnitParentGUID') BEGIN ALTER TABLE [dbo].[InvTreatmentUnit] ADD [TreatmentUnitParentGUID] [uniqueidentifier] NULL END -- 2. Add new columns to StandInventory IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'StandInventory' AND COLUMN_NAME = 'P1') BEGIN ALTER TABLE [dbo].[StandInventory] ADD [P1] [float] NULL END IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'StandInventory' AND COLUMN_NAME = 'P2') BEGIN ALTER TABLE [dbo].[StandInventory] ADD [P2] [float] NULL END IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'StandInventory' AND COLUMN_NAME = 'P3') BEGIN ALTER TABLE [dbo].[StandInventory] ADD [P3] [float] NULL END IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'StandInventory' AND COLUMN_NAME = 'StratumNo') BEGIN ALTER TABLE [dbo].[StandInventory] ADD [StratumNo] [int] NULL END IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'StandInventory' AND COLUMN_NAME = 'RepresentativeArea') BEGIN ALTER TABLE [dbo].[StandInventory] ADD [RepresentativeArea] [float] NULL END -- Update version UPDATE Version SET ApplicationVersion = '0.5.4.2'; PRINT 'Success! Database upgrade to version 0.5.4.2'; END