-- 10000 to 10200
-- domain

ALTER TABLE  `BannerLevel` ADD  `popular` CHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL AFTER  `active` ;
ALTER TABLE  `ClassifiedLevel` ADD  `popular` CHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL AFTER  `active` ;
ALTER TABLE  `EventLevel` ADD  `popular` CHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL AFTER  `active` ;
ALTER TABLE  `ListingLevel` ADD  `popular` CHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL AFTER  `active` ;

CREATE TABLE  IF NOT EXISTS `Leads` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`item_id` INT( 11 ) NOT NULL ,
`member_id` INT( 11 ) NOT NULL ,
`type` VARCHAR( 10 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT  'listing/event/classified/general' ,
`first_name` VARCHAR( 25 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`last_name` VARCHAR( 25 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`email` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`phone` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`subject` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`message` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`entered` DATETIME NOT NULL DEFAULT  '0000-00-00 00:00:00',
`reply_date` DATETIME NOT NULL DEFAULT  '0000-00-00 00:00:00',
`forward_date` DATETIME NOT NULL DEFAULT  '0000-00-00 00:00:00',
`status` CHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT  'P' COMMENT  'A : read / P: unread'
) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci;

INSERT INTO  `ArticleLevel` (  `value` ,  `name` ,  `defaultlevel` ,  `detail` ,  `images` ,  `price` ,  `active` ,  `content` ,  `theme` ) VALUES ( 50,  'article',  'y',  'y', 5, 30.00,  'y', 'Contains summary View and Detail View. \r\nTitle, Publication Date, Author, Author URL, Abstract, Image, Content, Photo Gallery, Add to Favorites, Facebook Like and Send button, Google +1 button, Pinterest button.',  'contractors' ) ;

INSERT INTO  `BannerLevel` (  `value` ,  `name` ,  `defaultlevel` ,  `price` ,  `width` ,  `height` ,  `impression_block` ,  `impression_price` ,  `active` ,  `content` ,  `displayName` ,  `theme` )  VALUES 
( 1,  'top',  'y', 50.00, 728, 90, 1000, 50.00,  'y',  'Banner size: 728px x 90px',  'top',  'contractors' ) , 
( 2,  'bottom',  'n', 20.00, 468, 60, 1000, 20.00,  'y',  'Banner size: 468px x 60px',  'bottom',  'contractors' ) , 
( 3,  'top right',  'n', 40.00, 120, 90, 1000, 40.00, 'y',  'Banner size: 120px x 90px',  'top right',  'contractors' ) , 
( 50,  'sponsored links',  'n', 10.00, 180, 66, 1000, 10.00,  'y',  'Banner size: 180px x 66px',  'sponsored links',  'contractors' );

INSERT INTO  `ClassifiedLevel_Field` (`theme`, `level`, `field`) VALUES 
('contractors', 10, 'contact_name'), 
('contractors', 30, 'contact_name'), 
('contractors', 10, 'fax'), 
('contractors', 10, 'url'), 
('contractors', 10, 'long_description'), 
('contractors', 30, 'long_description'), 
('contractors', 10, 'main_image'), 
('contractors', 30, 'main_image'), 
('contractors', 50, 'main_image'), 
('contractors', 10, 'summary_description'),
('contractors', 30, 'summary_description'),
('contractors', 50, 'summary_description'),
('contractors', 10, 'contact_phone'),
('contractors', 30, 'contact_phone'),
('contractors', 50, 'contact_phone'),
('contractors', 10, 'contact_email'),
('contractors', 30, 'contact_email'),
('contractors', 50, 'contact_email'),
('contractors', 10, 'price'),
('contractors', 30, 'price'),
('contractors', 50, 'price');

INSERT INTO `ClassifiedLevel` (`value`, `name`, `defaultlevel`, `detail`, `images`, `price`, `active`, `content`, `theme`) VALUES
(50, 'silver', 'n', 'n', 0, 0.00, 'y', 'Title, Address, Photo, Phone, E-mail, Price, Short Description, Add to Favorites.', 'contractors'),
(30, 'gold', 'n', 'y', 3, 25.00, 'y', 'Gold Classifieds appear in search results above Silver Classifieds. \r\nContains Summary View and Detail View. \r\nTitle, Address, Photo, Contact Name, Phone, E-mail, Price, Short Description, Detail Description, Photo Gallery, Add to Favorites, Facebook Like and Send button, Google +1 button, Pinterest button.', 'contractors'),
(10, 'diamond', 'y', 'y', 7, 50.00, 'y', 'Diamond Classifieds appear in search results above Gold and Silver Classifieds. \r\nContains Summary View and Detail View. \r\nTitle, Address, Photo, Contact Name, Phone, Fax, E-mail, Web Link, Price, Short Description, Detail Description, Photo Gallery, Add to Favorites, Facebook Like and Send button, Google +1 button, Pinterest button.', 'contractors');


INSERT INTO `Content` (`id`, `updated`, `type`, `title`, `description`, `keywords`, `url`, `section`, `content`, `sitemap`) VALUES (NULL, '0000-00-00 00:00:00', 'Leads Form', 'Enquire', '', '', '', 'general', '', '0');

INSERT INTO `Email_Notification_Default` (`id`, `subject`, `body_text`, `body_html`) VALUES ('40', '[EDIRECTORY_TITLE] New Lead Notification', 'Dear ACCOUNT_NAME,\r\n\r\nYour item on EDIRECTORY_TITLE received the following lead.\r\n\r\nLEAD_MESSAGE\r\n\r\nYou can see it in DEFAULT_URL/members/\r\n\r\nThank you for being a member of the EDIRECTORY_TITLE!\r\n\r\nRegards\r\n\r\nEDIRECTORY_TITLE Team', '<html>\r\n<head>\r\n<style type="text/css">\r\n.default_text_settings {\r\nfont-family: Verdana, Arial, Helvetica, sans-serif;\r\nfont-size: 8pt;\r\ncolor: #003365;\r\nmargin: 0;\r\npadding: 5px;\r\nbackground: #FBFBFB;\r\nborder: 1px solid #E9E9E9;\r\ntext-align: justify;\r\n};\r\n</style>\r\n</head>\r\n<body>\r\n<div class="default_text_settings">\r\nDear ACCOUNT_NAME,<br /><br />\r\nYour item on EDIRECTORY_TITLE received the following lead.<br /><br />\r\nLEAD_MESSAGE<br /><br />\r\nYou can see it in DEFAULT_URL/members/ <br /><br />\r\nThank you for being a member of the EDIRECTORY_TITLE!<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\r\n</html>');

INSERT INTO  `Email_Notification` (`id` ,`email` ,`days` ,`deactivate` ,`updated` ,`bcc` ,`subject` ,`content_type` ,`body` ,`use_variables`) VALUES ('40',  'New Lead',  '0',  '0',  '0000-00-00 00:00:00',  '',  '[EDIRECTORY_TITLE] New Lead Notification',  'text/plain',  'Dear ACCOUNT_NAME,\r\n\r\nYour item on EDIRECTORY_TITLE received the following lead.\r\n\r\nLEAD_MESSAGE\r\n\r\nYou can see it in DEFAULT_URL/members/\r\n\r\nThank you for being a member of the EDIRECTORY_TITLE!\r\n\r\nRegards\r\n\r\nEDIRECTORY_TITLE Team', 'ACCOUNT_NAME,ACCOUNT_USERNAME,DEFAULT_URL,SITEMGR_EMAIL,EDIRECTORY_TITLE,LEAD_MESSAGE');

INSERT INTO  `EventLevel_Field` (`theme`, `level`, `field`) VALUES 
('contractors', 10, 'summary_description'), 
('contractors', 30, 'summary_description'), 
('contractors', 10, 'email'), 
('contractors', 10, 'url'), 
('contractors', 10, 'contact_name'), 
('contractors', 10, 'start_time'), 
('contractors', 30, 'start_time'), 
('contractors', 10, 'end_time'), 
('contractors', 30, 'end_time'), 
('contractors', 10, 'long_description'), 
('contractors', 10, 'main_image'), 
('contractors', 30, 'main_image'), 
('contractors', 10, 'phone'), 
('contractors', 30, 'phone'), 
('contractors', 10, 'video'), 
('contractors', 50, 'phone');

INSERT INTO  `EventLevel` (  `value` ,  `name` ,  `defaultlevel` ,  `detail` ,  `images` ,  `price` ,  `active` ,  `content` ,  `theme` ) VALUES 
( 50,  'silver',  'n',  'n', 0, 0.00,  'y',  'Title, Date, Address, Phone, Add to Favorites, Recurring option.',  'contractors' ), 
( 30,  'gold',  'n',  'n', 0, 25.00,  'y',  'Gold Events appear in search results above the Silver Events. \r\nTitle, Date, Time, Logo image, Address, Phone, Summary Description, Add to Favorites, Recurring option.',  'contractors' ) , 
( 10, 'diamond',  'y',  'y', 3, 50.00,  'y', 'Diamond Events appear in search results above Gold and Silver Events. \r\nContains Summary View and Detail view. \r\nTitle, Date, Time, Logo Image, Video Snippet, Address, Summary Description, Driving Directions, Phone, Web Link, E-mail, Contact Name, Photo Gallery, Detail Description, Add to Favorites, Facebook Like and Send button, Google +1 button, Pinterest button, Recurring option.', 'contractors' );


INSERT INTO  `Setting_Google` (`id` , `name` , `value`) VALUES ('11',  'google_tag_status',  'off'), ('12',  'google_tag_client',  '');

INSERT INTO `ListingLevel_Field` (`theme`, `level`, `field`) VALUES
('contractors', 10, 'summary_description'),
('contractors', 10, 'email'),
('contractors', 10, 'phone'),
('contractors', 10, 'url'),
('contractors', 10, 'fax'),
('contractors', 10, 'video'),
('contractors', 10, 'attachment_file'),
('contractors', 10, 'long_description'),
('contractors', 10, 'hours_of_work'),
('contractors', 10, 'locations'),
('contractors', 10, 'badges'),
('contractors', 10, 'main_image'),
('contractors', 30, 'summary_description'),
('contractors', 30, 'email'),
('contractors', 30, 'phone'),
('contractors', 30, 'url'),
('contractors', 30, 'fax'),
('contractors', 30, 'badges'),
('contractors', 50, 'email'),
('contractors', 50, 'phone'),
('contractors', 50, 'url'),
('contractors', 70, 'phone'),
('contractors', 10, 'price'),
('contractors', 10, 'fbpage'),
('contractors', 10, 'features');

INSERT INTO `ListingLevel` (`value`, `name`, `defaultlevel`, `detail`, `images`, `has_promotion`, `has_review`, `has_sms`, `has_call`, `backlink`, `price`, `free_category`, `category_price`, `active`, `content`, `theme`) VALUES
(70, 'bronze', 'n', 'n', 0, 'n', 'y', 'n', 'n', 'n', 0.00, 1, 5.00, 'y', 'Title, Address, Phone, Add to Favorites, Ratings and Reviews.', 'contractors'),
(50, 'silver', 'n', 'n', 0, 'n', 'y', 'n', 'n', 'n', 99.00, 1, 10.00, 'y', 'Silver level listings appear in search results above Bronze listings. \r\nTitle, Address, Phone, Web Link, E-mail Link, Add to Favorites, Ratings and Reviews.', 'contractors'),
(30, 'gold', 'n', 'n', 0, 'n', 'y', 'n', 'n', 'n', 199.00, 2, 15.00, 'y', 'Gold level listings appear in search results above Silver and Bronze listings. \r\nTitle, Address, Phone, Fax, Web Link, E-Mail Link, Summary Description, Add to Favorites, Badges, Ratings and Reviews.', 'contractors'),
(10, 'diamond', 'y', 'y', 9, 'y', 'y', 'y', 'y', 'y', 299.00, 3, 20.00, 'y', 'Diamond level listings appear in search results above Gold, Silver and Bronze listings. \r\nContains Detail View and Summary View. \r\nTitle, Logo Image, Address, Phone, Fax, Web Link, E-Mail Link, Summary Description, Detail Description, Add to Favorites, Map, Badges, Deal, Ratings and Reviews, Photo Gallery, Contact Form, Video Snippet, Attachment File, Hours of work, Location, Mobile Check in, Facebook Like and Send button, Google +1 button, Pinterest button, Send to Phone, Click to Call.', 'contractors');

