Newer
Older
casic-production-safety / casic-web / src / main / resources / doc / 历史更新 / 20250113数据库.txt
liwenhao on 6 Jun 1 KB 1.测评问题整改
ALTER TABLE box_device
MODIFY COLUMN server_public_key VARCHAR(512),
MODIFY COLUMN server_private_key VARCHAR(1024),
MODIFY COLUMN client_public_key VARCHAR(512),
MODIFY COLUMN client_private_key VARCHAR(1024);

ALTER TABLE sys_config MODIFY COLUMN VALUE TEXT;



INSERT INTO sys_resource(ID, PID, CODE, P_CODE, P_CODES, NAME, ICON, URL, NUM, LEVELS, IS_MENU, TIPS, IS_OPEN, RESOURCE_TYPE, CREATE_USER, UPDATE_USER, CREATE_TIME, UPDATE_TIME, DEL_FLAG, TENANT_ID, STATUS) VALUES (1872184789440688129, 0, 'bigScreen', '0', '[0],', '安全生产智慧监管平台', '', '/bigScreen', 0, 1, '1', NULL, '0', '03', 1832137050074128386, NULL, '2024-12-26 07:36:52', NULL, '0', NULL, '0');
INSERT INTO sys_resource(ID, PID, CODE, P_CODE, P_CODES, NAME, ICON, URL, NUM, LEVELS, IS_MENU, TIPS, IS_OPEN, RESOURCE_TYPE, CREATE_USER, UPDATE_USER, CREATE_TIME, UPDATE_TIME, DEL_FLAG, TENANT_ID, STATUS) VALUES (1879080561335627777, 105, 'sys_bsConfig', 'system', '[0],[system],', '大屏配置', 'icon-bs', '/sys/bsConfig', 0, 2, '1', NULL, '0', '03', 1832137050074128386, 1832137050074128386, '2025-01-14 08:18:12', '2025-01-14 08:25:05', '0', NULL, '0');