#JED 83492
ALTER TABLE contacts
DROP COLUMN validity_import_date,
DROP COLUMN validity_status;
ALTER TABLE event_shimacourse_contacts
DROP COLUMN kyuukaki_start_date,
DROP COLUMN kyuukaki_end_date;

ALTER TABLE resource DROP COLUMN code;
 ALTER TABLE contacts DROP COLUMN area_id;
 ALTER TABLE contacts_audit ADD COLUMN date_modified DATE;
 ALTER TABLE contacts_audit ADD COLUMN modified_user_id VARCHAR(36);

ALTER TABLE contacts DROP COLUMN area_id;
 ALTER TABLE contacts_audit ADD COLUMN date_modified DATE;
 ALTER TABLE contacts_audit MODIFY COLUMN modified_user_id CHAR(36); 
 ALTER TABLE contacts_audit MODIFY COLUMN created_by CHAR(36)
 ALTER TABLE contacts_sms_memo ADD COLUMN date_entered DATE;
 ALTER TABLE contacts_sms_memo ADD COLUMN created_by CHAR(36);
 ALTER TABLE contacts_sms_memo ADD COLUMN modified_user_id CHAR(36);
 ALTER TABLE smsevent_instances ADD COLUMN date_entered DATE;
 ALTER TABLE smsevent_instances ADD COLUMN created_by CHAR(36);
 ALTER TABLE smsevent_instances ADD COLUMN modified_user_id CHAR(36);
 ALTER TABLE smsevent DROP COLUMN area_id;
ALTER TABLE shimacourse DROP COLUMN event_id;
ALTER TABLE sms_event_instance ADD COLUMN date_created DATE;
ALTER TABLE sms_event_instance ADD COLUMN created_by CHAR(36);
ALTER TABLE sms_event_instance ADD COLUMN modified_user_id CHAR(36);
ALTER TABLE sms_memo MODIFY COLUMN  modified_user_id CHAR(36);
ALTER TABLE emailman ADD COLUMN created_by VARCHAR(36);
ALTER TABLE emailman MODIFY COLUMN modified_user_id CHAR(36);
ALTER TABLE sms_fee DROP COLUMN claim_month;
ALTER TABLE sharei_hibetsu MODIFY COLUMN teacher_id CHAR(36);


ALTER TABLE event_resource ADD COLUMN date_created DATETIME;
ALTER TABLE event_resource ADD COLUMN modified_user_id CHAR(36);
ALTER TABLE event_resource ADD COLUMN created_by CHAR(36);

ALTER TABLE prospect_lists_prospects ADD COLUMN date_entered DATETIME;
ALTER TABLE prospect_lists_prospects ADD COLUMN modified_user_id CHAR(36);
ALTER TABLE prospect_lists_prospects ADD COLUMN created_by CHAR(36);

ALTER TABLE sms_memo_templates MODIFY COLUMN modified_user_id CHAR(36);
ALTER TABLE sms_memo_templates MODIFY COLUMN created_by CHAR(36);

ALTER TABLE prospect_lists MODIFY COLUMN modified_user_id CHAR(36);
ALTER TABLE prospect_lists MODIFY COLUMN created_by CHAR(36);

ALTER TABLE emailman MODIFY COLUMN modified_user_id CHAR(36);
ALTER TABLE emailman ADD COLUMN created_by CHAR(36);