Home : Database Upgrade 7.7.8
Q14547 - INFO: Database Upgrade 7.7.8
With the release of WIMS Client 7.7.8 a database upgrade is required.  The upgrade is automatically applied when logging into a Facility Database for the first time with the WIMS 7.7.8 client. 

Tech Notes:

SQL Server Scripts:

OPSROOT

ALTER TABLE FACILITY ADD DASHMSG [nvarchar](2000)  NULL DEFAULT (NULL)

FACILITY DATABASES

ALTER TABLE LC_PEOPLE ADD PWSID [nvarchar](50)  NULL DEFAULT (NULL)
ALTER TABLE LC_PEOPLE ADD PWSNAME [nvarchar](200) NULL DEFAULT (NULL)
ALTER TABLE LC_PEOPLE ADD COUNTY [nvarchar](50) NULL DEFAULT (NULL)

ALTER TABLE LOCATION ADD PATH [nvarchar](2000) NULL DEFAULT (NULL)

ALTER TABLE VARDESC ADD VGROUPID [numeric](18, 0) NOT NULL DEFAULT (0)

ALTER TABLE VARDES ADD CLAROS_PARMGUID [uniqueidentifier] NULL 
ALTER TABLE VARDES ADD SOURCE [navarchar](100) NULL 
ALTER TABLE VARDES ADD COMPSUBLOC [navarchar](100) NULL

ALTER TABLE MDE ADD WINDOWSTATE [numeric](18, 0) NULL
ALTER TABLE MDE ADD FORMHEIGHT [numeric](18, 0) NULL
ALTER TABLE MDE ADD FORMWIDTH [numeric](18, 0) NULL
ALTER TABLE MDE ADD FORMLEFT [numeric](18, 0) NULL
ALTER TABLE MDE ADD FORMTOP [numeric](18, 0) NULL
ALTER TABLE MDE ADD QTSHOW [numeric](18, 0) NULL
ALTER TABLE MDE ADD QTFORMHEIGHT [numeric](18, 0) NULL
ALTER TABLE MDE ADD QTFORMWIDTH [numeric](18, 0) NULL
ALTER TABLE MDE ADD QTFORMLEFT [numeric](18, 0) NULL
ALTER TABLE MDE ADD QTFORMTOP [numeric](18, 0) NULL  
ALTER TABLE MDE ADD PICSHOW [numeric](18, 0) NULL
ALTER TABLE MDE ADD PICFORMHEIGHT [numeric](18, 0) NULL
ALTER TABLE MDE ADD PICFORMWIDTH [numeric](18, 0) NULL
ALTER TABLE MDE ADD PICFORMLEFT [numeric](18, 0) NULL
ALTER TABLE MDE ADD PICFORMTOP [numeric](18, 0) NULL
ALTER TABLE MDE ADD AISHOW [numeric](18, 0) NULL
ALTER TABLE MDE ADD AIFORMHEIGHT [numeric](18, 0) NULL
ALTER TABLE MDE ADD AIFORMWIDTH [numeric](18, 0) NULL
ALTER TABLE MDE ADD AIFORMLEFT [numeric](18, 0) NULL
ALTER TABLE MDE ADD AIFORMTOP [numeric](18, 0) NULL
ALTER TABLE MDE ADD AICOLWIDTH1 [numeric](18, 0) NULL
ALTER TABLE MDE ADD AICOLWIDTH2 [numeric](18, 0) NULL
ALTER TABLE MDE ADD WSSHOW [numeric](18, 0) NULL
ALTER TABLE MDE ADD WSFORMHEIGHT [numeric](18, 0) NULL
ALTER TABLE MDE ADD WSFORMWIDTH [numeric](18, 0) NULL
ALTER TABLE MDE ADD WSFORMLEFT [numeric](18, 0) NULL
ALTER TABLE MDE ADD WSFORMTOP [numeric](18, 0) NULL
ALTER TABLE MDE ADD WSWEEKDEF [numeric](18, 0) NULL
ALTER TABLE MDE ADD WSCALCAVG [numeric](18, 0) NULL
ALTER TABLE MDE ADD WSCALCGM [numeric](18, 0) NULL
ALTER TABLE MDE ADD WSGTYPE [numeric](18, 0) NULL
ALTER TABLE MDE ADD WSLTRULE [numeric](18, 0) NULL

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

