wuweihua
31 lines
813 B
SQL
31 lines
813 B
SQL
-- prc_order_bill: drop match_source / match_message.
|
|
-- Idempotent.
|
|
|
|
SET NAMES utf8mb4;
|
|
|
|
SET @sql_drop_match_source = (
|
|
SELECT IF(
|
|
COUNT(*) > 0,
|
|
'ALTER TABLE prc_order_bill DROP COLUMN match_source',
|
|
'SELECT 1'
|
|
)
|
|
FROM information_schema.COLUMNS
|
|
WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'prc_order_bill' AND COLUMN_NAME = 'match_source'
|
|
);
|
|
PREPARE stmt FROM @sql_drop_match_source;
|
|
EXECUTE stmt;
|
|
DEALLOCATE PREPARE stmt;
|
|
|
|
SET @sql_drop_match_message = (
|
|
SELECT IF(
|
|
COUNT(*) > 0,
|
|
'ALTER TABLE prc_order_bill DROP COLUMN match_message',
|
|
'SELECT 1'
|
|
)
|
|
FROM information_schema.COLUMNS
|
|
WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'prc_order_bill' AND COLUMN_NAME = 'match_message'
|
|
);
|
|
PREPARE stmt FROM @sql_drop_match_message;
|
|
EXECUTE stmt;
|
|
DEALLOCATE PREPARE stmt;
|