-- 9820 to 9900

--domain

ALTER TABLE  `ArticleCategory` ADD  `thumb_id` INT( 11 ) NOT NULL DEFAULT  '0' AFTER  `category_id` ,ADD  `image_id` INT( 11 ) NOT NULL DEFAULT  '0' AFTER  `thumb_id`, ADD  `summary_description` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL AFTER  `featured` ;
ALTER TABLE  `BlogCategory` ADD  `thumb_id` INT( 11 ) NOT NULL DEFAULT  '0' AFTER  `category_id` ,ADD  `image_id` INT( 11 ) NOT NULL DEFAULT  '0' AFTER  `thumb_id`, ADD  `summary_description` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL AFTER  `featured` ;
ALTER TABLE  `ClassifiedCategory` ADD  `thumb_id` INT( 11 ) NOT NULL DEFAULT  '0' AFTER  `category_id` ,ADD  `image_id` INT( 11 ) NOT NULL DEFAULT  '0' AFTER  `thumb_id`, ADD  `summary_description` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL AFTER  `featured` ;
ALTER TABLE  `Event` ADD  `video_snippet` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL AFTER  `fulltextsearch_where` ;
ALTER TABLE  `EventCategory` ADD  `thumb_id` INT( 11 ) NOT NULL DEFAULT  '0' AFTER  `category_id` ,ADD  `image_id` INT( 11 ) NOT NULL DEFAULT  '0' AFTER  `thumb_id`, ADD  `summary_description` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL AFTER  `featured` ;
ALTER TABLE  `Listing` ADD  `video_description` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL AFTER  `video_snippet` , ADD  `features` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL AFTER  `attachment_caption` ,ADD  `price` INT( 10 ) NULL COMMENT 'price range (1-4)' AFTER  `features` ,ADD  `facebook_page` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL AFTER  `price` ;
ALTER TABLE  `ListingCategory` ADD  `thumb_id` INT( 11 ) NOT NULL DEFAULT  '0' AFTER  `category_id` ,ADD  `image_id` INT( 11 ) NOT NULL DEFAULT  '0' AFTER  `thumb_id`, ADD  `summary_description` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL AFTER  `featured` ;
ALTER TABLE  `Listing_Summary` ADD  `price` INT( 10 ) NULL COMMENT 'price range (1-4)' AFTER  `avg_review`;
ALTER TABLE  `Review` ADD  `like` INT( 11 ) NOT NULL ,ADD  `dislike` INT( 11 ) NOT NULL,ADD  `like_ips` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,ADD  `dislike_ips` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ;


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.',  'diningguide' ) ;

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',  'diningguide' ) , 
( 2,  'bottom',  'n', 20.00, 468, 60, 1000, 20.00,  'y',  'Banner size: 468px x 60px',  'bottom',  'diningguide' ) , 
( 3,  'top right',  'n', 40.00, 120, 90, 1000, 40.00, 'y',  'Banner size: 120px x 90px',  'top right',  'diningguide' ) , 
( 50,  'sponsored links',  'n', 10.00, 180, 66, 1000, 10.00,  'y',  'Banner size: 180px x 66px',  'sponsored links',  'diningguide' );

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.', 'diningguide'),
(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.', 'diningguide'),
(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.', 'diningguide');

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

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

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.',  'diningguide' ), 
( 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.',  'diningguide' ) , 
( 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.', 'diningguide' );

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

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.', 'diningguide'),
(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.', 'diningguide'),
(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.', 'diningguide'),
(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.', 'diningguide');

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

INSERT INTO Setting (name, value) VALUES
('listing_price_1_from', '0'),
('listing_price_1_to', '15'),
('listing_price_2_from', '16'),
('listing_price_2_to', '30'),
('listing_price_3_from', '31'),
('listing_price_3_to', '40'),
('listing_price_4_from', '41'),
('listing_price_4_to', ''),
('listing_price_symbol', '$');


CREATE TABLE IF NOT EXISTS `Classified_LocationCounter` (
`id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`location_level` INT(11) NOT NULL ,
`location_id` INT(11) NOT NULL ,
`count` INT(11) NOT NULL ,
`title` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`full_friendly_url` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE `Event_LocationCounter` (
`id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`location_level` INT(11) NOT NULL ,
`location_id` INT(11) NOT NULL ,
`count` INT(11) NOT NULL ,
`title` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`full_friendly_url` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE `Listing_LocationCounter` (
`id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`location_level` INT(11) NOT NULL ,
`location_id` INT(11) NOT NULL ,
`count` INT(11) NOT NULL ,
`title` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`full_friendly_url` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

