--<ScriptOptions statementTerminator=";"/>

ALTER TABLE JBPM.ATTACHMENT DROP CONSTRAINT FK_7NDPFA311I50BQ7HY18Q05VA3;

ALTER TABLE JBPM.ATTACHMENT DROP CONSTRAINT FK_HQUPX569KRP0F0SGU9KH87513;

ALTER TABLE JBPM.BOOLEANEXPRESSION DROP CONSTRAINT FK_394NF2QOC0K9OK6OMGD6JTPSO;

ALTER TABLE JBPM.CORRELATIONPROPERTYINFO DROP CONSTRAINT FK_HRMX1M882CEJWJ9C04IXH50I4;

ALTER TABLE JBPM.DASHB_ALLOWED_PANEL DROP CONSTRAINT FK_WORKSPACE_ID;

ALTER TABLE JBPM.DASHB_DATA_PROVIDER_I18N DROP CONSTRAINT SQL170307175301300;

ALTER TABLE JBPM.DASHB_KPI DROP CONSTRAINT SQL170307175300990;

ALTER TABLE JBPM.DASHB_KPI_I18N DROP CONSTRAINT SQL170307175301160;

ALTER TABLE JBPM.DASHB_PANEL DROP CONSTRAINT SQL170307175259540;

ALTER TABLE JBPM.DASHB_PANEL_HTML DROP CONSTRAINT SQL170307175259960;

ALTER TABLE JBPM.DASHB_PANEL_HTML_I18N DROP CONSTRAINT SQL170307175300270;

ALTER TABLE JBPM.DASHB_PANEL_INSTANCE DROP CONSTRAINT SQL170307175259360;

ALTER TABLE JBPM.DASHB_PANEL_PARAMETER DROP CONSTRAINT SQL170307175259760;

ALTER TABLE JBPM.DASHB_SECTION DROP CONSTRAINT SQL170307175258810;

ALTER TABLE JBPM.DASHB_SECTION_I18N DROP CONSTRAINT SQL170307175259010;

ALTER TABLE JBPM.DASHB_WORKSPACE_HOME DROP CONSTRAINT SQL170307175257940;

ALTER TABLE JBPM.DASHB_WORKSPACE_PARAMETER DROP CONSTRAINT SQL170307175258300;

ALTER TABLE JBPM.DEADLINE DROP CONSTRAINT FK_68W742SGE00VCO2CQ3JHBVMGX;

ALTER TABLE JBPM.DEADLINE DROP CONSTRAINT FK_EUOOHOELBQVV94D8A8RCG8S5N;

ALTER TABLE JBPM.DELEGATION_DELEGATES DROP CONSTRAINT FK_FAJQ6KOSSBSQWR3OPKRCTXEI3;

ALTER TABLE JBPM.DELEGATION_DELEGATES DROP CONSTRAINT FK_GN7ULA51SK55WJ1O1M57GUQXB;

ALTER TABLE JBPM.ERRORINFO DROP CONSTRAINT FK_CMS0MET37GGFW5P5GCI3OTAQ0;

ALTER TABLE JBPM.ESCALATION DROP CONSTRAINT FK_AY2GD4FVL9YAAPVIYXUDWUVFG;

ALTER TABLE JBPM.EVENTTYPES DROP CONSTRAINT FK_NRECJ4617IWXLC65IJ6M7LSL1;

ALTER TABLE JBPM.I18NTEXT DROP CONSTRAINT FK_21QVIFARXSVUXEAW5SXWH473W;

ALTER TABLE JBPM.I18NTEXT DROP CONSTRAINT FK_4EYFP69UCRRON2HR7QX4NP2FP;

ALTER TABLE JBPM.I18NTEXT DROP CONSTRAINT FK_BW8VMPEKEJXT1EI2GE26GDSRY;

ALTER TABLE JBPM.I18NTEXT DROP CONSTRAINT FK_FD9UK6HEMV2DX1OJOVO7MS3VP;

ALTER TABLE JBPM.I18NTEXT DROP CONSTRAINT FK_G1TRXRI8W64ENUDW2T1QAHHK5;

ALTER TABLE JBPM.I18NTEXT DROP CONSTRAINT FK_K16JPGRH67TI9UEDF6KONSU1P;

ALTER TABLE JBPM.I18NTEXT DROP CONSTRAINT FK_O84RKH69R47TI8UV4EYJ7BMO2;

ALTER TABLE JBPM.I18NTEXT DROP CONSTRAINT FK_PQARJVVNWFJPEYB87YD7M0BFI;

ALTER TABLE JBPM.I18NTEXT DROP CONSTRAINT FK_QOCE92C70ADEM3CCB3I7LEC8X;

ALTER TABLE JBPM.NOTIFICATION DROP CONSTRAINT FK_BDBEML3768GO5IM41CGFPYSO9;

ALTER TABLE JBPM.NOTIFICATION_BAS DROP CONSTRAINT FK_FC0UUY76T2BVXAXQYSOO8XTS7;

ALTER TABLE JBPM.NOTIFICATION_BAS DROP CONSTRAINT FK_MFBSNBRHTH4RJHQC2UD338S4I;

ALTER TABLE JBPM.NOTIFICATION_EMAIL_HEADER DROP CONSTRAINT FK_ETH4NVXN21FK1VNJU85VKJRAI;

ALTER TABLE JBPM.NOTIFICATION_EMAIL_HEADER DROP CONSTRAINT FK_PTAKA5KOST68H7L3WFLV7W6Y8;

ALTER TABLE JBPM.NOTIFICATION_RECIPIENTS DROP CONSTRAINT FK_3L244PJ8SH78VTN9IMAYMRG47;

ALTER TABLE JBPM.NOTIFICATION_RECIPIENTS DROP CONSTRAINT FK_BLF9JSRUMTRTHDAQNPWXT25EU;

ALTER TABLE JBPM.PEOPLEASSIGNMENTS_BAS DROP CONSTRAINT FK_OMJG5QH7UV8E9BOLBAQ7HV6OH;

ALTER TABLE JBPM.PEOPLEASSIGNMENTS_BAS DROP CONSTRAINT FK_T38XBKRQ6CPPIFNXEQUHVJSL2;

ALTER TABLE JBPM.PEOPLEASSIGNMENTS_EXCLOWNERS DROP CONSTRAINT FK_B8OWUXFRDNG050UGPK0PDOWA7;

ALTER TABLE JBPM.PEOPLEASSIGNMENTS_EXCLOWNERS DROP CONSTRAINT FK_PTH28A73RJ6BXTLFC69KMQO0A;

ALTER TABLE JBPM.PEOPLEASSIGNMENTS_POTOWNERS DROP CONSTRAINT FK_4DV2OJI7PR35RU0W45TRIX02X;

ALTER TABLE JBPM.PEOPLEASSIGNMENTS_POTOWNERS DROP CONSTRAINT FK_TEE3FTIR7XS6EO3FDVI3XW026;

ALTER TABLE JBPM.PEOPLEASSIGNMENTS_RECIPIENTS DROP CONSTRAINT FK_4G7Y3WX6GNOKF6VYCGPXS83D6;

ALTER TABLE JBPM.PEOPLEASSIGNMENTS_RECIPIENTS DROP CONSTRAINT FK_ENHK831FGHF6AKJILFN58OKL4;

ALTER TABLE JBPM.PEOPLEASSIGNMENTS_STAKEHOLDERS DROP CONSTRAINT FK_4BH3AY74X6QL9USUNUBTTFDF1;

ALTER TABLE JBPM.PEOPLEASSIGNMENTS_STAKEHOLDERS DROP CONSTRAINT FK_MET63INAEP6CQ4OFB3NNXI4TM;

ALTER TABLE JBPM.REASSIGNMENT DROP CONSTRAINT FK_PNPEUE9HS6KX2EP0SP16B6KFD;

ALTER TABLE JBPM.REASSIGNMENT_POTENTIALOWNERS DROP CONSTRAINT FK_8FRL6LA7TGPARLNUKHP8XMODY;

ALTER TABLE JBPM.REASSIGNMENT_POTENTIALOWNERS DROP CONSTRAINT FK_QBEGA5NCU6B9YIGWLW55AEIJN;

ALTER TABLE JBPM.TASK DROP CONSTRAINT FK_DPK0F9UCM14C78BSXTHH7H8YH;

ALTER TABLE JBPM.TASK DROP CONSTRAINT FK_K02OG0U71OBF1UXGCDJX9RCJC;

ALTER TABLE JBPM.TASK DROP CONSTRAINT FK_NH9NNT47F3L61QJLYEDQT05RF;

ALTER TABLE JBPM.TASK_COMMENT DROP CONSTRAINT FK_1WS9JDMHTEY6MXU7JB0R0UFVS;

ALTER TABLE JBPM.TASK_COMMENT DROP CONSTRAINT FK_AAX378YJNSMW9KB9VSU994JJV;

ALTER TABLE JBPM.ATTACHMENT DROP CONSTRAINT SQL170307175055530;

ALTER TABLE JBPM.AUDITTASKIMPL DROP CONSTRAINT SQL170307175055730;

