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


-- 2015-09-17 05_Cheery_Spec 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;

-- 2015-10-07 05_Cheery_Spec add table (school_memo)
CREATE TABLE IF NOT EXISTS `school_memo` (
  `resource_id` VARCHAR(36),
  `date` DATE,
  `description` TEXT
) ENGINE=INNODB DEFAULT CHARSET=utf8;

-- 2015-11-26 05 and 05.2 Cheery_Spec
-- bug 57981
ALTER TABLE `smsevent_instances_sub` 
CHANGE `os` `os` VARCHAR(2) CHARSET utf8 COLLATE utf8_general_ci NULL

-- 2015-12-10 Spec 00 (menu shortcuts)
ALTER TABLE menu_priviledge MODIFY COLUMN menu_item VARCHAR(50); 

-- (rio) 74912 : create batch_ctrl config
INSERT INTO config (`category`, `name`, `value`)
VALUES  ('batch_ctrl','monthly_day','1'), ('batch_ctrl','from_time','00:00'), ('batch_ctrl','to_time','12:00');