123456789 |
- SET FOREIGN_KEY_CHECKS=0;
- ALTER TABLE `t_collection` ADD COLUMN IF NOT EXISTS `collection_gram_weight` decimal(18, 0) NULL DEFAULT NULL AFTER `status`;
- ALTER TABLE `t_collection` ADD COLUMN IF NOT EXISTS `collection_gram_weight_unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT 'g/m2' AFTER `collection_gram_weight`;
- ALTER TABLE `t_statement_calculation` ADD COLUMN IF NOT EXISTS `calculation_collection_id` int(11) NOT NULL AFTER `calculation_note`;
- SET FOREIGN_KEY_CHECKS=1;
|