shark.script

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

CREATE TABLE PROCESSDEFINITIONS(NAME VARCHAR(200) NOT NULL,PACKAGEID VARCHAR(90) NOT NULL,PROCESSDEFINITIONID VARCHAR(90) NOT NULL,PROCESSDEFINITIONCREATED BIGINT NOT NULL,PROCESSDEFINITIONVERSION VARCHAR(20) NOT NULL,STATE INTEGER NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_PROCESSDEFINITIONS ON PROCESSDEFINITIONS(NAME)
CREATE TABLE PROCESSES(ID VARCHAR(100) NOT NULL,PROCESSDEFINITION DECIMAL(19) NOT NULL,PDEFNAME VARCHAR(200) NOT NULL,ACTIVITYREQUESTERID VARCHAR(100),ACTIVITYREQUESTERPROCESSID VARCHAR(100),RESOURCEREQUESTERID VARCHAR(100) NOT NULL,EXTERNALREQUESTERCLASSNAME VARCHAR(254),STATE DECIMAL(19) NOT NULL,PRIORITY INTEGER,NAME VARCHAR(254),CREATED BIGINT NOT NULL,STARTED BIGINT,LASTSTATETIME BIGINT NOT NULL,LIMITTIME BIGINT NOT NULL,DESCRIPTION VARCHAR(254),OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_PROCESSES ON PROCESSES(ID)
CREATE INDEX I2_PROCESSES ON PROCESSES(PROCESSDEFINITION)
CREATE INDEX I3_PROCESSES ON PROCESSES(STATE)
CREATE INDEX I4_PROCESSES ON PROCESSES(ACTIVITYREQUESTERID)
CREATE INDEX I5_PROCESSES ON PROCESSES(RESOURCEREQUESTERID)
CREATE TABLE PROCESSREQUESTERS(ID VARCHAR(100) NOT NULL,ACTIVITYREQUESTER DECIMAL(19),RESOURCEREQUESTER DECIMAL(19),OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_PROCESSREQUESTERS ON PROCESSREQUESTERS(ID)
CREATE INDEX I2_PROCESSREQUESTERS ON PROCESSREQUESTERS(ACTIVITYREQUESTER)
CREATE INDEX I3_PROCESSREQUESTERS ON PROCESSREQUESTERS(RESOURCEREQUESTER)
CREATE TABLE ACTIVITIES(ID VARCHAR(100) NOT NULL,ACTIVITYSETDEFINITIONID VARCHAR(90),ACTIVITYDEFINITIONID VARCHAR(90) NOT NULL,PROCESS DECIMAL(19) NOT NULL,THERESOURCE DECIMAL(19),PDEFNAME VARCHAR(200) NOT NULL,PROCESSID VARCHAR(200) NOT NULL,RESOURCEID VARCHAR(100),STATE DECIMAL(19) NOT NULL,BLOCKACTIVITYID VARCHAR(100),PERFORMER VARCHAR(100),ISPERFORMERASYNCHRONOUS INTEGER,PRIORITY INTEGER,NAME VARCHAR(254),ACTIVATED BIGINT NOT NULL,ACCEPTED BIGINT,LASTSTATETIME BIGINT NOT NULL,LIMITTIME BIGINT NOT NULL,DESCRIPTION VARCHAR(254),OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_ACTIVITIES ON ACTIVITIES(ID)
CREATE INDEX I2_ACTIVITIES ON ACTIVITIES(PROCESS,ACTIVITYSETDEFINITIONID,ACTIVITYDEFINITIONID)
CREATE INDEX I3_ACTIVITIES ON ACTIVITIES(PROCESS,STATE)
CREATE TABLE RESOURCESTABLE(USERNAME VARCHAR(100) NOT NULL,NAME VARCHAR(100),OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_RESOURCESTABLE ON RESOURCESTABLE(USERNAME)
CREATE TABLE ASSIGNMENTSTABLE(ACTIVITY DECIMAL(19) NOT NULL,THERESOURCE DECIMAL(19) NOT NULL,ACTIVITYID VARCHAR(100) NOT NULL,ACTIVITYPROCESSID VARCHAR(100) NOT NULL,ACTIVITYPROCESSDEFNAME VARCHAR(200) NOT NULL,RESOURCEID VARCHAR(100) NOT NULL,ISACCEPTED INTEGER NOT NULL,ISVALID INTEGER NOT NULL,CNT DECIMAL(19) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_ASSIGNMENTSTABLE ON ASSIGNMENTSTABLE(CNT)
CREATE UNIQUE INDEX I2_ASSIGNMENTSTABLE ON ASSIGNMENTSTABLE(ACTIVITY,THERESOURCE)
CREATE INDEX I3_ASSIGNMENTSTABLE ON ASSIGNMENTSTABLE(THERESOURCE,ISVALID)
CREATE INDEX I4_ASSIGNMENTSTABLE ON ASSIGNMENTSTABLE(ACTIVITYID)
CREATE INDEX I5_ASSIGNMENTSTABLE ON ASSIGNMENTSTABLE(RESOURCEID)
CREATE TABLE PROCESSDATA(PROCESS DECIMAL(19) NOT NULL,VARIABLEDEFINITIONID VARCHAR(100) NOT NULL,VARIABLETYPE INTEGER NOT NULL,VARIABLEVALUE LONGVARBINARY,VARIABLEVALUEVCHAR VARCHAR(4000),VARIABLEVALUEDBL DOUBLE,VARIABLEVALUELONG BIGINT,VARIABLEVALUEDATE TIMESTAMP,VARIABLEVALUEBOOL INTEGER,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_PROCESSDATA ON PROCESSDATA(PROCESS,VARIABLEDEFINITIONID)
CREATE TABLE PROCESSDATAWOB(PROCESS DECIMAL(19) NOT NULL,VARIABLEDEFINITIONID VARCHAR(100) NOT NULL,VARIABLETYPE INTEGER NOT NULL,VARIABLEVALUEVCHAR VARCHAR(4000),VARIABLEVALUEDBL DOUBLE,VARIABLEVALUELONG BIGINT,VARIABLEVALUEDATE TIMESTAMP,VARIABLEVALUEBOOL INTEGER,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_PROCESSDATAWOB ON PROCESSDATAWOB(PROCESS,VARIABLEDEFINITIONID)
CREATE TABLE PROCESSDATABLOBS(PROCESSDATAWOB DECIMAL(19) NOT NULL,VARIABLEVALUE LONGVARBINARY,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_PROCESSDATABLOBS ON PROCESSDATABLOBS(PROCESSDATAWOB)
CREATE TABLE ACTIVITYDATA(ACTIVITY DECIMAL(19) NOT NULL,VARIABLEDEFINITIONID VARCHAR(100) NOT NULL,VARIABLETYPE INTEGER NOT NULL,VARIABLEVALUE LONGVARBINARY,VARIABLEVALUEVCHAR VARCHAR(4000),VARIABLEVALUEDBL DOUBLE,VARIABLEVALUELONG BIGINT,VARIABLEVALUEDATE TIMESTAMP,VARIABLEVALUEBOOL INTEGER,ISRESULT INTEGER NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_ACTIVITYDATA ON ACTIVITYDATA(ACTIVITY,VARIABLEDEFINITIONID)
CREATE TABLE ACTIVITYDATAWOB(ACTIVITY DECIMAL(19) NOT NULL,VARIABLEDEFINITIONID VARCHAR(100) NOT NULL,VARIABLETYPE INTEGER NOT NULL,VARIABLEVALUEVCHAR VARCHAR(4000),VARIABLEVALUEDBL DOUBLE,VARIABLEVALUELONG BIGINT,VARIABLEVALUEDATE TIMESTAMP,VARIABLEVALUEBOOL INTEGER,ISRESULT INTEGER NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_ACTIVITYDATAWOB ON ACTIVITYDATAWOB(ACTIVITY,VARIABLEDEFINITIONID)
CREATE TABLE ACTIVITYDATABLOBS(ACTIVITYDATAWOB DECIMAL(19) NOT NULL,VARIABLEVALUE LONGVARBINARY,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_ACTIVITYDATABLOBS ON ACTIVITYDATABLOBS(ACTIVITYDATAWOB)
CREATE TABLE ANDJOINTABLE(PROCESS DECIMAL(19) NOT NULL,ACTIVITYSETDEFINITIONID VARCHAR(90),ACTIVITYDEFINITIONID VARCHAR(90) NOT NULL,ACTIVITY DECIMAL(19) NOT NULL,CNT DECIMAL(19) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_ANDJOINTABLE ON ANDJOINTABLE(CNT)
CREATE INDEX I2_ANDJOINTABLE ON ANDJOINTABLE(PROCESS,ACTIVITYSETDEFINITIONID,ACTIVITYDEFINITIONID)
CREATE INDEX I3_ANDJOINTABLE ON ANDJOINTABLE(ACTIVITY)
CREATE TABLE DEADLINES(PROCESS DECIMAL(19) NOT NULL,ACTIVITY DECIMAL(19) NOT NULL,CNT DECIMAL(19) NOT NULL,TIMELIMIT BIGINT NOT NULL,EXCEPTIONNAME VARCHAR(100) NOT NULL,ISSYNCHRONOUS INTEGER NOT NULL,ISEXECUTED INTEGER NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_DEADLINES ON DEADLINES(CNT)
CREATE INDEX I2_DEADLINES ON DEADLINES(PROCESS,TIMELIMIT)
CREATE INDEX I3_DEADLINES ON DEADLINES(ACTIVITY,TIMELIMIT)
CREATE TABLE PROCESSSTATES(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_PROCESSSTATES ON PROCESSSTATES(KEYVALUE)
CREATE UNIQUE INDEX I2_PROCESSSTATES ON PROCESSSTATES(NAME)
CREATE TABLE ACTIVITYSTATES(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_ACTIVITYSTATES ON ACTIVITYSTATES(KEYVALUE)
CREATE UNIQUE INDEX I2_ACTIVITYSTATES ON ACTIVITYSTATES(NAME)
CREATE TABLE XPDLAPPLICATIONPACKAGE(PACKAGE_ID VARCHAR(90) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_XPDLAPPLICATIONPACKAGE ON XPDLAPPLICATIONPACKAGE(PACKAGE_ID)
CREATE TABLE XPDLAPPLICATIONPROCESS(PROCESS_ID VARCHAR(90) NOT NULL,PACKAGEOID DECIMAL(19) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_XPDLAPPLICATIONPROCESS ON XPDLAPPLICATIONPROCESS(PROCESS_ID,PACKAGEOID)
CREATE TABLE PACKLEVELXPDLAPP(APPLICATION_ID VARCHAR(90) NOT NULL,PACKAGEOID DECIMAL(19) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_PACKLEVELXPDLAPP ON PACKLEVELXPDLAPP(APPLICATION_ID,PACKAGEOID)
CREATE TABLE PROCLEVELXPDLAPP(APPLICATION_ID VARCHAR(90) NOT NULL,PROCESSOID DECIMAL(19) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_PROCLEVELXPDLAPP ON PROCLEVELXPDLAPP(APPLICATION_ID,PROCESSOID)
CREATE TABLE TOOLAGENTUSER(USERNAME VARCHAR(100) NOT NULL,PWD VARCHAR(100),OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_TOOLAGENTUSER ON TOOLAGENTUSER(USERNAME)
CREATE TABLE TOOLAGENTAPP(TOOL_AGENT_NAME VARCHAR(250) NOT NULL,APP_NAME VARCHAR(90) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_TOOLAGENTAPP ON TOOLAGENTAPP(TOOL_AGENT_NAME,APP_NAME)
CREATE TABLE TOOLAGENTAPPDETAIL(APP_MODE DECIMAL(10) NOT NULL,TOOLAGENT_APPOID DECIMAL(19) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_TOOLAGENTAPPDETAIL ON TOOLAGENTAPPDETAIL(APP_MODE,TOOLAGENT_APPOID)
CREATE TABLE TOOLAGENTAPPUSER(TOOLAGENT_APPOID DECIMAL(19) NOT NULL,USEROID DECIMAL(19) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_TOOLAGENTAPPUSER ON TOOLAGENTAPPUSER(TOOLAGENT_APPOID,USEROID)
CREATE TABLE TOOLAGENTAPPDETAILUSER(TOOLAGENT_APPOID DECIMAL(19) NOT NULL,USEROID DECIMAL(19) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_TOOLAGENTAPPDETAILUSER ON TOOLAGENTAPPDETAILUSER(TOOLAGENT_APPOID,USEROID)
CREATE TABLE PACKLEVELXPDLAPPTOOLAGENTAPP(XPDL_APPOID DECIMAL(19) NOT NULL,TOOLAGENTOID DECIMAL(19) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_PACKLEVELXPDLAPPTOOLAGENTAPP ON PACKLEVELXPDLAPPTOOLAGENTAPP(XPDL_APPOID,TOOLAGENTOID)
CREATE TABLE PACKLEVELXPDLAPPTAAPPDETAIL(XPDL_APPOID DECIMAL(19) NOT NULL,TOOLAGENTOID DECIMAL(19) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_PACKLEVELXPDLAPPTAAPPDETAIL ON PACKLEVELXPDLAPPTAAPPDETAIL(XPDL_APPOID,TOOLAGENTOID)
CREATE TABLE PACKLEVELXPDLAPPTAAPPUSER(XPDL_APPOID DECIMAL(19) NOT NULL,TOOLAGENTOID DECIMAL(19) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_PACKLEVELXPDLAPPTAAPPUSER ON PACKLEVELXPDLAPPTAAPPUSER(XPDL_APPOID,TOOLAGENTOID)
CREATE TABLE PACKLEVELXPDLAPPTAAPPDETAILUSR(XPDL_APPOID DECIMAL(19) NOT NULL,TOOLAGENTOID DECIMAL(19) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_PACKLEVELXPDLAPPTAAPPDETAILUSR ON PACKLEVELXPDLAPPTAAPPDETAILUSR(XPDL_APPOID,TOOLAGENTOID)
CREATE TABLE PROCLEVELXPDLAPPTOOLAGENTAPP(XPDL_APPOID DECIMAL(19) NOT NULL,TOOLAGENTOID DECIMAL(19) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_PROCLEVELXPDLAPPTOOLAGENTAPP ON PROCLEVELXPDLAPPTOOLAGENTAPP(XPDL_APPOID,TOOLAGENTOID)
CREATE TABLE PROCLEVELXPDLAPPTAAPPDETAIL(XPDL_APPOID DECIMAL(19) NOT NULL,TOOLAGENTOID DECIMAL(19) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_PROCLEVELXPDLAPPTAAPPDETAIL ON PROCLEVELXPDLAPPTAAPPDETAIL(XPDL_APPOID,TOOLAGENTOID)
CREATE TABLE PROCLEVELXPDLAPPTAAPPUSER(XPDL_APPOID DECIMAL(19) NOT NULL,TOOLAGENTOID DECIMAL(19) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_PROCLEVELXPDLAPPTAAPPUSER ON PROCLEVELXPDLAPPTAAPPUSER(XPDL_APPOID,TOOLAGENTOID)
CREATE TABLE PROCLEVELXPDLAPPTAAPPDETAILUSR(XPDL_APPOID DECIMAL(19) NOT NULL,TOOLAGENTOID DECIMAL(19) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_PROCLEVELXPDLAPPTAAPPDETAILUSR ON PROCLEVELXPDLAPPTAAPPDETAILUSR(XPDL_APPOID,TOOLAGENTOID)
CREATE TABLE XPDLPARTICIPANTPACKAGE(PACKAGE_ID VARCHAR(90) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_XPDLPARTICIPANTPACKAGE ON XPDLPARTICIPANTPACKAGE(PACKAGE_ID)
CREATE TABLE PROCLEVELPARTICIPANT(PARTICIPANT_ID VARCHAR(90) NOT NULL,PROCESSOID DECIMAL(19) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_PROCLEVELPARTICIPANT ON PROCLEVELPARTICIPANT(PARTICIPANT_ID,PROCESSOID)
CREATE TABLE PACKLEVELPARTICIPANT(PARTICIPANT_ID VARCHAR(90) NOT NULL,PACKAGEOID DECIMAL(19) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_PACKLEVELPARTICIPANT ON PACKLEVELPARTICIPANT(PARTICIPANT_ID,PACKAGEOID)
CREATE TABLE XPDLPARTICIPANTPROCESS(PROCESS_ID VARCHAR(90) NOT NULL,PACKAGEOID DECIMAL(19) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_XPDLPARTICIPANTPROCESS ON XPDLPARTICIPANTPROCESS(PROCESS_ID,PACKAGEOID)
CREATE TABLE NORMALUSER(USERNAME VARCHAR(100) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_NORMALUSER ON NORMALUSER(USERNAME)
CREATE TABLE GROUPUSER(USERNAME VARCHAR(100) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_GROUPUSER ON GROUPUSER(USERNAME)
CREATE TABLE USERPROCLEVELPARTICIPANT(PARTICIPANTOID DECIMAL(19) NOT NULL,USEROID DECIMAL(19) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_USERPROCLEVELPARTICIPANT ON USERPROCLEVELPARTICIPANT(PARTICIPANTOID,USEROID)
CREATE TABLE USERPACKLEVELPARTICIPANT(PARTICIPANTOID DECIMAL(19) NOT NULL,USEROID DECIMAL(19) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_USERPACKLEVELPARTICIPANT ON USERPACKLEVELPARTICIPANT(PARTICIPANTOID,USEROID)
CREATE TABLE GROUPUSERPACKLEVELPARTICIPANT(PARTICIPANTOID DECIMAL(19) NOT NULL,USEROID DECIMAL(19) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)
CREATE UNIQUE INDEX I1_GROUPUSERPACKLEVELPARTICIPANT ON GROUPUSERPACKLEVELPARTICIPANT(PARTICIPANTOID,USEROID)
CREATE TABLE GROUPUSERPROCLEVELPARTICIPANT(PARTICIPANTOID DECIMAL(19) NOT NULL,USEROID DECIMAL(19) NOT NULL,OID DECIMAL(19) NOT NULL PRIMARY KEY,VERSION INTEGER NOT NULL)