17 lines
531 B
SQL
17 lines
531 B
SQL
SET @table_schema = DATABASE();
|
|
|
|
SET @ddl = IF(
|
|
EXISTS(
|
|
SELECT 1
|
|
FROM information_schema.COLUMNS
|
|
WHERE TABLE_SCHEMA = @table_schema
|
|
AND TABLE_NAME = 'team_manager_base_info'
|
|
AND COLUMN_NAME = 'can_change_country'
|
|
),
|
|
'SELECT 1',
|
|
"ALTER TABLE `team_manager_base_info` ADD COLUMN `can_change_country` tinyint(1) NOT NULL DEFAULT 1 COMMENT '经理中心是否允许修改用户国家' AFTER `can_unban_user`"
|
|
);
|
|
PREPARE stmt FROM @ddl;
|
|
EXECUTE stmt;
|
|
DEALLOCATE PREPARE stmt;
|