ALTER TABLE `config` ADD `do_registrations` CHAR( 3 ) DEFAULT 'yes' NOT NULL AFTER `run_domain_expire` ;
UPDATE `email_templates` SET `attr_avail` = '{{ip}}|{{whm_username}}|{{whm_password}}|{{domain_name}}|{{primary_ns}}|{{primary_ns_ip}}|{{secondary_ns}}|{{secondary_ns_ip}}|{{generate_date}}|{{clientarea_username}}|{{clientarea_password}}|{{clientarea_loginlink}}|{{installed_on_server}}|{{server_location}}' WHERE `emid` = '10' LIMIT 1 ;
ALTER TABLE `config` ADD `email_admin` VARCHAR( 255 ) NOT NULL AFTER `email_support` ;
ALTER TABLE `config` ADD `activate_support` CHAR( 3 ) DEFAULT 'yes' NOT NULL AFTER `email_support` ;