<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="en">
	<id>https://www.heurekaslu.se/w/index.php?action=history&amp;feed=atom&amp;title=Heureka_database_upgrade_script_0.5.4.0</id>
	<title>Heureka database upgrade script 0.5.4.0 - Revision history</title>
	<link rel="self" type="application/atom+xml" href="https://www.heurekaslu.se/w/index.php?action=history&amp;feed=atom&amp;title=Heureka_database_upgrade_script_0.5.4.0"/>
	<link rel="alternate" type="text/html" href="https://www.heurekaslu.se/w/index.php?title=Heureka_database_upgrade_script_0.5.4.0&amp;action=history"/>
	<updated>2026-11-19T02:53:51Z</updated>
	<subtitle>Revision history for this page on the wiki</subtitle>
	<generator>MediaWiki 1.43.11</generator>
	<entry>
		<id>https://www.heurekaslu.se/w/index.php?title=Heureka_database_upgrade_script_0.5.4.0&amp;diff=2771&amp;oldid=prev</id>
		<title>Peder at 13:46, 14 July 2009</title>
		<link rel="alternate" type="text/html" href="https://www.heurekaslu.se/w/index.php?title=Heureka_database_upgrade_script_0.5.4.0&amp;diff=2771&amp;oldid=prev"/>
		<updated>2009-07-14T13:46:03Z</updated>

		<summary type="html">&lt;p&gt;&lt;/p&gt;
&lt;table style=&quot;background-color: #fff; color: #202122;&quot; data-mw=&quot;interface&quot;&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;tr class=&quot;diff-title&quot; lang=&quot;en&quot;&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #202122; text-align: center;&quot;&gt;← Older revision&lt;/td&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #202122; text-align: center;&quot;&gt;Revision as of 14:46, 14 July 2009&lt;/td&gt;
				&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot; id=&quot;mw-diff-left-l1&quot;&gt;Line 1:&lt;/td&gt;
&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot;&gt;Line 1:&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;−&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;[[&lt;del style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;Heureka database upgrade &lt;/del&gt;scripts | Back to scripts]]&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;[[&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;:Category:Database &lt;/ins&gt;scripts | Back to scripts]]&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;lt;pre&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;lt;pre&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = &amp;#039;0.5.3.2&amp;#039;) = 0&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = &amp;#039;0.5.3.2&amp;#039;) = 0&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot; id=&quot;mw-diff-left-l366&quot;&gt;Line 366:&lt;/td&gt;
&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot;&gt;Line 366:&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;br&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;br&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;lt;/pre&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;lt;/pre&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;−&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;[[Category:Database]]&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;[[Category:Database &lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;scripts&lt;/ins&gt;]]&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;/table&gt;</summary>
		<author><name>Peder</name></author>
	</entry>
	<entry>
		<id>https://www.heurekaslu.se/w/index.php?title=Heureka_database_upgrade_script_0.5.4.0&amp;diff=2050&amp;oldid=prev</id>
		<title>Fkl at 13:52, 1 June 2009</title>
		<link rel="alternate" type="text/html" href="https://www.heurekaslu.se/w/index.php?title=Heureka_database_upgrade_script_0.5.4.0&amp;diff=2050&amp;oldid=prev"/>
		<updated>2009-06-01T13:52:42Z</updated>

		<summary type="html">&lt;p&gt;&lt;/p&gt;
&lt;table style=&quot;background-color: #fff; color: #202122;&quot; data-mw=&quot;interface&quot;&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;tr class=&quot;diff-title&quot; lang=&quot;en&quot;&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #202122; text-align: center;&quot;&gt;← Older revision&lt;/td&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #202122; text-align: center;&quot;&gt;Revision as of 14:52, 1 June 2009&lt;/td&gt;
				&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot; id=&quot;mw-diff-left-l1&quot;&gt;Line 1:&lt;/td&gt;
&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot;&gt;Line 1:&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;[[Heureka database upgrade scripts | Back to scripts]]&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;[[Heureka database upgrade scripts | Back to scripts]]&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;−&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;del style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;[[Category:Database]]&lt;/del&gt;&lt;/div&gt;&lt;/td&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-added&quot;&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;lt;pre&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;lt;pre&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = &amp;#039;0.5.3.2&amp;#039;) = 0&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = &amp;#039;0.5.3.2&amp;#039;) = 0&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot; id=&quot;mw-diff-left-l367&quot;&gt;Line 367:&lt;/td&gt;
&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot;&gt;Line 366:&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;br&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;br&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;lt;/pre&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;lt;/pre&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;[[Category:Database]]&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;/table&gt;</summary>
		<author><name>Fkl</name></author>
	</entry>
	<entry>
		<id>https://www.heurekaslu.se/w/index.php?title=Heureka_database_upgrade_script_0.5.4.0&amp;diff=2049&amp;oldid=prev</id>
		<title>Fkl at 13:51, 1 June 2009</title>
		<link rel="alternate" type="text/html" href="https://www.heurekaslu.se/w/index.php?title=Heureka_database_upgrade_script_0.5.4.0&amp;diff=2049&amp;oldid=prev"/>
		<updated>2009-06-01T13:51:41Z</updated>

		<summary type="html">&lt;p&gt;&lt;/p&gt;
