Heureka database upgrade script 0.8.0.1
Revision as of 09:33, 10 October 2009 by Peder (talk | contribs) (New page: Back to scripts <pre> IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = '0.8.0.0') = 0 BEGIN PRINT 'Wrong Version of database. You must upgrade ...)
IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = '0.8.0.0') = 0 BEGIN PRINT 'Wrong Version of database. You must upgrade to version 0.8.0.0 before running this script.'; END ELSE BEGIN -- 1. Add new columns to InitialState_BiomassData IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'InitialState_BiomassData' AND COLUMN_NAME = 'AboveGroundMassTotal') BEGIN ALTER TABLE InitialState_BiomassData ADD [AboveGroundMassTotal] [float] NULL, [BelowGroundMassTotal] [float] NULL END -- Update Version Table UPDATE Version SET ApplicationVersion = '0.8.0.1'; PRINT 'Success! Database upgrade to version 0.8.0.1'; END