Heureka database upgrade script 0.8.0.1
Jump to navigation
Jump to search
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