CREATE TABLE [dbo].[LC_RESULTS_SET]([ID] [int] IDENTITY(1,1) NOT NULL,[AUDITUSER] [varchar](50) NULL,[AUDITTIMESTAMP] [datetime] NULL DEFAULT (getdate()),[NAME] [nvarchar](100) NULL,[WHERE_CLAUSE] [nvarchar](2000) NULL,[SHOWOPTIONS] [nvarchar](100) NULL,[APPLEVEL] [numeric](18, 0) NULL,[DATESETTINGS] [nvarchar](100) NULL,[WINDOWSTATE] [numeric](18, 0) NULL,[FORMHEIGHT] [numeric](18, 0) NULL,[FORMWIDTH] [numeric](18, 0) NULL,[FORMLEFT] [numeric](18, 0) NULL,[FORMTOP] [numeric](18, 0) NULL,[FONTSIZE] [float] NULL,[COLWIDTH1] [numeric](18, 0) NULL,[COLWIDTH2] [numeric](18, 0) NULL,[COLWIDTH3] [numeric](18, 0) NULL,[COLWIDTH4] [numeric](18, 0) NULL,[COLWIDTH5] [numeric](18, 0) NULL,[COLWIDTH6] [numeric](18, 0) NULL,[COLWIDTH7] [numeric](18, 0) NULL,[COLWIDTH8] [numeric](18, 0) NULL,[COLWIDTH9] [numeric](18, 0) NULL,[COLWIDTH10] [numeric](18, 0) NULL,[COLWIDTH11] [numeric](18, 0) NULL,[COLWIDTH12] [numeric](18, 0) NULL,[COLWIDTH13] [numeric](18, 0) NULL,[COLWIDTH14] [numeric](18, 0) NULL,[COLWIDTH15] [numeric](18
, 0) NULL,[COLWIDTH16] [numeric](18, 0) NULL,[COLWIDTH17] [numeric](18, 0) NULL,[COLWIDTH18] [numeric](18, 0) NULL,[UD1] [nvarchar](100) NULL,[UD2] [nvarchar](100) NULL,[UD3] [nvarchar](100) NULL) ON [PRIMARY]

CREATE TABLE [dbo].[FORMSET]([ID] [int] IDENTITY(1,1) NOT NULL,[AUDITUSER] [varchar](50) NULL,[AUDITTIMESTAMP] [datetime] NULL DEFAULT (getdate()),[USERID] [numeric](18, 0) NULL,[FORMNAME] [nvarchar](100) NULL,[WINDOWSTATE] [numeric](18, 0) NULL,[FORMHEIGHT] [numeric](18, 0) NULL,[FORMWIDTH] [numeric](18, 0) NULL,[FORMLEFT] [numeric](18, 0) NULL,[FORMTOP] [numeric](18, 0) NULL,[FONTSIZE] [float] NULL,[COLWIDTH1] [numeric](18, 0) NULL,[COLWIDTH2] [numeric](18, 0) NULL,[COLWIDTH3] [numeric](18, 0) NULL,[COLWIDTH4] [numeric](18, 0) NULL,[COLWIDTH5] [numeric](18, 0) NULL,[COLWIDTH6] [numeric](18, 0) NULL,[COLWIDTH7] [numeric](18, 0) NULL,[COLWIDTH8] [numeric](18, 0) NULL,[COLWIDTH9] [numeric](18, 0) NULL,[COLWIDTH10] [numeric](18, 0) NULL,[COLWIDTH11] [numeric](18, 0) NULL,[COLWIDTH12] [numeric](18, 0) NULL,[COLWIDTH13] [numeric](18, 0) NULL,[COLWIDTH14] [numeric](18, 0) NULL,[COLWIDTH15] [numeric](18, 0) NULL,[COLWIDTH16] [numeric](18, 0) NULL,[COLWIDTH17] [numeric](18, 0) NULL,[COLWIDTH18] [numeric](18, 0) NUL
L,[UD1] [nvarchar](100) NULL,[UD2] [nvarchar](100) NULL,[UD3] [nvarchar](100) NULL,[UD4] [nvarchar](100) NULL,[UD5] [nvarchar](100) NULL,[UD6] [nvarchar](100) NULL) ON [PRIMARY]

