--sandi; saitama school
INSERT INTO resource(id,school_id,date_entered,date_modified,modified_user_id,created_by,NAME,catergory,deleted)
VALUES ('9d7e4e19-a74b-8614-6f48-57e5a1458d39','02',NOW(),NOW(),'1','1','埼玉','school','0');

INSERT INTO resource_sub1(id_sub1,last_student_id_c,last_invoice_id_c,last_teacher_id_c,shimebi_c)
VALUES ('9d7e4e19-a74b-8614-6f48-57e5a1458d39','0','0','0','2017-01-01');

-- rio; 04.2_【Sawa】 Spec (Bank Transfer Result Import・Payment Process)
CREATE TABLE IF NOT EXISTS `manual_transaction` (
	`id`	 VARCHAR(36) NOT NULL,
	`salesno` VARCHAR(36),
	`contact_name` VARCHAR(36) NOT NULL,
	`t_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
	`actual_in_amount` DOUBLE,
	`mikakunin_zandaka` VARCHAR(36),
	`payment_type` VARCHAR(36) NOT NULL,
	`status` TINYINT NOT NULL,
    `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) NOT NULL,
	`created_by` VARCHAR(36) NOT NULL,
	`raw_import_data` DOUBLE,
	`school_id` VARCHAR(36),
	`nyuukinsaki_koza` TINYINT,
	`bank_name`  VARCHAR(36),
	`bank_branch_name`  VARCHAR(36),
   `import_serial_no` int(11) NOT NULL AUTO_INCREMENT,
	PRIMARY KEY (`import_serial_no`),
	UNIQUE KEY `unique_id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;