Database Upgrade 846 [Q14839]

	Browse		Search		Login

Home : Database Upgrade 846

Q14839 - INFO: Database Upgrade 846

With the release of WIMS Client 8.4.6 a database upgrade is required. The upgrade is automatically applied when logging into a Facility Database for the first time with the WIMS 8.4.6 client.

Tech Notes:

SQL Server Scripts:

OPSROOT

CREATE TABLE [dbo].[MATHTOOLBOXFUNCTIONS](
            [ID] [int] IDENTITY(1,1) NOT NULL,
            [AUDITUSER] [varchar](50) NULL," & _
            [AUDITTIMESTAMP] [datetime] NULL DEFAULT (getdate()),
            [NAME] [nvarchar](100) NULL,
            [SYNTAX] [nvarchar](500) NULL,
            [DESCRIPTION] [nvarchar](500) NULL,
            [HELPID] [nvarchar](100) NULL,
            [TAG1] [nvarchar](100) NULL,
            [TAG2] [nvarchar](100) NULL,
            [TAG3] [nvarchar](100) NULL,
            [TAG4] [nvarchar](100) NULL
            ) ON [PRIMARY]

Facility Databases

ALTER TABLE VARDESC ALTER COLUMN UD1 NVARCHAR(255)
ALTER TABLE VARDESC ALTER COLUMN UD2 NVARCHAR(255)
ALTER TABLE VARDESC ALTER COLUMN UD3 NVARCHAR(255)
ALTER TABLE VARDESC ALTER COLUMN UD4 NVARCHAR(255)
ALTER TABLE VARDESC ALTER COLUMN UD5 NVARCHAR(255)
ALTER TABLE VARDESC ALTER COLUMN UD6 NVARCHAR(255)
ALTER TABLE VARDESC ALTER COLUMN UD7 NVARCHAR(255)
ALTER TABLE VARDESC ALTER COLUMN UD8 NVARCHAR(255)
ALTER TABLE VARDESC ALTER COLUMN UD9 NVARCHAR(255)

Oracle:

OPSROOT

CREATE TABLE "MATHTOOLBOXFUNCTIONS" (
                "ID" NUMBER NOT NULL,
                "AUDITUSER" & Chr(34) & " VARCHAR2(50) NULL,
                "AUDITTIMESTAMP" & Chr(34) & " DATE DEFAULT NULL,
                "NAME" & Chr(34) & " NVARCHAR2 (100) NULL,
                "SYNTAX" & Chr(34) & " NVARCHAR2 (500) NULL,
                "DESCRIPTION" & Chr(34) & " NVARCHAR2 (500) NULL,
                "HELPID" & Chr(34) & " NVARCHAR2 (5) NULL,
                "TAG1" & Chr(34) & " NVARCHAR2 (100) NULL,
                "TAG2" & Chr(34) & " NVARCHAR2 (100) NULL,
                "TAG3" & Chr(34) & " NVARCHAR2 (100) NULL,
                "TAG4" & Chr(34) & " NVARCHAR2 (100) NULL)

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

Facility Databases

ALTER TABLE VARDESC MODIFY(UD1 NVARCHAR2(255))
ALTER TABLE VARDESC MODIFY(UD2 NVARCHAR2(255))
ALTER TABLE VARDESC MODIFY(UD3 NVARCHAR2(255))
ALTER TABLE VARDESC MODIFY(UD4 NVARCHAR2(255))
ALTER TABLE VARDESC MODIFY(UD5 NVARCHAR2(255))
ALTER TABLE VARDESC MODIFY(UD6 NVARCHAR2(255))
ALTER TABLE VARDESC MODIFY(UD7 NVARCHAR2(255))
ALTER TABLE VARDESC MODIFY(UD8 NVARCHAR2(255))
ALTER TABLE VARDESC MODIFY(UD9 NVARCHAR2(255))