CREATE TABLE [dbo].[EVENTS_SET]([ID] [int] IDENTITY(1,1) NOT NULL,[AUDITUSER] [varchar](50) NULL,[AUDITTIMESTAMP] [datetime] NULL DEFAULT (getdate()),[NAME] [nvarchar](100) NULL,[LOCID] [numeric](18, 0) NULL,[SHOWVIOL] [numeric](18, 0) NOT NULL DEFAULT (0), [SHOWENTRY] [numeric](18, 0) NOT NULL DEFAULT (0),[SHOWQC] [numeric](18, 0) NOT NULL DEFAULT (0), [SHOWSAMPREQ] [numeric](18, 0) NOT NULL DEFAULT (0),[SHOWOPEN] [numeric](18, 0) NOT NULL DEFAULT (0), [SHOWCLOSED] [numeric](18, 0) NOT NULL DEFAULT (0),[QUICKFILTER] [nvarchar](200) NULL,[WINDOWSTATE] [numeric](18, 0) NULL,[FORMHEIGHT] [numeric](18, 0) NULL,[FORMWIDTH] [numeric](18, 0) NULL,[FORMLEFT] [numeric](18, 0) NULL,[FORMTOP] [numeric](18, 0) NULL,[FONTSIZE] [float] NULL,[COLWIDTH1] [numeric](18, 0) NULL,[COLWIDTH2] [numeric](18, 0) NULL,[COLWIDTH3] [numeric](18, 0) NULL,[COLWIDTH4] [numeric](18, 0) NULL,[COLWIDTH5] [numeric](18, 0) NULL,[COLWIDTH6] [numeric](18, 0) NULL,[COLWIDTH7] [numeric](18, 0) NULL,[COLWIDTH8] [numeric](18, 0) NULL,[COLWIDTH9] [
numeric](18, 0) NULL,[COLWIDTH10] [numeric](18, 0) NULL,[COLWIDTH11] [numeric](18, 0) NULL,[COLWIDTH12] [numeric](18, 0) NULL,[COLWIDTH13] [numeric](18, 0) NULL,[COLWIDTH14] [numeric](18, 0) NULL,[COLWIDTH15] [numeric](18, 0) NULL,[COLWIDTH16] [numeric](18, 0) NULL,[UD1] [nvarchar](100) NULL,[UD2] [nvarchar](100) NULL,[UD3] [nvarchar](100) NULL) ON [PRIMARY]

 

ORACLE:

OPSROOT

ALTER TABLE FACILITY ADD DASHMSG NVARCHAR2(2000) DEFAULT NULL

FACILITY DATABASES

ALTER TABLE LC_PEOPLE ADD PWSID NVARCHAR2(50) DEFAULT NULL
ALTER TABLE LC_PEOPLE ADD PWSNAME NVARCHAR2(200) DEFAULT NULL
ALTER TABLE LC_PEOPLE ADD COUNTY  NVARCHAR2(50) DEFAULT NULL

ALTER TABLE LOCATION ADD PATH NVARCHAR2(2000) DEFAULT NULL

ALTER TABLE VARDESC ADD VGROUPID NUMBER DEFAULT 0 NOT NULL

ALTER TABLE VARDESC ADD CLAROS_PARMGUID [uniqueidentifier] NULL
ALTER TABLE VARDESC ADD SOURCE [nvarchar](100) NULL
ALTER TABLE VARDESC ADD COMPSUBLOC [nvarchar](100) NULL

ALTER TABLE MDE ADD WINDOWSTATE NUMBER NULL
ALTER TABLE MDE ADD FORMHEIGHT NUMBER NULL
ALTER TABLE MDE ADD FORMWIDTH NUMBER NULL
ALTER TABLE MDE ADD FORMLEFT NUMBER NULL
ALTER TABLE MDE ADD FORMTOP NUMBER NULL
ALTER TABLE MDE ADD QTSHOW NUMBER NULL
ALTER TABLE MDE ADD QTFORMHEIGHT NUMBER NULL
ALTER TABLE MDE ADD QTFORMWIDTH NUMBER NULL
ALTER TABLE MDE ADD QTFORMLEFT NUMBER NULL
ALTER TABLE MDE ADD QTFORMTOP NUMBER NULL
ALTER TABLE MDE ADD PICSHOW NUMBER NULL
ALTER TABLE MDE ADD PICFORMHEIGHT NUMBER NULL
ALTER TABLE MDE ADD PICFORMWIDTH NUMBER NULL
ALTER TABLE MDE ADD PICFORMLEFT NUMBER NULL
ALTER TABLE MDE ADD PICFORMTOP NUMBER NULL       
ALTER TABLE MDE ADD AISHOW NUMBER NULL
ALTER TABLE MDE ADD AIFORMHEIGHT NUMBER NULL
ALTER TABLE MDE ADD AIFORMWIDTH NUMBER NULL
ALTER TABLE MDE ADD AIFORMLEFT NUMBER NULL
ALTER TABLE MDE ADD AIFORMTOP NUMBER NULL
ALTER TABLE MDE ADD AICOLWIDTH1 NUMBER NULL
ALTER TABLE MDE ADD AICOLWIDTH2 NUMBER NULL      
ALTER TABLE MDE ADD WSSHOW NUMBER NULL
ALTER TABLE MDE ADD WSFORMHEIGHT NUMBER NULL
ALTER TABLE MDE ADD WSFORMWIDTH NUMBER NULL
ALTER TABLE MDE ADD WSFORMLEFT NUMBER NULL
ALTER TABLE MDE ADD WSFORMTOP NUMBER NULL
ALTER TABLE MDE ADD WSWEEKDEF NUMBER NULL
ALTER TABLE MDE ADD WSCALCAVG NUMBER NULL
ALTER TABLE MDE ADD WSCALCGM NUMBER NULL
ALTER TABLE MDE ADD WSGTYPE NUMBER NULL
ALTER TABLE MDE ADD WSLTRULE NUMBER NULL

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

