-- 2016-02-10 special read-only user for Digital Stage 

ds_user		J827bHWNYyqQu9nM

-- 販売前
GRANT SELECT ON  `itojuku_test2`.`koza_code_master` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test2`.`master_kanri` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test2`.`koza` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test2`.`curriculum` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test2`.`curriculum_hassocode` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test2`.`hassobi` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test2`.`hassocode` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test2`.`hassocode_hassobi` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test2`.`hassocode_buppin` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test2`.`event_koza` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test2`.`smsevent` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test2`.`sms_event_instance` TO  'ds_user'@'%';

GRANT SELECT (
`id`, `deleted`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, 
`buppin_name`, `buppin_category`, `buppin_code`, 
`shikenshu`, `kaikonen`, `buppin_code_7`, `seishikimeisho`, `shuppansha`, 
`hanbai_tanka`, `teika`, `fair_tanka`, `shainwari_tanka`, `version_up_tanka`, 
`rejiyou_barcode`, `idouheikin_tanka`, `haiki_umu`, `if_code_buppin`, `shohin_kobestu_number_buppin`, `buppin_form`
) ON  `itojuku_test2`.`buppin` TO  'ds_user'@'%';

GRANT SELECT (
`id`, `school_id`, `name`, `category`
) ON  `itojuku_test2`.`resource` TO  'ds_user'@'%';

GRANT SELECT (
`id_sub1`, `tel_c`, `address_c`, `fax_c`, `school_code`, `eshop_code`, `eshop_jukoukeitai_01d`
) ON  `itojuku_test2`.`resource_sub1` TO  'ds_user'@'%';

-- 販売後

GRANT SELECT ON  `itojuku_test2`.`koza_contacts` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test2`.`event_contacts` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test2`.`hasso_contacts` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test2`.`hassocode_contacts` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test2`.`smsevent_instances` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test2`.`sms_event_instance_sub` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test2`.`sms_memo` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test2`.`shukka_kobetsu` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test2`.`shiken` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test2`.`shiken_student` TO  'ds_user'@'%';

GRANT SELECT (
`id`, `deleted`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, 
`alt_address_city`, `alt_address_postalcode`, `alt_address_state`, `alt_address_street`, 
`birthdate`, `email_opt_out`, `email1`, `email2`, 
`first_name`, `first_name_furigana`, 
`gender`, `grade`, `houka_graduate_school`, 
`idnumber`, `smsgroup`, `contact_status`, 
`jikanshitei`, 
`kiseisaki_address_city`, `kiseisaki_address_postalcode`, `kiseisaki_address_state`, `kiseisaki_address_street`, 
`kiseisaki_date_end`, `kiseisaki_date_entered`, `kiseisaki_phone`, `kiseisaki_phone_cleaned`, 
`kishu_mishu`, 
`kyokudome_address_city`, `kyokudome_address_kana`, `kyokudome_address_postalcode`, `kyokudome_address_state`, `kyokudome_address_street`, 
`last_name`, `last_name_furigana`, 
`phone_home`, `phone_home_cleaned`, 
`phone_mobile`, `phone_mobile_cleaned`, 
`primary_address_city`, `primary_address_postalcode`, `primary_address_state`, `primary_address_street`, 
`university`, 
`urgency_name`, `urgency_phone`, `urgency_phone_cleaned`
) ON  `itojuku_test2`.`contacts` TO  'ds_user'@'%';

GRANT SELECT (
`id`, `school_id`, `name`, 
`event_id`, `contact_id`, `type_id`, `deleted`, 
`date_entered`, `date_modified`, `modified_user_id`, `created_by`, 
`sell_date`, `basic_fee`, `description`, `applied_contact`, 
`salesno`, `start_date`, `product_id`, 
`nyukin_zumi`, `uriagekubun`, `suryo`, 
`hasso_from_soko`, `koza_id`, `buppin_id`, 
`uriage_keitai`, `buppin_tanka`, `waribiki_category`, `buppin_category`, 
`schedule_sakusei_flg`, `kaiyaku_flg`
) ON  `itojuku_test2`.`sms_fee` TO  'ds_user'@'%';

