/
mysql-upgrade-3.3-3.4.sql
145 lines (123 loc) · 4.78 KB
/
mysql-upgrade-3.3-3.4.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
ALTER TABLE m_task
ADD wfEndTimestamp DATETIME(6),
ADD wfObjectRef_relation VARCHAR(157),
ADD wfObjectRef_targetOid VARCHAR(36),
ADD wfObjectRef_type INTEGER,
ADD wfProcessInstanceId VARCHAR(255),
ADD wfRequesterRef_relation VARCHAR(157),
ADD wfRequesterRef_targetOid VARCHAR(36),
ADD wfRequesterRef_type INTEGER,
ADD wfStartTimestamp DATETIME(6),
ADD wfTargetRef_relation VARCHAR(157),
ADD wfTargetRef_targetOid VARCHAR(36),
ADD wfTargetRef_type INTEGER;
CREATE INDEX iTaskWfProcessInstanceId ON m_task (wfProcessInstanceId);
CREATE INDEX iTaskWfStartTimestamp ON m_task (wfStartTimestamp);
CREATE INDEX iTaskWfEndTimestamp ON m_task (wfEndTimestamp);
CREATE INDEX iTaskWfRequesterOid ON m_task (wfRequesterRef_targetOid);
CREATE INDEX iTaskWfObjectOid ON m_task (wfObjectRef_targetOid);
CREATE INDEX iTaskWfTargetOid ON m_task (wfTargetRef_targetOid);
ALTER TABLE m_abstract_role
ADD ownerRef_relation VARCHAR(157),
ADD ownerRef_targetOid VARCHAR(36),
ADD ownerRef_type INTEGER;
ALTER TABLE m_acc_cert_campaign
ADD endTimestamp DATETIME(6),
ADD handlerUri VARCHAR(255),
ADD ownerRef_relation VARCHAR(157),
ADD ownerRef_targetOid VARCHAR(36),
ADD ownerRef_type INTEGER,
ADD stageNumber INTEGER,
ADD startTimestamp DATETIME(6),
ADD state INTEGER;
ALTER TABLE m_acc_cert_definition
ADD handlerUri VARCHAR(255),
ADD lastCampaignClosedTimestamp DATETIME(6),
ADD lastCampaignStartedTimestamp DATETIME(6),
ADD ownerRef_relation VARCHAR(157),
ADD ownerRef_targetOid VARCHAR(36),
ADD ownerRef_type INTEGER;
CREATE TABLE m_acc_cert_case (
id INTEGER NOT NULL,
owner_oid VARCHAR(36) NOT NULL,
administrativeStatus INTEGER,
archiveTimestamp DATETIME(6),
disableReason VARCHAR(255),
disableTimestamp DATETIME(6),
effectiveStatus INTEGER,
enableTimestamp DATETIME(6),
validFrom DATETIME(6),
validTo DATETIME(6),
validityChangeTimestamp DATETIME(6),
validityStatus INTEGER,
currentStageNumber INTEGER,
currentStageOutcome INTEGER,
fullObject LONGBLOB,
objectRef_relation VARCHAR(157),
objectRef_targetOid VARCHAR(36),
objectRef_type INTEGER,
orgRef_relation VARCHAR(157),
orgRef_targetOid VARCHAR(36),
orgRef_type INTEGER,
overallOutcome INTEGER,
remediedTimestamp DATETIME(6),
reviewDeadline DATETIME(6),
reviewRequestedTimestamp DATETIME(6),
targetRef_relation VARCHAR(157),
targetRef_targetOid VARCHAR(36),
targetRef_type INTEGER,
tenantRef_relation VARCHAR(157),
tenantRef_targetOid VARCHAR(36),
tenantRef_type INTEGER,
PRIMARY KEY (id, owner_oid)
)
DEFAULT CHARACTER SET utf8
COLLATE utf8_bin
ENGINE = InnoDB;
CREATE TABLE m_acc_cert_case_reference (
owner_id INTEGER NOT NULL,
owner_owner_oid VARCHAR(36) NOT NULL,
reference_type INTEGER NOT NULL,
relation VARCHAR(157) NOT NULL,
targetOid VARCHAR(36) NOT NULL,
containerType INTEGER,
PRIMARY KEY (owner_id, owner_owner_oid, reference_type, relation, targetOid)
)
DEFAULT CHARACTER SET utf8
COLLATE utf8_bin
ENGINE = InnoDB;
CREATE TABLE m_acc_cert_decision (
id INTEGER NOT NULL,
owner_id INTEGER NOT NULL,
owner_owner_oid VARCHAR(36) NOT NULL,
reviewerComment VARCHAR(255),
response INTEGER,
reviewerRef_relation VARCHAR(157),
reviewerRef_targetOid VARCHAR(36),
reviewerRef_type INTEGER,
stageNumber INTEGER NOT NULL,
timestamp DATETIME(6),
PRIMARY KEY (id, owner_id, owner_owner_oid)
)
DEFAULT CHARACTER SET utf8
COLLATE utf8_bin
ENGINE = InnoDB;
CREATE INDEX iCaseObjectRefTargetOid ON m_acc_cert_case (objectRef_targetOid);
CREATE INDEX iCaseTargetRefTargetOid ON m_acc_cert_case (targetRef_targetOid);
CREATE INDEX iCaseTenantRefTargetOid ON m_acc_cert_case (tenantRef_targetOid);
CREATE INDEX iCaseOrgRefTargetOid ON m_acc_cert_case (orgRef_targetOid);
CREATE INDEX iCaseReferenceTargetOid ON m_acc_cert_case_reference (targetOid);
ALTER TABLE m_acc_cert_decision
ADD CONSTRAINT uc_case_stage_reviewer UNIQUE (owner_owner_oid, owner_id, stageNumber, reviewerRef_targetOid);
ALTER TABLE m_acc_cert_case
ADD CONSTRAINT fk_acc_cert_case_owner
FOREIGN KEY (owner_oid)
REFERENCES m_object (oid);
ALTER TABLE m_acc_cert_case_reference
ADD CONSTRAINT fk_acc_cert_case_ref_owner
FOREIGN KEY (owner_id, owner_owner_oid)
REFERENCES m_acc_cert_case (id, owner_oid);
ALTER TABLE m_acc_cert_decision
ADD CONSTRAINT fk_acc_cert_decision_owner
FOREIGN KEY (owner_id, owner_owner_oid)
REFERENCES m_acc_cert_case (id, owner_oid);