#Jed 60961 
CREATE TABLE `state_master` (
 `id` VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`name` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
PRIMARY KEY ( `id` ) 
) ENGINE = InnoDB;

INSERT INTO state_master (id, name) VALUES ("01","東北地方");
INSERT INTO state_master (id, name) VALUES ("02","関東地方");
INSERT INTO state_master (id, name) VALUES ("03","中部地方");
INSERT INTO state_master (id, name) VALUES ("04","近畿地方");
INSERT INTO state_master (id, name) VALUES ("05","中国地方");
INSERT INTO state_master (id, name) VALUES ("06","四国地方");
INSERT INTO state_master (id, name) VALUES ("07","九州地方");
INSERT INTO state_master (id, name) VALUES ("10","北海道");
INSERT INTO state_master (id, name) VALUES ("11","青森県");
INSERT INTO state_master (id, name) VALUES ("12","岩手県");
INSERT INTO state_master (id, name) VALUES ("13","宮城県");
INSERT INTO state_master (id, name) VALUES ("14","秋田県");
INSERT INTO state_master (id, name) VALUES ("15","山形県");
INSERT INTO state_master (id, name) VALUES ("16","福島県");
INSERT INTO state_master (id, name) VALUES ("17","茨城県");
INSERT INTO state_master (id, name) VALUES ("18","栃木県");
INSERT INTO state_master (id, name) VALUES ("19","群馬県");
INSERT INTO state_master (id, name) VALUES ("20","埼玉県");
INSERT INTO state_master (id, name) VALUES ("21","千葉県");
INSERT INTO state_master (id, name) VALUES ("22","東京都");
INSERT INTO state_master (id, name) VALUES ("23","神奈川県");
INSERT INTO state_master (id, name) VALUES ("24","新潟県");
INSERT INTO state_master (id, name) VALUES ("25","富山県");
INSERT INTO state_master (id, name) VALUES ("26","石川県");
INSERT INTO state_master (id, name) VALUES ("27","福井県");
INSERT INTO state_master (id, name) VALUES ("28","山梨県");
INSERT INTO state_master (id, name) VALUES ("29","長野県");
INSERT INTO state_master (id, name) VALUES ("30","岐阜県");
INSERT INTO state_master (id, name) VALUES ("31","静岡県");
INSERT INTO state_master (id, name) VALUES ("32","愛知県");
INSERT INTO state_master (id, name) VALUES ("33","三重県");
INSERT INTO state_master (id, name) VALUES ("34","滋賀県");
INSERT INTO state_master (id, name) VALUES ("35","京都府");
INSERT INTO state_master (id, name) VALUES ("36","大阪府");
INSERT INTO state_master (id, name) VALUES ("37","兵庫県");
INSERT INTO state_master (id, name) VALUES ("38","奈良県");
INSERT INTO state_master (id, name) VALUES ("39","和歌山県");
INSERT INTO state_master (id, name) VALUES ("40","鳥取県");
INSERT INTO state_master (id, name) VALUES ("41","島根県");
INSERT INTO state_master (id, name) VALUES ("42","岡山県");
INSERT INTO state_master (id, name) VALUES ("43","広島県");
INSERT INTO state_master (id, name) VALUES ("44","山口県");
INSERT INTO state_master (id, name) VALUES ("45","徳島県");
INSERT INTO state_master (id, name) VALUES ("46","香川県");
INSERT INTO state_master (id, name) VALUES ("47","愛媛県");
INSERT INTO state_master (id, name) VALUES ("48","高知県");
INSERT INTO state_master (id, name) VALUES ("49","福岡県");
INSERT INTO state_master (id, name) VALUES ("50","佐賀県");
INSERT INTO state_master (id, name) VALUES ("51","長崎県");
INSERT INTO state_master (id, name) VALUES ("52","熊本県");
INSERT INTO state_master (id, name) VALUES ("53","大分県");
INSERT INTO state_master (id, name) VALUES ("54","宮崎県");
INSERT INTO state_master (id, name) VALUES ("55","鹿児島県");
INSERT INTO state_master (id, name) VALUES ("56","沖縄");

#Rio 61288

CREATE TABLE IF NOT EXISTS `manual_transaction` (
  `id` varchar(36) NOT NULL DEFAULT '',
  `custom_unique_id` varchar(50) DEFAULT NULL,
  `contact_name` varchar(255) DEFAULT NULL,
  `fee_name` varchar(255) DEFAULT NULL,
  `t_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `actual_in_amount` int(11) NOT NULL DEFAULT '0',
  `mikakunin_zandaka` int(11) NOT NULL DEFAULT '0',
  `payment_type` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `date_entered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_user_id` varchar(36) DEFAULT NULL,
  `created_by` varchar(36) DEFAULT NULL,
  `contact_id` varchar(36) DEFAULT NULL,
  `description` text,
  `raw_import_data` text NOT NULL,
  `import_serial_no` int(11) NOT NULL AUTO_INCREMENT,
  `school_id` varchar(36) NOT NULL ,
  PRIMARY KEY (`import_serial_no`),
  UNIQUE KEY `unique_id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


-- Jewel 68774
ALTER TABLE email_templates
MODIFY COLUMN body_html LONGTEXT;