Browse Search Login
Home : Database Upgrade 826
Q14792 - INFO: Database Upgrade 826

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


Tech Notes:

SQL Server Scripts:

OPSROOT

CREATE TABLE [dbo].[SPREADFUNCTIONS](
            [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]

Table OPSROOT.LIB_PARM updated with latest Rio Parameter Library

CREATE TABLE [dbo].[GLOBALNOTIFICATIONLIST]([ID] [int] IDENTITY(1,1) NOT NULL,[AUDITUSER] [varchar](50) NULL,[AUDITTIMESTAMP] [datetime] NULL DEFAULT (getdate()),[NAME] [nvarchar](100) NULL,[LIST] NVARCHAR (max) NULL,[NOTES] [nvarchar](500) NULL) ON [PRIMARY]

 

Facility Databases

CREATE TABLE [dbo].[BARCHART]([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,[LEGENDLOCATION] [numeric](18, 0) NULL,[PLOTTINGMETHOD] [numeric](18, 0) NULL,[DATAPRECISION] [numeric](18, 0) NULL,[DATASHADOWS] [numeric](18, 0) NULL,[GRADIENTBARS] [numeric](18, 0) NULL,[FONTSIZE] [numeric](18, 0) NULL,[GRAPHPLUSTABLE] [numeric](18, 0) NULL,[YAXISLABEL] [nvarchar](100) NULL,[YAXISMIN] [numeric](18, 0) NULL,[YAXISMAX] [numeric](18, 0) NULL,[POINTLABEL1] [NVARCHAR] (100),[POINTLABEL2] [NVARCHAR] (100),[POINTLABEL3] [NVARCHAR] (100),[POINTLABEL4] [NVARCHAR] (100),[POINTLABEL5] [NVARCHAR] (100),[POINTLABEL6] [NVARCHAR] (100),[POINTLABEL7] [NVARCHAR] (100),[POINTLABEL8] [NVARCHAR] (100),[POINTLABEL9] [NVARCHAR] (100),[POINTLABEL10] [NVARCHAR] (100),[POINTLABEL11] [NVARCHAR] (100),[POINTLABEL12] [NVARCHAR] (100),[POINTLABEL13] [NVARCHAR] (100),[POINTLABEL14] [NVARCHAR] (100),[POINTLABEL15] [NVARCHAR] (100),[POINTLABEL16] [NVARCHAR] (100),[POINTLABEL17] [NVARCHAR] (100),[POINTLABEL18] [NVARCHAR] (100),[POINTLABEL19] [NVARCHAR] (100),[POINTLABEL20] [NVARCHAR] (100),[GROUPNAME1] [NVARCHAR] (100) NULL,[GROUPSTAT1] [NVARCHAR] (100) NULL,[GROUPOFFSET1] Numeric (18,0) NULL,[GROUPGROUPING1] [NVARCHAR] (10) NULL,[GROUPVARS1] [NVARCHAR] (1000) NULL,[GROUPNAME2] [NVARCHAR] (100) NULL,[GROUPSTAT2] [NVARCHAR] (100) NULL,[GROUPOFFSET2] Numeric (18,0) NULL,[GROUPGROUPING2] [NVARCHAR] (10) NULL,[GROUPVARS2] [NVARCHAR] (1000) NULL,[GROUPNAME3] [NVARCHAR] (100) NULL,[GROUPSTAT3] [NVARCHAR] (100) NULL,[GROUPOFFSET3] Numeric (18,0) NULL,[GROUPGROUPING3] [NVARCHAR] (10) NULL,[GROUPVARS3] [NVARCHAR] (1000) NULL,[GROUPNAME4] [NVARCHAR] (100) NULL,[GROUPSTAT4] [NVARCHAR] (100) NULL,[GROUPOFFSET4] Numeric (18,0) NULL,[GROUPGROUPING4] [NVARCHAR] (10) NULL,[GROUPVARS4] [NVARCHAR] (1000) NULL,[GROUPNAME5] [NVARCHAR] (100) NULL,[GROUPSTAT5] [NVARCHAR] (100) NULL,[GROUPOFFSET5] Numeric (18,0) NULL,[GROUPGROUPING5] [NVARCHAR] (10) NULL,[GROUPVARS5] [NVARCHAR] (1000) NULL,[GROUPNAME6] [NVARCHAR] (100) NULL,[GROUPSTAT6] [NVARCHAR] (100) NULL,[GROUPOFFSET6] Numeric (18,0) NULL,[GROUPGROUPING6] [NVARCHAR] (10) NULL,[GROUPVARS6] [NVARCHAR] (1000) NULL,[GROUPNAME7] [NVARCHAR] (100) NULL,[GROUPSTAT7] [NVARCHAR] (100) NULL,[GROUPOFFSET7] Numeric (18,0) NULL,[GROUPGROUPING7] [NVARCHAR] (10) NULL,[GROUPVARS7] [NVARCHAR] (1000) NULL,[GROUPNAME8] [NVARCHAR] (100) NULL,[GROUPSTAT8] [NVARCHAR] (100) NULL,[GROUPOFFSET8] Numeric (18,0) NULL,[GROUPGROUPING8] [NVARCHAR] (10) NULL,[GROUPVARS8] [NVARCHAR] (1000) NULL,[GROUPNAME9] [NVARCHAR] (100) NULL,[GROUPSTAT9] [NVARCHAR] (100) NULL,[GROUPOFFSET9] Numeric (18,0) NULL,[GROUPGROUPING9] [NVARCHAR] (10) NULL,[GROUPVARS9] [NVARCHAR] (1000) NULL,[GROUPNAME10] [NVARCHAR] (100) NULL,[GROUPSTAT10] [NVARCHAR] (100) NULL,[GROUPOFFSET10] Numeric (18,0) NULL,[GROUPGROUPING10] [NVARCHAR] (10) NULL,[GROUPVARS10] [NVARCHAR] (1000) NULL,[GROUPNAME11] [NVARCHAR] (100) NULL,[GROUPSTAT11] [NVARCHAR] (100) NULL,[GROUPOFFSET11] Numeric (18,0) NULL,[GROUPGROUPING11] [NVARCHAR] (10) NULL,[GROUPVARS11] [NVARCHAR] (1000) NULL,[GROUPNAME12] [NVARCHAR] (100) NULL,[GROUPSTAT12] [NVARCHAR] (100) NULL,[GROUPOFFSET12] Numeric (18,0) NULL,[GROUPGROUPING12] [NVARCHAR] (10) NULL,[GROUPVARS12] [NVARCHAR] (1000) NULL,[GROUPNAME13] [NVARCHAR] (100) NULL,[GROUPSTAT13] [NVARCHAR] (100) NULL,[GROUPOFFSET13] Numeric (18,0) NULL,[GROUPGROUPING13] [NVARCHAR] (10) NULL,[GROUPVARS13] [NVARCHAR] (1000) NULL,[GROUPNAME14] [NVARCHAR] (100) NULL,[GROUPSTAT14] [NVARCHAR] (100) NULL,[GROUPOFFSET14] Numeric (18,0) NULL,[GROUPGROUPING14] [NVARCHAR] (10) NULL,[GROUPVARS14] [NVARCHAR] (1000) NULL,[GROUPNAME15] [NVARCHAR] (100) NULL,[GROUPSTAT15] [NVARCHAR] (100) NULL,[GROUPOFFSET15] Numeric (18,0) NULL,[GROUPGROUPING15] [NVARCHAR] (10) NULL,[GROUPVARS15] [NVARCHAR] (1000) NULL,[GROUPNAME16] [NVARCHAR] (100) NULL,[GROUPSTAT16] [NVARCHAR] (100) NULL,[GROUPOFFSET16] Numeric (18,0) NULL,[GROUPGROUPING16] [NVARCHAR] (10) NULL,[GROUPVARS16] [NVARCHAR] (1000) NULL,[GROUPNAME17] [NVARCHAR] (100) NULL,[GROUPSTAT17] [NVARCHAR] (100) NULL,[GROUPOFFSET17] Numeric (18,0) NULL,[GROUPGROUPING17] [NVARCHAR] (10) NULL,[GROUPVARS17] [NVARCHAR] (1000) NULL,[GROUPNAME18] [NVARCHAR] (100) NULL,[GROUPSTAT18] [NVARCHAR] (100) NULL,[GROUPOFFSET18] Numeric (18,0) NULL,[GROUPGROUPING18] [NVARCHAR] (10) NULL,[GROUPVARS18] [NVARCHAR] (1000) NULL,[GROUPNAME19] [NVARCHAR] (100) NULL,[GROUPSTAT19] [NVARCHAR] (100) NULL,[GROUPOFFSET19] Numeric (18,0) NULL,[GROUPGROUPING19] [NVARCHAR] (10) NULL,[GROUPVARS19] [NVARCHAR] (1000) NULL,[GROUPNAME20] [NVARCHAR] (100) NULL,[GROUPSTAT20] [NVARCHAR] (100) NULL,[GROUPOFFSET20] Numeric (18,0) NULL,[GROUPGROUPING20] [NVARCHAR] (10) NULL,[GROUPVARS20] [NVARCHAR] (1000) NULL,[GROUPNAME21] [NVARCHAR] (100) NULL,[GROUPSTAT21] [NVARCHAR] (100) NULL,[GROUPOFFSET21] Numeric (18,0) NULL,[GROUPGROUPING21] [NVARCHAR] (10) NULL,[GROUPVARS21] [NVARCHAR] (1000) NULL,[GROUPNAME22] [NVARCHAR] (100) NULL,[GROUPSTAT22] [NVARCHAR] (100) NULL,[GROUPOFFSET22] Numeric (18,0) NULL,[GROUPGROUPING22] [NVARCHAR] (10) NULL,[GROUPVARS22] [NVARCHAR] (1000) NULL,[GROUPNAME23] [NVARCHAR] (100) NULL,[GROUPSTAT23] [NVARCHAR] (100) NULL,[GROUPOFFSET23] Numeric (18,0) NULL,[GROUPGROUPING23] [NVARCHAR] (10) NULL,[GROUPVARS23] [NVARCHAR] (1000) NULL,[GROUPNAME24] [NVARCHAR] (100) NULL,[GROUPSTAT24] [NVARCHAR] (100) NULL,[GROUPOFFSET24] Numeric (18,0) NULL,[GROUPGROUPING24] [NVARCHAR] (10) NULL,[GROUPVARS24] [NVARCHAR] (1000) NULL,[GROUPNAME25] [NVARCHAR] (100) NULL,[GROUPSTAT25] [NVARCHAR] (100) NULL,[GROUPOFFSET25] Numeric (18,0) NULL,[GROUPGROUPING25] [NVARCHAR] (10) NULL,[GROUPVARS25] [NVARCHAR] (1000) NULL,[GROUPNAME26] [NVARCHAR] (100) NULL,[GROUPSTAT26] [NVARCHAR] (100) NULL,[GROUPOFFSET26] Numeric (18,0) NULL,[GROUPGROUPING26] [NVARCHAR] (10) NULL,[GROUPVARS26] [NVARCHAR] (1000) NULL,[GROUPNAME27] [NVARCHAR] (100) NULL,[GROUPSTAT27] [NVARCHAR] (100) NULL,[GROUPOFFSET27] Numeric (18,0) NULL,[GROUPGROUPING27] [NVARCHAR] (10) NULL,[GROUPVARS27] [NVARCHAR] (1000) NULL,[GROUPNAME28] [NVARCHAR] (100) NULL,[GROUPSTAT28] [NVARCHAR] (100) NULL,[GROUPOFFSET28] Numeric (18,0) NULL,[GROUPGROUPING28] [NVARCHAR] (10) NULL,[GROUPVARS28] [NVARCHAR] (1000) NULL,[GROUPNAME29] [NVARCHAR] (100) NULL,[GROUPSTAT29] [NVARCHAR] (100) NULL,[GROUPOFFSET29] Numeric (18,0) NULL,[GROUPGROUPING29] [NVARCHAR] (10) NULL,[GROUPVARS29] [NVARCHAR] (1000) NULL,[GROUPNAME30] [NVARCHAR] (100) NULL,[GROUPSTAT30] [NVARCHAR] (100) NULL,[GROUPOFFSET30] Numeric (18,0) NULL,[GROUPGROUPING30] [NVARCHAR] (10) NULL,[GROUPVARS30] [NVARCHAR] (1000) NULL,[GROUPNAME31] [NVARCHAR] (100) NULL,[GROUPSTAT31] [NVARCHAR] (100) NULL,[GROUPOFFSET31] Numeric (18,0) NULL,[GROUPGROUPING31] [NVARCHAR] (10) NULL,[GROUPVARS31] [NVARCHAR] (1000) NULL,[GROUPNAME32] [NVARCHAR] (100) NULL,[GROUPSTAT32] [NVARCHAR] (100) NULL,[GROUPOFFSET32] Numeric (18,0) NULL,[GROUPGROUPING32] [NVARCHAR] (10) NULL,[GROUPVARS32] [NVARCHAR] (1000) NULL,[GROUPNAME33] [NVARCHAR] (100) NULL,[GROUPSTAT33] [NVARCHAR] (100) NULL,[GROUPOFFSET33] Numeric (18,0) NULL,[GROUPGROUPING33] [NVARCHAR] (10) NULL,[GROUPVARS33] [NVARCHAR] (1000) NULL,[GROUPNAME34] [NVARCHAR] (100) NULL,[GROUPSTAT34] [NVARCHAR] (100) NULL,[GROUPOFFSET34] Numeric (18,0) NULL,[GROUPGROUPING34] [NVARCHAR] (10) NULL,[GROUPVARS34] [NVARCHAR] (1000) NULL,[GROUPNAME35] [NVARCHAR] (100) NULL,[GROUPSTAT35] [NVARCHAR] (100) NULL,[GROUPOFFSET35] Numeric (18,0) NULL,[GROUPGROUPING35] [NVARCHAR] (10) NULL,[GROUPVARS35] [NVARCHAR] (1000) NULL,[GROUPNAME36] [NVARCHAR] (100) NULL,[GROUPSTAT36] [NVARCHAR] (100) NULL,[GROUPOFFSET36] Numeric (18,0) NULL,[GROUPGROUPING36] [NVARCHAR] (10) NULL,[GROUPVARS36] [NVARCHAR] (1000) NULL,[GROUPNAME37] [NVARCHAR] (100) NULL,[GROUPSTAT37] [NVARCHAR] (100) NULL,[GROUPOFFSET37] Numeric (18,0) NULL,[GROUPGROUPING37] [NVARCHAR] (10) NULL,[GROUPVARS37] [NVARCHAR] (1000) NULL,[GROUPNAME38] [NVARCHAR] (100) NULL,[GROUPSTAT38] [NVARCHAR] (100) NULL,[GROUPOFFSET38] Numeric (18,0) NULL,[GROUPGROUPING38] [NVARCHAR] (10) NULL,[GROUPVARS38] [NVARCHAR] (1000) NULL,[GROUPNAME39] [NVARCHAR] (100) NULL,[GROUPSTAT39] [NVARCHAR] (100) NULL,[GROUPOFFSET39] Numeric (18,0) NULL,[GROUPGROUPING39] [NVARCHAR] (10) NULL,[GROUPVARS39] [NVARCHAR] (1000) NULL,[GROUPNAME40] [NVARCHAR] (100) NULL,[GROUPSTAT40] [NVARCHAR] (100) NULL,[GROUPOFFSET40] Numeric (18,0) NULL,[GROUPGROUPING40] [NVARCHAR] (10) NULL,[GROUPVARS40] [NVARCHAR] (1000) NULL,[GROUPNAME41] [NVARCHAR] (100) NULL,[GROUPSTAT41] [NVARCHAR] (100) NULL,[GROUPOFFSET41] Numeric (18,0) NULL,[GROUPGROUPING41] [NVARCHAR] (10) NULL,[GROUPVARS41] [NVARCHAR] (1000) NULL,[GROUPNAME42] [NVARCHAR] (100) NULL,[GROUPSTAT42] [NVARCHAR] (100) NULL,[GROUPOFFSET42] Numeric (18,0) NULL,[GROUPGROUPING42] [NVARCHAR] (10) NULL,[GROUPVARS42] [NVARCHAR] (1000) NULL,[GROUPNAME43] [NVARCHAR] (100) NULL,[GROUPSTAT43] [NVARCHAR] (100) NULL,[GROUPOFFSET43] Numeric (18,0) NULL,[GROUPGROUPING43] [NVARCHAR] (10) NULL,[GROUPVARS43] [NVARCHAR] (1000) NULL,[GROUPNAME44] [NVARCHAR] (100) NULL,[GROUPSTAT44] [NVARCHAR] (100) NULL,[GROUPOFFSET44] Numeric (18,0) NULL,[GROUPGROUPING44] [NVARCHAR] (10) NULL,[GROUPVARS44] [NVARCHAR] (1000) NULL,[GROUPNAME45] [NVARCHAR] (100) NULL,[GROUPSTAT45] [NVARCHAR] (100) NULL,[GROUPOFFSET45] Numeric (18,0) NULL,[GROUPGROUPING45] [NVARCHAR] (10) NULL,[GROUPVARS45] [NVARCHAR] (1000) NULL,[GROUPNAME46] [NVARCHAR] (100) NULL,[GROUPSTAT46] [NVARCHAR] (100) NULL,[GROUPOFFSET46] Numeric (18,0) NULL,[GROUPGROUPING46] [NVARCHAR] (10) NULL,[GROUPVARS46] [NVARCHAR] (1000) NULL,[GROUPNAME47] [NVARCHAR] (100) NULL,[GROUPSTAT47] [NVARCHAR] (100) NULL,[GROUPOFFSET47] Numeric (18,0) NULL,[GROUPGROUPING47] [NVARCHAR] (10) NULL,[GROUPVARS47] [NVARCHAR] (1000) NULL,[GROUPNAME48] [NVARCHAR] (100) NULL,[GROUPSTAT48] [NVARCHAR] (100) NULL,[GROUPOFFSET48] Numeric (18,0) NULL,[GROUPGROUPING48] [NVARCHAR] (10) NULL,[GROUPVARS48] [NVARCHAR] (1000) NULL,[GROUPNAME49] [NVARCHAR] (100) NULL,[GROUPSTAT49] [NVARCHAR] (100) NULL,[GROUPOFFSET49] Numeric (18,0) NULL,[GROUPGROUPING49] [NVARCHAR] (10) NULL,[GROUPVARS49] [NVARCHAR] (1000) NULL,[GROUPNAME50] [NVARCHAR] (100) NULL,[GROUPSTAT50] [NVARCHAR] (100) NULL,[GROUPOFFSET50] Numeric (18,0) NULL,[GROUPGROUPING50] [NVARCHAR] (10) NULL,[GROUPVARS50] [NVARCHAR] (1000) NULL,[GROUPNAME51] [NVARCHAR] (100) NULL,[GROUPSTAT51] [NVARCHAR] (100) NULL,[GROUPOFFSET51] Numeric (18,0) NULL,[GROUPGROUPING51] [NVARCHAR] (10) NULL,[GROUPVARS51] [NVARCHAR] (1000) NULL,[GROUPNAME52] [NVARCHAR] (100) NULL,[GROUPSTAT52] [NVARCHAR] (100) NULL,[GROUPOFFSET52] Numeric (18,0) NULL,[GROUPGROUPING52] [NVARCHAR] (10) NULL,[GROUPVARS52] [NVARCHAR] (1000) NULL,[GROUPNAME53] [NVARCHAR] (100) NULL,[GROUPSTAT53] [NVARCHAR] (100) NULL,[GROUPOFFSET53] Numeric (18,0) NULL,[GROUPGROUPING53] [NVARCHAR] (10) NULL,[GROUPVARS53] [NVARCHAR] (1000) NULL,[GROUPNAME54] [NVARCHAR] (100) NULL,[GROUPSTAT54] [NVARCHAR] (100) NULL,[GROUPOFFSET54] Numeric (18,0) NULL,[GROUPGROUPING54] [NVARCHAR] (10) NULL,[GROUPVARS54] [NVARCHAR] (1000) NULL,[GROUPNAME55] [NVARCHAR] (100) NULL,[GROUPSTAT55] [NVARCHAR] (100) NULL,[GROUPOFFSET55] Numeric (18,0) NULL,[GROUPGROUPING55] [NVARCHAR] (10) NULL,[GROUPVARS55] [NVARCHAR] (1000) NULL,[GROUPNAME56] [NVARCHAR] (100) NULL,[GROUPSTAT56] [NVARCHAR] (100) NULL,[GROUPOFFSET56] Numeric (18,0) NULL,[GROUPGROUPING56] [NVARCHAR] (10) NULL,[GROUPVARS56] [NVARCHAR] (1000) NULL,[GROUPNAME57] [NVARCHAR] (100) NULL,[GROUPSTAT57] [NVARCHAR] (100) NULL,[GROUPOFFSET57] Numeric (18,0) NULL,[GROUPGROUPING57] [NVARCHAR] (10) NULL,[GROUPVARS57] [NVARCHAR] (1000) NULL,[GROUPNAME58] [NVARCHAR] (100) NULL,[GROUPSTAT58] [NVARCHAR] (100) NULL,[GROUPOFFSET58] Numeric (18,0) NULL,[GROUPGROUPING58] [NVARCHAR] (10) NULL,[GROUPVARS58] [NVARCHAR] (1000) NULL,[GROUPNAME59] [NVARCHAR] (100) NULL,[GROUPSTAT59] [NVARCHAR] (100) NULL,[GROUPOFFSET59] Numeric (18,0) NULL,[GROUPGROUPING59] [NVARCHAR] (10) NULL,[GROUPVARS59] [NVARCHAR] (1000) NULL,[GROUPNAME60] [NVARCHAR] (100) NULL,[GROUPSTAT60] [NVARCHAR] (100) NULL,[GROUPOFFSET60] Numeric (18,0) NULL,[GROUPGROUPING60] [NVARCHAR] (10) NULL,[GROUPVARS60] [NVARCHAR] (1000) NULL) ON [PRIMARY]

 

Oracle Scripts:

OPSROOT

CREATE TABLE "GLOBALNOTIFICATIONLIST" ("ID" NUMBER NOT NULL,
        "AUDITUSER" VARCHAR2(50) NULL,
        "AUDITTIMESTAMP" DATE DEFAULT NULL,
        "NAME" NVARCHAR2 (100) NULL,
        "LIST" NVARCHAR2 (1000) NULL,
        "NOTES" NVARCHAR2 (500) NULL)

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

CREATE TRIGGER "T_LC_GLOBALNOTIFICATIONLIST"  BEFORE INSERT ON  "GLOBALNOTIFICATIONLIST"  FOR EACH ROW BEGIN SELECT "A_LC_GLOBALNOTIFICATIONLIST".NEXTVAL INTO :NEW. "ID" FROM DUAL; END T_LC_GLOBALNOTIFICATIONLIST;


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

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

CREATE TRIGGER  "T_SPREADFUNCTIONS" BEFORE INSERT ON  "SPREADFUNCTIONS" FOR EACH ROW BEGIN SELECT  "A_SPREADFUNCTIONS" .NEXTVAL INTO :NEW "ID"  FROM DUAL; END T_SPREADFUNCTIONS;

Facility Databases

CREATE TABLE "BARCHART" ("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,"LEGENDLOCATION" NUMBER DEFAULT 0 NULL,"PLOTTINGMETHOD" NUMBER DEFAULT 0 NULL,"DATAPRECISION" NUMBER DEFAULT 0 NULL,"DATASHADOWS" NUMBER DEFAULT 0 NULL,"GRADIENTBARS" NUMBER DEFAULT 0 NULL,"FONTSIZE" NUMBER DEFAULT 0 NULL,"GRAPHPLUSTABLE" NUMBER DEFAULT 0 NULL,"YAXISLABEL" NVARCHAR2 (100) NULL,"YAXISMIN" NUMBER DEFAULT 0 NULL,"YAXISMAX" NUMBER DEFAULT 0 NULL,"POINTLABEL1" NVARCHAR2 (100) NULL,"POINTLABEL2" NVARCHAR2 (100) NULL,"POINTLABEL3" NVARCHAR2 (100) NULL,"POINTLABEL4" NVARCHAR2 (100) NULL,"POINTLABEL5" NVARCHAR2 (100) NULL,"POINTLABEL6" NVARCHAR2 (100) NULL,"POINTLABEL7" NVARCHAR2 (100) NULL,"POINTLABEL8" NVARCHAR2 (100) NULL,"POINTLABEL9" NVARCHAR2 (100) NULL,"POINTLABEL10" NVARCHAR2 (100) NULL,"POINTLABEL11" NVARCHAR2 (100) NULL,"POINTLABEL12" NVARCHAR2 (100) NULL,"POINTLABEL13" NVARCHAR2 (100) NULL,"POINTLABEL14" NVARCHAR2 (100) NULL,"POINTLABEL15" NVARCHAR2 (100) NULL,"POINTLABEL16" NVARCHAR2 (100) NULL,"POINTLABEL17" NVARCHAR2 (100) NULL,"POINTLABEL18" NVARCHAR2 (100) NULL,"POINTLABEL19" NVARCHAR2 (100) NULL,"POINTLABEL20" NVARCHAR2 (100) NULL,"GROUPNAME1" NVARCHAR2 (100) NULL,"GROUPSTAT1" NVARCHAR2 (100) NULL,"GROUPOFFSET1" NUMBER DEFAULT 0 NULL,"GROUPGROUPING1" NVARCHAR2 (10) NULL,"GROUPVARS1" NVARCHAR2 (1000) NULL,"GROUPNAME2" NVARCHAR2 (100) NULL,"GROUPSTAT2" NVARCHAR2 (100) NULL,"GROUPOFFSET2" NUMBER DEFAULT 0 NULL,"GROUPGROUPING2" NVARCHAR2 (10) NULL,"GROUPVARS2" NVARCHAR2 (1000) NULL,"GROUPNAME3" NVARCHAR2 (100) NULL,"GROUPSTAT3" NVARCHAR2 (100) NULL,"GROUPOFFSET3" NUMBER DEFAULT 0 NULL,"GROUPGROUPING3" NVARCHAR2 (10) NULL,"GROUPVARS3" NVARCHAR2 (1000) NULL,"GROUPNAME4" NVARCHAR2 (100) NULL,"GROUPSTAT4" NVARCHAR2 (100) NULL,"GROUPOFFSET4" NUMBER DEFAULT 0 NULL,"GROUPGROUPING4" NVARCHAR2 (10) NULL,"GROUPVARS4" NVARCHAR2 (1000) NULL,"GROUPNAME5" NVARCHAR2 (100) NULL,"GROUPSTAT5" NVARCHAR2 (100) NULL,"GROUPOFFSET5" NUMBER DEFAULT 0 NULL,"GROUPGROUPING5" NVARCHAR2 (10) NULL,"GROUPVARS5" NVARCHAR2 (1000) NULL,"GROUPNAME6" NVARCHAR2 (100) NULL,"GROUPSTAT6" NVARCHAR2 (100) NULL,"GROUPOFFSET6" NUMBER DEFAULT 0 NULL,"GROUPGROUPING6" NVARCHAR2 (10) NULL,"GROUPVARS6" NVARCHAR2 (1000) NULL,"GROUPNAME7" NVARCHAR2 (100) NULL,"GROUPSTAT7" NVARCHAR2 (100) NULL,"GROUPOFFSET7" NUMBER DEFAULT 0 NULL,"GROUPGROUPING7" NVARCHAR2 (10) NULL,"GROUPVARS7" NVARCHAR2 (1000) NULL,"GROUPNAME8" NVARCHAR2 (100) NULL,"GROUPSTAT8" NVARCHAR2 (100) NULL,"GROUPOFFSET8" NUMBER DEFAULT 0 NULL,"GROUPGROUPING8" NVARCHAR2 (10) NULL,"GROUPVARS8" NVARCHAR2 (1000) NULL,"GROUPNAME9" NVARCHAR2 (100) NULL,"GROUPSTAT9" NVARCHAR2 (100) NULL,"GROUPOFFSET9" NUMBER DEFAULT 0 NULL,"GROUPGROUPING9" NVARCHAR2 (10) NULL,"GROUPVARS9" NVARCHAR2 (1000) NULL,"GROUPNAME10" NVARCHAR2 (100) NULL,"GROUPSTAT10" NVARCHAR2 (100) NULL,"GROUPOFFSET10" NUMBER DEFAULT 0 NULL,"GROUPGROUPING10" NVARCHAR2 (10) NULL,"GROUPVARS10" NVARCHAR2 (1000) NULL,"GROUPNAME11" NVARCHAR2 (100) NULL,"GROUPSTAT11" NVARCHAR2 (100) NULL,"GROUPOFFSET11" NUMBER DEFAULT 0 NULL,"GROUPGROUPING11" NVARCHAR2 (10) NULL,"GROUPVARS11" NVARCHAR2 (1000) NULL,"GROUPNAME12" NVARCHAR2 (100) NULL,"GROUPSTAT12" NVARCHAR2 (100) NULL,"GROUPOFFSET12" NUMBER DEFAULT 0 NULL,"GROUPGROUPING12" NVARCHAR2 (10) NULL,"GROUPVARS12" NVARCHAR2 (1000) NULL,"GROUPNAME13" NVARCHAR2 (100) NULL,"GROUPSTAT13" NVARCHAR2 (100) NULL,"GROUPOFFSET13" NUMBER DEFAULT 0 NULL,"GROUPGROUPING13" NVARCHAR2 (10) NULL,"GROUPVARS13" NVARCHAR2 (1000) NULL,"GROUPNAME14" NVARCHAR2 (100) NULL,"GROUPSTAT14" NVARCHAR2 (100) NULL,"GROUPOFFSET14" NUMBER DEFAULT 0 NULL,"GROUPGROUPING14" NVARCHAR2 (10) NULL,"GROUPVARS14" NVARCHAR2 (1000) NULL,"GROUPNAME15" NVARCHAR2 (100) NULL,"GROUPSTAT15" NVARCHAR2 (100) NULL,"GROUPOFFSET15" NUMBER DEFAULT 0 NULL,"GROUPGROUPING15" NVARCHAR2 (10) NULL,"GROUPVARS15" NVARCHAR2 (1000) NULL,"GROUPNAME16" NVARCHAR2 (100) NULL,"GROUPSTAT16" NVARCHAR2 (100) NULL,"GROUPOFFSET16" NUMBER DEFAULT 0 NULL,"GROUPGROUPING16" NVARCHAR2 (10) NULL,"GROUPVARS16" NVARCHAR2 (1000) NULL,"GROUPNAME17" NVARCHAR2 (100) NULL,"GROUPSTAT17" NVARCHAR2 (100) NULL,"GROUPOFFSET17" NUMBER DEFAULT 0 NULL,"GROUPGROUPING17" NVARCHAR2 (10) NULL,"GROUPVARS17" NVARCHAR2 (1000) NULL,"GROUPNAME18" NVARCHAR2 (100) NULL,"GROUPSTAT18" NVARCHAR2 (100) NULL,"GROUPOFFSET18" NUMBER DEFAULT 0 NULL,"GROUPGROUPING18" NVARCHAR2 (10) NULL,"GROUPVARS18" NVARCHAR2 (1000) NULL,"GROUPNAME19" NVARCHAR2 (100) NULL,"GROUPSTAT19" NVARCHAR2 (100) NULL,"GROUPOFFSET19" NUMBER DEFAULT 0 NULL,"GROUPGROUPING19" NVARCHAR2 (10) NULL,"GROUPVARS19" NVARCHAR2 (1000) NULL,"GROUPNAME20" NVARCHAR2 (100) NULL,"GROUPSTAT20" NVARCHAR2 (100) NULL,"GROUPOFFSET20" NUMBER DEFAULT 0 NULL,"GROUPGROUPING20" NVARCHAR2 (10) NULL,"GROUPVARS20" NVARCHAR2 (1000) NULL,"GROUPNAME21" NVARCHAR2 (100) NULL,"GROUPSTAT21" NVARCHAR2 (100) NULL,"GROUPOFFSET21" NUMBER DEFAULT 0 NULL,"GROUPGROUPING21" NVARCHAR2 (10) NULL,"GROUPVARS21" NVARCHAR2 (1000) NULL,"GROUPNAME22" NVARCHAR2 (100) NULL,"GROUPSTAT22" NVARCHAR2 (100) NULL,"GROUPOFFSET22" NUMBER DEFAULT 0 NULL,"GROUPGROUPING22" NVARCHAR2 (10) NULL,"GROUPVARS22" NVARCHAR2 (1000) NULL,"GROUPNAME23" NVARCHAR2 (100) NULL,"GROUPSTAT23" NVARCHAR2 (100) NULL,"GROUPOFFSET23" NUMBER DEFAULT 0 NULL,"GROUPGROUPING23" NVARCHAR2 (10) NULL,"GROUPVARS23" NVARCHAR2 (1000) NULL,"GROUPNAME24" NVARCHAR2 (100) NULL,"GROUPSTAT24" NVARCHAR2 (100) NULL,"GROUPOFFSET24" NUMBER DEFAULT 0 NULL,"GROUPGROUPING24" NVARCHAR2 (10) NULL,"GROUPVARS24" NVARCHAR2 (1000) NULL,"GROUPNAME25" NVARCHAR2 (100) NULL,"GROUPSTAT25" NVARCHAR2 (100) NULL,"GROUPOFFSET25" NUMBER DEFAULT 0 NULL,"GROUPGROUPING25" NVARCHAR2 (10) NULL,"GROUPVARS25" NVARCHAR2 (1000) NULL,"GROUPNAME26" NVARCHAR2 (100) NULL,"GROUPSTAT26" NVARCHAR2 (100) NULL,"GROUPOFFSET26" NUMBER DEFAULT 0 NULL,"GROUPGROUPING26" NVARCHAR2 (10) NULL,"GROUPVARS26" NVARCHAR2 (1000) NULL,"GROUPNAME27" NVARCHAR2 (100) NULL,"GROUPSTAT27" NVARCHAR2 (100) NULL,"GROUPOFFSET27" NUMBER DEFAULT 0 NULL,"GROUPGROUPING27" NVARCHAR2 (10) NULL,"GROUPVARS27" NVARCHAR2 (1000) NULL,"GROUPNAME28" NVARCHAR2 (100) NULL,"GROUPSTAT28" NVARCHAR2 (100) NULL,"GROUPOFFSET28" NUMBER DEFAULT 0 NULL,"GROUPGROUPING28" NVARCHAR2 (10) NULL,"GROUPVARS28" NVARCHAR2 (1000) NULL,"GROUPNAME29" NVARCHAR2 (100) NULL,"GROUPSTAT29" NVARCHAR2 (100) NULL,"GROUPOFFSET29" NUMBER DEFAULT 0 NULL,"GROUPGROUPING29" NVARCHAR2 (10) NULL,"GROUPVARS29" NVARCHAR2 (1000) NULL,"GROUPNAME30" NVARCHAR2 (100) NULL,"GROUPSTAT30" NVARCHAR2 (100) NULL,"GROUPOFFSET30" NUMBER DEFAULT 0 NULL,"GROUPGROUPING30" NVARCHAR2 (10) NULL,"GROUPVARS30" NVARCHAR2 (1000) NULL,"GROUPNAME31" NVARCHAR2 (100) NULL,"GROUPSTAT31" NVARCHAR2 (100) NULL,"GROUPOFFSET31" NUMBER DEFAULT 0 NULL,"GROUPGROUPING31" NVARCHAR2 (10) NULL,"GROUPVARS31" NVARCHAR2 (1000) NULL,"GROUPNAME32" NVARCHAR2 (100) NULL,"GROUPSTAT32" NVARCHAR2 (100) NULL,"GROUPOFFSET32" NUMBER DEFAULT 0 NULL,"GROUPGROUPING32" NVARCHAR2 (10) NULL,"GROUPVARS32" NVARCHAR2 (1000) NULL,"GROUPNAME33" NVARCHAR2 (100) NULL,"GROUPSTAT33" NVARCHAR2 (100) NULL,"GROUPOFFSET33" NUMBER DEFAULT 0 NULL,"GROUPGROUPING33" NVARCHAR2 (10) NULL,"GROUPVARS33" NVARCHAR2 (1000) NULL,"GROUPNAME34" NVARCHAR2 (100) NULL,"GROUPSTAT34" NVARCHAR2 (100) NULL,"GROUPOFFSET34" NUMBER DEFAULT 0 NULL,"GROUPGROUPING34" NVARCHAR2 (10) NULL,"GROUPVARS34" NVARCHAR2 (1000) NULL,"GROUPNAME35" NVARCHAR2 (100) NULL,"GROUPSTAT35" NVARCHAR2 (100) NULL,"GROUPOFFSET35" NUMBER DEFAULT 0 NULL,"GROUPGROUPING35" NVARCHAR2 (10) NULL,"GROUPVARS35" NVARCHAR2 (1000) NULL,"GROUPNAME36" NVARCHAR2 (100) NULL,"GROUPSTAT36" NVARCHAR2 (100) NULL,"GROUPOFFSET36" NUMBER DEFAULT 0 NULL,"GROUPGROUPING36" NVARCHAR2 (10) NULL,"GROUPVARS36" NVARCHAR2 (1000) NULL,"GROUPNAME37" NVARCHAR2 (100) NULL,"GROUPSTAT37" NVARCHAR2 (100) NULL,"GROUPOFFSET37" NUMBER DEFAULT 0 NULL,"GROUPGROUPING37" NVARCHAR2 (10) NULL,"GROUPVARS37" NVARCHAR2 (1000) NULL,"GROUPNAME38" NVARCHAR2 (100) NULL,"GROUPSTAT38" NVARCHAR2 (100) NULL,"GROUPOFFSET38" NUMBER DEFAULT 0 NULL,"GROUPGROUPING38" NVARCHAR2 (10) NULL,"GROUPVARS38" NVARCHAR2 (1000) NULL,"GROUPNAME39" NVARCHAR2 (100) NULL,"GROUPSTAT39" NVARCHAR2 (100) NULL,"GROUPOFFSET39" NUMBER DEFAULT 0 NULL,"GROUPGROUPING39" NVARCHAR2 (10) NULL,"GROUPVARS39" NVARCHAR2 (1000) NULL,"GROUPNAME40" NVARCHAR2 (100) NULL,"GROUPSTAT40" NVARCHAR2 (100) NULL,"GROUPOFFSET40" NUMBER DEFAULT 0 NULL,"GROUPGROUPING40" NVARCHAR2 (10) NULL,"GROUPVARS40" NVARCHAR2 (1000) NULL,"GROUPNAME41" NVARCHAR2 (100) NULL,"GROUPSTAT41" NVARCHAR2 (100) NULL,"GROUPOFFSET41" NUMBER DEFAULT 0 NULL,"GROUPGROUPING41" NVARCHAR2 (10) NULL,"GROUPVARS41" NVARCHAR2 (1000) NULL,"GROUPNAME42" NVARCHAR2 (100) NULL,"GROUPSTAT42" NVARCHAR2 (100) NULL,"GROUPOFFSET42" NUMBER DEFAULT 0 NULL,"GROUPGROUPING42" NVARCHAR2 (10) NULL,"GROUPVARS42" NVARCHAR2 (1000) NULL,"GROUPNAME43" NVARCHAR2 (100) NULL,"GROUPSTAT43" NVARCHAR2 (100) NULL,"GROUPOFFSET43" NUMBER DEFAULT 0 NULL,"GROUPGROUPING43" NVARCHAR2 (10) NULL,"GROUPVARS43" NVARCHAR2 (1000) NULL,"GROUPNAME44" NVARCHAR2 (100) NULL,"GROUPSTAT44" NVARCHAR2 (100) NULL,"GROUPOFFSET44" NUMBER DEFAULT 0 NULL,"GROUPGROUPING44" NVARCHAR2 (10) NULL,"GROUPVARS44" NVARCHAR2 (1000) NULL,"GROUPNAME45" NVARCHAR2 (100) NULL,"GROUPSTAT45" NVARCHAR2 (100) NULL,"GROUPOFFSET45" NUMBER DEFAULT 0 NULL,"GROUPGROUPING45" NVARCHAR2 (10) NULL,"GROUPVARS45" NVARCHAR2 (1000) NULL,"GROUPNAME46" NVARCHAR2 (100) NULL,"GROUPSTAT46" NVARCHAR2 (100) NULL,"GROUPOFFSET46" NUMBER DEFAULT 0 NULL,"GROUPGROUPING46" NVARCHAR2 (10) NULL,"GROUPVARS46" NVARCHAR2 (1000) NULL,"GROUPNAME47" NVARCHAR2 (100) NULL,"GROUPSTAT47" NVARCHAR2 (100) NULL,"GROUPOFFSET47" NUMBER DEFAULT 0 NULL,"GROUPGROUPING47" NVARCHAR2 (10) NULL,"GROUPVARS47" NVARCHAR2 (1000) NULL,"GROUPNAME48" NVARCHAR2 (100) NULL,"GROUPSTAT48" NVARCHAR2 (100) NULL,"GROUPOFFSET48" NUMBER DEFAULT 0 NULL,"GROUPGROUPING48" NVARCHAR2 (10) NULL,"GROUPVARS48" NVARCHAR2 (1000) NULL,"GROUPNAME49" NVARCHAR2 (100) NULL,"GROUPSTAT49" NVARCHAR2 (100) NULL,"GROUPOFFSET49" NUMBER DEFAULT 0 NULL,"GROUPGROUPING49" NVARCHAR2 (10) NULL,"GROUPVARS49" NVARCHAR2 (1000) NULL,"GROUPNAME50" NVARCHAR2 (100) NULL,"GROUPSTAT50" NVARCHAR2 (100) NULL,"GROUPOFFSET50" NUMBER DEFAULT 0 NULL,"GROUPGROUPING50" NVARCHAR2 (10) NULL,"GROUPVARS50" NVARCHAR2 (1000) NULL,"GROUPNAME51" NVARCHAR2 (100) NULL,"GROUPSTAT51" NVARCHAR2 (100) NULL,"GROUPOFFSET51" NUMBER DEFAULT 0 NULL,"GROUPGROUPING51" NVARCHAR2 (10) NULL,"GROUPVARS51" NVARCHAR2 (1000) NULL,"GROUPNAME52" NVARCHAR2 (100) NULL,"GROUPSTAT52" NVARCHAR2 (100) NULL,"GROUPOFFSET52" NUMBER DEFAULT 0 NULL,"GROUPGROUPING52" NVARCHAR2 (10) NULL,"GROUPVARS52" NVARCHAR2 (1000) NULL,"GROUPNAME53" NVARCHAR2 (100) NULL,"GROUPSTAT53" NVARCHAR2 (100) NULL,"GROUPOFFSET53" NUMBER DEFAULT 0 NULL,"GROUPGROUPING53" NVARCHAR2 (10) NULL,"GROUPVARS53" NVARCHAR2 (1000) NULL,"GROUPNAME54" NVARCHAR2 (100) NULL,"GROUPSTAT54" NVARCHAR2 (100) NULL,"GROUPOFFSET54" NUMBER DEFAULT 0 NULL,"GROUPGROUPING54" NVARCHAR2 (10) NULL,"GROUPVARS54" NVARCHAR2 (1000) NULL,"GROUPNAME55" NVARCHAR2 (100) NULL,"GROUPSTAT55" NVARCHAR2 (100) NULL,"GROUPOFFSET55" NUMBER DEFAULT 0 NULL,"GROUPGROUPING55" NVARCHAR2 (10) NULL,"GROUPVARS55" NVARCHAR2 (1000) NULL,"GROUPNAME56" NVARCHAR2 (100) NULL,"GROUPSTAT56" NVARCHAR2 (100) NULL,"GROUPOFFSET56" NUMBER DEFAULT 0 NULL,"GROUPGROUPING56" NVARCHAR2 (10) NULL,"GROUPVARS56" NVARCHAR2 (1000) NULL,"GROUPNAME57" NVARCHAR2 (100) NULL,"GROUPSTAT57" NVARCHAR2 (100) NULL,"GROUPOFFSET57" NUMBER DEFAULT 0 NULL,"GROUPGROUPING57" NVARCHAR2 (10) NULL,"GROUPVARS57" NVARCHAR2 (1000) NULL,"GROUPNAME58" NVARCHAR2 (100) NULL,"GROUPSTAT58" NVARCHAR2 (100) NULL,"GROUPOFFSET58" NUMBER DEFAULT 0 NULL,"GROUPGROUPING58" NVARCHAR2 (10) NULL,"GROUPVARS58" NVARCHAR2 (1000) NULL,"GROUPNAME59" NVARCHAR2 (100) NULL,"GROUPSTAT59" NVARCHAR2 (100) NULL,"GROUPOFFSET59" NUMBER DEFAULT 0 NULL,"GROUPGROUPING59" NVARCHAR2 (10) NULL,"GROUPVARS59" NVARCHAR2 (1000) NULL,"GROUPNAME60" NVARCHAR2 (100) NULL,"GROUPSTAT60" NVARCHAR2 (100) NULL,"GROUPOFFSET60" NUMBER DEFAULT 0 NULL,"GROUPGROUPING60" NVARCHAR2 (10) NULL,"GROUPVARS60" NVARCHAR2 (1000) NULL)

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

CREATE TRIGGER "T_BARCHART" BEFORE INSERT ON "BARCHART" FOR EACH ROW BEGIN SELECT "A_BARCHART".NEXTVAL INTO :NEW."ID" FROM DUAL; END T_BARCHART;
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 6/5/2024 9:47 AM.
Last Modified on 6/13/2024 9:13 AM.
Last Modified by Scott Dorner.
Article has been viewed 438 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article