--2013-11-14 kato sampledb_itojuku反映済
INSERT INTO `config` (`category`, `name`, `value`) VALUES ('student_idnumber', 'student', '0');
INSERT INTO `config` (`category`, `name`, `value`) VALUES ('koza', 'shohin_kobestu_number', '10000');
INSERT INTO `config` (`category`, `name`, `value`) VALUES ('koza', 'if_code', '1000000000000');
INSERT INTO `config` (`category`, `name`, `value`) VALUES ('idnumber', 'shiryo', '0');
INSERT INTO `config` (`category`, `name`, `value`) VALUES ('idnumber', 'fb', '0');
INSERT INTO `config` (`category`, `name`, `value`) VALUES ('idnumber', 'event', '0');
INSERT INTO `config` (`category`, `name`, `value`) VALUES ('buppin', 'shohin_kobestu_number', '70000');
INSERT INTO `config` (`category`, `name`, `value`) VALUES ('buppin', 'if_code', '2000000000000');
INSERT INTO `config` (`category`, `name`, `value`) VALUES ('hacchu', 'hacchu_number', '0001');
INSERT INTO `config` (`category`, `name`, `value`) VALUES ('hassocode', 'shukka_kobetsu', '1');

ALTER TABLE resource_sub1 ADD COLUMN school_code varchar(3) DEFAULT NULL;
ALTER TABLE resource_sub1 ADD COLUMN eshop_code varchar(5) DEFAULT NULL;

-- Naeem
CREATE TABLE IF NOT EXISTS `master_kanri` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `deleted` tinyint(1) NOT NULL DEFAULT '0',
 `date_entered` datetime NOT NULL,
 `date_modified` datetime NOT NULL,
 `modified_user_id` char(36) NOT NULL,
 `created_by` char(36) NOT NULL,
 `inactive` tinyint(1) DEFAULT '0',
 `display_order` int(11) DEFAULT NULL,
 `master_name` varchar(40) DEFAULT NULL,
 `master_group` varchar(40) DEFAULT NULL,
 `school_id` char(36) DEFAULT NULL,
 `master_category1` varchar(40) DEFAULT NULL,
 `master_category2` varchar(40) DEFAULT NULL,
 `field1` varchar(40) DEFAULT NULL,
 `field2` varchar(40) DEFAULT NULL,
 `field3` varchar(40) DEFAULT NULL,
 `field4` varchar(40) DEFAULT NULL,
 `field5` varchar(40) DEFAULT NULL,
 `field6` varchar(40) DEFAULT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB  
 DEFAULT CHARSET=utf8 AUTO_INCREMENT=2920 ;

--2013-11-14 kato sampledb_itojukuに未反映
-- shimoju
 -- DB_Kanriを実行してmanual_contactを再構築した後、以下のカラムを追加
ALTER TABLE `manual_contact` ADD `obog1` TINYINT NULL;
ALTER TABLE `manual_contact` ADD `obog2` TINYINT NULL;
ALTER TABLE `manual_contact` ADD `obog3` TINYINT NULL;
ALTER TABLE `manual_contact` ADD `obog4` TINYINT NULL;
ALTER TABLE `manual_contact` ADD `rel_kobaimikomi` VARCHAR( 5 ) NULL;
ALTER TABLE `manual_contact` ADD `rel_school_id` VARCHAR( 36 ) NULL;
ALTER TABLE `manual_contact` ADD `rel_description` TEXT NULL;
ALTER TABLE `manual_contact` ADD `spiral_number` VARCHAR( 128 ) NULL;

ALTER TABLE `manual_contact` ADD `raw_import_data` TEXT NULL; 
ALTER TABLE `manual_contact` ADD `import_serial_no` int(11) NULL;
ALTER TABLE `manual_contact` ADD `import_source` VARCHAR( 40 ) NULL;
ALTER TABLE `manual_contact` ADD `status` TINYINT( 1 ) NOT NULL DEFAULT '0';

--2013-11-15 kato 
INSERT INTO `config` (`category`, `name`, `value`) VALUES ('koza', 'iclassNo', '0000000');