Difference between revisions of "Heureka database upgrade script 0.5.4.3"
Jump to navigation
Jump to search
(New page: Back to scripts <pre> IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = '0.5.4.2') = 0 BEGIN PRINT 'Wrong Version of database. You must ...) |
|||
(5 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
− | [[ | + | [[:Category:Database scripts | Back to scripts]] |
<pre> | <pre> | ||
− | |||
IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = '0.5.4.2') = 0 | IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = '0.5.4.2') = 0 | ||
BEGIN | BEGIN | ||
Line 10: | Line 9: | ||
BEGIN | BEGIN | ||
+ | --1. Add Constraints to StandInventory | ||
+ | |||
+ | IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'StandInventory' AND COLUMN_NAME = 'StandObjectGUID' AND COLUMN_NAME = 'StratificationGUID') | ||
+ | BEGIN | ||
+ | ALTER TABLE [STANDINVENTORY] DROP CONSTRAINT PK_StandInventory | ||
+ | |||
+ | ALTER TABLE [STANDINVENTORY] | ||
+ | ADD CONSTRAINT PK_StandInventory PRIMARY KEY (StandObjectGUID, StratificationGUID) | ||
+ | |||
+ | END | ||
+ | |||
+ | -- 2. Add columns to Stratification | ||
-- STATEMENTS NOT WORKING COMBINED WITHIN THE SAME BEGIN - END, THEREFORE ENTERED SEPARATELY | -- STATEMENTS NOT WORKING COMBINED WITHIN THE SAME BEGIN - END, THEREFORE ENTERED SEPARATELY | ||
Line 18: | Line 29: | ||
[ModifiedBy] [varchar](50) NULL | [ModifiedBy] [varchar](50) NULL | ||
END | END | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
-- Update version | -- Update version | ||
Line 38: | Line 36: | ||
END | END | ||
− | |||
</pre> | </pre> | ||
− | [[Category:Database]] | + | [[Category:Database scripts]] |
Latest revision as of 15:42, 14 July 2009
IF (SELECT COUNT(*) FROM VERSION WHERE ApplicationVersion = '0.5.4.2') = 0 BEGIN PRINT 'Wrong Version of database. You must upgrade to version 0.5.4.2 before running this script.'; SELECT ApplicationVersion FROM VERSION; END ELSE BEGIN --1. Add Constraints to StandInventory IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'StandInventory' AND COLUMN_NAME = 'StandObjectGUID' AND COLUMN_NAME = 'StratificationGUID') BEGIN ALTER TABLE [STANDINVENTORY] DROP CONSTRAINT PK_StandInventory ALTER TABLE [STANDINVENTORY] ADD CONSTRAINT PK_StandInventory PRIMARY KEY (StandObjectGUID, StratificationGUID) END -- 2. Add columns to Stratification -- STATEMENTS NOT WORKING COMBINED WITHIN THE SAME BEGIN - END, THEREFORE ENTERED SEPARATELY IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Stratification' AND COLUMN_NAME = 'ModifiedDate') BEGIN ALTER TABLE [dbo].[Stratification] ADD [ModifiedDate] [datetime] NULL, [ModifiedBy] [varchar](50) NULL END -- Update version UPDATE Version SET ApplicationVersion = '0.5.4.3'; PRINT 'Success! Database upgrade to version 0.5.4.3'; END