With the release of WIMS Client 8.5.4 a database upgrade is required. The upgrade is automatically applied when logging into a Facility Database for the first time with the WIMS 8.5.4 client.
Tech Notes:
SQL SERVER
OPSROOT
ALTER TABLE OPSTIMEZONE ADD DISPLAY NUMERIC NULL DEFAULT (NULL)
INSERT INTO OPSTIMEZONE VALUES ('UP854',GETDATE(),91,'Pacific Time (Canada)','(UTC-07:00) Pacific Time (Canada, No DST)','Mountain Standard Time','Mountain Standard Time',-1)
For years 1966 - 2066:
INSERT INTO OPSTIMEZONE_BIAS VALUES ('UP854',GETDATE(),91,1966,420,360,'1966-01-01',NULL)
INSERT INTO OPSTIMEZONE VALUES ('UP854',GETDATE(),92,'Mountain Time (Edmonton)','(UTC-06:00) (Mountain Time (Edmonton, No DST)','Central Standard Time','Central Standard Time',-1)
For years 1966 - 2066:
INSERT INTO OPSTIMEZONE_BIAS VALUES ('UP854',GETDATE(),92,1966,360,300,'1966-01-01',NULL)
INSERT INTO OPSTIMEZONE VALUES ('UP854',GETDATE(),93,'Central Time (Regina)','(UTC-06:00) Central Time (Regina, No DST)','Central Standard Time','Central Standard Time',-1)
For years 1966 - 2066:
INSERT INTO OPSTIMEZONE_BIAS VALUES ('UP854',GETDATE(),93,1966,360,300,'1966-01-01',NULL)
INSERT INTO OPSTIMEZONE VALUES ('UP854',GETDATE(),94,'Central Time (Winnipeg)','(UTC-05:00) Central Time (Winnipeg, No DST)','Manitoba Standard Time','Manitoba Standard Time',-1)
For years 1966 - 2066:
INSERT INTO OPSTIMEZONE_BIAS VALUES ('UP854',GETDATE(),94,1966,300,240,'1966-01-01',NULL)
INSERT INTO OPSTIMEZONE VALUES ('UP854',GETDATE(),95,'Atlantic Time (Puerto Rico, No DST)','(UTC-04:00) Atlantic Time (Puerto Rico, No DST)','Atlantic Standard Time','Atlantic Standard Time',-1)
For years 1966 - 2066:
INSERT INTO OPSTIMEZONE_BIAS VALUES ('UP854',GETDATE(),95,1966,240,180,'1966-01-01',NULL)
UPDATE OPSTIMEZONE SET DISPLAY=-1 WHERE OPSTIMEZONEID IN (2,8,9,10,13,16,20,21,23,28,29,31,37,41,49,53,59,60,64,74,78,82,85,91)
Facility Databases
ALTER TABLE LC_SAMPLEDEF ADD DATASTOREOFFSET [Numeric](18, 0) NULL DEFAULT (NULL)
ALTER TABLE LC_SAMPLE ADD DATASTOREDATETIME [DateTime] NULL DEFAULT (NULL)
ALTER TABLE LC_SAMPLE ADD DATASTOREOFFSET [Numeric](18, 0) NULL DEFAULT (NULL)
UPDATE LC_SAMPLE SET DATASTOREDATETIME=SAMPLEDTTIME
Oracle
OPSROOT
ALTER TABLE OPSTIMEZONE ADD DISPLAY NUMBER DEFAULT NULL
Use same insert statements as shown in SQL scripts
Facility Databases
ALTER TABLE LC_SAMPLEDEF ADD DATASTOREOFFSET NUMBER DEFAULT NULL
ALTER TABLE LC_SAMPLE ADD DATASTOREDATETIME DATE DEFAULT NULL
ALTER TABLE LC_SAMPLE ADD DATASTOREOFFSET NUMBER DEFAULT NULL
UPDATE LC_SAMPLE SET DATASTOREDATETIME=SAMPLEDTTIME