&lt;table style=&quot;background-color: #fff; color: #202122;&quot; data-mw=&quot;interface&quot;&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;tr class=&quot;diff-title&quot; lang=&quot;en&quot;&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #202122; text-align: center;&quot;&gt;← Older revision&lt;/td&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #202122; text-align: center;&quot;&gt;Revision as of 14:51, 1 June 2009&lt;/td&gt;
				&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot; id=&quot;mw-diff-left-l1&quot;&gt;Line 1:&lt;/td&gt;
&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot;&gt;Line 1:&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;[[Heureka database upgrade scripts | Back to scripts]]&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;[[Category:Database]]&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;lt;pre&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;lt;pre&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = &amp;#039;0.5.3.2&amp;#039;) = 0&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = &amp;#039;0.5.3.2&amp;#039;) = 0&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;/table&gt;</summary>
		<author><name>Fkl</name></author>
	</entry>
	<entry>
		<id>https://www.heurekaslu.se/w/index.php?title=Heureka_database_upgrade_script_0.5.4.0&amp;diff=2048&amp;oldid=prev</id>
		<title>Fkl: New page: &lt;pre&gt; IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = &#039;0.5.3.2&#039;) = 0 BEGIN 		PRINT &#039;Wrong Version of database. You must upgrade to version 0.5.3.2 before running this script.&#039;;...</title>
		<link rel="alternate" type="text/html" href="https://www.heurekaslu.se/w/index.php?title=Heureka_database_upgrade_script_0.5.4.0&amp;diff=2048&amp;oldid=prev"/>
		<updated>2009-06-01T13:50:33Z</updated>

		<summary type="html">&lt;p&gt;New page: &amp;lt;pre&amp;gt; IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = &amp;#039;0.5.3.2&amp;#039;) = 0 BEGIN 		PRINT &amp;#039;Wrong Version of database. You must upgrade to version 0.5.3.2 before running this script.&amp;#039;;...&lt;/p&gt;
&lt;p&gt;&lt;b&gt;New page&lt;/b&gt;&lt;/p&gt;&lt;div&gt;&amp;lt;pre&amp;gt;&lt;br /&gt;
IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = &amp;#039;0.5.3.2&amp;#039;) = 0&lt;br /&gt;
BEGIN&lt;br /&gt;
		PRINT &amp;#039;Wrong Version of database. You must upgrade to version 0.5.3.2 before running this script.&amp;#039;;&lt;br /&gt;
		SELECT ApplicationVersion FROM VERSION;&lt;br /&gt;
END&lt;br /&gt;
ELSE &lt;br /&gt;
BEGIN&lt;br /&gt;
&lt;br /&gt;
	SET ANSI_NULLS ON;&lt;br /&gt;
	SET QUOTED_IDENTIFIER ON;&lt;br /&gt;
	SET ANSI_PADDING ON;&lt;br /&gt;
&lt;br /&gt;
	-- 1. Add new column for ObjectID to GIS_Polygon &lt;br /&gt;
&lt;br /&gt;
	IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = &amp;#039;GIS_Polygon&amp;#039; AND COLUMN_NAME = &amp;#039;ObjectId&amp;#039;)&lt;br /&gt;
	BEGIN&lt;br /&gt;
		ALTER TABLE [dbo].[GIS_Polygon] ADD&lt;br /&gt;
			[ObjectId] [int] NULL&lt;br /&gt;
	END&lt;br /&gt;
&lt;br /&gt;
	-- 2. Create new stratification database&lt;br /&gt;
	-- 2.1. Drop StratumStandObjectJunction&lt;br /&gt;
&lt;br /&gt;
	IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N&amp;#039;[dbo].[FK_StratumStandObjectJunction_StandObject]&amp;#039;) AND parent_object_id = OBJECT_ID(N&amp;#039;[dbo].[StratumStandObjectJunction]&amp;#039;))&lt;br /&gt;
	ALTER TABLE [dbo].[StratumStandObjectJunction] DROP CONSTRAINT [FK_StratumStandObjectJunction_StandObject];&lt;br /&gt;
&lt;br /&gt;
	IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N&amp;#039;[dbo].[FK_StratumStandObjectJunction_Stratum]&amp;#039;) AND parent_object_id = OBJECT_ID(N&amp;#039;[dbo].[StratumStandObjectJunction]&amp;#039;))&lt;br /&gt;
	ALTER TABLE [dbo].[StratumStandObjectJunction] DROP CONSTRAINT [FK_StratumStandObjectJunction_Stratum];&lt;br /&gt;
&lt;br /&gt;
	IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N&amp;#039;[dbo].[StratumStandObjectJunction]&amp;#039;) AND type in (N&amp;#039;U&amp;#039;))&lt;br /&gt;
	DROP TABLE [dbo].[StratumStandObjectJunction];&lt;br /&gt;
&lt;br /&gt;
	-- 2.2.  Drop StratumConditionJunction&lt;br /&gt;
