Home : Database Upgrade 7.8.0
Q14556 - INFO: Database Upgrade 7.8.0
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

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 10/23/2019 1:00 PM.
Last Modified on 10/31/2019 9:13 AM.
Last Modified by Scott Dorner.
Article has been viewed 443 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article