-- http://www.phpmyadmin.net
--




--
-- Database: `client_yp4`
--

-- --------------------------------------------------------

--
-- Table structure for table `backup_log`
--

CREATE TABLE IF NOT EXISTS `backup_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `file` text NOT NULL,
  `size` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

-- --------------------------------------------------------

--
-- Table structure for table `banners`
--

CREATE TABLE IF NOT EXISTS `banners` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `file` varchar(150) NOT NULL,
  `page` int(11) NOT NULL DEFAULT '0',
  `category` int(11) NOT NULL DEFAULT '0',
  `link` varchar(200) NOT NULL DEFAULT '#',
  `title` varchar(150) NOT NULL,
  `from_date` date NOT NULL,
  `to_date` date NOT NULL,
  `max_impressions` int(11) NOT NULL DEFAULT '0',
  `max_clicks` int(11) NOT NULL DEFAULT '0',
  `impressions` int(11) NOT NULL DEFAULT '0',
  `clicks` int(11) NOT NULL DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `modified_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `from_date` (`from_date`,`to_date`,`max_impressions`,`max_clicks`,`impressions`,`clicks`),
  KEY `page` (`page`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=30 ;

--
-- Dumping data for table `banners`
--

INSERT INTO `banners` (`id`, `file`, `page`, `category`, `link`, `title`, `from_date`, `to_date`, `max_impressions`, `max_clicks`, `impressions`, `clicks`, `created_at`, `modified_at`) VALUES
(17, '2451a54bd5253101ef5d6bdafc16058c.jpg', 1, 0, 'http://www.yellowpagesphpscript.com', 'Testing Banner for Index Pages 1', '2014-11-15', '2015-11-26', 0, 0, 1950, 0, '2015-05-07 19:15:53', '2015-05-07 19:15:53'),
(29, '12d1e7b41c5792db35919859a4479d13.png', 0, 0, 'testing.com', 'This is a testiing', '2015-09-03', '2015-09-10', 0, 0, 133, 0, '2015-09-03 12:39:06', '2015-09-03 12:39:06');

-- --------------------------------------------------------

--
-- Table structure for table `blog`
--

CREATE TABLE IF NOT EXISTS `blog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `catelogs_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(120) NOT NULL,
  `slug` varchar(250) DEFAULT NULL,
  `description` text NOT NULL,
  `image` varchar(100) NOT NULL,
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `catelogs_id` (`catelogs_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `blog`
--

INSERT INTO `blog` (`id`, `catelogs_id`, `title`, `slug`, `description`, `image`, `updated_at`, `created_at`) VALUES
(1, 1, 'Yellow Pages Php Script is one the best business directory.', 'yellow-pages-php-script-is-one-the-best-business-directory', 'Yellow Pages Business Directory php Script is one the best business directory or Yellow Pages portal script written in Php and MySQL. Nowadays Business directories or Local Yellow Pages are becoming more and more popular. In a meaning of Yellow Pages directory or business directory website , a listing page can become a small business web site.<div>&lt;code&gt;</div><div>&lt;?php&nbsp;</div><div>&nbsp; &nbsp; if($blog){<br></div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; echo "Hello World..";<br></div><div>&nbsp; &nbsp; }<br></div><div><br>&lt;/code&gt; &nbsp;&nbsp;<p>If you’re an Individual or Company who are looking to start a Local business directory or Yellow Pages, it will help you to achieve your business goals. Yellow Pages Business Directory Php Script is loaded with tons of features and very user friendly in terms of searching and business listing submission\r\n\r\nIntegrated mapping,	Business listings are tied to Google maps so that users can easily find where your advertisers are located, and many more.\r\n</p></div>', 'logo2.jpg', '2014-08-05 11:19:35', '0000-00-00 00:00:00'),
(2, 1, 'Create a Game model which extends Eloquent and use this', 'yellow-pages-business-directory', 'Of course, your database tables are probably related to one another. For example, a blog post may have many comments, or an order could be related to the user who placed it. Eloquent makes managing and working with these relationships easy. Laravel supports four types of relationships:\r\n\r\nIn the example above, Eloquent will look for a user_id column on the phones table. If you would like to define a different foreign key column, you may pass it as the second argument to the belongsTo method:\r\n\r\nMany-to-many relations are a more complicated relationship type. An example of such a relationship is a user with many roles, where the roles are also shared by other users. For example, many users may have the role of "Admin". Three database tables are needed for this relationship: users, roles, and role_user. The role_user table is derived from the alphabetical order of the related model names, and should have user_id and role_id columns.\r\n\r\nWe can define a many-to-many relation using the belongsToMany method:', '', '2014-08-05 10:51:49', '0000-00-00 00:00:00'),
(3, 0, 'Database Table to Eloquent Model Mapping', NULL, 'In Laravel, each Eloquent model represents a single database table. It is important to note however, that even though a single Model maps to a single Table, we will most often be using combinations of Models in retrieving say an article, or a task, or a blog post. By way of relationships, we can query several tables to get the desired result.\r\n\r\nIn the last tutorial, we covered how to do basic CRUD with Laravel by using the DB class right out of the box. Now remember, we didn’t even create any Models for that, the functionality was there right out of the box. Quite impressive! Moving on, we can now define some Models and this will be by Extending Eloquent.', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(4, 1, 'Hello Thsi is Test', 'hello-thsi-is-test', '<p>Hello This is This</p>', '', '2014-08-06 06:19:12', '2014-08-06 06:19:12'),
(5, 0, 'fdgf', 'dfgfd', '<p>fdgdfg</p>', '', '2014-08-06 09:00:35', '2014-08-06 09:00:35');

-- --------------------------------------------------------

--
-- Table structure for table `cache`
--

CREATE TABLE IF NOT EXISTS `cache` (
  `key` varchar(255) NOT NULL,
  `value` text NOT NULL,
  `expiration` int(11) NOT NULL,
  PRIMARY KEY (`key`),
  UNIQUE KEY `UK_KEY` (`key`),
  KEY `key` (`key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cache`
--

INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES
('settings_default_location', 's:5:"India";', 1448028319),
('locations_india', 'N;', 1448028333),
('categories_agriculture-forestry-fishing', 'O:8:"stdClass":1:{s:2:"id";s:1:"1";}', 1448028319),
('categories_pk_1', 'O:8:"stdClass":14:{s:2:"id";s:1:"1";s:9:"parent_id";s:1:"0";s:7:"lineage";s:5:"00001";s:4:"deep";s:1:"0";s:4:"name";s:22:"Agriculture & Fishing ";s:3:"top";s:1:"0";s:11:"description";s:134:"Find  Agriculture, Forestry & Fishing  business and services in your local place, with their contact information, address and reviews.";s:10:"meta_title";s:63:"List of  Agriculture, Forestry & Fishing  business and services";s:12:"meta_keyword";s:63:"List of  Agriculture, Forestry & Fishing  business and services";s:16:"meta_description";s:63:"List of  Agriculture, Forestry & Fishing  business and services";s:4:"slug";s:28:"agriculture-forestry-fishing";s:6:"status";s:2:"51";s:10:"updated_at";s:19:"0000-00-00 00:00:00";s:10:"created_at";s:19:"0000-00-00 00:00:00";}', 1419084319),
('settings_adsense_pub_id', 's:23:"ca-pub-5079663447907991";', 1448028319),
('settings_seo_listing_title', 's:28:"All {category} in {location}";', 1448028319),
('settings_seo_listing_keyword', 's:83:"{category), {location}, {location} yellow page, {location} local business directory";', 1448028319),
('settings_seo_listing_description', 's:135:"List of all business and services in {location} yellow page, find their contact no, email, reviews etc. all business of this {category}";', 1448028319),
('settings_site_title', 's:20:"Yellow Pagesn Script";', 1448028319),
('settings_publisher_id', 's:23:"ca-pub-5079663447907991";', 1448028319),
('categories_last2_1', 'O:8:"stdClass":5:{s:2:"id";s:4:"9581";s:7:"post_id";s:1:"1";s:4:"term";s:8:"category";s:5:"value";s:2:"71";s:7:"caption";s:8:"Category";}', 1419084319),
('locations_last2_1', 'O:8:"stdClass":5:{s:2:"id";s:4:"9582";s:7:"post_id";s:1:"1";s:4:"term";s:8:"location";s:5:"value";s:1:"1";s:7:"caption";s:8:"Location";}', 1419084319),
('locations_last_1', 'a:1:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"9582";s:7:"post_id";s:1:"1";s:4:"term";s:8:"location";s:5:"value";s:1:"1";s:7:"caption";s:8:"Location";}}', 1419084319),
('locations_pk_1', 'O:8:"stdClass":12:{s:2:"id";s:1:"1";s:9:"parent_id";s:1:"0";s:7:"lineage";s:5:"00001";s:4:"deep";s:1:"0";s:4:"name";s:7:"Alabama";s:10:"meta_title";s:35:"Find Business & Services in Alabama";s:12:"meta_keyword";s:30:"Business & Services in Alabama";s:16:"meta_description";s:219:"List of Business & Services in Alabama, You can find all the Business & Services in your local area with their Contact information, reviews and ratting, which will guide you to choose best Business & Services in Alabama";s:4:"slug";s:7:"alabama";s:6:"prefix";s:2:"AL";s:6:"status";s:2:"51";s:7:"popular";s:1:"0";}', 1419084319),
('categories_last_1', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"9581";s:7:"post_id";s:1:"1";s:4:"term";s:8:"category";s:5:"value";s:2:"71";s:7:"caption";s:8:"Category";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"9580";s:7:"post_id";s:1:"1";s:4:"term";s:8:"category";s:5:"value";s:1:"1";s:7:"caption";s:8:"Category";}}', 1419084319),
('categories_pk_71', 'O:8:"stdClass":14:{s:2:"id";s:2:"71";s:9:"parent_id";s:1:"1";s:7:"lineage";s:11:"00001-00071";s:4:"deep";s:1:"1";s:4:"name";s:5:"Crops";s:3:"top";s:1:"0";s:11:"description";s:132:"Find Agricultural Production - Crops business and services in your local place, with their contact information, address and reviews.";s:10:"meta_title";s:61:"List of Agricultural Production - Crops business and services";s:12:"meta_keyword";s:53:"Agricultural Production - Crops business and services";s:16:"meta_description";s:61:"List of Agricultural Production - Crops business and services";s:4:"slug";s:29:"agricultural-production-crops";s:6:"status";s:2:"51";s:10:"updated_at";s:19:"0000-00-00 00:00:00";s:10:"created_at";s:19:"0000-00-00 00:00:00";}', 1419084319),
('categories_last2_236', 'O:8:"stdClass":5:{s:2:"id";s:4:"8523";s:7:"post_id";s:3:"236";s:4:"term";s:8:"category";s:5:"value";s:2:"73";s:7:"caption";s:8:"Category";}', 1419084319),
('locations_last2_236', 'O:8:"stdClass":5:{s:2:"id";s:4:"8521";s:7:"post_id";s:3:"236";s:4:"term";s:8:"location";s:5:"value";s:4:"9935";s:7:"caption";s:4:"City";}', 1419084319),
('locations_last_236', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"8521";s:7:"post_id";s:3:"236";s:4:"term";s:8:"location";s:5:"value";s:4:"9935";s:7:"caption";s:4:"City";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"8520";s:7:"post_id";s:3:"236";s:4:"term";s:8:"location";s:5:"value";s:2:"48";s:7:"caption";s:6:"Region";}}', 1419084319),
('locations_pk_9935', 'O:8:"stdClass":12:{s:2:"id";s:4:"9935";s:9:"parent_id";s:2:"48";s:7:"lineage";s:11:"00048-09935";s:4:"deep";s:1:"1";s:4:"name";s:8:"Freeland";s:10:"meta_title";s:40:"Find Business &amp; Services in Freeland";s:12:"meta_keyword";s:35:"Business &amp; Services in Freeland";s:16:"meta_description";s:233:"List of Business &amp; Services in Freeland, You can find all the Business &amp; Services in your local area with their Contact information, reviews and ratting, which will guide you to choose best Business &amp; Services in Freeland";s:4:"slug";s:8:"Freeland";s:6:"prefix";s:2:"WA";s:6:"status";s:2:"51";s:7:"popular";s:1:"0";}', 1419084319),
('locations_pk_48', 'O:8:"stdClass":12:{s:2:"id";s:2:"48";s:9:"parent_id";s:1:"0";s:7:"lineage";s:5:"00048";s:4:"deep";s:1:"0";s:4:"name";s:10:"Washington";s:10:"meta_title";s:42:"Find Business &amp; Services in Washington";s:12:"meta_keyword";s:37:"Business &amp; Services in Washington";s:16:"meta_description";s:237:"List of Business &amp; Services in Washington, You can find all the Business &amp; Services in your local area with their Contact information, reviews and ratting, which will guide you to choose best Business &amp; Services in Washington";s:4:"slug";s:10:"Washington";s:6:"prefix";s:2:"WA";s:6:"status";s:2:"51";s:7:"popular";s:1:"0";}', 1419084319),
('categories_last_236', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"8523";s:7:"post_id";s:3:"236";s:4:"term";s:8:"category";s:5:"value";s:2:"73";s:7:"caption";s:8:"Category";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"8522";s:7:"post_id";s:3:"236";s:4:"term";s:8:"category";s:5:"value";s:1:"1";s:7:"caption";s:8:"Category";}}', 1419084319),
('categories_pk_73', 'O:8:"stdClass":14:{s:2:"id";s:2:"73";s:9:"parent_id";s:1:"1";s:7:"lineage";s:11:"00001-00073";s:4:"deep";s:1:"1";s:4:"name";s:21:"Agricultural Services";s:3:"top";s:1:"0";s:11:"description";s:122:"Find Agricultural Services business and services in your local place, with their contact information, address and reviews.";s:10:"meta_title";s:51:"List of Agricultural Services business and services";s:12:"meta_keyword";s:43:"Agricultural Services business and services";s:16:"meta_description";s:51:"List of Agricultural Services business and services";s:4:"slug";s:21:"agricultural-services";s:6:"status";s:2:"51";s:10:"updated_at";s:19:"0000-00-00 00:00:00";s:10:"created_at";s:19:"0000-00-00 00:00:00";}', 1419084319),
('categories_last2_237', 'O:8:"stdClass":5:{s:2:"id";s:4:"5220";s:7:"post_id";s:3:"237";s:4:"term";s:8:"category";s:5:"value";s:2:"73";s:7:"caption";s:8:"Category";}', 1419084319),
('locations_last2_237', 'O:8:"stdClass":5:{s:2:"id";s:4:"5218";s:7:"post_id";s:3:"237";s:4:"term";s:8:"location";s:5:"value";s:5:"24856";s:7:"caption";s:4:"City";}', 1419084319),
('locations_last_237', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"5218";s:7:"post_id";s:3:"237";s:4:"term";s:8:"location";s:5:"value";s:5:"24856";s:7:"caption";s:4:"City";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"5217";s:7:"post_id";s:3:"237";s:4:"term";s:8:"location";s:5:"value";s:2:"48";s:7:"caption";s:6:"Region";}}', 1419084319),
('locations_pk_24856', 'O:8:"stdClass":12:{s:2:"id";s:5:"24856";s:9:"parent_id";s:2:"48";s:7:"lineage";s:11:"00048-24856";s:4:"deep";s:1:"1";s:4:"name";s:7:"Seattle";s:10:"meta_title";s:39:"Find Business &amp; Services in Seattle";s:12:"meta_keyword";s:34:"Business &amp; Services in Seattle";s:16:"meta_description";s:231:"List of Business &amp; Services in Seattle, You can find all the Business &amp; Services in your local area with their Contact information, reviews and ratting, which will guide you to choose best Business &amp; Services in Seattle";s:4:"slug";s:7:"Seattle";s:6:"prefix";s:2:"WA";s:6:"status";s:2:"51";s:7:"popular";s:1:"0";}', 1419084319),
('categories_last_237', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"5220";s:7:"post_id";s:3:"237";s:4:"term";s:8:"category";s:5:"value";s:2:"73";s:7:"caption";s:8:"Category";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"5219";s:7:"post_id";s:3:"237";s:4:"term";s:8:"category";s:5:"value";s:1:"1";s:7:"caption";s:8:"Category";}}', 1419084319),
('categories_last2_238', 'O:8:"stdClass":5:{s:2:"id";s:4:"3380";s:7:"post_id";s:3:"238";s:4:"term";s:8:"category";s:5:"value";s:2:"73";s:7:"caption";s:8:"Category";}', 1419084319),
('locations_last2_238', 'O:8:"stdClass":5:{s:2:"id";s:4:"3378";s:7:"post_id";s:3:"238";s:4:"term";s:8:"location";s:5:"value";s:5:"16571";s:7:"caption";s:4:"City";}', 1419084319),
('locations_last_238', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"3378";s:7:"post_id";s:3:"238";s:4:"term";s:8:"location";s:5:"value";s:5:"16571";s:7:"caption";s:4:"City";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"3377";s:7:"post_id";s:3:"238";s:4:"term";s:8:"location";s:5:"value";s:2:"47";s:7:"caption";s:6:"Region";}}', 1419084319),
('locations_pk_16571', 'O:8:"stdClass":12:{s:2:"id";s:5:"16571";s:9:"parent_id";s:2:"47";s:7:"lineage";s:11:"00047-16571";s:4:"deep";s:1:"1";s:4:"name";s:8:"Manassas";s:10:"meta_title";s:40:"Find Business &amp; Services in Manassas";s:12:"meta_keyword";s:35:"Business &amp; Services in Manassas";s:16:"meta_description";s:233:"List of Business &amp; Services in Manassas, You can find all the Business &amp; Services in your local area with their Contact information, reviews and ratting, which will guide you to choose best Business &amp; Services in Manassas";s:4:"slug";s:8:"Manassas";s:6:"prefix";s:2:"VA";s:6:"status";s:2:"51";s:7:"popular";s:1:"0";}', 1419084319),
('locations_pk_47', 'O:8:"stdClass":12:{s:2:"id";s:2:"47";s:9:"parent_id";s:1:"0";s:7:"lineage";s:5:"00047";s:4:"deep";s:1:"0";s:4:"name";s:8:"Virginia";s:10:"meta_title";s:40:"Find Business &amp; Services in Virginia";s:12:"meta_keyword";s:35:"Business &amp; Services in Virginia";s:16:"meta_description";s:233:"List of Business &amp; Services in Virginia, You can find all the Business &amp; Services in your local area with their Contact information, reviews and ratting, which will guide you to choose best Business &amp; Services in Virginia";s:4:"slug";s:8:"Virginia";s:6:"prefix";s:2:"VA";s:6:"status";s:2:"51";s:7:"popular";s:1:"0";}', 1419084319),
('categories_last_238', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"3380";s:7:"post_id";s:3:"238";s:4:"term";s:8:"category";s:5:"value";s:2:"73";s:7:"caption";s:8:"Category";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"3379";s:7:"post_id";s:3:"238";s:4:"term";s:8:"category";s:5:"value";s:1:"1";s:7:"caption";s:8:"Category";}}', 1419084319),
('categories_last2_239', 'O:8:"stdClass":5:{s:2:"id";s:4:"4576";s:7:"post_id";s:3:"239";s:4:"term";s:8:"category";s:5:"value";s:2:"73";s:7:"caption";s:8:"Category";}', 1419084319),
('locations_last2_239', 'O:8:"stdClass":5:{s:2:"id";s:4:"4574";s:7:"post_id";s:3:"239";s:4:"term";s:8:"location";s:5:"value";s:5:"23669";s:7:"caption";s:4:"City";}', 1419084319),
('locations_last_239', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"4574";s:7:"post_id";s:3:"239";s:4:"term";s:8:"location";s:5:"value";s:5:"23669";s:7:"caption";s:4:"City";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"4573";s:7:"post_id";s:3:"239";s:4:"term";s:8:"location";s:5:"value";s:2:"14";s:7:"caption";s:6:"Region";}}', 1419084319),
('locations_pk_23669', 'O:8:"stdClass":12:{s:2:"id";s:5:"23669";s:9:"parent_id";s:2:"14";s:7:"lineage";s:11:"00014-23669";s:4:"deep";s:1:"1";s:4:"name";s:15:"Rolling Meadows";s:10:"meta_title";s:47:"Find Business &amp; Services in Rolling Meadows";s:12:"meta_keyword";s:42:"Business &amp; Services in Rolling Meadows";s:16:"meta_description";s:247:"List of Business &amp; Services in Rolling Meadows, You can find all the Business &amp; Services in your local area with their Contact information, reviews and ratting, which will guide you to choose best Business &amp; Services in Rolling Meadows";s:4:"slug";s:15:"Rolling-Meadows";s:6:"prefix";s:2:"IL";s:6:"status";s:2:"51";s:7:"popular";s:1:"0";}', 1419084319),
('locations_pk_14', 'O:8:"stdClass":12:{s:2:"id";s:2:"14";s:9:"parent_id";s:1:"0";s:7:"lineage";s:5:"00014";s:4:"deep";s:1:"0";s:4:"name";s:8:"Illinois";s:10:"meta_title";s:40:"Find Business &amp; Services in Illinois";s:12:"meta_keyword";s:35:"Business &amp; Services in Illinois";s:16:"meta_description";s:233:"List of Business &amp; Services in Illinois, You can find all the Business &amp; Services in your local area with their Contact information, reviews and ratting, which will guide you to choose best Business &amp; Services in Illinois";s:4:"slug";s:8:"Illinois";s:6:"prefix";s:2:"IL";s:6:"status";s:2:"51";s:7:"popular";s:1:"0";}', 1419084319),
('categories_last_239', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"4576";s:7:"post_id";s:3:"239";s:4:"term";s:8:"category";s:5:"value";s:2:"73";s:7:"caption";s:8:"Category";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"4575";s:7:"post_id";s:3:"239";s:4:"term";s:8:"category";s:5:"value";s:1:"1";s:7:"caption";s:8:"Category";}}', 1419084319),
('categories_last2_240', 'O:8:"stdClass":5:{s:2:"id";s:4:"6337";s:7:"post_id";s:3:"240";s:4:"term";s:8:"category";s:5:"value";s:2:"73";s:7:"caption";s:8:"Category";}', 1419084320),
('locations_last2_240', 'O:8:"stdClass":5:{s:2:"id";s:4:"6335";s:7:"post_id";s:3:"240";s:4:"term";s:8:"location";s:5:"value";s:5:"12954";s:7:"caption";s:4:"City";}', 1419084320),
('locations_last_240', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"6335";s:7:"post_id";s:3:"240";s:4:"term";s:8:"location";s:5:"value";s:5:"12954";s:7:"caption";s:4:"City";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"6334";s:7:"post_id";s:3:"240";s:4:"term";s:8:"location";s:5:"value";s:2:"44";s:7:"caption";s:6:"Region";}}', 1419084320),
('locations_pk_12954', 'O:8:"stdClass":12:{s:2:"id";s:5:"12954";s:9:"parent_id";s:2:"44";s:7:"lineage";s:11:"00044-12954";s:4:"deep";s:1:"1";s:4:"name";s:7:"Houston";s:10:"meta_title";s:39:"Find Business &amp; Services in Houston";s:12:"meta_keyword";s:34:"Business &amp; Services in Houston";s:16:"meta_description";s:231:"List of Business &amp; Services in Houston, You can find all the Business &amp; Services in your local area with their Contact information, reviews and ratting, which will guide you to choose best Business &amp; Services in Houston";s:4:"slug";s:7:"Houston";s:6:"prefix";s:2:"TX";s:6:"status";s:2:"51";s:7:"popular";s:1:"0";}', 1419084320),
('locations_pk_44', 'O:8:"stdClass":12:{s:2:"id";s:2:"44";s:9:"parent_id";s:1:"0";s:7:"lineage";s:5:"00044";s:4:"deep";s:1:"0";s:4:"name";s:5:"Texas";s:10:"meta_title";s:37:"Find Business &amp; Services in Texas";s:12:"meta_keyword";s:32:"Business &amp; Services in Texas";s:16:"meta_description";s:227:"List of Business &amp; Services in Texas, You can find all the Business &amp; Services in your local area with their Contact information, reviews and ratting, which will guide you to choose best Business &amp; Services in Texas";s:4:"slug";s:5:"Texas";s:6:"prefix";s:2:"TX";s:6:"status";s:2:"51";s:7:"popular";s:1:"0";}', 1419084320),
('categories_last_240', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"6337";s:7:"post_id";s:3:"240";s:4:"term";s:8:"category";s:5:"value";s:2:"73";s:7:"caption";s:8:"Category";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"6336";s:7:"post_id";s:3:"240";s:4:"term";s:8:"category";s:5:"value";s:1:"1";s:7:"caption";s:8:"Category";}}', 1419084320),
('categories_last2_242', 'O:8:"stdClass":5:{s:2:"id";s:4:"5108";s:7:"post_id";s:3:"242";s:4:"term";s:8:"category";s:5:"value";s:2:"73";s:7:"caption";s:8:"Category";}', 1419084320),
('locations_last2_242', 'O:8:"stdClass":5:{s:2:"id";s:4:"5106";s:7:"post_id";s:3:"242";s:4:"term";s:8:"location";s:5:"value";s:4:"5503";s:7:"caption";s:4:"City";}', 1419084320),
('locations_last_242', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"5106";s:7:"post_id";s:3:"242";s:4:"term";s:8:"location";s:5:"value";s:4:"5503";s:7:"caption";s:4:"City";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"5105";s:7:"post_id";s:3:"242";s:4:"term";s:8:"location";s:5:"value";s:2:"47";s:7:"caption";s:6:"Region";}}', 1419084320),
('locations_pk_5503', 'O:8:"stdClass":12:{s:2:"id";s:4:"5503";s:9:"parent_id";s:2:"47";s:7:"lineage";s:11:"00047-05503";s:4:"deep";s:1:"1";s:4:"name";s:9:"Clintwood";s:10:"meta_title";s:41:"Find Business &amp; Services in Clintwood";s:12:"meta_keyword";s:36:"Business &amp; Services in Clintwood";s:16:"meta_description";s:235:"List of Business &amp; Services in Clintwood, You can find all the Business &amp; Services in your local area with their Contact information, reviews and ratting, which will guide you to choose best Business &amp; Services in Clintwood";s:4:"slug";s:9:"Clintwood";s:6:"prefix";s:2:"VA";s:6:"status";s:2:"51";s:7:"popular";s:1:"0";}', 1419084320),
('categories_last_242', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"5108";s:7:"post_id";s:3:"242";s:4:"term";s:8:"category";s:5:"value";s:2:"73";s:7:"caption";s:8:"Category";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"5107";s:7:"post_id";s:3:"242";s:4:"term";s:8:"category";s:5:"value";s:1:"1";s:7:"caption";s:8:"Category";}}', 1419084320),
('categories_last2_243', 'O:8:"stdClass":5:{s:2:"id";s:4:"9053";s:7:"post_id";s:3:"243";s:4:"term";s:8:"category";s:5:"value";s:2:"73";s:7:"caption";s:8:"Category";}', 1419084320),
('locations_last2_243', 'O:8:"stdClass":5:{s:2:"id";s:4:"9051";s:7:"post_id";s:3:"243";s:4:"term";s:8:"location";s:5:"value";s:4:"4167";s:7:"caption";s:4:"City";}', 1419084320),
('locations_last_243', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"9051";s:7:"post_id";s:3:"243";s:4:"term";s:8:"location";s:5:"value";s:4:"4167";s:7:"caption";s:4:"City";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"9050";s:7:"post_id";s:3:"243";s:4:"term";s:8:"location";s:5:"value";s:1:"5";s:7:"caption";s:6:"Region";}}', 1419084320),
('locations_pk_4167', 'O:8:"stdClass":12:{s:2:"id";s:4:"4167";s:9:"parent_id";s:1:"5";s:7:"lineage";s:11:"00005-04167";s:4:"deep";s:1:"1";s:4:"name";s:11:"Canoga Park";s:10:"meta_title";s:43:"Find Business &amp; Services in Canoga Park";s:12:"meta_keyword";s:38:"Business &amp; Services in Canoga Park";s:16:"meta_description";s:239:"List of Business &amp; Services in Canoga Park, You can find all the Business &amp; Services in your local area with their Contact information, reviews and ratting, which will guide you to choose best Business &amp; Services in Canoga Park";s:4:"slug";s:11:"Canoga-Park";s:6:"prefix";s:2:"CA";s:6:"status";s:2:"51";s:7:"popular";s:1:"0";}', 1419084320),
('locations_pk_5', 'O:8:"stdClass":12:{s:2:"id";s:1:"5";s:9:"parent_id";s:1:"0";s:7:"lineage";s:5:"00005";s:4:"deep";s:1:"0";s:4:"name";s:10:"California";s:10:"meta_title";s:42:"Find Business &amp; Services in California";s:12:"meta_keyword";s:37:"Business &amp; Services in California";s:16:"meta_description";s:237:"List of Business &amp; Services in California, You can find all the Business &amp; Services in your local area with their Contact information, reviews and ratting, which will guide you to choose best Business &amp; Services in California";s:4:"slug";s:10:"California";s:6:"prefix";s:2:"CA";s:6:"status";s:2:"51";s:7:"popular";s:1:"0";}', 1419084320),
('categories_last_243', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"9053";s:7:"post_id";s:3:"243";s:4:"term";s:8:"category";s:5:"value";s:2:"73";s:7:"caption";s:8:"Category";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"9052";s:7:"post_id";s:3:"243";s:4:"term";s:8:"category";s:5:"value";s:1:"1";s:7:"caption";s:8:"Category";}}', 1419084320),
('categories_last2_245', 'O:8:"stdClass":5:{s:2:"id";s:4:"4743";s:7:"post_id";s:3:"245";s:4:"term";s:8:"category";s:5:"value";s:2:"73";s:7:"caption";s:8:"Category";}', 1419084320),
('locations_last2_245', 'O:8:"stdClass":5:{s:2:"id";s:4:"4741";s:7:"post_id";s:3:"245";s:4:"term";s:8:"location";s:5:"value";s:5:"13487";s:7:"caption";s:4:"City";}', 1419084320),
('locations_last_245', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"4741";s:7:"post_id";s:3:"245";s:4:"term";s:8:"location";s:5:"value";s:5:"13487";s:7:"caption";s:4:"City";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"4740";s:7:"post_id";s:3:"245";s:4:"term";s:8:"location";s:5:"value";s:2:"48";s:7:"caption";s:6:"Region";}}', 1419084320),
('locations_pk_13487', 'O:8:"stdClass":12:{s:2:"id";s:5:"13487";s:9:"parent_id";s:2:"48";s:7:"lineage";s:11:"00048-13487";s:4:"deep";s:1:"1";s:4:"name";s:8:"Issaquah";s:10:"meta_title";s:40:"Find Business &amp; Services in Issaquah";s:12:"meta_keyword";s:35:"Business &amp; Services in Issaquah";s:16:"meta_description";s:233:"List of Business &amp; Services in Issaquah, You can find all the Business &amp; Services in your local area with their Contact information, reviews and ratting, which will guide you to choose best Business &amp; Services in Issaquah";s:4:"slug";s:8:"Issaquah";s:6:"prefix";s:2:"WA";s:6:"status";s:2:"51";s:7:"popular";s:1:"0";}', 1419084320),
('categories_last_245', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"4743";s:7:"post_id";s:3:"245";s:4:"term";s:8:"category";s:5:"value";s:2:"73";s:7:"caption";s:8:"Category";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"4742";s:7:"post_id";s:3:"245";s:4:"term";s:8:"category";s:5:"value";s:1:"1";s:7:"caption";s:8:"Category";}}', 1419084320),
('categories_last2_246', 'O:8:"stdClass":5:{s:2:"id";s:4:"4146";s:7:"post_id";s:3:"246";s:4:"term";s:8:"category";s:5:"value";s:2:"73";s:7:"caption";s:8:"Category";}', 1419084320),
('locations_last2_246', 'O:8:"stdClass":5:{s:2:"id";s:4:"4144";s:7:"post_id";s:3:"246";s:4:"term";s:8:"location";s:5:"value";s:4:"9084";s:7:"caption";s:4:"City";}', 1419084320),
('locations_last_246', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"4144";s:7:"post_id";s:3:"246";s:4:"term";s:8:"location";s:5:"value";s:4:"9084";s:7:"caption";s:4:"City";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"4143";s:7:"post_id";s:3:"246";s:4:"term";s:8:"location";s:5:"value";s:1:"5";s:7:"caption";s:6:"Region";}}', 1419084320),
('locations_pk_9084', 'O:8:"stdClass":12:{s:2:"id";s:4:"9084";s:9:"parent_id";s:1:"5";s:7:"lineage";s:11:"00005-09084";s:4:"deep";s:1:"1";s:4:"name";s:9:"Fallbrook";s:10:"meta_title";s:41:"Find Business &amp; Services in Fallbrook";s:12:"meta_keyword";s:36:"Business &amp; Services in Fallbrook";s:16:"meta_description";s:235:"List of Business &amp; Services in Fallbrook, You can find all the Business &amp; Services in your local area with their Contact information, reviews and ratting, which will guide you to choose best Business &amp; Services in Fallbrook";s:4:"slug";s:9:"Fallbrook";s:6:"prefix";s:2:"CA";s:6:"status";s:2:"51";s:7:"popular";s:1:"0";}', 1419084320),
('categories_last_246', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"4146";s:7:"post_id";s:3:"246";s:4:"term";s:8:"category";s:5:"value";s:2:"73";s:7:"caption";s:8:"Category";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"4145";s:7:"post_id";s:3:"246";s:4:"term";s:8:"category";s:5:"value";s:1:"1";s:7:"caption";s:8:"Category";}}', 1419084320),
('settings_google_analytics', 's:394:"(function(i,s,o,g,r,a,m){i[''GoogleAnalyticsObject'']=r;i[r]=i[r]||function(){\n  (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),\n  m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)\n  })(window,document,''script'',''//www.google-analytics.com/analytics.js'',''ga'');\n\n  ga(''create'', ''UA-49935961-1'', ''pricegag.com'');\n  ga(''send'', ''pageview'');";', 1448028320),
('settings_site_logo', 's:15:"logo_150_45.png";', 1448028320),
('settings_office_contact_1', 's:14:"+91 9832893116";', 1448028320),
('post_total', 's:4:"1739";', 1419084320),
('settings_total', 's:5:"23268";', 1419084334),
('comments_total', 's:2:"27";', 1416578720),
('settings_social_twitter', 's:33:"http://twitter.com/matrixinfoline";', 1448028320),
('settings_social_facebook', 's:34:"http://facebook.com/matrixinfoline";', 1448028320),
('settings_social_linkdin', 's:33:"http://linkdin.com/matrixinfoline";', 1448028320),
('settings_social_google', 's:37:"http://plus.google.com/matrixinfoline";', 1448028320),
('categories_last2_8', 'O:8:"stdClass":5:{s:2:"id";s:4:"7417";s:7:"post_id";s:1:"8";s:4:"term";s:8:"category";s:5:"value";s:3:"134";s:7:"caption";s:8:"Category";}', 1419084320),
('locations_last2_8', 'O:8:"stdClass":5:{s:2:"id";s:4:"7415";s:7:"post_id";s:1:"8";s:4:"term";s:8:"location";s:5:"value";s:5:"24856";s:7:"caption";s:4:"City";}', 1419084320),
('locations_last_8', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"7415";s:7:"post_id";s:1:"8";s:4:"term";s:8:"location";s:5:"value";s:5:"24856";s:7:"caption";s:4:"City";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"7414";s:7:"post_id";s:1:"8";s:4:"term";s:8:"location";s:5:"value";s:2:"48";s:7:"caption";s:6:"Region";}}', 1419084320),
('categories_last_8', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"7417";s:7:"post_id";s:1:"8";s:4:"term";s:8:"category";s:5:"value";s:3:"134";s:7:"caption";s:8:"Category";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"7416";s:7:"post_id";s:1:"8";s:4:"term";s:8:"category";s:5:"value";s:2:"70";s:7:"caption";s:8:"Category";}}', 1419084320),
('categories_last2_6', 'O:8:"stdClass":5:{s:2:"id";s:4:"6332";s:7:"post_id";s:1:"6";s:4:"term";s:8:"category";s:5:"value";s:3:"144";s:7:"caption";s:8:"Category";}', 1419084320),
('locations_last2_6', 'O:8:"stdClass":5:{s:2:"id";s:4:"6330";s:7:"post_id";s:1:"6";s:4:"term";s:8:"location";s:5:"value";s:5:"21995";s:7:"caption";s:4:"City";}', 1419084320),
('locations_last_6', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"6330";s:7:"post_id";s:1:"6";s:4:"term";s:8:"location";s:5:"value";s:5:"21995";s:7:"caption";s:4:"City";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"6329";s:7:"post_id";s:1:"6";s:4:"term";s:8:"location";s:5:"value";s:2:"15";s:7:"caption";s:6:"Region";}}', 1419084320),
('categories_last_6', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"6332";s:7:"post_id";s:1:"6";s:4:"term";s:8:"category";s:5:"value";s:3:"144";s:7:"caption";s:8:"Category";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"6331";s:7:"post_id";s:1:"6";s:4:"term";s:8:"category";s:5:"value";s:2:"70";s:7:"caption";s:8:"Category";}}', 1419084320),
('categories_last2_5', 'O:8:"stdClass":5:{s:2:"id";s:4:"8390";s:7:"post_id";s:1:"5";s:4:"term";s:8:"category";s:5:"value";s:3:"144";s:7:"caption";s:8:"Category";}', 1419084320),
('locations_last2_5', 'O:8:"stdClass":5:{s:2:"id";s:4:"8388";s:7:"post_id";s:1:"5";s:4:"term";s:8:"location";s:5:"value";s:5:"24856";s:7:"caption";s:4:"City";}', 1419084320),
('locations_last_5', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"8388";s:7:"post_id";s:1:"5";s:4:"term";s:8:"location";s:5:"value";s:5:"24856";s:7:"caption";s:4:"City";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"8387";s:7:"post_id";s:1:"5";s:4:"term";s:8:"location";s:5:"value";s:2:"48";s:7:"caption";s:6:"Region";}}', 1419084320),
('categories_last_5', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"8390";s:7:"post_id";s:1:"5";s:4:"term";s:8:"category";s:5:"value";s:3:"144";s:7:"caption";s:8:"Category";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"8389";s:7:"post_id";s:1:"5";s:4:"term";s:8:"category";s:5:"value";s:2:"70";s:7:"caption";s:8:"Category";}}', 1419084320),
('categories_last2_50022', 'O:8:"stdClass":5:{s:2:"id";s:4:"9628";s:7:"post_id";s:5:"50022";s:4:"term";s:8:"category";s:5:"value";s:2:"81";s:7:"caption";s:8:"Category";}', 1419084320),
('locations_last2_50022', 'O:8:"stdClass":5:{s:2:"id";s:4:"9630";s:7:"post_id";s:5:"50022";s:4:"term";s:8:"location";s:5:"value";s:5:"15063";s:7:"caption";s:8:"Location";}', 1419084320),
('locations_last_50022', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"9630";s:7:"post_id";s:5:"50022";s:4:"term";s:8:"location";s:5:"value";s:5:"15063";s:7:"caption";s:8:"Location";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"9629";s:7:"post_id";s:5:"50022";s:4:"term";s:8:"location";s:5:"value";s:2:"32";s:7:"caption";s:8:"Location";}}', 1419084320),
('categories_last_50022', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"9628";s:7:"post_id";s:5:"50022";s:4:"term";s:8:"category";s:5:"value";s:2:"81";s:7:"caption";s:8:"Category";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"9627";s:7:"post_id";s:5:"50022";s:4:"term";s:8:"category";s:5:"value";s:2:"15";s:7:"caption";s:8:"Category";}}', 1419084320),
('categories_last2_50015', 'O:8:"stdClass":5:{s:2:"id";s:4:"9440";s:7:"post_id";s:5:"50015";s:4:"term";s:8:"category";s:5:"value";s:2:"81";s:7:"caption";s:8:"Category";}', 1419084320),
('locations_last2_50015', 'O:8:"stdClass":5:{s:2:"id";s:4:"9442";s:7:"post_id";s:5:"50015";s:4:"term";s:8:"location";s:5:"value";s:1:"2";s:7:"caption";s:8:"Location";}', 1419084320),
('locations_last_50015', 'a:1:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"9442";s:7:"post_id";s:5:"50015";s:4:"term";s:8:"location";s:5:"value";s:1:"2";s:7:"caption";s:8:"Location";}}', 1419084320),
('categories_last_50015', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"9440";s:7:"post_id";s:5:"50015";s:4:"term";s:8:"category";s:5:"value";s:2:"81";s:7:"caption";s:8:"Category";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"9439";s:7:"post_id";s:5:"50015";s:4:"term";s:8:"category";s:5:"value";s:2:"15";s:7:"caption";s:8:"Category";}}', 1419084320),
('categories_last2_49933', 'O:8:"stdClass":5:{s:2:"id";s:4:"4202";s:7:"post_id";s:5:"49933";s:4:"term";s:8:"category";s:5:"value";s:3:"144";s:7:"caption";s:8:"Category";}', 1419084320),
('locations_last2_49933', 'O:8:"stdClass":5:{s:2:"id";s:4:"4200";s:7:"post_id";s:5:"49933";s:4:"term";s:8:"location";s:5:"value";s:4:"3156";s:7:"caption";s:4:"City";}', 1419084320),
('locations_last_49933', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"4200";s:7:"post_id";s:5:"49933";s:4:"term";s:8:"location";s:5:"value";s:4:"3156";s:7:"caption";s:4:"City";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"4199";s:7:"post_id";s:5:"49933";s:4:"term";s:8:"location";s:5:"value";s:2:"48";s:7:"caption";s:6:"Region";}}', 1419084320),
('categories_last_49933', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"4202";s:7:"post_id";s:5:"49933";s:4:"term";s:8:"category";s:5:"value";s:3:"144";s:7:"caption";s:8:"Category";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"4201";s:7:"post_id";s:5:"49933";s:4:"term";s:8:"category";s:5:"value";s:2:"70";s:7:"caption";s:8:"Category";}}', 1419084320),
('categories_last2_49931', 'O:8:"stdClass":5:{s:2:"id";s:4:"4021";s:7:"post_id";s:5:"49931";s:4:"term";s:8:"category";s:5:"value";s:3:"144";s:7:"caption";s:8:"Category";}', 1419084320),
('locations_last2_49931', 'O:8:"stdClass":5:{s:2:"id";s:4:"4019";s:7:"post_id";s:5:"49931";s:4:"term";s:8:"location";s:5:"value";s:4:"1400";s:7:"caption";s:4:"City";}', 1419084320),
('locations_last_49931', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"4019";s:7:"post_id";s:5:"49931";s:4:"term";s:8:"location";s:5:"value";s:4:"1400";s:7:"caption";s:4:"City";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"4018";s:7:"post_id";s:5:"49931";s:4:"term";s:8:"location";s:5:"value";s:1:"3";s:7:"caption";s:6:"Region";}}', 1419084320),
('categories_last_49931', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"4021";s:7:"post_id";s:5:"49931";s:4:"term";s:8:"category";s:5:"value";s:3:"144";s:7:"caption";s:8:"Category";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"4020";s:7:"post_id";s:5:"49931";s:4:"term";s:8:"category";s:5:"value";s:2:"70";s:7:"caption";s:8:"Category";}}', 1419084320),
('categories_last2_49929', 'O:8:"stdClass":5:{s:2:"id";s:4:"4116";s:7:"post_id";s:5:"49929";s:4:"term";s:8:"category";s:5:"value";s:3:"144";s:7:"caption";s:8:"Category";}', 1419084320),
('locations_last2_49929', 'O:8:"stdClass":5:{s:2:"id";s:4:"4114";s:7:"post_id";s:5:"49929";s:4:"term";s:8:"location";s:5:"value";s:4:"3323";s:7:"caption";s:4:"City";}', 1419084320),
('locations_last_49929', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"4114";s:7:"post_id";s:5:"49929";s:4:"term";s:8:"location";s:5:"value";s:4:"3323";s:7:"caption";s:4:"City";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"4113";s:7:"post_id";s:5:"49929";s:4:"term";s:8:"location";s:5:"value";s:2:"22";s:7:"caption";s:6:"Region";}}', 1419084320),
('categories_last_49929', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"4116";s:7:"post_id";s:5:"49929";s:4:"term";s:8:"category";s:5:"value";s:3:"144";s:7:"caption";s:8:"Category";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"4115";s:7:"post_id";s:5:"49929";s:4:"term";s:8:"category";s:5:"value";s:2:"70";s:7:"caption";s:8:"Category";}}', 1419084320),
('categories_last2_49927', 'O:8:"stdClass":5:{s:2:"id";s:4:"2595";s:7:"post_id";s:5:"49927";s:4:"term";s:8:"category";s:5:"value";s:3:"144";s:7:"caption";s:8:"Category";}', 1419084320),
('locations_last2_49927', 'O:8:"stdClass":5:{s:2:"id";s:4:"2593";s:7:"post_id";s:5:"49927";s:4:"term";s:8:"location";s:5:"value";s:3:"719";s:7:"caption";s:4:"City";}', 1419084320),
('locations_last_49927', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"2593";s:7:"post_id";s:5:"49927";s:4:"term";s:8:"location";s:5:"value";s:3:"719";s:7:"caption";s:4:"City";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"2592";s:7:"post_id";s:5:"49927";s:4:"term";s:8:"location";s:5:"value";s:1:"2";s:7:"caption";s:6:"Region";}}', 1419084320),
('categories_last_49927', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"2595";s:7:"post_id";s:5:"49927";s:4:"term";s:8:"category";s:5:"value";s:3:"144";s:7:"caption";s:8:"Category";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"2594";s:7:"post_id";s:5:"49927";s:4:"term";s:8:"category";s:5:"value";s:2:"70";s:7:"caption";s:8:"Category";}}', 1419084320),
('categories_last2_49921', 'O:8:"stdClass":5:{s:2:"id";s:4:"3971";s:7:"post_id";s:5:"49921";s:4:"term";s:8:"category";s:5:"value";s:3:"144";s:7:"caption";s:8:"Category";}', 1419084320),
('locations_last2_49921', 'O:8:"stdClass":5:{s:2:"id";s:4:"3969";s:7:"post_id";s:5:"49921";s:4:"term";s:8:"location";s:5:"value";s:5:"21014";s:7:"caption";s:4:"City";}', 1419084320),
('locations_last_49921', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"3969";s:7:"post_id";s:5:"49921";s:4:"term";s:8:"location";s:5:"value";s:5:"21014";s:7:"caption";s:4:"City";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"3968";s:7:"post_id";s:5:"49921";s:4:"term";s:8:"location";s:5:"value";s:2:"10";s:7:"caption";s:6:"Region";}}', 1419084320),
('categories_last_49921', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"3971";s:7:"post_id";s:5:"49921";s:4:"term";s:8:"category";s:5:"value";s:3:"144";s:7:"caption";s:8:"Category";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"3970";s:7:"post_id";s:5:"49921";s:4:"term";s:8:"category";s:5:"value";s:2:"70";s:7:"caption";s:8:"Category";}}', 1419084320),
('categories_last2_49920', 'O:8:"stdClass":5:{s:2:"id";s:4:"4096";s:7:"post_id";s:5:"49920";s:4:"term";s:8:"category";s:5:"value";s:3:"144";s:7:"caption";s:8:"Category";}', 1419084320),
('locations_last2_49920', 'O:8:"stdClass":5:{s:2:"id";s:4:"4094";s:7:"post_id";s:5:"49920";s:4:"term";s:8:"location";s:5:"value";s:4:"2583";s:7:"caption";s:4:"City";}', 1419084320),
('locations_last_49920', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"4094";s:7:"post_id";s:5:"49920";s:4:"term";s:8:"location";s:5:"value";s:4:"2583";s:7:"caption";s:4:"City";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"4093";s:7:"post_id";s:5:"49920";s:4:"term";s:8:"location";s:5:"value";s:2:"37";s:7:"caption";s:6:"Region";}}', 1419084320),
('categories_last_49920', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"4096";s:7:"post_id";s:5:"49920";s:4:"term";s:8:"category";s:5:"value";s:3:"144";s:7:"caption";s:8:"Category";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"4095";s:7:"post_id";s:5:"49920";s:4:"term";s:8:"category";s:5:"value";s:2:"70";s:7:"caption";s:8:"Category";}}', 1419084320),
('categories_last2_49919', 'O:8:"stdClass":5:{s:2:"id";s:4:"4106";s:7:"post_id";s:5:"49919";s:4:"term";s:8:"category";s:5:"value";s:3:"144";s:7:"caption";s:8:"Category";}', 1419084320),
('locations_last2_49919', 'O:8:"stdClass":5:{s:2:"id";s:4:"4104";s:7:"post_id";s:5:"49919";s:4:"term";s:8:"location";s:5:"value";s:4:"3278";s:7:"caption";s:4:"City";}', 1419084320),
('locations_last_49919', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"4104";s:7:"post_id";s:5:"49919";s:4:"term";s:8:"location";s:5:"value";s:4:"3278";s:7:"caption";s:4:"City";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"4103";s:7:"post_id";s:5:"49919";s:4:"term";s:8:"location";s:5:"value";s:2:"15";s:7:"caption";s:6:"Region";}}', 1419084320),
('categories_last_49919', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"4106";s:7:"post_id";s:5:"49919";s:4:"term";s:8:"category";s:5:"value";s:3:"144";s:7:"caption";s:8:"Category";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"4105";s:7:"post_id";s:5:"49919";s:4:"term";s:8:"category";s:5:"value";s:2:"70";s:7:"caption";s:8:"Category";}}', 1419084320),
('categories_last2_49909', 'O:8:"stdClass":5:{s:2:"id";s:4:"3956";s:7:"post_id";s:5:"49909";s:4:"term";s:8:"category";s:5:"value";s:3:"144";s:7:"caption";s:8:"Category";}', 1419084320),
('locations_last2_49909', 'O:8:"stdClass":5:{s:2:"id";s:4:"3954";s:7:"post_id";s:5:"49909";s:4:"term";s:8:"location";s:5:"value";s:4:"7046";s:7:"caption";s:4:"City";}', 1419084320),
('locations_last_49909', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"3954";s:7:"post_id";s:5:"49909";s:4:"term";s:8:"location";s:5:"value";s:4:"7046";s:7:"caption";s:4:"City";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"3953";s:7:"post_id";s:5:"49909";s:4:"term";s:8:"location";s:5:"value";s:2:"10";s:7:"caption";s:6:"Region";}}', 1419084320),
('categories_last_49909', 'a:2:{i:0;O:8:"stdClass":5:{s:2:"id";s:4:"3956";s:7:"post_id";s:5:"49909";s:4:"term";s:8:"category";s:5:"value";s:3:"144";s:7:"caption";s:8:"Category";}i:1;O:8:"stdClass":5:{s:2:"id";s:4:"3955";s:7:"post_id";s:5:"49909";s:4:"term";s:8:"category";s:5:"value";s:2:"70";s:7:"caption";s:8:"Category";}}', 1419084320),
('settings_office_company', 's:32:"Matrix Infoline Private Limited.";', 1448028321),
('settings_office_address', 's:28:"Siliguri, West Bengal, India";', 1448028321),
('settings_office_contact_2', 's:14:"+91 9832893116";', 1448028321),
('settings_office_email', 's:24:"infolinematrix@gmail.com";', 1448028321),
('settings_footer_text', 's:71:"National advertising powered by matrixinfoline.com All Rights Reserved.";', 1448028321);

-- --------------------------------------------------------

--
-- Table structure for table `categories`
--

CREATE TABLE IF NOT EXISTS `categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `lineage` varchar(100) NOT NULL,
  `deep` int(11) NOT NULL DEFAULT '0',
  `name` varchar(100) NOT NULL,
  `top` tinyint(4) NOT NULL DEFAULT '0',
  `description` longtext NOT NULL,
  `meta_title` varchar(80) NOT NULL,
  `meta_keyword` varchar(250) NOT NULL,
  `meta_description` varchar(250) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '51',
  `icon` varchar(50) DEFAULT NULL,
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  `popular` enum('0','1') NOT NULL,
  PRIMARY KEY (`id`),
  KEY `parent_id` (`parent_id`,`slug`,`name`),
  KEY `deep` (`deep`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8999551 ;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `parent_id`, `lineage`, `deep`, `name`, `top`, `description`, `meta_title`, `meta_keyword`, `meta_description`, `slug`, `status`, `icon`, `updated_at`, `created_at`, `popular`) VALUES
(8999513, 0, '8999513', 0, 'Services', 0, 'This is a testing category', 'Services Meta title', 'Services Meta Keyword', 'Services Meta Description ', 'services', 51, 'fa-area-chart', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0'),
(8999514, 8999513, '8999513-8999514', 1, 'Testing Services', 0, '', 'Top secret!', 'Top secret!', '', 'testing-services', 51, '-----Select-----', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1'),
(8999541, 8999514, '8999513-8999514-8999541', 2, 'Testing Services 1', 0, '', 'Top secret!', 'Top secret!', '', 'testing-services-1', 51, '-----Select-----', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0'),
(8999542, 8999514, '8999513-8999514-8999542', 2, 'Testing Services 2', 0, '', 'Top secret!', 'Top secret!', '', 'testing-services-2', 51, '-----Select-----', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0'),
(8999543, 8999514, '8999513-8999514-8999543', 2, 'Testing Services 3', 0, '', 'Top secret!', 'Top secret!', '', 'testing-services-3', 51, '-----Select-----', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0'),
(8999544, 0, '8999544', 0, 'Automotive Parts & Accessories', 0, 'Automotive Parts & Accessories', 'Automotive Parts & Accessories', 'Automotive Parts & Accessories', 'Automotive Parts & Accessories', 'automotive-parts-accessories', 51, 'fa-bus', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0'),
(8999545, 8999544, '8999544-8999545', 1, 'Cars, Trucks & Suvs', 0, 'Cars, Trucks & Suvs', 'Cars, Trucks & Suvs', 'Cars, Trucks & Suvs', 'Cars, Trucks & Suvs', 'cars-trucks-suvs', 51, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0'),
(8999546, 8999545, '8999544-8999545-8999546', 2, 'Car Alarm', 0, 'Car Alarm', 'Car Alarm', 'Car Alarm', 'Car Alarm', 'car-alarm', 51, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0'),
(8999547, 8999545, '8999544-8999545-8999547', 2, 'Car Audio', 0, 'Car Audio', 'Car Audio', 'Car Audio', 'Car Audio', 'car-audio', 51, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0'),
(8999548, 8999545, '8999544-8999545-8999548', 2, 'Car Starter', 0, 'Car Starter', 'Car Starter', 'Car Starter', 'Car Starter', 'car-starter', 51, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0'),
(8999549, 0, '8999549', 0, 'Consumer Electronics', 0, 'Consumer Electronics', 'Consumer Electronics', 'Consumer Electronics', 'Consumer Electronics', 'consumer-electronics', 51, 'fa-area-chart', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0'),
(8999550, 8999549, '8999549-8999550', 1, 'Kitchenware', 0, 'Kitchenware', 'Kitchenware', 'Kitchenware', 'Kitchenware', 'kitchenware', 51, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0');

-- --------------------------------------------------------

--
-- Table structure for table `comments`
--

CREATE TABLE IF NOT EXISTS `comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `post_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `contact` varchar(25) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '51',
  `comment` text NOT NULL,
  `location` varchar(200) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `ratting` tinyint(4) NOT NULL DEFAULT '0',
  `ip_address` varchar(15) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `post_id` (`post_id`,`email`,`status`),
  KEY `ratting` (`ratting`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `comments`
--

INSERT INTO `comments` (`id`, `post_id`, `name`, `email`, `contact`, `status`, `comment`, `location`, `created_at`, `updated_at`, `ratting`, `ip_address`) VALUES
(2, 1710, 'Rahul Sinha', 'rahul@gmail.com', '454564564165', 51, 'This is a testing description for this business this is a testing description for this business ', '', '2015-09-30 13:27:43', '2015-09-30 13:27:43', 3, '127.0.0.1');

-- --------------------------------------------------------

--
-- Table structure for table `emailtemplate`
--

CREATE TABLE IF NOT EXISTS `emailtemplate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) CHARACTER SET utf8 NOT NULL,
  `type` varchar(100) CHARACTER SET utf8 NOT NULL,
  `description` longtext CHARACTER SET utf8 NOT NULL,
  `status` int(11) NOT NULL DEFAULT '51',
  `variable` varchar(25) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `title` (`title`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;



-- --------------------------------------------------------

--
-- Table structure for table `featured`
--

CREATE TABLE IF NOT EXISTS `featured` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `post_id` int(11) NOT NULL,
  `plan` int(11) NOT NULL DEFAULT '0',
  `valid_upto` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_FEATURED` (`post_id`,`plan`,`valid_upto`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=40 ;

--
-- Dumping data for table `featured`
--

INSERT INTO `featured` (`id`, `post_id`, `plan`, `valid_upto`) VALUES
(39, 1710, 2, '2016-09-29');

-- --------------------------------------------------------

--
-- Table structure for table `gallery`
--

CREATE TABLE IF NOT EXISTS `gallery` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `post_id` int(11) NOT NULL DEFAULT '0',
  `term` enum('photo','banner','video','file') NOT NULL DEFAULT 'photo',
  `value` text,
  `caption` varchar(50) NOT NULL DEFAULT 'Caption',
  `title` varchar(150) NOT NULL DEFAULT 'Title of Image',
  `status` int(11) NOT NULL DEFAULT '51',
  PRIMARY KEY (`id`),
  KEY `term` (`term`),
  KEY `post_id` (`post_id`),
  KEY `status` (`status`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

--
-- Table structure for table `lang`
--

CREATE TABLE IF NOT EXISTS `lang` (
  `type` enum('admin','front') NOT NULL DEFAULT 'admin',
  `lang` varchar(4) NOT NULL,
  `variable` varchar(15) NOT NULL,
  `value` text NOT NULL,
  PRIMARY KEY (`type`,`lang`,`variable`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Language Table';

--
-- Dumping data for table `lang`
--

INSERT INTO `lang` (`type`, `lang`, `variable`, `value`) VALUES
('admin', 'eng', 'category', 'Category'),
('admin', 'eng', 'category_list', 'Category List');

-- --------------------------------------------------------

--
-- Table structure for table `laravel_migrations`
--

CREATE TABLE IF NOT EXISTS `laravel_migrations` (
  `bundle` varchar(50) NOT NULL,
  `name` varchar(200) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`bundle`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `laravel_migrations`
--

INSERT INTO `laravel_migrations` (`bundle`, `name`, `batch`) VALUES
('application', '2014_06_28_092902_create_session_table', 1),
('admin', '2013_02_17_050003_create_roles_table', 2),
('admin', '2013_02_17_050100_create_permissions_table', 3),
('admin', '2013_02_17_050110_create_permission_role_table', 3);

-- --------------------------------------------------------

--
-- Table structure for table `locations`
--

CREATE TABLE IF NOT EXISTS `locations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `lineage` varchar(100) NOT NULL,
  `deep` int(11) NOT NULL DEFAULT '0',
  `name` varchar(150) NOT NULL,
  `meta_title` varchar(80) NOT NULL,
  `meta_keyword` varchar(250) NOT NULL,
  `meta_description` text CHARACTER SET latin1 NOT NULL,
  `slug` varchar(150) NOT NULL,
  `prefix` varchar(4) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '51',
  `popular` enum('0','1') NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `parent_id` (`parent_id`,`status`,`name`,`slug`),
  KEY `populer` (`popular`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=30946 ;

--
-- Dumping data for table `locations`
--

INSERT INTO `locations` (`id`, `parent_id`, `lineage`, `deep`, `name`, `meta_title`, `meta_keyword`, `meta_description`, `slug`, `prefix`, `status`, `popular`) VALUES
(30944, 0, '30944', 0, 'Tamil Nadu', 'Tamil Nadu', 'Tamil Nadu', 'Tamil Nadu', 'tamil-nadu', NULL, 51, '0'),
(30945, 30944, '30944-30945', 1, 'Chennai', 'Chennai', 'Chennai', 'Chennai', 'chennai', NULL, 51, '0');

-- --------------------------------------------------------

--
-- Table structure for table `membership`
--

CREATE TABLE IF NOT EXISTS `membership` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `period` int(11) NOT NULL,
  `description` longtext NOT NULL,
  `contact_no` int(11) NOT NULL DEFAULT '0',
  `contact_person` int(11) NOT NULL DEFAULT '0',
  `email` int(11) NOT NULL DEFAULT '0',
  `website` int(11) NOT NULL DEFAULT '0',
  `video` int(11) NOT NULL DEFAULT '0',
  `photo` int(11) NOT NULL DEFAULT '0',
  `products` int(11) NOT NULL DEFAULT '0',
  `keyword_limit` varchar(20) NOT NULL,
  `photo_limit` varchar(20) NOT NULL,
  `video_limit` varchar(20) NOT NULL,
  `products_limit` varchar(20) NOT NULL,
  `price` varchar(20) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `membership`
--

INSERT INTO `membership` (`id`, `name`, `period`, `description`, `contact_no`, `contact_person`, `email`, `website`, `video`, `photo`, `products`, `keyword_limit`, `photo_limit`, `video_limit`, `products_limit`, `price`, `status`) VALUES
(1, 'Free Listing', 3, 'Free Listing Membership', 0, 0, 0, 0, 1, 1, 1, '1', '3', '5', '3', '0', 0),
(2, 'Premium Listing', 365, 'Premium Listing Membership', 1, 1, 1, 1, 1, 1, 1, '2', '4', '2', '2', '10.895232', 0);

-- --------------------------------------------------------

--
-- Table structure for table `messages`
--

CREATE TABLE IF NOT EXISTS `messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` enum('ENQ','WRN') NOT NULL DEFAULT 'ENQ',
  `post_id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(150) NOT NULL,
  `email` varchar(150) NOT NULL,
  `contact` varchar(25) NOT NULL,
  `location` int(11) NOT NULL DEFAULT '0',
  `description` text NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `ip_address` varchar(16) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '51',
  PRIMARY KEY (`id`),
  KEY `post_id` (`post_id`,`email`,`location`,`status`),
  KEY `location` (`location`),
  KEY `type` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `modules`
--

CREATE TABLE IF NOT EXISTS `modules` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `variable` varchar(200) NOT NULL,
  `module` varchar(200) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '51',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `modules`
--

INSERT INTO `modules` (`id`, `variable`, `module`, `status`) VALUES
(1, 'review', 'Review', 51);

-- --------------------------------------------------------

--
-- Table structure for table `pages`
--

CREATE TABLE IF NOT EXISTS `pages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(80) CHARACTER SET utf8 NOT NULL,
  `slug` varchar(150) CHARACTER SET utf8 NOT NULL,
  `content` text CHARACTER SET utf8 NOT NULL,
  `meta_title` text CHARACTER SET utf8 NOT NULL,
  `meta_description` varchar(250) CHARACTER SET utf8 NOT NULL,
  `meta_keyword` varchar(250) CHARACTER SET utf8 NOT NULL,
  `created_at` datetime NOT NULL,
  `modified_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `slug` (`slug`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`id`, `title`, `slug`, `content`, `meta_title`, `meta_description`, `meta_keyword`, `created_at`, `modified_at`) VALUES
(1, 'About Us', 'about', 'A complete website design featuring various single page templates from Start Bootstraps library of free HTML starter templates. A complete website design featuring various single page templates from Start Bootstraps library of free HTML starter templates. A complete website design featuring various single page templates from Start Bootstraps library of free HTML starter templates.', 'About Us - Yellow Pages Script version 4', 'A complete website design featuring various single page templates from Start Bootstraps', 'aboutus', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(2, 'Terms & Conditions', 'terms', 'Here is the Terms and Conditions', 'Terms and Conditions - Yellow Pages Script Meta title', 'Terms and Conditions - Yellow Pages Script Meta Description ', 'Terms and Conditions - Yellow Pages Script Meta Keyword', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(3, 'Our Services', 'services', 'Here is our Services', 'Our Services - Yellow Pages Script Version 4', 'Our Services - Yellow Pages Script Version 4 meta Description ', 'Our Services -  Yellow Pages Script Version 4 meta keyword', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(5, 'Company Description', 'company-description', '<b>{companyname}</b> is situated at <b>{companyaddress}</b>. <b>{companyname}</b> deals in products and services related to <b>{comp_productlist}</b>. <b>{companyname}</b> is one of the pioneer business in <b>{company_city}</b>. We have a fully equipped in-house development which enable us to develop special products and services such as <b>{comp_productlist}</b> as per the requirements of customers. Our staff is also well educated and well trained. You will be fully satisfied with out products and services. We provide a good support for our new as well as existing customers. You may email us at any time and can call us anytime during our office timing. We will surely respond to your query as soon as possible. Kindly mention this website name -<b>{weburl}</b> whenever you call or mail us.', 'ypage company description meta title', '\r\n\r\nypage company description meta description', 'ypage company description meta keyword', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(6, 'FAQ', 'faq', 'Your Faq', 'Faq - Yellow Pages Script Version 4 Meta Title', 'Faq - Yellow Pages Script Version 4 Meta Description ', 'Faq - Yellow Pages Script Version 4 Meta Keyword', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(7, 'Privacy Policy', 'privacy-policy', '&nbsp;\r\n\r\n	Privacy Policy:\r\n\r\n	&nbsp;', 'Privacy Policy of Yellow Pages Script Version 4 ', 'Privacy Policy Meta Description of Yellow Pages Script Version 4 ', 'Privacy Policy Meta Keyword of Yellow Pages Script Version 4', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(8, 'Disclaimer', 'disclaimer', '<p>    Your Sisclaimer</p>', 'meta title', 'meta description', 'meta keyword', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(9, 'Why Us', 'why-us', 'Your Why us', 'Why Us - Yellow Pages Script Version 4 Meta title', 'Why Us - Yellow Pages Script Version 4 Meta description', 'Why Us - Yellow Pages Script Version 4 Meta keyword', '0000-00-00 00:00:00', '0000-00-00 00:00:00');

-- --------------------------------------------------------

--
-- Table structure for table `paypal`
--

CREATE TABLE IF NOT EXISTS `paypal` (
  `id` int(11) NOT NULL DEFAULT '0',
  `user_id` varchar(250) NOT NULL,
  `currency_code` varchar(50) NOT NULL,
  `paypal_live` varchar(50) NOT NULL,
  `ipn_log` varchar(50) NOT NULL,
  `status` int(11) NOT NULL,
  `paypal` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `paypal`
--

INSERT INTO `paypal` (`id`, `user_id`, `currency_code`, `paypal_live`, `ipn_log`, `status`, `paypal`) VALUES
(1, 'phprhl@gmail.com', 'USD', 'FALSE', 'TRUE', 51, 'ACTIVE');

-- --------------------------------------------------------

--
-- Table structure for table `paypal_payment`
--

CREATE TABLE IF NOT EXISTS `paypal_payment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(250) NOT NULL,
  `last_name` varchar(250) NOT NULL,
  `payer_email` varchar(250) NOT NULL,
  `mc_currency` varchar(20) NOT NULL,
  `payment_gross` varchar(20) NOT NULL,
  `payment_date` varchar(150) NOT NULL,
  `post_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=68 ;

--
-- Dumping data for table `paypal_payment`
--

INSERT INTO `paypal_payment` (`id`, `first_name`, `last_name`, `payer_email`, `mc_currency`, `payment_gross`, `payment_date`, `post_id`) VALUES
(5, 'Subha Test', 'Das', 'pptestmatrix@gmail.com', 'USD', '10.00', '02:49:35 Jan 10, 2015 PST', 229),
(6, 'Subha Test', 'Das', 'pptestmatrix@gmail.com', 'USD', '10.00', '04:07:38 Jan 16, 2015 PST', 230),
(7, 'Subha Test', 'Das', 'pptestmatrix@gmail.com', 'USD', '10.20', '02:16:53 Jan 22, 2015 PST', 1693),
(67, 'Subha Test', 'Das', 'pptestmatrix@gmail.com', 'USD', '10.20', '00:14:31 Sep 30, 2015 PDT', 1708),
(66, 'Subha Test', 'Das', 'pptestmatrix@gmail.com', 'USD', '10.20', '00:28:12 Sep 29, 2015 PDT', 1699),
(65, 'Subha Test', 'Das', 'pptestmatrix@gmail.com', 'USD', '10.20', '23:36:34 Sep 14, 2015 PDT', 1700),
(64, 'Subha Test', 'Das', 'pptestmatrix@gmail.com', 'USD', '10.20', '23:24:57 Sep 14, 2015 PDT', 1700),
(63, 'Subha Test', 'Das', 'pptestmatrix@gmail.com', 'USD', '10.20', '23:19:40 Sep 14, 2015 PDT', 1699),
(62, 'Subha Test', 'Das', 'pptestmatrix@gmail.com', 'USD', '10.20', '06:20:20 Sep 12, 2015 PDT', 1698),
(57, 'Subha Test', 'Das', 'pptestmatrix@gmail.com', 'USD', '10.20', '03:53:10 Sep 12, 2015 PDT', 1695),
(58, 'Subha Test', 'Das', 'pptestmatrix@gmail.com', 'USD', '10.20', '04:23:49 Sep 12, 2015 PDT', 1696),
(59, 'Subha Test', 'Das', 'pptestmatrix@gmail.com', 'USD', '10.20', '05:47:18 Sep 12, 2015 PDT', 1697),
(60, 'Subha Test', 'Das', 'pptestmatrix@gmail.com', 'USD', '10.00', '06:01:40 Sep 12, 2015 PDT', 1697),
(61, 'Subha Test', 'Das', 'pptestmatrix@gmail.com', 'USD', '10.20', '06:04:19 Sep 12, 2015 PDT', 1697);

-- --------------------------------------------------------

--
-- Table structure for table `permissions`
--

CREATE TABLE IF NOT EXISTS `permissions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `description` varchar(200) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `description`, `created_at`, `updated_at`) VALUES
(1, 'Manage Users', 'Access user management in admin panel', '2014-07-02 06:05:53', '2014-07-02 06:05:53'),
(2, 'Manage Pages', 'Access page management in admin panel', '2014-07-02 06:05:53', '2014-07-02 06:05:53'),
(3, 'Manage Categories', 'Access category management in admin panel', '2014-07-02 06:05:53', '2014-07-02 06:05:53'),
(4, 'Manage Menu', 'Access menu management in admin panel', '2014-07-02 06:05:53', '2014-07-02 06:05:53');

-- --------------------------------------------------------

--
-- Table structure for table `permission_role`
--

CREATE TABLE IF NOT EXISTS `permission_role` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `permission_id` int(10) unsigned NOT NULL,
  `role_id` int(10) unsigned NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `permission_role_permission_id_foreign` (`permission_id`),
  KEY `permission_role_role_id_foreign` (`role_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `permission_role`
--

INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES
(1, 1, 1, '2014-07-02 06:05:53', '2014-07-02 06:05:53'),
(2, 2, 1, '2014-07-02 06:05:53', '2014-07-02 06:05:53'),
(3, 3, 1, '2014-07-02 06:05:53', '2014-07-02 06:05:53'),
(4, 4, 1, '2014-07-02 06:05:53', '2014-07-02 06:05:53');

-- --------------------------------------------------------

--
-- Table structure for table `post`
--

CREATE TABLE IF NOT EXISTS `post` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `users_id` int(11) DEFAULT NULL,
  `title` varchar(150) NOT NULL,
  `address1` varchar(100) DEFAULT NULL,
  `address2` varchar(100) DEFAULT NULL,
  `phone1` text,
  `phone2` varchar(100) DEFAULT NULL,
  `fax` varchar(25) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `website` varchar(50) DEFAULT NULL,
  `tollfree` varchar(15) DEFAULT NULL,
  `slug` varchar(150) DEFAULT NULL,
  `meta_title` varchar(100) NOT NULL,
  `meta_description` varchar(255) NOT NULL,
  `meta_keyword` varchar(255) NOT NULL,
  `status` int(2) NOT NULL DEFAULT '51',
  `description` text NOT NULL,
  `services` text NOT NULL,
  `verified` int(11) NOT NULL DEFAULT '0',
  `contact_name` varchar(100) DEFAULT NULL,
  `contact_no` varchar(50) DEFAULT NULL,
  `contact_name2` varchar(100) NOT NULL,
  `contact_no2` varchar(50) NOT NULL,
  `expires_on` date NOT NULL,
  `logo` varchar(350) NOT NULL DEFAULT 'no-logo.jpg',
  `zip_code` varchar(25) DEFAULT NULL,
  `long` double NOT NULL DEFAULT '0',
  `lat` double NOT NULL DEFAULT '0',
  `hit` int(11) NOT NULL DEFAULT '0',
  `plan` int(11) NOT NULL DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `status` (`status`),
  KEY `MAIN_INDEX` (`title`,`status`),
  KEY `user_id` (`users_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1712 ;

--
-- Dumping data for table `post`
--

INSERT INTO `post` (`id`, `users_id`, `title`, `address1`, `address2`, `phone1`, `phone2`, `fax`, `email`, `website`, `tollfree`, `slug`, `meta_title`, `meta_description`, `meta_keyword`, `status`, `description`, `services`, `verified`, `contact_name`, `contact_no`, `contact_name2`, `contact_no2`, `expires_on`, `logo`, `zip_code`, `long`, `lat`, `hit`, `plan`, `created_at`, `updated_at`) VALUES
(1710, 13, 'R. Sinha &amp; Co&#039;mpany.', 'New No. 19, Paramasiva Chetty Street, Park Town,', '', '55555555555', NULL, NULL, 'test@gmail.com', NULL, NULL, 'r-sinha-amp-co039mpany', 'R. Sinha &amp; Co&#039;mpany.', 'R. Sinha &amp; Co&#039;mpany., Stainless Steel Kitchenware And Utensiles Stainless Steel Kitchenware And Utensiles Kitchenware', 'R. Sinha &amp; Co&#039;mpany., Stainless Steel Kitchenware And Utensiles Stainless Steel Kitchenware And Utensiles Kitchenware', 51, '', 'Stainless Steel Kitchenware And Utensiles Stainless Steel Kitchenware And Utensiles Kitchenware', 0, 'Mr. A  Murugesans', '914425354218/24997731(R)', '', '', '0000-00-00', 'no-logo.jpg', '600001', 0, 0, 0, 2, '2015-09-30 13:23:59', NULL),
(1711, 13, 'this is a testing', 'Chennai Central', '', '12123123', '', '', 'admin@admin.com', '', '', 'this-is-a-testing', 'this is a testing', 'this is a testing', 'this is a testing', 1, 'test', '', 0, '', '', '', '', '0000-00-00', 'no-logo.jpg', '', 80.2623025, 13.122955, 0, 2, '2015-12-03 17:20:59', '2015-12-03 17:20:59');

-- --------------------------------------------------------

--
-- Table structure for table `postrequirement`
--

CREATE TABLE IF NOT EXISTS `postrequirement` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category` int(11) NOT NULL,
  `description` longtext NOT NULL,
  `location` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `email` varchar(250) NOT NULL,
  `phone_no` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=31 ;

-- --------------------------------------------------------

--
-- Table structure for table `products`
--

CREATE TABLE IF NOT EXISTS `products` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `post_id` int(11) NOT NULL,
  `category` varchar(200) NOT NULL,
  `title` varchar(100) NOT NULL,
  `slug` varchar(200) NOT NULL,
  `description` text NOT NULL,
  `price` varchar(15) NOT NULL,
  `image` varchar(150) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `post_id` (`post_id`,`status`),
  KEY `title` (`title`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `post_id`, `category`, `title`, `slug`, `description`, `price`, `image`, `status`) VALUES
(16, 1710, '8999513', 'TVS PVT.LTD', 'tvs-pvtltd', 'this is a testing products description ', 'Rs 8500000', '2e91ccca192d82161ff981462d86bf54.jpg', 51);

-- --------------------------------------------------------

--
-- Table structure for table `report`
--

CREATE TABLE IF NOT EXISTS `report` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `post_id` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `email` varchar(300) NOT NULL,
  `contact` varchar(50) NOT NULL,
  `location` varchar(200) NOT NULL,
  `type` enum('ENQ','INQ','CLAIM') NOT NULL DEFAULT 'ENQ',
  `title` varchar(250) NOT NULL,
  `description` longtext NOT NULL,
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ip_address` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `post_id` (`post_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `roles`
--

CREATE TABLE IF NOT EXISTS `roles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `description` varchar(200) DEFAULT NULL,
  `weight` int(11) NOT NULL DEFAULT '1',
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `description`, `weight`, `created_at`, `updated_at`) VALUES
(1, 'Admin', 'Admins have all permissions', 0, '2014-07-02 06:05:53', '2014-07-02 06:05:53'),
(4, 'Normal', 'Normal users can change profile information', 15, '2014-07-02 06:05:53', '2014-07-02 06:05:53');

-- --------------------------------------------------------

--
-- Table structure for table `sessions`
--

CREATE TABLE IF NOT EXISTS `sessions` (
  `id` varchar(40) NOT NULL,
  `last_activity` int(11) NOT NULL,
  `data` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `settings`
--

CREATE TABLE IF NOT EXISTS `settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `variable` varchar(50) NOT NULL,
  `value` text,
  `lang` varchar(3) NOT NULL DEFAULT 'en',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `variable` (`variable`,`lang`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=76 ;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `variable`, `value`, `lang`, `created_at`, `updated_at`) VALUES
(1, 'site_title', 'Yellow Pages Script', 'en', NULL, '2015-05-13 16:22:06'),
(2, 'site_logo', 'logo_150_45.png', 'en', NULL, '2014-11-05 08:20:52'),
(3, 'site_mode', '1', 'en', NULL, '2015-05-13 16:22:06'),
(4, 'post_approval', '0', 'en', NULL, NULL),
(5, 'image_approval', '1', 'en', NULL, NULL),
(6, 'video_approval', '1', 'en', NULL, NULL),
(7, 'default_location', 'USA', 'en', NULL, '2015-05-13 16:22:06'),
(8, 'review_approval', '1', 'en', NULL, NULL),
(9, 'meta_title', 'Yellow Page Business Directory Script', 'en', NULL, '2015-05-13 16:22:06'),
(10, 'meta_keyword', 'Yellow Pages, Business Directory, Local Business', 'en', NULL, '2015-05-13 16:22:06'),
(11, 'meta_description', 'Yellow Page Business Directory is Open Business directory for all.', 'en', NULL, '2015-05-13 16:22:07'),
(12, 'social_facebook', 'https://www.facebook.com/yellowpagebusinessdirectory', 'en', NULL, '2015-04-09 19:33:46'),
(13, 'social_twitter', 'http://twitter.com/matrixinfoline', 'en', NULL, '2015-04-09 19:33:46'),
(14, 'social_google', 'http://plus.google.com/matrixinfoline', 'en', NULL, '2015-04-09 19:33:46'),
(15, 'social_linkdin', 'http://linkdin.com/matrixinfoline', 'en', NULL, '2015-04-09 19:33:46'),
(21, 'timezone', 'Asia/Calcutta', 'en', NULL, '2015-05-11 19:34:14'),
(28, 'mail_smtp', '0', 'en', '2014-10-18 11:45:22', '2015-02-28 11:29:56'),
(29, 'mail_smtp_auth', '1', 'en', '2014-10-18 11:49:00', '2015-02-28 11:29:56'),
(30, 'mail_smtp_host', 'smtp.gmail.com', 'en', '2014-10-18 11:49:00', '2015-02-28 11:29:56'),
(31, 'mail_smtp_ssl', '1', 'en', '2014-10-18 11:49:01', '2015-02-28 11:29:56'),
(32, 'mail_smtp_port', '465', 'en', '2014-10-18 11:49:01', '2015-02-28 11:29:56'),
(33, 'mail_smtp_user', 'infolinematrix@gmail.com', 'en', '2014-10-18 11:49:01', '2015-02-28 11:29:56'),
(34, 'mail_smtp_password', 'abcd1234', 'en', '2014-10-18 11:49:01', '2015-02-28 11:29:56'),
(35, 'mail_smtp_footer', 'We are the No#1 yellow pages portal .. <a href=''http://www.yellowpagesphpscript.com''> Click here<a>', 'en', '2014-10-18 11:49:01', '2015-02-28 11:29:56'),
(36, 'seo_home_title', 'Home Meta Title', 'en', '2014-10-18 15:29:50', '2014-10-18 15:41:48'),
(37, 'seo_home_keyword', 'Home Meta Keyword', 'en', '2014-10-18 15:36:56', '2014-10-18 15:41:48'),
(38, 'seo_home_description', 'Home Meta Description', 'en', '2014-10-18 15:37:10', '2014-10-18 15:41:48'),
(39, 'seo_listing_title', 'All {category} in {location}', 'en', '2014-10-18 15:37:25', '2015-05-07 17:49:10'),
(40, 'seo_listing_keyword', '{category}, {location}, {location} yellow page, {location} local business directory', 'en', '2014-10-18 15:37:46', '2015-05-07 17:49:10'),
(41, 'seo_listing_description', 'List of all business and services in {location} yellow page, find their contact no, email, reviews etc. all business of this {category}', 'en', '2014-10-18 15:37:46', '2015-05-07 17:49:11'),
(42, 'seo_search_title', 'HELLO FROM DATA BASE {location} in {category}', 'en', '2014-10-18 15:39:58', '2015-05-07 17:49:11'),
(43, 'seo_search_keyword', '{title} in  {location} listed in {category}', 'en', '2014-10-18 15:39:58', '2015-05-07 17:49:11'),
(44, 'seo_search_description', '{title} in  {location} listed in {category}', 'en', '2014-10-18 15:39:58', '2015-05-07 17:49:11'),
(47, 'short_date_format', 'd-M-Y', 'en', '2014-10-18 16:06:57', '2015-05-11 19:34:14'),
(48, 'long_date_format', 'd-m-Y h:m:s', 'en', '2014-10-18 16:06:57', '2015-05-11 19:34:14'),
(49, 'currecy_symbol', 'USD', 'en', '2014-10-18 16:06:57', '2015-05-11 19:34:14'),
(50, 'currency_decimal', '2', 'en', '2014-10-18 16:06:57', '2015-05-11 19:34:14'),
(51, 'adsense_pub_id', 'ca-pub-5079663447907991', 'en', NULL, NULL),
(52, 'office_address', 'Balaidas Chetterjee Length, Rajanikanth Sarani, Hakim Para,Siliguri, West Bengal, India', 'en', NULL, '2015-04-11 10:57:55'),
(53, 'office_contact_1', '+91 9832893116', 'en', NULL, '2015-04-11 10:57:56'),
(54, 'office_contact_2', '+91 9832893116', 'en', NULL, '2015-04-11 10:57:56'),
(55, 'office_email', 'infolinematrix@gmail.com', 'en', NULL, '2015-04-11 10:57:56'),
(56, 'footer_text', 'National advertising powered by matrixinfoline.com All Rights Reserved.', 'en', NULL, '2015-05-13 16:22:07'),
(57, 'office_company', 'Matrix Infoline Private Limited.', 'en', NULL, '2015-04-11 10:57:55'),
(58, 'notify_admin_registration', 'on', 'en', NULL, '2014-11-05 12:04:51'),
(59, 'notify_admin_post', 'on', 'en', NULL, '2014-11-05 12:04:51'),
(60, 'notify_admin_comment', 'on', 'en', NULL, '2014-11-05 12:04:51'),
(61, 'notify_admin_incorrect', 'on', 'en', NULL, '2014-11-05 12:04:51'),
(62, 'mod_post', 'on', 'en', NULL, '2014-11-05 12:04:51'),
(63, 'mod_comment', 'on', 'en', NULL, '2014-11-05 12:04:51'),
(64, 'mod_photo', 'on', 'en', NULL, '2014-11-05 12:04:51'),
(65, 'mod_video', 'on', 'en', NULL, '2014-11-05 12:04:51'),
(66, 'notify_user_registration', 'on', 'en', NULL, '2014-11-05 12:04:51'),
(67, 'notify_user_post', 'on', 'en', NULL, '2014-11-05 12:04:51'),
(68, 'site_slogan', 'Best Yellow Pages Script', 'en', NULL, '2015-05-13 16:22:06'),
(69, 'charecter_set', 'UTF-8', 'en', '2014-11-05 12:11:14', '2015-05-11 19:34:14'),
(70, 'google_analytics', '<script>\r\n(function(i,s,o,g,r,a,m){i[''GoogleAnalyticsObject'']=r;i[r]=i[r]||function(){\r\n  (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),\r\n  m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)\r\n  })(window,document,''script'',''//www.google-analytics.com/analytics.js'',''ga'');\r\n\r\n  ga(''create'', ''UA-49935961-1'', ''pricegag.com'');\r\n  ga(''send'', ''pageview'');\r\n\r\n</script>', 'en', NULL, '2015-05-13 16:22:07'),
(71, 'publisher_id', 'ca-pub-5079663447907991', 'en', NULL, '2015-05-13 16:22:07'),
(72, 'default_email', 'infolinematrix@gmail.com', 'en', '2014-11-19 00:24:00', '2015-02-28 11:29:56'),
(73, 'currency', '$', 'en', NULL, '2015-05-11 19:34:14'),
(74, 'publisher_id_approve', '1', 'en', NULL, '2015-05-13 16:22:07'),
(75, 'currnecy', '$', 'en', '2015-01-22 15:33:33', '2015-01-22 15:33:33');

-- --------------------------------------------------------

--
-- Table structure for table `subscribe`
--

CREATE TABLE IF NOT EXISTS `subscribe` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(300) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ip` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `subscribe`
--

INSERT INTO `subscribe` (`id`, `email`, `date`, `ip`) VALUES
(7, 'phprhl@gmail.com', '2014-12-04 10:40:03', '127.0.0.1');

-- --------------------------------------------------------

--
-- Table structure for table `terms`
--

CREATE TABLE IF NOT EXISTS `terms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `post_id` int(11) NOT NULL,
  `term` varchar(20) NOT NULL,
  `value` int(11) NOT NULL DEFAULT '0',
  `caption` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `INQ` (`post_id`,`term`,`value`),
  KEY `post_id` (`post_id`,`term`,`value`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=19340 ;

--
-- Dumping data for table `terms`
--

INSERT INTO `terms` (`id`, `post_id`, `term`, `value`, `caption`) VALUES
(19331, 1710, 'category', 8999549, 'Category'),
(19333, 1710, 'location', 30944, 'Country'),
(19334, 1710, 'location', 30945, 'Region'),
(19335, 1711, 'category', 8999513, 'Category'),
(19336, 1711, 'category', 8999514, 'Category'),
(19337, 1711, 'category', 8999541, 'Category'),
(19338, 1711, 'location', 30944, 'Location'),
(19339, 1711, 'location', 30945, 'Location');

-- --------------------------------------------------------

--
-- Table structure for table `visitor`
--

CREATE TABLE IF NOT EXISTS `visitor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `post_id` int(11) NOT NULL,
  `ip` varchar(50) NOT NULL,
  `date` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=139 ;

--
-- Dumping data for table `visitor`
--

INSERT INTO `visitor` (`id`, `post_id`, `ip`, `date`) VALUES
(1, 20, '127.0.0.1', '2015-01-26'),
(2, 22, '127.0.0.1', '2015-01-26'),
(3, 23, '127.0.0.1', '2015-01-26'),
(4, 22, '127.0.0.1', '2015-01-28'),
(5, 23, '127.0.0.1', '2015-01-28'),
(6, 23, '127.0.0.1', '2015-01-31'),
(7, 23, '127.0.0.1', '2015-02-02'),
(8, 20, '127.0.0.1', '2015-02-02'),
(9, 23, '127.0.0.1', '2015-02-03'),
(10, 22, '127.0.0.1', '2015-02-03'),
(11, 51, '127.0.0.1', '2015-02-03'),
(12, 52, '127.0.0.1', '2015-02-03'),
(13, 52, '127.0.0.1', '2015-02-04'),
(14, 52, '127.0.0.1', '2015-02-05'),
(15, 52, '127.0.0.1', '2015-02-06'),
(16, 52, '127.0.0.1', '2015-02-07'),
(17, 53, '127.0.0.1', '2015-02-07'),
(18, 52, '127.0.0.1', '2015-02-10'),
(19, 52, '127.0.0.1', '2015-02-12'),
(20, 52, '127.0.0.1', '2015-02-16'),
(21, 52, '127.0.0.1', '2015-02-20'),
(22, 52, '127.0.0.1', '2015-02-25'),
(23, 52, '127.0.0.1', '2015-02-27'),
(24, 52, '127.0.0.1', '2015-02-28'),
(25, 52, '127.0.0.1', '2015-03-02'),
(26, 52, '127.0.0.1', '2015-03-09'),
(27, 52, '127.0.0.1', '2015-03-10'),
(28, 52, '127.0.0.1', '2015-03-11'),
(29, 52, '127.0.0.1', '2015-03-12'),
(30, 56, '127.0.0.1', '2015-03-12'),
(31, 57, '127.0.0.1', '2015-03-13'),
(32, 56, '127.0.0.1', '2015-03-13'),
(33, 57, '127.0.0.1', '2015-03-14'),
(34, 56, '127.0.0.1', '2015-03-14'),
(35, 56, '127.0.0.1', '2015-03-16'),
(36, 57, '127.0.0.1', '2015-03-16'),
(37, 57, '127.0.0.1', '2015-03-17'),
(38, 57, '127.0.0.1', '2015-03-18'),
(39, 56, '127.0.0.1', '2015-03-18'),
(40, 56, '127.0.0.1', '2015-03-20'),
(41, 57, '127.0.0.1', '2015-03-24'),
(42, 56, '127.0.0.1', '2015-03-24'),
(43, 56, '127.0.0.1', '2015-03-30'),
(44, 57, '127.0.0.1', '2015-04-01'),
(45, 2284, '127.0.0.1', '2015-04-06'),
(46, 3561, '127.0.0.1', '2015-04-06'),
(47, 57, '127.0.0.1', '2015-04-07'),
(48, 57, '127.0.0.1', '2015-04-08'),
(49, 58, '127.0.0.1', '2015-04-10'),
(50, 57, '127.0.0.1', '2015-04-10'),
(51, 57, '127.0.0.1', '2015-04-11'),
(52, 67, '127.0.0.1', '2015-04-13'),
(53, 150, '127.0.0.1', '2015-04-13'),
(54, 149, '127.0.0.1', '2015-04-13'),
(55, 153, '127.0.0.1', '2015-04-13'),
(56, 57, '127.0.0.1', '2015-04-13'),
(57, 160, '127.0.0.1', '2015-04-13'),
(58, 162, '127.0.0.1', '2015-04-13'),
(59, 170, '127.0.0.1', '2015-04-13'),
(60, 172, '127.0.0.1', '2015-04-13'),
(61, 171, '127.0.0.1', '2015-04-13'),
(62, 175, '127.0.0.1', '2015-04-13'),
(63, 174, '127.0.0.1', '2015-04-13'),
(64, 176, '127.0.0.1', '2015-04-13'),
(65, 176, '127.0.0.1', '2015-05-08'),
(66, 176, '127.0.0.1', '2015-05-12'),
(67, 175, '127.0.0.1', '2015-05-12'),
(68, 177, '127.0.0.1', '2015-05-12'),
(69, 181, '127.0.0.1', '2015-05-13'),
(70, 181, '127.0.0.1', '2015-05-15'),
(71, 185, '127.0.0.1', '2015-05-16'),
(72, 187, '127.0.0.1', '2015-05-16'),
(73, 180, '127.0.0.1', '2015-05-16'),
(74, 186, '127.0.0.1', '2015-05-16'),
(75, 181, '127.0.0.1', '2015-05-16'),
(76, 189, '127.0.0.1', '2015-05-16'),
(77, 180, '127.0.0.1', '2015-05-18'),
(78, 189, '127.0.0.1', '2015-05-21'),
(79, 199, '127.0.0.1', '2015-05-21'),
(80, 200, '127.0.0.1', '2015-05-21'),
(81, 198, '127.0.0.1', '2015-05-21'),
(82, 197, '127.0.0.1', '2015-06-06'),
(83, 200, '127.0.0.1', '2015-06-06'),
(84, 198, '127.0.0.1', '2015-06-06'),
(85, 197, '127.0.0.1', '2015-06-09'),
(86, 198, '127.0.0.1', '2015-06-09'),
(87, 197, '127.0.0.1', '2015-06-10'),
(88, 200, '127.0.0.1', '2015-06-10'),
(89, 202, '127.0.0.1', '2015-06-10'),
(90, 198, '127.0.0.1', '2015-06-10'),
(91, 197, '127.0.0.1', '2015-06-12'),
(92, 200, '127.0.0.1', '2015-06-12'),
(93, 198, '127.0.0.1', '2015-06-12'),
(94, 200, '127.0.0.1', '2015-06-18'),
(95, 198, '127.0.0.1', '2015-06-18'),
(96, 197, '127.0.0.1', '2015-06-18'),
(97, 198, '127.0.0.1', '2015-06-19'),
(98, 200, '127.0.0.1', '2015-06-19'),
(99, 200, '192.168.0.104', '2015-06-19'),
(100, 200, '127.0.0.1', '2015-06-20'),
(101, 200, '192.168.0.104', '2015-06-20'),
(102, 200, '127.0.0.1', '2015-06-22'),
(103, 198, '127.0.0.1', '2015-06-22'),
(104, 200, '127.0.0.1', '2015-06-24'),
(105, 198, '127.0.0.1', '2015-06-24'),
(106, 200, '127.0.0.1', '2015-06-25'),
(107, 200, '127.0.0.1', '2015-06-26'),
(108, 200, '127.0.0.1', '2015-07-01'),
(109, 198, '127.0.0.1', '2015-07-04'),
(110, 200, '127.0.0.1', '2015-07-16'),
(111, 200, '127.0.0.1', '2015-07-20'),
(112, 198, '127.0.0.1', '2015-07-20'),
(113, 200, '127.0.0.1', '2015-07-21'),
(114, 198, '127.0.0.1', '2015-07-21'),
(115, 198, '127.0.0.1', '2015-07-27'),
(116, 200, '127.0.0.1', '2015-07-27'),
(117, 198, '127.0.0.1', '2015-08-11'),
(118, 218, '127.0.0.1', '2015-08-11'),
(119, 220, '127.0.0.1', '2015-08-17'),
(120, 214, '127.0.0.1', '2015-08-19'),
(121, 220, '127.0.0.1', '2015-08-20'),
(122, 214, '127.0.0.1', '2015-08-20'),
(123, 198, '127.0.0.1', '2015-08-20'),
(124, 218, '127.0.0.1', '2015-08-25'),
(125, 224, '127.0.0.1', '2015-08-25'),
(126, 220, '127.0.0.1', '2015-08-25'),
(127, 198, '127.0.0.1', '2015-08-25'),
(128, 224, '127.0.0.1', '2015-08-27'),
(129, 1692, '127.0.0.1', '2015-09-04'),
(130, 230, '127.0.0.1', '2015-09-12'),
(131, 230, '127.0.0.1', '2015-09-14'),
(132, 230, '127.0.0.1', '2015-09-23'),
(133, 230, '127.0.0.1', '2015-09-28'),
(134, 1699, '127.0.0.1', '2015-09-29'),
(135, 1708, '127.0.0.1', '2015-09-30'),
(136, 230, '127.0.0.1', '2015-09-30'),
(137, 1710, '127.0.0.1', '2015-09-30'),
(138, 1710, '127.0.0.1', '2015-12-03');

-- --------------------------------------------------------

--
-- Table structure for table `widgets`
--

CREATE TABLE IF NOT EXISTS `widgets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(150) NOT NULL,
  `description` text NOT NULL,
  `created_at` datetime NOT NULL,
  `modified_at` datetime NOT NULL,
  `enable` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `enable` (`enable`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `widgets`
--

INSERT INTO `widgets` (`id`, `title`, `description`, `created_at`, `modified_at`, `enable`) VALUES
(1, 'Popular Locations', 'List of Popular location Based on Most Viewed, Reviewed and No of Posts.\r\n', '2014-10-14 00:00:00', '2014-10-10 00:00:00', 1);

-- --------------------------------------------------------

--
-- Table structure for table `working_hours`
--

CREATE TABLE IF NOT EXISTS `working_hours` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `post_id` int(11) NOT NULL,
  `mon` varchar(50) NOT NULL DEFAULT 'CLOSED',
  `tues` varchar(50) NOT NULL DEFAULT 'CLOSED',
  `wed` varchar(50) NOT NULL DEFAULT 'CLOSED',
  `thurs` varchar(50) NOT NULL DEFAULT 'CLOSED',
  `fri` varchar(50) DEFAULT 'CLOSED',
  `sat` varchar(50) NOT NULL DEFAULT 'CLOSED',
  `sun` varchar(50) NOT NULL DEFAULT 'CLOSED',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=24 ;

--
-- Dumping data for table `working_hours`
--

INSERT INTO `working_hours` (`id`, `post_id`, `mon`, `tues`, `wed`, `thurs`, `fri`, `sat`, `sun`) VALUES
(18, 197, '02:00 AM - 02:00 AM', '02:00 AM - 02:00 AM', '02:00 AM - 02:00 AM', '02:00 AM - 02:00 AM', '02:00 AM - 02:00 AM', '02:00 AM - 02:00 AM', 'CLOSED'),
(17, 200, '03:00 AM to 03:00 AM', '03:00 AM to 03:00 AM', '03:00 AM to 03:00 AM', 'CLOSED', 'CLOSED', 'CLOSED', 'CLOSED'),
(19, 198, '06:00 AM to 08:00 PM', '10:00 AM to 08:00 PM', 'CLOSED', 'CLOSED', '03:00 AM to 03:00 AM', 'CLOSED', 'CLOSED'),
(20, 222, '07:00 AM - 08:00 PM', '03:00 AM - 09:00 PM', '04:00 AM - 08:00 PM', 'CLOSED', 'CLOSED', 'CLOSED', 'CLOSED'),
(21, 223, '05:00 AM - 09:00 PM', '09:00 AM - 05:00 PM', '06:00 AM - 02:00 AM', '07:00 AM - 02:00 PM', 'CLOSED', 'CLOSED', 'CLOSED'),
(22, 216, '05:00 AM - 08:00 PM', '01:00 AM - 09:00 PM', '02:00 AM - 10:00 PM', '02:00 AM - 11:00 PM', '02:00 AM - 12:00 PM', '04:00 AM - 11:00 PM', '07:00 AM - 09:00 PM'),
(23, 220, '07:00 AM to 12:00 AM', '03:00 AM to 12:00 AM', '03:00 AM to 12:00 AM', 'CLOSED', 'CLOSED', 'CLOSED', 'CLOSED');

--
-- Constraints for dumped tables
--

--
-- Constraints for table `comments`
--
ALTER TABLE `comments`
  ADD CONSTRAINT `comments_ibfk_1` FOREIGN KEY (`post_id`) REFERENCES `post` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `featured`
--
ALTER TABLE `featured`
  ADD CONSTRAINT `featured_ibfk_1` FOREIGN KEY (`post_id`) REFERENCES `post` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `messages`
--
ALTER TABLE `messages`
  ADD CONSTRAINT `messages_ibfk_1` FOREIGN KEY (`post_id`) REFERENCES `post` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `messages_ibfk_2` FOREIGN KEY (`location`) REFERENCES `locations` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `post`
--
ALTER TABLE `post`
  ADD CONSTRAINT `post_ibfk_1` FOREIGN KEY (`users_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_ibfk_1` FOREIGN KEY (`post_id`) REFERENCES `post` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `report`
--
ALTER TABLE `report`
  ADD CONSTRAINT `report_ibfk_1` FOREIGN KEY (`post_id`) REFERENCES `post` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `terms`
--
ALTER TABLE `terms`
  ADD CONSTRAINT `terms_ibfk_1` FOREIGN KEY (`post_id`) REFERENCES `post` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

