With the release of WIMS Client 8.2.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.2.4 

Tech Notes:

SQL Server Scripts:

OPSROOT:

ALTER TABLE SPRPTS_SHEETS ADD PRINTFOOTER [nvarchar](2000) NULL
ALTER TABLE SPRPTS_SHEETS ADD PRINTHEADER [nvarchar](2000) NULL
ALTER TABLE SPRPTS_SHEETS ADD PAPERHEIGHT [numeric](18, 0) NULL
ALTER TABLE SPRPTS_SHEETS ADD PAPERWIDTH [numeric](18, 0) NULL

Facility Databases:

CREATE TABLE [dbo].[GRAPHYOY]([ID] [int] IDENTITY(1,1) NOT NULL,[AUDITUSER] [varchar](50) NULL,[AUDITTIMESTAMP] [datetime] NULL DEFAULT (getdate()),[NAME] [nvarchar](255) NULL,[GGROUPID] [numeric](18, 0) NULL,[MAINTITLE] [nvarchar](255) NULL,[SUBTITLE] [nvarchar](255) NULL,[QUICKSTYLE] [numeric](18, 0) NULL,[YEARS] [numeric](18, 0) NULL,[VARID] [numeric](18, 0) NULL) ON [PRIMARY]

ALTER TABLE CHART ADD YAXIS1MIN FLOAT NULL DEFAULT NULL
ALTER TABLE CHART ADD YAXIS1MAX FLOAT NULL DEFAULT NULL

ALTER TABLE CHART ADD PLOT1 [nvarchar](50) NULL DEFAULT NULL
ALTER TABLE CHART ADD PLOT2 [nvarchar](50) NULL DEFAULT NULL
ALTER TABLE CHART ADD PLOT3 [nvarchar](50) NULL DEFAULT NULL
ALTER TABLE CHART ADD PLOT4 [nvarchar](50) NULL DEFAULT NULL
ALTER TABLE CHART ADD PLOT5 [nvarchar](50) NULL DEFAULT NULL
ALTER TABLE CHART ADD PLOT6 [nvarchar](50) NULL DEFAULT NULL
ALTER TABLE CHART ADD PLOT7 [nvarchar](50) NULL DEFAULT NULL
ALTER TABLE CHART ADD PLOT8 [nvarchar](50) NULL DEFAULT NULL
ALTER TABLE CHART ADD PLOT9 [nvarchar](50) NULL DEFAULT NULL
ALTER TABLE CHART ADD PLOT10 [nvarchar](50) NULL DEFAULT NULL

UPDATE CHART SET PLOT1 = 'Raw Data'
UPDATE CHART SET PLOT2 = 'Raw Data'
UPDATE CHART SET PLOT3 = 'Raw Data'
UPDATE CHART SET PLOT4 = 'Raw Data'
UPDATE CHART SET PLOT5 = 'Raw Data'
UPDATE CHART SET PLOT6 = 'Raw Data'
UPDATE CHART SET PLOT7 = 'Raw Data'
UPDATE CHART SET PLOT8 = 'Raw Data'
UPDATE CHART SET PLOT9 = 'Raw Data'
UPDATE CHART SET PLOT10 = 'Raw Data'

Oracle Scripts:

OPSROOT:

ALTER TABLE SPRPTS_SHEETS ADD PRINTFOOTER NVARCHAR2(2000) NULL
ALTER TABLE SPRPTS_SHEETS ADD PRINTHEADER NVARCHAR2(2000) NULL
ALTER TABLE SPRPTS_SHEETS ADD PAPERHEIGHT NUMBER NULL
ALTER TABLE SPRPTS_SHEETS ADD PAPERWIDTH NUMBER NULL

Facility Databases:

CREATE TABLE "GRAPHYOY" & Chr(34)
                ("ID" NUMBER NOT NULL,
                "AUDITUSER" VARCHAR2(50) NULL,
                "AUDITTIMESTAMP" DATE DEFAULT NULL,
                "NAME" NVARCHAR2 (100) NULL,
                "GGROUPID" NUMBER DEFAULT 0 NULL,
                "MAINTITLE" NVARCHAR2(255) DEFAULT NULL,
                "SUBTITLE" NVARCHAR2(255) DEFAULT NULL,
                "QUICKSTYLE" NUMBER DEFAULT 0 NULL,
                "YEARS" NUMBER DEFAULT 4 NULL,
                "VARID" NUMBER NULL)

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

CREATE TRIGGER "T_GRAPHYOY" BEFORE INSERT ON "GRAPHYOY" FOR EACH ROW BEGIN SELECT "A_GRAPHYOY" .NEXTVAL INTO :NEW."ID"  FROM DUAL; END T_GRAPHYOY;

ALTER TABLE CHART ADD YAXIS1MIN NUMBER NULL
ALTER TABLE CHART ADD YAXIS1MAX NUMBER NULL

ALTER TABLE CHART ADD PLOT1 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE CHART ADD PLOT2 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE CHART ADD PLOT3 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE CHART ADD PLOT4 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE CHART ADD PLOT5 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE CHART ADD PLOT6 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE CHART ADD PLOT7 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE CHART ADD PLOT8 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE CHART ADD PLOT9 NVARCHAR2(50) DEFAULT NULL
ALTER TABLE CHART ADD PLOT10 NVARCHAR2(50) DEFAULT NULL

UPDATE CHART SET PLOT1 = 'Raw Data'
UPDATE CHART SET PLOT2 = 'Raw Data'
UPDATE CHART SET PLOT3 = 'Raw Data'
UPDATE CHART SET PLOT4 = 'Raw Data'
UPDATE CHART SET PLOT5 = 'Raw Data'
UPDATE CHART SET PLOT6 = 'Raw Data'
UPDATE CHART SET PLOT7 = 'Raw Data'
UPDATE CHART SET PLOT8 = 'Raw Data'
UPDATE CHART SET PLOT9 = 'Raw Data'
UPDATE CHART SET PLOT10 = 'Raw Data'