CREATE TABLE "LC_RESULTS_SET"("ID" NUMBER NOT NULL, "AUDITUSER" VARCHAR2(50) NULL, "AUDITTIMESTAMP" DATE DEFAULT NULL, "NAME" nvarchar2 (100) NULL,"WHERE_CLAUSE" NVARCHAR2 (2000) NULL,"SHOWOPTIONS" nvarchar2 (100) NULL,"APPLEVEL" NUMBER NULL,"DATESETTING" nvarchar2 (100) NULL,"WINDOWSTATE" NUMBER NULL,"FORMHEIGHT" NUMBER NULL,"FORMWIDTH" NUMBER NULL,"FORMLEFT" NUMBER NULL,"FORMTOP" NUMBER NULL,"FONTSIZE" NUMBER NULL,"COLWIDTH1" NUMBER NULL,"COLWIDTH2" NUMBER NULL,"COLWIDTH3" NUMBER NULL,"COLWIDTH4" NUMBER NULL,"COLWIDTH5" NUMBER NULL,"COLWIDTH6" NUMBER NULL,"COLWIDTH7" NUMBER NULL,"COLWIDTH8" NUMBER NULL,"COLWIDTH9" NUMBER NULL,"COLWIDTH10" NUMBER NULL,"COLWIDTH11" NUMBER NULL,"COLWIDTH13" NUMBER NULL,"COLWIDTH13" NUMBER NULL,"COLWIDTH14" NUMBER NULL,"COLWIDTH15" NUMBER NULL,"COLWIDTH16" NUMBER NULL,"COLWIDTH17" NUMBER NULL,"COLWIDTH18" NUMBER NULL,"UD1" nvarchar2 (100) NULL,"UD2" nvarchar2 (100) NULL,"UD3" nvarchar2 (100) NULL)

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

CREATE TRIGGER "T_LC_RESULTS_SET" BEFORE INSERT ON "LC_RESULTS_SET" FOR EACH ROW BEGIN SELECT "A_LC_RESULTS_SET".NEXTVAL INTO :NEW."ID" FROM DUAL; END T_LC_RESULTS_SET;

CREATE TABLE "FORMSET"("ID" NUMBER NOT NULL, "AUDITUSER" VARCHAR2(50) NULL, "AUDITTIMESTAMP" DATE DEFAULT NULL, "USERID" NUMBER NULL,"FORMNAME" nvarchar2 (100) NULL,"WINDOWSTATE" NUMBER NULL,"FORMHEIGHT" NUMBER NULL,"FORMWIDTH" NUMBER NULL,"FORMLEFT" NUMBER NULL,"FORMTOP" NUMBER NULL,"FONTSIZE" NUMBER NULL,"COLWIDTH1" NUMBER NULL,"COLWIDTH2" NUMBER NULL,"COLWIDTH3" NUMBER NULL,"COLWIDTH4" NUMBER NULL,"COLWIDTH5" NUMBER NULL,"COLWIDTH6" NUMBER NULL,"COLWIDTH7" NUMBER NULL,"COLWIDTH8" NUMBER NULL,"COLWIDTH9" NUMBER NULL,"COLWIDTH10" NUMBER NULL,"COLWIDTH11" NUMBER NULL,"COLWIDTH12" NUMBER NULL,"COLWIDTH13" NUMBER NULL,"COLWIDTH14" NUMBER NULL,"COLWIDTH15" NUMBER NULL,"COLWIDTH16" NUMBER NULL,"COLWIDTH17" NUMBER NULL,"COLWIDTH18" NUMBER 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)

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;

