Peder at 13:45, 14 July 2009

2009-07-14T13:45:30Z

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]]

@@ Line 1: / Line 1: @@
-[[Heureka database upgrade scripts | Back to scripts]]
+[[:Category:Database scripts | Back to scripts]]
 <pre>
@@ Line 38: / Line 38: @@
 </pre>
-[[Category:Database]]
+[[Category:Database scripts]]

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...