shark.script

A complete business intelligence platform that includes reporting, analysis (OLAP), dashboards, data

CREATE UNIQUE INDEX I1_GROUPUSERPROCLEVELPARTICIPANT ON GROUPUSERPROCLEVELPARTICIPANT(PARTICIPANTOID,USEROID)
CREATE TABLE LOCKTABLE(ENGINENAME VARCHAR(100) NOT NULL,ID VARCHAR(100) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_LOCKTABLE ON LOCKTABLE(ID)
CREATE UNIQUE INDEX I2_LOCKTABLE ON LOCKTABLE(ID,ENGINENAME)
CREATE TABLE USERTABLE(USERID VARCHAR(100) NOT NULL,FIRSTNAME VARCHAR(50),LASTNAME VARCHAR(50),PASSWD VARCHAR(50) NOT NULL,EMAIL VARCHAR(254),OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_USERTABLE ON USERTABLE(USERID)
CREATE TABLE GROUPTABLE(GROUPID VARCHAR(100) NOT NULL,DESCRIPTION VARCHAR(254),OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_GROUPTABLE ON GROUPTABLE(GROUPID)
CREATE TABLE USERGROUPTABLE(USERID DECIMAL(19) NOT NULL,GROUPID DECIMAL(19) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_USERGROUPTABLE ON USERGROUPTABLE(USERID,GROUPID)
CREATE TABLE GROUPGROUPTABLE(SUB_GID DECIMAL(19) NOT NULL,GROUPID DECIMAL(19) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_GROUPGROUPTABLE ON GROUPGROUPTABLE(SUB_GID,GROUPID)
CREATE INDEX I2_GROUPGROUPTABLE ON GROUPGROUPTABLE(GROUPID)
CREATE TABLE COUNTERS(NAME VARCHAR(100) NOT NULL,THE_NUMBER DECIMAL(19) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_COUNTERS ON COUNTERS(NAME)
CREATE TABLE PROCESSSTATEEVENTAUDITS(KEYVALUE VARCHAR(30) NOT NULL,NAME VARCHAR(50) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_PROCESSSTATEEVENTAUDITS ON PROCESSSTATEEVENTAUDITS(KEYVALUE)
CREATE UNIQUE INDEX I2_PROCESSSTATEEVENTAUDITS ON PROCESSSTATEEVENTAUDITS(NAME)
CREATE TABLE ACTIVITYSTATEEVENTAUDITS(KEYVALUE VARCHAR(30) NOT NULL,NAME VARCHAR(50) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_ACTIVITYSTATEEVENTAUDITS ON ACTIVITYSTATEEVENTAUDITS(KEYVALUE)
CREATE UNIQUE INDEX I2_ACTIVITYSTATEEVENTAUDITS ON ACTIVITYSTATEEVENTAUDITS(NAME)
CREATE TABLE CREATEPROCESSEVENTAUDITS(UTCTIME VARCHAR(254) NOT NULL,THETYPE DECIMAL(19) NOT NULL,PROCESSID VARCHAR(100) NOT NULL,PROCESSNAME VARCHAR(254),PROCESSDEFINITIONNAME VARCHAR(200) NOT NULL,PROCESSDEFINITIONVERSION VARCHAR(20) NOT NULL,PROCESSDEFINITIONID VARCHAR(90) NOT NULL,PACKAGEID VARCHAR(90) NOT NULL,PACTIVITYID VARCHAR(100),PPROCESSID VARCHAR(100),PPROCESSNAME VARCHAR(254),PPROCESSDEFINITIONNAME VARCHAR(200),PPROCESSDEFINITIONVERSION VARCHAR(20),PACTIVITYDEFINITIONID VARCHAR(90),PACTIVITYSETDEFINITIONID VARCHAR(90),PPROCESSDEFINITIONID VARCHAR(90),PPACKAGEID VARCHAR(90),CNT DECIMAL(19) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_CREATEPROCESSEVENTAUDITS ON CREATEPROCESSEVENTAUDITS(CNT)
CREATE TABLE STATEEVENTAUDITS(UTCTIME VARCHAR(254) NOT NULL,THETYPE DECIMAL(19) NOT NULL,ACTIVITYID VARCHAR(100),ACTIVITYNAME VARCHAR(254),PROCESSID VARCHAR(100) NOT NULL,PROCESSNAME VARCHAR(254),PROCESSDEFINITIONNAME VARCHAR(200) NOT NULL,PROCESSDEFINITIONVERSION VARCHAR(20) NOT NULL,ACTIVITYDEFINITIONID VARCHAR(90),ACTIVITYSETDEFINITIONID VARCHAR(90),PROCESSDEFINITIONID VARCHAR(90) NOT NULL,PACKAGEID VARCHAR(90) NOT NULL,OLDPROCESSSTATE DECIMAL(19),NEWPROCESSSTATE DECIMAL(19),OLDACTIVITYSTATE DECIMAL(19),NEWACTIVITYSTATE DECIMAL(19),CNT DECIMAL(19) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_STATEEVENTAUDITS ON STATEEVENTAUDITS(CNT)
CREATE TABLE DATAEVENTAUDITS(UTCTIME VARCHAR(254) NOT NULL,THETYPE DECIMAL(19) NOT NULL,ACTIVITYID VARCHAR(100),ACTIVITYNAME VARCHAR(254),PROCESSID VARCHAR(100) NOT NULL,PROCESSNAME VARCHAR(254),PROCESSDEFINITIONNAME VARCHAR(200) NOT NULL,PROCESSDEFINITIONVERSION VARCHAR(20) NOT NULL,ACTIVITYDEFINITIONID VARCHAR(90),ACTIVITYSETDEFINITIONID VARCHAR(90),PROCESSDEFINITIONID VARCHAR(90) NOT NULL,PACKAGEID VARCHAR(90) NOT NULL,CNT DECIMAL(19) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_DATAEVENTAUDITS ON DATAEVENTAUDITS(CNT)
CREATE TABLE ASSIGNMENTEVENTAUDITS(UTCTIME VARCHAR(254) NOT NULL,THETYPE DECIMAL(19) NOT NULL,ACTIVITYID VARCHAR(100) NOT NULL,ACTIVITYNAME VARCHAR(254),PROCESSID VARCHAR(100) NOT NULL,PROCESSNAME VARCHAR(254),PROCESSDEFINITIONNAME VARCHAR(200) NOT NULL,PROCESSDEFINITIONVERSION VARCHAR(20) NOT NULL,ACTIVITYDEFINITIONID VARCHAR(90) NOT NULL,ACTIVITYSETDEFINITIONID VARCHAR(90),PROCESSDEFINITIONID VARCHAR(90) NOT NULL,PACKAGEID VARCHAR(90) NOT NULL,OLDRESOURCEUSERNAME VARCHAR(100),OLDRESOURCENAME VARCHAR(100),NEWRESOURCEUSERNAME VARCHAR(100) NOT NULL,NEWRESOURCENAME VARCHAR(100),ISACCEPTED INTEGER NOT NULL,CNT DECIMAL(19) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_ASSIGNMENTEVENTAUDITS ON ASSIGNMENTEVENTAUDITS(CNT)
CREATE TABLE OLDEVENTAUDITDATA(DATAEVENTAUDIT DECIMAL(19) NOT NULL,VARIABLEDEFINITIONID VARCHAR(100) NOT NULL,VARIABLETYPE INTEGER NOT NULL,VARIABLEVALUE LONGVARBINARY,VARIABLEVALUEVCHAR VARCHAR(4000),VARIABLEVALUEDBL FLOAT,VARIABLEVALUELONG BIGINT,VARIABLEVALUEDATE TIMESTAMP,VARIABLEVALUEBOOL INTEGER,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_OLDEVENTAUDITDATA ON OLDEVENTAUDITDATA(DATAEVENTAUDIT,VARIABLEDEFINITIONID)
CREATE TABLE OLDEVENTAUDITDATAWOB(DATAEVENTAUDIT DECIMAL(19) NOT NULL,VARIABLEDEFINITIONID VARCHAR(100) NOT NULL,VARIABLETYPE INTEGER NOT NULL,VARIABLEVALUEVCHAR VARCHAR(4000),VARIABLEVALUEDBL FLOAT,VARIABLEVALUELONG BIGINT,VARIABLEVALUEDATE TIMESTAMP,VARIABLEVALUEBOOL INTEGER,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_OLDEVENTAUDITDATAWOB ON OLDEVENTAUDITDATAWOB(DATAEVENTAUDIT,VARIABLEDEFINITIONID)
CREATE TABLE OLDEVENTAUDITDATABLOBS(OLDEVENTAUDITDATAWOB DECIMAL(19) NOT NULL,VARIABLEVALUE LONGVARBINARY,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_OLDEVENTAUDITDATABLOBS ON OLDEVENTAUDITDATABLOBS(OLDEVENTAUDITDATAWOB)
CREATE TABLE NEWEVENTAUDITDATA(DATAEVENTAUDIT DECIMAL(19) NOT NULL,VARIABLEDEFINITIONID VARCHAR(100) NOT NULL,VARIABLETYPE INTEGER NOT NULL,VARIABLEVALUE LONGVARBINARY,VARIABLEVALUEVCHAR VARCHAR(4000),VARIABLEVALUEDBL FLOAT,VARIABLEVALUELONG BIGINT,VARIABLEVALUEDATE TIMESTAMP,VARIABLEVALUEBOOL INTEGER,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_NEWEVENTAUDITDATA ON NEWEVENTAUDITDATA(DATAEVENTAUDIT,VARIABLEDEFINITIONID)
CREATE TABLE NEWEVENTAUDITDATAWOB(DATAEVENTAUDIT DECIMAL(19) NOT NULL,VARIABLEDEFINITIONID VARCHAR(100) NOT NULL,VARIABLETYPE INTEGER NOT NULL,VARIABLEVALUEVCHAR VARCHAR(4000),VARIABLEVALUEDBL FLOAT,VARIABLEVALUELONG BIGINT,VARIABLEVALUEDATE TIMESTAMP,VARIABLEVALUEBOOL INTEGER,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_NEWEVENTAUDITDATAWOB ON NEWEVENTAUDITDATAWOB(DATAEVENTAUDIT,VARIABLEDEFINITIONID)
CREATE TABLE NEWEVENTAUDITDATABLOBS(NEWEVENTAUDITDATAWOB DECIMAL(19) NOT NULL,VARIABLEVALUE LONGVARBINARY,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_NEWEVENTAUDITDATABLOBS ON NEWEVENTAUDITDATABLOBS(NEWEVENTAUDITDATAWOB)
CREATE TABLE EVENTTYPES(KEYVALUE VARCHAR(30) NOT NULL,NAME VARCHAR(50) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_EVENTTYPES ON EVENTTYPES(KEYVALUE)
CREATE UNIQUE INDEX I2_EVENTTYPES ON EVENTTYPES(NAME)
CREATE TABLE XPDLS(XPDLID VARCHAR(90) NOT NULL,XPDLVERSION VARCHAR(20) NOT NULL,XPDLCLASSVERSION BIGINT NOT NULL,XPDLUPLOADTIME TIMESTAMP NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_XPDLS ON XPDLS(XPDLID,XPDLVERSION)
CREATE TABLE XPDLDATA(XPDLCONTENT LONGVARBINARY NOT NULL,XPDLCLASSCONTENT LONGVARBINARY NOT NULL,XPDL DECIMAL(19) NOT NULL,CNT DECIMAL(19) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_XPDLDATA ON XPDLDATA(CNT)
CREATE UNIQUE INDEX I2_XPDLDATA ON XPDLDATA(XPDL)
CREATE TABLE XPDLHISTORY(XPDLID VARCHAR(90) NOT NULL,XPDLVERSION VARCHAR(20) NOT NULL,XPDLCLASSVERSION BIGINT NOT NULL,XPDLUPLOADTIME TIMESTAMP NOT NULL,XPDLHISTORYUPLOADTIME TIMESTAMP NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_XPDLHISTORY ON XPDLHISTORY(XPDLID,XPDLVERSION)
CREATE TABLE XPDLHISTORYDATA(XPDLCONTENT LONGVARBINARY NOT NULL,XPDLCLASSCONTENT LONGVARBINARY NOT NULL,XPDLHISTORY DECIMAL(19) NOT NULL,CNT DECIMAL(19) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_XPDLHISTORYDATA ON XPDLHISTORYDATA(CNT)
CREATE TABLE XPDLREFERENCES(REFERREDXPDLID VARCHAR(90) NOT NULL,REFERRINGXPDL DECIMAL(19) NOT NULL,REFERREDXPDLNUMBER INTEGER NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_XPDLREFERENCES ON XPDLREFERENCES(REFERREDXPDLID,REFERRINGXPDL)
CREATE TABLE NEXTXPDLVERSIONS(XPDLID VARCHAR(90) NOT NULL,NEXTVERSION VARCHAR(20) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_NEXTXPDLVERSIONS ON NEXTXPDLVERSIONS(XPDLID,NEXTVERSION)
CREATE TABLE OBJECTID("NEXT" DECIMAL(19) NOT NULL PRIMARY KEY)
CREATE USER SA PASSWORD "" ADMIN
INSERT INTO RESOURCESTABLE VALUES('jspUser2',NULL,1000038,0)
INSERT INTO RESOURCESTABLE VALUES('admin',NULL,1000204,0)
INSERT INTO PROCESSSTATES VALUES('open.running','open.running',1000000,0)
INSERT INTO PROCESSSTATES VALUES('open.not_running.not_started','open.not_running.not_started',1000002,0)
INSERT INTO PROCESSSTATES VALUES('open.not_running.suspended','open.not_running.suspended',1000004,0)
INSERT INTO PROCESSSTATES VALUES('closed.completed','closed.completed',1000006,0)
INSERT INTO PROCESSSTATES VALUES('closed.terminated','closed.terminated',1000008,0)
INSERT INTO PROCESSSTATES VALUES('closed.aborted','closed.aborted',1000010,0)
INSERT INTO ACTIVITYSTATES VALUES('open.running','open.running',1000001,0)
INSERT INTO ACTIVITYSTATES VALUES('open.not_running.not_started','open.not_running.not_started',1000003,0)
INSERT INTO ACTIVITYSTATES VALUES('open.not_running.suspended','open.not_running.suspended',1000005,0)
INSERT INTO ACTIVITYSTATES VALUES('closed.completed','closed.completed',1000007,0)
INSERT INTO ACTIVITYSTATES VALUES('closed.terminated','closed.terminated',1000009,0)
INSERT INTO ACTIVITYSTATES VALUES('closed.aborted','closed.aborted',1000011,0)
INSERT INTO USERTABLE VALUES('jspUser2','John','JSPUser','5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8','[e-mail]',1000036,0)
INSERT INTO USERTABLE VALUES('admin','Default User','','73d7665487f88c55adb98e90a84f579728032f46','',1000202,0)
INSERT INTO GROUPTABLE VALUES('idle','JSP Group',1000035,0)
INSERT INTO GROUPTABLE VALUES('SharkGroup','',1000201,0)
INSERT INTO USERGROUPTABLE VALUES(1000036,1000035,1000037,0)
INSERT INTO USERGROUPTABLE VALUES(1000202,1000201,1000203,0)
INSERT INTO PROCESSSTATEEVENTAUDITS VALUES('open.running','open.running',1000012,0)
INSERT INTO PROCESSSTATEEVENTAUDITS VALUES('open.not_running.not_started','open.not_running.not_started',1000014,0)
INSERT INTO PROCESSSTATEEVENTAUDITS VALUES('open.not_running.suspended','open.not_running.suspended',1000016,0)
INSERT INTO PROCESSSTATEEVENTAUDITS VALUES('closed.completed','closed.completed',1000018,0)
INSERT INTO PROCESSSTATEEVENTAUDITS VALUES('closed.terminated','closed.terminated',1000020,0)
INSERT INTO PROCESSSTATEEVENTAUDITS VALUES('closed.aborted','closed.aborted',1000022,0)
INSERT INTO ACTIVITYSTATEEVENTAUDITS VALUES('open.running','open.running',1000013,0)
INSERT INTO ACTIVITYSTATEEVENTAUDITS VALUES('open.not_running.not_started','open.not_running.not_started',1000015,0)
INSERT INTO ACTIVITYSTATEEVENTAUDITS VALUES('open.not_running.suspended','open.not_running.suspended',1000017,0)
INSERT INTO ACTIVITYSTATEEVENTAUDITS VALUES('closed.completed','closed.completed',1000019,0)
INSERT INTO ACTIVITYSTATEEVENTAUDITS VALUES('closed.terminated','closed.terminated',1000021,0)
INSERT INTO ACTIVITYSTATEEVENTAUDITS VALUES('closed.aborted','closed.aborted',1000023,0)
INSERT INTO EVENTTYPES VALUES('packageLoaded','packageLoaded',1000024,0)
INSERT INTO EVENTTYPES VALUES('packageUnloaded','packageUnloaded',1000025,0)
INSERT INTO EVENTTYPES VALUES('packageUpdated','packageUpdated',1000026,0)
INSERT INTO EVENTTYPES VALUES('processCreated','processCreated',1000027,0)
INSERT INTO EVENTTYPES VALUES('processStateChanged','processStateChanged',1000028,0)
INSERT INTO EVENTTYPES VALUES('processContextChanged','processContextChanged',1000029,0)
INSERT INTO EVENTTYPES VALUES('activityStateChanged','activityStateChanged',1000030,0)
INSERT INTO EVENTTYPES VALUES('activityContextChanged','activityContextChanged',1000031,0)
INSERT INTO EVENTTYPES VALUES('activityResultChanged','activityResultChanged',1000032,0)
INSERT INTO EVENTTYPES VALUES('activityAssignmentChanged','activityAssignmentChanged',1000033,0)
INSERT INTO OBJECTID VALUES(1000400)