ALTER TABLE `{$wpdb->prefix}wpjb_company` ADD `company_slogan` VARCHAR(250) NOT NULL DEFAULT '' AFTER `company_name` ; --

INSERT INTO `{$wpdb->prefix}wpjb_mail` (`id`, `name`, `is_active`, `sent_to`, `format`, `mail_title`, `mail_body_text`, `mail_body_html`, `mail_from`, `mail_from_name`, `mail_bcc`) VALUES
(NULL, 'notify_admin_new_employer', 1, 1, 'text/plain', 'New Employer: {$company.company_name}', 'Hi there!\r\n\r\nThis is an automated email letting you know a new company {$company.company_name} has been registered on the job board.\r\n\r\nView the company profile: \r\n{$company.url}\r\n\r\nSee this listing as an administrator here: \r\n{$company.admin_url}\r\n\r\nBest regards,\r\nJob Board Support', '', 'test@example.com', 'Admin', ''),
(NULL, 'notify_admin_new_candidate', 1, 1, 'text/plain', 'New Candidate: {$resume.full_name}', 'Hi there!\r\n\r\nThis is an automated email letting you {$resume.full_name} registered on the job board.\r\n\r\nView the company profile: \r\n{$resume.url}\r\n\r\nSee this listing as an administrator here: \r\n{$resume.admin_url}\r\n\r\nBest regards,\r\nJob Board Support', '', 'test@example.com', 'Admin', ''),
(NULL, 'notify_candidate_message', 1, 3, 'text/plain', 'Message From {$company.company_name}', '{$contact_form.message}\r\n\r\n--------------------\r\n{$contact_form.fullname} / {$contact_form.email}', '', 'test@example.com', 'Admin', '') ; --