With the release of WIMS Client 8.2.0 a database upgrade is required. The upgrade is automatically applied when logging into a Facility Database for the first time with the WIMS 8.1.8.
Tech Notes:
SQL Server Scripts:
CREATE TABLE [dbo].[VARSLOTREQ]([VARID] [numeric](18, 0) NULL DEFAULT (NULL),[SLOT] [numeric](18, 0) NULL DEFAULT (NULL),[AUDITUSER] [varchar](50) NULL,[AUDITTIMESTAMP] [datetime] NULL DEFAULT (getdate())) ON [PRIMARY]
ALTER TABLE MDEVARS ADD FACILITYFILENAME [nvarchar](60) NULL DEFAULT (NULL)
ALTER TABLE MDE ADD SHOWFACIL [Numeric](18, 0) NOT NULL DEFAULT (0)
ALTER TABLE MDE ADD AUTOADVANCE [Numeric](18, 0) NOT NULL DEFAULT (0)
ALTER TABLE HDE ADD AUTOADVANCE [Numeric](18, 0) NOT NULL DEFAULT (0)
ALTER TABLE VARDESC ADD ISCOMPLIANCE [Numeric](18, 0) NOT NULL DEFAULT (0)
ALTER TABLE LC_SAMPLEDEF ADD ISCOMPLIANCE [Numeric](18, 0) NOT NULL DEFAULT (0)
ALTER TABLE LC_SAMPLE ADD ISCOMPLIANCE [Numeric](18, 0) NOT NULL DEFAULT (0)
Oracle Scripts:
CREATE TABLE "VARSLOTREQ" ("VARID" NUMBER NOT NULL,
"AUDITUSER" VARCHAR2(50) NULL,
"AUDITTIMESTAMP" DATE DEFAULT NULL,
"SLOT" NUMBER NOT NULL)
ALTER TABLE MDEVARS ADD FACILITYFILENAME NVARCHAR2(60) DEFAULT NULL
ALTER TABLE MDE ADD SHOWFACIL NUMBER DEFAULT 0
ALTER TABLE MDE ADD AUTOADVANCE NUMBER DEFAULT 0
ALTER TABLE HDE ADD AUTOADVANCE NUMBER DEFAULT 0
ALTER TABLE VARDESC ADD ISCOMPLIANCE NUMBER DEFAULT 0
ALTER TABLE LC_SAMPLEDEF ADD ISCOMPLIANCE NUMBER DEFAULT 0
ALTER TABLE LC_SAMPLE ADD ISCOMPLIANCE NUMBER DEFAULT 0