Peder at 13:45, 14 July 2009

2009-07-14T13:45:30Z

← Older revision		Revision as of 14:45, 14 July 2009
Line 1:		Line 1:
	[[~~Heureka database upgrade~~ scripts \| Back to scripts]]		[[:Category:Database scripts \| Back to scripts]]
	<pre>		<pre>

Line 38:		Line 38:

	</pre>		</pre>
	[[Category:Database]]		[[Category:Database scripts]]

Cawa2: New page: Back to scripts

  IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = '0.5.4.0' OR ApplicationVersion = '0.5.4.1') = 0 BEGIN 		PRINT 'Wr...

2009-06-02T12:07:01Z

New page: Back to scripts <pre> IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = '0.5.4.0' OR ApplicationVersion = '0.5.4.1') = 0 BEGIN PRINT 'Wr...

New page

[[Heureka database upgrade scripts | Back to scripts]]
<pre>

IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = '0.5.4.0' OR ApplicationVersion = '0.5.4.1') = 0
BEGIN
PRINT 'Wrong Version of database. You must upgrade to version 0.5.4.0 before running this script.';
SELECT ApplicationVersion FROM VERSION;
END
ELSE
BEGIN

-- 1. Add new columns to StandObject

IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'StandObject' AND COLUMN_NAME = 'AreaLevel2')
BEGIN
ALTER TABLE [dbo].[StandObject] ADD
[AreaLevel2] [nvarchar](50) NULL,
[AreaLevel3] [nvarchar](50) NULL,
[Register] [int] NULL
END

-- 2. Add new column to StratificationDomain

IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'StratificationDomain' AND COLUMN_NAME = 'PriorityNo')
BEGIN
ALTER TABLE [dbo].[StratificationDomain] ADD
[PriorityNo] [int] NULL
END

-- Update version

UPDATE Version SET ApplicationVersion = '0.5.4.1';
PRINT 'Success! Database upgrade to version 0.5.4.1';

END

</pre>
[[Category:Database]]

Heureka database upgrade script 0.5.4.1 - Revision history

Peder at 13:45, 14 July 2009

Cawa2: New page: Back to scripts
IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = '0.5.4.0' OR ApplicationVersion = '0.5.4.1') = 0 BEGIN PRINT 'Wr...