| 123456789 |
- -- 1.0.362 ItemMaster 新增 MRPRequired（是否参与资源检查）
- -- 行尾必须 LF（CRLF 会导致 SHA256 与 sys_db_migration_log 不一致并阻止启动）。
- SET @col_exists := (SELECT COUNT(*) FROM information_schema.COLUMNS
- WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='ItemMaster' AND COLUMN_NAME='MRPRequired');
- SET @sql := IF(@col_exists = 0,
- 'ALTER TABLE `ItemMaster` ADD COLUMN `MRPRequired` tinyint(1) NOT NULL DEFAULT 0 COMMENT ''是否参与资源检查''',
- 'DO 0');
- PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;
|