&lt;br /&gt;
	IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N&amp;#039;[dbo].[FK_StratumConditionJunction_Stratum]&amp;#039;) AND parent_object_id = OBJECT_ID(N&amp;#039;[dbo].[StratumConditionJunction]&amp;#039;))&lt;br /&gt;
	ALTER TABLE [dbo].[StratumConditionJunction] DROP CONSTRAINT [FK_StratumConditionJunction_Stratum];&lt;br /&gt;
&lt;br /&gt;
	IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N&amp;#039;[dbo].[FK_StratumConditionJunction_StratumCondition]&amp;#039;) AND parent_object_id = OBJECT_ID(N&amp;#039;[dbo].[StratumConditionJunction]&amp;#039;))&lt;br /&gt;
	ALTER TABLE [dbo].[StratumConditionJunction] DROP CONSTRAINT [FK_StratumConditionJunction_StratumCondition];&lt;br /&gt;
&lt;br /&gt;
	IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N&amp;#039;[dbo].[StratumConditionJunction]&amp;#039;) AND type in (N&amp;#039;U&amp;#039;))&lt;br /&gt;
	DROP TABLE [dbo].[StratumConditionJunction];&lt;br /&gt;
&lt;br /&gt;
	-- 2.3. Drop StratumConditionDetailValue&lt;br /&gt;
&lt;br /&gt;
	IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N&amp;#039;[dbo].[FK_StratumConditionDetailValue_StratumConditionDetailValue]&amp;#039;) AND parent_object_id = OBJECT_ID(N&amp;#039;[dbo].[StratumConditionDetailValue]&amp;#039;))&lt;br /&gt;
	ALTER TABLE [dbo].[StratumConditionDetailValue] DROP CONSTRAINT [FK_StratumConditionDetailValue_StratumConditionDetailValue];&lt;br /&gt;
&lt;br /&gt;
	IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N&amp;#039;[dbo].[StratumConditionDetailValue]&amp;#039;) AND type in (N&amp;#039;U&amp;#039;))&lt;br /&gt;
	DROP TABLE [dbo].[StratumConditionDetailValue];&lt;br /&gt;
&lt;br /&gt;
	-- 2.4. Drop StratumConditionDetail&lt;br /&gt;
&lt;br /&gt;
	IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N&amp;#039;[dbo].[FK_StratumConditionDetail_StratumCondition]&amp;#039;) AND parent_object_id = OBJECT_ID(N&amp;#039;[dbo].[StratumConditionDetail]&amp;#039;))&lt;br /&gt;
	ALTER TABLE [dbo].[StratumConditionDetail] DROP CONSTRAINT [FK_StratumConditionDetail_StratumCondition];&lt;br /&gt;
&lt;br /&gt;
	IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N&amp;#039;[dbo].[StratumConditionDetail]&amp;#039;) AND type in (N&amp;#039;U&amp;#039;))&lt;br /&gt;
	DROP TABLE [dbo].[StratumConditionDetail];&lt;br /&gt;
&lt;br /&gt;
	-- 2.5. Drop StratumCondition&lt;br /&gt;
&lt;br /&gt;
	IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N&amp;#039;[dbo].[FK_StratumCondition_Stratification]&amp;#039;) AND parent_object_id = OBJECT_ID(N&amp;#039;[dbo].[StratumCondition]&amp;#039;))&lt;br /&gt;
	ALTER TABLE [dbo].[StratumCondition] DROP CONSTRAINT [FK_StratumCondition_Stratification];&lt;br /&gt;
&lt;br /&gt;
	IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N&amp;#039;[dbo].[StratumCondition]&amp;#039;) AND type in (N&amp;#039;U&amp;#039;))&lt;br /&gt;
	DROP TABLE [dbo].[StratumCondition];&lt;br /&gt;
&lt;br /&gt;
	-- 2.6. Drop Stratum table&lt;br /&gt;
&lt;br /&gt;
	IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N&amp;#039;[dbo].[FK_Strata_Strata]&amp;#039;) AND parent_object_id = OBJECT_ID(N&amp;#039;[dbo].[Stratum]&amp;#039;))&lt;br /&gt;
	ALTER TABLE [dbo].[Stratum] DROP CONSTRAINT [FK_Strata_Strata];&lt;br /&gt;
&lt;br /&gt;
	IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N&amp;#039;[dbo].[FK_Strata_Stratification]&amp;#039;) AND parent_object_id = OBJECT_ID(N&amp;#039;[dbo].[Stratum]&amp;#039;))&lt;br /&gt;
	ALTER TABLE [dbo].[Stratum] DROP CONSTRAINT [FK_Strata_Stratification];&lt;br /&gt;
&lt;br /&gt;
	IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N&amp;#039;[dbo].[Stratum]&amp;#039;) AND type in (N&amp;#039;U&amp;#039;))&lt;br /&gt;
	DROP TABLE [dbo].[Stratum];&lt;br /&gt;
&lt;br /&gt;
	-- 2.7. Drop StrataMatrixValue&lt;br /&gt;
