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`;