-- 22015-08-12 01.5 additional of item from 区分  (FEE MASTER)
UPDATE sms_transactiontype SET deleted = 0 WHERE id = 5


-- 2015-09-17 01.5 add table (smsevent_instances_sub)
CREATE TABLE IF NOT EXISTS `smsevent_instances_sub` (
  `id` CHAR(36) NOT NULL DEFAULT '',
  `curriculum_instance_id` VARCHAR(36),
  `fee_id` VARCHAR(36),
  `ticket_type` VARCHAR(2),
  `os` VARCHAR(1),
  `resource_id` VARCHAR(36),
  `description` VARCHAR(10),
  `confirmed` TINYINT(1),
  PRIMARY KEY  (`id`)
) ENGINE=INNODB DEFAULT CHARSET=utf8;