&lt;br /&gt;
	IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N&amp;#039;[dbo].[FK_StrataMatrixValue_StrataMatrix]&amp;#039;) AND parent_object_id = OBJECT_ID(N&amp;#039;[dbo].[StrataMatrixValue]&amp;#039;))&lt;br /&gt;
	ALTER TABLE [dbo].[StrataMatrixValue] DROP CONSTRAINT [FK_StrataMatrixValue_StrataMatrix];&lt;br /&gt;
&lt;br /&gt;
	IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N&amp;#039;[dbo].[StrataMatrixValue]&amp;#039;) AND type in (N&amp;#039;U&amp;#039;))&lt;br /&gt;
	DROP TABLE [dbo].[StrataMatrixValue];&lt;br /&gt;
&lt;br /&gt;
	-- 2.8. Drop StrataMatrixInterval&lt;br /&gt;
&lt;br /&gt;
	IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N&amp;#039;[dbo].[FK_StrataMatrixInterval_StrataMatrix]&amp;#039;) AND parent_object_id = OBJECT_ID(N&amp;#039;[dbo].[StrataMatrixInterval]&amp;#039;))&lt;br /&gt;
	ALTER TABLE [dbo].[StrataMatrixInterval] DROP CONSTRAINT [FK_StrataMatrixInterval_StrataMatrix];&lt;br /&gt;
&lt;br /&gt;
	IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N&amp;#039;[dbo].[StrataMatrixInterval]&amp;#039;) AND type in (N&amp;#039;U&amp;#039;))&lt;br /&gt;
	DROP TABLE [dbo].[StrataMatrixInterval];&lt;br /&gt;
&lt;br /&gt;
	-- 2.9. Drop StrataMatrix&lt;br /&gt;
&lt;br /&gt;
	IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N&amp;#039;[dbo].[FK_StrataMatrix_Stratification]&amp;#039;) AND parent_object_id = OBJECT_ID(N&amp;#039;[dbo].[StrataMatrix]&amp;#039;))&lt;br /&gt;
	ALTER TABLE [dbo].[StrataMatrix] DROP CONSTRAINT [FK_StrataMatrix_Stratification];&lt;br /&gt;
&lt;br /&gt;
	IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N&amp;#039;[dbo].[StrataMatrix]&amp;#039;) AND type in (N&amp;#039;U&amp;#039;))&lt;br /&gt;
	DROP TABLE [dbo].[StrataMatrix];&lt;br /&gt;
&lt;br /&gt;
	-- 2.10. Drop Stratification table&lt;br /&gt;
&lt;br /&gt;
	IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N&amp;#039;[dbo].[FK_Stratification_StandRegister]&amp;#039;) AND parent_object_id = OBJECT_ID(N&amp;#039;[dbo].[Stratification]&amp;#039;))&lt;br /&gt;
	ALTER TABLE [dbo].[Stratification] DROP CONSTRAINT [FK_Stratification_StandRegister];&lt;br /&gt;
&lt;br /&gt;
	IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N&amp;#039;[dbo].[Stratification]&amp;#039;) AND type in (N&amp;#039;U&amp;#039;))&lt;br /&gt;
	DROP TABLE [dbo].[Stratification];&lt;br /&gt;
&lt;br /&gt;
	-- 2.11. Create ClassDescription&lt;br /&gt;
&lt;br /&gt;
	IF OBJECT_ID (&amp;#039;dbo.ClassDescription&amp;#039;,&amp;#039;U&amp;#039;) IS NULL&lt;br /&gt;
	BEGIN&lt;br /&gt;
		CREATE TABLE [dbo].[ClassDescription](&lt;br /&gt;
			[ClassGuid] [uniqueidentifier] NOT NULL,&lt;br /&gt;
			[PropertyName] [varchar](50) COLLATE Finnish_Swedish_CI_AS NOT NULL,&lt;br /&gt;
			[Species] [varchar](50) COLLATE Finnish_Swedish_CI_AS NOT NULL,&lt;br /&gt;
			[ClassWidth] [float] NOT NULL,&lt;br /&gt;
			[NumberOfClasses] [int] NOT NULL,&lt;br /&gt;
		 CONSTRAINT [PK_ClassDescription] PRIMARY KEY CLUSTERED &lt;br /&gt;
		(&lt;br /&gt;
			[ClassGuid] ASC&lt;br /&gt;
		)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]&lt;br /&gt;
		) ON [PRIMARY];&lt;br /&gt;
	END&lt;br /&gt;
&lt;br /&gt;
	-- 2.12. Create ContingencyTable&lt;br /&gt;