ALTER TABLE JBPM.BAMTASKSUMMARY DROP CONSTRAINT SQL170307175055880;

ALTER TABLE JBPM.BOOLEANEXPRESSION DROP CONSTRAINT SQL170307175056080;

ALTER TABLE JBPM.CONTENT DROP CONSTRAINT SQL170307175056300;

ALTER TABLE JBPM.CONTEXTMAPPINGINFO DROP CONSTRAINT SQL170307175056480;

ALTER TABLE JBPM.CORRELATIONKEYINFO DROP CONSTRAINT SQL170307175056990;

ALTER TABLE JBPM.CORRELATIONPROPERTYINFO DROP CONSTRAINT SQL170307175057130;

ALTER TABLE JBPM.DASHB_ALLOWED_PANEL DROP CONSTRAINT DASHB_WORKSPACE_PROVIDER_ALLOWED_PKEY;

ALTER TABLE JBPM.DASHB_CLUSTER_NODE DROP CONSTRAINT SQL170307175301450;

ALTER TABLE JBPM.DASHB_DATA_PROVIDER DROP CONSTRAINT SQL170307175300770;

ALTER TABLE JBPM.DASHB_DATA_PROVIDER_I18N DROP CONSTRAINT SQL170307175301290;

ALTER TABLE JBPM.DASHB_DATA_SOURCE DROP CONSTRAINT SQL170307175256120;

ALTER TABLE JBPM.DASHB_DATA_SOURCE_COLUMN DROP CONSTRAINT SQL170307175256860;

ALTER TABLE JBPM.DASHB_DATA_SOURCE_TABLE DROP CONSTRAINT SQL170307175256470;

ALTER TABLE JBPM.DASHB_GRAPHIC_RESOURCE DROP CONSTRAINT SQL170307175258510;

ALTER TABLE JBPM.DASHB_INSTALLED_MODULE DROP CONSTRAINT SQL170307175257170;

ALTER TABLE JBPM.DASHB_KPI DROP CONSTRAINT SQL170307175300980;

ALTER TABLE JBPM.DASHB_KPI_I18N DROP CONSTRAINT SQL170307175301130;

ALTER TABLE JBPM.DASHB_PANEL DROP CONSTRAINT SQL170307175259520;

ALTER TABLE JBPM.DASHB_PANEL_HTML DROP CONSTRAINT SQL170307175259950;

ALTER TABLE JBPM.DASHB_PANEL_HTML_I18N DROP CONSTRAINT SQL170307175300260;

ALTER TABLE JBPM.DASHB_PANEL_INSTANCE DROP CONSTRAINT SQL170307175259350;

ALTER TABLE JBPM.DASHB_PANEL_PARAMETER DROP CONSTRAINT SQL170307175259750;

ALTER TABLE JBPM.DASHB_PERMISSION DROP CONSTRAINT SQL170307175257440;

ALTER TABLE JBPM.DASHB_SECTION DROP CONSTRAINT SQL170307175258770;

ALTER TABLE JBPM.DASHB_SECTION_I18N DROP CONSTRAINT SQL170307175259000;

ALTER TABLE JBPM.DASHB_WORKSPACE DROP CONSTRAINT SQL170307175257690;

ALTER TABLE JBPM.DASHB_WORKSPACE_HOME DROP CONSTRAINT SQL170307175257920;

ALTER TABLE JBPM.DASHB_WORKSPACE_PARAMETER DROP CONSTRAINT SQL170307175258280;

ALTER TABLE JBPM.DEADLINE DROP CONSTRAINT SQL170307175057280;

ALTER TABLE JBPM.DEPLOYMENTSTORE DROP CONSTRAINT SQL170307175057580;

ALTER TABLE JBPM.EMAIL_HEADER DROP CONSTRAINT SQL170307175104430;

ALTER TABLE JBPM.ERRORINFO DROP CONSTRAINT SQL170307175057930;

ALTER TABLE JBPM.ESCALATION DROP CONSTRAINT SQL170307175058160;

ALTER TABLE JBPM.I18NTEXT DROP CONSTRAINT SQL170307175058680;

ALTER TABLE JBPM.NODEINSTANCELOG DROP CONSTRAINT SQL170307175058970;

ALTER TABLE JBPM.NOTIFICATION DROP CONSTRAINT SQL170307175059170;

ALTER TABLE JBPM.NOTIFICATION_EMAIL_HEADER DROP CONSTRAINT SQL170307175059470;

ALTER TABLE JBPM.NOTIFICATION_EMAIL_HEADER DROP CONSTRAINT UK_PTAKA5KOST68H7L3WFLV7W6Y8;

ALTER TABLE JBPM.ORGANIZATIONALENTITY DROP CONSTRAINT SQL170307175059790;

ALTER TABLE JBPM.PROCESSINSTANCEINFO DROP CONSTRAINT SQL170307175100400;

ALTER TABLE JBPM.PROCESSINSTANCELOG DROP CONSTRAINT SQL170307175100770;

ALTER TABLE JBPM.QUERYDEFINITIONSTORE DROP CONSTRAINT SQL170307175101050;

ALTER TABLE JBPM.REASSIGNMENT DROP CONSTRAINT SQL170307175101320;

ALTER TABLE JBPM.REQUESTINFO DROP CONSTRAINT SQL170307175101710;

ALTER TABLE JBPM.SESSIONINFO DROP CONSTRAINT SQL170307175102170;

ALTER TABLE JBPM.TASK DROP CONSTRAINT SQL170307175102750;

ALTER TABLE JBPM.TASKDEF DROP CONSTRAINT SQL170307175103060;

ALTER TABLE JBPM.TASKEVENT DROP CONSTRAINT SQL170307175103290;

ALTER TABLE JBPM.TASKVARIABLEIMPL DROP CONSTRAINT SQL170307175103580;

ALTER TABLE JBPM.TASK_COMMENT DROP CONSTRAINT SQL170307175104760;

ALTER TABLE JBPM.VARIABLEINSTANCELOG DROP CONSTRAINT SQL170307175103830;

ALTER TABLE JBPM.WORKITEMINFO DROP CONSTRAINT SQL170307175104150;

DROP INDEX JBPM.UK_1DMY087NHBYKUCPGJIPCNYLUV;

DROP INDEX JBPM.UK_85RGSKT09THD8MKKFL3TB0Y81;

DROP TABLE JBPM.ATTACHMENT;

DROP TABLE JBPM.AUDITTASKIMPL;

DROP TABLE JBPM.BAMTASKSUMMARY;

DROP TABLE JBPM.BOOLEANEXPRESSION;

DROP TABLE JBPM.CONTENT;

DROP TABLE JBPM.CONTEXTMAPPINGINFO;

DROP TABLE JBPM.CORRELATIONKEYINFO;

DROP TABLE JBPM.CORRELATIONPROPERTYINFO;

DROP TABLE JBPM.DASHB_ALLOWED_PANEL;

DROP TABLE JBPM.DASHB_CLUSTER_NODE;

DROP TABLE JBPM.DASHB_DATA_PROVIDER;

DROP TABLE JBPM.DASHB_DATA_PROVIDER_I18N;

DROP TABLE JBPM.DASHB_DATA_SOURCE;

DROP TABLE JBPM.DASHB_DATA_SOURCE_COLUMN;

DROP TABLE JBPM.DASHB_DATA_SOURCE_TABLE;

DROP TABLE JBPM.DASHB_GRAPHIC_RESOURCE;

DROP TABLE JBPM.DASHB_INSTALLED_MODULE;

DROP TABLE JBPM.DASHB_KPI;

DROP TABLE JBPM.DASHB_KPI_I18N;

DROP TABLE JBPM.DASHB_PANEL;

DROP TABLE JBPM.DASHB_PANEL_HTML;

DROP TABLE JBPM.DASHB_PANEL_HTML_I18N;

DROP TABLE JBPM.DASHB_PANEL_INSTANCE;

DROP TABLE JBPM.DASHB_PANEL_PARAMETER;

DROP TABLE JBPM.DASHB_PERMISSION;

DROP TABLE JBPM.DASHB_SECTION;

DROP TABLE JBPM.DASHB_SECTION_I18N;

DROP TABLE JBPM.DASHB_WORKSPACE;

DROP TABLE JBPM.DASHB_WORKSPACE_HOME;

DROP TABLE JBPM.DASHB_WORKSPACE_PARAMETER;

DROP TABLE JBPM.DEADLINE;

DROP TABLE JBPM.DELEGATION_DELEGATES;

DROP TABLE JBPM.DEPLOYMENTSTORE;

DROP TABLE JBPM.EMAIL_HEADER;

DROP TABLE JBPM.ERRORINFO;

DROP TABLE JBPM.ESCALATION;

DROP TABLE JBPM.EVENTTYPES;

DROP TABLE JBPM.I18NTEXT;

DROP TABLE JBPM.NODEINSTANCELOG;

DROP TABLE JBPM.NOTIFICATION;

DROP TABLE JBPM.NOTIFICATION_BAS;

DROP TABLE JBPM.NOTIFICATION_EMAIL_HEADER;

DROP TABLE JBPM.NOTIFICATION_RECIPIENTS;

