lacemi/data/upgrade/v1.1.9/v1.1.9.sql

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;