&lt;br /&gt;
	IF OBJECT_ID (&amp;#039;dbo.ContingencyTable&amp;#039;,&amp;#039;U&amp;#039;) IS NULL&lt;br /&gt;
	BEGIN&lt;br /&gt;
		CREATE TABLE [dbo].[ContingencyTable](&lt;br /&gt;
			[TableGuid] [uniqueidentifier] NOT NULL,&lt;br /&gt;
			[RowClassGuid] [uniqueidentifier] NOT NULL,&lt;br /&gt;
			[ColumnClassGuid] [uniqueidentifier] NOT NULL,&lt;br /&gt;
			[DefaultCellValue] [float] NULL,&lt;br /&gt;
		 CONSTRAINT [PK_ContingencyTable] PRIMARY KEY CLUSTERED &lt;br /&gt;
		(&lt;br /&gt;
			[TableGuid] ASC&lt;br /&gt;
		)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]&lt;br /&gt;
		) ON [PRIMARY];&lt;br /&gt;
		ALTER TABLE [dbo].[ContingencyTable]  WITH CHECK ADD  CONSTRAINT [FK_ContingencyTable_ColumnClassDescription] FOREIGN KEY([ColumnClassGuid])&lt;br /&gt;
		REFERENCES [dbo].[ClassDescription] ([ClassGuid]);&lt;br /&gt;
		ALTER TABLE [dbo].[ContingencyTable] CHECK CONSTRAINT [FK_ContingencyTable_ColumnClassDescription];&lt;br /&gt;
		ALTER TABLE [dbo].[ContingencyTable]  WITH CHECK ADD  CONSTRAINT [FK_ContingencyTable_RowClassDescription] FOREIGN KEY([RowClassGuid])&lt;br /&gt;
		REFERENCES [dbo].[ClassDescription] ([ClassGuid]);&lt;br /&gt;
		ALTER TABLE [dbo].[ContingencyTable] CHECK CONSTRAINT [FK_ContingencyTable_RowClassDescription];&lt;br /&gt;
	END&lt;br /&gt;
&lt;br /&gt;
	-- 2.13. Create Stratification &lt;br /&gt;
&lt;br /&gt;
	IF OBJECT_ID (&amp;#039;dbo.Stratification&amp;#039;,&amp;#039;U&amp;#039;) IS NULL&lt;br /&gt;
	BEGIN&lt;br /&gt;
		CREATE TABLE [dbo].[Stratification](&lt;br /&gt;
			[StratificationGUID] [uniqueidentifier] NOT NULL,&lt;br /&gt;
			[Description] [varchar](50) COLLATE Finnish_Swedish_CI_AS NULL,&lt;br /&gt;
			[CreatedDate] [datetime] NOT NULL,&lt;br /&gt;
			[CreatedBy] [varchar](50) COLLATE Finnish_Swedish_CI_AS NOT NULL,&lt;br /&gt;
			[StandRegisterId] [int] NULL,&lt;br /&gt;
			[DesiredTotalNoOfSamples] [int] NULL,&lt;br /&gt;
			[MaxAreaProportion] [int] NOT NULL,&lt;br /&gt;
			[RandomSeed] [int] NULL,&lt;br /&gt;
			[P1] [float] NOT NULL,&lt;br /&gt;
			[P3] [float] NOT NULL,&lt;br /&gt;
			[NoOfPlotsTableGuid] [uniqueidentifier] NOT NULL,&lt;br /&gt;
			[PlotRadiusTableGuid] [uniqueidentifier] NOT NULL,&lt;br /&gt;
			[AvgSampleTreesOnPlot] [int] NOT NULL CONSTRAINT [DF_Stratification_AvgSampleTreesOnPlot]  DEFAULT ((2)),&lt;br /&gt;
			[StandardErrorPropertyName] [varchar](50) COLLATE Finnish_Swedish_CI_AS NOT NULL,&lt;br /&gt;
			[StandardErrorSpecies] [varchar](50) COLLATE Finnish_Swedish_CI_AS NOT NULL,&lt;br /&gt;
		 CONSTRAINT [PK_Stratification] PRIMARY KEY CLUSTERED &lt;br /&gt;
		(&lt;br /&gt;
			[StratificationGUID] ASC&lt;br /&gt;
		)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]&lt;br /&gt;
		) ON [PRIMARY];&lt;br /&gt;
		ALTER TABLE [dbo].[Stratification]  WITH CHECK ADD  CONSTRAINT [FK_Stratification_NoOfPlotsContingencyTable] FOREIGN KEY([NoOfPlotsTableGuid])&lt;br /&gt;
		REFERENCES [dbo].[ContingencyTable] ([TableGuid]);&lt;br /&gt;
		ALTER TABLE [dbo].[Stratification] CHECK CONSTRAINT [FK_Stratification_NoOfPlotsContingencyTable];&lt;br /&gt;
		ALTER TABLE [dbo].[Stratification]  WITH CHECK ADD  CONSTRAINT [FK_Stratification_PlotRadiusContingencyTable] FOREIGN KEY([PlotRadiusTableGuid])&lt;br /&gt;
		REFERENCES [dbo].[ContingencyTable] ([TableGuid]);&lt;br /&gt;
		ALTER TABLE [dbo].[Stratification] CHECK CONSTRAINT [FK_Stratification_PlotRadiusContingencyTable];&lt;br /&gt;
		ALTER TABLE [dbo].[Stratification]  WITH CHECK ADD  CONSTRAINT [FK_Stratification_StandRegister] FOREIGN KEY([StandRegisterId])&lt;br /&gt;
		REFERENCES [dbo].[StandRegister] ([StandRegisterId]);&lt;br /&gt;
		ALTER TABLE [dbo].[Stratification] CHECK CONSTRAINT [FK_Stratification_StandRegister];&lt;br /&gt;
	END&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
	-- 2.14. Create StratificationDomain&lt;br /&gt;