GRANT SELECT (
`id`, `fee_id`, `type_id`, `deleted`, 
`date_entered`, `date_modified`, `modified_user_id`, `created_by`, 
`sell_date`, `due_date`, `t_date`, 
`in_amount`, `actual_in_amount`, 
`contact_id`, `event_id`, `payment_type`, `description`, 
`salesno`, `fee_name`, `school_id`, `koza_id`, `buppin_id`, 
`nyuukinsaki_kouza`, `nyuukinsaki_card_credit`, `nyuukinsaki_shori_number`, 
`seikyou_dairiten_id`, `dairiten_uketsukebi`, `hanbaikeiro`, 
`waribiki_category`, `buppin_category`, `uriagekubun`, `debit_card`
) ON  `itojuku_test2`.`sms_transaction` TO  'ds_user'@'%';



-- 販売前
GRANT SELECT ON  `itojuku_test`.`koza_code_master` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test`.`master_kanri` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test`.`koza` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test`.`curriculum` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test`.`curriculum_hassocode` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test`.`hassobi` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test`.`hassocode` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test`.`hassocode_hassobi` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test`.`hassocode_buppin` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test`.`event_koza` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test`.`smsevent` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test`.`sms_event_instance` TO  'ds_user'@'%';

GRANT SELECT (
`id`, `deleted`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, 
`buppin_name`, `buppin_category`, `buppin_code`, 
`shikenshu`, `kaikonen`, `buppin_code_7`, `seishikimeisho`, `shuppansha`, 
`hanbai_tanka`, `teika`, `fair_tanka`, `shainwari_tanka`, `version_up_tanka`, 
`rejiyou_barcode`, `idouheikin_tanka`, `haiki_umu`, `if_code_buppin`, `shohin_kobestu_number_buppin`, `buppin_form`
) ON  `itojuku_test`.`buppin` TO  'ds_user'@'%';

GRANT SELECT (
`id`, `school_id`, `name`, `category`
) ON  `itojuku_test`.`resource` TO  'ds_user'@'%';

GRANT SELECT (
`id_sub1`, `tel_c`, `address_c`, `fax_c`, `school_code`, `eshop_code`, `eshop_jukoukeitai_01d`
) ON  `itojuku_test`.`resource_sub1` TO  'ds_user'@'%';

-- 販売後

GRANT SELECT ON  `itojuku_test`.`koza_contacts` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test`.`event_contacts` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test`.`hasso_contacts` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test`.`hassocode_contacts` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test`.`smsevent_instances` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test`.`sms_event_instance_sub` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test`.`sms_memo` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test`.`shukka_kobetsu` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test`.`shiken` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test`.`shiken_student` TO  'ds_user'@'%';

GRANT SELECT (
`id`, `deleted`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, 
`alt_address_city`, `alt_address_postalcode`, `alt_address_state`, `alt_address_street`, 
`birthdate`, `email_opt_out`, `email1`, `email2`, 
`first_name`, `first_name_furigana`, 
`gender`, `grade`, `houka_graduate_school`, 
`idnumber`, `smsgroup`, `contact_status`,
`jikanshitei`, 
`kiseisaki_address_city`, `kiseisaki_address_postalcode`, `kiseisaki_address_state`, `kiseisaki_address_street`, 
`kiseisaki_date_end`, `kiseisaki_date_entered`, `kiseisaki_phone`, `kiseisaki_phone_cleaned`, 
`kishu_mishu`, 
`kyokudome_address_city`, `kyokudome_address_kana`, `kyokudome_address_postalcode`, `kyokudome_address_state`, `kyokudome_address_street`, 
`last_name`, `last_name_furigana`, 
`phone_home`, `phone_home_cleaned`, 
`phone_mobile`, `phone_mobile_cleaned`, 
`primary_address_city`, `primary_address_postalcode`, `primary_address_state`, `primary_address_street`, 
`university`, 
`urgency_name`, `urgency_phone`, `urgency_phone_cleaned`
) ON  `itojuku_test`.`contacts` TO  'ds_user'@'%';

GRANT SELECT (
`id`, `school_id`, `name`, 
`event_id`, `contact_id`, `type_id`, `deleted`, 
`date_entered`, `date_modified`, `modified_user_id`, `created_by`, 
`sell_date`, `basic_fee`, `description`, `applied_contact`, 
`salesno`, `start_date`, `product_id`, 
`nyukin_zumi`, `uriagekubun`, `suryo`, 
`hasso_from_soko`, `koza_id`, `buppin_id`, 
`uriage_keitai`, `buppin_tanka`, `waribiki_category`, `buppin_category`, 
`schedule_sakusei_flg`, `kaiyaku_flg`
) ON  `itojuku_test`.`sms_fee` TO  'ds_user'@'%';

