SET @db_name = DATABASE();
|
|
SET @clinic_license_col = (
|
SELECT COUNT(*)
|
FROM information_schema.COLUMNS
|
WHERE TABLE_SCHEMA = @db_name
|
AND TABLE_NAME = 'tcm_clinic'
|
AND COLUMN_NAME = 'business_license_url'
|
);
|
|
SET @clinic_license_sql = IF(
|
@clinic_license_col = 0,
|
'ALTER TABLE `tcm_clinic` ADD COLUMN `business_license_url` VARCHAR(255) DEFAULT NULL COMMENT ''营业执照图片'' AFTER `address`',
|
'SELECT 1'
|
);
|
|
PREPARE stmt FROM @clinic_license_sql;
|
EXECUTE stmt;
|
DEALLOCATE PREPARE stmt;
|
