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