&lt;br /&gt;
	IF OBJECT_ID (&amp;#039;dbo.StratificationDomain&amp;#039;,&amp;#039;U&amp;#039;) IS NULL&lt;br /&gt;
	BEGIN&lt;br /&gt;
		CREATE TABLE [dbo].[StratificationDomain](&lt;br /&gt;
			[StratificationDomainGuid] [uniqueidentifier] NOT NULL,&lt;br /&gt;
			[StratificationGuid] [uniqueidentifier] NOT NULL,&lt;br /&gt;
			[DomainNo] [int] NOT NULL,&lt;br /&gt;
			[Name] [varchar](50) COLLATE Finnish_Swedish_CI_AS NOT NULL,&lt;br /&gt;
			[IsDefault] [bit] NOT NULL,&lt;br /&gt;
			[UserDefinedName] [bit] NOT NULL,&lt;br /&gt;
			[TableGuid] [uniqueidentifier] NOT NULL,&lt;br /&gt;
			[HasDefaultTable] [bit] NOT NULL,&lt;br /&gt;
		 CONSTRAINT [PK_StratificationDomain] PRIMARY KEY CLUSTERED &lt;br /&gt;
		(&lt;br /&gt;
			[StratificationDomainGuid] ASC&lt;br /&gt;
		)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]&lt;br /&gt;
		) ON [PRIMARY];&lt;br /&gt;
		ALTER TABLE [dbo].[StratificationDomain]  WITH CHECK ADD  CONSTRAINT [FK_StratificationDomain_ContingencyTable] FOREIGN KEY([TableGuid])&lt;br /&gt;
		REFERENCES [dbo].[ContingencyTable] ([TableGuid]);&lt;br /&gt;
		ALTER TABLE [dbo].[StratificationDomain] CHECK CONSTRAINT [FK_StratificationDomain_ContingencyTable];&lt;br /&gt;
		ALTER TABLE [dbo].[StratificationDomain]  WITH CHECK ADD  CONSTRAINT [FK_StratificationDomain_Stratification] FOREIGN KEY([StratificationGuid])&lt;br /&gt;
		REFERENCES [dbo].[Stratification] ([StratificationGUID])&lt;br /&gt;
		ON DELETE CASCADE;&lt;br /&gt;
		ALTER TABLE [dbo].[StratificationDomain] CHECK CONSTRAINT [FK_StratificationDomain_Stratification];&lt;br /&gt;
	END&lt;br /&gt;
&lt;br /&gt;
	-- 2.15. Create StratificationDomainCondition&lt;br /&gt;
&lt;br /&gt;
	IF OBJECT_ID (&amp;#039;dbo.StratificationDomainCondition&amp;#039;,&amp;#039;U&amp;#039;) IS NULL&lt;br /&gt;
	BEGIN&lt;br /&gt;
		CREATE TABLE [dbo].[StratificationDomainCondition](&lt;br /&gt;
			[StratificationDomainConditionGuid] [uniqueidentifier] NOT NULL,&lt;br /&gt;
			[StratificationDomainGuid] [uniqueidentifier] NOT NULL,&lt;br /&gt;
			[PropertyName] [varchar](50) COLLATE Finnish_Swedish_CI_AS NOT NULL,&lt;br /&gt;
			[Species] [varchar](50) COLLATE Finnish_Swedish_CI_AS NOT NULL,&lt;br /&gt;
			[OperatorType] [int] NOT NULL,&lt;br /&gt;
			[SimpleValue] [varchar](1024) COLLATE Finnish_Swedish_CI_AS NOT NULL,&lt;br /&gt;
			[ValueList] [varchar](1024) COLLATE Finnish_Swedish_CI_AS NOT NULL,&lt;br /&gt;
		 CONSTRAINT [PK_StratificationDomainCondition] PRIMARY KEY CLUSTERED &lt;br /&gt;
		(&lt;br /&gt;
			[StratificationDomainConditionGuid] ASC&lt;br /&gt;
		)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]&lt;br /&gt;
		) ON [PRIMARY];&lt;br /&gt;
		ALTER TABLE [dbo].[StratificationDomainCondition]  WITH CHECK ADD  CONSTRAINT [FK_StratificationDomainCondition_StratificationDomain] FOREIGN KEY([StratificationDomainGuid])&lt;br /&gt;
		REFERENCES [dbo].[StratificationDomain] ([StratificationDomainGuid])&lt;br /&gt;
		ON DELETE CASCADE;&lt;br /&gt;
		ALTER TABLE [dbo].[StratificationDomainCondition] CHECK CONSTRAINT [FK_StratificationDomainCondition_StratificationDomain];&lt;br /&gt;
		ALTER TABLE [dbo].[StratificationDomainCondition]  WITH CHECK ADD  CONSTRAINT [FK_StratificationDomainCondition_StratificationDomainCondition] FOREIGN KEY([StratificationDomainConditionGuid])&lt;br /&gt;
		REFERENCES [dbo].[StratificationDomainCondition] ([StratificationDomainConditionGuid]);&lt;br /&gt;
		ALTER TABLE [dbo].[StratificationDomainCondition] CHECK CONSTRAINT [FK_StratificationDomainCondition_StratificationDomainCondition];&lt;br /&gt;
	END&lt;br /&gt;
