flow-script.sql 85 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643
  1. -- ----------------------------
  2. -- 如果是多租户工程,则需要在租户管理数据库中执行该脚本,既TENANT_ADMIN数据源类型指向的数据库。
  3. -- 这里包含流程引擎自带的数据表和自增序列,以及橙单工作流模块内置的zz_flow开头的数据表。
  4. -- ----------------------------
  5. SET NAMES utf8mb4;
  6. SET FOREIGN_KEY_CHECKS = 0;
  7. -- ----------------------------
  8. -- Table structure for ACT_EVT_LOG
  9. -- ----------------------------
  10. DROP TABLE IF EXISTS `ACT_EVT_LOG`;
  11. CREATE TABLE `ACT_EVT_LOG` (
  12. `LOG_NR_` bigint NOT NULL AUTO_INCREMENT,
  13. `TYPE_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  14. `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  15. `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  16. `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  17. `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  18. `TIME_STAMP_` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  19. `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  20. `DATA_` longblob,
  21. `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  22. `LOCK_TIME_` timestamp(3) NULL DEFAULT NULL,
  23. `IS_PROCESSED_` tinyint DEFAULT '0',
  24. PRIMARY KEY (`LOG_NR_`)
  25. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  26. -- ----------------------------
  27. -- Table structure for ACT_GE_BYTEARRAY
  28. -- ----------------------------
  29. DROP TABLE IF EXISTS `ACT_GE_BYTEARRAY`;
  30. CREATE TABLE `ACT_GE_BYTEARRAY` (
  31. `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  32. `REV_` int DEFAULT NULL,
  33. `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  34. `DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  35. `BYTES_` longblob,
  36. `GENERATED_` tinyint DEFAULT NULL,
  37. PRIMARY KEY (`ID_`),
  38. KEY `ACT_FK_BYTEARR_DEPL` (`DEPLOYMENT_ID_`),
  39. CONSTRAINT `ACT_FK_BYTEARR_DEPL` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `ACT_RE_DEPLOYMENT` (`ID_`)
  40. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  41. -- ----------------------------
  42. -- Table structure for ACT_GE_PROPERTY
  43. -- ----------------------------
  44. DROP TABLE IF EXISTS `ACT_GE_PROPERTY`;
  45. CREATE TABLE `ACT_GE_PROPERTY` (
  46. `NAME_` varchar(64) COLLATE utf8_bin NOT NULL,
  47. `VALUE_` varchar(300) COLLATE utf8_bin DEFAULT NULL,
  48. `REV_` int DEFAULT NULL,
  49. PRIMARY KEY (`NAME_`)
  50. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  51. -- ----------------------------
  52. -- Records of ACT_GE_PROPERTY
  53. -- ----------------------------
  54. BEGIN;
  55. INSERT INTO `ACT_GE_PROPERTY` VALUES ('batch.schema.version', '7.0.1.1', 1);
  56. INSERT INTO `ACT_GE_PROPERTY` VALUES ('cfg.execution-related-entities-count', 'true', 1);
  57. INSERT INTO `ACT_GE_PROPERTY` VALUES ('cfg.task-related-entities-count', 'true', 1);
  58. INSERT INTO `ACT_GE_PROPERTY` VALUES ('common.schema.version', '7.0.1.1', 1);
  59. INSERT INTO `ACT_GE_PROPERTY` VALUES ('entitylink.schema.version', '7.0.1.1', 1);
  60. INSERT INTO `ACT_GE_PROPERTY` VALUES ('eventsubscription.schema.version', '7.0.1.1', 1);
  61. INSERT INTO `ACT_GE_PROPERTY` VALUES ('identitylink.schema.version', '7.0.1.1', 1);
  62. INSERT INTO `ACT_GE_PROPERTY` VALUES ('job.schema.version', '7.0.1.1', 1);
  63. INSERT INTO `ACT_GE_PROPERTY` VALUES ('next.dbid', '1', 1);
  64. INSERT INTO `ACT_GE_PROPERTY` VALUES ('schema.history', 'create(7.0.1.1)', 1);
  65. INSERT INTO `ACT_GE_PROPERTY` VALUES ('schema.version', '7.0.1.1', 1);
  66. INSERT INTO `ACT_GE_PROPERTY` VALUES ('task.schema.version', '7.0.1.1', 1);
  67. INSERT INTO `ACT_GE_PROPERTY` VALUES ('variable.schema.version', '7.0.1.1', 1);
  68. COMMIT;
  69. -- ----------------------------
  70. -- Table structure for ACT_HI_ACTINST
  71. -- ----------------------------
  72. DROP TABLE IF EXISTS `ACT_HI_ACTINST`;
  73. CREATE TABLE `ACT_HI_ACTINST` (
  74. `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  75. `REV_` int DEFAULT '1',
  76. `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  77. `PROC_INST_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  78. `EXECUTION_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  79. `ACT_ID_` varchar(255) COLLATE utf8_bin NOT NULL,
  80. `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  81. `CALL_PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  82. `ACT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  83. `ACT_TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
  84. `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  85. `START_TIME_` datetime(3) NOT NULL,
  86. `END_TIME_` datetime(3) DEFAULT NULL,
  87. `TRANSACTION_ORDER_` int DEFAULT NULL,
  88. `DURATION_` bigint DEFAULT NULL,
  89. `DELETE_REASON_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  90. `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  91. PRIMARY KEY (`ID_`),
  92. KEY `ACT_IDX_HI_ACT_INST_START` (`START_TIME_`),
  93. KEY `ACT_IDX_HI_ACT_INST_END` (`END_TIME_`),
  94. KEY `ACT_IDX_HI_ACT_INST_PROCINST` (`PROC_INST_ID_`,`ACT_ID_`),
  95. KEY `ACT_IDX_HI_ACT_INST_EXEC` (`EXECUTION_ID_`,`ACT_ID_`)
  96. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  97. -- ----------------------------
  98. -- Table structure for ACT_HI_ATTACHMENT
  99. -- ----------------------------
  100. DROP TABLE IF EXISTS `ACT_HI_ATTACHMENT`;
  101. CREATE TABLE `ACT_HI_ATTACHMENT` (
  102. `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  103. `REV_` int DEFAULT NULL,
  104. `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  105. `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  106. `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  107. `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  108. `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  109. `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  110. `URL_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  111. `CONTENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  112. `TIME_` datetime(3) DEFAULT NULL,
  113. PRIMARY KEY (`ID_`)
  114. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  115. -- ----------------------------
  116. -- Table structure for ACT_HI_COMMENT
  117. -- ----------------------------
  118. DROP TABLE IF EXISTS `ACT_HI_COMMENT`;
  119. CREATE TABLE `ACT_HI_COMMENT` (
  120. `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  121. `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  122. `TIME_` datetime(3) NOT NULL,
  123. `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  124. `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  125. `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  126. `ACTION_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  127. `MESSAGE_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  128. `FULL_MSG_` longblob,
  129. PRIMARY KEY (`ID_`)
  130. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  131. -- ----------------------------
  132. -- Table structure for ACT_HI_DETAIL
  133. -- ----------------------------
  134. DROP TABLE IF EXISTS `ACT_HI_DETAIL`;
  135. CREATE TABLE `ACT_HI_DETAIL` (
  136. `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  137. `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
  138. `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  139. `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  140. `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  141. `ACT_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  142. `NAME_` varchar(255) COLLATE utf8_bin NOT NULL,
  143. `VAR_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  144. `REV_` int DEFAULT NULL,
  145. `TIME_` datetime(3) NOT NULL,
  146. `BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  147. `DOUBLE_` double DEFAULT NULL,
  148. `LONG_` bigint DEFAULT NULL,
  149. `TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  150. `TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  151. PRIMARY KEY (`ID_`),
  152. KEY `ACT_IDX_HI_DETAIL_PROC_INST` (`PROC_INST_ID_`),
  153. KEY `ACT_IDX_HI_DETAIL_ACT_INST` (`ACT_INST_ID_`),
  154. KEY `ACT_IDX_HI_DETAIL_TIME` (`TIME_`),
  155. KEY `ACT_IDX_HI_DETAIL_NAME` (`NAME_`),
  156. KEY `ACT_IDX_HI_DETAIL_TASK_ID` (`TASK_ID_`)
  157. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  158. -- ----------------------------
  159. -- Table structure for ACT_HI_ENTITYLINK
  160. -- ----------------------------
  161. DROP TABLE IF EXISTS `ACT_HI_ENTITYLINK`;
  162. CREATE TABLE `ACT_HI_ENTITYLINK` (
  163. `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  164. `LINK_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  165. `CREATE_TIME_` datetime(3) DEFAULT NULL,
  166. `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  167. `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  168. `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  169. `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  170. `PARENT_ELEMENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  171. `REF_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  172. `REF_SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  173. `REF_SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  174. `ROOT_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  175. `ROOT_SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  176. `HIERARCHY_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  177. PRIMARY KEY (`ID_`),
  178. KEY `ACT_IDX_HI_ENT_LNK_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`,`LINK_TYPE_`),
  179. KEY `ACT_IDX_HI_ENT_LNK_REF_SCOPE` (`REF_SCOPE_ID_`,`REF_SCOPE_TYPE_`,`LINK_TYPE_`),
  180. KEY `ACT_IDX_HI_ENT_LNK_ROOT_SCOPE` (`ROOT_SCOPE_ID_`,`ROOT_SCOPE_TYPE_`,`LINK_TYPE_`),
  181. KEY `ACT_IDX_HI_ENT_LNK_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`,`LINK_TYPE_`)
  182. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  183. -- ----------------------------
  184. -- Table structure for ACT_HI_IDENTITYLINK
  185. -- ----------------------------
  186. DROP TABLE IF EXISTS `ACT_HI_IDENTITYLINK`;
  187. CREATE TABLE `ACT_HI_IDENTITYLINK` (
  188. `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  189. `GROUP_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  190. `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  191. `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  192. `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  193. `CREATE_TIME_` datetime(3) DEFAULT NULL,
  194. `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  195. `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  196. `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  197. `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  198. `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  199. PRIMARY KEY (`ID_`),
  200. KEY `ACT_IDX_HI_IDENT_LNK_USER` (`USER_ID_`),
  201. KEY `ACT_IDX_HI_IDENT_LNK_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`),
  202. KEY `ACT_IDX_HI_IDENT_LNK_SUB_SCOPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`),
  203. KEY `ACT_IDX_HI_IDENT_LNK_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`),
  204. KEY `ACT_IDX_HI_IDENT_LNK_TASK` (`TASK_ID_`),
  205. KEY `ACT_IDX_HI_IDENT_LNK_PROCINST` (`PROC_INST_ID_`)
  206. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  207. -- ----------------------------
  208. -- Table structure for ACT_HI_PROCINST
  209. -- ----------------------------
  210. DROP TABLE IF EXISTS `ACT_HI_PROCINST`;
  211. CREATE TABLE `ACT_HI_PROCINST` (
  212. `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  213. `REV_` int DEFAULT '1',
  214. `PROC_INST_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  215. `BUSINESS_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  216. `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  217. `START_TIME_` datetime(3) NOT NULL,
  218. `END_TIME_` datetime(3) DEFAULT NULL,
  219. `DURATION_` bigint DEFAULT NULL,
  220. `START_USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  221. `START_ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  222. `END_ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  223. `SUPER_PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  224. `DELETE_REASON_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  225. `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  226. `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  227. `CALLBACK_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  228. `CALLBACK_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  229. `REFERENCE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  230. `REFERENCE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  231. `PROPAGATED_STAGE_INST_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  232. `BUSINESS_STATUS_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  233. PRIMARY KEY (`ID_`),
  234. UNIQUE KEY `PROC_INST_ID_` (`PROC_INST_ID_`),
  235. KEY `ACT_IDX_HI_PRO_INST_END` (`END_TIME_`),
  236. KEY `ACT_IDX_HI_PRO_I_BUSKEY` (`BUSINESS_KEY_`),
  237. KEY `ACT_IDX_HI_PRO_SUPER_PROCINST` (`SUPER_PROCESS_INSTANCE_ID_`)
  238. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  239. -- ----------------------------
  240. -- Table structure for ACT_HI_TASKINST
  241. -- ----------------------------
  242. DROP TABLE IF EXISTS `ACT_HI_TASKINST`;
  243. CREATE TABLE `ACT_HI_TASKINST` (
  244. `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  245. `REV_` int DEFAULT '1',
  246. `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  247. `TASK_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  248. `TASK_DEF_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  249. `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  250. `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  251. `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  252. `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  253. `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  254. `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  255. `PROPAGATED_STAGE_INST_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  256. `STATE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  257. `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  258. `PARENT_TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  259. `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  260. `OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  261. `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  262. `START_TIME_` datetime(3) NOT NULL,
  263. `IN_PROGRESS_TIME_` datetime(3) DEFAULT NULL,
  264. `IN_PROGRESS_STARTED_BY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  265. `CLAIM_TIME_` datetime(3) DEFAULT NULL,
  266. `CLAIMED_BY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  267. `SUSPENDED_TIME_` datetime(3) DEFAULT NULL,
  268. `SUSPENDED_BY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  269. `END_TIME_` datetime(3) DEFAULT NULL,
  270. `COMPLETED_BY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  271. `DURATION_` bigint DEFAULT NULL,
  272. `DELETE_REASON_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  273. `PRIORITY_` int DEFAULT NULL,
  274. `IN_PROGRESS_DUE_DATE_` datetime(3) DEFAULT NULL,
  275. `DUE_DATE_` datetime(3) DEFAULT NULL,
  276. `FORM_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  277. `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  278. `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  279. `LAST_UPDATED_TIME_` datetime(3) DEFAULT NULL,
  280. PRIMARY KEY (`ID_`),
  281. KEY `ACT_IDX_HI_TASK_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`),
  282. KEY `ACT_IDX_HI_TASK_SUB_SCOPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`),
  283. KEY `ACT_IDX_HI_TASK_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`),
  284. KEY `ACT_IDX_HI_TASK_INST_PROCINST` (`PROC_INST_ID_`)
  285. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  286. -- ----------------------------
  287. -- Table structure for ACT_HI_TSK_LOG
  288. -- ----------------------------
  289. DROP TABLE IF EXISTS `ACT_HI_TSK_LOG`;
  290. CREATE TABLE `ACT_HI_TSK_LOG` (
  291. `ID_` bigint NOT NULL AUTO_INCREMENT,
  292. `TYPE_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  293. `TASK_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  294. `TIME_STAMP_` timestamp(3) NOT NULL,
  295. `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  296. `DATA_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  297. `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  298. `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  299. `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  300. `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  301. `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  302. `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  303. `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  304. `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  305. PRIMARY KEY (`ID_`)
  306. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  307. -- ----------------------------
  308. -- Table structure for ACT_HI_VARINST
  309. -- ----------------------------
  310. DROP TABLE IF EXISTS `ACT_HI_VARINST`;
  311. CREATE TABLE `ACT_HI_VARINST` (
  312. `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  313. `REV_` int DEFAULT '1',
  314. `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  315. `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  316. `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  317. `NAME_` varchar(255) COLLATE utf8_bin NOT NULL,
  318. `VAR_TYPE_` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  319. `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  320. `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  321. `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  322. `BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  323. `DOUBLE_` double DEFAULT NULL,
  324. `LONG_` bigint DEFAULT NULL,
  325. `TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  326. `TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  327. `META_INFO_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  328. `CREATE_TIME_` datetime(3) DEFAULT NULL,
  329. `LAST_UPDATED_TIME_` datetime(3) DEFAULT NULL,
  330. PRIMARY KEY (`ID_`),
  331. KEY `ACT_IDX_HI_PROCVAR_NAME_TYPE` (`NAME_`,`VAR_TYPE_`),
  332. KEY `ACT_IDX_HI_VAR_SCOPE_ID_TYPE` (`SCOPE_ID_`,`SCOPE_TYPE_`),
  333. KEY `ACT_IDX_HI_VAR_SUB_ID_TYPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`),
  334. KEY `ACT_IDX_HI_PROCVAR_PROC_INST` (`PROC_INST_ID_`),
  335. KEY `ACT_IDX_HI_PROCVAR_TASK_ID` (`TASK_ID_`),
  336. KEY `ACT_IDX_HI_PROCVAR_EXE` (`EXECUTION_ID_`)
  337. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  338. -- ----------------------------
  339. -- Table structure for ACT_ID_BYTEARRAY
  340. -- ----------------------------
  341. DROP TABLE IF EXISTS `ACT_ID_BYTEARRAY`;
  342. CREATE TABLE `ACT_ID_BYTEARRAY` (
  343. `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  344. `REV_` int DEFAULT NULL,
  345. `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  346. `BYTES_` longblob,
  347. PRIMARY KEY (`ID_`)
  348. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  349. -- ----------------------------
  350. -- Table structure for ACT_ID_GROUP
  351. -- ----------------------------
  352. DROP TABLE IF EXISTS `ACT_ID_GROUP`;
  353. CREATE TABLE `ACT_ID_GROUP` (
  354. `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  355. `REV_` int DEFAULT NULL,
  356. `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  357. `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  358. PRIMARY KEY (`ID_`)
  359. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  360. -- ----------------------------
  361. -- Table structure for ACT_ID_INFO
  362. -- ----------------------------
  363. DROP TABLE IF EXISTS `ACT_ID_INFO`;
  364. CREATE TABLE `ACT_ID_INFO` (
  365. `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  366. `REV_` int DEFAULT NULL,
  367. `USER_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  368. `TYPE_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  369. `KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  370. `VALUE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  371. `PASSWORD_` longblob,
  372. `PARENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  373. PRIMARY KEY (`ID_`)
  374. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  375. -- ----------------------------
  376. -- Table structure for ACT_ID_MEMBERSHIP
  377. -- ----------------------------
  378. DROP TABLE IF EXISTS `ACT_ID_MEMBERSHIP`;
  379. CREATE TABLE `ACT_ID_MEMBERSHIP` (
  380. `USER_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  381. `GROUP_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  382. PRIMARY KEY (`USER_ID_`,`GROUP_ID_`),
  383. KEY `ACT_FK_MEMB_GROUP` (`GROUP_ID_`),
  384. CONSTRAINT `ACT_FK_MEMB_GROUP` FOREIGN KEY (`GROUP_ID_`) REFERENCES `ACT_ID_GROUP` (`ID_`),
  385. CONSTRAINT `ACT_FK_MEMB_USER` FOREIGN KEY (`USER_ID_`) REFERENCES `ACT_ID_USER` (`ID_`)
  386. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  387. -- ----------------------------
  388. -- Table structure for ACT_ID_PRIV
  389. -- ----------------------------
  390. DROP TABLE IF EXISTS `ACT_ID_PRIV`;
  391. CREATE TABLE `ACT_ID_PRIV` (
  392. `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  393. `NAME_` varchar(255) COLLATE utf8_bin NOT NULL,
  394. PRIMARY KEY (`ID_`),
  395. UNIQUE KEY `ACT_UNIQ_PRIV_NAME` (`NAME_`)
  396. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  397. -- ----------------------------
  398. -- Table structure for ACT_ID_PRIV_MAPPING
  399. -- ----------------------------
  400. DROP TABLE IF EXISTS `ACT_ID_PRIV_MAPPING`;
  401. CREATE TABLE `ACT_ID_PRIV_MAPPING` (
  402. `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  403. `PRIV_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  404. `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  405. `GROUP_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  406. PRIMARY KEY (`ID_`),
  407. KEY `ACT_FK_PRIV_MAPPING` (`PRIV_ID_`),
  408. KEY `ACT_IDX_PRIV_USER` (`USER_ID_`),
  409. KEY `ACT_IDX_PRIV_GROUP` (`GROUP_ID_`),
  410. CONSTRAINT `ACT_FK_PRIV_MAPPING` FOREIGN KEY (`PRIV_ID_`) REFERENCES `ACT_ID_PRIV` (`ID_`)
  411. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  412. -- ----------------------------
  413. -- Table structure for ACT_ID_PROPERTY
  414. -- ----------------------------
  415. DROP TABLE IF EXISTS `ACT_ID_PROPERTY`;
  416. CREATE TABLE `ACT_ID_PROPERTY` (
  417. `NAME_` varchar(64) COLLATE utf8_bin NOT NULL,
  418. `VALUE_` varchar(300) COLLATE utf8_bin DEFAULT NULL,
  419. `REV_` int DEFAULT NULL,
  420. PRIMARY KEY (`NAME_`)
  421. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  422. -- ----------------------------
  423. -- Records of ACT_ID_PROPERTY
  424. -- ----------------------------
  425. BEGIN;
  426. INSERT INTO `ACT_ID_PROPERTY` VALUES ('schema.version', '7.0.1.1', 1);
  427. COMMIT;
  428. -- ----------------------------
  429. -- Table structure for ACT_ID_TOKEN
  430. -- ----------------------------
  431. DROP TABLE IF EXISTS `ACT_ID_TOKEN`;
  432. CREATE TABLE `ACT_ID_TOKEN` (
  433. `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  434. `REV_` int DEFAULT NULL,
  435. `TOKEN_VALUE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  436. `TOKEN_DATE_` timestamp(3) NULL DEFAULT NULL,
  437. `IP_ADDRESS_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  438. `USER_AGENT_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  439. `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  440. `TOKEN_DATA_` varchar(2000) COLLATE utf8_bin DEFAULT NULL,
  441. PRIMARY KEY (`ID_`)
  442. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  443. -- ----------------------------
  444. -- Table structure for ACT_ID_USER
  445. -- ----------------------------
  446. DROP TABLE IF EXISTS `ACT_ID_USER`;
  447. CREATE TABLE `ACT_ID_USER` (
  448. `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  449. `REV_` int DEFAULT NULL,
  450. `FIRST_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  451. `LAST_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  452. `DISPLAY_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  453. `EMAIL_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  454. `PWD_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  455. `PICTURE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  456. `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  457. PRIMARY KEY (`ID_`)
  458. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  459. -- ----------------------------
  460. -- Table structure for ACT_PROCDEF_INFO
  461. -- ----------------------------
  462. DROP TABLE IF EXISTS `ACT_PROCDEF_INFO`;
  463. CREATE TABLE `ACT_PROCDEF_INFO` (
  464. `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  465. `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  466. `REV_` int DEFAULT NULL,
  467. `INFO_JSON_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  468. PRIMARY KEY (`ID_`),
  469. UNIQUE KEY `ACT_UNIQ_INFO_PROCDEF` (`PROC_DEF_ID_`),
  470. KEY `ACT_IDX_INFO_PROCDEF` (`PROC_DEF_ID_`),
  471. KEY `ACT_FK_INFO_JSON_BA` (`INFO_JSON_ID_`),
  472. CONSTRAINT `ACT_FK_INFO_JSON_BA` FOREIGN KEY (`INFO_JSON_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`),
  473. CONSTRAINT `ACT_FK_INFO_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`)
  474. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  475. -- ----------------------------
  476. -- Table structure for ACT_RE_DEPLOYMENT
  477. -- ----------------------------
  478. DROP TABLE IF EXISTS `ACT_RE_DEPLOYMENT`;
  479. CREATE TABLE `ACT_RE_DEPLOYMENT` (
  480. `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  481. `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  482. `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  483. `KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  484. `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  485. `DEPLOY_TIME_` timestamp(3) NULL DEFAULT NULL,
  486. `DERIVED_FROM_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  487. `DERIVED_FROM_ROOT_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  488. `PARENT_DEPLOYMENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  489. `ENGINE_VERSION_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  490. PRIMARY KEY (`ID_`)
  491. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  492. -- ----------------------------
  493. -- Table structure for ACT_RE_MODEL
  494. -- ----------------------------
  495. DROP TABLE IF EXISTS `ACT_RE_MODEL`;
  496. CREATE TABLE `ACT_RE_MODEL` (
  497. `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  498. `REV_` int DEFAULT NULL,
  499. `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  500. `KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  501. `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  502. `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL,
  503. `LAST_UPDATE_TIME_` timestamp(3) NULL DEFAULT NULL,
  504. `VERSION_` int DEFAULT NULL,
  505. `META_INFO_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  506. `DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  507. `EDITOR_SOURCE_VALUE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  508. `EDITOR_SOURCE_EXTRA_VALUE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  509. `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  510. PRIMARY KEY (`ID_`),
  511. KEY `ACT_FK_MODEL_SOURCE` (`EDITOR_SOURCE_VALUE_ID_`),
  512. KEY `ACT_FK_MODEL_SOURCE_EXTRA` (`EDITOR_SOURCE_EXTRA_VALUE_ID_`),
  513. KEY `ACT_FK_MODEL_DEPLOYMENT` (`DEPLOYMENT_ID_`),
  514. CONSTRAINT `ACT_FK_MODEL_DEPLOYMENT` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `ACT_RE_DEPLOYMENT` (`ID_`),
  515. CONSTRAINT `ACT_FK_MODEL_SOURCE` FOREIGN KEY (`EDITOR_SOURCE_VALUE_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`),
  516. CONSTRAINT `ACT_FK_MODEL_SOURCE_EXTRA` FOREIGN KEY (`EDITOR_SOURCE_EXTRA_VALUE_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`)
  517. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  518. -- ----------------------------
  519. -- Table structure for ACT_RE_PROCDEF
  520. -- ----------------------------
  521. DROP TABLE IF EXISTS `ACT_RE_PROCDEF`;
  522. CREATE TABLE `ACT_RE_PROCDEF` (
  523. `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  524. `REV_` int DEFAULT NULL,
  525. `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  526. `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  527. `KEY_` varchar(255) COLLATE utf8_bin NOT NULL,
  528. `VERSION_` int NOT NULL,
  529. `DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  530. `RESOURCE_NAME_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  531. `DGRM_RESOURCE_NAME_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  532. `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  533. `HAS_START_FORM_KEY_` tinyint DEFAULT NULL,
  534. `HAS_GRAPHICAL_NOTATION_` tinyint DEFAULT NULL,
  535. `SUSPENSION_STATE_` int DEFAULT NULL,
  536. `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  537. `ENGINE_VERSION_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  538. `DERIVED_FROM_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  539. `DERIVED_FROM_ROOT_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  540. `DERIVED_VERSION_` int NOT NULL DEFAULT '0',
  541. PRIMARY KEY (`ID_`),
  542. UNIQUE KEY `ACT_UNIQ_PROCDEF` (`KEY_`,`VERSION_`,`DERIVED_VERSION_`,`TENANT_ID_`)
  543. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  544. -- ----------------------------
  545. -- Table structure for ACT_RU_ACTINST
  546. -- ----------------------------
  547. DROP TABLE IF EXISTS `ACT_RU_ACTINST`;
  548. CREATE TABLE `ACT_RU_ACTINST` (
  549. `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  550. `REV_` int DEFAULT '1',
  551. `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  552. `PROC_INST_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  553. `EXECUTION_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  554. `ACT_ID_` varchar(255) COLLATE utf8_bin NOT NULL,
  555. `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  556. `CALL_PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  557. `ACT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  558. `ACT_TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
  559. `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  560. `START_TIME_` datetime(3) NOT NULL,
  561. `END_TIME_` datetime(3) DEFAULT NULL,
  562. `DURATION_` bigint DEFAULT NULL,
  563. `TRANSACTION_ORDER_` int DEFAULT NULL,
  564. `DELETE_REASON_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  565. `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  566. PRIMARY KEY (`ID_`),
  567. KEY `ACT_IDX_RU_ACTI_START` (`START_TIME_`),
  568. KEY `ACT_IDX_RU_ACTI_END` (`END_TIME_`),
  569. KEY `ACT_IDX_RU_ACTI_PROC` (`PROC_INST_ID_`),
  570. KEY `ACT_IDX_RU_ACTI_PROC_ACT` (`PROC_INST_ID_`,`ACT_ID_`),
  571. KEY `ACT_IDX_RU_ACTI_EXEC` (`EXECUTION_ID_`),
  572. KEY `ACT_IDX_RU_ACTI_EXEC_ACT` (`EXECUTION_ID_`,`ACT_ID_`),
  573. KEY `ACT_IDX_RU_ACTI_TASK` (`TASK_ID_`)
  574. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  575. -- ----------------------------
  576. -- Table structure for ACT_RU_DEADLETTER_JOB
  577. -- ----------------------------
  578. DROP TABLE IF EXISTS `ACT_RU_DEADLETTER_JOB`;
  579. CREATE TABLE `ACT_RU_DEADLETTER_JOB` (
  580. `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  581. `REV_` int DEFAULT NULL,
  582. `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  583. `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
  584. `EXCLUSIVE_` tinyint(1) DEFAULT NULL,
  585. `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  586. `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  587. `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  588. `ELEMENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  589. `ELEMENT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  590. `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  591. `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  592. `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  593. `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  594. `CORRELATION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  595. `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  596. `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  597. `DUEDATE_` timestamp(3) NULL DEFAULT NULL,
  598. `REPEAT_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  599. `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  600. `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  601. `CUSTOM_VALUES_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  602. `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL,
  603. `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  604. PRIMARY KEY (`ID_`),
  605. KEY `ACT_IDX_DEADLETTER_JOB_EXCEPTION_STACK_ID` (`EXCEPTION_STACK_ID_`),
  606. KEY `ACT_IDX_DEADLETTER_JOB_CUSTOM_VALUES_ID` (`CUSTOM_VALUES_ID_`),
  607. KEY `ACT_IDX_DEADLETTER_JOB_CORRELATION_ID` (`CORRELATION_ID_`),
  608. KEY `ACT_IDX_DJOB_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`),
  609. KEY `ACT_IDX_DJOB_SUB_SCOPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`),
  610. KEY `ACT_IDX_DJOB_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`),
  611. KEY `ACT_FK_DEADLETTER_JOB_EXECUTION` (`EXECUTION_ID_`),
  612. KEY `ACT_FK_DEADLETTER_JOB_PROCESS_INSTANCE` (`PROCESS_INSTANCE_ID_`),
  613. KEY `ACT_FK_DEADLETTER_JOB_PROC_DEF` (`PROC_DEF_ID_`),
  614. CONSTRAINT `ACT_FK_DEADLETTER_JOB_CUSTOM_VALUES` FOREIGN KEY (`CUSTOM_VALUES_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`),
  615. CONSTRAINT `ACT_FK_DEADLETTER_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`),
  616. CONSTRAINT `ACT_FK_DEADLETTER_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`),
  617. CONSTRAINT `ACT_FK_DEADLETTER_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`),
  618. CONSTRAINT `ACT_FK_DEADLETTER_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`)
  619. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  620. -- ----------------------------
  621. -- Table structure for ACT_RU_ENTITYLINK
  622. -- ----------------------------
  623. DROP TABLE IF EXISTS `ACT_RU_ENTITYLINK`;
  624. CREATE TABLE `ACT_RU_ENTITYLINK` (
  625. `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  626. `REV_` int DEFAULT NULL,
  627. `CREATE_TIME_` datetime(3) DEFAULT NULL,
  628. `LINK_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  629. `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  630. `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  631. `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  632. `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  633. `PARENT_ELEMENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  634. `REF_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  635. `REF_SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  636. `REF_SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  637. `ROOT_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  638. `ROOT_SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  639. `HIERARCHY_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  640. PRIMARY KEY (`ID_`),
  641. KEY `ACT_IDX_ENT_LNK_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`,`LINK_TYPE_`),
  642. KEY `ACT_IDX_ENT_LNK_REF_SCOPE` (`REF_SCOPE_ID_`,`REF_SCOPE_TYPE_`,`LINK_TYPE_`),
  643. KEY `ACT_IDX_ENT_LNK_ROOT_SCOPE` (`ROOT_SCOPE_ID_`,`ROOT_SCOPE_TYPE_`,`LINK_TYPE_`),
  644. KEY `ACT_IDX_ENT_LNK_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`,`LINK_TYPE_`)
  645. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  646. -- ----------------------------
  647. -- Table structure for ACT_RU_EVENT_SUBSCR
  648. -- ----------------------------
  649. DROP TABLE IF EXISTS `ACT_RU_EVENT_SUBSCR`;
  650. CREATE TABLE `ACT_RU_EVENT_SUBSCR` (
  651. `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  652. `REV_` int DEFAULT NULL,
  653. `EVENT_TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
  654. `EVENT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  655. `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  656. `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  657. `ACTIVITY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  658. `CONFIGURATION_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  659. `CREATED_` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  660. `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  661. `SUB_SCOPE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  662. `SCOPE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  663. `SCOPE_DEFINITION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  664. `SCOPE_DEFINITION_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  665. `SCOPE_TYPE_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  666. `LOCK_TIME_` timestamp(3) NULL DEFAULT NULL,
  667. `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  668. `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  669. PRIMARY KEY (`ID_`),
  670. KEY `ACT_IDX_EVENT_SUBSCR_CONFIG_` (`CONFIGURATION_`),
  671. KEY `ACT_IDX_EVENT_SUBSCR_SCOPEREF_` (`SCOPE_ID_`,`SCOPE_TYPE_`),
  672. KEY `ACT_FK_EVENT_EXEC` (`EXECUTION_ID_`),
  673. CONSTRAINT `ACT_FK_EVENT_EXEC` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`)
  674. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  675. -- ----------------------------
  676. -- Table structure for ACT_RU_EXECUTION
  677. -- ----------------------------
  678. DROP TABLE IF EXISTS `ACT_RU_EXECUTION`;
  679. CREATE TABLE `ACT_RU_EXECUTION` (
  680. `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  681. `REV_` int DEFAULT NULL,
  682. `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  683. `BUSINESS_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  684. `PARENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  685. `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  686. `SUPER_EXEC_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  687. `ROOT_PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  688. `ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  689. `IS_ACTIVE_` tinyint DEFAULT NULL,
  690. `IS_CONCURRENT_` tinyint DEFAULT NULL,
  691. `IS_SCOPE_` tinyint DEFAULT NULL,
  692. `IS_EVENT_SCOPE_` tinyint DEFAULT NULL,
  693. `IS_MI_ROOT_` tinyint DEFAULT NULL,
  694. `SUSPENSION_STATE_` int DEFAULT NULL,
  695. `CACHED_ENT_STATE_` int DEFAULT NULL,
  696. `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  697. `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  698. `START_ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  699. `START_TIME_` datetime(3) DEFAULT NULL,
  700. `START_USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  701. `LOCK_TIME_` timestamp(3) NULL DEFAULT NULL,
  702. `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  703. `IS_COUNT_ENABLED_` tinyint DEFAULT NULL,
  704. `EVT_SUBSCR_COUNT_` int DEFAULT NULL,
  705. `TASK_COUNT_` int DEFAULT NULL,
  706. `JOB_COUNT_` int DEFAULT NULL,
  707. `TIMER_JOB_COUNT_` int DEFAULT NULL,
  708. `SUSP_JOB_COUNT_` int DEFAULT NULL,
  709. `DEADLETTER_JOB_COUNT_` int DEFAULT NULL,
  710. `EXTERNAL_WORKER_JOB_COUNT_` int DEFAULT NULL,
  711. `VAR_COUNT_` int DEFAULT NULL,
  712. `ID_LINK_COUNT_` int DEFAULT NULL,
  713. `CALLBACK_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  714. `CALLBACK_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  715. `REFERENCE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  716. `REFERENCE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  717. `PROPAGATED_STAGE_INST_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  718. `BUSINESS_STATUS_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  719. PRIMARY KEY (`ID_`),
  720. KEY `ACT_IDX_EXEC_BUSKEY` (`BUSINESS_KEY_`),
  721. KEY `ACT_IDC_EXEC_ROOT` (`ROOT_PROC_INST_ID_`),
  722. KEY `ACT_IDX_EXEC_REF_ID_` (`REFERENCE_ID_`),
  723. KEY `ACT_FK_EXE_PROCINST` (`PROC_INST_ID_`),
  724. KEY `ACT_FK_EXE_PARENT` (`PARENT_ID_`),
  725. KEY `ACT_FK_EXE_SUPER` (`SUPER_EXEC_`),
  726. KEY `ACT_FK_EXE_PROCDEF` (`PROC_DEF_ID_`),
  727. CONSTRAINT `ACT_FK_EXE_PARENT` FOREIGN KEY (`PARENT_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) ON DELETE CASCADE,
  728. CONSTRAINT `ACT_FK_EXE_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`),
  729. CONSTRAINT `ACT_FK_EXE_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) ON DELETE CASCADE ON UPDATE CASCADE,
  730. CONSTRAINT `ACT_FK_EXE_SUPER` FOREIGN KEY (`SUPER_EXEC_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) ON DELETE CASCADE
  731. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  732. -- ----------------------------
  733. -- Table structure for ACT_RU_EXTERNAL_JOB
  734. -- ----------------------------
  735. DROP TABLE IF EXISTS `ACT_RU_EXTERNAL_JOB`;
  736. CREATE TABLE `ACT_RU_EXTERNAL_JOB` (
  737. `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  738. `REV_` int DEFAULT NULL,
  739. `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  740. `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
  741. `LOCK_EXP_TIME_` timestamp(3) NULL DEFAULT NULL,
  742. `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  743. `EXCLUSIVE_` tinyint(1) DEFAULT NULL,
  744. `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  745. `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  746. `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  747. `ELEMENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  748. `ELEMENT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  749. `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  750. `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  751. `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  752. `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  753. `CORRELATION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  754. `RETRIES_` int DEFAULT NULL,
  755. `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  756. `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  757. `DUEDATE_` timestamp(3) NULL DEFAULT NULL,
  758. `REPEAT_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  759. `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  760. `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  761. `CUSTOM_VALUES_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  762. `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL,
  763. `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  764. PRIMARY KEY (`ID_`),
  765. KEY `ACT_IDX_EXTERNAL_JOB_EXCEPTION_STACK_ID` (`EXCEPTION_STACK_ID_`),
  766. KEY `ACT_IDX_EXTERNAL_JOB_CUSTOM_VALUES_ID` (`CUSTOM_VALUES_ID_`),
  767. KEY `ACT_IDX_EXTERNAL_JOB_CORRELATION_ID` (`CORRELATION_ID_`),
  768. KEY `ACT_IDX_EJOB_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`),
  769. KEY `ACT_IDX_EJOB_SUB_SCOPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`),
  770. KEY `ACT_IDX_EJOB_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`),
  771. CONSTRAINT `ACT_FK_EXTERNAL_JOB_CUSTOM_VALUES` FOREIGN KEY (`CUSTOM_VALUES_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`),
  772. CONSTRAINT `ACT_FK_EXTERNAL_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`)
  773. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  774. -- ----------------------------
  775. -- Table structure for ACT_RU_HISTORY_JOB
  776. -- ----------------------------
  777. DROP TABLE IF EXISTS `ACT_RU_HISTORY_JOB`;
  778. CREATE TABLE `ACT_RU_HISTORY_JOB` (
  779. `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  780. `REV_` int DEFAULT NULL,
  781. `LOCK_EXP_TIME_` timestamp(3) NULL DEFAULT NULL,
  782. `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  783. `RETRIES_` int DEFAULT NULL,
  784. `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  785. `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  786. `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  787. `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  788. `CUSTOM_VALUES_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  789. `ADV_HANDLER_CFG_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  790. `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL,
  791. `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  792. `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  793. PRIMARY KEY (`ID_`)
  794. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  795. -- ----------------------------
  796. -- Table structure for ACT_RU_IDENTITYLINK
  797. -- ----------------------------
  798. DROP TABLE IF EXISTS `ACT_RU_IDENTITYLINK`;
  799. CREATE TABLE `ACT_RU_IDENTITYLINK` (
  800. `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  801. `REV_` int DEFAULT NULL,
  802. `GROUP_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  803. `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  804. `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  805. `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  806. `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  807. `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  808. `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  809. `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  810. `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  811. `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  812. PRIMARY KEY (`ID_`),
  813. KEY `ACT_IDX_IDENT_LNK_USER` (`USER_ID_`),
  814. KEY `ACT_IDX_IDENT_LNK_GROUP` (`GROUP_ID_`),
  815. KEY `ACT_IDX_IDENT_LNK_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`),
  816. KEY `ACT_IDX_IDENT_LNK_SUB_SCOPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`),
  817. KEY `ACT_IDX_IDENT_LNK_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`),
  818. KEY `ACT_IDX_ATHRZ_PROCEDEF` (`PROC_DEF_ID_`),
  819. KEY `ACT_FK_TSKASS_TASK` (`TASK_ID_`),
  820. KEY `ACT_FK_IDL_PROCINST` (`PROC_INST_ID_`),
  821. CONSTRAINT `ACT_FK_ATHRZ_PROCEDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`),
  822. CONSTRAINT `ACT_FK_IDL_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`),
  823. CONSTRAINT `ACT_FK_TSKASS_TASK` FOREIGN KEY (`TASK_ID_`) REFERENCES `ACT_RU_TASK` (`ID_`)
  824. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  825. -- ----------------------------
  826. -- Table structure for ACT_RU_JOB
  827. -- ----------------------------
  828. DROP TABLE IF EXISTS `ACT_RU_JOB`;
  829. CREATE TABLE `ACT_RU_JOB` (
  830. `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  831. `REV_` int DEFAULT NULL,
  832. `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  833. `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
  834. `LOCK_EXP_TIME_` timestamp(3) NULL DEFAULT NULL,
  835. `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  836. `EXCLUSIVE_` tinyint(1) DEFAULT NULL,
  837. `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  838. `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  839. `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  840. `ELEMENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  841. `ELEMENT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  842. `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  843. `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  844. `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  845. `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  846. `CORRELATION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  847. `RETRIES_` int DEFAULT NULL,
  848. `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  849. `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  850. `DUEDATE_` timestamp(3) NULL DEFAULT NULL,
  851. `REPEAT_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  852. `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  853. `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  854. `CUSTOM_VALUES_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  855. `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL,
  856. `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  857. PRIMARY KEY (`ID_`),
  858. KEY `ACT_IDX_JOB_EXCEPTION_STACK_ID` (`EXCEPTION_STACK_ID_`),
  859. KEY `ACT_IDX_JOB_CUSTOM_VALUES_ID` (`CUSTOM_VALUES_ID_`),
  860. KEY `ACT_IDX_JOB_CORRELATION_ID` (`CORRELATION_ID_`),
  861. KEY `ACT_IDX_JOB_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`),
  862. KEY `ACT_IDX_JOB_SUB_SCOPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`),
  863. KEY `ACT_IDX_JOB_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`),
  864. KEY `ACT_FK_JOB_EXECUTION` (`EXECUTION_ID_`),
  865. KEY `ACT_FK_JOB_PROCESS_INSTANCE` (`PROCESS_INSTANCE_ID_`),
  866. KEY `ACT_FK_JOB_PROC_DEF` (`PROC_DEF_ID_`),
  867. CONSTRAINT `ACT_FK_JOB_CUSTOM_VALUES` FOREIGN KEY (`CUSTOM_VALUES_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`),
  868. CONSTRAINT `ACT_FK_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`),
  869. CONSTRAINT `ACT_FK_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`),
  870. CONSTRAINT `ACT_FK_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`),
  871. CONSTRAINT `ACT_FK_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`)
  872. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  873. -- ----------------------------
  874. -- Table structure for ACT_RU_SUSPENDED_JOB
  875. -- ----------------------------
  876. DROP TABLE IF EXISTS `ACT_RU_SUSPENDED_JOB`;
  877. CREATE TABLE `ACT_RU_SUSPENDED_JOB` (
  878. `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  879. `REV_` int DEFAULT NULL,
  880. `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  881. `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
  882. `EXCLUSIVE_` tinyint(1) DEFAULT NULL,
  883. `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  884. `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  885. `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  886. `ELEMENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  887. `ELEMENT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  888. `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  889. `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  890. `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  891. `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  892. `CORRELATION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  893. `RETRIES_` int DEFAULT NULL,
  894. `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  895. `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  896. `DUEDATE_` timestamp(3) NULL DEFAULT NULL,
  897. `REPEAT_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  898. `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  899. `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  900. `CUSTOM_VALUES_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  901. `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL,
  902. `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  903. PRIMARY KEY (`ID_`),
  904. KEY `ACT_IDX_SUSPENDED_JOB_EXCEPTION_STACK_ID` (`EXCEPTION_STACK_ID_`),
  905. KEY `ACT_IDX_SUSPENDED_JOB_CUSTOM_VALUES_ID` (`CUSTOM_VALUES_ID_`),
  906. KEY `ACT_IDX_SUSPENDED_JOB_CORRELATION_ID` (`CORRELATION_ID_`),
  907. KEY `ACT_IDX_SJOB_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`),
  908. KEY `ACT_IDX_SJOB_SUB_SCOPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`),
  909. KEY `ACT_IDX_SJOB_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`),
  910. KEY `ACT_FK_SUSPENDED_JOB_EXECUTION` (`EXECUTION_ID_`),
  911. KEY `ACT_FK_SUSPENDED_JOB_PROCESS_INSTANCE` (`PROCESS_INSTANCE_ID_`),
  912. KEY `ACT_FK_SUSPENDED_JOB_PROC_DEF` (`PROC_DEF_ID_`),
  913. CONSTRAINT `ACT_FK_SUSPENDED_JOB_CUSTOM_VALUES` FOREIGN KEY (`CUSTOM_VALUES_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`),
  914. CONSTRAINT `ACT_FK_SUSPENDED_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`),
  915. CONSTRAINT `ACT_FK_SUSPENDED_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`),
  916. CONSTRAINT `ACT_FK_SUSPENDED_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`),
  917. CONSTRAINT `ACT_FK_SUSPENDED_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`)
  918. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  919. -- ----------------------------
  920. -- Table structure for ACT_RU_TASK
  921. -- ----------------------------
  922. DROP TABLE IF EXISTS `ACT_RU_TASK`;
  923. CREATE TABLE `ACT_RU_TASK` (
  924. `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  925. `REV_` int DEFAULT NULL,
  926. `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  927. `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  928. `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  929. `TASK_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  930. `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  931. `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  932. `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  933. `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  934. `PROPAGATED_STAGE_INST_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  935. `STATE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  936. `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  937. `PARENT_TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  938. `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  939. `TASK_DEF_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  940. `OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  941. `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  942. `DELEGATION_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  943. `PRIORITY_` int DEFAULT NULL,
  944. `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL,
  945. `IN_PROGRESS_TIME_` datetime(3) DEFAULT NULL,
  946. `IN_PROGRESS_STARTED_BY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  947. `CLAIM_TIME_` datetime(3) DEFAULT NULL,
  948. `CLAIMED_BY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  949. `SUSPENDED_TIME_` datetime(3) DEFAULT NULL,
  950. `SUSPENDED_BY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  951. `IN_PROGRESS_DUE_DATE_` datetime(3) DEFAULT NULL,
  952. `DUE_DATE_` datetime(3) DEFAULT NULL,
  953. `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  954. `SUSPENSION_STATE_` int DEFAULT NULL,
  955. `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  956. `FORM_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  957. `IS_COUNT_ENABLED_` tinyint DEFAULT NULL,
  958. `VAR_COUNT_` int DEFAULT NULL,
  959. `ID_LINK_COUNT_` int DEFAULT NULL,
  960. `SUB_TASK_COUNT_` int DEFAULT NULL,
  961. PRIMARY KEY (`ID_`),
  962. KEY `ACT_IDX_TASK_CREATE` (`CREATE_TIME_`),
  963. KEY `ACT_IDX_TASK_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`),
  964. KEY `ACT_IDX_TASK_SUB_SCOPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`),
  965. KEY `ACT_IDX_TASK_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`),
  966. KEY `ACT_FK_TASK_EXE` (`EXECUTION_ID_`),
  967. KEY `ACT_FK_TASK_PROCINST` (`PROC_INST_ID_`),
  968. KEY `ACT_FK_TASK_PROCDEF` (`PROC_DEF_ID_`),
  969. CONSTRAINT `ACT_FK_TASK_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`),
  970. CONSTRAINT `ACT_FK_TASK_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`),
  971. CONSTRAINT `ACT_FK_TASK_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`)
  972. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  973. -- ----------------------------
  974. -- Table structure for ACT_RU_TIMER_JOB
  975. -- ----------------------------
  976. DROP TABLE IF EXISTS `ACT_RU_TIMER_JOB`;
  977. CREATE TABLE `ACT_RU_TIMER_JOB` (
  978. `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  979. `REV_` int DEFAULT NULL,
  980. `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  981. `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
  982. `LOCK_EXP_TIME_` timestamp(3) NULL DEFAULT NULL,
  983. `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  984. `EXCLUSIVE_` tinyint(1) DEFAULT NULL,
  985. `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  986. `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  987. `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  988. `ELEMENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  989. `ELEMENT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  990. `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  991. `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  992. `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  993. `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  994. `CORRELATION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  995. `RETRIES_` int DEFAULT NULL,
  996. `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  997. `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  998. `DUEDATE_` timestamp(3) NULL DEFAULT NULL,
  999. `REPEAT_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  1000. `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  1001. `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  1002. `CUSTOM_VALUES_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  1003. `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL,
  1004. `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  1005. PRIMARY KEY (`ID_`),
  1006. KEY `ACT_IDX_TIMER_JOB_EXCEPTION_STACK_ID` (`EXCEPTION_STACK_ID_`),
  1007. KEY `ACT_IDX_TIMER_JOB_CUSTOM_VALUES_ID` (`CUSTOM_VALUES_ID_`),
  1008. KEY `ACT_IDX_TIMER_JOB_CORRELATION_ID` (`CORRELATION_ID_`),
  1009. KEY `ACT_IDX_TIMER_JOB_DUEDATE` (`DUEDATE_`),
  1010. KEY `ACT_IDX_TJOB_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`),
  1011. KEY `ACT_IDX_TJOB_SUB_SCOPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`),
  1012. KEY `ACT_IDX_TJOB_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`),
  1013. KEY `ACT_FK_TIMER_JOB_EXECUTION` (`EXECUTION_ID_`),
  1014. KEY `ACT_FK_TIMER_JOB_PROCESS_INSTANCE` (`PROCESS_INSTANCE_ID_`),
  1015. KEY `ACT_FK_TIMER_JOB_PROC_DEF` (`PROC_DEF_ID_`),
  1016. CONSTRAINT `ACT_FK_TIMER_JOB_CUSTOM_VALUES` FOREIGN KEY (`CUSTOM_VALUES_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`),
  1017. CONSTRAINT `ACT_FK_TIMER_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`),
  1018. CONSTRAINT `ACT_FK_TIMER_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`),
  1019. CONSTRAINT `ACT_FK_TIMER_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`),
  1020. CONSTRAINT `ACT_FK_TIMER_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`)
  1021. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  1022. -- ----------------------------
  1023. -- Table structure for ACT_RU_VARIABLE
  1024. -- ----------------------------
  1025. DROP TABLE IF EXISTS `ACT_RU_VARIABLE`;
  1026. CREATE TABLE `ACT_RU_VARIABLE` (
  1027. `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  1028. `REV_` int DEFAULT NULL,
  1029. `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
  1030. `NAME_` varchar(255) COLLATE utf8_bin NOT NULL,
  1031. `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  1032. `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  1033. `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  1034. `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  1035. `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  1036. `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  1037. `BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  1038. `DOUBLE_` double DEFAULT NULL,
  1039. `LONG_` bigint DEFAULT NULL,
  1040. `TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  1041. `TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  1042. `META_INFO_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  1043. PRIMARY KEY (`ID_`),
  1044. KEY `ACT_IDX_RU_VAR_SCOPE_ID_TYPE` (`SCOPE_ID_`,`SCOPE_TYPE_`),
  1045. KEY `ACT_IDX_RU_VAR_SUB_ID_TYPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`),
  1046. KEY `ACT_FK_VAR_BYTEARRAY` (`BYTEARRAY_ID_`),
  1047. KEY `ACT_IDX_VARIABLE_TASK_ID` (`TASK_ID_`),
  1048. KEY `ACT_FK_VAR_EXE` (`EXECUTION_ID_`),
  1049. KEY `ACT_FK_VAR_PROCINST` (`PROC_INST_ID_`),
  1050. CONSTRAINT `ACT_FK_VAR_BYTEARRAY` FOREIGN KEY (`BYTEARRAY_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`),
  1051. CONSTRAINT `ACT_FK_VAR_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`),
  1052. CONSTRAINT `ACT_FK_VAR_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`)
  1053. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  1054. -- ----------------------------
  1055. -- Table structure for FLW_CHANNEL_DEFINITION
  1056. -- ----------------------------
  1057. DROP TABLE IF EXISTS `FLW_CHANNEL_DEFINITION`;
  1058. CREATE TABLE `FLW_CHANNEL_DEFINITION` (
  1059. `ID_` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  1060. `NAME_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  1061. `VERSION_` int DEFAULT NULL,
  1062. `KEY_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  1063. `CATEGORY_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  1064. `DEPLOYMENT_ID_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  1065. `CREATE_TIME_` datetime(3) DEFAULT NULL,
  1066. `TENANT_ID_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  1067. `RESOURCE_NAME_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  1068. `DESCRIPTION_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  1069. `TYPE_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  1070. `IMPLEMENTATION_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  1071. PRIMARY KEY (`ID_`),
  1072. UNIQUE KEY `ACT_IDX_CHANNEL_DEF_UNIQ` (`KEY_`,`VERSION_`,`TENANT_ID_`)
  1073. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
  1074. -- ----------------------------
  1075. -- Table structure for FLW_EV_DATABASECHANGELOG
  1076. -- ----------------------------
  1077. DROP TABLE IF EXISTS `FLW_EV_DATABASECHANGELOG`;
  1078. CREATE TABLE `FLW_EV_DATABASECHANGELOG` (
  1079. `ID` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  1080. `AUTHOR` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  1081. `FILENAME` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  1082. `DATEEXECUTED` datetime NOT NULL,
  1083. `ORDEREXECUTED` int NOT NULL,
  1084. `EXECTYPE` varchar(10) COLLATE utf8mb4_bin NOT NULL,
  1085. `MD5SUM` varchar(35) COLLATE utf8mb4_bin DEFAULT NULL,
  1086. `DESCRIPTION` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  1087. `COMMENTS` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  1088. `TAG` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  1089. `LIQUIBASE` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
  1090. `CONTEXTS` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  1091. `LABELS` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  1092. `DEPLOYMENT_ID` varchar(10) COLLATE utf8mb4_bin DEFAULT NULL
  1093. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
  1094. -- ----------------------------
  1095. -- Records of FLW_EV_DATABASECHANGELOG
  1096. -- ----------------------------
  1097. BEGIN;
  1098. INSERT INTO `FLW_EV_DATABASECHANGELOG` VALUES ('1', 'flowable', 'org/flowable/eventregistry/db/liquibase/flowable-eventregistry-db-changelog.xml', '2024-01-23 14:13:11', 1, 'EXECUTED', '8:1b0c48c9cf7945be799d868a2626d687', 'createTable tableName=FLW_EVENT_DEPLOYMENT; createTable tableName=FLW_EVENT_RESOURCE; createTable tableName=FLW_EVENT_DEFINITION; createIndex indexName=ACT_IDX_EVENT_DEF_UNIQ, tableName=FLW_EVENT_DEFINITION; createTable tableName=FLW_CHANNEL_DEFIN...', '', NULL, '4.20.0', NULL, NULL, '5990391167');
  1099. INSERT INTO `FLW_EV_DATABASECHANGELOG` VALUES ('2', 'flowable', 'org/flowable/eventregistry/db/liquibase/flowable-eventregistry-db-changelog.xml', '2024-01-23 14:13:11', 2, 'EXECUTED', '8:0ea825feb8e470558f0b5754352b9cda', 'addColumn tableName=FLW_CHANNEL_DEFINITION; addColumn tableName=FLW_CHANNEL_DEFINITION', '', NULL, '4.20.0', NULL, NULL, '5990391167');
  1100. INSERT INTO `FLW_EV_DATABASECHANGELOG` VALUES ('3', 'flowable', 'org/flowable/eventregistry/db/liquibase/flowable-eventregistry-db-changelog.xml', '2024-01-23 14:13:11', 3, 'EXECUTED', '8:3c2bb293350b5cbe6504331980c9dcee', 'customChange', '', NULL, '4.20.0', NULL, NULL, '5990391167');
  1101. COMMIT;
  1102. -- ----------------------------
  1103. -- Table structure for FLW_EV_DATABASECHANGELOGLOCK
  1104. -- ----------------------------
  1105. DROP TABLE IF EXISTS `FLW_EV_DATABASECHANGELOGLOCK`;
  1106. CREATE TABLE `FLW_EV_DATABASECHANGELOGLOCK` (
  1107. `ID` int NOT NULL,
  1108. `LOCKED` bit(1) NOT NULL,
  1109. `LOCKGRANTED` datetime DEFAULT NULL,
  1110. `LOCKEDBY` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  1111. PRIMARY KEY (`ID`)
  1112. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
  1113. -- ----------------------------
  1114. -- Records of FLW_EV_DATABASECHANGELOGLOCK
  1115. -- ----------------------------
  1116. BEGIN;
  1117. INSERT INTO `FLW_EV_DATABASECHANGELOGLOCK` VALUES (1, b'0', NULL, NULL);
  1118. COMMIT;
  1119. -- ----------------------------
  1120. -- Table structure for FLW_EVENT_DEFINITION
  1121. -- ----------------------------
  1122. DROP TABLE IF EXISTS `FLW_EVENT_DEFINITION`;
  1123. CREATE TABLE `FLW_EVENT_DEFINITION` (
  1124. `ID_` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  1125. `NAME_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  1126. `VERSION_` int DEFAULT NULL,
  1127. `KEY_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  1128. `CATEGORY_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  1129. `DEPLOYMENT_ID_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  1130. `TENANT_ID_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  1131. `RESOURCE_NAME_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  1132. `DESCRIPTION_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  1133. PRIMARY KEY (`ID_`),
  1134. UNIQUE KEY `ACT_IDX_EVENT_DEF_UNIQ` (`KEY_`,`VERSION_`,`TENANT_ID_`)
  1135. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
  1136. -- ----------------------------
  1137. -- Table structure for FLW_EVENT_DEPLOYMENT
  1138. -- ----------------------------
  1139. DROP TABLE IF EXISTS `FLW_EVENT_DEPLOYMENT`;
  1140. CREATE TABLE `FLW_EVENT_DEPLOYMENT` (
  1141. `ID_` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  1142. `NAME_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  1143. `CATEGORY_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  1144. `DEPLOY_TIME_` datetime(3) DEFAULT NULL,
  1145. `TENANT_ID_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  1146. `PARENT_DEPLOYMENT_ID_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  1147. PRIMARY KEY (`ID_`)
  1148. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
  1149. -- ----------------------------
  1150. -- Table structure for FLW_EVENT_RESOURCE
  1151. -- ----------------------------
  1152. DROP TABLE IF EXISTS `FLW_EVENT_RESOURCE`;
  1153. CREATE TABLE `FLW_EVENT_RESOURCE` (
  1154. `ID_` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  1155. `NAME_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  1156. `DEPLOYMENT_ID_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  1157. `RESOURCE_BYTES_` longblob,
  1158. PRIMARY KEY (`ID_`)
  1159. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
  1160. -- ----------------------------
  1161. -- Table structure for FLW_RU_BATCH
  1162. -- ----------------------------
  1163. DROP TABLE IF EXISTS `FLW_RU_BATCH`;
  1164. CREATE TABLE `FLW_RU_BATCH` (
  1165. `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  1166. `REV_` int DEFAULT NULL,
  1167. `TYPE_` varchar(64) COLLATE utf8_bin NOT NULL,
  1168. `SEARCH_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  1169. `SEARCH_KEY2_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  1170. `CREATE_TIME_` datetime(3) NOT NULL,
  1171. `COMPLETE_TIME_` datetime(3) DEFAULT NULL,
  1172. `STATUS_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  1173. `BATCH_DOC_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  1174. `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  1175. PRIMARY KEY (`ID_`)
  1176. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  1177. -- ----------------------------
  1178. -- Table structure for FLW_RU_BATCH_PART
  1179. -- ----------------------------
  1180. DROP TABLE IF EXISTS `FLW_RU_BATCH_PART`;
  1181. CREATE TABLE `FLW_RU_BATCH_PART` (
  1182. `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  1183. `REV_` int DEFAULT NULL,
  1184. `BATCH_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  1185. `TYPE_` varchar(64) COLLATE utf8_bin NOT NULL,
  1186. `SCOPE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  1187. `SUB_SCOPE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  1188. `SCOPE_TYPE_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  1189. `SEARCH_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  1190. `SEARCH_KEY2_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  1191. `CREATE_TIME_` datetime(3) NOT NULL,
  1192. `COMPLETE_TIME_` datetime(3) DEFAULT NULL,
  1193. `STATUS_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  1194. `RESULT_DOC_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  1195. `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  1196. PRIMARY KEY (`ID_`),
  1197. KEY `FLW_IDX_BATCH_PART` (`BATCH_ID_`),
  1198. CONSTRAINT `FLW_FK_BATCH_PART_PARENT` FOREIGN KEY (`BATCH_ID_`) REFERENCES `FLW_RU_BATCH` (`ID_`)
  1199. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  1200. -- ----------------------------
  1201. -- 流程分类表
  1202. -- ----------------------------
  1203. DROP TABLE IF EXISTS `zz_flow_category`;
  1204. CREATE TABLE `zz_flow_category` (
  1205. `category_id` bigint(20) NOT NULL COMMENT '主键Id',
  1206. `tenant_id` bigint(20) COMMENT '租户Id',
  1207. `app_code` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '应用编码',
  1208. `name` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT '显示名称',
  1209. `code` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT '分类编码',
  1210. `show_order` int(11) NOT NULL COMMENT '实现顺序',
  1211. `update_time` datetime NOT NULL COMMENT '更新时间',
  1212. `update_user_id` bigint NOT NULL COMMENT '更新者Id',
  1213. `create_time` datetime NOT NULL COMMENT '创建时间',
  1214. `create_user_id` bigint NOT NULL COMMENT '创建者Id',
  1215. PRIMARY KEY (`category_id`) USING BTREE,
  1216. KEY `idx_tenant_id` (`tenant_id`) USING BTREE,
  1217. KEY `idx_code` (`code`) USING BTREE,
  1218. KEY `idx_app_code` (`app_code`) USING BTREE
  1219. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='流程分类表';
  1220. -- ----------------------------
  1221. -- 流程管理表
  1222. -- ----------------------------
  1223. DROP TABLE IF EXISTS `zz_flow_entry`;
  1224. CREATE TABLE `zz_flow_entry` (
  1225. `entry_id` bigint(20) NOT NULL COMMENT '主键',
  1226. `tenant_id` bigint(20) COMMENT '租户Id',
  1227. `app_code` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '应用编码',
  1228. `process_definition_name` varchar(200) NOT NULL COMMENT '流程名称',
  1229. `process_definition_key` varchar(150) NOT NULL COMMENT '流程标识Key',
  1230. `category_id` bigint(20) NOT NULL COMMENT '流程分类',
  1231. `main_entry_publish_id` bigint(20) DEFAULT NULL COMMENT '工作流部署的发布主版本Id',
  1232. `latest_publish_time` datetime DEFAULT NULL COMMENT '最新发布时间',
  1233. `status` int(11) NOT NULL COMMENT '流程状态',
  1234. `bpmn_xml` longtext COMMENT '流程定义的xml',
  1235. `diagram_type` int(11) NOT NULL COMMENT '流程图类型',
  1236. `bind_form_type` int(11) NOT NULL COMMENT '绑定表单类型',
  1237. `page_id` bigint(20) DEFAULT NULL COMMENT '在线表单的页面Id',
  1238. `default_form_id` bigint(20) DEFAULT NULL COMMENT '在线表单Id',
  1239. `default_router_name` varchar(255) DEFAULT NULL COMMENT '静态表单的缺省路由名称',
  1240. `encoded_rule` varchar(255) DEFAULT NULL COMMENT '工单表编码字段的编码规则',
  1241. `extension_data` varchar(3000) DEFAULT NULL COMMENT '流程的自定义扩展数据',
  1242. `update_time` datetime NOT NULL COMMENT '更新时间',
  1243. `update_user_id` bigint NOT NULL COMMENT '更新者Id',
  1244. `create_time` datetime NOT NULL COMMENT '创建时间',
  1245. `create_user_id` bigint NOT NULL COMMENT '创建者Id',
  1246. PRIMARY KEY (`entry_id`) USING BTREE,
  1247. KEY `idx_process_definition_key` (`process_definition_key`) USING BTREE,
  1248. KEY `idx_app_code` (`app_code`) USING BTREE,
  1249. KEY `idx_category_id` (`category_id`) USING BTREE,
  1250. KEY `idx_tenant_id` (`tenant_id`) USING BTREE,
  1251. KEY `idx_status` (`status`) USING BTREE,
  1252. KEY `idx_process_definition_name` (`process_definition_name`) USING BTREE
  1253. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='流程管理表';
  1254. -- ----------------------------
  1255. -- 流程发布表
  1256. -- ----------------------------
  1257. DROP TABLE IF EXISTS `zz_flow_entry_publish`;
  1258. CREATE TABLE `zz_flow_entry_publish` (
  1259. `entry_publish_id` bigint(20) NOT NULL COMMENT '主键Id',
  1260. `entry_id` bigint(20) NOT NULL COMMENT '流程Id',
  1261. `process_definition_id` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT '流程引擎的定义Id',
  1262. `deploy_id` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT '流程引擎的部署Id',
  1263. `publish_version` int(11) NOT NULL COMMENT '发布版本',
  1264. `active_status` bit(1) NOT NULL COMMENT '激活状态',
  1265. `main_version` bit(1) NOT NULL COMMENT '是否为主版本',
  1266. `extension_data` varchar(3000) DEFAULT NULL COMMENT '流程的自定义扩展数据',
  1267. `create_user_id` bigint NOT NULL COMMENT '创建者Id',
  1268. `publish_time` datetime NOT NULL COMMENT '发布时间',
  1269. `init_task_info` text CHARACTER SET utf8mb4 COMMENT '第一个非开始节点任务的附加信息',
  1270. `analyzed_node_json` longtext CHARACTER SET utf8mb4 COMMENT '分析后的节点JSON信息',
  1271. PRIMARY KEY (`entry_publish_id`) USING BTREE,
  1272. UNIQUE KEY `uk_process_definition_id` (`process_definition_id`) USING BTREE,
  1273. KEY `idx_entry_id` (`entry_id`) USING BTREE
  1274. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='流程发布表';
  1275. -- ----------------------------
  1276. -- 流程发布变量表
  1277. -- ----------------------------
  1278. DROP TABLE IF EXISTS `zz_flow_entry_publish_variable`;
  1279. CREATE TABLE `zz_flow_entry_publish_variable` (
  1280. `variable_id` bigint(20) NOT NULL COMMENT '主键Id',
  1281. `entry_publish_id` bigint(20) NOT NULL COMMENT '流程Id',
  1282. `variable_name` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '变量名',
  1283. `show_name` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '显示名',
  1284. `variable_type` int(11) NOT NULL COMMENT '变量类型',
  1285. `bind_datasource_id` bigint(20) DEFAULT NULL COMMENT '绑定数据源Id',
  1286. `bind_relation_id` bigint(20) DEFAULT NULL COMMENT '绑定数据源关联Id',
  1287. `bind_column_id` bigint(20) DEFAULT NULL COMMENT '绑定字段Id',
  1288. `builtin` bit(1) NOT NULL COMMENT '是否内置',
  1289. PRIMARY KEY (`variable_id`) USING BTREE,
  1290. KEY `idx_entry_publish_id` (`entry_publish_id`) USING BTREE
  1291. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='流程发布变量表';
  1292. -- ----------------------------
  1293. -- 流程变量表
  1294. -- ----------------------------
  1295. DROP TABLE IF EXISTS `zz_flow_entry_variable`;
  1296. CREATE TABLE `zz_flow_entry_variable` (
  1297. `variable_id` bigint(20) NOT NULL COMMENT '主键Id',
  1298. `entry_id` bigint(20) NOT NULL COMMENT '流程Id',
  1299. `variable_name` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '变量名',
  1300. `show_name` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '显示名',
  1301. `variable_type` int(11) NOT NULL COMMENT '变量类型',
  1302. `bind_datasource_id` bigint(20) DEFAULT NULL COMMENT '绑定数据源Id',
  1303. `bind_relation_id` bigint(20) DEFAULT NULL COMMENT '绑定数据源关联Id',
  1304. `bind_column_id` bigint(20) DEFAULT NULL COMMENT '绑定字段Id',
  1305. `builtin` bit(1) NOT NULL COMMENT '是否内置',
  1306. `create_time` datetime NOT NULL COMMENT '创建时间',
  1307. PRIMARY KEY (`variable_id`) USING BTREE,
  1308. UNIQUE KEY `uk_entry_id_variable_name` (`entry_id`,`variable_name`) USING BTREE
  1309. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='流程变量表';
  1310. -- ----------------------------
  1311. -- 流程任务审批表
  1312. -- ----------------------------
  1313. DROP TABLE IF EXISTS `zz_flow_task_comment`;
  1314. CREATE TABLE `zz_flow_task_comment` (
  1315. `id` bigint(20) NOT NULL COMMENT '主键Id',
  1316. `process_instance_id` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT '流程实例Id',
  1317. `task_id` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '任务Id',
  1318. `task_key` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '任务标识',
  1319. `task_name` varchar(512) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '任务名称',
  1320. `target_task_key` varchar(255) COLLATE utf8mb4_bin COMMENT '目标任务标识',
  1321. `execution_id` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '任务的执行Id',
  1322. `multi_instance_exec_id` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '会签任务的执行Id',
  1323. `approval_type` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '审批类型',
  1324. `task_comment` varchar(1024) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '批注内容',
  1325. `delegate_assignee` varchar(512) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '委托指定人,比如加签、转办等',
  1326. `custom_business_data` longtext COLLATE utf8mb4_bin COMMENT '自定义数据。开发者可自行扩展,推荐使用JSON格式数据',
  1327. `head_image_url` varchar(1024) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '审批用户头像',
  1328. `create_user_id` bigint COMMENT '创建者Id',
  1329. `create_login_name` varchar(255) COLLATE utf8mb4_bin COMMENT '创建者登录名',
  1330. `create_username` varchar(255) COLLATE utf8mb4_bin COMMENT '创建者用户名',
  1331. `create_time` datetime NOT NULL COMMENT '创建时间',
  1332. PRIMARY KEY (`id`) USING BTREE,
  1333. KEY `idx_multi_instance_exec_id` (`multi_instance_exec_id`) USING BTREE,
  1334. KEY `idx_process_instance_id` (`process_instance_id`) USING BTREE
  1335. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='流程任务审批表';
  1336. -- ----------------------------
  1337. -- 流程多实例任务审批流水表
  1338. -- ----------------------------
  1339. DROP TABLE IF EXISTS `zz_flow_multi_instance_trans`;
  1340. CREATE TABLE `zz_flow_multi_instance_trans` (
  1341. `id` bigint NOT NULL COMMENT '主键Id',
  1342. `process_instance_id` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT '流程实例Id',
  1343. `task_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '任务Id',
  1344. `task_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '任务标识',
  1345. `multi_instance_exec_id` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT '会签任务的执行Id',
  1346. `execution_id` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT '任务的执行Id',
  1347. `assignee_list` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '会签指派人列表',
  1348. `create_user_id` bigint NOT NULL COMMENT '创建者Id',
  1349. `create_login_name` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '创建者登录名',
  1350. `create_username` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '创建者用户名',
  1351. `create_time` datetime NOT NULL COMMENT '创建时间',
  1352. PRIMARY KEY (`id`),
  1353. UNIQUE KEY `uk_execution_id_task_id` (`execution_id`, `task_id`) USING BTREE,
  1354. KEY `idx_multi_instance_exec_id` (`multi_instance_exec_id`) USING BTREE
  1355. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='流程多实例任务审批流水表';
  1356. -- ----------------------------
  1357. -- 流程流程图任务扩展表
  1358. -- ----------------------------
  1359. DROP TABLE IF EXISTS `zz_flow_task_ext`;
  1360. CREATE TABLE `zz_flow_task_ext` (
  1361. `process_definition_id` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT '流程引擎的定义Id',
  1362. `task_id` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT '流程引擎任务Id',
  1363. `operation_list_json` longtext COLLATE utf8mb4_bin COMMENT '操作列表JSON',
  1364. `variable_list_json` longtext COLLATE utf8mb4_bin COMMENT '变量列表JSON',
  1365. `assignee_list_json` text COLLATE utf8mb4_bin COMMENT '存储多实例的assigneeList的JSON',
  1366. `group_type` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '分组类型',
  1367. `dept_post_list_json` varchar(1024) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '保存岗位相关的数据',
  1368. `role_ids` varchar(1024) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '保存角色Id数据',
  1369. `dept_ids` varchar(1024) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '保存部门Id数据',
  1370. `candidate_usernames` varchar(4000) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '保存候选组用户名数据',
  1371. `copy_list_json` varchar(4000) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '抄送相关的数据',
  1372. `extra_data_json` text COLLATE utf8mb4_bin COMMENT '用户任务的扩展属性,存储为JSON的字符串格式',
  1373. PRIMARY KEY (`process_definition_id`,`task_id`) USING BTREE
  1374. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='流程流程图任务扩展表';
  1375. -- ----------------------------
  1376. -- 流程工单表
  1377. -- ----------------------------
  1378. DROP TABLE IF EXISTS `zz_flow_work_order`;
  1379. CREATE TABLE `zz_flow_work_order` (
  1380. `work_order_id` bigint(20) NOT NULL COMMENT '主键Id',
  1381. `tenant_id` bigint(20) COMMENT '租户Id',
  1382. `app_code` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '应用编码',
  1383. `work_order_code` varchar(255) COLLATE utf8mb4_bin COMMENT '工单编码字段',
  1384. `process_definition_key` varchar(128) COLLATE utf8mb4_bin NOT NULL COMMENT '流程定义标识',
  1385. `process_definition_name` varchar(200) CHARACTER SET utf8mb4 NOT NULL COMMENT '流程名称',
  1386. `process_definition_id` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT '流程引擎的定义Id',
  1387. `process_instance_id` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT '流程实例Id',
  1388. `online_table_id` bigint(20) DEFAULT NULL COMMENT '在线表单的主表Id',
  1389. `table_name` varchar(128) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '用于静态表单的表名',
  1390. `business_key` varchar(128) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '业务主键值',
  1391. `task_id` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '未完成的任务Id',
  1392. `task_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '未完成的任务名称',
  1393. `task_definition_key` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '未完成的任务标识',
  1394. `latest_approval_status` int(11) COMMENT '最近的审批状态',
  1395. `flow_status` int(11) NOT NULL DEFAULT 0 COMMENT '流程状态',
  1396. `submit_username` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT '提交用户登录名称',
  1397. `dept_id` bigint NOT NULL COMMENT '提交用户所在部门Id',
  1398. `update_time` datetime NOT NULL COMMENT '更新时间',
  1399. `update_user_id` bigint NOT NULL COMMENT '更新者Id',
  1400. `create_time` datetime NOT NULL COMMENT '创建时间',
  1401. `create_user_id` bigint NOT NULL COMMENT '创建者Id',
  1402. `deleted_flag` int(11) NOT NULL COMMENT '删除标记(1: 正常 -1: 已删除)',
  1403. PRIMARY KEY (`work_order_id`) USING BTREE,
  1404. UNIQUE KEY `uk_process_instance_id` (`process_instance_id`) USING BTREE,
  1405. UNIQUE KEY `uk_work_order_code` (`work_order_code`) USING BTREE,
  1406. KEY `idx_tenant_id` (`tenant_id`) USING BTREE,
  1407. KEY `idx_app_code` (`app_code`) USING BTREE,
  1408. KEY `idx_process_definition_key` (`process_definition_key`) USING BTREE,
  1409. KEY `idx_create_user_id` (`create_user_id`) USING BTREE,
  1410. KEY `idx_create_time` (`create_time`) USING BTREE,
  1411. KEY `idx_dept_id` (`dept_id`) USING BTREE,
  1412. KEY `idx_table_name` (`table_name`) USING BTREE,
  1413. KEY `idx_business_key` (`business_key`) USING BTREE
  1414. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='流程工单表';
  1415. -- ----------------------------
  1416. -- 流程工单扩展表
  1417. -- ----------------------------
  1418. DROP TABLE IF EXISTS `zz_flow_work_order_ext`;
  1419. CREATE TABLE `zz_flow_work_order_ext` (
  1420. `id` bigint NOT NULL COMMENT '主键Id',
  1421. `work_order_id` bigint NOT NULL COMMENT '工单Id',
  1422. `draft_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '草稿数据',
  1423. `business_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '业务数据',
  1424. `update_time` datetime NOT NULL COMMENT '更新时间',
  1425. `update_user_id` bigint NOT NULL COMMENT '更新者Id',
  1426. `create_time` datetime NOT NULL COMMENT '创建时间',
  1427. `create_user_id` bigint NOT NULL COMMENT '创建者Id',
  1428. `deleted_flag` int(11) NOT NULL COMMENT '删除标记(1: 正常 -1: 已删除)',
  1429. PRIMARY KEY (`id`) USING BTREE,
  1430. KEY `idx_work_order_id` (`work_order_id`) USING BTREE
  1431. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='流程工单扩展表';
  1432. -- ----------------------------
  1433. -- 流程消息通知表
  1434. -- ----------------------------
  1435. DROP TABLE IF EXISTS `zz_flow_message`;
  1436. CREATE TABLE `zz_flow_message` (
  1437. `message_id` bigint(20) NOT NULL COMMENT '主键Id',
  1438. `tenant_id` bigint(20) COMMENT '租户Id',
  1439. `app_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '应用Id',
  1440. `message_type` tinyint(4) NOT NULL COMMENT '消息类型',
  1441. `message_content` varchar(1024) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '消息内容',
  1442. `remind_count` int(11) DEFAULT 0 COMMENT '催办次数',
  1443. `work_order_id` bigint(20) DEFAULT NULL COMMENT '工单Id',
  1444. `process_definition_id` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '流程定义Id',
  1445. `process_definition_key` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '流程定义标识',
  1446. `process_definition_name` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '流程定义名称',
  1447. `process_instance_id` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '流程实例Id',
  1448. `process_instance_initiator` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '流程实例发起者',
  1449. `task_id` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '流程任务Id',
  1450. `task_definition_key` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '流程任务定义标识',
  1451. `task_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '流程任务名称',
  1452. `task_start_time` datetime DEFAULT NULL COMMENT '任务开始时间',
  1453. `task_finished` bit(1) NOT NULL DEFAULT b'0' COMMENT '任务是否已完成',
  1454. `task_assignee` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '任务指派人登录名',
  1455. `business_data_shot` longtext COLLATE utf8mb4_bin COMMENT '业务数据快照',
  1456. `online_form_data` bit(1) COMMENT '是否为在线表单消息数据',
  1457. `update_time` datetime NOT NULL COMMENT '更新时间',
  1458. `update_user_id` bigint NOT NULL COMMENT '更新者Id',
  1459. `create_time` datetime NOT NULL COMMENT '创建时间',
  1460. `create_user_id` bigint NOT NULL COMMENT '创建者Id',
  1461. `create_username` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '创建者显示名',
  1462. PRIMARY KEY (`message_id`) USING BTREE,
  1463. KEY `idx_tenant_id` (`tenant_id`) USING BTREE,
  1464. KEY `idx_app_code` (`app_code`) USING BTREE,
  1465. KEY `idx_notified_username` (`task_assignee`) USING BTREE,
  1466. KEY `idx_process_instance_id` (`process_instance_id`) USING BTREE,
  1467. KEY `idx_message_type` (`message_type`) USING BTREE,
  1468. KEY `idx_task_id` (`task_id`) USING BTREE,
  1469. KEY `idx_task_finished` (`task_finished`) USING BTREE,
  1470. KEY `idx_update_time` (`update_time`) USING BTREE
  1471. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='流程消息通知表';
  1472. -- ----------------------------
  1473. -- 流程消息通知候选人表
  1474. -- ----------------------------
  1475. DROP TABLE IF EXISTS `zz_flow_msg_candidate_identity`;
  1476. CREATE TABLE `zz_flow_msg_candidate_identity` (
  1477. `id` bigint(20) NOT NULL COMMENT '主键Id',
  1478. `message_id` bigint(20) NOT NULL COMMENT '流程任务Id',
  1479. `candidate_type` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '候选身份类型',
  1480. `candidate_id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '候选身份Id',
  1481. PRIMARY KEY (`id`),
  1482. KEY `idx_candidate_id` (`candidate_id`) USING BTREE,
  1483. KEY `idx_message_id` (`message_id`) USING BTREE
  1484. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='流程消息通知候选人表';
  1485. -- ----------------------------
  1486. -- 流程消息候选人操作表
  1487. -- ----------------------------
  1488. DROP TABLE IF EXISTS `zz_flow_msg_identity_operation`;
  1489. CREATE TABLE `zz_flow_msg_identity_operation` (
  1490. `id` bigint NOT NULL COMMENT '主键Id',
  1491. `message_id` bigint NOT NULL COMMENT '流程任务Id',
  1492. `login_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '用户登录名',
  1493. `operation_type` int NOT NULL COMMENT '操作类型',
  1494. `operation_time` datetime NOT NULL COMMENT '操作时间',
  1495. PRIMARY KEY (`id`),
  1496. KEY `idx_message_id` (`message_id`) USING BTREE,
  1497. KEY `idx_login_name` (`login_name`) USING BTREE
  1498. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='流程消息候选人操作表';
  1499. -- ----------------------------
  1500. -- 流程变量日志表
  1501. -- ----------------------------
  1502. DROP TABLE IF EXISTS `zz_flow_variable_log`;
  1503. CREATE TABLE `zz_flow_variable_log` (
  1504. `id` bigint NOT NULL COMMENT '主键Id',
  1505. `process_definition_key` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '流程定义标识',
  1506. `process_instance_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '流程实例Id',
  1507. `task_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '未完成的任务标识',
  1508. `variable_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '变量数据',
  1509. `create_time` datetime NOT NULL COMMENT '创建时间',
  1510. `expired_time` datetime DEFAULT NULL COMMENT '过期时间',
  1511. PRIMARY KEY (`id`) USING BTREE,
  1512. KEY `idx_process_instance_id` (`process_instance_id`,`task_key`) USING BTREE
  1513. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='流程变量日志表';
  1514. -- ----------------------------
  1515. -- 流程任务超时作业表
  1516. -- ----------------------------
  1517. DROP TABLE IF EXISTS `zz_flow_task_timeout_job`;
  1518. CREATE TABLE `zz_flow_task_timeout_job` (
  1519. `id` bigint NOT NULL COMMENT '主键Id',
  1520. `process_definition_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '流程定义Id',
  1521. `process_instance_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '流程实例Id',
  1522. `task_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '任务标识',
  1523. `task_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '任务Id',
  1524. `timeout_hours` int NOT NULL COMMENT '超时的小时数',
  1525. `handle_way` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '超时处理方式',
  1526. `default_assignee` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '超时处理缺省用户名',
  1527. `error_message` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '错误信息',
  1528. `status` int NOT NULL COMMENT '执行状态',
  1529. `exec_time` datetime DEFAULT NULL COMMENT '执行时间',
  1530. `create_time` datetime NOT NULL COMMENT '创建时间',
  1531. `update_time` datetime NOT NULL COMMENT '更新时间',
  1532. PRIMARY KEY (`id`) USING BTREE,
  1533. KEY `idx_process_instance_id` (`process_instance_id`) USING BTREE,
  1534. KEY `idx_status` (`status`),
  1535. KEY `idx_task_id` (`task_id`),
  1536. KEY `idx_exec_time` (`exec_time`) USING BTREE
  1537. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='流程任务超时作业表';
  1538. -- ----------------------------
  1539. -- 流程处理事务事件生产者流水表
  1540. -- ----------------------------
  1541. DROP TABLE IF EXISTS `zz_flow_trans_producer`;
  1542. CREATE TABLE `zz_flow_trans_producer` (
  1543. `trans_id` bigint NOT NULL COMMENT '主键Id',
  1544. `app_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '应用Id',
  1545. `dblink_id` bigint NOT NULL COMMENT '数据库链接Id',
  1546. `process_instance_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '流程实例Id',
  1547. `task_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '任务Id',
  1548. `task_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '任务标识',
  1549. `task_name` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '任务名称',
  1550. `task_comment` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '批注内容',
  1551. `url` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '当前请求的url',
  1552. `init_method` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '创建该事务性事件对象的初始方法',
  1553. `trace_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '当前请求的traceId',
  1554. `sql_data` text COLLATE utf8mb4_bin COMMENT '和SQL操作相关的数据',
  1555. `try_times` int NOT NULL COMMENT '尝试次数',
  1556. `error_reason` text COLLATE utf8mb4_bin COMMENT '提交业务数据时的错误信息',
  1557. `create_login_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建者登录名',
  1558. `create_username` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建者中文用户名',
  1559. `create_time` datetime NOT NULL COMMENT '创建时间',
  1560. PRIMARY KEY (`trans_id`) USING BTREE,
  1561. KEY `idx_app_code` (`app_code`) USING BTREE,
  1562. KEY `idx_process_instance_id` (`process_instance_id`) USING BTREE
  1563. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
  1564. -- ----------------------------
  1565. -- 流程处理事务事件消费者流水表
  1566. -- ----------------------------
  1567. DROP TABLE IF EXISTS `zz_flow_trans_consumer`;
  1568. CREATE TABLE `zz_flow_trans_consumer` (
  1569. `trans_id` bigint NOT NULL COMMENT '主键Id',
  1570. `create_time` datetime NOT NULL COMMENT '创建时间',
  1571. PRIMARY KEY (`trans_id`) USING BTREE
  1572. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
  1573. SET FOREIGN_KEY_CHECKS = 1;