62 lines
1.9 KiB
SQL
62 lines
1.9 KiB
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_add_bd_leader'
|
|
),
|
|
'SELECT 1',
|
|
"ALTER TABLE `team_manager_base_info` ADD COLUMN `can_add_bd_leader` tinyint(1) NOT NULL DEFAULT 1 COMMENT '经理中心是否允许添加BD Leader' AFTER `region_id`"
|
|
);
|
|
PREPARE stmt FROM @ddl;
|
|
EXECUTE stmt;
|
|
DEALLOCATE PREPARE stmt;
|
|
|
|
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_gift_props'
|
|
),
|
|
'SELECT 1',
|
|
"ALTER TABLE `team_manager_base_info` ADD COLUMN `can_gift_props` tinyint(1) NOT NULL DEFAULT 1 COMMENT '经理中心是否允许赠送道具' AFTER `can_add_bd_leader`"
|
|
);
|
|
PREPARE stmt FROM @ddl;
|
|
EXECUTE stmt;
|
|
DEALLOCATE PREPARE stmt;
|
|
|
|
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_ban_user'
|
|
),
|
|
'SELECT 1',
|
|
"ALTER TABLE `team_manager_base_info` ADD COLUMN `can_ban_user` tinyint(1) NOT NULL DEFAULT 1 COMMENT '经理中心是否允许封禁用户' AFTER `can_gift_props`"
|
|
);
|
|
PREPARE stmt FROM @ddl;
|
|
EXECUTE stmt;
|
|
DEALLOCATE PREPARE stmt;
|
|
|
|
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_unban_user'
|
|
),
|
|
'SELECT 1',
|
|
"ALTER TABLE `team_manager_base_info` ADD COLUMN `can_unban_user` tinyint(1) NOT NULL DEFAULT 1 COMMENT '经理中心是否允许解封用户' AFTER `can_ban_user`"
|
|
);
|
|
PREPARE stmt FROM @ddl;
|
|
EXECUTE stmt;
|
|
DEALLOCATE PREPARE stmt;
|