8.0.sql
27.6 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
-- 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_)
/