GRANT SELECT (
`id`, `fee_id`, `type_id`, `deleted`, 
`date_entered`, `date_modified`, `modified_user_id`, `created_by`, 
`sell_date`, `due_date`, `t_date`, 
`in_amount`, `actual_in_amount`, 
`contact_id`, `event_id`, `payment_type`, `description`, 
`salesno`, `fee_name`, `school_id`, `koza_id`, `buppin_id`, 
`nyuukinsaki_kouza`, `nyuukinsaki_card_credit`, `nyuukinsaki_shori_number`, 
`seikyou_dairiten_id`, `dairiten_uketsukebi`, `hanbaikeiro`, 
`waribiki_category`, `buppin_category`, `uriagekubun`, `debit_card`
) ON  `itojuku_test`.`sms_transaction` TO  'ds_user'@'%';

-- 2016-08-08
GRANT SELECT (
`contact_status`
) ON  `itojuku_test2`.`contacts` TO  'ds_user'@'%';
GRANT SELECT (
`contact_status`
) ON  `itojuku_test`.`contacts` TO  'ds_user'@'%';

GRANT SELECT ON  `itojuku_test2`.`sms_event_instance_sub` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test`.`sms_event_instance_sub` TO  'ds_user'@'%';

-- 2016-08-11
GRANT SELECT ON  `itojuku_test`.`shiken` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test`.`shiken_student` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test2`.`shiken` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test2`.`shiken_student` TO  'ds_user'@'%';

-- 2016-08-26 本番 priviledge 

GRANT SELECT ON  `itojuku`.`koza_code_master` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku`.`master_kanri` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku`.`koza` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku`.`curriculum` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku`.`curriculum_hassocode` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku`.`hassobi` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku`.`hassocode` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku`.`hassocode_hassobi` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku`.`hassocode_buppin` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku`.`event_koza` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku`.`smsevent` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku`.`sms_event_instance` TO  'ds_user'@'%';

GRANT SELECT (
`id`, `deleted`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, 
`buppin_name`, `buppin_category`, `buppin_code`, 
`shikenshu`, `kaikonen`, `buppin_code_7`, `seishikimeisho`, `shuppansha`, 
`hanbai_tanka`, `teika`, `fair_tanka`, `shainwari_tanka`, `version_up_tanka`, 
`rejiyou_barcode`, `idouheikin_tanka`, `haiki_umu`, `if_code_buppin`, `shohin_kobestu_number_buppin`, `buppin_form`
) ON  `itojuku`.`buppin` TO  'ds_user'@'%';

GRANT SELECT (
`id`, `school_id`, `name`, `category`
) ON  `itojuku`.`resource` TO  'ds_user'@'%';

GRANT SELECT (
`id_sub1`, `tel_c`, `address_c`, `fax_c`, `school_code`, `eshop_code`, `eshop_jukoukeitai_01d`
) ON  `itojuku`.`resource_sub1` TO  'ds_user'@'%';

-- 販売後

GRANT SELECT ON  `itojuku`.`koza_contacts` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku`.`event_contacts` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku`.`hasso_contacts` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku`.`hassocode_contacts` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku`.`smsevent_instances` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku`.`sms_event_instance_sub` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku`.`sms_memo` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku`.`shukka_kobetsu` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku`.`shiken` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku`.`shiken_student` TO  'ds_user'@'%';

GRANT SELECT (
`id`, `deleted`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, 
`alt_address_city`, `alt_address_postalcode`, `alt_address_state`, `alt_address_street`, 
`birthdate`, `email_opt_out`, `email1`, `email2`, 
`first_name`, `first_name_furigana`, 
`gender`, `grade`, `houka_graduate_school`, 
`idnumber`, `smsgroup`, `contact_status`, 
`jikanshitei`, 
`kiseisaki_address_city`, `kiseisaki_address_postalcode`, `kiseisaki_address_state`, `kiseisaki_address_street`, 
`kiseisaki_date_end`, `kiseisaki_date_entered`, `kiseisaki_phone`, `kiseisaki_phone_cleaned`, 
`kishu_mishu`, 
`kyokudome_address_city`, `kyokudome_address_kana`, `kyokudome_address_postalcode`, `kyokudome_address_state`, `kyokudome_address_street`, 
`last_name`, `last_name_furigana`, 
`phone_home`, `phone_home_cleaned`, 
`phone_mobile`, `phone_mobile_cleaned`, 
`primary_address_city`, `primary_address_postalcode`, `primary_address_state`, `primary_address_street`, 
`university`, 
`urgency_name`, `urgency_phone`, `urgency_phone_cleaned`
) ON  `itojuku`.`contacts` TO  'ds_user'@'%';

