20 lines
1.1 KiB
SQL
20 lines
1.1 KiB
SQL
-- 海外人工费用说明字段。仅修改 baiyue_lastleg.ll_finance_fee_source 的结构。
|
|
-- 执行需单独授权；使用独立连接、遇错停止。先执行本脚本，再加载配套 Lastleg 代码。
|
|
-- 无业务数据回填、费用重建、资金操作或菜单变更。已有字段时跳过新增。
|
|
USE baiyue_lastleg;
|
|
|
|
SET @overseas_fee_remark_ddl = (
|
|
SELECT IF(EXISTS(
|
|
SELECT 1 FROM information_schema.columns
|
|
WHERE table_schema = DATABASE() AND table_name = 'll_finance_fee_source' AND column_name = 'fee_remark'
|
|
), 'SELECT ''fee_remark already exists'' AS result',
|
|
'ALTER TABLE ll_finance_fee_source ADD COLUMN fee_remark VARCHAR(500) NULL COMMENT ''费用说明，补收或重复作业原因'' AFTER fee_item_name')
|
|
);
|
|
PREPARE overseas_fee_remark_stmt FROM @overseas_fee_remark_ddl;
|
|
EXECUTE overseas_fee_remark_stmt;
|
|
DEALLOCATE PREPARE overseas_fee_remark_stmt;
|
|
|
|
SELECT table_schema, table_name, column_name, column_type, is_nullable, column_comment
|
|
FROM information_schema.columns
|
|
WHERE table_schema = 'baiyue_lastleg' AND table_name = 'll_finance_fee_source' AND column_name = 'fee_remark';
|