
ALTER TABLE `event_contacts` ADD `application_date` DATE NOT NULL , ADD `entrance_date` DATE NOT NULL ;
ALTER TABLE `event_contacts` ADD `application_tantosha` VARCHAR( 36 ) NULL ;
ALTER TABLE `event_contacts` ADD `kibo_date1` DATE NULL;
ALTER TABLE `event_contacts` ADD `kibo_date_jikantai1` VARCHAR( 36 ) NULL ;
ALTER TABLE `event_contacts` ADD `kibo_date2` DATE NULL;
ALTER TABLE `event_contacts` ADD `kibo_date_jikantai2` VARCHAR( 36 ) NULL ;

ALTER TABLE `event_contacts` ADD `nitteihyo_date` DATE NULL DEFAULT NULL ; 


SELECT last_name, first_name, idnumber, idnumber+270000, date_entered, date_modified FROM contacts
WHERE deleted=0 AND smsgroup='student' AND date_entered > '2012-04-10 10:00:00' AND school_id='sssssss-1111'


UPDATE contacts SET idnumber=idnumber+270000 
WHERE deleted=0 AND smsgroup='student' AND date_entered > '2012-04-10 10:00:00' AND school_id='sssssss-1111'

SELECT name, contact_id, event_id, basic_fee, fee_subcategory FROM sms_fee
WHERE deleted=0

SELECT DISTINCT fee_subcategory FROM sms_fee
WHERE deleted=0

