DROP TABLE `billing_status_codes`;
ALTER TABLE `billing` ADD `rerun_date` date;
ALTER TABLE `billing` ADD `pastdue_exempt` enum('y','n');
ALTER TABLE `billing_history` CHANGE `billing_type` `billing_type` set('creditcard','invoice','einvoice','prepay','prepaycc','free');
ALTER TABLE `billing_types` CHANGE `method` `method` enum('creditcard','invoice','einvoice','prepay','prepaycc','free');
ALTER TABLE `master_services` ADD `activation_string` varchar(254);
ALTER TABLE `master_services` ADD `usage_label` varchar(32);
CREATE TABLE `options_urls` (
`id` int(11),
`urlname` varchar(25),
`fieldname` varchar(255),
`url` varchar(255));
ALTER TABLE `payment_history` CHANGE `status` `status` set('authorized','declined','pending','donotreactivate','collections','turnedoff');