因为最近后天开发的框架使用的是jeecg,提有自己的一套表体系(主要是用户角色表),所以要在使用activity必须想办法解决表融合的问题,解决方法如下:
网上提到了好多解决办法,什么数据同步啊,重写activity的管理器方法啊,
其实最实用的还是删除activity的act_id_**的表,然后根据自己的用户角色表创建所有与已删除的act_id_**同名的视图,
然后配置文件中指定不去校验身份相关表是否存在:
spring: activiti: db-identity-used: false #身份信息表使用的是视图所以不用新建
视图创建参考(这是根据我们业务中的表创建的数据)
CREATE VIEW `act_id_user` AS SELECT `sys_user`.`ID` AS `ID_`, 1 AS `REV_`, `sys_user`.`username` AS `FIRST_`, `sys_user`.`realname` AS `LAST_`, `sys_user`.`email` AS `EMAIL_`, `sys_user`.`password` AS `PWD_`, null AS `PICTURE_ID_` FROM `sys_user`; CREATE VIEW `act_id_info` AS SELECT `sys_user`.`ID` AS `ID_`, null AS `REV_`, `sys_user`.`ID` AS `USER_ID_`, null AS `TYPE_`, null AS `KEY_`, null AS `VALUE_`, null AS `PASSWORD_`, null AS `PARENT_ID_` FROM `sys_user`; CREATE VIEW `act_id_group` AS SELECT `sys_role`.`ID` AS `ID_`, 1 AS `REV_`, `sys_role`.`role_name` AS `NAME_`, `sys_role`.`role_name` AS `TYPE_` FROM `sys_role`; CREATE VIEW `act_id_membership` AS SELECT `sys_user_role`.`user_id` AS `USER_ID_`, `sys_user_role`.`role_id` AS `GROUP_ID_` FROM `sys_user_role`;