From 6b74cf2b7b5d1813d951e8638044e25c1cbb11f1 Mon Sep 17 00:00:00 2001
From: puzhibing <393733352@qq.com>
Date: 星期五, 04 九月 2026 11:40:28 +0800
Subject: [PATCH] 修改VIN管理表中的字段名称
---
sql/20260903_vin_applet_binding.sql | 12 ++++++------
1 files changed, 6 insertions(+), 6 deletions(-)
diff --git a/sql/20260903_vin_applet_binding.sql b/sql/20260903_vin_applet_binding.sql
index 11f179f..896633f 100644
--- a/sql/20260903_vin_applet_binding.sql
+++ b/sql/20260903_vin_applet_binding.sql
@@ -1,16 +1,16 @@
--- VIN 小程序车辆绑定字段增量脚本，请使用 UTF-8 执行。
-USE `charging_pile_account`;
+-- 小程序 VIN 车辆绑定字段（app_user_id）
+-- 说明：绑定列统一命名为 app_user_id，脚本幂等可重复执行
SET @column_exists := (
SELECT COUNT(1)
FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = DATABASE()
AND TABLE_NAME = 't_vin_management'
- AND COLUMN_NAME = 'appp_user_id'
+ AND COLUMN_NAME = 'app_user_id'
);
SET @column_sql := IF(
@column_exists = 0,
- 'ALTER TABLE `t_vin_management` ADD COLUMN `appp_user_id` BIGINT NULL COMMENT ''绑定的小程序用户ID（三个p）'' AFTER `del_flag`',
+ 'ALTER TABLE `t_vin_management` ADD COLUMN `app_user_id` BIGINT NULL COMMENT ''绑定的小程序用户ID'' AFTER `del_flag`',
'SELECT 1'
);
PREPARE column_stmt FROM @column_sql;
@@ -22,11 +22,11 @@
FROM information_schema.STATISTICS
WHERE TABLE_SCHEMA = DATABASE()
AND TABLE_NAME = 't_vin_management'
- AND INDEX_NAME = 'idx_appp_user_id'
+ AND INDEX_NAME = 'idx_app_user_id'
);
SET @index_sql := IF(
@index_exists = 0,
- 'ALTER TABLE `t_vin_management` ADD INDEX `idx_appp_user_id` (`appp_user_id`)',
+ 'ALTER TABLE `t_vin_management` ADD INDEX `idx_app_user_id` (`app_user_id`)',
'SELECT 1'
);
PREPARE index_stmt FROM @index_sql;
--
Gitblit v1.7.1