执行语句:
USE brewage;
-- 检查字段是否已经存在(可选,但推荐以避免重复添加)
SET @inspection_type_field_exists = (SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'brewage'
AND TABLE_NAME = 't_qa_inspection_task'
AND COLUMN_NAME = 'inspection_type');
IF inspection_type_field_exists = 0 THEN
ALTER TABLE t_qa_inspection_task ADD COLUMN inspection_type VARCHAR(255) NOT NULL DEFAULT '';
-- 如果需要,还可以添加索引或其他约束
-- ALTER TABLE users ADD INDEX idx_email (email);
-- 插入版本更新记录(可选,但有助于跟踪)
INSERT INTO version_control_table (table_name, version, upgrade_date) VALUES ('t_qa_inspection_task', '1.1', NOW());
END IF;