1CREATE TABLE m_archetype ( 2 name_norm VARCHAR(255), 3 name_orig VARCHAR(255), 4 oid VARCHAR(36) NOT NULL, 5 PRIMARY KEY (oid) 6) 7 DEFAULT CHARACTER SET utf8 8 COLLATE utf8_bin 9 ENGINE = InnoDB; 10CREATE TABLE m_dashboard ( 11 name_norm VARCHAR(255), 12 name_orig VARCHAR(255), 13 oid VARCHAR(36) NOT NULL, 14 PRIMARY KEY (oid) 15) 16 DEFAULT CHARACTER SET utf8 17 COLLATE utf8_bin 18 ENGINE = InnoDB; 19 20CREATE INDEX iArchetypeNameOrig ON m_archetype(name_orig); 21CREATE INDEX iArchetypeNameNorm ON m_archetype(name_norm); 22 23CREATE INDEX iDashboardNameOrig 24 ON m_dashboard (name_orig); 25ALTER TABLE m_dashboard 26 ADD CONSTRAINT u_dashboard_name UNIQUE (name_norm); 27 28ALTER TABLE m_dashboard 29 ADD CONSTRAINT fk_dashboard FOREIGN KEY (oid) REFERENCES m_object (oid); 30 31ALTER TABLE m_archetype 32 ADD CONSTRAINT fk_archetype FOREIGN KEY (oid) REFERENCES m_abstract_role(oid); 33 34ALTER TABLE m_generic_object DROP FOREIGN KEY fk_generic_object; 35ALTER TABLE m_generic_object 36 ADD CONSTRAINT fk_generic_object FOREIGN KEY (oid) REFERENCES m_focus(oid); 37 38ALTER TABLE m_shadow ADD COLUMN primaryIdentifierValue VARCHAR(255); 39 40ALTER TABLE m_shadow 41 ADD CONSTRAINT iPrimaryIdentifierValueWithOC UNIQUE (primaryIdentifierValue, objectClass, resourceRef_targetOid); 42 43ALTER TABLE m_audit_event ADD COLUMN requestIdentifier VARCHAR(255); 44 45ALTER TABLE m_case ADD COLUMN 46 ( 47 parentRef_relation VARCHAR(157), 48 parentRef_targetOid VARCHAR(36), 49 parentRef_type INTEGER, 50 targetRef_relation VARCHAR(157), 51 targetRef_targetOid VARCHAR(36), 52 targetRef_type INTEGER 53 ); 54 55CREATE INDEX iCaseTypeObjectRefTargetOid ON m_case(objectRef_targetOid); 56CREATE INDEX iCaseTypeTargetRefTargetOid ON m_case(targetRef_targetOid); 57CREATE INDEX iCaseTypeParentRefTargetOid ON m_case(parentRef_targetOid); 58 59-- 2019-06-07 13:00 60 61DROP INDEX iTaskWfProcessInstanceId ON m_task; 62DROP INDEX iTaskWfStartTimestamp ON m_task; 63DROP INDEX iTaskWfEndTimestamp ON m_task; 64DROP INDEX iTaskWfRequesterOid ON m_task; 65DROP INDEX iTaskWfObjectOid ON m_task; 66DROP INDEX iTaskWfTargetOid ON m_task; 67CREATE INDEX iTaskObjectOid ON m_task(objectRef_targetOid); 68 69ALTER TABLE m_task DROP COLUMN canRunOnNode; 70ALTER TABLE m_task DROP COLUMN wfEndTimestamp; 71ALTER TABLE m_task DROP COLUMN wfObjectRef_relation; 72ALTER TABLE m_task DROP COLUMN wfObjectRef_targetOid; 73ALTER TABLE m_task DROP COLUMN wfObjectRef_type; 74ALTER TABLE m_task DROP COLUMN wfProcessInstanceId; 75ALTER TABLE m_task DROP COLUMN wfRequesterRef_relation; 76ALTER TABLE m_task DROP COLUMN wfRequesterRef_targetOid; 77ALTER TABLE m_task DROP COLUMN wfRequesterRef_type; 78ALTER TABLE m_task DROP COLUMN wfStartTimestamp; 79ALTER TABLE m_task DROP COLUMN wfTargetRef_relation; 80ALTER TABLE m_task DROP COLUMN wfTargetRef_targetOid; 81ALTER TABLE m_task DROP COLUMN wfTargetRef_type; 82 83ALTER TABLE m_case ADD COLUMN ( 84 closeTimestamp DATETIME(6), 85 requestorRef_relation VARCHAR(157), 86 requestorRef_targetOid VARCHAR(36), 87 requestorRef_type INTEGER 88 ); 89 90CREATE INDEX iCaseTypeRequestorRefTargetOid ON m_case(requestorRef_targetOid); 91CREATE INDEX iCaseTypeCloseTimestamp ON m_case(closeTimestamp); 92 93UPDATE m_global_metadata SET value = '4.0' WHERE name = 'databaseSchemaVersion'; 94 95-- 2019-06-25 09:00 96 97CREATE TABLE m_audit_resource ( 98 resourceOid VARCHAR(255) NOT NULL, 99 record_id BIGINT NOT NULL, 100 PRIMARY KEY (record_id, resourceOid) 101) DEFAULT CHARACTER SET utf8 102 COLLATE utf8_bin 103 ENGINE = InnoDB; 104 105CREATE INDEX iAuditResourceOid 106 ON m_audit_resource (resourceOid); 107CREATE INDEX iAuditResourceOidRecordId 108 ON m_audit_resource (record_id); 109ALTER TABLE m_audit_resource 110 ADD CONSTRAINT fk_audit_resource FOREIGN KEY (record_id) REFERENCES m_audit_event (id); 111 112-- 2019-08-30 12:32 113 114ALTER TABLE m_case_wi_reference ADD COLUMN reference_type INTEGER NOT NULL DEFAULT 0; 115 116ALTER TABLE m_case_wi_reference DROP PRIMARY KEY, ADD PRIMARY KEY(owner_owner_oid, owner_id, reference_type, targetOid, relation); 117 118ALTER TABLE m_assignment_extension DROP COLUMN booleansCount; 119ALTER TABLE m_assignment_extension DROP COLUMN datesCount; 120ALTER TABLE m_assignment_extension DROP COLUMN longsCount; 121ALTER TABLE m_assignment_extension DROP COLUMN polysCount; 122ALTER TABLE m_assignment_extension DROP COLUMN referencesCount; 123ALTER TABLE m_assignment_extension DROP COLUMN stringsCount; 124 125ALTER TABLE m_object DROP COLUMN booleansCount; 126ALTER TABLE m_object DROP COLUMN datesCount; 127ALTER TABLE m_object DROP COLUMN longsCount; 128ALTER TABLE m_object DROP COLUMN polysCount; 129ALTER TABLE m_object DROP COLUMN referencesCount; 130ALTER TABLE m_object DROP COLUMN stringsCount; 131 132DROP TABLE ACT_EVT_LOG; 133DROP TABLE ACT_GE_PROPERTY; 134DROP TABLE ACT_HI_ACTINST; 135DROP TABLE ACT_HI_ATTACHMENT; 136DROP TABLE ACT_HI_COMMENT; 137DROP TABLE ACT_HI_DETAIL; 138DROP TABLE ACT_HI_IDENTITYLINK; 139DROP TABLE ACT_HI_PROCINST; 140DROP TABLE ACT_HI_TASKINST; 141DROP TABLE ACT_HI_VARINST; 142DROP TABLE ACT_ID_INFO; 143DROP TABLE ACT_ID_MEMBERSHIP; 144DROP TABLE ACT_ID_GROUP; 145DROP TABLE ACT_ID_USER; 146DROP TABLE ACT_PROCDEF_INFO; 147DROP TABLE ACT_RE_MODEL; 148DROP TABLE ACT_RU_EVENT_SUBSCR; 149DROP TABLE ACT_RU_IDENTITYLINK; 150DROP TABLE ACT_RU_JOB; 151DROP TABLE ACT_RU_TASK; 152DROP TABLE ACT_RU_VARIABLE; 153DROP TABLE ACT_GE_BYTEARRAY; 154DROP TABLE ACT_RE_DEPLOYMENT; 155DROP TABLE ACT_RU_EXECUTION; 156DROP TABLE ACT_RE_PROCDEF; 157 158-- 2019-09-04 10:25 159 160ALTER TABLE m_case DROP INDEX uc_case_name; 161 162-- 2019-09-06 20:00 163 164ALTER TABLE m_case_wi ADD COLUMN createTimestamp DATETIME(6); 165 166COMMIT; 167