GRANT SELECT (
`id`, `school_id`, `name`, 
`event_id`, `contact_id`, `type_id`, `deleted`, 
`date_entered`, `date_modified`, `modified_user_id`, `created_by`, 
`sell_date`, `basic_fee`, `description`, `applied_contact`, 
`salesno`, `start_date`, `product_id`, 
`nyukin_zumi`, `uriagekubun`, `suryo`, 
`hasso_from_soko`, `koza_id`, `buppin_id`, 
`uriage_keitai`, `buppin_tanka`, `waribiki_category`, `buppin_category`, 
`schedule_sakusei_flg`, `kaiyaku_flg`
) ON  `itojuku`.`sms_fee` TO  'ds_user'@'%';

GRANT SELECT (
`id`, `fee_id`, `type_id`, `deleted`, 
`date_entered`, `date_modified`, `modified_user_id`, `created_by`, 
`sell_date`, `due_date`, `t_date`, 
`in_amount`, `actual_in_amount`, 
`contact_id`, `event_id`, `payment_type`, `description`, 
`salesno`, `fee_name`, `school_id`, `koza_id`, `buppin_id`, 
`nyuukinsaki_kouza`, `nyuukinsaki_card_credit`, `nyuukinsaki_shori_number`, 
`seikyou_dairiten_id`, `dairiten_uketsukebi`, `hanbaikeiro`, 
`waribiki_category`, `buppin_category`, `uriagekubun`, `debit_card`
) ON  `itojuku`.`sms_transaction` TO  'ds_user'@'%';


-- 2016-10-13 training priviledge 

GRANT SELECT ON  `itojuku_training`.`koza_code_master` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_training`.`master_kanri` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_training`.`koza` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_training`.`curriculum` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_training`.`curriculum_hassocode` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_training`.`hassobi` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_training`.`hassocode` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_training`.`hassocode_hassobi` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_training`.`hassocode_buppin` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_training`.`event_koza` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_training`.`smsevent` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_training`.`sms_event_instance` TO  'ds_user'@'%';

GRANT SELECT (
`id`, `deleted`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, 
`buppin_name`, `buppin_category`, `buppin_code`, 
`shikenshu`, `kaikonen`, `buppin_code_7`, `seishikimeisho`, `shuppansha`, 
`hanbai_tanka`, `teika`, `fair_tanka`, `shainwari_tanka`, `version_up_tanka`, 
`rejiyou_barcode`, `idouheikin_tanka`, `haiki_umu`, `if_code_buppin`, `shohin_kobestu_number_buppin`, `buppin_form`
) ON  `itojuku_training`.`buppin` TO  'ds_user'@'%';

GRANT SELECT (
`id`, `school_id`, `name`, `category`
) ON  `itojuku_training`.`resource` TO  'ds_user'@'%';

GRANT SELECT (
`id_sub1`, `tel_c`, `address_c`, `fax_c`, `school_code`, `eshop_code`, `eshop_jukoukeitai_01d`
) ON  `itojuku_training`.`resource_sub1` TO  'ds_user'@'%';

-- 販売後

GRANT SELECT ON  `itojuku_training`.`koza_contacts` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_training`.`event_contacts` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_training`.`hasso_contacts` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_training`.`hassocode_contacts` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_training`.`smsevent_instances` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_training`.`sms_event_instance_sub` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_training`.`sms_memo` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_training`.`shukka_kobetsu` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_training`.`shiken` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_training`.`shiken_student` TO  'ds_user'@'%';

