Home : Database Upgrade 7.8.4
Q14575 - INFO: Database Upgrade 7.8.4
With the release of WIMS Client 7.8.4 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.4 client. 

Tech Notes:

SQL Server Scripts:

OPSROOT

ALTER TABLE PORTALMAIL ALTER COLUMN MSG_TO NVARCHAR(1000)

FACILITY DATABASES

LabCal Days (columns) to display on calendar and Days (columns) to display before the current day added to facility settings (set in Facility Setup) that can be used to decrease load time of the Lab Cal calendar.

  • DisplayMaxCol OPSROOT.GENERALSETTING moved to Facility.SETTINGS LABCAL-DISPLAYMAXCOL (default 366)
  • Facility.SETTINGS LABCAL-BACKDAYS set to 60 by default. 

ALTER TABLE DRILLDOWN ADD SHOWREPORTSUMMARYROW numeric (18, 0) NULL     'Note may not be required

ALTER TABLE MDE ADD ROUNDTYPE [numeric](18, 0) NOT NULL DEFAULT (0)

ALTER TABLE SPFORMS ADD ROUNDTYPE [numeric](18, 0) NOT NULL DEFAULT (0)

ALTER TABLE VARDESC ADD SIGFIGS [numeric](18, 0) NOT NULL DEFAULT (-1)

CREATE TABLE [dbo].[LC_LOGINBATCH](
                [ID] [int] IDENTITY(1,1) NOT NULL,
                [AUDITUSER] [varchar](50) NULL,
                [AUDITTIMESTAMP] [datetime] NULL DEFAULT (getdate()),
                [NAME] [nvarchar](100) NULL,
                [DESCRIPTION] [nvarchar](500) NULL,
                [UD1] [nvarchar](100) NULL,
                [UD2] [nvarchar](100) NULL,
                [UD3] [nvarchar](100) NULL,
                [UD4] [nvarchar](100) NULL,
                [UD5] [nvarchar](100) NULL,
                [UD6] [nvarchar](100) NULL,
                [UD7] [nvarchar](100) NULL,
                [UD8] [nvarchar](100) NULL,
                [UD9] [nvarchar](100) NULL
            ) ON [PRIMARY]

CREATE TABLE [dbo].[LC_REJECTIONCODES](
                [ID] [int] IDENTITY(1,1) NOT NULL,
                [AUDITUSER] [varchar](50) NULL,
                [AUDITTIMESTAMP] [datetime] NULL DEFAULT (getdate()),
                [CODE] [nvarchar](10) NULL,
                [DESCRIPTION] [nvarchar](500) NULL,
                [RECORDER] NUMERIC NULL DEFAULT (NULL),
                [UD1] [nvarchar](100) NULL,
                [UD2] [nvarchar](100) NULL,
                [UD3] [nvarchar](100) NULL,
                [UD4] [nvarchar](100) NULL,
                [UD5] [nvarchar](100) NULL,
                [UD6] [nvarchar](100) NULL,
                [UD7] [nvarchar](100) NULL,
                [UD8] [nvarchar](100) NULL,
                [UD9] [nvarchar](100) NULL
            ) ON [PRIMARY]

Default Rejection codes added.

ALTER TABLE LC_SAMPLETYPE ADD UD1 NVARCHAR(100) NULL DEFAULT (NULL)
ALTER TABLE LC_SAMPLETYPE ADD UD2 NVARCHAR(100) NULL DEFAULT (NULL)
ALTER TABLE LC_SAMPLETYPE ADD UD3 NVARCHAR(100) NULL DEFAULT (NULL)
ALTER TABLE LC_SAMPLETYPE ADD UD4 NVARCHAR(100) NULL DEFAULT (NULL)
ALTER TABLE LC_SAMPLETYPE ADD UD5 NVARCHAR(100) NULL DEFAULT (NULL)
ALTER TABLE LC_SAMPLETYPE ADD UD6 NVARCHAR(100) NULL DEFAULT (NULL)
ALTER TABLE LC_SAMPLETYPE ADD UD7 NVARCHAR(100) NULL DEFAULT (NULL)
ALTER TABLE LC_SAMPLETYPE ADD UD8 NVARCHAR(100) NULL DEFAULT (NULL)
ALTER TABLE LC_SAMPLETYPE ADD UD9 NVARCHAR(100) NULL DEFAULT (NULL)

