Home : Database Upgrade 7.7.6
Q14539 - INFO: Database Upgrade 7.7.6
With the release of WIMS Client 7.7.6 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.6 client. 

Tech Notes:

SQL Server Scripts:

OPSROOT

CREATE TABLE [dbo].[LIB_PARM]([ID] [int] IDENTITY(1,1) NOT NULL,[AUDITUSER] [varchar](50) NULL,[AUDITTIMESTAMP] [datetime] NULL DEFAULT (getdate()),[NAME] [nvarchar](100) NULL,[SHORTNAME] [nvarchar](500) NULL,[CLAROS_GUID] [uniqueidentifier] NULL,[UD1] [nvarchar](100) NULL,[UD2] [nvarchar](100) NULL,[UD3] [nvarchar](100) NULL,[UD4] [nvarchar](100) NULL,[UD5] [nvarchar](100) NULL) ON [PRIMARY]

FACILITY DATABASES

ALTER TABLE MDE ADD STARTHOUR numeric (18, 0) NULL

ALTER TABLE SPFORMS ADD AUTOEXPORT numeric (18, 0) NULL

ALTER TABLE SPFORMS ADD AUTOEXPORTOPTIONS [nvarchar](2000) NULL

CREATE TABLE [dbo].[VGROUP]([ID] [int] IDENTITY(1,1) NOT NULL,[AUDITUSER] [varchar](50) NULL,[AUDITTIMESTAMP] [datetime] NULL DEFAULT (getdate()),[VGROUPNAME] [nvarchar](255) NULL,[PARENTID] [int] NULL,) ON [PRIMARY]

CREATE TABLE [dbo].[VGROUPACCESS]([AUDITUSER] [varchar](50) NULL,[AUDITTIMESTAMP] [datetime] NULL DEFAULT (getdate()),[VGROUPID] [numeric](18, 0) NOT NULL,[USERID] [numeric](18, 0) NOT NULL,[ACCESSLEVEL] [numeric](18, 0),) ON [PRIMARY]

CREATE TABLE [dbo].[SAMPLEREQ]([AUDITUSER] [varchar](50) NULL,[AUDITTIMESTAMP] [datetime] NULL DEFAULT (getdate()),[ID] [int] IDENTITY(1,1) NOT NULL,[NAME] [nvarchar](100) NOT NULL,[WHERE_CLAUSE] [nvarchar](2000) NOT NULL,[UD1] [nvarchar](100) NULL,[UD2] [nvarchar](100) NULL,[UD3] [nvarchar](100) NULL,[UD4] [nvarchar](100) NULL,[UD5] [nvarchar](100) NULL,[NOTES] [nvarchar](500) NULL,) ON [PRIMARY]

CREATE TABLE [dbo].[SAMPLEREQDETAIL]([AUDITUSER] [varchar](50) NULL,[AUDITTIMESTAMP] [datetime] NULL DEFAULT (getdate()),[ID] [int] IDENTITY(1,1) NOT NULL,[SRID] [numeric](18, 0) NOT NULL,[STARTDATE] [datetime] NOT NULL,[ENDDATE] [datetime] NOT NULL,[NUMREQ] [numeric](18, 0) NOT NULL,[GROUPING] [nvarchar](50) NOT NULL) ON [PRIMARY]

ORACLE:

OPSROOT

CREATE TABLE "LIB_PARM" ("ID" NUMBER NOT NULL, "AUDITUSER" VARCHAR2(50) NULL, "AUDITTIMESTAMP" DATE DEFAULT NULL, "NAME" NVARCHAR2 (100) NULL,"SHORTNAME" NVARCHAR2 (100) NULL,"CLAROS_GUID" NVARCHAR2 (100) NULL,"UD1" NVARCHAR2 (100) NULL,"UD2" NVARCHAR2 (100) NULL,"UD3" NVARCHAR2 (100) NULL,"UD4" NVARCHAR2 (100) NULL,"UD5" NVARCHAR2 (100) NULL)

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

CREATE TRIGGER "T_LIB_PARM" BEFORE INSERT ON "LIB_PARM" FOR EACH ROW BEGIN SELECT "A_LIB_PARM".NEXTVAL INTO :NEW."ID" FROM DUAL; END T_LIB_PARM;

FACILITY DATABASES

ALTER TABLE MDE ADD STARTHOUR NUMBER NULL

ALTER TABLE SPFORMS ADD AUTOEXPORT NUMBER NULL

ALTER TABLE SPFORMS ADD AUTOEXPORTOPTIONS NVARCHAR2(2000) NULL

CREATE TABLE "VGROUP" ("ID" NUMBER NOT NULL, "AUDITUSER" VARCHAR2(50) NULL, "AUDITTIMESTAMP" DATE DEFAULT NULL, "VGROUPNAME" NVARCHAR2 (255) NULL,"PARENTID" NUMBER NULL)

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

CREATE TRIGGER "T_VGROUP" BEFORE INSERT ON "VGROUP" FOR EACH ROW BEGIN SELECT "A_VGROUP".NEXTVAL INTO :NEW."ID" FROM DUAL; END T_VGROUP;

CREATE TABLE "VGROUPACCESS" ("AUDITUSER" VARCHAR2(50) NULL, "AUDITTIMESTAMP" DATE DEFAULT NULL, "VGROUPID" NUMBER NOT NULL,"USERID" NUMBER NOT NULL,"ACCESSLEVEL" NUMBER NOT NULL)

CREATE TABLE "SAMPLEREQ" ("ID" NUMBER NOT NULL, "AUDITUSER" VARCHAR2(50) NULL, "AUDITTIMESTAMP" DATE DEFAULT NULL, "NAME" NVARCHAR2 (100) NULL,"WHERE_CLAUSE" NVARCHAR2 (2000) NULL,"UD1" NVARCHAR2 (100) NULL,"UD2" NVARCHAR2 (100) NULL,"UD3" NVARCHAR2 (100) NULL,"UD4" NVARCHAR2 (100) NULL,"UD5" NVARCHAR2 (100) NULL,"NOTES" NVARCHAR2 (500) NULL)

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

CREATE TRIGGER "T_SAMPLEREQ" BEFORE INSERT ON "SAMPLEREQ" FOR EACH ROW BEGIN SELECT "A_SAMPLEREQ".NEXTVAL INTO :NEW."ID" FROM DUAL; END T_SAMPLEREQ;

CREATE TABLE "SAMPLEREQDETAIL" ("ID" NUMBER NOT NULL, "SRID" NUMBER NOT NULL, "AUDITUSER" VARCHAR2(50) NULL, "AUDITTIMESTAMP" DATE DEFAULT NULL, "STARTDATE" DATE DEFAULT NULL, "ENDDATE" DATE DEFAULT NULL, "NUMREQ" NUMBER NOT NULL,"GROUPING" NVARCHAR2 (50) NULL)

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

CREATE TRIGGER "T_SAMPLEREQDETAIL" BEFORE INSERT ON "SAMPLEREQDETAIL" FOR EACH ROW BEGIN SELECT "A_SAMPLEREQDETAIL".NEXTVAL INTO :NEW."ID" FROM DUAL; END T_SAMPLEREQDETAIL;


 

 

 

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