DROP TABLE JBPM.ORGANIZATIONALENTITY;

DROP TABLE JBPM.PEOPLEASSIGNMENTS_BAS;

DROP TABLE JBPM.PEOPLEASSIGNMENTS_EXCLOWNERS;

DROP TABLE JBPM.PEOPLEASSIGNMENTS_POTOWNERS;

DROP TABLE JBPM.PEOPLEASSIGNMENTS_RECIPIENTS;

DROP TABLE JBPM.PEOPLEASSIGNMENTS_STAKEHOLDERS;

DROP TABLE JBPM.PROCESSINSTANCEINFO;

DROP TABLE JBPM.PROCESSINSTANCELOG;

DROP TABLE JBPM.QUERYDEFINITIONSTORE;

DROP TABLE JBPM.REASSIGNMENT;

DROP TABLE JBPM.REASSIGNMENT_POTENTIALOWNERS;

DROP TABLE JBPM.REQUESTINFO;

DROP TABLE JBPM.SESSIONINFO;

DROP TABLE JBPM.TASK;

DROP TABLE JBPM.TASKDEF;

DROP TABLE JBPM.TASKEVENT;

DROP TABLE JBPM.TASKVARIABLEIMPL;

DROP TABLE JBPM.TASK_COMMENT;

DROP TABLE JBPM.VARIABLEINSTANCELOG;

DROP TABLE JBPM.WORKITEMINFO;