&lt;br /&gt;
	-- 2.16. Create Stratum&lt;br /&gt;
&lt;br /&gt;
	IF OBJECT_ID (&amp;#039;dbo.Stratum&amp;#039;,&amp;#039;U&amp;#039;) IS NULL&lt;br /&gt;
	BEGIN&lt;br /&gt;
		CREATE TABLE [dbo].[Stratum](&lt;br /&gt;
			[StratumGuid] [uniqueidentifier] NOT NULL,&lt;br /&gt;
			[StratumNo] [int] NOT NULL,&lt;br /&gt;
			[Color] [int] NOT NULL,&lt;br /&gt;
			[DesiredNoOfSamples] [int] NULL,&lt;br /&gt;
			[StratificationDomainGuid] [uniqueidentifier] NOT NULL,&lt;br /&gt;
			[AutoGenerated] [bit] NOT NULL CONSTRAINT [DF_Stratum_AutoGenerated]  DEFAULT ((0)),&lt;br /&gt;
		 CONSTRAINT [PK_Stratum] PRIMARY KEY CLUSTERED &lt;br /&gt;
		(&lt;br /&gt;
			[StratumGuid] ASC&lt;br /&gt;
		)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]&lt;br /&gt;
		) ON [PRIMARY];&lt;br /&gt;
		ALTER TABLE [dbo].[Stratum]  WITH CHECK ADD  CONSTRAINT [FK_Stratum_StratificationDomain] FOREIGN KEY([StratificationDomainGuid])&lt;br /&gt;
		REFERENCES [dbo].[StratificationDomain] ([StratificationDomainGuid])&lt;br /&gt;
		ON DELETE CASCADE;&lt;br /&gt;
		ALTER TABLE [dbo].[Stratum] CHECK CONSTRAINT [FK_Stratum_StratificationDomain];&lt;br /&gt;
	END&lt;br /&gt;
&lt;br /&gt;
	-- 2.17. Create StratumStandObject&lt;br /&gt;
&lt;br /&gt;
	IF OBJECT_ID (&amp;#039;dbo.StratumStandObject&amp;#039;,&amp;#039;U&amp;#039;) IS NULL&lt;br /&gt;
	BEGIN&lt;br /&gt;
		CREATE TABLE [dbo].[StratumStandObject](&lt;br /&gt;
			[StandObjectGuid] [uniqueidentifier] NOT NULL,&lt;br /&gt;
			[StratumGuid] [uniqueidentifier] NOT NULL,&lt;br /&gt;
			[RepresentativeArea] [float] NOT NULL,&lt;br /&gt;
			[PlotCount] [int] NOT NULL,&lt;br /&gt;
			[TreePlotRadius] [float] NOT NULL,&lt;br /&gt;
			[PlantPlotRadius] [float] NOT NULL,&lt;br /&gt;
			[P2] [float] NOT NULL,&lt;br /&gt;
		 CONSTRAINT [PK_StratumStandObject] PRIMARY KEY CLUSTERED &lt;br /&gt;
		(&lt;br /&gt;
			[StandObjectGuid] ASC,&lt;br /&gt;
			[StratumGuid] ASC&lt;br /&gt;
		)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]&lt;br /&gt;
		) ON [PRIMARY];&lt;br /&gt;
		ALTER TABLE [dbo].[StratumStandObject]  WITH CHECK ADD  CONSTRAINT [FK_StratumStandObject_StandObject] FOREIGN KEY([StandObjectGuid])&lt;br /&gt;
		REFERENCES [dbo].[StandObject] ([StandObjectGuid]);&lt;br /&gt;
		ALTER TABLE [dbo].[StratumStandObject] CHECK CONSTRAINT [FK_StratumStandObject_StandObject];&lt;br /&gt;
		ALTER TABLE [dbo].[StratumStandObject]  WITH CHECK ADD  CONSTRAINT [FK_StratumStandObject_Stratum] FOREIGN KEY([StratumGuid])&lt;br /&gt;
		REFERENCES [dbo].[Stratum] ([StratumGuid])&lt;br /&gt;
		ON DELETE CASCADE;&lt;br /&gt;
		ALTER TABLE [dbo].[StratumStandObject] CHECK CONSTRAINT [FK_StratumStandObject_Stratum];&lt;br /&gt;
	END&lt;br /&gt;
&lt;br /&gt;
	-- 2.18. Create ContingencyTableCell&lt;br /&gt;
