-- jewel table_Def 20190627_PH
ALTER TABLE sms_event_instance ADD COLUMN koushu_start_datetime DATETIME NULL;
ALTER TABLE sms_event_instance ADD COLUMN koushu_end_datetime DATETIME NULL;
ALTER TABLE sms_event_instance ADD COLUMN kougi_time DECIMAL(10,2) NULL;
ALTER TABLE sms_event_instance ADD COLUMN followup_hosoku_time DECIMAL(10,2) NULL;
ALTER TABLE sms_event_instance ADD COLUMN kaijou_name VARCHAR(30) NOT NULL;
ALTER TABLE sms_event_instance ADD COLUMN kamoku_name VARCHAR(20) NOT NULL;
ALTER TABLE sms_event_instance ADD COLUMN schedule_update_datetime DATETIME NOT NULL;
ALTER TABLE sms_event_instance ADD COLUMN iraisho_nyuuryoku_start_time DATETIME NULL;
ALTER TABLE sms_event_instance ADD COLUMN iraisho_nyuuryoku_end_time DATETIME NULL;

ALTER TABLE smsevent_instances ADD COLUMN toudan_koushi_shubetsu VARCHAR(10) NOT NULL;
ALTER TABLE smsevent_instances ADD COLUMN koushu_start_datetime DATETIME NULL;
ALTER TABLE smsevent_instances ADD COLUMN koushu_end_datetime DATETIME NULL;
ALTER TABLE smsevent_instances ADD COLUMN kougi_time DECIMAL(10,2) NULL;
ALTER TABLE smsevent_instances ADD COLUMN followup_hosoku_time DECIMAL(10,2) NULL;
ALTER TABLE smsevent_instances ADD COLUMN schedule_update_datetime DATETIME NOT NULL;

-- Ivan 75862
ALTER TABLE resource DROP COLUMN shortname;
ALTER TABLE resource DROP COLUMN location;
ALTER TABLE resource DROP COLUMN capacity;
ALTER TABLE resource DROP COLUMN activation_key;