https://www.heurekaslu.se/w/index.php?action=history&feed=atom&title=Heureka_database_upgrade_script_1.0.2.1 2026-05-05T20:48:57Z Revision history for this page on the wiki MediaWiki 1.35.13 https://www.heurekaslu.se/w/index.php?title=Heureka_database_upgrade_script_1.0.2.1&diff=3802&oldid=prev 2010-02-12T15:19:18Z

<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;1.0.2.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 /> <br /> &lt;pre&gt;<br /> IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = '1.0.2.0') = 0<br /> BEGIN<br /> PRINT 'Wrong Version of database. You must upgrade to version 1.0.2.0 before running this script.';<br /> END<br /> ELSE <br /> BEGIN <br /> <br /> -- 1. Drop column RejuvenationProposal<br /> <br /> -- 1.1 Drop column RejuvenationProposal from table InvReferenceUnitPlant<br /> IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'InvReferenceUnitPlant' AND COLUMN_NAME = 'RejuvenationProposal')<br /> BEGIN<br /> ALTER TABLE InvReferenceUnitPlant DROP COLUMN RejuvenationProposal<br /> END<br /> <br /> -- 1.2 Remove rows containing RejuvenationProposal for ReferenceUnitPlant from InventoryTemplate<br /> IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'InventoryTemplate')<br /> BEGIN<br /> DELETE FROM InventoryTemplate WHERE TableName = 'ReferenceUnitPlant' AND ColumnName = 'RejuvenationProposal'<br /> END<br /> <br /> -- 2. Add check constraint for column VegitationTypeCode in table ReferenceUnit<br /> IF (NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.CHECK_CONSTRAINTS WHERE CONSTRAINT_NAME = 'ck_ReferenceUnit_VegetationTypeCode')) AND<br /> (EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ReferenceUnit' AND COLUMN_NAME = 'VegetationTypeCode'))<br /> BEGIN<br /> ALTER TABLE [dbo].[ReferenceUnit] WITH CHECK ADD CONSTRAINT [ck_ReferenceUnit_VegetationTypeCode] CHECK (([VegetationTypeCode]&gt;=(0) AND [VegetationTypeCode]&lt;=(18)))<br /> ALTER TABLE [dbo].[ReferenceUnit] CHECK CONSTRAINT [ck_ReferenceUnit_VegetationTypeCode]<br /> <br /> END<br /> <br /> -- Update Version Table<br /> <br /> UPDATE Version SET ApplicationVersion = '1.0.2.1';<br /> PRINT 'Success! Database upgrade to version 1.0.2.1';<br /> END<br /> <br /> <br /> &lt;/pre&gt;<br /> [[Category:Database scripts]]</div>

Cawa2