CREATE TABLE "LC_RESULTS_SET"("ID" NUMBER NOT NULL, "AUDITUSER" VARCHAR2(50) NULL, "AUDITTIMESTAMP" DATE DEFAULT NULL, "NAME" nvarchar2 (100) NULL,"WHERE_CLAUSE" NVARCHAR2 (2000) NULL,"SHOWOPTIONS" nvarchar2 (100) NULL,"APPLEVEL" NUMBER NULL,"DATESETTING" nvarchar2 (100) NULL,"WINDOWSTATE" NUMBER NULL,"FORMHEIGHT" NUMBER NULL,"FORMWIDTH" NUMBER NULL,"FORMLEFT" NUMBER NULL,"FORMTOP" NUMBER NULL,"FONTSIZE" NUMBER NULL,"COLWIDTH1" NUMBER NULL,"COLWIDTH2" NUMBER NULL,"COLWIDTH3" NUMBER NULL,"COLWIDTH4" NUMBER NULL,"COLWIDTH5" NUMBER NULL,"COLWIDTH6" NUMBER NULL,"COLWIDTH7" NUMBER NULL,"COLWIDTH8" NUMBER NULL,"COLWIDTH9" NUMBER NULL,"COLWIDTH10" NUMBER NULL,"COLWIDTH11" NUMBER NULL,"COLWIDTH12" NUMBER NULL,"COLWIDTH13" NUMBER NULL,"COLWIDTH14" NUMBER NULL,"COLWIDTH15" NUMBER NULL,"COLWIDTH16" NUMBER NULL,"COLWIDTH17" NUMBER NULL,"COLWIDTH18" NUMBER NULL,"UD1" nvarchar2 (100) NULL,"UD2" nvarchar2 (100) NULL,"UD3" nvarchar2 (100) NULL)

CREATE SEQUENCE "A_LC_RESULTS_SET" INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER
CREATE TRIGGER "T_LC_RESULTS_SET" BEFORE INSERT ON "LC_RESULTS_SET" FOR EACH ROW BEGIN SELECT "A_LC_RESULTS_SET".NEXTVAL INTO :NEW."ID" FROM DUAL; END T_LC_RESULTS_SET;


CREATE TABLE "EVENTS_SET"("ID" NUMBER NOT NULL, "AUDITUSER" VARCHAR2(50) NULL, "AUDITTIMESTAMP" DATE DEFAULT NULL, "NAME" nvarchar2 (100) NULL,"LOCID" NUMBER NULL,"QUICKFILTER" nvarchar2 (200) NULL,"SHOWVIOL" NUMBER DEFAULT 0 NOT NULL, "SHOWENTRY" NUMBER DEFAULT 0 NOT NULL,"SHOWQC" NUMBER DEFAULT 0 NOT NULL, "SHOWSAMPREQ" NUMBER DEFAULT 0 NOT NULL,"SHOWOPEN" NUMBER DEFAULT 0 NOT NULL, "SHOWCLOSED" NUMBER DEFAULT 0 NOT NULL,"WINDOWSTATE" NUMBER NULL,"FORMHEIGHT" NUMBER NULL,"FORMWIDTH" NUMBER NULL,"FORMLEFT" NUMBER NULL,"FORMTOP" NUMBER NULL,"FONTSIZE" NUMBER NULL,"COLWIDTH1" NUMBER NULL,"COLWIDTH2" NUMBER NULL,"COLWIDTH3" NUMBER NULL,"COLWIDTH4" NUMBER NULL,"COLWIDTH5" NUMBER NULL,"COLWIDTH6" NUMBER NULL,"COLWIDTH7" NUMBER NULL,"COLWIDTH8" NUMBER NULL,"COLWIDTH9" NUMBER NULL,"COLWIDTH10" NUMBER NULL,"COLWIDTH11" NUMBER NULL,"COLWIDTH12" NUMBER NULL,"COLWIDTH13" NUMBER NULL,"COLWIDTH14" NUMBER NULL,"COLWIDTH15" NUMBER NULL,"COLWIDTH16" NUMBER NULL,"UD1" nvarchar2 (100) NULL,"UD2" nvarchar2 (100) NULL,"UD3" nvarchar2 (100) NULL)

CREATE SEQUENCE "A_EVENTS_SET" INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER
CREATE TRIGGER "T_EVENTS_SET" BEFORE INSERT ON "EVENTS_SET" FOR EACH ROW BEGIN SELECT "A_EVENTS_SET".NEXTVAL INTO :NEW."ID" FROM DUAL; END T_EVENTS_SET;


 

 

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 8/1/2019 10:00 AM.
Last Modified on 10/11/2019 4:14 PM.
Last Modified by Scott Dorner.
Article has been viewed 213 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article