|
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;
|
 |
|
|
|
No Related Articles Available.
|
|
|
|
|
No Attachments Available.
|
|
|
|
|
No Related Links Available.
|
|
|
|
|
|
|
|
|
|
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 2873 times. |
|
|
Rated 0 out of 10 based on 0 votes. |
|
 Print Article |
|
 Email Article
|
|
|