ALTER TABLE GRAPHLIST ADD HEADERTEXT NVARCHAR(500) NULL DEFAULT (NULL)
ALTER TABLE GRAPHLIST ADD HEADERFONTNAME NVARCHAR(100) NOT NULL DEFAULT ('Arial')
ALTER TABLE GRAPHLIST ADD HEADERFONTSIZE NVARCHAR(10) NOT NULL DEFAULT ('10')
ALTER TABLE GRAPHLIST ADD HEADERFONTBOLD NVARCHAR(10) NOT NULL DEFAULT ('ON')
ALTER TABLE GRAPHLIST ADD HEADERFONTITALIC NVARCHAR(10) NOT NULL DEFAULT ('OFF')
ALTER TABLE GRAPHLIST ADD HEADERGRAPHICJUST NVARCHAR(10) NOT NULL DEFAULT ('OFF')

ALTER TABLE LC_SAMPLE ADD PAYMENT [FLOAT] NOT NULL DEFAULT (0)
ALTER TABLE LC_SAMPLE ADD PAYMENTTYPE NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE LC_SAMPLE ADD PAYMENTNOTES NVARCHAR(4000) NULL DEFAULT (NULL)
ALTER TABLE LC_SAMPLE ADD REJECTIONCODE NVARCHAR(10) NULL DEFAULT (NULL)

ORACLE:

OPSROOT

ALTER TABLE PORTALMAIL MODIFY(MSG_TO NVARCHAR2(1000))

FACILITY DATABASES

LabCal Days (columns) to display on calendar and Days (columns) to display before the current day added to facility settings (set in Facility Setup) that can be used to decrease load time of the Lab Cal calendar.

  • DisplayMaxCol OPSROOT.GENERALSETTING moved to Facility.SETTINGS LABCAL-DISPLAYMAXCOL (default 366)
  • Facility.SETTINGS LABCAL-BACKDAYS set to 60 by default. 

ALTER TABLE LC_RESULTS_SET RENAME COLUMN DATESETTING to DATESETTINGS

ALTER TABLE GRAPHLIST RENAME COLUMN HEADERFONT TO HEADERFONTNAME

ALTER TABLE DRILLDOWN ADD SHOWREPORTSUMMARYROW NUMBER NULL   'Note may not be required

ALTER TABLE MDE ADD ROUNDTYPE NUMBER DEFAULT 0 NOT NULL

ALTER TABLE SPFORMS ADD ROUNDTYPE NUMBER DEFAULT 0 NOT NULL

ALTER TABLE VARDESC ADD SIGFIGS NUMBER DEFAULT -1 NOT NULL

CREATE TABLE "LC_LOGINBATCH"("ID" NUMBER NOT NULL, "AUDITUSER" VARCHAR2(50) NULL, "AUDITTIMESTAMP" DATE DEFAULT NULL, "NAME" nvarchar2 (100) NULL,"DESCRIPTION" nvarchar2 (500) NULL,"UD1" nvarchar2 (100) NULL,"UD2" nvarchar2 (100) NULL,"UD3" nvarchar2 (100) NULL,"UD4" nvarchar2 (100) NULL,"UD5" nvarchar2 (100) NULL,"UD6" nvarchar2 (100) NULL,"UD7" nvarchar2 (100) NULL,"UD8" nvarchar2 (100) NULL,"UD9" nvarchar2 (100) NULL)

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

