v1.1.9.sql 501 B

123456789
  1. SET FOREIGN_KEY_CHECKS=0;
  2. ALTER TABLE `t_collection` ADD COLUMN IF NOT EXISTS `collection_gram_weight` decimal(18, 0) NULL DEFAULT NULL AFTER `status`;
  3. 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`;
  4. ALTER TABLE `t_statement_calculation` ADD COLUMN IF NOT EXISTS `calculation_collection_id` int(11) NOT NULL AFTER `calculation_note`;
  5. SET FOREIGN_KEY_CHECKS=1;