ALTER TABLE sms_recurrence ADD COLUMN youbi varchar(10);
ALTER TABLE sms_recurrence ADD COLUMN start_time time;
ALTER TABLE sms_recurrence ADD COLUMN end_time time;

-- mmmaske 78797 --
ALTER TABLE sms_transaction DROP COLUMN type_id;
ALTER TABLE sms_transaction DROP COLUMN document_id;
ALTER TABLE sms_transaction DROP COLUMN commission;
ALTER TABLE sms_transaction DROP COLUMN actual;
ALTER TABLE sms_transaction DROP COLUMN account_id;
ALTER TABLE sms_transaction DROP COLUMN event_id;
ALTER TABLE sms_transaction DROP COLUMN bank_account_id;
ALTER TABLE sms_transaction DROP COLUMN combini_sakusei_id;
ALTER TABLE sms_transaction DROP COLUMN furikomibi;
ALTER TABLE sms_transaction DROP COLUMN kakuhobi;
ALTER TABLE sms_transaction DROP COLUMN combini_saihakkou_kbn;

ALTER TABLE m_kamoku CHANGE name m_kamokuname_id char(36);
ALTER TABLE m_kamoku DROP COLUMN jointkamoku;
ALTER TABLE smsevent CHANGE Kamoku_level_sitei kamoku_level_sitei char(3);


ALTER TABLE `contacts` DROP COLUMN `custom_var1`;
ALTER TABLE `contacts` DROP COLUMN `custom_var2`;
ALTER TABLE `contacts` DROP COLUMN `custom_var3`;
ALTER TABLE `contacts` DROP COLUMN `custom_var4`;
ALTER TABLE `contacts` DROP COLUMN `custom_var5`;
ALTER TABLE `contacts` DROP COLUMN `custom_var6`;
ALTER TABLE `contacts` DROP COLUMN `custom_var7`;
ALTER TABLE `contacts` DROP COLUMN `custom_var8`;
ALTER TABLE `contacts` DROP COLUMN `custom_var9`;
ALTER TABLE `contacts` DROP COLUMN `custom_var10`;
ALTER TABLE `contacts` DROP COLUMN `custom_var11`;
ALTER TABLE `contacts` DROP COLUMN `custom_var12`;
ALTER TABLE `contacts` DROP COLUMN `custom_var13`;
ALTER TABLE `contacts` DROP COLUMN `custom_var14`;
ALTER TABLE `contacts` DROP COLUMN `custom_var15`;
ALTER TABLE `contacts` DROP COLUMN `custom_var16`;
ALTER TABLE `contacts` DROP COLUMN `custom_var17`;
ALTER TABLE `contacts` DROP COLUMN `custom_var18`;
ALTER TABLE `contacts` DROP COLUMN `custom_var19`;
ALTER TABLE `contacts` DROP COLUMN `custom_var20`;

ALTER TABLE `contacts` DROP COLUMN `dm_teishi`;

ALTER TABLE `kaikei_system_data` DROP COLUMN `id`;
ALTER TABLE `kaikei_system_data` DROP COLUMN `deleted`;
ALTER TABLE `kaikei_system_data` DROP COLUMN `created_by`;
ALTER TABLE `kaikei_system_data` DROP COLUMN `date_entered`;
ALTER TABLE `kaikei_system_data` DROP COLUMN `date_modified`;
ALTER TABLE `kaikei_system_data` DROP COLUMN `modified_user_id`;

-- 80552 move sms_fee.check_cd to sms_transaction.check_cd (sms_transaction column made in vardef) --
UPDATE sms_transaction SET check_cd=(SELECT check_cd FROM sms_fee WHERE sms_fee.id=sms_transaction.fee_id);
ALTER TABLE sms_fee DROP COLUMN `check_cd`;

-- remove tables at 80928 --
DROP TABLE ryoukin_siwake;
DROP TABLE kaikei_system_data;

-- 81870 (mon) 
ALTER TABLE sms_entrance MODIFY COLUMN  card_id VARCHAR(36);

-- mmmaske 82176
ALTER TABLE sms_transaction DROP COLUMN combini_saihakkou_kbn;

-- mmmaske 82430
ALTER TABLE product DROP COLUMN `manufacturer_id`;
ALTER TABLE product DROP COLUMN `subcategory`;
ALTER TABLE product DROP COLUMN `currency_id`;
ALTER TABLE product DROP COLUMN `tax_class`;
ALTER TABLE product DROP COLUMN `tax_rate`;
ALTER TABLE product DROP COLUMN `weight`;
ALTER TABLE product DROP COLUMN `account_id`;
ALTER TABLE product DROP COLUMN `contact_id`;
ALTER TABLE product DROP COLUMN `product_type`;
ALTER TABLE product DROP COLUMN `ticket_count`;
ALTER TABLE product DROP COLUMN `ticket_valid_months`;




--jed 83851

ALTER TABLE m_shohin
  DROP  `non-target_month_8`,
  DROP  `non-target_month_1`;

-- mmmaske 84016
 ALTER TABLE `poll` CHANGE `shohin_name` `shohin_id` CHAR( 36 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL 
 
 
 -- jewel 85135
 ALTER TABLE emails_sub1 ADD INDEX  to_addrs_ids (to_addrs_ids (255));

 --Roy 85228
 ALTER TABLE sms_entrance ADD INDEX card_type (card_type);

-- Roy 85263
ALTER TABLE practice_overall_result MODIFY COLUMN prefectures1 VARCHAR(255) AFTER school_of_choice_kbn3;
ALTER TABLE practice_overall_result MODIFY COLUMN prefectures2 VARCHAR(255) AFTER prefectures1;
ALTER TABLE practice_overall_result MODIFY COLUMN prefectures3 VARCHAR(255) AFTER prefectures2;
ALTER TABLE practice_overall_result DROP COLUMN prefectures;

-- Roy 85228
ALTER TABLE contacts ADD INDEX grade (grade);


-- mmmaske 85626
ALTER TABLE bankexport_salesnos ADD COLUMN actual_hikiotoshi_date VARCHAR(4);