CREATE TABLE `be_Career` (
  `id` int(11) NOT NULL,
  `jobTitle` varchar(255) NOT NULL,
  `jobLocation` varchar(255) NOT NULL,
  `introduction` text NOT NULL,
  `content` text NOT NULL,
  `searchContent` text NOT NULL,
  `enabled` ENUM('y','n') NOT NULL DEFAULT 'y',
  `sorter` int(11) NOT NULL DEFAULT '0',
  `added` datetime NOT NULL,
  `changed` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


ALTER TABLE `be_Career`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `be_Career`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;


INSERT INTO `be_zz_DPageItemType` (`type`, `title`, `sorter`) VALUES
('Career_', 'Careers', 500);


CREATE TABLE `be_FormCareer` (
  `id` int(11) NOT NULL,
  `jobTitle` varchar(255) DEFAULT NULL,
  `jobLocation` varchar(255) DEFAULT NULL,
  `firstName` varchar(255) NOT NULL,
  `middleName` varchar(255) NOT NULL,
  `lastName` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `address2` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `state` varchar(255) NOT NULL,
  `zip` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `phone2` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `file` varchar(255) NOT NULL,
  `education` text NOT NULL,
  `workExperience` text NOT NULL,
  `added` datetime NOT NULL,
  `changed` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

ALTER TABLE `be_FormCareer`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `be_FormCareer`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  
INSERT INTO `be_zz_DPageItemType` (`type`, `title`, `sorter`) VALUES
('Form_Career_', 'Career Form', 510);


INSERT INTO `be_zz_Settings` (`name`, `idCategory`, `fieldType`, `label`, `value`, `options`, `description`, `required`, `system`, `sorter`, `added`, `changed`) VALUES
('careerFormEmailHeader', 2, 'header', '', 'Career Application Form Submission Notification', '', '', 'n', 'n', 60, '2019-11-25 00:00:00', '2019-11-25 00:00:00'),
('careerFormEmailSubject', 2, 'text', 'Subject', 'New Career Application have been submitted', '', '', 'y', 'n', 61, '2019-11-25 00:00:00', '2019-11-25 00:00:00'),
('careerFormEmailFrom', 2, 'text', 'From Email Address', 'Bell Lumber & Pole <info@blpole.com>', '', '', 'y', 'n', 62, '2019-11-25 00:00:00', '2019-11-25 00:00:00'),
('careerFormEmailTo', 2, 'emails', 'To Email Address(es) &nbsp; <span class=\"label_description\">Enter email address(es) that should receive a notification email regarding Career Application form submissions on your site</span>', '', '', 'Use commas to separate email addresses', 'n', 'n', 63, '2014-03-28 11:30:45', '2018-06-04 08:37:44'),
('careerFormEmailBody', 2, 'HtmlEditor', 'Message Body', 'New Career Application have been submitted. <br />\r\n<br />Job Position: <b>{jobTitle}</b><br />\r\nJob Location: <b>{jobLocation}</b><br />\r\n<br />\r\nLegal First Name: <b>{firstName}</b><br />\r\nMiddle Initial: <b>{middleName}</b><br />\r\nLast Name: <b>{lastName}</b><br />\r\nAddress: <b>{address}</b><br />\r\nAddress 2: <b>{address2}</b><br />\r\nCity: <b>{city}</b><br />\r\nState or Province: <b>{state}</b><br />\r\nZip: <b>{zip}</b><br />\r\nPhone:  <b>{phone}</b><br />\r\nOther Phone:  <b>{phone2}</b><br />\r\nEmail Address:  <b>{email}</b><br />\r\nResume:  <b><a href=\"{file}\">download</a></b><br />\r\nEducation:<br />\r\n<b>{education}</b><br />\r\nWork Experience:<br />\r\n<b>{workExperience}</b><br />\r\n<br />\r\n<p>Click <a href=\"{link}\">here</a> to view details.</p>', '', 'Constants: {jobTitle} {jobLocation} {firstName} {middleName} {lastName} {address} {address2} {city} {state} {zip} {phone} {phone2} {email} {file} {education} {workExperience} {link}', 'y', 'n', 64, '2019-11-25 00:00:00', '2019-11-25 00:00:00');

INSERT INTO `be_zz_SettingsOptions` (`name`, `variable`, `value`, `type`) VALUES
('careerFormEmailBody', 'scriptOptions[Config][EnterMode]', 'br', 'string'),
('careerFormEmailBody', 'height', '200', 'int'),
('careerFormEmailBody', 'toolbarSet', 'Basic', 'string'),
('careerFormEmailBody', 'mode', 'view', 'string');


INSERT INTO `be_zz_Settings` (`name`, `idCategory`, `fieldType`, `label`, `value`, `options`, `description`, `required`, `system`, `sorter`, `added`, `changed`) VALUES
('careerFormUserEmailHeader', 2, 'header', '', 'Career Application Form Submission Notification (User Notification)', '', '', 'n', 'n', 70, '2019-11-25 00:00:00', '2019-11-25 00:00:00'),
('careerFormUserEmailSubject', 2, 'text', 'Subject', 'Your Career Application have been submitted', '', '', 'y', 'n', 71, '2019-11-25 00:00:00', '2019-11-25 00:00:00'),
('careerFormUserEmailFrom', 2, 'text', 'From Email Address', 'Bell Lumber & Pole <info@blpole.com>', '', '', 'y', 'n', 72, '2019-11-25 00:00:00', '2019-11-25 00:00:00'),
('careerFormUserEmailBody', 2, 'HtmlEditor', 'Message Body', 'Your Career Application have been submitted successfully. <br />\r\n<br />Job Position: <b>{jobTitle}</b><br />\r\nJob Location: <b>{jobLocation}</b><br />\r\n<br />\r\nLegal First Name: <b>{firstName}</b><br />\r\nMiddle Initial: <b>{middleName}</b><br />\r\nLast Name: <b>{lastName}</b><br />\r\nAddress: <b>{address}</b><br />\r\nAddress 2: <b>{address2}</b><br />\r\nCity: <b>{city}</b><br />\r\nState or Province: <b>{state}</b><br />\r\nZip: <b>{zip}</b><br />\r\nPhone:  <b>{phone}</b><br />\r\nOther Phone:  <b>{phone2}</b><br />\r\nEmail Address:  <b>{email}</b><br />\r\nResume:  <b><a href=\"{file}\">download</a></b><br />\r\nEducation:<br />\r\n<b>{education}</b><br />\r\nWork Experience:<br />\r\n<b>{workExperience}</b><br />\r\n<br />\r\n', '', 'Constants: {jobTitle} {jobLocation} {firstName} {middleName} {lastName} {address} {address2} {city} {state} {zip} {phone} {phone2} {email} {file} {education} {workExperience}', 'y', 'n', 73, '2019-11-25 00:00:00', '2019-11-25 00:00:00');

INSERT INTO `be_zz_SettingsOptions` (`name`, `variable`, `value`, `type`) VALUES
('careerFormUserEmailBody', 'scriptOptions[Config][EnterMode]', 'br', 'string'),
('careerFormUserEmailBody', 'height', '200', 'int'),
('careerFormUserEmailBody', 'toolbarSet', 'Basic', 'string'),
('careerFormUserEmailBody', 'mode', 'view', 'string');