-- 2013-09-19 shimoju
INSERT INTO `config` (`category`, `name`, `value`) VALUES ('student_idnumber', 'student', '0');

-- 2013-09-20 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-09-24 kato null制約解除
ALTER TABLE `smsevent` CHANGE `assigned_user_id` `assigned_user_id` CHAR( 36 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL ;

--2013-09-24 kato school_code追加
ALTER TABLE resource_sub1 ADD COLUMN school_code varchar(3) DEFAULT NULL;

-- 2013-09-25 shimoju 学校マスター作成 superuserで実行すること
INSERT INTO  gakkomaster
SELECT id, name, category, subcategory, state, city, NULL , NULL , '0', now( ) , now( ) , '1', '1'
FROM gakkoglobal.gakkomaster;

-- 2013-09-26 kato
INSERT INTO `config` (`category`, `name`, `value`) VALUES ('koza', 'shohin_kobestu_number', '10000');
INSERT INTO `config` (`category`, `name`, `value`) VALUES ('koza', 'if_code', '1000000000000');

-- 2013-09-20 Naeem
CREATE TABLE IF NOT EXISTS `buppin_curriculum_class` (
 `id` int(11) NOT NULL ,
 `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',
 `buppin_code` varchar(100) DEFAULT NULL,
 `curriculum_id` char(36) DEFAULT NULL,
 `event_id` char(36) DEFAULT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB  
 DEFAULT CHARSET=utf8 ;
 
 -- 2013-10-03 shimoju
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');

--2013-10-08 kato 仕様変更による削除
ALTER TABLE `buppin_curriculum_class` DROP `buppin_code` 

--2013-10-15 kato 仕様変更による削除
ALTER TABLE `sms_transaction` DROP `seikyou_dairiten_name` 

-- 2013-10-17 shimoju
DROP TABLE `manual_contact`;
 -- 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-10-23 kato 仕様変更による削除
ALTER TABLE `hassobi` DROP `instance_id` 

--2013-10-24 kato 個別出荷の発送コード
INSERT INTO `config` (`category`, `name`, `value`) VALUES ('hassocode', 'shukka_kobetsu', '1');

--2013-10-28 kato 仕様変更による削除
DROP TABLE `buppin_curriculum_class`;
ALTER TABLE `hassobi` DROP `instance_id` ;
ALTER TABLE `hassocode` DROP `curriculum_id` ;
ALTER TABLE `hassocode` DROP `buppin_id` ;
ALTER TABLE `hassocode` DROP `hassobi_id` ;
ALTER TABLE `hassocode_hassobi` DROP `event_id` ;
ALTER TABLE `hasso_contacts` DROP `contact_id` ;
ALTER TABLE `hasso_contacts` DROP `hassocode_id` ;

--2013-10-29 shimoju eshop_code追加
ALTER TABLE resource_sub1 ADD COLUMN eshop_code varchar(5) DEFAULT NULL;

-- 2013-10-31 kato
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');