GRANT SELECT (
`id`, `deleted`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, 
`alt_address_city`, `alt_address_postalcode`, `alt_address_state`, `alt_address_street`, 
`birthdate`, `email_opt_out`, `email1`, `email2`, 
`first_name`, `first_name_furigana`, 
`gender`, `grade`, `houka_graduate_school`, 
`idnumber`, `smsgroup`, `contact_status`, 
`jikanshitei`, 
`kiseisaki_address_city`, `kiseisaki_address_postalcode`, `kiseisaki_address_state`, `kiseisaki_address_street`, 
`kiseisaki_date_end`, `kiseisaki_date_entered`, `kiseisaki_phone`, `kiseisaki_phone_cleaned`, 
`kishu_mishu`, 
`kyokudome_address_city`, `kyokudome_address_kana`, `kyokudome_address_postalcode`, `kyokudome_address_state`, `kyokudome_address_street`, 
`last_name`, `last_name_furigana`, 
`phone_home`, `phone_home_cleaned`, 
`phone_mobile`, `phone_mobile_cleaned`, 
`primary_address_city`, `primary_address_postalcode`, `primary_address_state`, `primary_address_street`, 
`university`, 
`urgency_name`, `urgency_phone`, `urgency_phone_cleaned`
) ON  `itojuku_training`.`contacts` TO  'ds_user'@'%';

GRANT SELECT (
`id`, `school_id`, `name`, 
`event_id`, `contact_id`, `type_id`, `deleted`, 
`date_entered`, `date_modified`, `modified_user_id`, `created_by`, 
`sell_date`, `basic_fee`, `description`, `applied_contact`, 
`salesno`, `start_date`, `product_id`, 
`nyukin_zumi`, `uriagekubun`, `suryo`, 
`hasso_from_soko`, `koza_id`, `buppin_id`, 
`uriage_keitai`, `buppin_tanka`, `waribiki_category`, `buppin_category`, 
`schedule_sakusei_flg`, `kaiyaku_flg`
) ON  `itojuku_training`.`sms_fee` TO  'ds_user'@'%';

GRANT SELECT (
`id`, `fee_id`, `type_id`, `deleted`, 
`date_entered`, `date_modified`, `modified_user_id`, `created_by`, 
`sell_date`, `due_date`, `t_date`, 
`in_amount`, `actual_in_amount`, 
`contact_id`, `event_id`, `payment_type`, `description`, 
`salesno`, `fee_name`, `school_id`, `koza_id`, `buppin_id`, 
`nyuukinsaki_kouza`, `nyuukinsaki_card_credit`, `nyuukinsaki_shori_number`, 
`seikyou_dairiten_id`, `dairiten_uketsukebi`, `hanbaikeiro`, 
`waribiki_category`, `buppin_category`, `uriagekubun`, `debit_card`
) ON  `itojuku_training`.`sms_transaction` TO  'ds_user'@'%';


-- 20161027 shimoju 
GRANT SELECT (
work_school,kyokudome,work_school_etc,name_work,address_work,phone_work,phone_work_cleaned,email_work,obog_members,primary_address_kana,
kiseisaki_address_kana,graduate_school,vocational,gakubu,gakka,hougakukei_circle,circle_title,highschool
) ON  `itojuku_training`.`contacts` TO  'ds_user'@'%';


-- 2017-03-07

GRANT SELECT ON  `itojuku_test`.`shiken_curriculum` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test2`.`shiken_curriculum` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_training`.`shiken_curriculum` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku`.`shiken_curriculum` TO  'ds_user'@'%';


-- 2017-03-31 shimoju

GRANT SELECT ON  `itojuku_test`.`mk_calculation` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test2`.`mk_calculation` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_training`.`mk_calculation` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku`.`mk_calculation` TO  'ds_user'@'%';

-- 2017-03-31 shimoju
GRANT SELECT ON  `itojuku_training`.`marksheet` TO  'ds_user'@'%';

-- 2017-04-25 shimoju
GRANT SELECT (id,actual_event_start,deleted) ON  itojuku_test.sms_recurrence TO  'ds_user'@'%';
GRANT SELECT (id,actual_event_start,deleted) ON  itojuku_test2.sms_recurrence TO  'ds_user'@'%';
GRANT SELECT (id,actual_event_start,deleted) ON  itojuku_training.sms_recurrence TO  'ds_user'@'%';
GRANT SELECT (id,actual_event_start,deleted) ON  itojuku.sms_recurrence TO  'ds_user'@'%';


-- 2017-05-15 shimoju
GRANT SELECT ON  `itojuku_test`.`marksheet` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test2`.`marksheet` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku`.`marksheet` TO  'ds_user'@'%';

-- 2017-05-15 shimoju
GRANT SELECT ON  `itojuku_test`.`wt_calculation` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_test2`.`wt_calculation` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_training`.`wt_calculation` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku_training2`.`wt_calculation` TO  'ds_user'@'%';
GRANT SELECT ON  `itojuku`.`wt_calculation` TO  'ds_user'@'%';





