8.0.2 To 8.0.3.sql
3.8 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
/*
change.sql 说明
1.数据库相关修改添加到对应的 change.sql 文件，无需调整其他 sql 文件
2.sql 语句验证正确后再提交
*/
-- 2022-8-3 liangjc PORTAL_SYS_MENU 增加菜单类型
ALTER TABLE PORTAL_SYS_MENU ADD TYPE_ VARCHAR(50) comment '菜单类型';
-- 2022-08-08 yujl 增加account账号字段
ALTER TABLE portal_biz_system_auth ADD COLUMN `account_` varchar(64) COMMENT '账号';
-- 2022-08-12 yijj 修改form_data_template的 SUB_FIELD_ 字段类型为longtext
ALTER TABLE form_data_template MODIFY COLUMN `SUB_FIELD_` longtext NULL COMMENT '子表字段' AFTER `AFTER_FCRIPT_`;
-- liangjc 2022-8-12 修改字段长度
alter table FORM_META modify NAME_ VARCHAR(150);
alter table FORM_PRINT_TEMPLATE modify FILE_NAME VARCHAR(150);
alter table PORTAL_SYS_MENU modify NAME_ VARCHAR(150);
alter table portal_sys_logs_settings modify REMARK_ VARCHAR(1000);
alter table UC_ROLE modify DESCRIPTION_ VARCHAR(150);
alter table PORTAL_SERVICE_CHOREOGRAPHY modify NAME_ VARCHAR(150);
alter table PORTAL_INTERFACE_MANAGER modify NAME_ VARCHAR(150);
alter table PORTAL_CONNECTION_MANAGER modify NAME_ VARCHAR(150);
alter table PORTAL_SYS_DATASOURCE modify NAME_ VARCHAR(150);
alter table FORM_CUSTOM_CHART modify NAME_ VARCHAR(150);
alter table PORTAL_SYS_APP modify NAME_ VARCHAR(150);
alter table PORTAL_SYS_APP modify DESC_ VARCHAR(1000);
alter table PORTAL_BIZ_SYSTEM modify SYS_CODE_ VARCHAR(150);
alter table PORTAL_BIZ_SYSTEM modify SYS_NAME_ VARCHAR(150);
alter table PORTAL_BIZ_SYSTEM modify ROOT_ADDRESS_ VARCHAR(1000);
alter table PORTAL_BIZ_SYSTEM modify HOME_ADDRESS_ VARCHAR(1000);
alter table PORTAL_BIZ_SYSTEM modify BPM_MSG_QUEUE_ VARCHAR(150);
alter table PORTAL_SYS_MODULE modify NAME_ VARCHAR(150);
alter table PORTAL_SYS_MODULE modify CODE_ VARCHAR(150);
alter table PORTAL_SYS_PROPERTIES modify NAME VARCHAR(150);
alter table PORTAL_SYS_PROPERTIES modify ALIAS VARCHAR(150);
alter table PORTAL_SYS_PROPERTIES modify GROUP_ VARCHAR(150);
alter table PORTAL_SYS_PROPERTIES modify DESCRIPTION VARCHAR(1000);
alter table UC_ROLE modify NAME_ VARCHAR(150);
alter table UC_TENANT_MANAGE modify NAME_ VARCHAR(300);
alter table UC_TENANT_MANAGE modify NAME_FRONT_ VARCHAR(300);
alter table UC_TENANT_MANAGE modify SHORTHAND_ VARCHAR(150);
alter table BPM_AGENT_SETTING modify SUBJECT_ VARCHAR(150);
alter table FORM_BO_DEF modify DESCRIPTION_ VARCHAR(150);
alter table PORTAL_SYS_MSG_TPL modify KEY_ VARCHAR(150);
alter table PORTAL_SYS_MSG_TPL modify SMS_TEMPLATE_NO_ VARCHAR(150);
alter table PORTAL_SYS_MSG_TPL modify VOICE_TEMPLATE_NO_ VARCHAR(150);
alter table PORTAL_SYS_MSG_TPL modify SUBJECT_ VARCHAR(1000);
alter table BPM_MULTI_SCRIPT modify METHOD_DESC_ VARCHAR(1000);
alter table BPM_SCRIPT modify NAME_ VARCHAR(150);
alter table BPM_SCRIPT modify MEMO_ VARCHAR(1000);
alter table PORTAL_FLOW_UPLOAD_PROPERTIES modify NAME_ VARCHAR(150);
alter table PORTAL_FLOW_UPLOAD_PROPERTIES modify LOCATION_ VARCHAR(300);
alter table PORTAL_FLOW_UPLOAD_PROPERTIES modify FTP_URL_ VARCHAR(300);
alter table PORTAL_FLOW_UPLOAD_PROPERTIES modify FTP_PORT_ VARCHAR(300);
alter table PORTAL_FLOW_UPLOAD_PROPERTIES modify FTP_USER_NAME_ VARCHAR(150);
alter table PORTAL_FLOW_UPLOAD_PROPERTIES modify FTP_PASSWORD_ VARCHAR(150);
alter table PORTAL_FLOW_UPLOAD_PROPERTIES modify DESC_ VARCHAR(1000);
alter table PORTAL_BIZ_SYSTEM_AUTH modify SYS_NAME_ VARCHAR(150);
-- yijj 修改菜单旧数据
UPDATE PORTAL_SYS_MENU
SET TYPE_ = 'catalog'
WHERE
ID_ IN ( SELECT t.id_ FROM ( SELECT id_ FROM PORTAL_SYS_MENU WHERE ROUTE_EXTEND_ LIKE '%"MultilevelMenuLayout%' OR ROUTE_EXTEND_ LIKE '%"Layout%' OR ROUTE_EXTEND_ IS NULL ) t );
UPDATE PORTAL_SYS_MENU
SET type_ = 'page'
WHERE
id_ NOT IN ( SELECT t.id_ FROM ( SELECT id_ FROM PORTAL_SYS_MENU WHERE ROUTE_EXTEND_ LIKE '%"MultilevelMenuLayout%' OR ROUTE_EXTEND_ LIKE '%"Layout%' OR ROUTE_EXTEND_ IS NULL ) t );