INSERT INTO `vt_DPageItemType` (`id`, `type`, `title`, `sorter`)
VALUES ('0', 'Form_OnlineInquiry_', 'Online Inquiry Form', '45');

CREATE TABLE IF NOT EXISTS `vt_FormOnlineInquiry` (
  `id` int(10) unsigned NOT NULL,
  `name` varchar(255) NOT NULL DEFAULT '',
  `email` varchar(255) NOT NULL DEFAULT '',
  `comments` text NOT NULL,
  `phone` varchar(255) NOT NULL DEFAULT '',
  `technologies` varchar(255) NOT NULL DEFAULT '',
  `effortPerMont` varchar(255) NOT NULL DEFAULT '',
  `added` datetime NOT NULL,
  `changed` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

INSERT INTO `vt_Settings` (`name`, `idCategory`, `fieldType`, `label`, `value`, `options`, `description`, `required`, `system`, `sorter`, `added`, `changed`) VALUES
  ('onlineInquiryFormEmailHeader', 2, 'header', '', 'Online Inquiry Form Submission (Admin Notification) <span class="label_description">For admin notifications English version only</span>', '', '', 'n', 'n', 510, '2010-07-13 11:22:59', '2013-05-14 09:58:15'),
  ('onlineInquiryFormEmailSubject', 2, 'text', 'Subject', 'New online inquiry has been submitted', '', '', 'y', 'n', 520, '2010-07-13 11:28:19', '2017-11-15 15:05:07'),
  ('onlineInquiryFormEmailFrom', 2, 'text', 'From Email Address &nbsp; <span class="label_description">If you leave this field empty - the From Email Address will be the same as the one in General Settings.</span>', '', '', '', 'n', 'n', 530, '2010-07-13 11:29:43', '2017-11-15 15:05:07'),
  ('onlineInquiryFormEmailTo', 2, 'emails', 'To Email Address(es) &nbsp; <span class="label_description">Enter email address(es) that should receive a notification email regarding Online Inquiry form submissions on your website</span>', '', '', 'Use commas to separate email addresses', 'n', 'n', 540, '2010-07-13 11:30:45', '2017-11-15 15:05:07'),
  ('onlineInquiryFormEmailBody', 2, 'HtmlEditor', 'Message Body', 'New online inquiry has been submitted.<br />\r\n<br />\r\nName: <b>{name}</b><br />\r\nEmail Address: <b>{email}</b><br />\r\nComment: <strong>{comments}</strong><br />\r\nPhone Number: <strong>{phone}</strong><br />\r\nTechnologies: <strong>{technologies}</strong><br />\r\nExpected effort per month: <strong>{effortPerMont}</strong><br />\r\n<br />\r\nClick <a href="{link}">here</a> to view details.', '', 'Constants:  {name} {email} {comments} {phone} {technologies} {effortPerMont} {link}', 'y', 'n', 550, '2010-07-13 11:34:51', '2017-11-15 15:05:07'),
  ('onlineInquiryFormEmailUserHeader', 2, 'header', '', 'Online Inquiry Form Submission (User Notification)', '', '', 'n', 'n', 560, '2015-08-18 09:42:43', '2015-08-18 09:42:43'),
  ('onlineInquiryFormEmailUserSubject', 2, 'text', 'Subject', 'DE New online inquiry has been submitted', '', '', 'y', 'n', 570, '2015-08-18 09:42:43', '2017-11-15 15:05:07'),
  ('onlineInquiryFormEmailUserFrom', 2, 'text', 'From Email Address &nbsp; <span class="label_description">If you leave this field empty - the From Email Address will be the same as the one in General Settings.</span>', '', '', '', 'n', 'n', 580, '2015-08-18 09:42:43', '2017-11-15 15:05:07'),
  ('onlineInquiryFormEmailUserBody', 2, 'HtmlEditor', 'Message Body', 'DE New online inquiry has been submitted.<br />\r\n<br />\r\nName: <b>{name}</b><br />\r\nEmail Address: <b>{email}</b><br />\r\nComment: <strong>{comments}</strong><br />\r\nPhone Number: <strong>{phone}</strong><br />\r\nTechnologies: <strong>{technologies}</strong><br />\r\nExpected effort per month: <strong>{effortPerMont}</strong>', '', 'Constants: {name} {email} {comments} {phone} {technologies} {effortPerMont}', 'y', 'n', 590, '2015-08-18 09:42:43', '2017-11-15 15:05:07');

INSERT INTO `vt_SettingsContent` (`name`, `lang`, `value`, `changed`) VALUES
  ('onlineInquiryFormEmailUserBody', 'en', 'New online inquiry has been submitted.<br />\r\n<br />\r\nName: <b>{name}</b><br />\r\nEmail Address: <b>{email}</b><br />\r\nComment: <strong>{comments}</strong><br />\r\nPhone Number: <strong>{phone}</strong><br />\r\nTechnologies: <strong>{technologies}</strong><br />\r\nExpected effort per month: <strong>{effortPerMont}</strong>', '2017-11-15 15:05:07'),
  ('onlineInquiryFormEmailUserFrom', 'en', '', '2017-11-15 15:05:07'),
  ('onlineInquiryFormEmailUserSubject', 'en', 'New online inquiry has been submitted', '2017-11-15 15:05:07');

INSERT INTO `vt_SettingsOptions` (`id`, `name`, `variable`, `value`, `type`, `sorter`) VALUES
  (166, 'onlineInquiryFormEmailBody', 'scriptOptions[enterMode]', '2', 'string', NULL),
  (167, 'onlineInquiryFormEmailBody', 'height', '200', 'int', NULL),
  (168, 'onlineInquiryFormEmailBody', 'mode', 'view', 'string', NULL),
  (169, 'onlineInquiryFormEmailUserBody', 'scriptOptions[enterMode]', '2', 'string', NULL),
  (170, 'onlineInquiryFormEmailUserBody', 'height', '200', 'int', NULL),
  (171, 'onlineInquiryFormEmailUserBody', 'mode', 'view', 'string', NULL);

INSERT INTO `vt_Settings` (`name`, `idCategory`, `fieldType`, `label`, `value`, `options`, `description`, `required`, `system`, `sorter`, `added`, `changed`) VALUES
  ('landingPage', 1, 'header', 'Landing Page', '', '', '', 'n', 'n', 11, '2017-11-07 11:12:32', '2017-11-07 11:12:37'),
  ('headerLandingPage', 1, 'htmlEditor', 'Landing Page Header', '<p><a href="https://virtido.com" target="_blank"><img alt="" dir="" id="" lang="" src="{BASE_URL}/userfiles/ckfiles/images/logo.png" style="width: 209px; height: 50px;" title="" /></a></p>\r\n', '', '', 'n', 'n', 12, '2017-11-07 11:11:58', '2017-11-20 13:22:46'),
  ('footerLandingPage', 1, 'htmlEditor', 'Landing Page Footer', '<p style="text-align: right;"><span style="font-size:18px;"><strong>Virtido Inc.</strong><br />\r\nAnkerstrasse 27<br />\r\n8004 Z&uuml;rich<br />\r\n<a href="mailto:info@virtido.com">info@virtido.com</a><br />\r\n+41 43 544 34 96</span></p>\r\n', '', '', 'n', 'n', 13, '2017-11-07 11:00:55', '2017-11-20 13:22:46');


INSERT INTO `vt_SettingsOptions` (`id`, `name`, `variable`, `value`, `type`, `sorter`) VALUES
  (null, 'footerLandingPage', 'mode', 'view', 'string', NULL),
  (null, 'headerLandingPage', 'mode', 'view', 'string', NULL);