From bcaa5d1db58566d85ea51c549d11cd3ca95947c9 Mon Sep 17 00:00:00 2001 From: cl <1442464845@qq.com> Date: 星期二, 14 四月 2026 14:56:09 +0800 Subject: [PATCH] 对应sql --- version/db/sys_http_audit_rule.sql | 21 ++++++++++ version/db/sys_order_work_type_d004.sql | 7 +++ rsf-open-api/src/main/resources/sql/rcs_tv_callback_urls_monitor_jdxaj.sql | 10 +++++ version/db/sys_config_add_uuid.sql | 6 +++ version/db/sys_http_audit_rule_alter_202604.sql | 23 +++++++++++ version/db/man_wk_type_varchar.sql | 8 ++++ version/db/man_matnr_add_batch_unique.sql | 8 ++++ version/db/http_audit_rule_menu.sql | 33 ++++++++++++++++ 8 files changed, 116 insertions(+), 0 deletions(-) diff --git a/rsf-open-api/src/main/resources/sql/rcs_tv_callback_urls_monitor_jdxaj.sql b/rsf-open-api/src/main/resources/sql/rcs_tv_callback_urls_monitor_jdxaj.sql new file mode 100644 index 0000000..0729ade --- /dev/null +++ b/rsf-open-api/src/main/resources/sql/rcs_tv_callback_urls_monitor_jdxaj.sql @@ -0,0 +1,10 @@ +-- 渚� monitor_jdxaj 搴� sys_config 璁板綍銆孯CS 搴旀帹閫佺殑 WMS 鍦板潃銆嶏紙鐢佃鏈哄悗鍙颁唬鐮佷笉璇讳篃鍙紝浠呰繍缁�/RCS 閰嶇疆鍙傝�冿級 +-- 璇峰皢 http://127.0.0.1:8082/rsf-open-api 鎹㈡垚瀹為檯 rsf-open-api 澶栫綉鍦板潃 + +INSERT INTO `sys_config` (`name`, `code`, `value`, `type`, `status`, `select_type`) +SELECT 'RCS杈撻�佺嚎鎶ヨ鎺ㄩ��(WMS)', 'rcsTvStationErrorPushUrl', 'http://127.0.0.1:8082/rsf-open-api/rcs/callback/tv/station/error', 1, 1, 'system' +WHERE NOT EXISTS (SELECT 1 FROM `sys_config` WHERE `code` = 'rcsTvStationErrorPushUrl'); + +INSERT INTO `sys_config` (`name`, `code`, `value`, `type`, `status`, `select_type`) +SELECT 'RCS杈撻�佺嚎浠诲姟鍙锋帹閫�(WMS)', 'rcsTvStationTaskNoPushUrl', 'http://127.0.0.1:8082/rsf-open-api/rcs/callback/tv/station/taskNo', 1, 1, 'system' +WHERE NOT EXISTS (SELECT 1 FROM `sys_config` WHERE `code` = 'rcsTvStationTaskNoPushUrl'); diff --git a/version/db/http_audit_rule_menu.sql b/version/db/http_audit_rule_menu.sql new file mode 100644 index 0000000..dbc1e88 --- /dev/null +++ b/version/db/http_audit_rule_menu.sql @@ -0,0 +1,33 @@ +-- HTTP 瀹¤瑙勫垯鑿滃崟锛堢郴缁熺鐞嗕笅锛屼笌 HTTP鎺ュ彛瀹¤ 鍚岀骇锛夛紱鎵ц鍓嶈纭 id 393-397 鏈鍗犵敤 +SET NAMES utf8mb4; + +INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) +SELECT 393, 'menu.httpAuditRule', 1, 'menu.system', '1,393', 'menu.httpAuditRule', '/system/httpAuditRule', 'httpAuditRule', NULL, NULL, 0, NULL, 'Rule', 7, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL +FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `sys_menu` WHERE `id` = 393); + +INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) +SELECT 394, 'Query HttpAuditRule', 393, '', '1,393,394', NULL, NULL, NULL, NULL, NULL, 1, 'system:httpAuditRule:list', NULL, 0, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL +FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `sys_menu` WHERE `id` = 394); + +INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) +SELECT 395, 'Save HttpAuditRule', 393, '', '1,393,395', NULL, NULL, NULL, NULL, NULL, 1, 'system:httpAuditRule:save', NULL, 1, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL +FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `sys_menu` WHERE `id` = 395); + +INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) +SELECT 396, 'Update HttpAuditRule', 393, '', '1,393,396', NULL, NULL, NULL, NULL, NULL, 1, 'system:httpAuditRule:update', NULL, 2, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL +FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `sys_menu` WHERE `id` = 396); + +INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) +SELECT 397, 'Delete HttpAuditRule', 393, '', '1,393,397', NULL, NULL, NULL, NULL, NULL, 1, 'system:httpAuditRule:remove', NULL, 3, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL +FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `sys_menu` WHERE `id` = 397); + +INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) +SELECT 1, 393 FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `sys_role_menu` WHERE `role_id` = 1 AND `menu_id` = 393); +INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) +SELECT 1, 394 FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `sys_role_menu` WHERE `role_id` = 1 AND `menu_id` = 394); +INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) +SELECT 1, 395 FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `sys_role_menu` WHERE `role_id` = 1 AND `menu_id` = 395); +INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) +SELECT 1, 396 FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `sys_role_menu` WHERE `role_id` = 1 AND `menu_id` = 396); +INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) +SELECT 1, 397 FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `sys_role_menu` WHERE `role_id` = 1 AND `menu_id` = 397); diff --git a/version/db/man_matnr_add_batch_unique.sql b/version/db/man_matnr_add_batch_unique.sql new file mode 100644 index 0000000..e3bc9f1 --- /dev/null +++ b/version/db/man_matnr_add_batch_unique.sql @@ -0,0 +1,8 @@ +-- 鐗╂枡锛氭棤鎵规鏃� batch 涓虹┖涓诧紝鐗╂枡缂栫爜鍞竴锛涙湁鎵规鏃� (code, batch) 鍞竴 + +ALTER TABLE `man_matnr` + ADD COLUMN `batch` VARCHAR(64) NOT NULL DEFAULT '' COMMENT '鎵规锛岀┖涓茶〃绀烘棤鎵规' AFTER `code`; + +UPDATE `man_matnr` SET `batch` = '' WHERE `batch` IS NULL; + +CREATE UNIQUE INDEX `uk_man_matnr_code_batch` ON `man_matnr` (`code`, `batch`); diff --git a/version/db/man_wk_type_varchar.sql b/version/db/man_wk_type_varchar.sql new file mode 100644 index 0000000..3618293 --- /dev/null +++ b/version/db/man_wk_type_varchar.sql @@ -0,0 +1,8 @@ +-- 涓氬姟绫诲瀷 wk_type锛氫笌涓诲崟 man_asn_order 涓�鑷存敼涓� VARCHAR锛屾敮鎸� D004 绛夌紪鐮� +-- 鎵ц鍓嶈纭鍒楀悕涓庤〃鍚嶄笌绾夸笂涓�鑷达紱鑻ユ湁 view_stock_manage 绛夎鍥句緷璧� wk_type 绫诲瀷锛岄渶鍚屾閲嶅缓瑙嗗浘 + +ALTER TABLE `man_wait_pakin_item` MODIFY COLUMN `wk_type` VARCHAR(32) NULL COMMENT '涓氬姟绫诲瀷'; +ALTER TABLE `man_task_item` MODIFY COLUMN `wk_type` VARCHAR(32) NULL COMMENT '涓氬姟绫诲瀷'; +ALTER TABLE `man_loc_item` MODIFY COLUMN `wk_type` VARCHAR(32) NULL COMMENT '涓氬姟绫诲瀷'; +ALTER TABLE `man_stock` MODIFY COLUMN `wk_type` VARCHAR(32) NULL COMMENT '涓氬姟绫诲瀷'; +ALTER TABLE `man_loc_item_working` MODIFY COLUMN `wk_type` VARCHAR(32) NULL COMMENT '涓氬姟绫诲瀷'; diff --git a/version/db/sys_config_add_uuid.sql b/version/db/sys_config_add_uuid.sql new file mode 100644 index 0000000..f8b1ae8 --- /dev/null +++ b/version/db/sys_config_add_uuid.sql @@ -0,0 +1,6 @@ +-- 涓� init.sql 涓� sys_config 缁撴瀯瀵归綈锛氭棫搴撶己 uuid 鏃舵墽琛� + +SET NAMES utf8mb4; + +ALTER TABLE `sys_config` + ADD COLUMN `uuid` varchar(255) DEFAULT NULL COMMENT '缂栧彿' AFTER `id`; diff --git a/version/db/sys_http_audit_rule.sql b/version/db/sys_http_audit_rule.sql new file mode 100644 index 0000000..514a2cd --- /dev/null +++ b/version/db/sys_http_audit_rule.sql @@ -0,0 +1,21 @@ +-- HTTP 瀹¤鐧藉悕鍗曡鍒欙紙浠呭懡涓鍒欐椂鍐欏璁℃棩蹇楋紝鍙� http-audit.whitelist-only 鎺у埗锛� +SET NAMES utf8mb4; + +CREATE TABLE `sys_http_audit_rule` ( + `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '涓婚敭', + `rule_type` varchar(32) NOT NULL COMMENT 'URI / IP / REQUEST_BODY', + `match_mode` varchar(32) NOT NULL COMMENT 'EQUAL / PREFIX / CONTAINS / REGEX', + `pattern` varchar(2048) NOT NULL COMMENT '鍖归厤鍐呭', + `direction` varchar(16) NOT NULL DEFAULT 'IN' COMMENT 'IN鍏ョ珯 OUT鍑虹珯 BOTH鍙屽悜', + `request_max_chars` int(11) DEFAULT NULL COMMENT '-1鍏ㄩ噺 NULL鐢╤ttp-audit榛樿', + `response_max_chars` int(11) DEFAULT NULL COMMENT '-1鍏ㄩ噺 NULL鐢╤ttp-audit榛樿', + `enabled` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1 鍚敤 0 鍋滅敤', + `record_all` tinyint(4) NOT NULL DEFAULT '0' COMMENT '1=鍏ョ珯+鍑虹珯鍏ㄨ(whitelist-only涓�)', + `sort_order` int(11) NOT NULL DEFAULT '0' COMMENT '鎺掑簭锛堝皬鍦ㄥ墠锛�', + `remark` varchar(512) DEFAULT NULL COMMENT '澶囨敞', + `create_time` datetime DEFAULT NULL COMMENT '鍒涘缓鏃堕棿', + `update_time` datetime DEFAULT NULL COMMENT '鏇存柊鏃堕棿', + `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '閫昏緫鍒犻櫎', + PRIMARY KEY (`id`), + KEY `idx_enabled_deleted` (`enabled`,`deleted`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='HTTP瀹¤鐧藉悕鍗曡鍒�'; diff --git a/version/db/sys_http_audit_rule_alter_202604.sql b/version/db/sys_http_audit_rule_alter_202604.sql new file mode 100644 index 0000000..dd738a4 --- /dev/null +++ b/version/db/sys_http_audit_rule_alter_202604.sql @@ -0,0 +1,23 @@ +-- HTTP 瀹¤瑙勫垯鎵╁睍锛氭柟鍚戙�佽姹�/鍝嶅簲鎴柇闀垮害銆佸叏閲忚褰曞紑鍏� + +SET NAMES utf8mb4; + + + +ALTER TABLE `sys_http_audit_rule` + + ADD COLUMN `direction` varchar(16) NOT NULL DEFAULT 'IN' COMMENT 'IN鍏ョ珯 OUT鍑虹珯 BOTH鍙屽悜' AFTER `pattern`, + + ADD COLUMN `request_max_chars` int(11) DEFAULT NULL COMMENT '-1鍏ㄩ噺 NULL鐢╤ttp-audit榛樿', + + ADD COLUMN `response_max_chars` int(11) DEFAULT NULL COMMENT '-1鍏ㄩ噺 NULL鐢╤ttp-audit榛樿', + + ADD COLUMN `record_all` tinyint(4) NOT NULL DEFAULT '0' COMMENT '1=鍏ョ珯+鍑虹珯鍏ㄨ(whitelist-only涓嬩粛鐢熸晥)' AFTER `enabled`; + + + +ALTER TABLE `sys_http_audit_log` + + ADD COLUMN `io_direction` varchar(8) DEFAULT 'IN' COMMENT 'IN鍏ョ珯 OUT鍑虹珯' AFTER `uri`; + + diff --git a/version/db/sys_order_work_type_d004.sql b/version/db/sys_order_work_type_d004.sql new file mode 100644 index 0000000..e7f9a16 --- /dev/null +++ b/version/db/sys_order_work_type_d004.sql @@ -0,0 +1,7 @@ +-- 璁㈠崟涓氬姟绫诲瀷瀛楀吀锛欴004 閿�鍞��璐э紙涓� OrderWorkType.ORDER_WORK_TYPE_SALES_RETURN_D004 涓�鑷达級 + +INSERT INTO `sys_dict_data` (`dict_type_id`, `dict_type_code`, `value`, `label`, `sort`, `status`, `deleted`, `tenant_id`, `create_by`, `create_time`, `update_by`, `update_time`, `memo`) +SELECT t.id, 'sys_order_work_type', 'D004', '閿�鍞��璐�', 20, 1, 0, 1, NULL, NOW(), NULL, NOW(), NULL +FROM sys_dict_type t +WHERE t.code = 'sys_order_work_type' + AND NOT EXISTS (SELECT 1 FROM sys_dict_data d WHERE d.dict_type_code = 'sys_order_work_type' AND d.value = 'D004' LIMIT 1); -- Gitblit v1.9.1