Difference between revisions of "Heureka database upgrade script 0.5.2.1"
Jump to navigation
Jump to search
(New page: Back to scripts <pre> </pre> Category:Database) |
|||
Line 1: | Line 1: | ||
[[Heureka database upgrade scripts | Back to scripts]] | [[Heureka database upgrade scripts | Back to scripts]] | ||
<pre> | <pre> | ||
+ | IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = '0.5.2' OR ApplicationVersion = '0.5.2.1' ) = 0 | ||
+ | BEGIN | ||
+ | PRINT 'Wrong Version of database. You must upgrade to version 0.5.2 before running this script.'; | ||
+ | SELECT ApplicationVersion FROM VERSION; | ||
+ | END | ||
+ | ELSE | ||
+ | BEGIN | ||
+ | -- 1. Add new columns for to InitialState_SiteData and InitialState_PredictionUnit | ||
+ | |||
+ | IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'InitialState_SiteData' AND COLUMN_NAME = 'SoilMoistCode') | ||
+ | BEGIN | ||
+ | ALTER TABLE [dbo].[InitialState_SiteData] ADD | ||
+ | [SoilMoistCode] [int] NULL, | ||
+ | [Peat] [bit] NULL | ||
+ | END | ||
+ | |||
+ | IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'InitialState_PredictionUnit' AND COLUMN_NAME = 'SoilMoistCode') | ||
+ | BEGIN | ||
+ | ALTER TABLE [dbo].[InitialState_PredictionUnit] ADD | ||
+ | [SoilMoistCode] [int] NULL, | ||
+ | [Peat] [bit] NULL | ||
+ | END | ||
+ | |||
+ | -- Update Version Table | ||
+ | |||
+ | UPDATE Version SET ApplicationVersion = '0.5.2.1'; | ||
+ | |||
+ | PRINT 'Success! Database upgrade to version 0.5.2.1'; | ||
+ | |||
+ | END | ||
</pre> | </pre> | ||
[[Category:Database]] | [[Category:Database]] |
Revision as of 16:20, 18 March 2009
IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = '0.5.2' OR ApplicationVersion = '0.5.2.1' ) = 0 BEGIN PRINT 'Wrong Version of database. You must upgrade to version 0.5.2 before running this script.'; SELECT ApplicationVersion FROM VERSION; END ELSE BEGIN -- 1. Add new columns for to InitialState_SiteData and InitialState_PredictionUnit IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'InitialState_SiteData' AND COLUMN_NAME = 'SoilMoistCode') BEGIN ALTER TABLE [dbo].[InitialState_SiteData] ADD [SoilMoistCode] [int] NULL, [Peat] [bit] NULL END IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'InitialState_PredictionUnit' AND COLUMN_NAME = 'SoilMoistCode') BEGIN ALTER TABLE [dbo].[InitialState_PredictionUnit] ADD [SoilMoistCode] [int] NULL, [Peat] [bit] NULL END -- Update Version Table UPDATE Version SET ApplicationVersion = '0.5.2.1'; PRINT 'Success! Database upgrade to version 0.5.2.1'; END