https://www.heurekaslu.se/w/index.php?action=history&feed=atom&title=Heureka_database_upgrade_script_0.8.0.1 2026-05-05T22:12:07Z Revision history for this page on the wiki MediaWiki 1.35.13 https://www.heurekaslu.se/w/index.php?title=Heureka_database_upgrade_script_0.8.0.1&diff=3376&oldid=prev 2009-10-10T07:33:17Z

<p>New page: <a href="/wiki/Category:Database_scripts" title="Category:Database scripts"> Back to scripts</a> &lt;pre&gt; IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = &#039;0.8.0.0&#039;) = 0 BEGIN PRINT &#039;Wrong Version of database. You must upgrade ...</p> <p><b>New page</b></p><div>[[:Category:Database scripts | Back to scripts]]<br /> &lt;pre&gt;<br /> IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = '0.8.0.0') = 0<br /> BEGIN<br /> PRINT 'Wrong Version of database. You must upgrade to version 0.8.0.0 before running this script.';<br /> END<br /> ELSE <br /> BEGIN <br /> <br /> -- 1. Add new columns to InitialState_BiomassData<br /> <br /> IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'InitialState_BiomassData' AND COLUMN_NAME = 'AboveGroundMassTotal')<br /> BEGIN<br /> ALTER TABLE InitialState_BiomassData ADD<br /> [AboveGroundMassTotal] [float] NULL,<br /> [BelowGroundMassTotal] [float] NULL<br /> <br /> END<br /> <br /> <br /> <br /> -- Update Version Table<br /> <br /> UPDATE Version SET ApplicationVersion = '0.8.0.1';<br /> PRINT 'Success! Database upgrade to version 0.8.0.1';<br /> END<br /> <br /> &lt;/pre&gt;<br /> [[Category:Database scripts]]</div>

Peder