CREATE TABLE IF NOT EXISTS `be_FormGrandOpening` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `company` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `people` int(11) NOT NULL,
  `added` datetime NOT NULL,
  `changed` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

INSERT INTO `prj_bellpole_com`.`be_zz_DPageItemType` (
`id` ,
`type` ,
`title` ,
`sorter`
)
VALUES (NULL , 'Form_GrandOpening_', 'Grand Opening Form', '320');

INSERT INTO `be_zz_Settings` (`name`, `idCategory`, `fieldType`, `label`, `value`, `options`, `description`, `required`, `system`, `sorter`, `added`, `changed`) VALUES
('grandOpeningFormEmailHeader', 2, 'header', '', 'Grand Opening Form Submission Notification', '', '', 'n', 'n', 50, '2014-03-28 11:22:59', '2014-03-28 11:22:59'),
('grandOpeningFormEmailSubject', 2, 'text', 'Subject', 'New Grand Opening Info have been submitted', '', '', 'y', 'n', 51, '2014-03-28 11:28:19', '2012-07-05 10:16:18'),
('grandOpeningFormEmailFrom', 2, 'text', 'From Email Address', 'QSF2 <qsf2@inna.fr-wd.com>', '', '', 'y', 'n', 52, '2014-03-28 11:29:43', '2012-07-05 10:16:18'),
('grandOpeningFormEmailTo', 2, 'emails', 'To Email Address(es) &nbsp; <span class="label_description">Enter email address(es) that should receive a notification email regarding Grand Opening form submissions on your site</span>', '', '', 'Use commas to separate email addresses', 'n', 'n', 53, '2014-03-28 11:30:45', '2012-07-05 10:16:18'),
('grandOpeningFormEmailBody', 2, 'HtmlEditor', 'Message Body', '<p>New Grand Opening Info have been submitted. <br /><br />Name: <b>{name}</b><br />Company: <b>{company}</b><br />Phone:  <b>{phone}</b><br />Number of people attending the Grand Opening: <b>{people}</b></p><p>Click <a href="{link}">here</a> to view details.</p>', '', 'Constants: {name} {email} {phone} {people}', 'y', 'n', 54, '2014-03-28 11:34:51', '2012-07-05 10:16:18');

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