-- 2022-03-08 补充初始化sql文件中栏目表的遗漏字段 ALTER TABLE PORTAL_SYS_COLUMN ADD SHOW_TITLE_ SMALLINT; ALTER TABLE PORTAL_SYS_COLUMN ADD CONTAIN_COL_ VARCHAR2(2000); ALTER TABLE PORTAL_SYS_COLUMN ADD APPID_ VARCHAR2(255); ALTER TABLE PORTAL_SYS_COLUMN ADD SECRET_ VARCHAR2(255); COMMENT ON COLUMN PORTAL_SYS_COLUMN.SHOW_TITLE_ IS '是否 显示栏目名称'; COMMENT ON COLUMN PORTAL_SYS_COLUMN.CONTAIN_COL_ IS '组合栏目包含子栏目别名（逗号分隔）'; COMMENT ON COLUMN PORTAL_SYS_COLUMN.APPID_ IS '公众号appid'; COMMENT ON COLUMN PORTAL_SYS_COLUMN.SECRET_ IS '公众号secret'; -- 2022-03-08 补充初始化sql文件中遗漏的表 CREATE TABLE PORTAL_NEWS_TAG( ID_ VARCHAR2(64) NOT NULL, NAME_ VARCHAR2(64) DEFAULT NULL, ALIAS_ VARCHAR2(64) DEFAULT NULL, STYLE_ VARCHAR2(255) DEFAULT NULL, TENANT_ID_ VARCHAR2(255) DEFAULT NULL, CREATE_TIME_ DATE, CREATE_BY_ VARCHAR2(255) DEFAULT NULL, UPDATE_TIME_ DATE, UPDATE_BY_ VARCHAR2(255) DEFAULT NULL, PRIMARY KEY(ID_) ); COMMENT ON COLUMN PORTAL_NEWS_TAG.ID_ IS '主键'; COMMENT ON COLUMN PORTAL_NEWS_TAG.NAME_ IS '标签名称'; COMMENT ON COLUMN PORTAL_NEWS_TAG.ALIAS_ IS '标签别名'; COMMENT ON COLUMN PORTAL_NEWS_TAG.STYLE_ IS '标签风格'; COMMENT ON COLUMN PORTAL_NEWS_TAG.TENANT_ID_ IS '租户id'; COMMENT ON COLUMN PORTAL_NEWS_TAG.CREATE_TIME_ IS '创建时间'; COMMENT ON COLUMN PORTAL_NEWS_TAG.CREATE_BY_ IS '创建人'; COMMENT ON COLUMN PORTAL_NEWS_TAG.UPDATE_TIME_ IS '更新时间'; COMMENT ON COLUMN PORTAL_NEWS_TAG.UPDATE_BY_ IS '更新人'; -- 2022-03-08 补充portal_sys_menu表中漏掉的前端菜单数据 INSERT INTO PORTAL_SYS_MENU(ID_, PARENT_ID_, NAME_, ALIAS_, ACTIVE_TAB_, MENU_ICON_, OPENED_, SN_, TABS_STYLE_, PATH_, HREF_, TENANT_ID_, ROUTE_EXTEND_) VALUES ('1441339605377536000', '3', '流程中心', 'matter', '', 'icon-process', NULL, 6, '', '-1.3.1441339605377536000.', '', '-1', '{"path":"/matter","component":"Layout","redirect":"noRedirect","name":"matter","alwaysShow":true,"meta":{"title":"流程中心","icon":"matterCenter"}}'); INSERT INTO PORTAL_SYS_MENU(ID_, PARENT_ID_, NAME_, ALIAS_, ACTIVE_TAB_, MENU_ICON_, OPENED_, SN_, TABS_STYLE_, PATH_, HREF_, TENANT_ID_, ROUTE_EXTEND_) VALUES ('1441341228585766912', '3', '个人中心', 'personal', '', 'icon-user1', NULL, 7, '', '-1.3.1441341228585766912.', '', '-1', '{"path":"/personal","component":"Layout","redirect":"noRedirect","name":"personal","alwaysShow":true,"meta":{"title":"个人中心","icon":"user"}}'); INSERT INTO PORTAL_SYS_MENU(ID_, PARENT_ID_, NAME_, ALIAS_, ACTIVE_TAB_, MENU_ICON_, OPENED_, SN_, TABS_STYLE_, PATH_, HREF_, TENANT_ID_, ROUTE_EXTEND_) VALUES ('1441341831483412480', '3', '应用中心', 'appCenter1', '', 'icon-application1', NULL, 8, '', '-1.3.1441341831483412480.', '', '-1', '{"meta":{"title":"应用中心","icon":"matterCenter"},"path":"/appCenter","component":"Layout","redirect":"noRedirect","alwaysShow":true}'); INSERT INTO PORTAL_SYS_MENU(ID_, PARENT_ID_, NAME_, ALIAS_, ACTIVE_TAB_, MENU_ICON_, OPENED_, SN_, TABS_STYLE_, PATH_, HREF_, TENANT_ID_, ROUTE_EXTEND_) VALUES ('1441342209381814272', '1441339605377536000', '新建流程', 'new', '', '', NULL, 1, '', '-1.3.1441339605377536000.1441342209381814272.', '', '-1', '{"meta":{"title":"新建流程","isChildren":true},"component":"@/views/matter/newMatter/index","path":"new","hidden":false}'); INSERT INTO PORTAL_SYS_MENU(ID_, PARENT_ID_, NAME_, ALIAS_, ACTIVE_TAB_, MENU_ICON_, OPENED_, SN_, TABS_STYLE_, PATH_, HREF_, TENANT_ID_, ROUTE_EXTEND_) VALUES ('1441342342999756800', '1441339605377536000', '流程启动', 'startProcess', '', '', NULL, 2, '', '-1.3.1441339605377536000.1441342342999756800.', '', '-1', '{"meta":{"title":"流程启动","isChildren":true},"component":"@/views/matter/StartProcess","path":"startProcess","hidden":true}'); INSERT INTO PORTAL_SYS_MENU(ID_, PARENT_ID_, NAME_, ALIAS_, ACTIVE_TAB_, MENU_ICON_, OPENED_, SN_, TABS_STYLE_, PATH_, HREF_, TENANT_ID_, ROUTE_EXTEND_) VALUES ('1441342471236407296', '1441339605377536000', '我的任务', 'myTask', '', '', NULL, 3, '', '-1.3.1441339605377536000.1441342471236407296.', '', '-1', '{"meta":{"title":"我的任务","isChildren":true},"path":"myTask","component":"@/views/matter/myTask/index"}'); INSERT INTO PORTAL_SYS_MENU(ID_, PARENT_ID_, NAME_, ALIAS_, ACTIVE_TAB_, MENU_ICON_, OPENED_, SN_, TABS_STYLE_, PATH_, HREF_, TENANT_ID_, ROUTE_EXTEND_) VALUES ('1441342583597617152', '1441339605377536000', '我的申请', 'apply', '', '', NULL, 4, '', '-1.3.1441339605377536000.1441342583597617152.', '', '-1', '{"meta":{"title":"我的申请","isChildren":true},"path":"apply","component":"@/views/matter/myRequest/index"}'); INSERT INTO PORTAL_SYS_MENU(ID_, PARENT_ID_, NAME_, ALIAS_, ACTIVE_TAB_, MENU_ICON_, OPENED_, SN_, TABS_STYLE_, PATH_, HREF_, TENANT_ID_, ROUTE_EXTEND_) VALUES ('1441359555827781632', '3', '首页', 'homePage', '', 'icon-aside-home', NULL, 5, '', '-1.3.1441359555827781632.', '', '-1', '{"meta":{},"component":"Layout","redirect":"index","path":"/"}'); INSERT INTO PORTAL_SYS_MENU(ID_, PARENT_ID_, NAME_, ALIAS_, ACTIVE_TAB_, MENU_ICON_, OPENED_, SN_, TABS_STYLE_, PATH_, HREF_, TENANT_ID_, ROUTE_EXTEND_) VALUES ('1441359958220918784', '1441359555827781632', '首页', 'Index', '', '', NULL, 1, '', '-1.3.1441359555827781632.1441359958220918784.', '', '-1', '{"path":"index","name":"Index","component":"@/views/home/index","meta":{"title":"首页","icon":"home","affix":true,"isChildren":true}}'); INSERT INTO PORTAL_SYS_MENU(ID_, PARENT_ID_, NAME_, ALIAS_, ACTIVE_TAB_, MENU_ICON_, OPENED_, SN_, TABS_STYLE_, PATH_, HREF_, TENANT_ID_, ROUTE_EXTEND_) VALUES ('1441938397294415872', '1441341228585766912', '个人设置', 'setting', '', '', NULL, 1, '', '-1.3.1441341228585766912.1441938397294415872.', '', '-1', '{"path":"setting","name":"setting","component":"@/views/personal/setting","meta":{"title":"个人设置","isChildren":true}}'); INSERT INTO PORTAL_SYS_MENU(ID_, PARENT_ID_, NAME_, ALIAS_, ACTIVE_TAB_, MENU_ICON_, OPENED_, SN_, TABS_STYLE_, PATH_, HREF_, TENANT_ID_, ROUTE_EXTEND_) VALUES ('1441938698676129792', '1441341228585766912', '邮件中心', 'mail', '', '', NULL, 2, '', '-1.3.1441341228585766912.1441938698676129792.', '', '-1', '{"path":"mail","name":"mail","component":"@/views/personal/mail","meta":{"title":"邮件中心","isChildren":true}}'); INSERT INTO PORTAL_SYS_MENU(ID_, PARENT_ID_, NAME_, ALIAS_, ACTIVE_TAB_, MENU_ICON_, OPENED_, SN_, TABS_STYLE_, PATH_, HREF_, TENANT_ID_, ROUTE_EXTEND_) VALUES ('1441941148611039232', '1441341831483412480', '应用中心', 'appCenter2', '', '', NULL, 1, '', '-1.3.1441341831483412480.1441941148611039232.', '', '-1', '{"path":"index","component":"@/views/appCenter/index","name":"AppCenter","meta":{"title":"首页","isChildren":true}}'); INSERT INTO PORTAL_SYS_MENU(ID_, PARENT_ID_, NAME_, ALIAS_, ACTIVE_TAB_, MENU_ICON_, OPENED_, SN_, TABS_STYLE_, PATH_, HREF_, TENANT_ID_, ROUTE_EXTEND_) VALUES ('1441946969948475392', '1441359555827781632', '个人中心', 'personalCenter', '', '', NULL, 2, '', '-1.3.1441359555827781632.1441946969948475392.', '', '-1', '{"path":"personalCenter","name":"personalCenter","component":"@/views/personalCenter/index","meta":{"title":"个人中心","icon":"laptop","isChildren":true},"hidden":true}'); INSERT INTO PORTAL_SYS_MENU(ID_, PARENT_ID_, NAME_, ALIAS_, ACTIVE_TAB_, MENU_ICON_, OPENED_, SN_, TABS_STYLE_, PATH_, HREF_, TENANT_ID_, ROUTE_EXTEND_) VALUES ('1441966593469501440', '1441339605377536000', '审批表单', 'approvalForm', '', '', NULL, 5, '', '-1.3.1441339605377536000.1441966593469501440.', '', '-1', '{"path":"approvalForm","name":"approvalForm","component":"@/views/matter/ApprovalForm","meta":{"title":"审批表单"},"hidden":true}'); INSERT INTO PORTAL_SYS_MENU(ID_, PARENT_ID_, NAME_, ALIAS_, ACTIVE_TAB_, MENU_ICON_, OPENED_, SN_, TABS_STYLE_, PATH_, HREF_, TENANT_ID_, ROUTE_EXTEND_) VALUES ('1443153816786980864', '1441339605377536000', '传阅事项', 'circulateMatter', '', '', NULL, 5, '', '-1.3.1441339605377536000.1443153816786980864.', '', '-1', '{"path":"circulateMatter","component":"@/views/matter/circulateMatter","redirect":"","alwaysShow":false,"caseSensitive":false,"meta":{"title":"传阅事项","isChildren":true}}'); INSERT INTO PORTAL_SYS_MENU(ID_, PARENT_ID_, NAME_, ALIAS_, ACTIVE_TAB_, MENU_ICON_, OPENED_, SN_, TABS_STYLE_, PATH_, HREF_, TENANT_ID_, ROUTE_EXTEND_) VALUES ('1494487013470261248', '1441341228585766912', '消息中心', 'xxzx', '', '', NULL, 1, '', '-1.3.1441341228585766912.1494487013470261248.', '', '-1', '{"path":"message","component":"@/views/personal/message","redirect":"","alwaysShow":false,"caseSensitive":false,"meta":{"title":"消息中心","isChildren":true}}'); INSERT INTO PORTAL_SYS_MENU(ID_, PARENT_ID_, NAME_, ALIAS_, ACTIVE_TAB_, MENU_ICON_, OPENED_, SN_, TABS_STYLE_, PATH_, HREF_, TENANT_ID_, ROUTE_EXTEND_) VALUES ('1432175565783007232', '4073629', '权限调整', 'permissionAdjustmentManage', '', '', NULL, 4, '', '-1.1.3641025.4073629.1432175565783007232.', '', '-1', NULL); delete from portal_sys_menu where name_ = '外部接口调用日志' or name_ = '外部系统消息日志' or name_ = '外部接口管理'; INSERT INTO PORTAL_SYS_MENU(ID_, PARENT_ID_, NAME_, ALIAS_, ACTIVE_TAB_, MENU_ICON_, OPENED_, SN_, TABS_STYLE_, PATH_, HREF_, TENANT_ID_, ROUTE_EXTEND_) VALUES ('1451456425861406720', '1437975457390284800', '外部接口管理', 'apiManager', '', '', NULL, 4, '', '- 1.1.1437982148582154240.1437975457390284800.1451456425861406720.', '', '-1', '{ "path" : "","component" : "","redirect" : "","alwaysShow" : false,"caseSensitive" : false, "meta" :{ "title" : "" }}'); INSERT INTO PORTAL_SYS_MENU(ID_, PARENT_ID_, NAME_, ALIAS_, ACTIVE_TAB_, MENU_ICON_, OPENED_, SN_, TABS_STYLE_, PATH_, HREF_, TENANT_ID_, ROUTE_EXTEND_) VALUES ('1451818951124017152', '5403008', '外部接口调用日志', 'externalSystemLog', '', '', NULL, 6, '', '- 1.1.3421053.5403008.1451818951124017152.', '', '-1', '{ "path" : "", "component" : "","redirect" : "","alwaysShow" : false,"caseSensitive" : false,"meta" :{ "title" : "" }}'); INSERT INTO PORTAL_SYS_MENU(ID_, PARENT_ID_, NAME_, ALIAS_, ACTIVE_TAB_, MENU_ICON_, OPENED_, SN_, TABS_STYLE_, PATH_, HREF_, TENANT_ID_, ROUTE_EXTEND_) VALUES ('1467391005218881536', '5403008', '外部系统消息日志', 'externalSystemQueueLog', '', '', NULL, 7, '', '-1.1.3421053.5403008.1467391005218881536.', '', '-1', '{"path":"","component":"Layout","redirect":"","alwaysShow":false,"caseSensitive":false,"meta":{"title":""}}'); -- bug #16597 CREATE TABLE bpm_flow_default_button ( ID_ varchar(64) NOT NULL, NAME_ varchar(64) NOT NULL, ALIAS_ varchar(64) NOT NULL, BEFORESCRIPT_ clob, AFTERSCRIPT_ clob, GROOVYSCRIPT_ clob, COMPLETEEVENTGROOVYSCRIPT_ clob, REJECTMODE_ varchar(64), REJECTNODE_ varchar(64), ISLOCK_ number, SUPPORTSCRIPT_ number, MSGCONFIG_ varchar(255), TYPE_ varchar(64), DISABLED_ number, constraint bpm_flow_default_button_pk PRIMARY KEY (ID_) ); comment on column bpm_flow_default_button.ID_ is '主键'; comment on column bpm_flow_default_button.NAME_ is '按钮名称'; comment on column bpm_flow_default_button.ALIAS_ is '按钮别名'; comment on column bpm_flow_default_button.BEFORESCRIPT_ is '前置脚本'; comment on column bpm_flow_default_button.AFTERSCRIPT_ is '后置脚本'; comment on column bpm_flow_default_button.GROOVYSCRIPT_ is '后台java脚本'; comment on column bpm_flow_default_button.COMPLETEEVENTGROOVYSCRIPT_ is '后台完成任务后执行的java脚本'; comment on column bpm_flow_default_button.REJECTMODE_ is '驳回模式 reject 驳回指定节点 rejectPre 驳回上一步 backToStart 驳回发起人'; comment on column bpm_flow_default_button.REJECTNODE_ is '指定驳回的节点'; comment on column bpm_flow_default_button.SUPPORTSCRIPT_ is '是否支持脚本'; comment on column bpm_flow_default_button.MSGCONFIG_ is '按钮消息配置'; comment on column bpm_flow_default_button.TYPE_ is '按钮节点类型'; comment on column bpm_flow_default_button.DISABLED_ is '启用或者禁用'; comment on table bpm_flow_default_button is '流程默认按钮表'; -- 2022-03-09 补充遗漏的流程按钮相关数据 INSERT INTO PORTAL_SYS_MENU(ID_, PARENT_ID_, NAME_, ALIAS_, ACTIVE_TAB_, MENU_ICON_, OPENED_, SN_, TABS_STYLE_, PATH_, HREF_, TENANT_ID_, ROUTE_EXTEND_) VALUES ('1430769509001445376', '3641025', '流程按钮', 'flowButtonManager', 'startTaskButtons', '', NULL, 6, '', '-1.1.3641025.1430769509001445376.', '', '-1', NULL); INSERT INTO PORTAL_SYS_MENU(ID_, PARENT_ID_, NAME_, ALIAS_, ACTIVE_TAB_, MENU_ICON_, OPENED_, SN_, TABS_STYLE_, PATH_, HREF_, TENANT_ID_, ROUTE_EXTEND_) VALUES ('1430788426285563904', '1430769509001445376', '用户任务节点', 'userTaskButtons', '', '', NULL, 2, '', '-1.1.3641025.1430769509001445376.1430788426285563904.', '', '-1', NULL); INSERT INTO PORTAL_SYS_MENU(ID_, PARENT_ID_, NAME_, ALIAS_, ACTIVE_TAB_, MENU_ICON_, OPENED_, SN_, TABS_STYLE_, PATH_, HREF_, TENANT_ID_, ROUTE_EXTEND_) VALUES ('1430788606049239040', '1430769509001445376', '会签任务节点', 'signTaskButtons', '', '', NULL, 3, '', '-1.1.3641025.1430769509001445376.1430788606049239040.', '', '-1', NULL); INSERT INTO PORTAL_SYS_MENU(ID_, PARENT_ID_, NAME_, ALIAS_, ACTIVE_TAB_, MENU_ICON_, OPENED_, SN_, TABS_STYLE_, PATH_, HREF_, TENANT_ID_, ROUTE_EXTEND_) VALUES ('1430789609448390656', '1430769509001445376', '开始任务节点', 'startTaskButtons', '', '', NULL, 1, '', '-1.1.3641025.1430769509001445376.1430789609448390656.', '', '-1', NULL); INSERT INTO BPM_FLOW_DEFAULT_BUTTON(ID_, NAME_, ALIAS_, BEFORESCRIPT_, AFTERSCRIPT_, GROOVYSCRIPT_, COMPLETEEVENTGROOVYSCRIPT_, REJECTMODE_, REJECTNODE_, ISLOCK_, SUPPORTSCRIPT_, MSGCONFIG_, TYPE_, DISABLED_) VALUES ('1', '启动', 'startFlow', '', '', '', '', 'backToStart,rejectPre,reject', '', 0, 1, '', 'start', 0); INSERT INTO BPM_FLOW_DEFAULT_BUTTON(ID_, NAME_, ALIAS_, BEFORESCRIPT_, AFTERSCRIPT_, GROOVYSCRIPT_, COMPLETEEVENTGROOVYSCRIPT_, REJECTMODE_, REJECTNODE_, ISLOCK_, SUPPORTSCRIPT_, MSGCONFIG_, TYPE_, DISABLED_) VALUES ('10', '签收', 'lockUnlock', '', '', '', '', 'backToStart,rejectPre,reject', '', 0, 0, '', 'userTask', 0); INSERT INTO BPM_FLOW_DEFAULT_BUTTON(ID_, NAME_, ALIAS_, BEFORESCRIPT_, AFTERSCRIPT_, GROOVYSCRIPT_, COMPLETEEVENTGROOVYSCRIPT_, REJECTMODE_, REJECTNODE_, ISLOCK_, SUPPORTSCRIPT_, MSGCONFIG_, TYPE_, DISABLED_) VALUES ('11', '保存', 'saveDraft', '', '', '', '', 'backToStart,rejectPre,reject', '', 0, 1, '', 'userTask', 0); INSERT INTO BPM_FLOW_DEFAULT_BUTTON(ID_, NAME_, ALIAS_, BEFORESCRIPT_, AFTERSCRIPT_, GROOVYSCRIPT_, COMPLETEEVENTGROOVYSCRIPT_, REJECTMODE_, REJECTNODE_, ISLOCK_, SUPPORTSCRIPT_, MSGCONFIG_, TYPE_, DISABLED_) VALUES ('12', '挂起', 'hangUp', '', '', '', '', 'backToStart,rejectPre,reject', '', 0, 0, '', 'userTask', 0); INSERT INTO BPM_FLOW_DEFAULT_BUTTON(ID_, NAME_, ALIAS_, BEFORESCRIPT_, AFTERSCRIPT_, GROOVYSCRIPT_, COMPLETEEVENTGROOVYSCRIPT_, REJECTMODE_, REJECTNODE_, ISLOCK_, SUPPORTSCRIPT_, MSGCONFIG_, TYPE_, DISABLED_) VALUES ('13', '取消挂起', 'cancelHangUp', '', '', '', '', 'backToStart,rejectPre,reject', '', 0, 0, '', 'userTask', 0); INSERT INTO BPM_FLOW_DEFAULT_BUTTON(ID_, NAME_, ALIAS_, BEFORESCRIPT_, AFTERSCRIPT_, GROOVYSCRIPT_, COMPLETEEVENTGROOVYSCRIPT_, REJECTMODE_, REJECTNODE_, ISLOCK_, SUPPORTSCRIPT_, MSGCONFIG_, TYPE_, DISABLED_) VALUES ('14', '反对', 'oppose', '', '', '', '', 'backToStart,rejectPre,reject', '', 0, 1, '', 'userTask', 0); INSERT INTO BPM_FLOW_DEFAULT_BUTTON(ID_, NAME_, ALIAS_, BEFORESCRIPT_, AFTERSCRIPT_, GROOVYSCRIPT_, COMPLETEEVENTGROOVYSCRIPT_, REJECTMODE_, REJECTNODE_, ISLOCK_, SUPPORTSCRIPT_, MSGCONFIG_, TYPE_, DISABLED_) VALUES ('15', '流转', 'startTrans', '', '', '', '', 'backToStart,rejectPre,reject', '', 0, 0, '', 'userTask', 0); INSERT INTO BPM_FLOW_DEFAULT_BUTTON(ID_, NAME_, ALIAS_, BEFORESCRIPT_, AFTERSCRIPT_, GROOVYSCRIPT_, COMPLETEEVENTGROOVYSCRIPT_, REJECTMODE_, REJECTNODE_, ISLOCK_, SUPPORTSCRIPT_, MSGCONFIG_, TYPE_, DISABLED_) VALUES ('16', '加签', 'addSign', '', '', '', '', 'backToStart,rejectPre,reject', '', 0, 0, '', 'userTask', 0); INSERT INTO BPM_FLOW_DEFAULT_BUTTON(ID_, NAME_, ALIAS_, BEFORESCRIPT_, AFTERSCRIPT_, GROOVYSCRIPT_, COMPLETEEVENTGROOVYSCRIPT_, REJECTMODE_, REJECTNODE_, ISLOCK_, SUPPORTSCRIPT_, MSGCONFIG_, TYPE_, DISABLED_) VALUES ('17', '终止', 'endProcess', '', '', '', '', 'backToStart,rejectPre,reject', '', 0, 1, '', 'userTask', 0); INSERT INTO BPM_FLOW_DEFAULT_BUTTON(ID_, NAME_, ALIAS_, BEFORESCRIPT_, AFTERSCRIPT_, GROOVYSCRIPT_, COMPLETEEVENTGROOVYSCRIPT_, REJECTMODE_, REJECTNODE_, ISLOCK_, SUPPORTSCRIPT_, MSGCONFIG_, TYPE_, DISABLED_) VALUES ('18', '传阅', 'instanceTrans', '', '', '', '', 'backToStart,rejectPre,reject', '', 0, 0, '', 'userTask', 1); INSERT INTO BPM_FLOW_DEFAULT_BUTTON(ID_, NAME_, ALIAS_, BEFORESCRIPT_, AFTERSCRIPT_, GROOVYSCRIPT_, COMPLETEEVENTGROOVYSCRIPT_, REJECTMODE_, REJECTNODE_, ISLOCK_, SUPPORTSCRIPT_, MSGCONFIG_, TYPE_, DISABLED_) VALUES ('19', '驳回发起人', 'backToStart', '', '', '', '', 'backToStart,rejectPre,reject', '', 0, 1, '', 'userTask', 1); INSERT INTO BPM_FLOW_DEFAULT_BUTTON(ID_, NAME_, ALIAS_, BEFORESCRIPT_, AFTERSCRIPT_, GROOVYSCRIPT_, COMPLETEEVENTGROOVYSCRIPT_, REJECTMODE_, REJECTNODE_, ISLOCK_, SUPPORTSCRIPT_, MSGCONFIG_, TYPE_, DISABLED_) VALUES ('2', '保存', 'saveDraft', NULL, NULL, NULL, NULL, 'backToStart,rejectPre,reject', NULL, 0, 1, NULL, 'start', 0); INSERT INTO BPM_FLOW_DEFAULT_BUTTON(ID_, NAME_, ALIAS_, BEFORESCRIPT_, AFTERSCRIPT_, GROOVYSCRIPT_, COMPLETEEVENTGROOVYSCRIPT_, REJECTMODE_, REJECTNODE_, ISLOCK_, SUPPORTSCRIPT_, MSGCONFIG_, TYPE_, DISABLED_) VALUES ('20', '同意', 'agree', NULL, NULL, NULL, NULL, 'backToStart,rejectPre,reject', NULL, 0, 1, NULL, 'signTask', 0); INSERT INTO BPM_FLOW_DEFAULT_BUTTON(ID_, NAME_, ALIAS_, BEFORESCRIPT_, AFTERSCRIPT_, GROOVYSCRIPT_, COMPLETEEVENTGROOVYSCRIPT_, REJECTMODE_, REJECTNODE_, ISLOCK_, SUPPORTSCRIPT_, MSGCONFIG_, TYPE_, DISABLED_) VALUES ('21', '沟通反馈', 'commu', '', '', '', '', 'backToStart,rejectPre,reject', '', 0, 1, '', 'signTask', 1); INSERT INTO BPM_FLOW_DEFAULT_BUTTON(ID_, NAME_, ALIAS_, BEFORESCRIPT_, AFTERSCRIPT_, GROOVYSCRIPT_, COMPLETEEVENTGROOVYSCRIPT_, REJECTMODE_, REJECTNODE_, ISLOCK_, SUPPORTSCRIPT_, MSGCONFIG_, TYPE_, DISABLED_) VALUES ('22', '驳回', 'reject', NULL, NULL, NULL, NULL, 'backToStart,rejectPre,reject', NULL, 0, 1, NULL, 'signTask', 0); INSERT INTO BPM_FLOW_DEFAULT_BUTTON(ID_, NAME_, ALIAS_, BEFORESCRIPT_, AFTERSCRIPT_, GROOVYSCRIPT_, COMPLETEEVENTGROOVYSCRIPT_, REJECTMODE_, REJECTNODE_, ISLOCK_, SUPPORTSCRIPT_, MSGCONFIG_, TYPE_, DISABLED_) VALUES ('23', '征询', 'inqu', NULL, NULL, NULL, NULL, 'backToStart,rejectPre,reject', NULL, 0, 0, NULL, 'signTask', 0); INSERT INTO BPM_FLOW_DEFAULT_BUTTON(ID_, NAME_, ALIAS_, BEFORESCRIPT_, AFTERSCRIPT_, GROOVYSCRIPT_, COMPLETEEVENTGROOVYSCRIPT_, REJECTMODE_, REJECTNODE_, ISLOCK_, SUPPORTSCRIPT_, MSGCONFIG_, TYPE_, DISABLED_) VALUES ('24', '转办', 'delegate', NULL, NULL, NULL, NULL, 'backToStart,rejectPre,reject', NULL, 0, 0, NULL, 'signTask', 0); INSERT INTO BPM_FLOW_DEFAULT_BUTTON(ID_, NAME_, ALIAS_, BEFORESCRIPT_, AFTERSCRIPT_, GROOVYSCRIPT_, COMPLETEEVENTGROOVYSCRIPT_, REJECTMODE_, REJECTNODE_, ISLOCK_, SUPPORTSCRIPT_, MSGCONFIG_, TYPE_, DISABLED_) VALUES ('25', '保存', 'saveDraft', NULL, NULL, NULL, NULL, 'backToStart,rejectPre,reject', NULL, 0, 1, NULL, 'signTask', 0); INSERT INTO BPM_FLOW_DEFAULT_BUTTON(ID_, NAME_, ALIAS_, BEFORESCRIPT_, AFTERSCRIPT_, GROOVYSCRIPT_, COMPLETEEVENTGROOVYSCRIPT_, REJECTMODE_, REJECTNODE_, ISLOCK_, SUPPORTSCRIPT_, MSGCONFIG_, TYPE_, DISABLED_) VALUES ('26', '反对', 'oppose', NULL, NULL, NULL, NULL, 'backToStart,rejectPre,reject', NULL, 0, 1, NULL, 'signTask', 0); INSERT INTO BPM_FLOW_DEFAULT_BUTTON(ID_, NAME_, ALIAS_, BEFORESCRIPT_, AFTERSCRIPT_, GROOVYSCRIPT_, COMPLETEEVENTGROOVYSCRIPT_, REJECTMODE_, REJECTNODE_, ISLOCK_, SUPPORTSCRIPT_, MSGCONFIG_, TYPE_, DISABLED_) VALUES ('27', '驳回发起人', 'backToStart', '', '', '', '', 'backToStart,rejectPre,reject', '', 0, 1, '', 'signTask', 1); INSERT INTO BPM_FLOW_DEFAULT_BUTTON(ID_, NAME_, ALIAS_, BEFORESCRIPT_, AFTERSCRIPT_, GROOVYSCRIPT_, COMPLETEEVENTGROOVYSCRIPT_, REJECTMODE_, REJECTNODE_, ISLOCK_, SUPPORTSCRIPT_, MSGCONFIG_, TYPE_, DISABLED_) VALUES ('28', '传阅', 'instanceTrans', '', '', '', '', 'backToStart,rejectPre,reject', '', 0, 0, '', 'signTask', 1); INSERT INTO BPM_FLOW_DEFAULT_BUTTON(ID_, NAME_, ALIAS_, BEFORESCRIPT_, AFTERSCRIPT_, GROOVYSCRIPT_, COMPLETEEVENTGROOVYSCRIPT_, REJECTMODE_, REJECTNODE_, ISLOCK_, SUPPORTSCRIPT_, MSGCONFIG_, TYPE_, DISABLED_) VALUES ('29', '加签', 'addSign', NULL, NULL, NULL, NULL, 'backToStart,rejectPre,reject', NULL, 0, 0, NULL, 'signTask', 0); INSERT INTO BPM_FLOW_DEFAULT_BUTTON(ID_, NAME_, ALIAS_, BEFORESCRIPT_, AFTERSCRIPT_, GROOVYSCRIPT_, COMPLETEEVENTGROOVYSCRIPT_, REJECTMODE_, REJECTNODE_, ISLOCK_, SUPPORTSCRIPT_, MSGCONFIG_, TYPE_, DISABLED_) VALUES ('3', '同意', 'agree', '', '', '', '', 'backToStart,rejectPre,reject', '', 0, 1, '', 'userTask', 0); INSERT INTO BPM_FLOW_DEFAULT_BUTTON(ID_, NAME_, ALIAS_, BEFORESCRIPT_, AFTERSCRIPT_, GROOVYSCRIPT_, COMPLETEEVENTGROOVYSCRIPT_, REJECTMODE_, REJECTNODE_, ISLOCK_, SUPPORTSCRIPT_, MSGCONFIG_, TYPE_, DISABLED_) VALUES ('4', '同意（流转）', 'agreeTrans', NULL, NULL, NULL, NULL, 'backToStart,rejectPre,reject', NULL, 0, 1, NULL, 'userTask', 0); INSERT INTO BPM_FLOW_DEFAULT_BUTTON(ID_, NAME_, ALIAS_, BEFORESCRIPT_, AFTERSCRIPT_, GROOVYSCRIPT_, COMPLETEEVENTGROOVYSCRIPT_, REJECTMODE_, REJECTNODE_, ISLOCK_, SUPPORTSCRIPT_, MSGCONFIG_, TYPE_, DISABLED_) VALUES ('5', '反对（流转）', 'opposeTrans', NULL, NULL, NULL, NULL, 'backToStart,rejectPre,reject', NULL, 0, 1, NULL, 'userTask', 0); INSERT INTO BPM_FLOW_DEFAULT_BUTTON(ID_, NAME_, ALIAS_, BEFORESCRIPT_, AFTERSCRIPT_, GROOVYSCRIPT_, COMPLETEEVENTGROOVYSCRIPT_, REJECTMODE_, REJECTNODE_, ISLOCK_, SUPPORTSCRIPT_, MSGCONFIG_, TYPE_, DISABLED_) VALUES ('6', '沟通反馈', 'commu', '', '', '', '', 'backToStart,rejectPre,reject', '', 0, 1, '', 'userTask', 1); INSERT INTO BPM_FLOW_DEFAULT_BUTTON(ID_, NAME_, ALIAS_, BEFORESCRIPT_, AFTERSCRIPT_, GROOVYSCRIPT_, COMPLETEEVENTGROOVYSCRIPT_, REJECTMODE_, REJECTNODE_, ISLOCK_, SUPPORTSCRIPT_, MSGCONFIG_, TYPE_, DISABLED_) VALUES ('7', '驳回', 'reject', NULL, NULL, NULL, NULL, 'backToStart,rejectPre,reject', NULL, 0, 1, NULL, 'userTask', 0); INSERT INTO BPM_FLOW_DEFAULT_BUTTON(ID_, NAME_, ALIAS_, BEFORESCRIPT_, AFTERSCRIPT_, GROOVYSCRIPT_, COMPLETEEVENTGROOVYSCRIPT_, REJECTMODE_, REJECTNODE_, ISLOCK_, SUPPORTSCRIPT_, MSGCONFIG_, TYPE_, DISABLED_) VALUES ('8', '征询', 'inqu', NULL, NULL, NULL, NULL, 'backToStart,rejectPre,reject', NULL, 0, 0, NULL, 'userTask', 0); INSERT INTO BPM_FLOW_DEFAULT_BUTTON(ID_, NAME_, ALIAS_, BEFORESCRIPT_, AFTERSCRIPT_, GROOVYSCRIPT_, COMPLETEEVENTGROOVYSCRIPT_, REJECTMODE_, REJECTNODE_, ISLOCK_, SUPPORTSCRIPT_, MSGCONFIG_, TYPE_, DISABLED_) VALUES ('9', '转办', 'delegate', NULL, NULL, NULL, NULL, 'backToStart,rejectPre,reject', NULL, 0, 0, NULL, 'userTask', 0); -- 补充流程发起人账号字段 ALTER TABLE BPM_PRO_INST ADD CREATE_ACCOUNT_ VARCHAR2(64); COMMENT ON COLUMN BPM_PRO_INST.CREATE_ACCOUNT_ IS '流程发起人账号'; -- 补充新闻表遗漏字段 ALTER TABLE PORTAL_NEWS_NOTICE_ ADD TAG_ VARCHAR2(64); ALTER TABLE PORTAL_NEWS_NOTICE_ ADD ICON_COLOR_ VARCHAR2(10); ALTER TABLE PORTAL_NEWS_NOTICE_ ADD DEPARTMENT_ VARCHAR2(255); ALTER TABLE PORTAL_NEWS_NOTICE_ ADD PUBLISH_TIME_ DATE; COMMENT ON COLUMN PORTAL_NEWS_NOTICE_.TAG_ IS '标签'; COMMENT ON COLUMN PORTAL_NEWS_NOTICE_.ICON_COLOR_ IS '图表颜色'; COMMENT ON COLUMN PORTAL_NEWS_NOTICE_.DEPARTMENT_ IS '拟稿部门'; COMMENT ON COLUMN PORTAL_NEWS_NOTICE_.PUBLISH_TIME_ IS '发布时间'; -- 2022-03-02 yijj 新增流程实例回收站菜单 INSERT INTO portal_sys_menu(ID_, PARENT_ID_, NAME_, ALIAS_, ACTIVE_TAB_, MENU_ICON_, OPENED_, SN_, TABS_STYLE_, PATH_, HREF_, TENANT_ID_, ROUTE_EXTEND_) VALUES ('1497089603655909376', '4171077', '实例回收站', 'instanceRecovery', '', '', NULL, 4, '', '-1.1.3641025.4171077.1497089603655909376.', '', '-1', '{"path":"","component":"Layout","redirect":"","alwaysShow":false,"caseSensitive":false,"meta":{"title":""}}'); -- 2022-03-15 jjx 添加首页布局标题名 UPDATE portal_sys_menu SET ROUTE_EXTEND_ = '{"meta":{"title":"首页"},"component":"Layout","redirect":"index","path":"/"}' WHERE ID_ = '1441359555827781632'; CREATE TABLE "PORTAL_AGENDA_DAY" ( "ID_" VARCHAR2(64) NOT NULL, "CREATOR_" VARCHAR2(64), "SUBJECT_" VARCHAR2(255), "START_TIME_" DATE NOT NULL, "END_TIME_" DATE, "CONTENT_" VARCHAR2(4000), "SHARE_ID_" VARCHAR2(2000), "SHARE_NAME_" VARCHAR2(2000), "CREATE_BY_" VARCHAR2(64), "UPDATE_BY_" VARCHAR2(64), "CREATE_TIME_" DATE, "UPDATE_TIME_" DATE, "CREATE_ORG_ID_" VARCHAR2(64), "TENANT_ID_" VARCHAR2(64), PRIMARY KEY ("ID_") ) ; COMMENT ON COLUMN "PORTAL_AGENDA_DAY"."ID_" IS '主键'; COMMENT ON COLUMN "PORTAL_AGENDA_DAY"."CREATOR_" IS '创建人'; COMMENT ON COLUMN "PORTAL_AGENDA_DAY"."SUBJECT_" IS '日程标题'; COMMENT ON COLUMN "PORTAL_AGENDA_DAY"."START_TIME_" IS '开始时间'; COMMENT ON COLUMN "PORTAL_AGENDA_DAY"."END_TIME_" IS '结束时间'; COMMENT ON COLUMN "PORTAL_AGENDA_DAY"."CONTENT_" IS '日程内容'; COMMENT ON COLUMN "PORTAL_AGENDA_DAY"."SHARE_ID_" IS '日程共享人id'; COMMENT ON COLUMN "PORTAL_AGENDA_DAY"."SHARE_NAME_" IS '日程共享人姓名'; COMMENT ON COLUMN "PORTAL_AGENDA_DAY"."CREATE_BY_" IS '创建人id'; COMMENT ON COLUMN "PORTAL_AGENDA_DAY"."UPDATE_BY_" IS '更新人id'; COMMENT ON COLUMN "PORTAL_AGENDA_DAY"."CREATE_TIME_" IS '创建时间'; COMMENT ON COLUMN "PORTAL_AGENDA_DAY"."UPDATE_TIME_" IS '更新时间'; COMMENT ON COLUMN "PORTAL_AGENDA_DAY"."CREATE_ORG_ID_" IS '创建人所属部门id'; COMMENT ON COLUMN "PORTAL_AGENDA_DAY"."TENANT_ID_" IS '租户id'; COMMENT ON TABLE "PORTAL_AGENDA_DAY" IS '日程管理'; CREATE TABLE "PORTAL_WEIXIN_MATERIAL" ( "ID_" VARCHAR2(64) NOT NULL, "APPID" VARCHAR2(255), "TITLE" VARCHAR2(600), "AUTHOR" VARCHAR2(64), "DIGEST" VARCHAR2(255), "CONTENT" BLOB, "CONTENT_SOURCE_URL" VARCHAR2(600), "THUMB_MEDIA_ID" VARCHAR2(255), "SHOW_COVER_PIC" INT, "URL" VARCHAR2(600), "NEED_OPEN_COMMENT" INT, "THUMB_URL" VARCHAR2(600), "ONLY_FANS_CAN_COMMENT" INT, "CREATE_TIME" DATE, "UPDATE_TIME" DATE, "PULL_TIME" DATE, PRIMARY KEY ("ID_") ) ; CREATE INDEX IDX_APPID ON PORTAL_WEIXIN_MATERIAL (APPID); COMMENT ON COLUMN "PORTAL_WEIXIN_MATERIAL"."ID_" IS '主键'; COMMENT ON COLUMN "PORTAL_WEIXIN_MATERIAL"."APPID" IS '用户凭证'; COMMENT ON COLUMN "PORTAL_WEIXIN_MATERIAL"."TITLE" IS '标题'; COMMENT ON COLUMN "PORTAL_WEIXIN_MATERIAL"."AUTHOR" IS '作者'; COMMENT ON COLUMN "PORTAL_WEIXIN_MATERIAL"."DIGEST" IS '摘要'; COMMENT ON COLUMN "PORTAL_WEIXIN_MATERIAL"."CONTENT" IS '内容'; COMMENT ON COLUMN "PORTAL_WEIXIN_MATERIAL"."CONTENT_SOURCE_URL" IS '图文消息的原文地址，即点击“阅读原文”后的URL'; COMMENT ON COLUMN "PORTAL_WEIXIN_MATERIAL"."THUMB_MEDIA_ID" IS '图文消息的封面图片素材id（必须是永久mediaID）'; COMMENT ON COLUMN "PORTAL_WEIXIN_MATERIAL"."SHOW_COVER_PIC" IS '是否显示封面，0为false，即不显示，1为true，即显示'; COMMENT ON COLUMN "PORTAL_WEIXIN_MATERIAL"."URL" IS '图文页的URL'; COMMENT ON COLUMN "PORTAL_WEIXIN_MATERIAL"."NEED_OPEN_COMMENT" IS '是否打开评论，0不打开，1打开'; COMMENT ON COLUMN "PORTAL_WEIXIN_MATERIAL"."THUMB_URL" IS '素材图片地址'; COMMENT ON COLUMN "PORTAL_WEIXIN_MATERIAL"."ONLY_FANS_CAN_COMMENT" IS '是否粉丝才可评论，0所有人可评论，1粉丝才可评论'; COMMENT ON COLUMN "PORTAL_WEIXIN_MATERIAL"."CREATE_TIME" IS '创建时间'; COMMENT ON COLUMN "PORTAL_WEIXIN_MATERIAL"."UPDATE_TIME" IS '更新时间'; COMMENT ON COLUMN "PORTAL_WEIXIN_MATERIAL"."PULL_TIME" IS '拉取时间'; COMMENT ON TABLE "PORTAL_WEIXIN_MATERIAL" IS '微信永久素材列表'; -- 2022-03-19 jjx 修改索引 create index ALIAS_TENANT_ID__INDEX on PORTAL_SYS_COLUMN (ALIAS, TENANT_ID_) /