You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
2192 lines
139 KiB
2192 lines
139 KiB
|
|
drop table if exists `act_app_appdef`;
|
|
create table `act_app_appdef` (
|
|
`id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`rev_` int not null,
|
|
`name_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`key_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`version_` int not null,
|
|
`category_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`deployment_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`resource_name_` varchar(4000) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`description_` varchar(4000) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`tenant_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default '',
|
|
primary key (`id_`) using btree,
|
|
unique index `act_idx_app_def_uniq`(`key_` asc, `version_` asc, `tenant_id_` asc) using btree,
|
|
index `act_idx_app_def_dply`(`deployment_id_` asc) using btree,
|
|
constraint `act_fk_app_def_dply` foreign key (`deployment_id_`) references `act_app_deployment` (`id_`) on delete restrict on update restrict
|
|
) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_app_appdef
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_app_databasechangelog
|
|
-- ----------------------------
|
|
drop table if exists `act_app_databasechangelog`;
|
|
create table `act_app_databasechangelog` (
|
|
`id` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`author` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`filename` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`dateexecuted` datetime not null,
|
|
`orderexecuted` int not null,
|
|
`exectype` varchar(10) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`md5sum` varchar(35) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`description` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`comments` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`tag` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`liquibase` varchar(20) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`contexts` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`labels` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`deployment_id` varchar(10) character set utf8mb4 collate utf8mb4_general_ci null default null
|
|
) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_app_databasechangelog
|
|
-- ----------------------------
|
|
insert into `act_app_databasechangelog` values ('1', 'flowable', 'org/flowable/app/db/liquibase/flowable-app-db-changelog.xml', '2025-08-05 09:17:09', 1, 'executed', '8:496fc778bdf2ab13f2e1926d0e63e0a2', 'createtable tablename=act_app_deployment; createtable tablename=act_app_deployment_resource; addforeignkeyconstraint basetablename=act_app_deployment_resource, constraintname=act_fk_app_rsrc_dpl, referencedtablename=act_app_deployment; createindex...', '', null, '4.3.5', null, null, '4356627971');
|
|
insert into `act_app_databasechangelog` values ('2', 'flowable', 'org/flowable/app/db/liquibase/flowable-app-db-changelog.xml', '2025-08-05 09:17:09', 2, 'executed', '8:ccea9ebfb6c1f8367ca4dd473fcbb7db', 'modifydatatype columnname=deploy_time_, tablename=act_app_deployment', '', null, '4.3.5', null, null, '4356627971');
|
|
insert into `act_app_databasechangelog` values ('3', 'flowable', 'org/flowable/app/db/liquibase/flowable-app-db-changelog.xml', '2025-08-05 09:17:09', 3, 'executed', '8:f1f8aff320aade831944ebad24355f3d', 'createindex indexname=act_idx_app_def_uniq, tablename=act_app_appdef', '', null, '4.3.5', null, null, '4356627971');
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_app_databasechangeloglock
|
|
-- ----------------------------
|
|
drop table if exists `act_app_databasechangeloglock`;
|
|
create table `act_app_databasechangeloglock` (
|
|
`id` int not null,
|
|
`locked` bit(1) not null,
|
|
`lockgranted` datetime null default null,
|
|
`lockedby` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
primary key (`id`) using btree
|
|
) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_app_databasechangeloglock
|
|
-- ----------------------------
|
|
insert into `act_app_databasechangeloglock` values (1, b'0', null, null);
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_app_deployment
|
|
-- ----------------------------
|
|
drop table if exists `act_app_deployment`;
|
|
create table `act_app_deployment` (
|
|
`id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`name_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`category_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`key_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`deploy_time_` datetime(3) null default null,
|
|
`tenant_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default '',
|
|
primary key (`id_`) using btree
|
|
) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_app_deployment
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_app_deployment_resource
|
|
-- ----------------------------
|
|
drop table if exists `act_app_deployment_resource`;
|
|
create table `act_app_deployment_resource` (
|
|
`id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`name_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`deployment_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`resource_bytes_` longblob null,
|
|
primary key (`id_`) using btree,
|
|
index `act_idx_app_rsrc_dpl`(`deployment_id_` asc) using btree,
|
|
constraint `act_fk_app_rsrc_dpl` foreign key (`deployment_id_`) references `act_app_deployment` (`id_`) on delete restrict on update restrict
|
|
) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_app_deployment_resource
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_cmmn_casedef
|
|
-- ----------------------------
|
|
drop table if exists `act_cmmn_casedef`;
|
|
create table `act_cmmn_casedef` (
|
|
`id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`rev_` int not null,
|
|
`name_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`key_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`version_` int not null,
|
|
`category_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`deployment_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`resource_name_` varchar(4000) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`description_` varchar(4000) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`has_graphical_notation_` bit(1) null default null,
|
|
`tenant_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default '',
|
|
`dgrm_resource_name_` varchar(4000) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`has_start_form_key_` bit(1) null default null,
|
|
primary key (`id_`) using btree,
|
|
unique index `act_idx_case_def_uniq`(`key_` asc, `version_` asc, `tenant_id_` asc) using btree,
|
|
index `act_idx_case_def_dply`(`deployment_id_` asc) using btree,
|
|
constraint `act_fk_case_def_dply` foreign key (`deployment_id_`) references `act_cmmn_deployment` (`id_`) on delete restrict on update restrict
|
|
) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_cmmn_casedef
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_cmmn_databasechangelog
|
|
-- ----------------------------
|
|
drop table if exists `act_cmmn_databasechangelog`;
|
|
create table `act_cmmn_databasechangelog` (
|
|
`id` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`author` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`filename` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`dateexecuted` datetime not null,
|
|
`orderexecuted` int not null,
|
|
`exectype` varchar(10) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`md5sum` varchar(35) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`description` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`comments` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`tag` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`liquibase` varchar(20) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`contexts` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`labels` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`deployment_id` varchar(10) character set utf8mb4 collate utf8mb4_general_ci null default null
|
|
) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_cmmn_databasechangelog
|
|
-- ----------------------------
|
|
insert into `act_cmmn_databasechangelog` values ('1', 'flowable', 'org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml', '2025-08-05 09:17:03', 1, 'executed', '8:8b4b922d90b05ff27483abefc9597aa6', 'createtable tablename=act_cmmn_deployment; createtable tablename=act_cmmn_deployment_resource; addforeignkeyconstraint basetablename=act_cmmn_deployment_resource, constraintname=act_fk_cmmn_rsrc_dpl, referencedtablename=act_cmmn_deployment; create...', '', null, '4.3.5', null, null, '4356620765');
|
|
insert into `act_cmmn_databasechangelog` values ('2', 'flowable', 'org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml', '2025-08-05 09:17:03', 2, 'executed', '8:65e39b3d385706bb261cbeffe7533cbe', 'addcolumn tablename=act_cmmn_casedef; addcolumn tablename=act_cmmn_deployment_resource; addcolumn tablename=act_cmmn_ru_case_inst; addcolumn tablename=act_cmmn_ru_plan_item_inst', '', null, '4.3.5', null, null, '4356620765');
|
|
insert into `act_cmmn_databasechangelog` values ('3', 'flowable', 'org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml', '2025-08-05 09:17:03', 3, 'executed', '8:c01f6e802b49436b4489040da3012359', 'addcolumn tablename=act_cmmn_ru_plan_item_inst; addcolumn tablename=act_cmmn_ru_case_inst; createindex indexname=act_idx_plan_item_stage_inst, tablename=act_cmmn_ru_plan_item_inst; addcolumn tablename=act_cmmn_ru_plan_item_inst; addcolumn tablenam...', '', null, '4.3.5', null, null, '4356620765');
|
|
insert into `act_cmmn_databasechangelog` values ('4', 'flowable', 'org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml', '2025-08-05 09:17:04', 4, 'executed', '8:e40d29cb79345b7fb5afd38a7f0ba8fc', 'createtable tablename=act_cmmn_hi_plan_item_inst; addcolumn tablename=act_cmmn_ru_mil_inst; addcolumn tablename=act_cmmn_hi_mil_inst', '', null, '4.3.5', null, null, '4356620765');
|
|
insert into `act_cmmn_databasechangelog` values ('6', 'flowable', 'org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml', '2025-08-05 09:17:04', 5, 'executed', '8:10e82e26a7fee94c32a92099c059c18c', 'createindex indexname=act_idx_case_def_uniq, tablename=act_cmmn_casedef', '', null, '4.3.5', null, null, '4356620765');
|
|
insert into `act_cmmn_databasechangelog` values ('7', 'flowable', 'org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml', '2025-08-05 09:17:04', 6, 'executed', '8:530bc81a1e30618ccf4a2da1f7c6c043', 'renamecolumn newcolumnname=create_time_, oldcolumnname=start_time_, tablename=act_cmmn_ru_plan_item_inst; renamecolumn newcolumnname=create_time_, oldcolumnname=created_time_, tablename=act_cmmn_hi_plan_item_inst; addcolumn tablename=act_cmmn_ru_p...', '', null, '4.3.5', null, null, '4356620765');
|
|
insert into `act_cmmn_databasechangelog` values ('8', 'flowable', 'org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml', '2025-08-05 09:17:04', 7, 'executed', '8:e8c2eb1ce28bc301efe07e0e29757781', 'addcolumn tablename=act_cmmn_hi_plan_item_inst', '', null, '4.3.5', null, null, '4356620765');
|
|
insert into `act_cmmn_databasechangelog` values ('9', 'flowable', 'org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml', '2025-08-05 09:17:04', 8, 'executed', '8:4cb4782b9bdec5ced2a64c525aa7b3a0', 'addcolumn tablename=act_cmmn_ru_plan_item_inst; addcolumn tablename=act_cmmn_hi_plan_item_inst', '', null, '4.3.5', null, null, '4356620765');
|
|
insert into `act_cmmn_databasechangelog` values ('10', 'flowable', 'org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml', '2025-08-05 09:17:05', 9, 'executed', '8:341c16be247f5d17badc9809da8691f9', 'addcolumn tablename=act_cmmn_ru_case_inst; addcolumn tablename=act_cmmn_ru_case_inst; createindex indexname=act_idx_case_inst_ref_id_, tablename=act_cmmn_ru_case_inst; addcolumn tablename=act_cmmn_hi_case_inst; addcolumn tablename=act_cmmn_hi_case...', '', null, '4.3.5', null, null, '4356620765');
|
|
insert into `act_cmmn_databasechangelog` values ('11', 'flowable', 'org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml', '2025-08-05 09:17:05', 10, 'executed', '8:d7c4da9276bcfffbfb0ebfb25e3f7b05', 'addcolumn tablename=act_cmmn_ru_plan_item_inst; addcolumn tablename=act_cmmn_hi_plan_item_inst', '', null, '4.3.5', null, null, '4356620765');
|
|
insert into `act_cmmn_databasechangelog` values ('12', 'flowable', 'org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml', '2025-08-05 09:17:05', 11, 'executed', '8:adf4ecc45f2aa9a44a5626b02e1d6f98', 'addcolumn tablename=act_cmmn_ru_case_inst', '', null, '4.3.5', null, null, '4356620765');
|
|
insert into `act_cmmn_databasechangelog` values ('13', 'flowable', 'org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml', '2025-08-05 09:17:05', 12, 'executed', '8:7550626f964ab5518464709408333ec1', 'addcolumn tablename=act_cmmn_ru_plan_item_inst; addcolumn tablename=act_cmmn_hi_plan_item_inst', '', null, '4.3.5', null, null, '4356620765');
|
|
insert into `act_cmmn_databasechangelog` values ('14', 'flowable', 'org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml', '2025-08-05 09:17:05', 13, 'executed', '8:086b40b3a05596dcc8a8d7479922d494', 'addcolumn tablename=act_cmmn_ru_case_inst; addcolumn tablename=act_cmmn_hi_case_inst', '', null, '4.3.5', null, null, '4356620765');
|
|
insert into `act_cmmn_databasechangelog` values ('15', 'flowable', 'org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml', '2025-08-05 09:17:07', 14, 'executed', '8:4554f53663c905ac40a23ea2943f1f5f', 'modifydatatype columnname=deploy_time_, tablename=act_cmmn_deployment; modifydatatype columnname=start_time_, tablename=act_cmmn_ru_case_inst; modifydatatype columnname=create_time_, tablename=act_cmmn_ru_plan_item_inst; modifydatatype columnname=...', '', null, '4.3.5', null, null, '4356620765');
|
|
insert into `act_cmmn_databasechangelog` values ('16', 'flowable', 'org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml', '2025-08-05 09:17:07', 15, 'executed', '8:a697a222ddd99dd15b36516a252f1c63', 'addcolumn tablename=act_cmmn_ru_case_inst; addcolumn tablename=act_cmmn_hi_case_inst', '', null, '4.3.5', null, null, '4356620765');
|
|
insert into `act_cmmn_databasechangelog` values ('17', 'flowable', 'org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml', '2025-08-05 09:17:07', 16, 'executed', '8:d3706c5813a9b97fd2a59d12a9523946', 'createindex indexname=act_idx_hi_case_inst_end, tablename=act_cmmn_hi_case_inst', '', null, '4.3.5', null, null, '4356620765');
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_cmmn_databasechangeloglock
|
|
-- ----------------------------
|
|
drop table if exists `act_cmmn_databasechangeloglock`;
|
|
create table `act_cmmn_databasechangeloglock` (
|
|
`id` int not null,
|
|
`locked` bit(1) not null,
|
|
`lockgranted` datetime null default null,
|
|
`lockedby` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
primary key (`id`) using btree
|
|
) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_cmmn_databasechangeloglock
|
|
-- ----------------------------
|
|
insert into `act_cmmn_databasechangeloglock` values (1, b'0', null, null);
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_cmmn_deployment
|
|
-- ----------------------------
|
|
drop table if exists `act_cmmn_deployment`;
|
|
create table `act_cmmn_deployment` (
|
|
`id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`name_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`category_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`key_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`deploy_time_` datetime(3) null default null,
|
|
`parent_deployment_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`tenant_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default '',
|
|
primary key (`id_`) using btree
|
|
) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_cmmn_deployment
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_cmmn_deployment_resource
|
|
-- ----------------------------
|
|
drop table if exists `act_cmmn_deployment_resource`;
|
|
create table `act_cmmn_deployment_resource` (
|
|
`id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`name_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`deployment_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`resource_bytes_` longblob null,
|
|
`generated_` bit(1) null default null,
|
|
primary key (`id_`) using btree,
|
|
index `act_idx_cmmn_rsrc_dpl`(`deployment_id_` asc) using btree,
|
|
constraint `act_fk_cmmn_rsrc_dpl` foreign key (`deployment_id_`) references `act_cmmn_deployment` (`id_`) on delete restrict on update restrict
|
|
) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_cmmn_deployment_resource
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_cmmn_hi_case_inst
|
|
-- ----------------------------
|
|
drop table if exists `act_cmmn_hi_case_inst`;
|
|
create table `act_cmmn_hi_case_inst` (
|
|
`id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`rev_` int not null,
|
|
`business_key_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`name_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`parent_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`case_def_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`state_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`start_time_` datetime(3) null default null,
|
|
`end_time_` datetime(3) null default null,
|
|
`start_user_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`callback_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`callback_type_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`tenant_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default '',
|
|
`reference_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`reference_type_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`last_reactivation_time_` datetime(3) null default null,
|
|
`last_reactivation_user_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`business_status_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
primary key (`id_`) using btree,
|
|
index `act_idx_hi_case_inst_end`(`end_time_` asc) using btree
|
|
) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_cmmn_hi_case_inst
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_cmmn_hi_mil_inst
|
|
-- ----------------------------
|
|
drop table if exists `act_cmmn_hi_mil_inst`;
|
|
create table `act_cmmn_hi_mil_inst` (
|
|
`id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`rev_` int not null,
|
|
`name_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`time_stamp_` datetime(3) null default null,
|
|
`case_inst_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`case_def_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`element_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`tenant_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default '',
|
|
primary key (`id_`) using btree
|
|
) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_cmmn_hi_mil_inst
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_cmmn_hi_plan_item_inst
|
|
-- ----------------------------
|
|
drop table if exists `act_cmmn_hi_plan_item_inst`;
|
|
create table `act_cmmn_hi_plan_item_inst` (
|
|
`id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`rev_` int not null,
|
|
`name_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`state_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`case_def_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`case_inst_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`stage_inst_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`is_stage_` bit(1) null default null,
|
|
`element_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`item_definition_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`item_definition_type_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`create_time_` datetime(3) null default null,
|
|
`last_available_time_` datetime(3) null default null,
|
|
`last_enabled_time_` datetime(3) null default null,
|
|
`last_disabled_time_` datetime(3) null default null,
|
|
`last_started_time_` datetime(3) null default null,
|
|
`last_suspended_time_` datetime(3) null default null,
|
|
`completed_time_` datetime(3) null default null,
|
|
`occurred_time_` datetime(3) null default null,
|
|
`terminated_time_` datetime(3) null default null,
|
|
`exit_time_` datetime(3) null default null,
|
|
`ended_time_` datetime(3) null default null,
|
|
`last_updated_time_` datetime(3) null default null,
|
|
`start_user_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`reference_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`reference_type_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`tenant_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default '',
|
|
`entry_criterion_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`exit_criterion_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`show_in_overview_` bit(1) null default null,
|
|
`extra_value_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`derived_case_def_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`last_unavailable_time_` datetime(3) null default null,
|
|
primary key (`id_`) using btree
|
|
) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_cmmn_hi_plan_item_inst
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_cmmn_ru_case_inst
|
|
-- ----------------------------
|
|
drop table if exists `act_cmmn_ru_case_inst`;
|
|
create table `act_cmmn_ru_case_inst` (
|
|
`id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`rev_` int not null,
|
|
`business_key_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`name_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`parent_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`case_def_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`state_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`start_time_` datetime(3) null default null,
|
|
`start_user_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`callback_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`callback_type_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`tenant_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default '',
|
|
`lock_time_` datetime(3) null default null,
|
|
`is_completeable_` bit(1) null default null,
|
|
`reference_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`reference_type_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`lock_owner_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`last_reactivation_time_` datetime(3) null default null,
|
|
`last_reactivation_user_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`business_status_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
primary key (`id_`) using btree,
|
|
index `act_idx_case_inst_case_def`(`case_def_id_` asc) using btree,
|
|
index `act_idx_case_inst_parent`(`parent_id_` asc) using btree,
|
|
index `act_idx_case_inst_ref_id_`(`reference_id_` asc) using btree,
|
|
constraint `act_fk_case_inst_case_def` foreign key (`case_def_id_`) references `act_cmmn_casedef` (`id_`) on delete restrict on update restrict
|
|
) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_cmmn_ru_case_inst
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_cmmn_ru_mil_inst
|
|
-- ----------------------------
|
|
drop table if exists `act_cmmn_ru_mil_inst`;
|
|
create table `act_cmmn_ru_mil_inst` (
|
|
`id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`name_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`time_stamp_` datetime(3) null default null,
|
|
`case_inst_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`case_def_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`element_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`tenant_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default '',
|
|
primary key (`id_`) using btree,
|
|
index `act_idx_mil_case_def`(`case_def_id_` asc) using btree,
|
|
index `act_idx_mil_case_inst`(`case_inst_id_` asc) using btree,
|
|
constraint `act_fk_mil_case_def` foreign key (`case_def_id_`) references `act_cmmn_casedef` (`id_`) on delete restrict on update restrict,
|
|
constraint `act_fk_mil_case_inst` foreign key (`case_inst_id_`) references `act_cmmn_ru_case_inst` (`id_`) on delete restrict on update restrict
|
|
) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_cmmn_ru_mil_inst
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_cmmn_ru_plan_item_inst
|
|
-- ----------------------------
|
|
drop table if exists `act_cmmn_ru_plan_item_inst`;
|
|
create table `act_cmmn_ru_plan_item_inst` (
|
|
`id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`rev_` int not null,
|
|
`case_def_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`case_inst_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`stage_inst_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`is_stage_` bit(1) null default null,
|
|
`element_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`name_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`state_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`create_time_` datetime(3) null default null,
|
|
`start_user_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`reference_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`reference_type_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`tenant_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default '',
|
|
`item_definition_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`item_definition_type_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`is_completeable_` bit(1) null default null,
|
|
`is_count_enabled_` bit(1) null default null,
|
|
`var_count_` int null default null,
|
|
`sentry_part_inst_count_` int null default null,
|
|
`last_available_time_` datetime(3) null default null,
|
|
`last_enabled_time_` datetime(3) null default null,
|
|
`last_disabled_time_` datetime(3) null default null,
|
|
`last_started_time_` datetime(3) null default null,
|
|
`last_suspended_time_` datetime(3) null default null,
|
|
`completed_time_` datetime(3) null default null,
|
|
`occurred_time_` datetime(3) null default null,
|
|
`terminated_time_` datetime(3) null default null,
|
|
`exit_time_` datetime(3) null default null,
|
|
`ended_time_` datetime(3) null default null,
|
|
`entry_criterion_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`exit_criterion_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`extra_value_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`derived_case_def_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`last_unavailable_time_` datetime(3) null default null,
|
|
primary key (`id_`) using btree,
|
|
index `act_idx_plan_item_case_def`(`case_def_id_` asc) using btree,
|
|
index `act_idx_plan_item_case_inst`(`case_inst_id_` asc) using btree,
|
|
index `act_idx_plan_item_stage_inst`(`stage_inst_id_` asc) using btree,
|
|
constraint `act_fk_plan_item_case_def` foreign key (`case_def_id_`) references `act_cmmn_casedef` (`id_`) on delete restrict on update restrict,
|
|
constraint `act_fk_plan_item_case_inst` foreign key (`case_inst_id_`) references `act_cmmn_ru_case_inst` (`id_`) on delete restrict on update restrict
|
|
) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_cmmn_ru_plan_item_inst
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_cmmn_ru_sentry_part_inst
|
|
-- ----------------------------
|
|
drop table if exists `act_cmmn_ru_sentry_part_inst`;
|
|
create table `act_cmmn_ru_sentry_part_inst` (
|
|
`id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`rev_` int not null,
|
|
`case_def_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`case_inst_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`plan_item_inst_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`on_part_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`if_part_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`time_stamp_` datetime(3) null default null,
|
|
primary key (`id_`) using btree,
|
|
index `act_idx_sentry_case_def`(`case_def_id_` asc) using btree,
|
|
index `act_idx_sentry_case_inst`(`case_inst_id_` asc) using btree,
|
|
index `act_idx_sentry_plan_item`(`plan_item_inst_id_` asc) using btree,
|
|
constraint `act_fk_sentry_case_def` foreign key (`case_def_id_`) references `act_cmmn_casedef` (`id_`) on delete restrict on update restrict,
|
|
constraint `act_fk_sentry_case_inst` foreign key (`case_inst_id_`) references `act_cmmn_ru_case_inst` (`id_`) on delete restrict on update restrict,
|
|
constraint `act_fk_sentry_plan_item` foreign key (`plan_item_inst_id_`) references `act_cmmn_ru_plan_item_inst` (`id_`) on delete restrict on update restrict
|
|
) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_cmmn_ru_sentry_part_inst
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_co_content_item
|
|
-- ----------------------------
|
|
drop table if exists `act_co_content_item`;
|
|
create table `act_co_content_item` (
|
|
`id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`name_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`mime_type_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`task_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`proc_inst_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`content_store_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`content_store_name_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`field_` varchar(400) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`content_available_` bit(1) null default b'0',
|
|
`created_` timestamp(6) null default null,
|
|
`created_by_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`last_modified_` timestamp(6) null default null,
|
|
`last_modified_by_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`content_size_` bigint null default 0,
|
|
`tenant_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`scope_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`scope_type_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
primary key (`id_`) using btree,
|
|
index `idx_contitem_taskid`(`task_id_` asc) using btree,
|
|
index `idx_contitem_procid`(`proc_inst_id_` asc) using btree,
|
|
index `idx_contitem_scope`(`scope_id_` asc, `scope_type_` asc) using btree
|
|
) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_co_content_item
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_co_databasechangelog
|
|
-- ----------------------------
|
|
drop table if exists `act_co_databasechangelog`;
|
|
create table `act_co_databasechangelog` (
|
|
`id` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`author` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`filename` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`dateexecuted` datetime not null,
|
|
`orderexecuted` int not null,
|
|
`exectype` varchar(10) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`md5sum` varchar(35) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`description` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`comments` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`tag` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`liquibase` varchar(20) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`contexts` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`labels` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`deployment_id` varchar(10) character set utf8mb4 collate utf8mb4_general_ci null default null
|
|
) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_co_databasechangelog
|
|
-- ----------------------------
|
|
insert into `act_co_databasechangelog` values ('1', 'activiti', 'org/flowable/content/db/liquibase/flowable-content-db-changelog.xml', '2025-08-05 09:16:59', 1, 'executed', '8:7644d7165cfe799200a2abdd3419e8b6', 'createtable tablename=act_co_content_item; createindex indexname=idx_contitem_taskid, tablename=act_co_content_item; createindex indexname=idx_contitem_procid, tablename=act_co_content_item', '', null, '4.3.5', null, null, '4356618696');
|
|
insert into `act_co_databasechangelog` values ('2', 'flowable', 'org/flowable/content/db/liquibase/flowable-content-db-changelog.xml', '2025-08-05 09:16:59', 2, 'executed', '8:fe7b11ac7dbbf9c43006b23bbab60bab', 'addcolumn tablename=act_co_content_item; createindex indexname=idx_contitem_scope, tablename=act_co_content_item', '', null, '4.3.5', null, null, '4356618696');
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_co_databasechangeloglock
|
|
-- ----------------------------
|
|
drop table if exists `act_co_databasechangeloglock`;
|
|
create table `act_co_databasechangeloglock` (
|
|
`id` int not null,
|
|
`locked` bit(1) not null,
|
|
`lockgranted` datetime null default null,
|
|
`lockedby` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
primary key (`id`) using btree
|
|
) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_co_databasechangeloglock
|
|
-- ----------------------------
|
|
insert into `act_co_databasechangeloglock` values (1, b'0', null, null);
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_dmn_databasechangelog
|
|
-- ----------------------------
|
|
drop table if exists `act_dmn_databasechangelog`;
|
|
create table `act_dmn_databasechangelog` (
|
|
`id` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`author` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`filename` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`dateexecuted` datetime not null,
|
|
`orderexecuted` int not null,
|
|
`exectype` varchar(10) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`md5sum` varchar(35) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`description` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`comments` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`tag` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`liquibase` varchar(20) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`contexts` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`labels` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`deployment_id` varchar(10) character set utf8mb4 collate utf8mb4_general_ci null default null
|
|
) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_dmn_databasechangelog
|
|
-- ----------------------------
|
|
insert into `act_dmn_databasechangelog` values ('1', 'activiti', 'org/flowable/dmn/db/liquibase/flowable-dmn-db-changelog.xml', '2025-08-05 09:16:51', 1, 'executed', '8:c8701f1c71018b55029f450b2e9a10a1', 'createtable tablename=act_dmn_deployment; createtable tablename=act_dmn_deployment_resource; createtable tablename=act_dmn_decision_table', '', null, '4.3.5', null, null, '4356610577');
|
|
insert into `act_dmn_databasechangelog` values ('2', 'flowable', 'org/flowable/dmn/db/liquibase/flowable-dmn-db-changelog.xml', '2025-08-05 09:16:51', 2, 'executed', '8:47f94b27feb7df8a30d4e338c7bd5fb8', 'createtable tablename=act_dmn_hi_decision_execution', '', null, '4.3.5', null, null, '4356610577');
|
|
insert into `act_dmn_databasechangelog` values ('3', 'flowable', 'org/flowable/dmn/db/liquibase/flowable-dmn-db-changelog.xml', '2025-08-05 09:16:51', 3, 'executed', '8:ac17eae89fbdccb6e08daf3c7797b579', 'addcolumn tablename=act_dmn_hi_decision_execution', '', null, '4.3.5', null, null, '4356610577');
|
|
insert into `act_dmn_databasechangelog` values ('4', 'flowable', 'org/flowable/dmn/db/liquibase/flowable-dmn-db-changelog.xml', '2025-08-05 09:16:52', 4, 'executed', '8:f73aabc4529e7292c2942073d1cff6f9', 'dropcolumn columnname=parent_deployment_id_, tablename=act_dmn_decision_table', '', null, '4.3.5', null, null, '4356610577');
|
|
insert into `act_dmn_databasechangelog` values ('5', 'flowable', 'org/flowable/dmn/db/liquibase/flowable-dmn-db-changelog.xml', '2025-08-05 09:16:52', 5, 'executed', '8:3e03528582dd4eeb4eb41f9b9539140d', 'modifydatatype columnname=deploy_time_, tablename=act_dmn_deployment; modifydatatype columnname=start_time_, tablename=act_dmn_hi_decision_execution; modifydatatype columnname=end_time_, tablename=act_dmn_hi_decision_execution', '', null, '4.3.5', null, null, '4356610577');
|
|
insert into `act_dmn_databasechangelog` values ('6', 'flowable', 'org/flowable/dmn/db/liquibase/flowable-dmn-db-changelog.xml', '2025-08-05 09:16:52', 6, 'executed', '8:646c6a061e0b6e8a62e69844ff96abb0', 'createindex indexname=act_idx_dec_tbl_uniq, tablename=act_dmn_decision_table', '', null, '4.3.5', null, null, '4356610577');
|
|
insert into `act_dmn_databasechangelog` values ('7', 'flowable', 'org/flowable/dmn/db/liquibase/flowable-dmn-db-changelog.xml', '2025-08-05 09:16:52', 7, 'executed', '8:215a499ff7ae77685b55355245b8b708', 'dropindex indexname=act_idx_dec_tbl_uniq, tablename=act_dmn_decision_table; renametable newtablename=act_dmn_decision, oldtablename=act_dmn_decision_table; createindex indexname=act_idx_dmn_dec_uniq, tablename=act_dmn_decision', '', null, '4.3.5', null, null, '4356610577');
|
|
insert into `act_dmn_databasechangelog` values ('8', 'flowable', 'org/flowable/dmn/db/liquibase/flowable-dmn-db-changelog.xml', '2025-08-05 09:16:52', 8, 'executed', '8:5355bee389318afed91a11702f2df032', 'addcolumn tablename=act_dmn_decision', '', null, '4.3.5', null, null, '4356610577');
|
|
insert into `act_dmn_databasechangelog` values ('9', 'flowable', 'org/flowable/dmn/db/liquibase/flowable-dmn-db-changelog.xml', '2025-08-05 09:16:53', 9, 'executed', '8:0fe82086431b1953d293f0199f805876', 'createindex indexname=act_idx_dmn_instance_id, tablename=act_dmn_hi_decision_execution', '', null, '4.3.5', null, null, '4356610577');
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_dmn_databasechangeloglock
|
|
-- ----------------------------
|
|
drop table if exists `act_dmn_databasechangeloglock`;
|
|
create table `act_dmn_databasechangeloglock` (
|
|
`id` int not null,
|
|
`locked` bit(1) not null,
|
|
`lockgranted` datetime null default null,
|
|
`lockedby` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
primary key (`id`) using btree
|
|
) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_dmn_databasechangeloglock
|
|
-- ----------------------------
|
|
insert into `act_dmn_databasechangeloglock` values (1, b'0', null, null);
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_dmn_decision
|
|
-- ----------------------------
|
|
drop table if exists `act_dmn_decision`;
|
|
create table `act_dmn_decision` (
|
|
`id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`name_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`version_` int null default null,
|
|
`key_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`category_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`deployment_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`tenant_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`resource_name_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`description_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`decision_type_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
primary key (`id_`) using btree,
|
|
unique index `act_idx_dmn_dec_uniq`(`key_` asc, `version_` asc, `tenant_id_` asc) using btree
|
|
) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_dmn_decision
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_dmn_deployment
|
|
-- ----------------------------
|
|
drop table if exists `act_dmn_deployment`;
|
|
create table `act_dmn_deployment` (
|
|
`id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`name_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`category_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`deploy_time_` datetime(3) null default null,
|
|
`tenant_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`parent_deployment_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
primary key (`id_`) using btree
|
|
) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_dmn_deployment
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_dmn_deployment_resource
|
|
-- ----------------------------
|
|
drop table if exists `act_dmn_deployment_resource`;
|
|
create table `act_dmn_deployment_resource` (
|
|
`id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`name_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`deployment_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`resource_bytes_` longblob null,
|
|
primary key (`id_`) using btree
|
|
) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_dmn_deployment_resource
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_dmn_hi_decision_execution
|
|
-- ----------------------------
|
|
drop table if exists `act_dmn_hi_decision_execution`;
|
|
create table `act_dmn_hi_decision_execution` (
|
|
`id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`decision_definition_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`deployment_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`start_time_` datetime(3) null default null,
|
|
`end_time_` datetime(3) null default null,
|
|
`instance_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`execution_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`activity_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`failed_` bit(1) null default b'0',
|
|
`tenant_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`execution_json_` longtext character set utf8mb4 collate utf8mb4_general_ci null,
|
|
`scope_type_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
primary key (`id_`) using btree,
|
|
index `act_idx_dmn_instance_id`(`instance_id_` asc) using btree
|
|
) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_dmn_hi_decision_execution
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_evt_log
|
|
-- ----------------------------
|
|
drop table if exists `act_evt_log`;
|
|
create table `act_evt_log` (
|
|
`log_nr_` bigint not null auto_increment,
|
|
`type_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`proc_def_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`proc_inst_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`execution_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`task_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`time_stamp_` timestamp not null default current_timestamp(),
|
|
`user_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`data_` longblob null,
|
|
`lock_owner_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`lock_time_` timestamp null default null,
|
|
`is_processed_` tinyint null default 0,
|
|
primary key (`log_nr_`) using btree
|
|
) engine = innodb auto_increment = 1 character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_evt_log
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_fo_databasechangelog
|
|
-- ----------------------------
|
|
drop table if exists `act_fo_databasechangelog`;
|
|
create table `act_fo_databasechangelog` (
|
|
`id` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`author` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`filename` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`dateexecuted` datetime not null,
|
|
`orderexecuted` int not null,
|
|
`exectype` varchar(10) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`md5sum` varchar(35) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`description` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`comments` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`tag` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`liquibase` varchar(20) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`contexts` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`labels` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`deployment_id` varchar(10) character set utf8mb4 collate utf8mb4_general_ci null default null
|
|
) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_fo_databasechangelog
|
|
-- ----------------------------
|
|
insert into `act_fo_databasechangelog` values ('1', 'activiti', 'org/flowable/form/db/liquibase/flowable-form-db-changelog.xml', '2025-08-05 09:16:56', 1, 'executed', '8:033ebf9380889aed7c453927ecc3250d', 'createtable tablename=act_fo_form_deployment; createtable tablename=act_fo_form_resource; createtable tablename=act_fo_form_definition; createtable tablename=act_fo_form_instance', '', null, '4.3.5', null, null, '4356613942');
|
|
insert into `act_fo_databasechangelog` values ('2', 'flowable', 'org/flowable/form/db/liquibase/flowable-form-db-changelog.xml', '2025-08-05 09:16:56', 2, 'executed', '8:986365ceb40445ce3b27a8e6b40f159b', 'addcolumn tablename=act_fo_form_instance', '', null, '4.3.5', null, null, '4356613942');
|
|
insert into `act_fo_databasechangelog` values ('3', 'flowable', 'org/flowable/form/db/liquibase/flowable-form-db-changelog.xml', '2025-08-05 09:16:56', 3, 'executed', '8:abf482518ceb09830ef674e52c06bf15', 'dropcolumn columnname=parent_deployment_id_, tablename=act_fo_form_definition', '', null, '4.3.5', null, null, '4356613942');
|
|
insert into `act_fo_databasechangelog` values ('4', 'flowable', 'org/flowable/form/db/liquibase/flowable-form-db-changelog.xml', '2025-08-05 09:16:57', 4, 'executed', '8:2087829f22a4b2298dbf530681c74854', 'modifydatatype columnname=deploy_time_, tablename=act_fo_form_deployment; modifydatatype columnname=submitted_date_, tablename=act_fo_form_instance', '', null, '4.3.5', null, null, '4356613942');
|
|
insert into `act_fo_databasechangelog` values ('5', 'flowable', 'org/flowable/form/db/liquibase/flowable-form-db-changelog.xml', '2025-08-05 09:16:57', 5, 'executed', '8:b4be732b89e5ca028bdd520c6ad4d446', 'createindex indexname=act_idx_form_def_uniq, tablename=act_fo_form_definition', '', null, '4.3.5', null, null, '4356613942');
|
|
insert into `act_fo_databasechangelog` values ('6', 'flowable', 'org/flowable/form/db/liquibase/flowable-form-db-changelog.xml', '2025-08-05 09:16:57', 6, 'executed', '8:384bbd364a649b67c3ca1bcb72fe537f', 'createindex indexname=act_idx_form_task, tablename=act_fo_form_instance; createindex indexname=act_idx_form_proc, tablename=act_fo_form_instance; createindex indexname=act_idx_form_scope, tablename=act_fo_form_instance', '', null, '4.3.5', null, null, '4356613942');
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_fo_databasechangeloglock
|
|
-- ----------------------------
|
|
drop table if exists `act_fo_databasechangeloglock`;
|
|
create table `act_fo_databasechangeloglock` (
|
|
`id` int not null,
|
|
`locked` bit(1) not null,
|
|
`lockgranted` datetime null default null,
|
|
`lockedby` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
primary key (`id`) using btree
|
|
) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_fo_databasechangeloglock
|
|
-- ----------------------------
|
|
insert into `act_fo_databasechangeloglock` values (1, b'0', null, null);
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_fo_form_definition
|
|
-- ----------------------------
|
|
drop table if exists `act_fo_form_definition`;
|
|
create table `act_fo_form_definition` (
|
|
`id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`name_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`version_` int null default null,
|
|
`key_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`category_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`deployment_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`tenant_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`resource_name_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`description_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
primary key (`id_`) using btree,
|
|
unique index `act_idx_form_def_uniq`(`key_` asc, `version_` asc, `tenant_id_` asc) using btree
|
|
) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_fo_form_definition
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_fo_form_deployment
|
|
-- ----------------------------
|
|
drop table if exists `act_fo_form_deployment`;
|
|
create table `act_fo_form_deployment` (
|
|
`id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`name_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`category_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`deploy_time_` datetime(3) null default null,
|
|
`tenant_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`parent_deployment_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
primary key (`id_`) using btree
|
|
) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_fo_form_deployment
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_fo_form_instance
|
|
-- ----------------------------
|
|
drop table if exists `act_fo_form_instance`;
|
|
create table `act_fo_form_instance` (
|
|
`id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`form_definition_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`task_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`proc_inst_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`proc_def_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`submitted_date_` datetime(3) null default null,
|
|
`submitted_by_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`form_values_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`tenant_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`scope_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`scope_type_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`scope_definition_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
primary key (`id_`) using btree,
|
|
index `act_idx_form_task`(`task_id_` asc) using btree,
|
|
index `act_idx_form_proc`(`proc_inst_id_` asc) using btree,
|
|
index `act_idx_form_scope`(`scope_id_` asc, `scope_type_` asc) using btree
|
|
) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_fo_form_instance
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_fo_form_resource
|
|
-- ----------------------------
|
|
drop table if exists `act_fo_form_resource`;
|
|
create table `act_fo_form_resource` (
|
|
`id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`name_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`deployment_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`resource_bytes_` longblob null,
|
|
primary key (`id_`) using btree
|
|
) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_fo_form_resource
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_ge_bytearray
|
|
-- ----------------------------
|
|
drop table if exists `act_ge_bytearray`;
|
|
create table `act_ge_bytearray` (
|
|
`id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`rev_` int null default null,
|
|
`name_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`deployment_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`bytes_` longblob null,
|
|
`generated_` tinyint null default null,
|
|
primary key (`id_`) using btree,
|
|
index `act_fk_bytearr_depl`(`deployment_id_` asc) using btree,
|
|
constraint `act_fk_bytearr_depl` foreign key (`deployment_id_`) references `act_re_deployment` (`id_`) on delete restrict on update restrict
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_ge_bytearray
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_ge_property
|
|
-- ----------------------------
|
|
drop table if exists `act_ge_property`;
|
|
create table `act_ge_property` (
|
|
`name_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`value_` varchar(300) character set utf8 collate utf8_bin null default null,
|
|
`rev_` int null default null,
|
|
primary key (`name_`) using btree
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_ge_property
|
|
-- ----------------------------
|
|
insert into `act_ge_property` values ('batch.schema.version', '6.8.0.0', 1);
|
|
insert into `act_ge_property` values ('cfg.execution-related-entities-count', 'true', 1);
|
|
insert into `act_ge_property` values ('cfg.task-related-entities-count', 'true', 1);
|
|
insert into `act_ge_property` values ('common.schema.version', '6.8.0.0', 1);
|
|
insert into `act_ge_property` values ('entitylink.schema.version', '6.8.0.0', 1);
|
|
insert into `act_ge_property` values ('eventsubscription.schema.version', '6.8.0.0', 1);
|
|
insert into `act_ge_property` values ('identitylink.schema.version', '6.8.0.0', 1);
|
|
insert into `act_ge_property` values ('job.schema.version', '6.8.0.0', 1);
|
|
insert into `act_ge_property` values ('next.dbid', '1', 1);
|
|
insert into `act_ge_property` values ('schema.history', 'create(6.8.0.0)', 1);
|
|
insert into `act_ge_property` values ('schema.version', '6.8.0.0', 1);
|
|
insert into `act_ge_property` values ('task.schema.version', '6.8.0.0', 1);
|
|
insert into `act_ge_property` values ('variable.schema.version', '6.8.0.0', 1);
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_hi_actinst
|
|
-- ----------------------------
|
|
drop table if exists `act_hi_actinst`;
|
|
create table `act_hi_actinst` (
|
|
`id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`rev_` int null default 1,
|
|
`proc_def_id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`proc_inst_id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`execution_id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`act_id_` varchar(255) character set utf8 collate utf8_bin not null,
|
|
`task_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`call_proc_inst_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`act_name_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`act_type_` varchar(255) character set utf8 collate utf8_bin not null,
|
|
`assignee_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`start_time_` datetime not null,
|
|
`end_time_` datetime null default null,
|
|
`transaction_order_` int null default null,
|
|
`duration_` bigint null default null,
|
|
`delete_reason_` varchar(4000) character set utf8 collate utf8_bin null default null,
|
|
`tenant_id_` varchar(255) character set utf8 collate utf8_bin null default '',
|
|
primary key (`id_`) using btree,
|
|
index `act_idx_hi_act_inst_start`(`start_time_` asc) using btree,
|
|
index `act_idx_hi_act_inst_end`(`end_time_` asc) using btree,
|
|
index `act_idx_hi_act_inst_procinst`(`proc_inst_id_` asc, `act_id_` asc) using btree,
|
|
index `act_idx_hi_act_inst_exec`(`execution_id_` asc, `act_id_` asc) using btree
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_hi_actinst
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_hi_attachment
|
|
-- ----------------------------
|
|
drop table if exists `act_hi_attachment`;
|
|
create table `act_hi_attachment` (
|
|
`id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`rev_` int null default null,
|
|
`user_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`name_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`description_` varchar(4000) character set utf8 collate utf8_bin null default null,
|
|
`type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`task_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`proc_inst_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`url_` varchar(4000) character set utf8 collate utf8_bin null default null,
|
|
`content_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`time_` datetime null default null,
|
|
primary key (`id_`) using btree
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_hi_attachment
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_hi_comment
|
|
-- ----------------------------
|
|
drop table if exists `act_hi_comment`;
|
|
create table `act_hi_comment` (
|
|
`id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`time_` datetime not null,
|
|
`user_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`task_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`proc_inst_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`action_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`message_` varchar(4000) character set utf8 collate utf8_bin null default null,
|
|
`full_msg_` longblob null,
|
|
primary key (`id_`) using btree
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_hi_comment
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_hi_detail
|
|
-- ----------------------------
|
|
drop table if exists `act_hi_detail`;
|
|
create table `act_hi_detail` (
|
|
`id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`type_` varchar(255) character set utf8 collate utf8_bin not null,
|
|
`proc_inst_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`execution_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`task_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`act_inst_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`name_` varchar(255) character set utf8 collate utf8_bin not null,
|
|
`var_type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`rev_` int null default null,
|
|
`time_` datetime not null,
|
|
`bytearray_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`double_` double null default null,
|
|
`long_` bigint null default null,
|
|
`text_` varchar(4000) character set utf8 collate utf8_bin null default null,
|
|
`text2_` varchar(4000) character set utf8 collate utf8_bin null default null,
|
|
primary key (`id_`) using btree,
|
|
index `act_idx_hi_detail_proc_inst`(`proc_inst_id_` asc) using btree,
|
|
index `act_idx_hi_detail_act_inst`(`act_inst_id_` asc) using btree,
|
|
index `act_idx_hi_detail_time`(`time_` asc) using btree,
|
|
index `act_idx_hi_detail_name`(`name_` asc) using btree,
|
|
index `act_idx_hi_detail_task_id`(`task_id_` asc) using btree
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_hi_detail
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_hi_entitylink
|
|
-- ----------------------------
|
|
drop table if exists `act_hi_entitylink`;
|
|
create table `act_hi_entitylink` (
|
|
`id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`link_type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`create_time_` datetime null default null,
|
|
`scope_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`sub_scope_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`scope_type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`scope_definition_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`parent_element_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`ref_scope_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`ref_scope_type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`ref_scope_definition_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`root_scope_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`root_scope_type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`hierarchy_type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
primary key (`id_`) using btree,
|
|
index `act_idx_hi_ent_lnk_scope`(`scope_id_` asc, `scope_type_` asc, `link_type_` asc) using btree,
|
|
index `act_idx_hi_ent_lnk_ref_scope`(`ref_scope_id_` asc, `ref_scope_type_` asc, `link_type_` asc) using btree,
|
|
index `act_idx_hi_ent_lnk_root_scope`(`root_scope_id_` asc, `root_scope_type_` asc, `link_type_` asc) using btree,
|
|
index `act_idx_hi_ent_lnk_scope_def`(`scope_definition_id_` asc, `scope_type_` asc, `link_type_` asc) using btree
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_hi_entitylink
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_hi_identitylink
|
|
-- ----------------------------
|
|
drop table if exists `act_hi_identitylink`;
|
|
create table `act_hi_identitylink` (
|
|
`id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`group_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`user_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`task_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`create_time_` datetime null default null,
|
|
`proc_inst_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`scope_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`sub_scope_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`scope_type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`scope_definition_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
primary key (`id_`) using btree,
|
|
index `act_idx_hi_ident_lnk_user`(`user_id_` asc) using btree,
|
|
index `act_idx_hi_ident_lnk_scope`(`scope_id_` asc, `scope_type_` asc) using btree,
|
|
index `act_idx_hi_ident_lnk_sub_scope`(`sub_scope_id_` asc, `scope_type_` asc) using btree,
|
|
index `act_idx_hi_ident_lnk_scope_def`(`scope_definition_id_` asc, `scope_type_` asc) using btree,
|
|
index `act_idx_hi_ident_lnk_task`(`task_id_` asc) using btree,
|
|
index `act_idx_hi_ident_lnk_procinst`(`proc_inst_id_` asc) using btree
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_hi_identitylink
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_hi_procinst
|
|
-- ----------------------------
|
|
drop table if exists `act_hi_procinst`;
|
|
create table `act_hi_procinst` (
|
|
`id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`rev_` int null default 1,
|
|
`proc_inst_id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`business_key_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`proc_def_id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`start_time_` datetime not null,
|
|
`end_time_` datetime null default null,
|
|
`duration_` bigint null default null,
|
|
`start_user_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`start_act_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`end_act_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`super_process_instance_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`delete_reason_` varchar(4000) character set utf8 collate utf8_bin null default null,
|
|
`tenant_id_` varchar(255) character set utf8 collate utf8_bin null default '',
|
|
`name_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`callback_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`callback_type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`reference_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`reference_type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`propagated_stage_inst_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`business_status_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
primary key (`id_`) using btree,
|
|
unique index `proc_inst_id_`(`proc_inst_id_` asc) using btree,
|
|
index `act_idx_hi_pro_inst_end`(`end_time_` asc) using btree,
|
|
index `act_idx_hi_pro_i_buskey`(`business_key_` asc) using btree,
|
|
index `act_idx_hi_pro_super_procinst`(`super_process_instance_id_` asc) using btree
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_hi_procinst
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_hi_taskinst
|
|
-- ----------------------------
|
|
drop table if exists `act_hi_taskinst`;
|
|
create table `act_hi_taskinst` (
|
|
`id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`rev_` int null default 1,
|
|
`proc_def_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`task_def_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`task_def_key_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`proc_inst_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`execution_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`scope_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`sub_scope_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`scope_type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`scope_definition_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`propagated_stage_inst_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`name_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`parent_task_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`description_` varchar(4000) character set utf8 collate utf8_bin null default null,
|
|
`owner_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`assignee_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`start_time_` datetime not null,
|
|
`claim_time_` datetime null default null,
|
|
`end_time_` datetime null default null,
|
|
`duration_` bigint null default null,
|
|
`delete_reason_` varchar(4000) character set utf8 collate utf8_bin null default null,
|
|
`priority_` int null default null,
|
|
`due_date_` datetime null default null,
|
|
`form_key_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`category_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`tenant_id_` varchar(255) character set utf8 collate utf8_bin null default '',
|
|
`last_updated_time_` datetime null default null,
|
|
primary key (`id_`) using btree,
|
|
index `act_idx_hi_task_scope`(`scope_id_` asc, `scope_type_` asc) using btree,
|
|
index `act_idx_hi_task_sub_scope`(`sub_scope_id_` asc, `scope_type_` asc) using btree,
|
|
index `act_idx_hi_task_scope_def`(`scope_definition_id_` asc, `scope_type_` asc) using btree,
|
|
index `act_idx_hi_task_inst_procinst`(`proc_inst_id_` asc) using btree
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_hi_taskinst
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_hi_tsk_log
|
|
-- ----------------------------
|
|
drop table if exists `act_hi_tsk_log`;
|
|
create table `act_hi_tsk_log` (
|
|
`id_` bigint not null auto_increment,
|
|
`type_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`task_id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`time_stamp_` timestamp not null default current_timestamp() on update current_timestamp,
|
|
`user_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`data_` varchar(4000) character set utf8 collate utf8_bin null default null,
|
|
`execution_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`proc_inst_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`proc_def_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`scope_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`scope_definition_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`sub_scope_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`scope_type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`tenant_id_` varchar(255) character set utf8 collate utf8_bin null default '',
|
|
primary key (`id_`) using btree
|
|
) engine = innodb auto_increment = 1 character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_hi_tsk_log
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_hi_varinst
|
|
-- ----------------------------
|
|
drop table if exists `act_hi_varinst`;
|
|
create table `act_hi_varinst` (
|
|
`id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`rev_` int null default 1,
|
|
`proc_inst_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`execution_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`task_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`name_` varchar(255) character set utf8 collate utf8_bin not null,
|
|
`var_type_` varchar(100) character set utf8 collate utf8_bin null default null,
|
|
`scope_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`sub_scope_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`scope_type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`bytearray_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`double_` double null default null,
|
|
`long_` bigint null default null,
|
|
`text_` varchar(4000) character set utf8 collate utf8_bin null default null,
|
|
`text2_` varchar(4000) character set utf8 collate utf8_bin null default null,
|
|
`create_time_` datetime null default null,
|
|
`last_updated_time_` datetime null default null,
|
|
primary key (`id_`) using btree,
|
|
index `act_idx_hi_procvar_name_type`(`name_` asc, `var_type_` asc) using btree,
|
|
index `act_idx_hi_var_scope_id_type`(`scope_id_` asc, `scope_type_` asc) using btree,
|
|
index `act_idx_hi_var_sub_id_type`(`sub_scope_id_` asc, `scope_type_` asc) using btree,
|
|
index `act_idx_hi_procvar_proc_inst`(`proc_inst_id_` asc) using btree,
|
|
index `act_idx_hi_procvar_task_id`(`task_id_` asc) using btree,
|
|
index `act_idx_hi_procvar_exe`(`execution_id_` asc) using btree
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_hi_varinst
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_id_bytearray
|
|
-- ----------------------------
|
|
drop table if exists `act_id_bytearray`;
|
|
create table `act_id_bytearray` (
|
|
`id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`rev_` int null default null,
|
|
`name_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`bytes_` longblob null,
|
|
primary key (`id_`) using btree
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_id_bytearray
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_id_group
|
|
-- ----------------------------
|
|
drop table if exists `act_id_group`;
|
|
create table `act_id_group` (
|
|
`id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`rev_` int null default null,
|
|
`name_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
primary key (`id_`) using btree
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_id_group
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_id_info
|
|
-- ----------------------------
|
|
drop table if exists `act_id_info`;
|
|
create table `act_id_info` (
|
|
`id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`rev_` int null default null,
|
|
`user_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`type_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`key_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`value_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`password_` longblob null,
|
|
`parent_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
primary key (`id_`) using btree
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_id_info
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_id_membership
|
|
-- ----------------------------
|
|
drop table if exists `act_id_membership`;
|
|
create table `act_id_membership` (
|
|
`user_id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`group_id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
primary key (`user_id_`, `group_id_`) using btree,
|
|
index `act_fk_memb_group`(`group_id_` asc) using btree,
|
|
constraint `act_fk_memb_group` foreign key (`group_id_`) references `act_id_group` (`id_`) on delete restrict on update restrict,
|
|
constraint `act_fk_memb_user` foreign key (`user_id_`) references `act_id_user` (`id_`) on delete restrict on update restrict
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_id_membership
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_id_priv
|
|
-- ----------------------------
|
|
drop table if exists `act_id_priv`;
|
|
create table `act_id_priv` (
|
|
`id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`name_` varchar(255) character set utf8 collate utf8_bin not null,
|
|
primary key (`id_`) using btree,
|
|
unique index `act_uniq_priv_name`(`name_` asc) using btree
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_id_priv
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_id_priv_mapping
|
|
-- ----------------------------
|
|
drop table if exists `act_id_priv_mapping`;
|
|
create table `act_id_priv_mapping` (
|
|
`id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`priv_id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`user_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`group_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
primary key (`id_`) using btree,
|
|
index `act_fk_priv_mapping`(`priv_id_` asc) using btree,
|
|
index `act_idx_priv_user`(`user_id_` asc) using btree,
|
|
index `act_idx_priv_group`(`group_id_` asc) using btree,
|
|
constraint `act_fk_priv_mapping` foreign key (`priv_id_`) references `act_id_priv` (`id_`) on delete restrict on update restrict
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_id_priv_mapping
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_id_property
|
|
-- ----------------------------
|
|
drop table if exists `act_id_property`;
|
|
create table `act_id_property` (
|
|
`name_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`value_` varchar(300) character set utf8 collate utf8_bin null default null,
|
|
`rev_` int null default null,
|
|
primary key (`name_`) using btree
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_id_property
|
|
-- ----------------------------
|
|
insert into `act_id_property` values ('schema.version', '6.8.0.0', 1);
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_id_token
|
|
-- ----------------------------
|
|
drop table if exists `act_id_token`;
|
|
create table `act_id_token` (
|
|
`id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`rev_` int null default null,
|
|
`token_value_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`token_date_` timestamp not null default current_timestamp() on update current_timestamp,
|
|
`ip_address_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`user_agent_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`user_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`token_data_` varchar(2000) character set utf8 collate utf8_bin null default null,
|
|
primary key (`id_`) using btree
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_id_token
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_id_user
|
|
-- ----------------------------
|
|
drop table if exists `act_id_user`;
|
|
create table `act_id_user` (
|
|
`id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`rev_` int null default null,
|
|
`first_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`last_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`display_name_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`email_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`pwd_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`picture_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`tenant_id_` varchar(255) character set utf8 collate utf8_bin null default '',
|
|
primary key (`id_`) using btree
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_id_user
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_procdef_info
|
|
-- ----------------------------
|
|
drop table if exists `act_procdef_info`;
|
|
create table `act_procdef_info` (
|
|
`id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`proc_def_id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`rev_` int null default null,
|
|
`info_json_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
primary key (`id_`) using btree,
|
|
unique index `act_uniq_info_procdef`(`proc_def_id_` asc) using btree,
|
|
index `act_idx_info_procdef`(`proc_def_id_` asc) using btree,
|
|
index `act_fk_info_json_ba`(`info_json_id_` asc) using btree,
|
|
constraint `act_fk_info_json_ba` foreign key (`info_json_id_`) references `act_ge_bytearray` (`id_`) on delete restrict on update restrict,
|
|
constraint `act_fk_info_procdef` foreign key (`proc_def_id_`) references `act_re_procdef` (`id_`) on delete restrict on update restrict
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_procdef_info
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_re_deployment
|
|
-- ----------------------------
|
|
drop table if exists `act_re_deployment`;
|
|
create table `act_re_deployment` (
|
|
`id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`name_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`category_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`key_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`tenant_id_` varchar(255) character set utf8 collate utf8_bin null default '',
|
|
`deploy_time_` timestamp null default null,
|
|
`derived_from_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`derived_from_root_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`parent_deployment_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`engine_version_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
primary key (`id_`) using btree
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_re_deployment
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_re_model
|
|
-- ----------------------------
|
|
drop table if exists `act_re_model`;
|
|
create table `act_re_model` (
|
|
`id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`rev_` int null default null,
|
|
`name_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`key_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`category_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`create_time_` timestamp null default null,
|
|
`last_update_time_` timestamp null default null,
|
|
`version_` int null default null,
|
|
`meta_info_` varchar(4000) character set utf8 collate utf8_bin null default null,
|
|
`deployment_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`editor_source_value_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`editor_source_extra_value_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`tenant_id_` varchar(255) character set utf8 collate utf8_bin null default '',
|
|
primary key (`id_`) using btree,
|
|
index `act_fk_model_source`(`editor_source_value_id_` asc) using btree,
|
|
index `act_fk_model_source_extra`(`editor_source_extra_value_id_` asc) using btree,
|
|
index `act_fk_model_deployment`(`deployment_id_` asc) using btree,
|
|
constraint `act_fk_model_deployment` foreign key (`deployment_id_`) references `act_re_deployment` (`id_`) on delete restrict on update restrict,
|
|
constraint `act_fk_model_source` foreign key (`editor_source_value_id_`) references `act_ge_bytearray` (`id_`) on delete restrict on update restrict,
|
|
constraint `act_fk_model_source_extra` foreign key (`editor_source_extra_value_id_`) references `act_ge_bytearray` (`id_`) on delete restrict on update restrict
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_re_model
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_re_procdef
|
|
-- ----------------------------
|
|
drop table if exists `act_re_procdef`;
|
|
create table `act_re_procdef` (
|
|
`id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`rev_` int null default null,
|
|
`category_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`name_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`key_` varchar(255) character set utf8 collate utf8_bin not null,
|
|
`version_` int not null,
|
|
`deployment_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`resource_name_` varchar(4000) character set utf8 collate utf8_bin null default null,
|
|
`dgrm_resource_name_` varchar(4000) character set utf8 collate utf8_bin null default null,
|
|
`description_` varchar(4000) character set utf8 collate utf8_bin null default null,
|
|
`has_start_form_key_` tinyint null default null,
|
|
`has_graphical_notation_` tinyint null default null,
|
|
`suspension_state_` int null default null,
|
|
`tenant_id_` varchar(255) character set utf8 collate utf8_bin null default '',
|
|
`engine_version_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`derived_from_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`derived_from_root_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`derived_version_` int not null default 0,
|
|
primary key (`id_`) using btree,
|
|
unique index `act_uniq_procdef`(`key_` asc, `version_` asc, `derived_version_` asc, `tenant_id_` asc) using btree
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_re_procdef
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_ru_actinst
|
|
-- ----------------------------
|
|
drop table if exists `act_ru_actinst`;
|
|
create table `act_ru_actinst` (
|
|
`id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`rev_` int null default 1,
|
|
`proc_def_id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`proc_inst_id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`execution_id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`act_id_` varchar(255) character set utf8 collate utf8_bin not null,
|
|
`task_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`call_proc_inst_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`act_name_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`act_type_` varchar(255) character set utf8 collate utf8_bin not null,
|
|
`assignee_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`start_time_` datetime not null,
|
|
`end_time_` datetime null default null,
|
|
`duration_` bigint null default null,
|
|
`transaction_order_` int null default null,
|
|
`delete_reason_` varchar(4000) character set utf8 collate utf8_bin null default null,
|
|
`tenant_id_` varchar(255) character set utf8 collate utf8_bin null default '',
|
|
primary key (`id_`) using btree,
|
|
index `act_idx_ru_acti_start`(`start_time_` asc) using btree,
|
|
index `act_idx_ru_acti_end`(`end_time_` asc) using btree,
|
|
index `act_idx_ru_acti_proc`(`proc_inst_id_` asc) using btree,
|
|
index `act_idx_ru_acti_proc_act`(`proc_inst_id_` asc, `act_id_` asc) using btree,
|
|
index `act_idx_ru_acti_exec`(`execution_id_` asc) using btree,
|
|
index `act_idx_ru_acti_exec_act`(`execution_id_` asc, `act_id_` asc) using btree,
|
|
index `act_idx_ru_acti_task`(`task_id_` asc) using btree
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_ru_actinst
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_ru_deadletter_job
|
|
-- ----------------------------
|
|
drop table if exists `act_ru_deadletter_job`;
|
|
create table `act_ru_deadletter_job` (
|
|
`id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`rev_` int null default null,
|
|
`category_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`type_` varchar(255) character set utf8 collate utf8_bin not null,
|
|
`exclusive_` tinyint(1) null default null,
|
|
`execution_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`process_instance_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`proc_def_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`element_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`element_name_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`scope_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`sub_scope_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`scope_type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`scope_definition_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`correlation_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`exception_stack_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`exception_msg_` varchar(4000) character set utf8 collate utf8_bin null default null,
|
|
`duedate_` timestamp null default null,
|
|
`repeat_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`handler_type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`handler_cfg_` varchar(4000) character set utf8 collate utf8_bin null default null,
|
|
`custom_values_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`create_time_` timestamp null default null,
|
|
`tenant_id_` varchar(255) character set utf8 collate utf8_bin null default '',
|
|
primary key (`id_`) using btree,
|
|
index `act_idx_deadletter_job_exception_stack_id`(`exception_stack_id_` asc) using btree,
|
|
index `act_idx_deadletter_job_custom_values_id`(`custom_values_id_` asc) using btree,
|
|
index `act_idx_deadletter_job_correlation_id`(`correlation_id_` asc) using btree,
|
|
index `act_idx_djob_scope`(`scope_id_` asc, `scope_type_` asc) using btree,
|
|
index `act_idx_djob_sub_scope`(`sub_scope_id_` asc, `scope_type_` asc) using btree,
|
|
index `act_idx_djob_scope_def`(`scope_definition_id_` asc, `scope_type_` asc) using btree,
|
|
index `act_fk_deadletter_job_execution`(`execution_id_` asc) using btree,
|
|
index `act_fk_deadletter_job_process_instance`(`process_instance_id_` asc) using btree,
|
|
index `act_fk_deadletter_job_proc_def`(`proc_def_id_` asc) using btree,
|
|
constraint `act_fk_deadletter_job_custom_values` foreign key (`custom_values_id_`) references `act_ge_bytearray` (`id_`) on delete restrict on update restrict,
|
|
constraint `act_fk_deadletter_job_exception` foreign key (`exception_stack_id_`) references `act_ge_bytearray` (`id_`) on delete restrict on update restrict,
|
|
constraint `act_fk_deadletter_job_execution` foreign key (`execution_id_`) references `act_ru_execution` (`id_`) on delete restrict on update restrict,
|
|
constraint `act_fk_deadletter_job_process_instance` foreign key (`process_instance_id_`) references `act_ru_execution` (`id_`) on delete restrict on update restrict,
|
|
constraint `act_fk_deadletter_job_proc_def` foreign key (`proc_def_id_`) references `act_re_procdef` (`id_`) on delete restrict on update restrict
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_ru_deadletter_job
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_ru_entitylink
|
|
-- ----------------------------
|
|
drop table if exists `act_ru_entitylink`;
|
|
create table `act_ru_entitylink` (
|
|
`id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`rev_` int null default null,
|
|
`create_time_` datetime null default null,
|
|
`link_type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`scope_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`sub_scope_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`scope_type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`scope_definition_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`parent_element_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`ref_scope_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`ref_scope_type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`ref_scope_definition_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`root_scope_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`root_scope_type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`hierarchy_type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
primary key (`id_`) using btree,
|
|
index `act_idx_ent_lnk_scope`(`scope_id_` asc, `scope_type_` asc, `link_type_` asc) using btree,
|
|
index `act_idx_ent_lnk_ref_scope`(`ref_scope_id_` asc, `ref_scope_type_` asc, `link_type_` asc) using btree,
|
|
index `act_idx_ent_lnk_root_scope`(`root_scope_id_` asc, `root_scope_type_` asc, `link_type_` asc) using btree,
|
|
index `act_idx_ent_lnk_scope_def`(`scope_definition_id_` asc, `scope_type_` asc, `link_type_` asc) using btree
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_ru_entitylink
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_ru_event_subscr
|
|
-- ----------------------------
|
|
drop table if exists `act_ru_event_subscr`;
|
|
create table `act_ru_event_subscr` (
|
|
`id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`rev_` int null default null,
|
|
`event_type_` varchar(255) character set utf8 collate utf8_bin not null,
|
|
`event_name_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`execution_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`proc_inst_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`activity_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`configuration_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`created_` timestamp not null default current_timestamp(),
|
|
`proc_def_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`sub_scope_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`scope_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`scope_definition_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`scope_type_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`lock_time_` timestamp null default null,
|
|
`lock_owner_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`tenant_id_` varchar(255) character set utf8 collate utf8_bin null default '',
|
|
primary key (`id_`) using btree,
|
|
index `act_idx_event_subscr_config_`(`configuration_` asc) using btree,
|
|
index `act_idx_event_subscr_scoperef_`(`scope_id_` asc, `scope_type_` asc) using btree,
|
|
index `act_fk_event_exec`(`execution_id_` asc) using btree,
|
|
constraint `act_fk_event_exec` foreign key (`execution_id_`) references `act_ru_execution` (`id_`) on delete restrict on update restrict
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_ru_event_subscr
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_ru_execution
|
|
-- ----------------------------
|
|
drop table if exists `act_ru_execution`;
|
|
create table `act_ru_execution` (
|
|
`id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`rev_` int null default null,
|
|
`proc_inst_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`business_key_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`parent_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`proc_def_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`super_exec_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`root_proc_inst_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`act_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`is_active_` tinyint null default null,
|
|
`is_concurrent_` tinyint null default null,
|
|
`is_scope_` tinyint null default null,
|
|
`is_event_scope_` tinyint null default null,
|
|
`is_mi_root_` tinyint null default null,
|
|
`suspension_state_` int null default null,
|
|
`cached_ent_state_` int null default null,
|
|
`tenant_id_` varchar(255) character set utf8 collate utf8_bin null default '',
|
|
`name_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`start_act_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`start_time_` datetime null default null,
|
|
`start_user_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`lock_time_` timestamp null default null,
|
|
`lock_owner_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`is_count_enabled_` tinyint null default null,
|
|
`evt_subscr_count_` int null default null,
|
|
`task_count_` int null default null,
|
|
`job_count_` int null default null,
|
|
`timer_job_count_` int null default null,
|
|
`susp_job_count_` int null default null,
|
|
`deadletter_job_count_` int null default null,
|
|
`external_worker_job_count_` int null default null,
|
|
`var_count_` int null default null,
|
|
`id_link_count_` int null default null,
|
|
`callback_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`callback_type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`reference_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`reference_type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`propagated_stage_inst_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`business_status_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
primary key (`id_`) using btree,
|
|
index `act_idx_exec_buskey`(`business_key_` asc) using btree,
|
|
index `act_idc_exec_root`(`root_proc_inst_id_` asc) using btree,
|
|
index `act_idx_exec_ref_id_`(`reference_id_` asc) using btree,
|
|
index `act_fk_exe_procinst`(`proc_inst_id_` asc) using btree,
|
|
index `act_fk_exe_parent`(`parent_id_` asc) using btree,
|
|
index `act_fk_exe_super`(`super_exec_` asc) using btree,
|
|
index `act_fk_exe_procdef`(`proc_def_id_` asc) using btree,
|
|
constraint `act_fk_exe_parent` foreign key (`parent_id_`) references `act_ru_execution` (`id_`) on delete cascade on update restrict,
|
|
constraint `act_fk_exe_procdef` foreign key (`proc_def_id_`) references `act_re_procdef` (`id_`) on delete restrict on update restrict,
|
|
constraint `act_fk_exe_procinst` foreign key (`proc_inst_id_`) references `act_ru_execution` (`id_`) on delete cascade on update cascade,
|
|
constraint `act_fk_exe_super` foreign key (`super_exec_`) references `act_ru_execution` (`id_`) on delete cascade on update restrict
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_ru_execution
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_ru_external_job
|
|
-- ----------------------------
|
|
drop table if exists `act_ru_external_job`;
|
|
create table `act_ru_external_job` (
|
|
`id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`rev_` int null default null,
|
|
`category_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`type_` varchar(255) character set utf8 collate utf8_bin not null,
|
|
`lock_exp_time_` timestamp null default null,
|
|
`lock_owner_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`exclusive_` tinyint(1) null default null,
|
|
`execution_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`process_instance_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`proc_def_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`element_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`element_name_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`scope_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`sub_scope_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`scope_type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`scope_definition_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`correlation_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`retries_` int null default null,
|
|
`exception_stack_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`exception_msg_` varchar(4000) character set utf8 collate utf8_bin null default null,
|
|
`duedate_` timestamp null default null,
|
|
`repeat_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`handler_type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`handler_cfg_` varchar(4000) character set utf8 collate utf8_bin null default null,
|
|
`custom_values_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`create_time_` timestamp null default null,
|
|
`tenant_id_` varchar(255) character set utf8 collate utf8_bin null default '',
|
|
primary key (`id_`) using btree,
|
|
index `act_idx_external_job_exception_stack_id`(`exception_stack_id_` asc) using btree,
|
|
index `act_idx_external_job_custom_values_id`(`custom_values_id_` asc) using btree,
|
|
index `act_idx_external_job_correlation_id`(`correlation_id_` asc) using btree,
|
|
index `act_idx_ejob_scope`(`scope_id_` asc, `scope_type_` asc) using btree,
|
|
index `act_idx_ejob_sub_scope`(`sub_scope_id_` asc, `scope_type_` asc) using btree,
|
|
index `act_idx_ejob_scope_def`(`scope_definition_id_` asc, `scope_type_` asc) using btree,
|
|
constraint `act_fk_external_job_custom_values` foreign key (`custom_values_id_`) references `act_ge_bytearray` (`id_`) on delete restrict on update restrict,
|
|
constraint `act_fk_external_job_exception` foreign key (`exception_stack_id_`) references `act_ge_bytearray` (`id_`) on delete restrict on update restrict
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_ru_external_job
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_ru_history_job
|
|
-- ----------------------------
|
|
drop table if exists `act_ru_history_job`;
|
|
create table `act_ru_history_job` (
|
|
`id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`rev_` int null default null,
|
|
`lock_exp_time_` timestamp null default null,
|
|
`lock_owner_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`retries_` int null default null,
|
|
`exception_stack_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`exception_msg_` varchar(4000) character set utf8 collate utf8_bin null default null,
|
|
`handler_type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`handler_cfg_` varchar(4000) character set utf8 collate utf8_bin null default null,
|
|
`custom_values_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`adv_handler_cfg_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`create_time_` timestamp null default null,
|
|
`scope_type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`tenant_id_` varchar(255) character set utf8 collate utf8_bin null default '',
|
|
primary key (`id_`) using btree
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_ru_history_job
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_ru_identitylink
|
|
-- ----------------------------
|
|
drop table if exists `act_ru_identitylink`;
|
|
create table `act_ru_identitylink` (
|
|
`id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`rev_` int null default null,
|
|
`group_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`user_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`task_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`proc_inst_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`proc_def_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`scope_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`sub_scope_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`scope_type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`scope_definition_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
primary key (`id_`) using btree,
|
|
index `act_idx_ident_lnk_user`(`user_id_` asc) using btree,
|
|
index `act_idx_ident_lnk_group`(`group_id_` asc) using btree,
|
|
index `act_idx_ident_lnk_scope`(`scope_id_` asc, `scope_type_` asc) using btree,
|
|
index `act_idx_ident_lnk_sub_scope`(`sub_scope_id_` asc, `scope_type_` asc) using btree,
|
|
index `act_idx_ident_lnk_scope_def`(`scope_definition_id_` asc, `scope_type_` asc) using btree,
|
|
index `act_idx_athrz_procedef`(`proc_def_id_` asc) using btree,
|
|
index `act_fk_tskass_task`(`task_id_` asc) using btree,
|
|
index `act_fk_idl_procinst`(`proc_inst_id_` asc) using btree,
|
|
constraint `act_fk_athrz_procedef` foreign key (`proc_def_id_`) references `act_re_procdef` (`id_`) on delete restrict on update restrict,
|
|
constraint `act_fk_idl_procinst` foreign key (`proc_inst_id_`) references `act_ru_execution` (`id_`) on delete restrict on update restrict,
|
|
constraint `act_fk_tskass_task` foreign key (`task_id_`) references `act_ru_task` (`id_`) on delete restrict on update restrict
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_ru_identitylink
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_ru_job
|
|
-- ----------------------------
|
|
drop table if exists `act_ru_job`;
|
|
create table `act_ru_job` (
|
|
`id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`rev_` int null default null,
|
|
`category_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`type_` varchar(255) character set utf8 collate utf8_bin not null,
|
|
`lock_exp_time_` timestamp null default null,
|
|
`lock_owner_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`exclusive_` tinyint(1) null default null,
|
|
`execution_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`process_instance_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`proc_def_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`element_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`element_name_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`scope_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`sub_scope_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`scope_type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`scope_definition_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`correlation_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`retries_` int null default null,
|
|
`exception_stack_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`exception_msg_` varchar(4000) character set utf8 collate utf8_bin null default null,
|
|
`duedate_` timestamp null default null,
|
|
`repeat_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`handler_type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`handler_cfg_` varchar(4000) character set utf8 collate utf8_bin null default null,
|
|
`custom_values_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`create_time_` timestamp null default null,
|
|
`tenant_id_` varchar(255) character set utf8 collate utf8_bin null default '',
|
|
primary key (`id_`) using btree,
|
|
index `act_idx_job_exception_stack_id`(`exception_stack_id_` asc) using btree,
|
|
index `act_idx_job_custom_values_id`(`custom_values_id_` asc) using btree,
|
|
index `act_idx_job_correlation_id`(`correlation_id_` asc) using btree,
|
|
index `act_idx_job_scope`(`scope_id_` asc, `scope_type_` asc) using btree,
|
|
index `act_idx_job_sub_scope`(`sub_scope_id_` asc, `scope_type_` asc) using btree,
|
|
index `act_idx_job_scope_def`(`scope_definition_id_` asc, `scope_type_` asc) using btree,
|
|
index `act_fk_job_execution`(`execution_id_` asc) using btree,
|
|
index `act_fk_job_process_instance`(`process_instance_id_` asc) using btree,
|
|
index `act_fk_job_proc_def`(`proc_def_id_` asc) using btree,
|
|
constraint `act_fk_job_custom_values` foreign key (`custom_values_id_`) references `act_ge_bytearray` (`id_`) on delete restrict on update restrict,
|
|
constraint `act_fk_job_exception` foreign key (`exception_stack_id_`) references `act_ge_bytearray` (`id_`) on delete restrict on update restrict,
|
|
constraint `act_fk_job_execution` foreign key (`execution_id_`) references `act_ru_execution` (`id_`) on delete restrict on update restrict,
|
|
constraint `act_fk_job_process_instance` foreign key (`process_instance_id_`) references `act_ru_execution` (`id_`) on delete restrict on update restrict,
|
|
constraint `act_fk_job_proc_def` foreign key (`proc_def_id_`) references `act_re_procdef` (`id_`) on delete restrict on update restrict
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_ru_job
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_ru_suspended_job
|
|
-- ----------------------------
|
|
drop table if exists `act_ru_suspended_job`;
|
|
create table `act_ru_suspended_job` (
|
|
`id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`rev_` int null default null,
|
|
`category_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`type_` varchar(255) character set utf8 collate utf8_bin not null,
|
|
`exclusive_` tinyint(1) null default null,
|
|
`execution_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`process_instance_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`proc_def_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`element_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`element_name_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`scope_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`sub_scope_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`scope_type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`scope_definition_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`correlation_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`retries_` int null default null,
|
|
`exception_stack_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`exception_msg_` varchar(4000) character set utf8 collate utf8_bin null default null,
|
|
`duedate_` timestamp null default null,
|
|
`repeat_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`handler_type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`handler_cfg_` varchar(4000) character set utf8 collate utf8_bin null default null,
|
|
`custom_values_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`create_time_` timestamp null default null,
|
|
`tenant_id_` varchar(255) character set utf8 collate utf8_bin null default '',
|
|
primary key (`id_`) using btree,
|
|
index `act_idx_suspended_job_exception_stack_id`(`exception_stack_id_` asc) using btree,
|
|
index `act_idx_suspended_job_custom_values_id`(`custom_values_id_` asc) using btree,
|
|
index `act_idx_suspended_job_correlation_id`(`correlation_id_` asc) using btree,
|
|
index `act_idx_sjob_scope`(`scope_id_` asc, `scope_type_` asc) using btree,
|
|
index `act_idx_sjob_sub_scope`(`sub_scope_id_` asc, `scope_type_` asc) using btree,
|
|
index `act_idx_sjob_scope_def`(`scope_definition_id_` asc, `scope_type_` asc) using btree,
|
|
index `act_fk_suspended_job_execution`(`execution_id_` asc) using btree,
|
|
index `act_fk_suspended_job_process_instance`(`process_instance_id_` asc) using btree,
|
|
index `act_fk_suspended_job_proc_def`(`proc_def_id_` asc) using btree,
|
|
constraint `act_fk_suspended_job_custom_values` foreign key (`custom_values_id_`) references `act_ge_bytearray` (`id_`) on delete restrict on update restrict,
|
|
constraint `act_fk_suspended_job_exception` foreign key (`exception_stack_id_`) references `act_ge_bytearray` (`id_`) on delete restrict on update restrict,
|
|
constraint `act_fk_suspended_job_execution` foreign key (`execution_id_`) references `act_ru_execution` (`id_`) on delete restrict on update restrict,
|
|
constraint `act_fk_suspended_job_process_instance` foreign key (`process_instance_id_`) references `act_ru_execution` (`id_`) on delete restrict on update restrict,
|
|
constraint `act_fk_suspended_job_proc_def` foreign key (`proc_def_id_`) references `act_re_procdef` (`id_`) on delete restrict on update restrict
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_ru_suspended_job
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_ru_task
|
|
-- ----------------------------
|
|
drop table if exists `act_ru_task`;
|
|
create table `act_ru_task` (
|
|
`id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`rev_` int null default null,
|
|
`execution_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`proc_inst_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`proc_def_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`task_def_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`scope_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`sub_scope_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`scope_type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`scope_definition_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`propagated_stage_inst_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`name_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`parent_task_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`description_` varchar(4000) character set utf8 collate utf8_bin null default null,
|
|
`task_def_key_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`owner_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`assignee_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`delegation_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`priority_` int null default null,
|
|
`create_time_` timestamp null default null,
|
|
`due_date_` datetime null default null,
|
|
`category_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`suspension_state_` int null default null,
|
|
`tenant_id_` varchar(255) character set utf8 collate utf8_bin null default '',
|
|
`form_key_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`claim_time_` datetime null default null,
|
|
`is_count_enabled_` tinyint null default null,
|
|
`var_count_` int null default null,
|
|
`id_link_count_` int null default null,
|
|
`sub_task_count_` int null default null,
|
|
primary key (`id_`) using btree,
|
|
index `act_idx_task_create`(`create_time_` asc) using btree,
|
|
index `act_idx_task_scope`(`scope_id_` asc, `scope_type_` asc) using btree,
|
|
index `act_idx_task_sub_scope`(`sub_scope_id_` asc, `scope_type_` asc) using btree,
|
|
index `act_idx_task_scope_def`(`scope_definition_id_` asc, `scope_type_` asc) using btree,
|
|
index `act_fk_task_exe`(`execution_id_` asc) using btree,
|
|
index `act_fk_task_procinst`(`proc_inst_id_` asc) using btree,
|
|
index `act_fk_task_procdef`(`proc_def_id_` asc) using btree,
|
|
constraint `act_fk_task_exe` foreign key (`execution_id_`) references `act_ru_execution` (`id_`) on delete restrict on update restrict,
|
|
constraint `act_fk_task_procdef` foreign key (`proc_def_id_`) references `act_re_procdef` (`id_`) on delete restrict on update restrict,
|
|
constraint `act_fk_task_procinst` foreign key (`proc_inst_id_`) references `act_ru_execution` (`id_`) on delete restrict on update restrict
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_ru_task
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_ru_timer_job
|
|
-- ----------------------------
|
|
drop table if exists `act_ru_timer_job`;
|
|
create table `act_ru_timer_job` (
|
|
`id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`rev_` int null default null,
|
|
`category_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`type_` varchar(255) character set utf8 collate utf8_bin not null,
|
|
`lock_exp_time_` timestamp null default null,
|
|
`lock_owner_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`exclusive_` tinyint(1) null default null,
|
|
`execution_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`process_instance_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`proc_def_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`element_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`element_name_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`scope_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`sub_scope_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`scope_type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`scope_definition_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`correlation_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`retries_` int null default null,
|
|
`exception_stack_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`exception_msg_` varchar(4000) character set utf8 collate utf8_bin null default null,
|
|
`duedate_` timestamp null default null,
|
|
`repeat_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`handler_type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`handler_cfg_` varchar(4000) character set utf8 collate utf8_bin null default null,
|
|
`custom_values_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`create_time_` timestamp null default null,
|
|
`tenant_id_` varchar(255) character set utf8 collate utf8_bin null default '',
|
|
primary key (`id_`) using btree,
|
|
index `act_idx_timer_job_exception_stack_id`(`exception_stack_id_` asc) using btree,
|
|
index `act_idx_timer_job_custom_values_id`(`custom_values_id_` asc) using btree,
|
|
index `act_idx_timer_job_correlation_id`(`correlation_id_` asc) using btree,
|
|
index `act_idx_timer_job_duedate`(`duedate_` asc) using btree,
|
|
index `act_idx_tjob_scope`(`scope_id_` asc, `scope_type_` asc) using btree,
|
|
index `act_idx_tjob_sub_scope`(`sub_scope_id_` asc, `scope_type_` asc) using btree,
|
|
index `act_idx_tjob_scope_def`(`scope_definition_id_` asc, `scope_type_` asc) using btree,
|
|
index `act_fk_timer_job_execution`(`execution_id_` asc) using btree,
|
|
index `act_fk_timer_job_process_instance`(`process_instance_id_` asc) using btree,
|
|
index `act_fk_timer_job_proc_def`(`proc_def_id_` asc) using btree,
|
|
constraint `act_fk_timer_job_custom_values` foreign key (`custom_values_id_`) references `act_ge_bytearray` (`id_`) on delete restrict on update restrict,
|
|
constraint `act_fk_timer_job_exception` foreign key (`exception_stack_id_`) references `act_ge_bytearray` (`id_`) on delete restrict on update restrict,
|
|
constraint `act_fk_timer_job_execution` foreign key (`execution_id_`) references `act_ru_execution` (`id_`) on delete restrict on update restrict,
|
|
constraint `act_fk_timer_job_process_instance` foreign key (`process_instance_id_`) references `act_ru_execution` (`id_`) on delete restrict on update restrict,
|
|
constraint `act_fk_timer_job_proc_def` foreign key (`proc_def_id_`) references `act_re_procdef` (`id_`) on delete restrict on update restrict
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_ru_timer_job
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for act_ru_variable
|
|
-- ----------------------------
|
|
drop table if exists `act_ru_variable`;
|
|
create table `act_ru_variable` (
|
|
`id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`rev_` int null default null,
|
|
`type_` varchar(255) character set utf8 collate utf8_bin not null,
|
|
`name_` varchar(255) character set utf8 collate utf8_bin not null,
|
|
`execution_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`proc_inst_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`task_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`scope_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`sub_scope_id_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`scope_type_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`bytearray_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`double_` double null default null,
|
|
`long_` bigint null default null,
|
|
`text_` varchar(4000) character set utf8 collate utf8_bin null default null,
|
|
`text2_` varchar(4000) character set utf8 collate utf8_bin null default null,
|
|
primary key (`id_`) using btree,
|
|
index `act_idx_ru_var_scope_id_type`(`scope_id_` asc, `scope_type_` asc) using btree,
|
|
index `act_idx_ru_var_sub_id_type`(`sub_scope_id_` asc, `scope_type_` asc) using btree,
|
|
index `act_fk_var_bytearray`(`bytearray_id_` asc) using btree,
|
|
index `act_idx_variable_task_id`(`task_id_` asc) using btree,
|
|
index `act_fk_var_exe`(`execution_id_` asc) using btree,
|
|
index `act_fk_var_procinst`(`proc_inst_id_` asc) using btree,
|
|
constraint `act_fk_var_bytearray` foreign key (`bytearray_id_`) references `act_ge_bytearray` (`id_`) on delete restrict on update restrict,
|
|
constraint `act_fk_var_exe` foreign key (`execution_id_`) references `act_ru_execution` (`id_`) on delete restrict on update restrict,
|
|
constraint `act_fk_var_procinst` foreign key (`proc_inst_id_`) references `act_ru_execution` (`id_`) on delete restrict on update restrict
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of act_ru_variable
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for flw_channel_definition
|
|
-- ----------------------------
|
|
drop table if exists `flw_channel_definition`;
|
|
create table `flw_channel_definition` (
|
|
`id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`name_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`version_` int null default null,
|
|
`key_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`category_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`deployment_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`create_time_` datetime(3) null default null,
|
|
`tenant_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`resource_name_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`description_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`type_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`implementation_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
primary key (`id_`) using btree,
|
|
unique index `act_idx_channel_def_uniq`(`key_` asc, `version_` asc, `tenant_id_` asc) using btree
|
|
) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of flw_channel_definition
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for flw_ev_databasechangelog
|
|
-- ----------------------------
|
|
drop table if exists `flw_ev_databasechangelog`;
|
|
create table `flw_ev_databasechangelog` (
|
|
`id` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`author` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`filename` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`dateexecuted` datetime not null,
|
|
`orderexecuted` int not null,
|
|
`exectype` varchar(10) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`md5sum` varchar(35) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`description` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`comments` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`tag` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`liquibase` varchar(20) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`contexts` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`labels` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`deployment_id` varchar(10) character set utf8mb4 collate utf8mb4_general_ci null default null
|
|
) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of flw_ev_databasechangelog
|
|
-- ----------------------------
|
|
insert into `flw_ev_databasechangelog` values ('1', 'flowable', 'org/flowable/eventregistry/db/liquibase/flowable-eventregistry-db-changelog.xml', '2025-08-05 09:16:49', 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.3.5', null, null, '4356607816');
|
|
insert into `flw_ev_databasechangelog` values ('2', 'flowable', 'org/flowable/eventregistry/db/liquibase/flowable-eventregistry-db-changelog.xml', '2025-08-05 09:16:49', 2, 'executed', '8:0ea825feb8e470558f0b5754352b9cda', 'addcolumn tablename=flw_channel_definition; addcolumn tablename=flw_channel_definition', '', null, '4.3.5', null, null, '4356607816');
|
|
insert into `flw_ev_databasechangelog` values ('3', 'flowable', 'org/flowable/eventregistry/db/liquibase/flowable-eventregistry-db-changelog.xml', '2025-08-05 09:16:49', 3, 'executed', '8:3c2bb293350b5cbe6504331980c9dcee', 'customchange', '', null, '4.3.5', null, null, '4356607816');
|
|
|
|
-- ----------------------------
|
|
-- table structure for flw_ev_databasechangeloglock
|
|
-- ----------------------------
|
|
drop table if exists `flw_ev_databasechangeloglock`;
|
|
create table `flw_ev_databasechangeloglock` (
|
|
`id` int not null,
|
|
`locked` bit(1) not null,
|
|
`lockgranted` datetime null default null,
|
|
`lockedby` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
primary key (`id`) using btree
|
|
) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of flw_ev_databasechangeloglock
|
|
-- ----------------------------
|
|
insert into `flw_ev_databasechangeloglock` values (1, b'0', null, null);
|
|
|
|
-- ----------------------------
|
|
-- table structure for flw_event_definition
|
|
-- ----------------------------
|
|
drop table if exists `flw_event_definition`;
|
|
create table `flw_event_definition` (
|
|
`id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`name_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`version_` int null default null,
|
|
`key_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`category_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`deployment_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`tenant_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`resource_name_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`description_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
primary key (`id_`) using btree,
|
|
unique index `act_idx_event_def_uniq`(`key_` asc, `version_` asc, `tenant_id_` asc) using btree
|
|
) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of flw_event_definition
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for flw_event_deployment
|
|
-- ----------------------------
|
|
drop table if exists `flw_event_deployment`;
|
|
create table `flw_event_deployment` (
|
|
`id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`name_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`category_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`deploy_time_` datetime(3) null default null,
|
|
`tenant_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`parent_deployment_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
primary key (`id_`) using btree
|
|
) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of flw_event_deployment
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for flw_event_resource
|
|
-- ----------------------------
|
|
drop table if exists `flw_event_resource`;
|
|
create table `flw_event_resource` (
|
|
`id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci not null,
|
|
`name_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`deployment_id_` varchar(255) character set utf8mb4 collate utf8mb4_general_ci null default null,
|
|
`resource_bytes_` longblob null,
|
|
primary key (`id_`) using btree
|
|
) engine = innodb character set = utf8mb4 collate = utf8mb4_general_ci row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of flw_event_resource
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for flw_ru_batch
|
|
-- ----------------------------
|
|
drop table if exists `flw_ru_batch`;
|
|
create table `flw_ru_batch` (
|
|
`id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`rev_` int null default null,
|
|
`type_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`search_key_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`search_key2_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`create_time_` datetime not null,
|
|
`complete_time_` datetime null default null,
|
|
`status_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`batch_doc_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`tenant_id_` varchar(255) character set utf8 collate utf8_bin null default '',
|
|
primary key (`id_`) using btree
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of flw_ru_batch
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- table structure for flw_ru_batch_part
|
|
-- ----------------------------
|
|
drop table if exists `flw_ru_batch_part`;
|
|
create table `flw_ru_batch_part` (
|
|
`id_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`rev_` int null default null,
|
|
`batch_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`type_` varchar(64) character set utf8 collate utf8_bin not null,
|
|
`scope_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`sub_scope_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`scope_type_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`search_key_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`search_key2_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`create_time_` datetime not null,
|
|
`complete_time_` datetime null default null,
|
|
`status_` varchar(255) character set utf8 collate utf8_bin null default null,
|
|
`result_doc_id_` varchar(64) character set utf8 collate utf8_bin null default null,
|
|
`tenant_id_` varchar(255) character set utf8 collate utf8_bin null default '',
|
|
primary key (`id_`) using btree,
|
|
index `flw_idx_batch_part`(`batch_id_` asc) using btree,
|
|
constraint `flw_fk_batch_part_parent` foreign key (`batch_id_`) references `flw_ru_batch` (`id_`) on delete restrict on update restrict
|
|
) engine = innodb character set = utf8 collate = utf8_bin row_format = dynamic;
|
|
|
|
-- ----------------------------
|
|
-- records of flw_ru_batch_part
|
|
-- ----------------------------
|
|
|
|
set foreign_key_checks = 1;
|
|
|