CREATE TRIGGER "T_LC_LOGINBATCH" BEFORE INSERT ON "LC_LOGINBATCH" FOR EACH ROW BEGIN SELECT "A_LC_LOGINBATCH".NEXTVAL INTO :NEW."ID" FROM DUAL; END T_LC_LOGINBATCH;

CREATE TABLE "LC_REJECTIONCODES"("ID" NUMBER NOT NULL, "AUDITUSER" VARCHAR2(50) NULL, "AUDITTIMESTAMP" DATE DEFAULT NULL, "CODE" nvarchar2 (10) NULL,"DESCRIPTION" nvarchar2 (500) NULL,"RECORDER" NUMBER DEFAULT NULL,"UD1" nvarchar2 (100) NULL,"UD2" nvarchar2 (100) NULL,"UD3" nvarchar2 (100) NULL,"UD4" nvarchar2 (100) NULL,"UD5" nvarchar2 (100) NULL,"UD6" nvarchar2 (100) NULL,"UD7" nvarchar2 (100) NULL,"UD8" nvarchar2 (100) NULL,"UD9" nvarchar2 (100) NULL)

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

CREATE TRIGGER "T_LC_REJECTIONCODES" BEFORE INSERT ON "LC_REJECTIONCODES" FOR EACH ROW BEGIN SELECT "A_LC_REJECTIONCODES".NEXTVAL INTO :NEW."ID" FROM DUAL; END T_LC_REJECTIONCODES;

ALTER TABLE LC_SAMPLE ADD PAYMENT NUMBER DEFAULT 0 NOT NULL
ALTER TABLE LC_SAMPLE ADD PAYMENTTYPE NVARCHAR2(50) NULL
ALTER TABLE LC_SAMPLE ADD PAYMENTNOTES NVARCHAR2(2000) NULL
ALTER TABLE LC_SAMPLE ADD REJECTIONCODE NVARCHAR2(10) NULL

ALTER TABLE GRAPHLIST ADD HEADERTEXT NVARCHAR2(500) NULL
ALTER TABLE GRAPHLIST ADD HEADERFONT NVARCHAR2(100) DEFAULT 'Arial' NOT NULL
ALTER TABLE GRAPHLIST ADD HEADERFONTSIZE NVARCHAR2(10) DEFAULT '10' NOT NULL
ALTER TABLE GRAPHLIST ADD HEADERFONTBOLD NVARCHAR2(10) DEFAULT 'ON' NOT NULL
ALTER TABLE GRAPHLIST ADD HEADERFONTITALIC NVARCHAR2(10) DEFAULT 'OFF' NOT NULL
ALTER TABLE GRAPHLIST ADD HEADERGRAPHICJUST NVARCHAR2(10) DEFAULT 'OFF' NOT NULL

 

ALTER TABLE LC_SAMPLETYPE ADD UD1 NVARCHAR2(100) NULL
ALTER TABLE LC_SAMPLETYPE ADD UD2 NVARCHAR2(100) NULL
ALTER TABLE LC_SAMPLETYPE ADD UD3 NVARCHAR2(100) NULL
ALTER TABLE LC_SAMPLETYPE ADD UD4 NVARCHAR2(100) NULL
ALTER TABLE LC_SAMPLETYPE ADD UD5 NVARCHAR2(100) NULL
ALTER TABLE LC_SAMPLETYPE ADD UD6 NVARCHAR2(100) NULL
ALTER TABLE LC_SAMPLETYPE ADD UD7 NVARCHAR2(100) NULL
ALTER TABLE LC_SAMPLETYPE ADD UD8 NVARCHAR2(100) NULL
ALTER TABLE LC_SAMPLETYPE ADD UD9 NVARCHAR2(100) 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 4/1/2020 1:24 PM.
Last Modified on 4/14/2020 12:55 PM.
Last Modified by Scott Dorner.
Article has been viewed 139 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article