
CREATE TABLE IF NOT EXISTS `ei_DContactFound` (
`id` int(11) NOT NULL,
  `title` varchar(150) NOT NULL,
  `sorter` int(11) NOT NULL,
  `added` datetime NOT NULL,
  `changed` datetime NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

INSERT INTO `ei_DContactFound` (`id`, `title`, `sorter`, `added`, `changed`) VALUES
(1, 'Google Search', 0, '2010-11-18 00:00:00', '2013-05-27 22:03:21'),
(2, 'Magazine ad', 1, '2010-11-18 00:00:00', '2013-05-27 22:03:21'),
(3, 'Other', 2, '2013-02-12 04:54:05', '2013-05-27 22:03:21');

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

ALTER TABLE `ei_DContactFound`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;


ALTER TABLE `ei_FormContact` ADD `idFoundUs` INT(11) NOT NULL AFTER `reasonTitle`;
ALTER TABLE `ei_FormContact` ADD `foundUsTitle` VARCHAR(255) NOT NULL AFTER `idFoundUs`;

UPDATE `ei_Settings` SET `description` = 'Constants: {name} {email} {phone} {reason} {foundUs} {comments} {link}' WHERE `ei_Settings`.`name` = 'contactFormEmailBody';
UPDATE `ei_Settings` SET `value` = 'New comments have been submitted on Elements, Inc website.<br /><br />Name: <b>{name}</b><br />Email Address: <b>{email}</b><br />Phone Number: <b>{phone}</b><br />Reason for Contact: <strong>{reason}</strong><br />Heard about us: <strong>{foundUs}</strong><br />Comments: <b>{comments}</b><br /><br />Click <a href="{link}">here</a> to view details.' WHERE `ei_Settings`.`name` = 'contactFormEmailBody';


ALTER TABLE `ei_DIndustryType` CHANGE `title` `title` VARCHAR(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
INSERT INTO `ei_DIndustryType` (`id`, `title`, `sorter`) VALUES ('4', 'HOA & Community Associations', '3');