Home : Database Upgrade 8.1.4
Q14716 - INFO: Database Upgrade 8.1.4
With the release of WIMS Client 8.1.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.1.4. 

Tech Notes:

SQL Server Scripts:

CREATE TABLE [dbo].[IMPORTPASTESETTINGS](
                [ID] [int] IDENTITY(1,1) NOT NULL,
                [AUDITUSER] [varchar](50) NULL,
                [AUDITTIMESTAMP] [datetime] NULL DEFAULT (getdate()),
                [NAME] [nvarchar](255) NULL,
                [OPTION] [numeric](18, 0) NULL,
                [VARLIST] [nvarchar](4000) NULL,
                ) ON [PRIMARY]

ALTER TABLE MDE ADD DATAJUSTIFY NUMERIC NULL DEFAULT (NULL)
UPDATE MDE SET DATAJUSTIFY=1

ALTER TABLE SPRPTS ALTER COLUMN REPORTDESC NVARCHAR(2000)

ALTER TABLE HDEVARS ADD COLWIDTHTIME [float] NULL DEFAULT (NULL)
ALTER TABLE HDEVARS ADD COLWIDTHVALUE [float] NULL DEFAULT (NULL)

ALTER TABLE LIMITS ADD LIMIT_VALUE_DISPLAY [nvarchar](255) NULL DEFAULT (NULL)
UPDATE LIMITS SET LIMIT_VALUE_DISPLAY = LIMIT_VALUE

ALTER TABLE LC_TESTQC ADD INPUTVARID  [numeric](18, 0) NULL

ALTER TABLE LC_BATCHTEMPLATEQC ADD INPUTVARID  [numeric](18, 0) NULL
SP_RENAME 'LC_BATCHTEMPLATEQC.VARID','QCCALCVARID','COLUMN'

ALTER TABLE LC_SAMPLETEST ADD BATCHQCVARID  [numeric](18, 0) NULL
ALTER TABLE LC_SAMPLETEST ADD BATCHQCTEXTRESULT [nvarchar](255) NULL DEFAULT (NULL)

ALTER TABLE LC_BATCH ADD TEMPLATEID [Numeric](18, 0)  NULL DEFAULT (NULL)

INSERT INTO LC_REJECTIONCODES (AuditUser,AuditTimeStamp,Code,Description,Recorder) VALUES ('UP814',GETDATE(),'ND','No Discharge',17)

Oracle Scripts:

CREATE TABLE "IMPORTPASTESETTINGS"
                ID"  NUMBER NOT NULL, 
                "AUDITUSER" VARCHAR2(50) NULL,                 
                "AUDITTIMESTAMP"  DATE DEFAULT NULL, 
                "NAME" NVARCHAR2 (100) NULL, 
                "OPTION" NUMBER DEFAULT 0 NULL,
                "VARLIST" NVARCHAR2(2000) DEFAULT NULL)

CREATE SEQUENCE  "A_IMPORTPASTESETTINGS"  INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER

CREATE TRIGGER  "T_IMPORTPASTESETTINGS"  BEFORE INSERT ON "IMPORTPASTESETTINGS"  FOR EACH ROW BEGIN SELECT "A_IMPORTPASTESETTINGS" .NEXTVAL INTO :NEW."ID" FROM DUAL; END T_IMPORTPASTESETTINGS;

ALTER TABLE MDE ADD DATAJUSTIFY NUMBER DEFAULT NULL
UPDATE MDE SET DATAJUSTIFY=1

ALTER TABLE SPRPTS MODIFY(REPORTDESC NVARCHAR2(1000))

ALTER TABLE HDEVARS ADD COLWIDTHTIME NUMBER NULL
ALTER TABLE HDEVARS ADD COLWIDTHVALUE NUMBER NULL

ALTER TABLE LIMITS ADD LIMIT_VALUE_DISPLAY NVARCHAR2(255) NULL

UPDATE LIMITS SET LIMIT_VALUE_DISPLAY = LIMIT_VALUE

ALTER TABLE LC_TESTQC ADD INPUTVARID NUMBER NULL

ALTER TABLE LC_BATCHTEMPLATEQC ADD INPUTVARID NUMBER NULL

ALTER TABLE VARDESC RENAME COLUMN VARID to QCCALCVARID

ALTER TABLE LC_SAMPLETEST ADD BATCHQCVARID NUMBER NULL

ALTER TABLE LC_SAMPLETEST ADD BATCHQCTEXTRESULT NVARCHAR2(255) NULL

INSERT INTO LC_REJECTIONCODES (AuditUser,AuditTimeStamp,Code,Description,Recorder) VALUES ('UP814',SYSDATE,'ND','No Discharge',17)

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 7/28/2022 10:40 AM.
Last Modified on 10/14/2022 4:38 PM.
Last Modified by Scott Dorner.
Article has been viewed 800 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article