&lt;br /&gt;
	IF OBJECT_ID (&amp;#039;dbo.ContingencyTableCell&amp;#039;,&amp;#039;U&amp;#039;) IS NULL&lt;br /&gt;
	BEGIN&lt;br /&gt;
		CREATE TABLE [dbo].[ContingencyTableCell](&lt;br /&gt;
			[CellGuid] [uniqueidentifier] NOT NULL,&lt;br /&gt;
			[TableGuid] [uniqueidentifier] NOT NULL,&lt;br /&gt;
			[RowNo] [int] NOT NULL,&lt;br /&gt;
			[ColumnNo] [int] NOT NULL,&lt;br /&gt;
			[StratumGuid] [uniqueidentifier] NULL,&lt;br /&gt;
			[Value] [float] NULL,&lt;br /&gt;
		 CONSTRAINT [PK_ContingencyTableCell] PRIMARY KEY CLUSTERED &lt;br /&gt;
		(&lt;br /&gt;
			[CellGuid] ASC&lt;br /&gt;
		)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]&lt;br /&gt;
		) ON [PRIMARY];&lt;br /&gt;
		ALTER TABLE [dbo].[ContingencyTableCell]  WITH CHECK ADD  CONSTRAINT [FK_ContingencyTableCell_ContingencyTable] FOREIGN KEY([TableGuid])&lt;br /&gt;
		REFERENCES [dbo].[ContingencyTable] ([TableGuid])&lt;br /&gt;
		ON DELETE CASCADE;&lt;br /&gt;
		ALTER TABLE [dbo].[ContingencyTableCell] CHECK CONSTRAINT [FK_ContingencyTableCell_ContingencyTable];&lt;br /&gt;
	END&lt;br /&gt;
&lt;br /&gt;
	-- 3. Add table TreatmentUnitNeighbour&lt;br /&gt;
	IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = &amp;#039;TreatmentUnitNeighbour&amp;#039;)&lt;br /&gt;
	BEGIN&lt;br /&gt;
		CREATE TABLE [dbo].[TreatmentUnitNeighbour](&lt;br /&gt;
			[TreatmentUnitGUID] [uniqueidentifier] NOT NULL,&lt;br /&gt;
			[TreatmentUnitNeighbourGUID] [uniqueidentifier] NOT NULL,&lt;br /&gt;
			[CommonBorderLength] [int] NOT NULL,&lt;br /&gt;
		 CONSTRAINT [PK_TreatmentUnitNeighbour] PRIMARY KEY CLUSTERED &lt;br /&gt;
		(&lt;br /&gt;
			[TreatmentUnitGUID] ASC,&lt;br /&gt;
			[TreatmentUnitNeighbourGUID] ASC&lt;br /&gt;
		)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]&lt;br /&gt;
		) ON [PRIMARY]&lt;br /&gt;
		ALTER TABLE [dbo].[TreatmentUnitNeighbour]  WITH CHECK ADD  CONSTRAINT [FK_TreatmentUnitNeighbour_TreatmentUnit] FOREIGN KEY([TreatmentUnitGUID])&lt;br /&gt;
		REFERENCES [dbo].[TreatmentUnit] ([TreatmentUnitGUID]) ON DELETE CASCADE&lt;br /&gt;
		ALTER TABLE [dbo].[TreatmentUnitNeighbour] CHECK CONSTRAINT [FK_TreatmentUnitNeighbour_TreatmentUnit]&lt;br /&gt;
	END&lt;br /&gt;
&lt;br /&gt;
	-- 4. Add columns for arithmetic mean height to table InitialState_SpeciesData&lt;br /&gt;
&lt;br /&gt;
	TRUNCATE TABLE STANDOBJECTPLOT&lt;br /&gt;
	IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = &amp;#039;StandobjectPlot&amp;#039; AND COLUMN_NAME = &amp;#039;StratificationGUID&amp;#039;)&lt;br /&gt;
	BEGIN&lt;br /&gt;
		ALTER TABLE [StandobjectPlot] ADD [StratificationGUID] [uniqueidentifier] NOT NULL&lt;br /&gt;
&lt;br /&gt;
	END&lt;br /&gt;
&lt;br /&gt;
	-- 5. Add new column for ObjectID to InitialState_TreatmentUnit &lt;br /&gt;
&lt;br /&gt;
	IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = &amp;#039;InitialState_TreatmentUnit&amp;#039; AND COLUMN_NAME = &amp;#039;ObjectId&amp;#039;)&lt;br /&gt;
	BEGIN&lt;br /&gt;
		ALTER TABLE [dbo].[InitialState_TreatmentUnit] ADD&lt;br /&gt;
			[ObjectId] [int] NULL&lt;br /&gt;
	END&lt;br /&gt;
&lt;br /&gt;
	-- 6. Add columns for arithmetic mean height to table InitialState_SpeciesData&lt;br /&gt;
&lt;br /&gt;
	TRUNCATE TABLE Standinventory&lt;br /&gt;
	IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = &amp;#039;Standinventory&amp;#039; AND COLUMN_NAME = &amp;#039;StratificationGUID&amp;#039;)&lt;br /&gt;
	BEGIN&lt;br /&gt;
		ALTER TABLE [Standinventory] ADD [StratificationGUID] [uniqueidentifier] NOT NULL;&lt;br /&gt;
&lt;br /&gt;
	END&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
	-- Update version&lt;br /&gt;
&lt;br /&gt;
	UPDATE Version SET ApplicationVersion = &amp;#039;0.5.4.0&amp;#039;;&lt;br /&gt;
	PRINT &amp;#039;Success! Database upgrade to version 0.5.4.0&amp;#039;;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
END&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;/div&gt;</summary>
		<author><name>Fkl</name></author>
	</entry>
</feed>