-- 托盘和生产批次独立业务码；先升级数据库再部署后端。历史记录在页面补生成。
|
SET @business_exists = (SELECT COUNT(*) FROM information_schema.columns
|
WHERE table_schema = DATABASE() AND table_name = 'mes_pro_pallet' AND column_name = 'business_code');
|
SET @business_ddl = IF(@business_exists = 0,
|
'ALTER TABLE mes_pro_pallet ADD COLUMN business_code VARCHAR(16) DEFAULT NULL COMMENT ''内部出入库业务码（16位数字）'' AFTER code', 'SELECT 1');
|
PREPARE business_stmt FROM @business_ddl;
|
EXECUTE business_stmt;
|
DEALLOCATE PREPARE business_stmt;
|
SET @business_exists = (SELECT COUNT(*) FROM information_schema.statistics
|
WHERE table_schema = DATABASE() AND table_name = 'mes_pro_pallet' AND index_name = 'uk_business_code');
|
SET @business_ddl = IF(@business_exists = 0,
|
'ALTER TABLE mes_pro_pallet ADD UNIQUE KEY uk_business_code (business_code)', 'SELECT 1');
|
PREPARE business_stmt FROM @business_ddl;
|
EXECUTE business_stmt;
|
DEALLOCATE PREPARE business_stmt;
|
|
SET @business_exists = (SELECT COUNT(*) FROM information_schema.columns
|
WHERE table_schema = DATABASE() AND table_name = 'mes_pro_batch' AND column_name = 'business_code');
|
SET @business_ddl = IF(@business_exists = 0,
|
'ALTER TABLE mes_pro_batch ADD COLUMN business_code VARCHAR(16) DEFAULT NULL COMMENT ''内部出入库业务码（16位数字）'' AFTER code', 'SELECT 1');
|
PREPARE business_stmt FROM @business_ddl;
|
EXECUTE business_stmt;
|
DEALLOCATE PREPARE business_stmt;
|
SET @business_exists = (SELECT COUNT(*) FROM information_schema.statistics
|
WHERE table_schema = DATABASE() AND table_name = 'mes_pro_batch' AND index_name = 'uk_business_code');
|
SET @business_ddl = IF(@business_exists = 0,
|
'ALTER TABLE mes_pro_batch ADD UNIQUE KEY uk_business_code (business_code)', 'SELECT 1');
|
PREPARE business_stmt FROM @business_ddl;
|
EXECUTE business_stmt;
|
DEALLOCATE PREPARE business_stmt;
|
