2025-08-27 14:43
-- update system_users set creator=1 where creator ='admin' or creator=''
-- 修改创建字段
SELECT CONCAT('update `',table_name,'` set creator=1 where creator =\'admin\' or creator=\'\';')
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'lin_dev_master'
and COLUMN_NAME='creator'
SELECT CONCAT('ALTER TABLE `',table_name,'` CHANGE COLUMN `creator` `create_user` bigint DEFAULT NULL COMMENT \'创建者\' ;')
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'lin_dev_master'
and COLUMN_NAME='creator'
-- 修改更新字段
SELECT CONCAT('update `',table_name,'` set updater=1 where updater =\'admin\' or updater=\'\';')
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'lin_dev_master'
and COLUMN_NAME='updater'
SELECT CONCAT('ALTER TABLE `',table_name,'` CHANGE COLUMN `updater` `update_user` bigint DEFAULT NULL COMMENT \'更新者\' ;')
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'lin_dev_master'
and COLUMN_NAME='updater'
-- 修改更新字段
SELECT CONCAT('ALTER TABLE `',table_name,'` CHANGE COLUMN `deleted` `is_deleted` bigint DEFAULT 0 COMMENT \'是否删除\' ;')
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'lin_dev_master'
and COLUMN_NAME='deleted'