12 lines
723 B
SQL
12 lines
723 B
SQL
-- xuchao: 补齐 task_template 的模板生效方式字段。生产库曾手工 ALTER 过这三列,
|
|
-- 故用 information_schema 判断实现幂等:已存在则跳过,保证生产与全新库都能安全执行。
|
|
SET @has_mode = (SELECT COUNT(*) FROM information_schema.columns WHERE table_schema = DATABASE() AND table_name = 'task_template' AND column_name = 'mode');
|
|
--> statement-breakpoint
|
|
SET @ddl = IF(@has_mode = 0, 'ALTER TABLE `task_template` ADD COLUMN `mode` varchar(10) NOT NULL DEFAULT ''weekly'', ADD COLUMN `date_start` date, ADD COLUMN `date_end` date', 'SELECT 1');
|
|
--> statement-breakpoint
|
|
PREPARE stmt FROM @ddl;
|
|
--> statement-breakpoint
|
|
EXECUTE stmt;
|
|
--> statement-breakpoint
|
|
DEALLOCATE PREPARE stmt;
|