Difference between revisions of "Heureka database upgrade script 0.8.0.1"
Jump to navigation
Jump to search
(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 ...) |
(No difference)
|
Latest revision as of 09:33, 10 October 2009
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