CREATE TABLE HT_COORDINATION_DATA (MESSAGE_ID VARCHAR2(255) NOT NULL, PROCESS_INSTANCE_ID VARCHAR2(255), PROTOCOL_HANDlER_URL VARCHAR2(255) NOT NULL, TASK_ID VARCHAR2(255), PRIMARY KEY (MESSAGE_ID));
CREATE TABLE HT_DEPLOYMENT_UNIT (id NUMBER NOT NULL, CHECKSUM VARCHAR2(255) NOT NULL, DEPLOYED_ON TIMESTAMP, DEPLOY_DIR VARCHAR2(255) NOT NULL, NAME VARCHAR2(255) NOT NULL, PACKAGE_NAME VARCHAR2(255) NOT NULL, STATUS VARCHAR2(255) NOT NULL, TENANT_ID NUMBER NOT NULL, VERSION NUMBER NOT NULL, PRIMARY KEY (id));
CREATE TABLE HT_VERSIONS (id NUMBER NOT NULL, TASK_VERSION NUMBER NOT NULL, PRIMARY KEY (id));
ALTER TABLE HT_TASK ADD PACKAGE_NAME VARCHAR(255);
ALTER TABLE HT_TASK ADD TASK_DEF_NAME VARCHAR(255);
ALTER TABLE HT_TASK ADD TASK_VERSION NUMBER;