CREATE TABLE JBPM.ATTACHMENT (
		ID BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY ( START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 NO CYCLE CACHE 20 NO ORDER ), 
		ACCESSTYPE INTEGER, 
		ATTACHEDAT TIMESTAMP, 
		ATTACHMENTCONTENTID BIGINT NOT NULL, 
		CONTENTTYPE VARCHAR(255 OCTETS), 
		NAME VARCHAR(255 OCTETS), 
		ATTACHMENT_SIZE INTEGER, 
		ATTACHEDBY_ID VARCHAR(255 OCTETS), 
		TASKDATA_ATTACHMENTS_ID BIGINT
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.AUDITTASKIMPL (
		ID BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY ( START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 NO CYCLE CACHE 20 NO ORDER ), 
		ACTIVATIONTIME TIMESTAMP, 
		ACTUALOWNER VARCHAR(255 OCTETS), 
		CREATEDBY VARCHAR(255 OCTETS), 
		CREATEDON TIMESTAMP, 
		DEPLOYMENTID VARCHAR(255 OCTETS), 
		DESCRIPTION VARCHAR(255 OCTETS), 
		DUEDATE TIMESTAMP, 
		NAME VARCHAR(255 OCTETS), 
		PARENTID BIGINT NOT NULL, 
		PRIORITY INTEGER NOT NULL, 
		PROCESSID VARCHAR(255 OCTETS), 
		PROCESSINSTANCEID BIGINT NOT NULL, 
		PROCESSSESSIONID BIGINT NOT NULL, 
		STATUS VARCHAR(255 OCTETS), 
		TASKID BIGINT, 
		WORKITEMID BIGINT
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.BAMTASKSUMMARY (
		PK BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY ( START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 NO CYCLE CACHE 20 NO ORDER ), 
		CREATEDDATE TIMESTAMP, 
		DURATION BIGINT, 
		ENDDATE TIMESTAMP, 
		PROCESSINSTANCEID BIGINT NOT NULL, 
		STARTDATE TIMESTAMP, 
		STATUS VARCHAR(255 OCTETS), 
		TASKID BIGINT NOT NULL, 
		TASKNAME VARCHAR(255 OCTETS), 
		USERID VARCHAR(255 OCTETS), 
		OPTLOCK INTEGER
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.BOOLEANEXPRESSION (
		ID BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY ( START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 NO CYCLE CACHE 20 NO ORDER ), 
		EXPRESSION CLOB(65535 OCTETS) INLINE LENGTH 116, 
		TYPE VARCHAR(255 OCTETS), 
		ESCALATION_CONSTRAINTS_ID BIGINT
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.CONTENT (
		ID BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY ( START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 NO CYCLE CACHE 20 NO ORDER ), 
		CONTENT BLOB(2147483647) INLINE LENGTH 312
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.CONTEXTMAPPINGINFO (
		MAPPINGID BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY ( START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 NO CYCLE CACHE 20 NO ORDER ), 
		CONTEXT_ID VARCHAR(255 OCTETS) NOT NULL, 
		KSESSION_ID BIGINT NOT NULL, 
		OWNER_ID VARCHAR(255 OCTETS), 
		OPTLOCK INTEGER
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.CORRELATIONKEYINFO (
		KEYID BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY ( START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 NO CYCLE CACHE 20 NO ORDER ), 
		NAME VARCHAR(255 OCTETS), 
		PROCESSINSTANCEID BIGINT NOT NULL, 
		OPTLOCK INTEGER
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.CORRELATIONPROPERTYINFO (
		PROPERTYID BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY ( START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 NO CYCLE CACHE 20 NO ORDER ), 
		NAME VARCHAR(255 OCTETS), 
		VALUE VARCHAR(255 OCTETS), 
		OPTLOCK INTEGER, 
		CORRELATIONKEY_KEYID BIGINT
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.DASHB_ALLOWED_PANEL (
		ID_WORKSPACE VARCHAR(40 OCTETS) NOT NULL, 
		ID_PANEL_PROVIDER VARCHAR(255 OCTETS) NOT NULL
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.DASHB_CLUSTER_NODE (
		ID_NODE DECIMAL(28 , 0) NOT NULL, 
		NODE_ADDRESS VARCHAR(50 OCTETS) NOT NULL, 
		STARTUP_TIME TIMESTAMP NOT NULL, 
		NODE_STATUS VARCHAR(100 OCTETS)
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.DASHB_DATA_PROVIDER (
		ID DECIMAL(28 , 0) NOT NULL, 
		CODE VARCHAR(128 OCTETS) NOT NULL, 
		PROVIDER_UID CLOB(1048576 OCTETS) INLINE LENGTH 164 NOT NULL, 
		PROVIDER_XML CLOB(1048576 OCTETS) INLINE LENGTH 164 NOT NULL, 
		DATA_PROPERTIES_XML CLOB(1048576 OCTETS) INLINE LENGTH 164, 
		CAN_EDIT SMALLINT, 
		CAN_EDIT_PROPERTIES SMALLINT, 
		CAN_DELETE SMALLINT
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.DASHB_DATA_PROVIDER_I18N (
		ID_DATA_PROVIDER DECIMAL(28 , 0) NOT NULL, 
		LANGUAGE VARCHAR(10 OCTETS) NOT NULL, 
		DESCRIPTION VARCHAR(512 OCTETS)
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.DASHB_DATA_SOURCE (
		DBID BIGINT NOT NULL, 
		DS_TYPE VARCHAR(512 OCTETS), 
		NAME VARCHAR(512 OCTETS), 
		JNDI_PATH VARCHAR(512 OCTETS), 
		DS_URL VARCHAR(512 OCTETS), 
		JDBC_DRIVER_CLASS VARCHAR(512 OCTETS), 
		USER_NAME VARCHAR(512 OCTETS), 
		PASSWD VARCHAR(512 OCTETS), 
		TEST_QUERY VARCHAR(2000 OCTETS)
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.DASHB_DATA_SOURCE_COLUMN (
		DBID BIGINT NOT NULL, 
		NAME VARCHAR(512 OCTETS), 
		SQL_TYPE INTEGER, 
		DATA_SOURCE VARCHAR(512 OCTETS), 
		TABLE_NAME VARCHAR(512 OCTETS), 
		PRIMARY_KEY VARCHAR(5 OCTETS), 
		IDENTITY1 VARCHAR(5 OCTETS)
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.DASHB_DATA_SOURCE_TABLE (
		DBID BIGINT NOT NULL, 
		NAME VARCHAR(512 OCTETS), 
		DATA_SOURCE VARCHAR(512 OCTETS), 
		SELECTED VARCHAR(512 OCTETS)
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.DASHB_GRAPHIC_RESOURCE (
		DBID DECIMAL(28 , 0) NOT NULL, 
		WORKSPACE_ID VARCHAR(40 OCTETS), 
		SECTION_ID DECIMAL(28 , 0), 
		PANEL_ID DECIMAL(28 , 0), 
		ID VARCHAR(3000 OCTETS), 
		RESOURCE_TYPE VARCHAR(3000 OCTETS), 
		ZIP BLOB(1048576) INLINE LENGTH 164, 
		STATUS SMALLINT, 
		LAST_MODIFIED TIMESTAMP
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.DASHB_INSTALLED_MODULE (
		NAME VARCHAR(256 OCTETS) NOT NULL, 
		VERSION BIGINT
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.DASHB_KPI (
		ID DECIMAL(28 , 0) NOT NULL, 
		ID_DATA_PROVIDER DECIMAL(28 , 0) NOT NULL, 
		CODE VARCHAR(128 OCTETS) NOT NULL, 
		DISPLAYER_UID VARCHAR(128 OCTETS) NOT NULL, 
		DISPLAYER_XML CLOB(1048576 OCTETS) INLINE LENGTH 164 NOT NULL
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.DASHB_KPI_I18N (
		ID_KPI DECIMAL(28 , 0) NOT NULL, 
		LANGUAGE VARCHAR(10 OCTETS) NOT NULL, 
		DESCRIPTION VARCHAR(512 OCTETS)
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.DASHB_PANEL (
		DBID DECIMAL(28 , 0) NOT NULL, 
		ID_PANEL DECIMAL(28 , 0) NOT NULL, 
		ID_INSTANCE DECIMAL(28 , 0) NOT NULL, 
		ID_SECTION DECIMAL(28 , 0) NOT NULL, 
		ID_REGION VARCHAR(100 OCTETS), 
		POSITION DECIMAL(4 , 0) NOT NULL
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.DASHB_PANEL_HTML (
		DBID DECIMAL(28 , 0) NOT NULL, 
		ID_INSTANCE DECIMAL(28 , 0) NOT NULL
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.DASHB_PANEL_HTML_I18N (
		ID_TEXT DECIMAL(28 , 0) NOT NULL, 
		LANGUAGE VARCHAR(10 OCTETS) NOT NULL, 
		HTML_TEXT CLOB(1048576 OCTETS) INLINE LENGTH 164
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.DASHB_PANEL_INSTANCE (
		DBID DECIMAL(28 , 0) NOT NULL, 
		ID_INSTANCE DECIMAL(28 , 0) NOT NULL, 
		ID_WORKSPACE VARCHAR(40 OCTETS) NOT NULL, 
		PROVIDER VARCHAR(100 OCTETS) NOT NULL, 
		SERIALIZATION CLOB(1048576 OCTETS) INLINE LENGTH 164
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.DASHB_PANEL_PARAMETER (
		DBID DECIMAL(28 , 0) NOT NULL, 
		ID_PARAMETER VARCHAR(100 OCTETS) NOT NULL, 
		ID_INSTANCE DECIMAL(28 , 0) NOT NULL, 
		VALUE CLOB(1048576 OCTETS) INLINE LENGTH 164, 
		LANGUAGE VARCHAR(10 OCTETS)
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.DASHB_PERMISSION (
		ID_PERMISSION DECIMAL(28 , 0) NOT NULL, 
		PRINCIPAL_CLASS VARCHAR(100 OCTETS), 
		PRINCIPAL_NAME VARCHAR(100 OCTETS), 
		PERMISSION_CLASS VARCHAR(100 OCTETS) NOT NULL, 
		PERMISSION_RESOURCE VARCHAR(100 OCTETS) NOT NULL, 
		PERMISSION_ACTION VARCHAR(100 OCTETS), 
		PERMISSION_READONLY SMALLINT
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.DASHB_SECTION (
		ID_SECTION DECIMAL(28 , 0) NOT NULL, 
		ID_WORKSPACE VARCHAR(40 OCTETS) NOT NULL, 
		ID_TEMPLATE VARCHAR(100 OCTETS) NOT NULL, 
		POSITION BIGINT NOT NULL, 
		VISIBLE SMALLINT, 
		REGION_SPACING DECIMAL(4 , 0), 
		PANEL_SPACING DECIMAL(4 , 0), 
		ID_PARENT DECIMAL(28 , 0), 
		URL VARCHAR(3000 OCTETS), 
		DBID DECIMAL(28 , 0) NOT NULL, 
		SKIN VARCHAR(100 OCTETS), 
		ENVELOPE VARCHAR(100 OCTETS)
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.DASHB_SECTION_I18N (
		ID_SECTION DECIMAL(28 , 0) NOT NULL, 
		LANGUAGE VARCHAR(10 OCTETS) NOT NULL, 
		TITLE VARCHAR(200 OCTETS)
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.DASHB_WORKSPACE (
		ID_WORKSPACE VARCHAR(40 OCTETS) NOT NULL, 
		LOOK VARCHAR(100 OCTETS), 
		ENVELOPE VARCHAR(100 OCTETS), 
		URL VARCHAR(3000 OCTETS), 
		DEFAULT_WORKSPACE SMALLINT NOT NULL, 
		HOME_SEARCH_MODE DECIMAL(4 , 0) NOT NULL DEFAULT 0
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.DASHB_WORKSPACE_HOME (
		ID_WORKSPACE VARCHAR(40 OCTETS) NOT NULL, 
		ID_ROLE VARCHAR(100 OCTETS) NOT NULL, 
		ID_SECTION DECIMAL(28 , 0)
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.DASHB_WORKSPACE_PARAMETER (
		ID_WORKSPACE VARCHAR(40 OCTETS) NOT NULL, 
		ID_PARAMETER VARCHAR(100 OCTETS) NOT NULL, 
		LANGUAGE VARCHAR(10 OCTETS) NOT NULL, 
		VALUE VARCHAR(4000 OCTETS)
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.DEADLINE (
		ID BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY ( START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 NO CYCLE CACHE 20 NO ORDER ), 
		DEADLINE_DATE TIMESTAMP, 
		ESCALATED SMALLINT, 
		DEADLINES_STARTDEADLINE_ID BIGINT, 
		DEADLINES_ENDDEADLINE_ID BIGINT
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.DELEGATION_DELEGATES (
		TASK_ID BIGINT NOT NULL, 
		ENTITY_ID VARCHAR(255 OCTETS) NOT NULL
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.DEPLOYMENTSTORE (
		ID BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY ( START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 NO CYCLE CACHE 20 NO ORDER ), 
		ATTRIBUTES VARCHAR(255 OCTETS), 
		DEPLOYMENT_ID VARCHAR(255 OCTETS), 
		DEPLOYMENTUNIT CLOB(65535 OCTETS) INLINE LENGTH 116, 
		STATE INTEGER, 
		UPDATEDATE TIMESTAMP
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.EMAIL_HEADER (
		ID BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY ( START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 NO CYCLE CACHE 20 NO ORDER ), 
		BODY CLOB(65535 OCTETS) INLINE LENGTH 116, 
		FROMADDRESS VARCHAR(255 OCTETS), 
		LANGUAGE VARCHAR(255 OCTETS), 
		REPLYTOADDRESS VARCHAR(255 OCTETS), 
		SUBJECT VARCHAR(255 OCTETS)
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.ERRORINFO (
		ID BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY ( START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 NO CYCLE CACHE 20 NO ORDER ), 
		MESSAGE VARCHAR(255 OCTETS), 
		STACKTRACE VARCHAR(5000 OCTETS), 
		TIMESTAMP TIMESTAMP, 
		REQUEST_ID BIGINT NOT NULL
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.ESCALATION (
		ID BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY ( START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 NO CYCLE CACHE 20 NO ORDER ), 
		NAME VARCHAR(255 OCTETS), 
		DEADLINE_ESCALATION_ID BIGINT
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.EVENTTYPES (
		INSTANCEID BIGINT NOT NULL, 
		ELEMENT VARCHAR(255 OCTETS)
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.I18NTEXT (
		ID BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY ( START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 NO CYCLE CACHE 20 NO ORDER ), 
		LANGUAGE VARCHAR(255 OCTETS), 
		SHORTTEXT VARCHAR(255 OCTETS), 
		TEXT CLOB(65535 OCTETS) INLINE LENGTH 116, 
		TASK_SUBJECTS_ID BIGINT, 
		TASK_NAMES_ID BIGINT, 
		TASK_DESCRIPTIONS_ID BIGINT, 
		REASSIGNMENT_DOCUMENTATION_ID BIGINT, 
		NOTIFICATION_SUBJECTS_ID BIGINT, 
		NOTIFICATION_NAMES_ID BIGINT, 
		NOTIFICATION_DOCUMENTATION_ID BIGINT, 
		NOTIFICATION_DESCRIPTIONS_ID BIGINT, 
		DEADLINE_DOCUMENTATION_ID BIGINT
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.NODEINSTANCELOG (
		ID BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY ( START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 NO CYCLE CACHE 20 NO ORDER ), 
		CONNECTION VARCHAR(255 OCTETS), 
		LOG_DATE TIMESTAMP, 
		EXTERNALID VARCHAR(255 OCTETS), 
		NODEID VARCHAR(255 OCTETS), 
		NODEINSTANCEID VARCHAR(255 OCTETS), 
		NODENAME VARCHAR(255 OCTETS), 
		NODETYPE VARCHAR(255 OCTETS), 
		PROCESSID VARCHAR(255 OCTETS), 
		PROCESSINSTANCEID BIGINT NOT NULL, 
		TYPE INTEGER NOT NULL, 
		WORKITEMID BIGINT
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.NOTIFICATION (
		DTYPE VARCHAR(31 OCTETS) NOT NULL, 
		ID BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY ( START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 NO CYCLE CACHE 20 NO ORDER ), 
		PRIORITY INTEGER NOT NULL, 
		ESCALATION_NOTIFICATIONS_ID BIGINT
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.NOTIFICATION_BAS (
		TASK_ID BIGINT NOT NULL, 
		ENTITY_ID VARCHAR(255 OCTETS) NOT NULL
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.NOTIFICATION_EMAIL_HEADER (
		NOTIFICATION_ID BIGINT NOT NULL, 
		EMAILHEADERS_ID BIGINT NOT NULL, 
		MAPKEY VARCHAR(255 OCTETS) NOT NULL
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.NOTIFICATION_RECIPIENTS (
		TASK_ID BIGINT NOT NULL, 
		ENTITY_ID VARCHAR(255 OCTETS) NOT NULL
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.ORGANIZATIONALENTITY (
		DTYPE VARCHAR(31 OCTETS) NOT NULL, 
		ID VARCHAR(255 OCTETS) NOT NULL
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.PEOPLEASSIGNMENTS_BAS (
		TASK_ID BIGINT NOT NULL, 
		ENTITY_ID VARCHAR(255 OCTETS) NOT NULL
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.PEOPLEASSIGNMENTS_EXCLOWNERS (
		TASK_ID BIGINT NOT NULL, 
		ENTITY_ID VARCHAR(255 OCTETS) NOT NULL
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.PEOPLEASSIGNMENTS_POTOWNERS (
		TASK_ID BIGINT NOT NULL, 
		ENTITY_ID VARCHAR(255 OCTETS) NOT NULL
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.PEOPLEASSIGNMENTS_RECIPIENTS (
		TASK_ID BIGINT NOT NULL, 
		ENTITY_ID VARCHAR(255 OCTETS) NOT NULL
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.PEOPLEASSIGNMENTS_STAKEHOLDERS (
		TASK_ID BIGINT NOT NULL, 
		ENTITY_ID VARCHAR(255 OCTETS) NOT NULL
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.PROCESSINSTANCEINFO (
		INSTANCEID BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY ( START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 NO CYCLE CACHE 20 NO ORDER ), 
		LASTMODIFICATIONDATE TIMESTAMP, 
		LASTREADDATE TIMESTAMP, 
		PROCESSID VARCHAR(255 OCTETS), 
		PROCESSINSTANCEBYTEARRAY BLOB(2147483647) INLINE LENGTH 312, 
		STARTDATE TIMESTAMP, 
		STATE INTEGER NOT NULL, 
		OPTLOCK INTEGER
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.PROCESSINSTANCELOG (
		ID BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY ( START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 NO CYCLE CACHE 20 NO ORDER ), 
		CORRELATIONKEY VARCHAR(255 OCTETS), 
		DURATION BIGINT, 
		END_DATE TIMESTAMP, 
		EXTERNALID VARCHAR(255 OCTETS), 
		USER_IDENTITY VARCHAR(255 OCTETS), 
		OUTCOME VARCHAR(255 OCTETS), 
		PARENTPROCESSINSTANCEID BIGINT, 
		PROCESSID VARCHAR(255 OCTETS), 
		PROCESSINSTANCEDESCRIPTION VARCHAR(255 OCTETS), 
		PROCESSINSTANCEID BIGINT NOT NULL, 
		PROCESSNAME VARCHAR(255 OCTETS), 
		PROCESSVERSION VARCHAR(255 OCTETS), 
		START_DATE TIMESTAMP, 
		STATUS INTEGER
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.QUERYDEFINITIONSTORE (
		ID BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY ( START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 NO CYCLE CACHE 20 NO ORDER ), 
		QEXPRESSION CLOB(65535 OCTETS) INLINE LENGTH 116, 
		QNAME VARCHAR(255 OCTETS), 
		QSOURCE VARCHAR(255 OCTETS), 
		QTARGET VARCHAR(255 OCTETS)
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.REASSIGNMENT (
		ID BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY ( START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 NO CYCLE CACHE 20 NO ORDER ), 
		ESCALATION_REASSIGNMENTS_ID BIGINT
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.REASSIGNMENT_POTENTIALOWNERS (
		TASK_ID BIGINT NOT NULL, 
		ENTITY_ID VARCHAR(255 OCTETS) NOT NULL
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.REQUESTINFO (
		ID BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY ( START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 NO CYCLE CACHE 20 NO ORDER ), 
		COMMANDNAME VARCHAR(255 OCTETS), 
		DEPLOYMENTID VARCHAR(255 OCTETS), 
		EXECUTIONS INTEGER NOT NULL, 
		BUSINESSKEY VARCHAR(255 OCTETS), 
		MESSAGE VARCHAR(255 OCTETS), 
		OWNER VARCHAR(255 OCTETS), 
		REQUESTDATA BLOB(2147483647) INLINE LENGTH 312, 
		RESPONSEDATA BLOB(2147483647) INLINE LENGTH 312, 
		RETRIES INTEGER NOT NULL, 
		STATUS VARCHAR(255 OCTETS), 
		TIMESTAMP TIMESTAMP
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.SESSIONINFO (
		ID BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY ( START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 NO CYCLE CACHE 20 NO ORDER ), 
		LASTMODIFICATIONDATE TIMESTAMP, 
		RULESBYTEARRAY BLOB(2147483647) INLINE LENGTH 312, 
		STARTDATE TIMESTAMP, 
		OPTLOCK INTEGER
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.TASK (
		ID BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY ( START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 NO CYCLE CACHE 20 NO ORDER ), 
		ARCHIVED SMALLINT, 
		ALLOWEDTODELEGATE VARCHAR(255 OCTETS), 
		DESCRIPTION VARCHAR(255 OCTETS), 
		FORMNAME VARCHAR(255 OCTETS), 
		NAME VARCHAR(255 OCTETS), 
		PRIORITY INTEGER NOT NULL, 
		SUBTASKSTRATEGY VARCHAR(255 OCTETS), 
		SUBJECT VARCHAR(255 OCTETS), 
		ACTIVATIONTIME TIMESTAMP, 
		CREATEDON TIMESTAMP, 
		DEPLOYMENTID VARCHAR(255 OCTETS), 
		DOCUMENTACCESSTYPE INTEGER, 
		DOCUMENTCONTENTID BIGINT NOT NULL, 
		DOCUMENTTYPE VARCHAR(255 OCTETS), 
		EXPIRATIONTIME TIMESTAMP, 
		FAULTACCESSTYPE INTEGER, 
		FAULTCONTENTID BIGINT NOT NULL, 
		FAULTNAME VARCHAR(255 OCTETS), 
		FAULTTYPE VARCHAR(255 OCTETS), 
		OUTPUTACCESSTYPE INTEGER, 
		OUTPUTCONTENTID BIGINT NOT NULL, 
		OUTPUTTYPE VARCHAR(255 OCTETS), 
		PARENTID BIGINT NOT NULL, 
		PREVIOUSSTATUS INTEGER, 
		PROCESSID VARCHAR(255 OCTETS), 
		PROCESSINSTANCEID BIGINT NOT NULL, 
		PROCESSSESSIONID BIGINT NOT NULL, 
		SKIPABLE SMALLINT NOT NULL, 
		STATUS VARCHAR(255 OCTETS), 
		WORKITEMID BIGINT NOT NULL, 
		TASKTYPE VARCHAR(255 OCTETS), 
		OPTLOCK INTEGER, 
		TASKINITIATOR_ID VARCHAR(255 OCTETS), 
		ACTUALOWNER_ID VARCHAR(255 OCTETS), 
		CREATEDBY_ID VARCHAR(255 OCTETS)
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.TASKDEF (
		ID BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY ( START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 NO CYCLE CACHE 20 NO ORDER ), 
		NAME VARCHAR(255 OCTETS), 
		PRIORITY INTEGER NOT NULL
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.TASKEVENT (
		ID BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY ( START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 NO CYCLE CACHE 20 NO ORDER ), 
		LOGTIME TIMESTAMP, 
		MESSAGE VARCHAR(255 OCTETS), 
		PROCESSINSTANCEID BIGINT, 
		TASKID BIGINT, 
		TYPE VARCHAR(255 OCTETS), 
		USERID VARCHAR(255 OCTETS), 
		OPTLOCK INTEGER, 
		WORKITEMID BIGINT
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.TASKVARIABLEIMPL (
		ID BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY ( START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 NO CYCLE CACHE 20 NO ORDER ), 
		MODIFICATIONDATE TIMESTAMP, 
		NAME VARCHAR(255 OCTETS), 
		PROCESSID VARCHAR(255 OCTETS), 
		PROCESSINSTANCEID BIGINT, 
		TASKID BIGINT, 
		TYPE INTEGER, 
		VALUE VARCHAR(4000 OCTETS)
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.TASK_COMMENT (
		ID BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY ( START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 NO CYCLE CACHE 20 NO ORDER ), 
		ADDEDAT TIMESTAMP, 
		TEXT CLOB(65535 OCTETS) INLINE LENGTH 116, 
		ADDEDBY_ID VARCHAR(255 OCTETS), 
		TASKDATA_COMMENTS_ID BIGINT
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.VARIABLEINSTANCELOG (
		ID BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY ( START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 NO CYCLE CACHE 20 NO ORDER ), 
		LOG_DATE TIMESTAMP, 
		EXTERNALID VARCHAR(255 OCTETS), 
		OLDVALUE VARCHAR(255 OCTETS), 
		PROCESSID VARCHAR(255 OCTETS), 
		PROCESSINSTANCEID BIGINT NOT NULL, 
		VALUE VARCHAR(255 OCTETS), 
		VARIABLEID VARCHAR(255 OCTETS), 
		VARIABLEINSTANCEID VARCHAR(255 OCTETS)
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE TABLE JBPM.WORKITEMINFO (
		WORKITEMID BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY ( START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 NO CYCLE CACHE 20 NO ORDER ), 
		CREATIONDATE TIMESTAMP, 
		NAME VARCHAR(255 OCTETS), 
		PROCESSINSTANCEID BIGINT NOT NULL, 
		STATE BIGINT NOT NULL, 
		OPTLOCK INTEGER, 
		WORKITEMBYTEARRAY BLOB(2147483647) INLINE LENGTH 312
	)
	ORGANIZE BY ROW
	DATA CAPTURE NONE 
	COMPRESS NO;

CREATE UNIQUE INDEX JBPM.UK_1DMY087NHBYKUCPGJIPCNYLUV
	ON JBPM.QUERYDEFINITIONSTORE
	(QNAME		ASC)
	MINPCTUSED 0
	ALLOW REVERSE SCANS
	PAGE SPLIT SYMMETRIC
	COMPRESS NO;

CREATE UNIQUE INDEX JBPM.UK_85RGSKT09THD8MKKFL3TB0Y81
	ON JBPM.DEPLOYMENTSTORE
	(DEPLOYMENT_ID		ASC)
	MINPCTUSED 0
	ALLOW REVERSE SCANS
	PAGE SPLIT SYMMETRIC
	COMPRESS NO;

ALTER TABLE JBPM.ATTACHMENT ADD CONSTRAINT SQL170307175055530 PRIMARY KEY
	(ID);

ALTER TABLE JBPM.AUDITTASKIMPL ADD CONSTRAINT SQL170307175055730 PRIMARY KEY
	(ID);

ALTER TABLE JBPM.BAMTASKSUMMARY ADD CONSTRAINT SQL170307175055880 PRIMARY KEY
	(PK);

ALTER TABLE JBPM.BOOLEANEXPRESSION ADD CONSTRAINT SQL170307175056080 PRIMARY KEY
	(ID);

ALTER TABLE JBPM.CONTENT ADD CONSTRAINT SQL170307175056300 PRIMARY KEY
	(ID);

ALTER TABLE JBPM.CONTEXTMAPPINGINFO ADD CONSTRAINT SQL170307175056480 PRIMARY KEY
	(MAPPINGID);

ALTER TABLE JBPM.CORRELATIONKEYINFO ADD CONSTRAINT SQL170307175056990 PRIMARY KEY
	(KEYID);

ALTER TABLE JBPM.CORRELATIONPROPERTYINFO ADD CONSTRAINT SQL170307175057130 PRIMARY KEY
	(PROPERTYID);

ALTER TABLE JBPM.DASHB_ALLOWED_PANEL ADD CONSTRAINT DASHB_WORKSPACE_PROVIDER_ALLOWED_PKEY PRIMARY KEY
	(ID_WORKSPACE, 
	 ID_PANEL_PROVIDER);

ALTER TABLE JBPM.DASHB_CLUSTER_NODE ADD CONSTRAINT SQL170307175301450 PRIMARY KEY
	(ID_NODE);

ALTER TABLE JBPM.DASHB_DATA_PROVIDER ADD CONSTRAINT SQL170307175300770 PRIMARY KEY
	(ID);

ALTER TABLE JBPM.DASHB_DATA_PROVIDER_I18N ADD CONSTRAINT SQL170307175301290 PRIMARY KEY
	(ID_DATA_PROVIDER, 
	 LANGUAGE);

ALTER TABLE JBPM.DASHB_DATA_SOURCE ADD CONSTRAINT SQL170307175256120 PRIMARY KEY
	(DBID);

ALTER TABLE JBPM.DASHB_DATA_SOURCE_COLUMN ADD CONSTRAINT SQL170307175256860 PRIMARY KEY
	(DBID);

ALTER TABLE JBPM.DASHB_DATA_SOURCE_TABLE ADD CONSTRAINT SQL170307175256470 PRIMARY KEY
	(DBID);

ALTER TABLE JBPM.DASHB_GRAPHIC_RESOURCE ADD CONSTRAINT SQL170307175258510 PRIMARY KEY
	(DBID);

ALTER TABLE JBPM.DASHB_INSTALLED_MODULE ADD CONSTRAINT SQL170307175257170 PRIMARY KEY
	(NAME);

ALTER TABLE JBPM.DASHB_KPI ADD CONSTRAINT SQL170307175300980 PRIMARY KEY
	(ID);

ALTER TABLE JBPM.DASHB_KPI_I18N ADD CONSTRAINT SQL170307175301130 PRIMARY KEY
	(ID_KPI, 
	 LANGUAGE);

ALTER TABLE JBPM.DASHB_PANEL ADD CONSTRAINT SQL170307175259520 PRIMARY KEY
	(DBID);

ALTER TABLE JBPM.DASHB_PANEL_HTML ADD CONSTRAINT SQL170307175259950 PRIMARY KEY
	(DBID);

ALTER TABLE JBPM.DASHB_PANEL_HTML_I18N ADD CONSTRAINT SQL170307175300260 PRIMARY KEY
	(ID_TEXT, 
	 LANGUAGE);

ALTER TABLE JBPM.DASHB_PANEL_INSTANCE ADD CONSTRAINT SQL170307175259350 PRIMARY KEY
	(DBID);

ALTER TABLE JBPM.DASHB_PANEL_PARAMETER ADD CONSTRAINT SQL170307175259750 PRIMARY KEY
	(DBID);

ALTER TABLE JBPM.DASHB_PERMISSION ADD CONSTRAINT SQL170307175257440 PRIMARY KEY
	(ID_PERMISSION);

ALTER TABLE JBPM.DASHB_SECTION ADD CONSTRAINT SQL170307175258770 PRIMARY KEY
	(DBID);

ALTER TABLE JBPM.DASHB_SECTION_I18N ADD CONSTRAINT SQL170307175259000 PRIMARY KEY
	(ID_SECTION, 
	 LANGUAGE);

ALTER TABLE JBPM.DASHB_WORKSPACE ADD CONSTRAINT SQL170307175257690 PRIMARY KEY
	(ID_WORKSPACE);

ALTER TABLE JBPM.DASHB_WORKSPACE_HOME ADD CONSTRAINT SQL170307175257920 PRIMARY KEY
	(ID_WORKSPACE, 
	 ID_ROLE);

ALTER TABLE JBPM.DASHB_WORKSPACE_PARAMETER ADD CONSTRAINT SQL170307175258280 PRIMARY KEY
	(ID_WORKSPACE, 
	 ID_PARAMETER, 
	 LANGUAGE);

ALTER TABLE JBPM.DEADLINE ADD CONSTRAINT SQL170307175057280 PRIMARY KEY
	(ID);

ALTER TABLE JBPM.DEPLOYMENTSTORE ADD CONSTRAINT SQL170307175057580 PRIMARY KEY
	(ID);

ALTER TABLE JBPM.EMAIL_HEADER ADD CONSTRAINT SQL170307175104430 PRIMARY KEY
	(ID);

ALTER TABLE JBPM.ERRORINFO ADD CONSTRAINT SQL170307175057930 PRIMARY KEY
	(ID);

ALTER TABLE JBPM.ESCALATION ADD CONSTRAINT SQL170307175058160 PRIMARY KEY
	(ID);

ALTER TABLE JBPM.I18NTEXT ADD CONSTRAINT SQL170307175058680 PRIMARY KEY
	(ID);

ALTER TABLE JBPM.NODEINSTANCELOG ADD CONSTRAINT SQL170307175058970 PRIMARY KEY
	(ID);

ALTER TABLE JBPM.NOTIFICATION ADD CONSTRAINT SQL170307175059170 PRIMARY KEY
	(ID);

ALTER TABLE JBPM.NOTIFICATION_EMAIL_HEADER ADD CONSTRAINT SQL170307175059470 PRIMARY KEY
	(NOTIFICATION_ID, 
	 MAPKEY);

ALTER TABLE JBPM.NOTIFICATION_EMAIL_HEADER ADD CONSTRAINT UK_PTAKA5KOST68H7L3WFLV7W6Y8 UNIQUE
	(EMAILHEADERS_ID);

ALTER TABLE JBPM.ORGANIZATIONALENTITY ADD CONSTRAINT SQL170307175059790 PRIMARY KEY
	(ID);

ALTER TABLE JBPM.PROCESSINSTANCEINFO ADD CONSTRAINT SQL170307175100400 PRIMARY KEY
	(INSTANCEID);

ALTER TABLE JBPM.PROCESSINSTANCELOG ADD CONSTRAINT SQL170307175100770 PRIMARY KEY
	(ID);

ALTER TABLE JBPM.QUERYDEFINITIONSTORE ADD CONSTRAINT SQL170307175101050 PRIMARY KEY
	(ID);

ALTER TABLE JBPM.REASSIGNMENT ADD CONSTRAINT SQL170307175101320 PRIMARY KEY
	(ID);

ALTER TABLE JBPM.REQUESTINFO ADD CONSTRAINT SQL170307175101710 PRIMARY KEY
	(ID);

ALTER TABLE JBPM.SESSIONINFO ADD CONSTRAINT SQL170307175102170 PRIMARY KEY
	(ID);

ALTER TABLE JBPM.TASK ADD CONSTRAINT SQL170307175102750 PRIMARY KEY
	(ID);

ALTER TABLE JBPM.TASKDEF ADD CONSTRAINT SQL170307175103060 PRIMARY KEY
	(ID);

ALTER TABLE JBPM.TASKEVENT ADD CONSTRAINT SQL170307175103290 PRIMARY KEY
	(ID);

ALTER TABLE JBPM.TASKVARIABLEIMPL ADD CONSTRAINT SQL170307175103580 PRIMARY KEY
	(ID);

ALTER TABLE JBPM.TASK_COMMENT ADD CONSTRAINT SQL170307175104760 PRIMARY KEY
	(ID);

ALTER TABLE JBPM.VARIABLEINSTANCELOG ADD CONSTRAINT SQL170307175103830 PRIMARY KEY
	(ID);

ALTER TABLE JBPM.WORKITEMINFO ADD CONSTRAINT SQL170307175104150 PRIMARY KEY
	(WORKITEMID);

ALTER TABLE JBPM.ATTACHMENT ADD CONSTRAINT FK_7NDPFA311I50BQ7HY18Q05VA3 FOREIGN KEY
	(ATTACHEDBY_ID)
	REFERENCES JBPM.ORGANIZATIONALENTITY
	(ID);

ALTER TABLE JBPM.ATTACHMENT ADD CONSTRAINT FK_HQUPX569KRP0F0SGU9KH87513 FOREIGN KEY
	(TASKDATA_ATTACHMENTS_ID)
	REFERENCES JBPM.TASK
	(ID);

ALTER TABLE JBPM.BOOLEANEXPRESSION ADD CONSTRAINT FK_394NF2QOC0K9OK6OMGD6JTPSO FOREIGN KEY
	(ESCALATION_CONSTRAINTS_ID)
	REFERENCES JBPM.ESCALATION
	(ID);

ALTER TABLE JBPM.CORRELATIONPROPERTYINFO ADD CONSTRAINT FK_HRMX1M882CEJWJ9C04IXH50I4 FOREIGN KEY
	(CORRELATIONKEY_KEYID)
	REFERENCES JBPM.CORRELATIONKEYINFO
	(KEYID);

ALTER TABLE JBPM.DASHB_ALLOWED_PANEL ADD CONSTRAINT FK_WORKSPACE_ID FOREIGN KEY
	(ID_WORKSPACE)
	REFERENCES JBPM.DASHB_WORKSPACE
	(ID_WORKSPACE)
	ON DELETE CASCADE;

ALTER TABLE JBPM.DASHB_DATA_PROVIDER_I18N ADD CONSTRAINT SQL170307175301300 FOREIGN KEY
	(ID_DATA_PROVIDER)
	REFERENCES JBPM.DASHB_DATA_PROVIDER
	(ID);

ALTER TABLE JBPM.DASHB_KPI ADD CONSTRAINT SQL170307175300990 FOREIGN KEY
	(ID_DATA_PROVIDER)
	REFERENCES JBPM.DASHB_DATA_PROVIDER
	(ID);

ALTER TABLE JBPM.DASHB_KPI_I18N ADD CONSTRAINT SQL170307175301160 FOREIGN KEY
	(ID_KPI)
	REFERENCES JBPM.DASHB_KPI
	(ID);

ALTER TABLE JBPM.DASHB_PANEL ADD CONSTRAINT SQL170307175259540 FOREIGN KEY
	(ID_SECTION)
	REFERENCES JBPM.DASHB_SECTION
	(DBID);

ALTER TABLE JBPM.DASHB_PANEL_HTML ADD CONSTRAINT SQL170307175259960 FOREIGN KEY
	(ID_INSTANCE)
	REFERENCES JBPM.DASHB_PANEL_INSTANCE
	(DBID);

ALTER TABLE JBPM.DASHB_PANEL_HTML_I18N ADD CONSTRAINT SQL170307175300270 FOREIGN KEY
	(ID_TEXT)
	REFERENCES JBPM.DASHB_PANEL_HTML
	(DBID);

ALTER TABLE JBPM.DASHB_PANEL_INSTANCE ADD CONSTRAINT SQL170307175259360 FOREIGN KEY
	(ID_WORKSPACE)
	REFERENCES JBPM.DASHB_WORKSPACE
	(ID_WORKSPACE);

ALTER TABLE JBPM.DASHB_PANEL_PARAMETER ADD CONSTRAINT SQL170307175259760 FOREIGN KEY
	(ID_INSTANCE)
	REFERENCES JBPM.DASHB_PANEL_INSTANCE
	(DBID);

ALTER TABLE JBPM.DASHB_SECTION ADD CONSTRAINT SQL170307175258810 FOREIGN KEY
	(ID_WORKSPACE)
	REFERENCES JBPM.DASHB_WORKSPACE
	(ID_WORKSPACE)
	ON DELETE CASCADE;

ALTER TABLE JBPM.DASHB_SECTION_I18N ADD CONSTRAINT SQL170307175259010 FOREIGN KEY
	(ID_SECTION)
	REFERENCES JBPM.DASHB_SECTION
	(DBID);

ALTER TABLE JBPM.DASHB_WORKSPACE_HOME ADD CONSTRAINT SQL170307175257940 FOREIGN KEY
	(ID_WORKSPACE)
	REFERENCES JBPM.DASHB_WORKSPACE
	(ID_WORKSPACE)
	ON DELETE CASCADE;

ALTER TABLE JBPM.DASHB_WORKSPACE_PARAMETER ADD CONSTRAINT SQL170307175258300 FOREIGN KEY
	(ID_WORKSPACE)
	REFERENCES JBPM.DASHB_WORKSPACE
	(ID_WORKSPACE)
	ON DELETE CASCADE;

ALTER TABLE JBPM.DEADLINE ADD CONSTRAINT FK_68W742SGE00VCO2CQ3JHBVMGX FOREIGN KEY
	(DEADLINES_STARTDEADLINE_ID)
	REFERENCES JBPM.TASK
	(ID);

ALTER TABLE JBPM.DEADLINE ADD CONSTRAINT FK_EUOOHOELBQVV94D8A8RCG8S5N FOREIGN KEY
	(DEADLINES_ENDDEADLINE_ID)
	REFERENCES JBPM.TASK
	(ID);

ALTER TABLE JBPM.DELEGATION_DELEGATES ADD CONSTRAINT FK_FAJQ6KOSSBSQWR3OPKRCTXEI3 FOREIGN KEY
	(TASK_ID)
	REFERENCES JBPM.TASK
	(ID);

ALTER TABLE JBPM.DELEGATION_DELEGATES ADD CONSTRAINT FK_GN7ULA51SK55WJ1O1M57GUQXB FOREIGN KEY
	(ENTITY_ID)
	REFERENCES JBPM.ORGANIZATIONALENTITY
	(ID);

ALTER TABLE JBPM.ERRORINFO ADD CONSTRAINT FK_CMS0MET37GGFW5P5GCI3OTAQ0 FOREIGN KEY
	(REQUEST_ID)
	REFERENCES JBPM.REQUESTINFO
	(ID);

ALTER TABLE JBPM.ESCALATION ADD CONSTRAINT FK_AY2GD4FVL9YAAPVIYXUDWUVFG FOREIGN KEY
	(DEADLINE_ESCALATION_ID)
	REFERENCES JBPM.DEADLINE
	(ID);

ALTER TABLE JBPM.EVENTTYPES ADD CONSTRAINT FK_NRECJ4617IWXLC65IJ6M7LSL1 FOREIGN KEY
	(INSTANCEID)
	REFERENCES JBPM.PROCESSINSTANCEINFO
	(INSTANCEID);

ALTER TABLE JBPM.I18NTEXT ADD CONSTRAINT FK_21QVIFARXSVUXEAW5SXWH473W FOREIGN KEY
	(DEADLINE_DOCUMENTATION_ID)
	REFERENCES JBPM.DEADLINE
	(ID);

ALTER TABLE JBPM.I18NTEXT ADD CONSTRAINT FK_4EYFP69UCRRON2HR7QX4NP2FP FOREIGN KEY
	(TASK_DESCRIPTIONS_ID)
	REFERENCES JBPM.TASK
	(ID);

ALTER TABLE JBPM.I18NTEXT ADD CONSTRAINT FK_BW8VMPEKEJXT1EI2GE26GDSRY FOREIGN KEY
	(NOTIFICATION_DESCRIPTIONS_ID)
	REFERENCES JBPM.NOTIFICATION
	(ID);

ALTER TABLE JBPM.I18NTEXT ADD CONSTRAINT FK_FD9UK6HEMV2DX1OJOVO7MS3VP FOREIGN KEY
	(TASK_NAMES_ID)
	REFERENCES JBPM.TASK
	(ID);

ALTER TABLE JBPM.I18NTEXT ADD CONSTRAINT FK_G1TRXRI8W64ENUDW2T1QAHHK5 FOREIGN KEY
	(NOTIFICATION_NAMES_ID)
	REFERENCES JBPM.NOTIFICATION
	(ID);

ALTER TABLE JBPM.I18NTEXT ADD CONSTRAINT FK_K16JPGRH67TI9UEDF6KONSU1P FOREIGN KEY
	(TASK_SUBJECTS_ID)
	REFERENCES JBPM.TASK
	(ID);

ALTER TABLE JBPM.I18NTEXT ADD CONSTRAINT FK_O84RKH69R47TI8UV4EYJ7BMO2 FOREIGN KEY
	(NOTIFICATION_SUBJECTS_ID)
	REFERENCES JBPM.NOTIFICATION
	(ID);

ALTER TABLE JBPM.I18NTEXT ADD CONSTRAINT FK_PQARJVVNWFJPEYB87YD7M0BFI FOREIGN KEY
	(REASSIGNMENT_DOCUMENTATION_ID)
	REFERENCES JBPM.REASSIGNMENT
	(ID);

ALTER TABLE JBPM.I18NTEXT ADD CONSTRAINT FK_QOCE92C70ADEM3CCB3I7LEC8X FOREIGN KEY
	(NOTIFICATION_DOCUMENTATION_ID)
	REFERENCES JBPM.NOTIFICATION
	(ID);

ALTER TABLE JBPM.NOTIFICATION ADD CONSTRAINT FK_BDBEML3768GO5IM41CGFPYSO9 FOREIGN KEY
	(ESCALATION_NOTIFICATIONS_ID)
	REFERENCES JBPM.ESCALATION
	(ID);

ALTER TABLE JBPM.NOTIFICATION_BAS ADD CONSTRAINT FK_FC0UUY76T2BVXAXQYSOO8XTS7 FOREIGN KEY
	(TASK_ID)
	REFERENCES JBPM.NOTIFICATION
	(ID);

ALTER TABLE JBPM.NOTIFICATION_BAS ADD CONSTRAINT FK_MFBSNBRHTH4RJHQC2UD338S4I FOREIGN KEY
	(ENTITY_ID)
	REFERENCES JBPM.ORGANIZATIONALENTITY
	(ID);

ALTER TABLE JBPM.NOTIFICATION_EMAIL_HEADER ADD CONSTRAINT FK_ETH4NVXN21FK1VNJU85VKJRAI FOREIGN KEY
	(NOTIFICATION_ID)
	REFERENCES JBPM.NOTIFICATION
	(ID);

ALTER TABLE JBPM.NOTIFICATION_EMAIL_HEADER ADD CONSTRAINT FK_PTAKA5KOST68H7L3WFLV7W6Y8 FOREIGN KEY
	(EMAILHEADERS_ID)
	REFERENCES JBPM.EMAIL_HEADER
	(ID);

ALTER TABLE JBPM.NOTIFICATION_RECIPIENTS ADD CONSTRAINT FK_3L244PJ8SH78VTN9IMAYMRG47 FOREIGN KEY
	(TASK_ID)
	REFERENCES JBPM.NOTIFICATION
	(ID);

ALTER TABLE JBPM.NOTIFICATION_RECIPIENTS ADD CONSTRAINT FK_BLF9JSRUMTRTHDAQNPWXT25EU FOREIGN KEY
	(ENTITY_ID)
	REFERENCES JBPM.ORGANIZATIONALENTITY
	(ID);

ALTER TABLE JBPM.PEOPLEASSIGNMENTS_BAS ADD CONSTRAINT FK_OMJG5QH7UV8E9BOLBAQ7HV6OH FOREIGN KEY
	(TASK_ID)
	REFERENCES JBPM.TASK
	(ID);

ALTER TABLE JBPM.PEOPLEASSIGNMENTS_BAS ADD CONSTRAINT FK_T38XBKRQ6CPPIFNXEQUHVJSL2 FOREIGN KEY
	(ENTITY_ID)
	REFERENCES JBPM.ORGANIZATIONALENTITY
	(ID);

ALTER TABLE JBPM.PEOPLEASSIGNMENTS_EXCLOWNERS ADD CONSTRAINT FK_B8OWUXFRDNG050UGPK0PDOWA7 FOREIGN KEY
	(TASK_ID)
	REFERENCES JBPM.TASK
	(ID);

ALTER TABLE JBPM.PEOPLEASSIGNMENTS_EXCLOWNERS ADD CONSTRAINT FK_PTH28A73RJ6BXTLFC69KMQO0A FOREIGN KEY
	(ENTITY_ID)
	REFERENCES JBPM.ORGANIZATIONALENTITY
	(ID);

ALTER TABLE JBPM.PEOPLEASSIGNMENTS_POTOWNERS ADD CONSTRAINT FK_4DV2OJI7PR35RU0W45TRIX02X FOREIGN KEY
	(TASK_ID)
	REFERENCES JBPM.TASK
	(ID);

ALTER TABLE JBPM.PEOPLEASSIGNMENTS_POTOWNERS ADD CONSTRAINT FK_TEE3FTIR7XS6EO3FDVI3XW026 FOREIGN KEY
	(ENTITY_ID)
	REFERENCES JBPM.ORGANIZATIONALENTITY
	(ID);

ALTER TABLE JBPM.PEOPLEASSIGNMENTS_RECIPIENTS ADD CONSTRAINT FK_4G7Y3WX6GNOKF6VYCGPXS83D6 FOREIGN KEY
	(ENTITY_ID)
	REFERENCES JBPM.ORGANIZATIONALENTITY
	(ID);

ALTER TABLE JBPM.PEOPLEASSIGNMENTS_RECIPIENTS ADD CONSTRAINT FK_ENHK831FGHF6AKJILFN58OKL4 FOREIGN KEY
	(TASK_ID)
	REFERENCES JBPM.TASK
	(ID);

ALTER TABLE JBPM.PEOPLEASSIGNMENTS_STAKEHOLDERS ADD CONSTRAINT FK_4BH3AY74X6QL9USUNUBTTFDF1 FOREIGN KEY
	(TASK_ID)
	REFERENCES JBPM.TASK
	(ID);

ALTER TABLE JBPM.PEOPLEASSIGNMENTS_STAKEHOLDERS ADD CONSTRAINT FK_MET63INAEP6CQ4OFB3NNXI4TM FOREIGN KEY
	(ENTITY_ID)
	REFERENCES JBPM.ORGANIZATIONALENTITY
	(ID);

ALTER TABLE JBPM.REASSIGNMENT ADD CONSTRAINT FK_PNPEUE9HS6KX2EP0SP16B6KFD FOREIGN KEY
	(ESCALATION_REASSIGNMENTS_ID)
	REFERENCES JBPM.ESCALATION
	(ID);

ALTER TABLE JBPM.REASSIGNMENT_POTENTIALOWNERS ADD CONSTRAINT FK_8FRL6LA7TGPARLNUKHP8XMODY FOREIGN KEY
	(ENTITY_ID)
	REFERENCES JBPM.ORGANIZATIONALENTITY
	(ID);

ALTER TABLE JBPM.REASSIGNMENT_POTENTIALOWNERS ADD CONSTRAINT FK_QBEGA5NCU6B9YIGWLW55AEIJN FOREIGN KEY
	(TASK_ID)
	REFERENCES JBPM.REASSIGNMENT
	(ID);

ALTER TABLE JBPM.TASK ADD CONSTRAINT FK_DPK0F9UCM14C78BSXTHH7H8YH FOREIGN KEY
	(TASKINITIATOR_ID)
	REFERENCES JBPM.ORGANIZATIONALENTITY
	(ID);

ALTER TABLE JBPM.TASK ADD CONSTRAINT FK_K02OG0U71OBF1UXGCDJX9RCJC FOREIGN KEY
	(CREATEDBY_ID)
	REFERENCES JBPM.ORGANIZATIONALENTITY
	(ID);

ALTER TABLE JBPM.TASK ADD CONSTRAINT FK_NH9NNT47F3L61QJLYEDQT05RF FOREIGN KEY
	(ACTUALOWNER_ID)
	REFERENCES JBPM.ORGANIZATIONALENTITY
	(ID);

ALTER TABLE JBPM.TASK_COMMENT ADD CONSTRAINT FK_1WS9JDMHTEY6MXU7JB0R0UFVS FOREIGN KEY
	(TASKDATA_COMMENTS_ID)
	REFERENCES JBPM.TASK
	(ID);

ALTER TABLE JBPM.TASK_COMMENT ADD CONSTRAINT FK_AAX378YJNSMW9KB9VSU994JJV FOREIGN KEY
	(ADDEDBY_ID)
	REFERENCES JBPM.ORGANIZATIONALENTITY
	(ID);


CREATE SEQUENCE "JBPM"."HIBERNATE_SEQUENCE" AS INTEGER  START WITH 1000 INCREMENT BY 1 MINVALUE 1000 MAXVALUE 2147483647 NO CYCLE CACHE 20 NO ORDER;

