-- 2009-04-23
ALTER TABLE `contacts` CHANGE `incometax_rate` `incometax_rate` FLOAT NOT NULL DEFAULT '0.1';
UPDATE `contacts` SET incometax_rate = 0.0;

-- 2009-08-17

SELECT sms_fee. * 
FROM `sms_fee` 
INNER JOIN contacts ON contacts.id = sms_fee.contact_id
WHERE contacts.deleted =0
AND sms_fee.deleted =0
AND contacts.smsgroup = 'teacher'


UPDATE sms_fee, contacts SET sms_fee.end_date =  '2010-03-31'
WHERE contacts.id = sms_fee.contact_id AND contacts.deleted =0 AND sms_fee.deleted =0 AND contacts.smsgroup = 'teacher'