ALTER TABLE `invoice` ADD `tax_type` VARCHAR( 3 ) NOT NULL AFTER `charge_tax` ;
ALTER TABLE `config` CHANGE `domain_fee` `domain_fee` FLOAT NOT NULL;
INSERT INTO `email_templates` (`emid`, `name`, `subject`, `message`, `attr_avail`, `default_email`) VALUES (42, 'Daily Billable Service Invoice Summary Report', 'Daily Invoice Summary Report', 'Hello,\r\n\r\nBelow is a list of billable service invoices in the system that are either past due or unpaid past due.\r\n\r\n*** UnPaid and Past Due Invoices as of {{generate_date}} Seperated by Payment Gateway ***\r\n\r\n{{mail_in_summary}}{{paypal_summary}}{{paysystems_summary}}{{authorize.net_summary}}{{2checkout}}{{worldpay_summary}}', '{{generate_date}}|{{mail_in_summary}}|{{paypal_summary}}|{{paysystems_summary}}|{{authorize.net_summary}}|{{2checkout}}|{{worldpay_summary}}|', '');