With the release of WIMS Client 7.8.0 a database upgrade is required. The upgrade is automatically applied when logging into a Facility Database for the first time with the WIMS 7.8.0 client.
Tech Notes:
SQL Server Scripts:
OPSROOT
No updates
FACILITY DATABASES
ALTER TABLE LC_SAMPLEDEF ADD PICKUPCOST [FLOAT] NOT NULL DEFAULT (0)
ALTER TABLE LC_SAMPLEDEF ADD SAMPLECOST [FLOAT] NOT NULL DEFAULT (0)
ALTER TABLE LC_SAMPLEDEF ADD PREPCOST [FLOAT] NOT NULL DEFAULT (0)
ALTER TABLE LC_SAMPLEDEF ADD MISCCOST [FLOAT] NOT NULL DEFAULT (0)
ALTER TABLE LC_TEST DROP CONSTRAINT ?????????
SP_RENAME 'LC_TEST.COST','COSTBAD','COLUMN'
ALTER TABLE LC_TEST ADD COST FLOAT NULL DEFAULT (NULL)
UPDATE LC_TEST SET COST=COSTBAD
ALTER TABLE LC_TEST DROP COLUMN COSTBAD
ALTER TABLE LC_SAMPLE ADD PICKUPCOST [FLOAT] NOT NULL DEFAULT (0)
ALTER TABLE LC_SAMPLE ADD SAMPLECOST [FLOAT] NOT NULL DEFAULT (0)
ALTER TABLE LC_SAMPLE ADD PREPCOST [FLOAT] NOT NULL DEFAULT (0)
ALTER TABLE LC_SAMPLE ADD MISCCOST [FLOAT] NOT NULL DEFAULT (0)
ALTER TABLE LC_SAMPLE ADD TOTALTESTCOST [FLOAT] NOT NULL DEFAULT (0)
ALTER TABLE LC_SAMPLE ADD DISCOUNT [FLOAT] NOT NULL DEFAULT (0)
ALTER TABLE LC_SAMPLE ADD TAXRATE [FLOAT] NOT NULL DEFAULT (0)
ALTER TABLE LC_SAMPLE ADD TOTALCOST [FLOAT] NOT NULL DEFAULT (0)
ALTER TABLE LC_SAMPLE ADD SAMPLEUD6 NVARCHAR(255) NULL DEFAULT (NULL)
ALTER TABLE LC_SAMPLE ADD SAMPLEUD7 NVARCHAR(255) NULL DEFAULT (NULL)
ALTER TABLE LC_SAMPLE ADD SAMPLEUD8 NVARCHAR(255) NULL DEFAULT (NULL)
ALTER TABLE LC_SAMPLE ADD SAMPLEUD9 NVARCHAR(255) NULL DEFAULT (NULL)
ALTER TABLE LC_SAMPLEDEF ADD TASKUD6 NVARCHAR(255) NULL DEFAULT (NULL)
ALTER TABLE LC_SAMPLEDEF ADD TASKUD7 NVARCHAR(255) NULL DEFAULT (NULL)
ALTER TABLE LC_SAMPLEDEF ADD TASKUD8 NVARCHAR(255) NULL DEFAULT (NULL)
ALTER TABLE LC_SAMPLEDEF ADD TASKUD9 NVARCHAR(255) NULL DEFAULT (NULL)
ALTER TABLE LC_PEOPLE ADD DISCOUNT [FLOAT] NOT NULL DEFAULT (0)
ORACLE:
OPSROOT
No updates
FACILITY DATABASES
SELECT COUNT(*) FROM USER_SEQUENCES WHERE SEQUENCE_NAME = 'A_FORMSET'
IF COUNT=0 THEN
CREATE SEQUENCE "A_FORMSET" INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER
CREATE TRIGGER "T_FORMSET" BEFORE INSERT ON "FORMSET" FOR EACH ROW BEGIN SELECT "A_FORMSET".NEXTVAL INTO :NEW."ID" FROM DUAL; END T_FORMSET;
ALTER TABLE LC_SAMPLEDEF ADD PICKUPCOST NUMBER DEFAULT 0 NOT NULL
ALTER TABLE LC_SAMPLEDEF ADD SAMPLECOST NUMBER DEFAULT 0 NOT NULL
ALTER TABLE LC_SAMPLEDEF ADD PREPCOST NUMBER DEFAULT 0 NOT NULL
ALTER TABLE LC_SAMPLEDEF ADD MISCCOST NUMBER DEFAULT 0 NOT NULL
ALTER TABLE LC_SAMPLE ADD PICKUPCOST NUMBER DEFAULT 0 NOT NULL
ALTER TABLE LC_SAMPLE ADD SAMPLECOST NUMBER DEFAULT 0 NOT NULL
ALTER TABLE LC_SAMPLE ADD PREPCOST NUMBER DEFAULT 0 NOT NULL
ALTER TABLE LC_SAMPLE ADD MISCCOST NUMBER DEFAULT 0 NOT NULL
ALTER TABLE LC_SAMPLE ADD TOTALTESTCOST NUMBER DEFAULT 0 NOT NULL
ALTER TABLE LC_SAMPLE ADD DISCOUNT NUMBER DEFAULT 0 NOT NULL
ALTER TABLE LC_SAMPLE ADD TAXRATE NUMBER DEFAULT 0 NOT NULL
ALTER TABLE LC_SAMPLE ADD TOTALCOST NUMBER DEFAULT 0 NOT NULL
ALTER TABLE LC_SAMPLE ADD SAMPLEUD6 NVARCHAR2(255) DEFAULT NULL
ALTER TABLE LC_SAMPLE ADD SAMPLEUD7 NVARCHAR2(255) DEFAULT NULL
ALTER TABLE LC_SAMPLE ADD SAMPLEUD8 NVARCHAR2(255) DEFAULT NULL
ALTER TABLE LC_SAMPLE ADD SAMPLEUD9 NVARCHAR2(255) DEFAULT NULL
ALTER TABLE LC_SAMPLEDEF ADD TASKUD6 NVARCHAR2(255) DEFAULT NULL
ALTER TABLE LC_SAMPLEDEF ADD TASKUD7 NVARCHAR2(255) DEFAULT NULL
ALTER TABLE LC_SAMPLEDEF ADD TASKUD8 NVARCHAR2(255) DEFAULT NULL
ALTER TABLE LC_SAMPLEDEF ADD TASKUD9 NVARCHAR2(255) DEFAULT NULL
ALTER TABLE LC_PEOPLE ADD DISCOUNT NUMBER DEFAULT 0 NOT NULL