-- phpMyAdmin SQL Dump
-- version 3.5.2.2
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Dec 17, 2012 at 12:52 PM
-- Server version: 5.5.27
-- PHP Version: 5.4.7

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `market`
--

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

--
-- Table structure for table `mk_advertises`
--

CREATE TABLE IF NOT EXISTS `mk_advertises` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `website` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `title` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `alias` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `summary` tinytext COLLATE utf8_unicode_ci,
  `content` text COLLATE utf8_unicode_ci,
  `image` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `category_id` int(11) NOT NULL,
  `created` int(11) DEFAULT NULL,
  `updated` int(11) DEFAULT NULL,
  `city_id` int(11) DEFAULT NULL,
  `province_id` int(11) DEFAULT NULL,
  `published` tinyint(1) NOT NULL DEFAULT '0',
  `ordering` int(11) DEFAULT NULL,
  `negotiable` tinyint(1) DEFAULT '0',
  `total_view` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=54 ;

--
-- Dumping data for table `mk_advertises`
--

INSERT INTO `mk_advertises` (`id`, `website`, `email`, `user_id`, `title`, `alias`, `summary`, `content`, `image`, `type`, `category_id`, `created`, `updated`, `city_id`, `province_id`, `published`, `ordering`, `negotiable`, `total_view`) VALUES
(2, NULL, 'pndtam@gmail.com', 1, 'abcd', 'abcd', 'abc', 'def', '15fc7bc19277da666d96a9175f8a9810.jpg', 'job', 34, 1354357171, 1354357171, 3, 2, 1, 2, NULL, 0),
(21, NULL, 'tam_duy24@yahoo.com', 13, 'Jobs', 'jobs', 'adsf', 'asdf', '298699_10151112067008948_794452286_n.jpg', 'job', 34, 1354604764, 1354604764, 4631, 3533, 1, 1, NULL, 6),
(22, NULL, 'ci.freemarket@gmail.com', 1, 'Job 1', 'job-1', 'asdf', 'asdf', 'untitled.JPG', 'job', 34, 1354603756, 1354676272, 4631, 3533, 1, 2, NULL, 4),
(23, NULL, 'tam_duy24@yahoo.com', 13, 'Services', 'services', 'sadf', 'asdf', '295933_419002658135639_1931300556_n1.jpg', 'service', 32, 1354607997, 1354678428, 4631, 3533, 1, 1, NULL, 13),
(24, NULL, 'pndtam@yahoo.com', 1, 'Services 1', 'services-1', 'asdf', '<p>asdf</p>', '298699_10151112067008948_794452286_n1.jpg', 'service', 32, 1354608328, 1355044511, 4631, 3533, 0, 2, NULL, 4),
(25, NULL, 'ci.freemarket@gmail.com', 1, 'Verhicles 1', 'verhicles-1', 'asdf1', 'asdf1', '295933_419002658135639_1931300556_n2.jpg', 'verhicle', 35, 1354615009, 1354615009, 4631, 3533, 1, 11, NULL, 8),
(26, NULL, 'tam_duy24@yahoo.com', 1, 'Buy_sell', 'buy_sell', 'asdf', '<p>asdf</p>', '429238_507910452555060_2810174_n.jpg', 'buy_sell', 31, 1354617336, 1355045442, 4631, 3533, 1, 1, 1, 0),
(31, NULL, 'pndtam@gmail.com', 1, 'Properties', 'properties', 'asdf', 'asdf', '295933_419002658135639_1931300556_n8.jpg', 'property', 33, 1354677520, 1354678456, 4631, 3533, 1, 1, NULL, 0),
(35, NULL, 'tam_duy24@yahoo.com', 1, 'asda', 'asd', 'adasd', 'adasd', '', 'job', 34, 1354959367, 1354959972, 0, 3530, 1, 0, 0, 0),
(37, NULL, 'tam_duy24@yahoo.com', 1, 'asdasd', 'asdasd', 'adada', '<p>asdasda</p>', 'default_avatar2.jpg', 'verhicle', 35, 1354962071, 1355044475, 0, 0, 1, 0, 0, 0),
(39, 'assad', 'ranger.ht@gmail.com', 13, 'ss', '', 'asdsad', '<p>asdsad</p>', NULL, 'property', 33, NULL, 1355114989, 0, 3532, 1, 0, 1, 2),
(40, '', 'ranger.ht@gmail.com', 13, 'asd', '', 'sda', '<p>adad</p>', '', 'buy_sell', 30, NULL, 1355399490, 0, 0, 1, 0, 1, 0),
(41, '', 'ranger.ht@gmail.com', 13, 'asdasd', '', 'asda', '<p>asdsad</p>', 'arrow_left_off.png', 'buy_sell', 30, NULL, 1355456010, 0, 3532, 1, 0, 1, 0),
(44, '', 'ranger.ht@gmail.com', 13, 'asdad', '', 'adad', '<p>asdad</p>', 'change_step_12.png', 'bussiness', 38, 1355132119, 1355133485, 0, 3531, 1, 0, 1, 0),
(45, NULL, 'pndtam@gmail.com', 1, 'ssdsd', 'ssdsd', 'ewr', '<p>&nbsp;erer</p>', 'avatar.jpg', 'buy_sell', 31, 1355194827, 1355194827, 0, 3532, 1, 0, 0, 0),
(46, '', 'ranger.ht@gmail.com', 13, 'asda', '', 'adasd', '<p>adad</p>', 'avatar1.jpg', 'buy_sell', 30, 1355280770, 1355280806, 0, 3399, 1, 0, 1, 0),
(47, 'asdf', 'phamduytam@yahoo.com', 20, 'asldf', '', 'asdf', 'asdf<br>', '298699_10151112067008948_794452286_n3.jpg', 'job', 34, 1355387673, NULL, 4642, 3403, 0, NULL, 1, 0),
(48, 'http://hoanvusolutions.com/dentist/payment-option', 'ptmhuu@gmail.com', 21, 'test', '', 'Dental Insurance Accepted\nWe accept most insurance PPO plans including Aetna, Ameritas, Assurant, Blue Cross Blue Shield, Delta Dental, Guardian, Metlife, Regence, United Health Care and Washington Dental Service. \n\nPlease call our office prior to your fi', '<strong  14px; line-height: 20px;">Dental Insurance Accepted</strong><br  14px; line-height: 20px;"><span  14px; line-height: 20px;">We accept most insurance PPO plans including Aetna, Ameritas, Assurant, Blue Cross Blue Shield, Delta Dental, Guardian, Metlife, Regence, United Health Care and Washington Dental Service.&nbsp;</span><br  14px; line-height: 20px;"><br  14px; line-height: 20px;"><span  14px; line-height: 20px;">Please call our office prior to your first visit to give us your insurance information.&nbsp;</span>', 'c39c37d39e9102b7cec7126ea325dc7e.jpg', 'service', 32, 1355396702, NULL, 43099, 3585, 0, NULL, 1, 0),
(49, '', 'ptmhuu@gmail.com', 21, 'TEST TEST', '', 'Please call our office prior to your first visit to give us your insurance information. \n\nWe will gladly file the insurance paper work for you and work with you to get you the maximum insurance benefit.', '<p>http://hoanvusolutions.com/dentist/payment-option</p>', 'c39c37d39e9102b7cec7126ea325dc7e1.jpg', 'service', 32, 1355396876, 1355398620, 43098, 3584, 1, 0, 1, 0),
(50, NULL, NULL, 1, 'Sài Gòn Queen Spa', 'sai-gon-queen-spa', 'Thư Giãn Và Chăm Sóc Cơ Thể Với Liệu Trình Massage Body Đá Nóng Núi Lửa Với Tinh Dầu 100% Thiên Nhiên Và Đắp Sáp Nóng Paraffin Đôi Chân Tại Sài Gòn Queen Spa. Voucher 450.000 VNĐ, Còn 85.000 VNĐ, Giảm 81 %. Chỉ', '<p>&nbsp;Thư gi&atilde;n v&agrave; chăm s&oacute;c cơ thể với liệu tr&igrave;nh Massage body đ&aacute; n&oacute;ng n&uacute;i lửa với tinh dầu 100% thi&ecirc;n nhi&ecirc;n v&agrave; đắp s&aacute;p n&oacute;ng paraffin đ&ocirc;i ch&acirc;n tại s&agrave;i g&ograve;n Queen Spa.</p>', 'TN135537449050c95f9a79717.jpg', 'buy_sell', 41, 1355456243, 1355456243, 43103, 3587, 1, 0, 0, 0),
(51, NULL, NULL, 1, 'Rock Water Bay Resort', 'rock-water-bay-resort', 'Tận Hưởng Kỳ Nghỉ 2N1Đ Dành Cho 2 Người Tại Rock Water Bay Beach Resort & Spa, Phòng Deluxe Ocean View Villa, Ăn Tối Và Dịch Vụ Spa. Voucher 3.190.000 VNĐ, Còn 1.250.000 VNĐ, Giảm 61 %. Chỉ Có Tại Hotdeal.vn!', '<p>&nbsp;Tận hưởng kỳ nghỉ 2N1Đ d&agrave;nh cho 2 người tại Rock Water Bay Beach Resort &amp; Spa, ph&ograve;ng Duluxe Ocean View Villa, Ăn tối v&agrave; Dịch Vụ Spa.</p>', 'thumb135536772750c9452fe5ce7.jpg', 'buy_sell', 41, 1355457292, 1355457317, 43102, 3586, 0, 0, 0, 0),
(52, NULL, NULL, 1, 'testtesst', 'testtesst', 'test test test test test', '<p>test test</p>', '', 'buy_sell', 45, 1355457879, 1355458251, 43103, 3587, 1, 0, 0, 0),
(53, 'sadf', '123@yahoo.com', 8, 'sdf', '', 'asdf', '<p>Tại kỳ họp HĐND Hà N&ocirc;̣i vừa qua, thảo luận về Nghị quyết về tổng  bi&ecirc;n chế h&agrave;nh ch&iacute;nh, sự nghiệp của H&agrave; Nội, &ocirc;ng Trần Trọng Dực, Chủ nhiệm  Uỷ ban Kiểm tra Th&agrave;nh uỷ H&agrave; Nội đã có phát bi&ecirc;̉u khi&ecirc;́n dư lu&acirc;̣n  thực sự s&ocirc;́c. &ldquo;Ch&uacute;ng t&ocirc;i ph&aacute;t hiện ra 2 gi&aacute;o vi&ecirc;n c&oacute; đ&aacute;nh dấu b&agrave;i của  th&iacute; sinh để chấm b&agrave;i. T&ocirc;i đ&atilde; y&ecirc;u cầu l&atilde;nh đạo trường đ&agrave;o tạo c&aacute;n bộ L&ecirc;  Hồng Phong phải kiểm điểm v&agrave; xem x&eacute;t tr&aacute;ch nhiệm với hai gi&aacute;o vi&ecirc;n n&agrave;y&rdquo;.  &Ocirc;ng Dực nhận định: &ldquo;B&acirc;y giờ người ta n&oacute;i rằng  dưới 100 triệu kh&ocirc;ng đỗ  đ&acirc;u&hellip; Chất lượng thi c&ocirc;ng chức kh&ocirc;ng ổn một t&yacute; n&agrave;o  vậy lấy g&igrave; đảm bảo  chất lượng?&rdquo;.</p>\n<p>Kể lại sự việc n&agrave;y với chúng t&ocirc;i, một nh&acirc;n chứng trong kỳ thi n&oacute;i  tr&ecirc;n (xin gi&acirc;́u t&ecirc;n) cho bi&ecirc;́t: Đầu năm 2012, kỳ thi c&ocirc;ng chức diễn ra  tại đơn vị m&agrave; anh đang được đ&agrave;o tạo. &ldquo;Đ&acirc;y cũng l&agrave; l&uacute;c &ldquo;sếp trưởng&rdquo; sắp  về  hưu n&ecirc;n ai muốn đỗ c&ocirc;ng chức đều tranh thủ &ldquo;quan hệ&rdquo; với sếp. Tuy  nhi&ecirc;n, mọi việc qu&aacute; lộ liễu, cấp tr&ecirc;n cử đo&agrave;n thanh tra về theo d&otilde;i kỳ  thi. Kết quả, đường d&acirc;y bị lộ, 2 gi&aacute;m thị bị đề nghị kỷ luật, những  người đ&atilde; &ldquo;chạy&rdquo; đều l&acirc;m cảnh tiền mất tật mang&rdquo;.</p>\n<p><img src="http://hcm.24h.com.vn/upload/4-2012/images/2012-12-14/1355467440-cong-chuc-3.jpg" alt="Kh&ocirc;ng tiền đừng &ldquo;mơ&rdquo; c&ocirc;ng chức, Tin tức trong ng&agrave;y, thi cong chuc, tuyen dung, chay cong chuc, chat luong can bo cong chuc, noi vu, Uy Ban Kiem tra thanh uy Ha Noi...." class="news-image" /></p>\n<p color:="" font-style:="">Đăng k&yacute; dự thi c&ocirc;ng chức cấp huyện (Ảnh minh họa)</p>\n<p>V&ecirc;̀ ph&aacute;t biểu của &ocirc;ng Trần Trọng Dực tại phi&ecirc;n họp HĐND&nbsp;TP.Hà  N&ocirc;̣i, &ocirc;ng B&ugrave;i Kh&aacute;nh Thụy, nguy&ecirc;n chuy&ecirc;n vi&ecirc;n cao cấp Ủy ban Kiểm tra TƯ  Đảng cho rằng chắc chắn vị chủ nhiệm Ủy ban Kiểm tra Th&agrave;nh ủy phải c&oacute; cơ  sở, c&oacute; bằng chứng r&otilde; r&agrave;ng về việc n&agrave;y.</p>', '295933_419002658135639_1931300556_n18.jpg', 'buy_sell', 227, 1355491343, 1355491368, 43100, 3586, 1, 0, 1, 0);

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

--
-- Table structure for table `mk_blogs`
--

CREATE TABLE IF NOT EXISTS `mk_blogs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `alias` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `summary` text COLLATE utf8_unicode_ci NOT NULL,
  `content` text COLLATE utf8_unicode_ci NOT NULL,
  `created` int(11) NOT NULL,
  `ordering` int(11) NOT NULL,
  `published` tinyint(1) NOT NULL,
  `type` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `image` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=15 ;

--
-- Dumping data for table `mk_blogs`
--

INSERT INTO `mk_blogs` (`id`, `title`, `alias`, `summary`, `content`, `created`, `ordering`, `published`, `type`, `image`) VALUES
(1, 'test1', 'test1', 'asd', 'asdf', 1354768300, 1, 1, 'blogs', ''),
(3, 'About us', 'about-us', '0', 'asdf \r\nasdf\r\nasd\r\nasdf\r\n', 1354774268, 1, 1, 'about_us', ''),
(4, '5 States Home To 50% Of Foreclosure Activity Nationwide', '5-states-homes-to-50-of-foreclosure', 'Foreclosure pipelines are re-filling nationwide. According to data from RealtyTrac, a national foreclosure-tracking firm, the number of foreclosure filings dipped below 192,000 in July 2012, a 3 percent decrease from the month prior. RealtyTrac defines a "foreclosure filing" as any foreclosure-related action, including a Notice of Default, a Scheduled Auction, or a Bank Repossession. July marks the 22nd straight month during which foreclosure filings fell on a year-over-year basis. At … ', 'Foreclosure pipelines are re-filling nationwide. According to data from RealtyTrac, a national foreclosure-tracking firm, the number of foreclosure filings dipped below 192,000 in July 2012, a 3 percent decrease from the month prior. RealtyTrac defines a "foreclosure filing" as any foreclosure-related action, including a Notice of Default, a Scheduled Auction, or a Bank Repossession. July marks the 22nd straight month during which foreclosure filings fell on a year-over-year basis. At … ', 1354936340, 2, 1, 'blogs', '295933_419002658135639_1931300556_n.jpg'),
(5, 'asdf', 'asdf', '0', '<p>asdf</p>', 1355300803, 0, 1, 'follow_us_on_twitter', ''),
(6, 'sadf', 'sadf', '0', '<p>sdf</p>', 1355300810, 0, 1, 'follow_us_on_twitter', ''),
(7, 'disclaimer', 'disclaimer', '0', '<p>&nbsp;asdsdsd</p>', 1355403081, 0, 1, 'disclaimer', ''),
(8, 'privacy_policy', 'privacy_policy', '0', '<p>&nbsp;sss</p>', 1355403097, 0, 1, 'privacy_policy', ''),
(9, 'Site map', 'site-map', '0', '<p>site map</p>', 1355451495, 0, 1, 'site_map', ''),
(10, 'Terms and Conditions', 'terms-and-conditions', '0', '<p>sadf</p>', 1355451512, 0, 1, 'terms_and_conditions', ''),
(11, 'testface', 'testface', '0', '<p>test</p>', 1355454982, 0, 1, 'follow_us_on_facebook', ''),
(12, 'Restricted Items', 'restricted-items', '0', '<p>sdf</p>', 1355484120, 0, 1, 'restricted_items', ''),
(13, 'For your safety', 'for-your-safety', '0', '<p>for your safety</p>', 1355484150, 0, 1, 'for_your_safety', ''),
(14, 'Dos and Donts', 'dos-and-donts', '0', '<p>dos and donts</p>', 1355484177, 0, 1, 'dos_and_donts', '');

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

--
-- Table structure for table `mk_bussiness`
--

CREATE TABLE IF NOT EXISTS `mk_bussiness` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adv_id` int(11) NOT NULL,
  `classification` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `address` tinytext COLLATE utf8_unicode_ci NOT NULL,
  `poster_type` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `contact` tinytext COLLATE utf8_unicode_ci NOT NULL,
  `price` float NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `mk_bussiness`
--

INSERT INTO `mk_bussiness` (`id`, `adv_id`, `classification`, `address`, `poster_type`, `contact`, `price`) VALUES
(1, 44, 'Free Membership', 'adsasdsss', 'Agent', 'adadassd', 123212000);

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

--
-- Table structure for table `mk_buysell`
--

CREATE TABLE IF NOT EXISTS `mk_buysell` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adv_id` int(11) NOT NULL,
  `item_number` int(11) NOT NULL,
  `title` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `condition` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `price` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `regular_price` float DEFAULT NULL,
  `type` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=13 ;

--
-- Dumping data for table `mk_buysell`
--

INSERT INTO `mk_buysell` (`id`, `adv_id`, `item_number`, `title`, `condition`, `price`, `regular_price`, `type`) VALUES
(3, 26, 3, '', 'New', '1', 1, 0),
(5, 40, 5, '', 'New', '123123', 0, 0),
(6, 41, 6, '', 'New', '232', 0, 0),
(7, 45, 123213, '', 'New', '123', 1223, 0),
(8, 46, 8, '', 'Old', '123213', 12323, 0),
(9, 50, 0, '', 'New', '85.000', 0, 0),
(10, 51, 10, '', 'New', '1.250.000', 0, 0),
(11, 52, 10, '', 'New', '1200', 0, 0),
(12, 53, 12, '', 'New', '12123', 0, 0);

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

--
-- Table structure for table `mk_categories`
--

CREATE TABLE IF NOT EXISTS `mk_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL,
  `title` varchar(250) NOT NULL,
  `alias` varchar(250) NOT NULL,
  `published` tinyint(1) NOT NULL,
  `ordering` int(11) NOT NULL,
  `type` varchar(40) NOT NULL,
  `created` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=511 ;

--
-- Dumping data for table `mk_categories`
--

INSERT INTO `mk_categories` (`id`, `parent_id`, `title`, `alias`, `published`, `ordering`, `type`, `created`) VALUES
(30, 0, 'Antiques', '0', 1, 2, 'buy_sell', 1355475336),
(31, 0, 'Arts and Crafts', '0', 1, 1, 'buy_sell', 1355475352),
(32, 0, 'Accounting', '0', 1, 4, 'service', 1355544181),
(33, 0, 'Apartments', '0', 1, 1, 'property', 1355544526),
(34, 0, 'Accounting and Finance', '0', 1, 0, 'job', 1355537246),
(35, 0, 'Verhicles', 'verhicles', 1, 1, 'verhicle', 1354614565),
(36, 0, 'Bulletin Board and Events Announcements', '0', 1, 1, 'community', 1355554574),
(38, 0, 'Online & Internet Business', '0', 1, 0, 'bussiness', 1355553480),
(39, 31, 'Drawings and Paintings ', '0', 1, 0, 'buy_sell', 1355475367),
(41, 31, 'Metal, Wood, and Glass ', '0', 1, 0, 'buy_sell', 1355475430),
(42, 31, 'Photographs and Prints ', '0', 1, 0, 'buy_sell', 1355475454),
(43, 31, 'Sculptures, Ceramic, and Clay ', '0', 1, 0, 'buy_sell', 1355475516),
(44, 31, 'Needlework and Textiles ', '0', 1, 0, 'buy_sell', 1355475548),
(45, 0, 'Babies, Toddlers & Children', '0', 1, 0, 'buy_sell', 1355475588),
(46, 45, 'Baby Clothes  ', 'baby-clothes', 1, 0, 'buy_sell', 1355475638),
(47, 45, 'Baby Toys  ', 'baby-toys', 1, 0, 'buy_sell', 1355475696),
(48, 45, 'Baby Footwear', 'baby-footwear', 1, 0, 'buy_sell', 1355475717),
(49, 45, 'Car Seats & Baby Carriers Nursery &Children''s Furniture Prams & Strollers   ', 'car-seats--baby-carriers-nursery-childrens-furniture-prams--strollers-', 1, 0, 'buy_sell', 1355475761),
(50, 45, 'Children Clothes', 'children-clothes', 1, 0, 'buy_sell', 1355475787),
(51, 45, 'Children Toys', 'children-toys', 1, 0, 'buy_sell', 1355475804),
(52, 45, 'Children Footwear', 'children-footwear', 1, 0, 'buy_sell', 1355475825),
(53, 45, 'Other', 'other', 1, 0, 'buy_sell', 1355475841),
(54, 0, 'Bicycle', 'bicycle', 1, 0, 'buy_sell', 1355475907),
(55, 0, 'Books', 'books', 1, 0, 'buy_sell', 1355475928),
(56, 55, 'E-books and E-zines ', 'e-books-and-e-zines-', 1, 0, 'buy_sell', 1355475967),
(57, 55, 'Books ', 'books-', 1, 0, 'buy_sell', 1355475993),
(58, 55, 'Magazines ', 'magazines-', 1, 0, 'buy_sell', 1355476013),
(59, 55, 'Comics', 'comics', 1, 0, 'buy_sell', 1355476029),
(60, 0, 'CDs, DVDs and Blu-rays', 'cds-dvds-and-blu-rays', 1, 0, 'buy_sell', 1355476051),
(61, 60, 'CDs  ', 'cds', 1, 0, 'buy_sell', 1355476087),
(62, 60, 'DVDs ', 'dvds-', 1, 0, 'buy_sell', 1355476112),
(63, 60, 'Games & Board Games  ', 'games--board-games', 1, 0, 'buy_sell', 1355476129),
(64, 60, 'Audio and Music ', 'audio-and-music-', 1, 0, 'buy_sell', 1355476144),
(65, 60, 'Shows and Movies', 'shows-and-movies', 1, 0, 'buy_sell', 1355476159),
(66, 0, 'Cellphones and Gadgets', 'cellphones-and-gadgets', 1, 0, 'buy_sell', 1355476193),
(67, 66, 'Telephones & Answering Machines  ', 'telephones--answering-machines', 1, 0, 'buy_sell', 1355476217),
(68, 66, 'Cellphone, Cellular, Mobile Phone, and Smartphone ', 'cellphone-cellular-mobile-phone-and-smartphone-', 1, 0, 'buy_sell', 1355476258),
(69, 66, 'Accessories and Parts for Phones ', 'accessories-and-parts-for-phones-', 1, 0, 'buy_sell', 1355476279),
(70, 66, 'PDA and Handhelds (Non-phone Devices) ', 'pda-and-handhelds-(non-phone-devices)-', 1, 0, 'buy_sell', 1355476303),
(71, 66, 'Cordless and Wireless Landline ', 'cordless-and-wireless-landline-', 1, 0, 'buy_sell', 1355476318),
(72, 66, 'Corded ', 'corded-', 1, 0, 'buy_sell', 1355476337),
(73, 0, 'Bags, Clothings&Footwears', 'bags-clothingsfootwears', 1, 0, 'buy_sell', 1355476356),
(74, 73, 'MensFootwear & Shoes ', 'mensfootwear--shoes-', 1, 0, 'buy_sell', 1355476374),
(75, 73, 'Womens Footwear & Shoes', 'womens-footwear--shoes', 1, 0, 'buy_sell', 1355476397),
(76, 73, 'WomensJewelry ', 'womensjewelry-', 1, 0, 'buy_sell', 1355476416),
(77, 73, 'Mens Jewelry', 'mens-jewelry', 1, 0, 'buy_sell', 1355476435),
(78, 73, 'Mens Clothing  ', 'mens-clothing', 1, 0, 'buy_sell', 1355476454),
(79, 73, 'Mens Accessories ', 'mens-accessories-', 1, 0, 'buy_sell', 1355476470),
(80, 73, 'Mens Bags, Luggages& Wallets', 'mens-bags-luggages-wallets', 1, 0, 'buy_sell', 1355476485),
(81, 73, 'MensSunglasses  ', 'menssunglasses', 1, 0, 'buy_sell', 1355476501),
(82, 73, 'MensWatches  ', 'menswatches', 1, 0, 'buy_sell', 1355476519),
(83, 73, 'Womens Clothing  ', 'womens-clothing', 1, 0, 'buy_sell', 1355476533),
(84, 73, 'Womens Bags ', 'womens-bags-', 1, 0, 'buy_sell', 1355476549),
(85, 73, 'Womens Accessories', 'womens-accessories', 1, 0, 'buy_sell', 1355476565),
(86, 73, 'Womens Wallets', 'womens-wallets', 1, 0, 'buy_sell', 1355476580),
(87, 73, 'Womens Watches', 'womens-watches', 1, 0, 'buy_sell', 1355476594),
(88, 73, 'Unisex Watches', 'unisex-watches', 1, 0, 'buy_sell', 1355476608),
(89, 73, 'Unisex Sunglasses', 'unisex-sunglasses', 1, 0, 'buy_sell', 1355476634),
(90, 73, 'Unisex Bags, Luggages and Wallets', 'unisex-bags-luggages-and-wallets', 1, 0, 'buy_sell', 1355476645),
(91, 73, 'Unisex Outerwear', 'unisex-outerwear', 1, 0, 'buy_sell', 1355476661),
(92, 73, 'Mens Casual Wear', 'mens-casual-wear', 1, 0, 'buy_sell', 1355476678),
(93, 73, 'Womens Casual Wear', 'womens-casual-wear', 1, 0, 'buy_sell', 1355476692),
(94, 73, 'Womens Dresses', 'womens-dresses', 1, 0, 'buy_sell', 1355476708),
(95, 73, 'Womens Prom Dresses', 'womens-prom-dresses', 1, 0, 'buy_sell', 1355476723),
(96, 73, 'Womens Wedding Dresses', 'womens-wedding-dresses', 1, 0, 'buy_sell', 1355476738),
(97, 73, 'Womens Formal Dresses', 'womens-formal-dresses', 1, 0, 'buy_sell', 1355476752),
(98, 73, 'MensFormal Wears', 'mensformal-wears', 1, 0, 'buy_sell', 1355476774),
(99, 73, 'Womens Formal Wears', 'womens-formal-wears', 1, 0, 'buy_sell', 1355476797),
(100, 73, 'Sportswear and Swimwear ', 'sportswear-and-swimwear-', 1, 0, 'buy_sell', 1355476811),
(101, 73, 'Costumes', 'costumes', 1, 0, 'buy_sell', 1355476825),
(102, 73, 'Sleepwear and Underwear ', 'sleepwear-and-underwear-', 1, 0, 'buy_sell', 1355476838),
(103, 0, 'Collectibles ', 'collectibles-', 1, 0, 'buy_sell', 1355477038),
(104, 103, 'Action Figures and Dolls ', 'action-figures-and-dolls-', 1, 0, 'buy_sell', 1355477067),
(105, 103, 'Cards ', 'cards-', 1, 0, 'buy_sell', 1355477080),
(106, 103, 'Antiques ', 'antiques-', 1, 0, 'buy_sell', 1355477096),
(107, 103, 'Coins and Currency ', 'coins-and-currency-', 1, 0, 'buy_sell', 1355477111),
(108, 103, 'Memorabilia ', 'memorabilia-', 1, 0, 'buy_sell', 1355477125),
(109, 103, 'Comics ', 'comics-', 1, 0, 'buy_sell', 1355477139),
(110, 103, 'Stamps', 'stamps', 1, 0, 'buy_sell', 1355477152),
(111, 0, 'Commercial and Industrial Equipments', 'commercial-and-industrial-equipments', 1, 0, 'buy_sell', 1355477166),
(112, 0, 'Computers and Peripherals', 'computers-and-peripherals', 1, 0, 'buy_sell', 1355477176),
(113, 112, 'Computers, PCs & Laptops  ', 'computers-pcs--laptops', 1, 0, 'buy_sell', 1355477195),
(114, 112, 'Software  ', 'software', 1, 0, 'buy_sell', 1355477210),
(115, 112, 'Video Games  ', 'video-games', 1, 0, 'buy_sell', 1355477230),
(116, 112, 'Notebooks, and Netbooks ', 'notebooks-and-netbooks-', 1, 0, 'buy_sell', 1355477245),
(117, 112, 'Accessories and Parts for Notebooks, Laptops and Netbooks ', 'accessories-and-parts-for-notebooks-laptops-and-netbooks-', 1, 0, 'buy_sell', 1355477267),
(118, 112, 'Peripherals, Components, and Parts ', 'peripherals-components-and-parts-', 1, 0, 'buy_sell', 1355477288),
(119, 112, 'Printers and Scanners ', 'printers-and-scanners-', 1, 0, 'buy_sell', 1355477303),
(120, 112, 'Tablets ', 'tablets-', 1, 0, 'buy_sell', 1355477319),
(121, 112, 'Desktops ', 'desktops-', 1, 0, 'buy_sell', 1355477332),
(122, 112, 'Storage Devices ', 'storage-devices-', 1, 0, 'buy_sell', 1355477347),
(123, 112, 'Networking and Servers', 'networking-and-servers', 1, 0, 'buy_sell', 1355477361),
(124, 112, 'Software ', 'software-', 1, 0, 'buy_sell', 1355477377),
(125, 112, 'Internet Gadgets ', 'internet-gadgets-', 1, 0, 'buy_sell', 1355477399),
(126, 112, 'Monitors ', 'monitors-', 1, 0, 'buy_sell', 1355477412),
(127, 112, 'Game System', 'game-system', 1, 0, 'buy_sell', 1355477485),
(128, 0, 'Health and Beauty', 'health-and-beauty', 1, 0, 'buy_sell', 1355477545),
(129, 0, 'Hobbies', 'hobbies', 1, 0, 'buy_sell', 1355477560),
(130, 0, 'Home & Garden', 'home--garden', 1, 0, 'buy_sell', 1355477572),
(131, 130, 'Garden & Patio Furniture ', 'garden--patio-furniture-', 1, 0, 'buy_sell', 1355477598),
(132, 130, 'Flowers and Plants ', 'flowers-and-plants-', 1, 0, 'buy_sell', 1355477612),
(133, 130, 'Garden Items and Supplies ', 'garden-items-and-supplies-', 1, 0, 'buy_sell', 1355477624),
(134, 130, 'Home and Office Furnitures', 'home-and-office-furnitures', 1, 0, 'buy_sell', 1355477640),
(135, 130, 'Beds & Bedroom Furniture  ', 'beds--bedroom-furniture', 1, 0, 'buy_sell', 1355477654),
(136, 130, 'Dining, Living Room Furniture ', 'dining-living-room-furniture-', 1, 0, 'buy_sell', 1355477667),
(137, 130, 'Cooking and Ovens ', 'cooking-and-ovens-', 1, 0, 'buy_sell', 1355477681),
(138, 130, 'Refrigerators and Freezers ', 'refrigerators-and-freezers-', 1, 0, 'buy_sell', 1355477695),
(139, 130, 'Other Kitchen Appliances ', 'other-kitchen-appliances-', 1, 0, 'buy_sell', 1355477707),
(140, 130, 'Water Dispensers and Purifiers ', 'water-dispensers-and-purifiers-', 1, 0, 'buy_sell', 1355477722),
(141, 130, 'Washers and Dryers ', 'washers-and-dryers-', 1, 0, 'buy_sell', 1355477735),
(142, 130, 'Sewing Machines ', 'sewing-machines-', 1, 0, 'buy_sell', 1355477754),
(143, 130, 'Electric Fans ', 'electric-fans-', 1, 0, 'buy_sell', 1355477771),
(144, 130, 'Lighting and Electricals', 'lighting-and-electricals', 1, 0, 'buy_sell', 1355477783),
(145, 130, 'AirConditioning and Heating', 'airconditioning-and-heating', 1, 0, 'buy_sell', 1355477796),
(146, 130, 'Office ', 'office-', 1, 0, 'buy_sell', 1355477809),
(147, 130, 'Family and Living Room ', 'family-and-living-room-', 1, 0, 'buy_sell', 1355477821),
(148, 130, 'Bath Room', 'bath-room', 1, 0, 'buy_sell', 1355477840),
(149, 130, 'Kids Room ', 'kids-room-', 1, 0, 'buy_sell', 1355477848),
(150, 130, 'Shed and Garage ', 'shed-and-garage-', 1, 0, 'buy_sell', 1355477862),
(151, 0, 'Household', 'household', 1, 0, 'buy_sell', 1355477888),
(152, 151, 'Kitchen Appliances & Accessories  ', 'kitchen-appliances--accessories', 1, 0, 'buy_sell', 1355477898),
(153, 151, 'Other Home Appliances  ', 'other-home-appliances', 1, 0, 'buy_sell', 1355477910),
(154, 151, 'Other Household Goods', 'other-household-goods', 1, 0, 'buy_sell', 1355477927),
(156, 0, 'Jewelry', 'jewelry', 1, 0, 'buy_sell', 1355478034),
(157, 0, 'Miscellaneous Goods', 'miscellaneous-goods', 1, 0, 'buy_sell', 1355478048),
(158, 0, 'Aquariums', 'aquariums', 1, 0, 'buy_sell', 1355478062),
(159, 0, 'Health & Beauty  ', 'health--beauty', 1, 0, 'buy_sell', 1355478075),
(160, 0, 'Hobbies, Interests & Collectibles  ', 'hobbies-interests--collectibles', 1, 0, 'buy_sell', 1355478088),
(161, 0, 'Scrapbooking, Sewing, Art, Craft  ', 'scrapbooking-sewing-art-craft', 1, 0, 'buy_sell', 1355478101),
(162, 0, 'Tools  ', 'tools', 1, 0, 'buy_sell', 1355478117),
(163, 0, 'Musical Instruments', 'musical-instruments', 1, 0, 'buy_sell', 1355478144),
(164, 163, 'String Instruments ', 'string-instruments-', 1, 0, 'buy_sell', 1355478161),
(165, 163, 'Accessories and Parts for Musical Instruments ', 'accessories-and-parts-for-musical-instruments-', 1, 0, 'buy_sell', 1355478178),
(166, 163, 'Keyboard Instruments ', 'keyboard-instruments-', 1, 0, 'buy_sell', 1355478193),
(167, 163, 'Percussion Instruments ', 'percussion-instruments-', 1, 0, 'buy_sell', 1355478206),
(168, 163, 'Woodwind Instruments ', 'woodwind-instruments-', 1, 0, 'buy_sell', 1355478218),
(169, 163, 'Brass Instruments ', 'brass-instruments-', 1, 0, 'buy_sell', 1355478230),
(170, 163, 'Vinyl', 'vinyl', 1, 0, 'buy_sell', 1355478243),
(171, 163, 'Studio & Live Music Equipment', 'studio--live-music-equipment', 1, 0, 'buy_sell', 1355478253),
(172, 163, 'Guitars and Guitar Amps', 'guitars-and-guitar-amps', 1, 0, 'buy_sell', 1355478272),
(173, 163, 'Keyboards and Pianos', 'keyboards-and-pianos', 1, 0, 'buy_sell', 1355478285),
(174, 163, 'Percussion & Drums', 'percussion--drums', 1, 0, 'buy_sell', 1355478298),
(175, 163, 'Sheet Music', 'sheet-music', 1, 0, 'buy_sell', 1355478316),
(176, 0, 'Office Furniture & Equipment', 'office-furniture--equipment', 1, 0, 'buy_sell', 1355478347),
(177, 176, 'Cartridges & Toners  ', 'cartridges--toners', 1, 0, 'buy_sell', 1355478360),
(178, 176, 'Chairs  ', 'chairs', 1, 0, 'buy_sell', 1355478381),
(179, 176, 'Copiers  ', 'copiers', 1, 0, 'buy_sell', 1355478389),
(180, 176, 'Desks  ', 'desks', 1, 0, 'buy_sell', 1355478399),
(181, 176, 'Faxes  ', 'faxes', 1, 0, 'buy_sell', 1355478410),
(182, 176, 'Multimedia Projectors  ', 'multimedia-projectors', 1, 0, 'buy_sell', 1355478421),
(183, 176, 'Printers ', 'printers-', 1, 0, 'buy_sell', 1355478435),
(184, 176, 'Shredders  ', 'shredders', 1, 0, 'buy_sell', 1355478450),
(185, 176, 'Storage & Filing  ', 'storage--filing', 1, 0, 'buy_sell', 1355478460),
(186, 0, 'Sporting Goods', 'sporting-goods', 1, 0, 'buy_sell', 1355478483),
(187, 186, 'Ball & Racquet Sport Equipment  ', 'ball--racquet-sport-equipment', 1, 0, 'buy_sell', 1355478494),
(188, 186, 'Bicycle Accessories  ', 'bicycle-accessories', 1, 0, 'buy_sell', 1355478507),
(189, 186, 'Bicycles  ', 'bicycles', 1, 0, 'buy_sell', 1355478520),
(190, 186, 'Camping & Hiking  ', 'camping--hiking', 1, 0, 'buy_sell', 1355478532),
(191, 186, 'Fishing Equipment  ', 'fishing-equipment', 1, 0, 'buy_sell', 1355478543),
(192, 186, 'Golf Equipment  ', 'golf-equipment', 1, 0, 'buy_sell', 1355478553),
(193, 186, 'Gym Equipment  ', 'gym-equipment', 1, 0, 'buy_sell', 1355478563),
(194, 186, 'Other Sports & Leisure  ', 'other-sports--leisure', 1, 0, 'buy_sell', 1355478575),
(195, 186, 'Water Sports  ', 'water-sports', 1, 0, 'buy_sell', 1355478586),
(196, 186, 'Winter Sports  ', 'winter-sports', 1, 0, 'buy_sell', 1355478597),
(197, 0, 'Sports and Hobbies', 'sports-and-hobbies', 1, 0, 'buy_sell', 1355478621),
(198, 197, 'Camping and Biking ', 'camping-and-biking-', 1, 0, 'buy_sell', 1355478645),
(199, 197, 'Exercise and Body Building ', 'exercise-and-body-building-', 1, 0, 'buy_sell', 1355478658),
(200, 197, 'Airsoft (AEG) ', 'airsoft-(aeg)-', 1, 0, 'buy_sell', 1355478671),
(201, 197, 'Sports Gear and Accessories ', 'sports-gear-and-accessories-', 1, 0, 'buy_sell', 1355478682),
(202, 197, 'Water Sports ', 'water-sports-', 1, 0, 'buy_sell', 1355478694),
(203, 197, 'Racket Sports ', 'racket-sports-', 1, 0, 'buy_sell', 1355478706),
(204, 197, 'Combat Sports ', 'combat-sports-', 1, 0, 'buy_sell', 1355478716),
(205, 197, 'Field Sports ', 'field-sports-', 1, 0, 'buy_sell', 1355478726),
(206, 197, 'Skateboards and Rollerblades ', 'skateboards-and-rollerblades-', 1, 0, 'buy_sell', 1355478736),
(207, 197, 'Billiards and Bowling ', 'billiards-and-bowling-', 1, 0, 'buy_sell', 1355478747),
(208, 197, 'Binoculars and Parts ', 'binoculars-and-parts-', 1, 0, 'buy_sell', 1355478759),
(209, 197, 'Board Games ', 'board-games-', 1, 0, 'buy_sell', 1355478770),
(210, 0, 'Stuff Wanted', 'stuff-wanted', 1, 0, 'buy_sell', 1355478782),
(211, 0, 'Tickets', 'tickets', 1, 0, 'buy_sell', 1355478794),
(212, 211, 'Music & Other  ', 'music--other', 1, 0, 'buy_sell', 1355478804),
(213, 211, 'Sports  ', 'sports', 1, 0, 'buy_sell', 1355478819),
(214, 211, 'Travel  ', 'travel', 1, 0, 'buy_sell', 1355478830),
(217, 0, 'Toys, Video Games, and Related Items ', 'toys-video-games-and-related-items-', 1, 0, 'buy_sell', 1355478912),
(218, 217, 'Toys and Playthings ', 'toys-and-playthings-', 1, 0, 'buy_sell', 1355478923),
(219, 217, 'Other Baby Stuff ', 'other-baby-stuff-', 1, 0, 'buy_sell', 1355478935),
(220, 217, 'Game Systems (Consoles) ', 'game-systems-(consoles)-', 1, 0, 'buy_sell', 1355478945),
(221, 217, 'Game Cartridges and CDs ', 'game-cartridges-and-cds-', 1, 0, 'buy_sell', 1355478955),
(222, 217, 'Handheld Systems ', 'handheld-systems-', 1, 0, 'buy_sell', 1355478965),
(223, 217, 'Game Accounts ', 'game-accounts-', 1, 0, 'buy_sell', 1355478976),
(224, 217, 'Control Pads ', 'control-pads-', 1, 0, 'buy_sell', 1355478985),
(225, 217, 'Memory ', 'memory-', 1, 0, 'buy_sell', 1355478998),
(226, 0, 'Travel and Vacation', 'travel-and-vacation', 1, 0, 'buy_sell', 1355479020),
(227, 0, 'TV, Audio and Video', 'tv-audio-and-video', 1, 0, 'buy_sell', 1355479032),
(228, 227, 'Decks & DJ Accessories  ', 'decks--dj-accessories', 1, 0, 'buy_sell', 1355479051),
(229, 227, 'Home Cinema  ', 'home-cinema', 1, 0, 'buy_sell', 1355479062),
(230, 227, 'Karaoke Equipment  ', 'karaoke-equipment', 1, 0, 'buy_sell', 1355479074),
(231, 227, 'Other Stereo & Audio  ', 'other-stereo--audio', 1, 0, 'buy_sell', 1355479086),
(232, 227, 'Personal Stereos  ', 'personal-stereos', 1, 0, 'buy_sell', 1355479097),
(233, 227, 'Stereos & Accessories  ', 'stereos--accessories', 1, 0, 'buy_sell', 1355479107),
(234, 227, 'Camcorders and Cameras ', 'camcorders-and-cameras-', 1, 0, 'buy_sell', 1355479121),
(235, 227, 'Accessories and Parts for Camcorders and Cameras ', 'accessories-and-parts-for-camcorders-and-cameras-', 1, 0, 'buy_sell', 1355479132),
(236, 227, 'CD, DVD, MP3, and MP4 Audio Players ', 'cd-dvd-mp3-and-mp4-audio-players-', 1, 0, 'buy_sell', 1355479143),
(237, 227, 'Headphones and Earphones ', 'headphones-and-earphones-', 1, 0, 'buy_sell', 1355479153),
(238, 227, 'TVs ', 'tvs-', 1, 0, 'buy_sell', 1355479163),
(239, 227, 'Speakers ', 'speakers-', 1, 0, 'buy_sell', 1355479174),
(240, 227, 'Amplifiers ', 'amplifiers-', 1, 0, 'buy_sell', 1355479186),
(241, 227, 'Projectors ', 'projectors-', 1, 0, 'buy_sell', 1355479196),
(242, 227, 'Antennas and Cables ', 'antennas-and-cables-', 1, 0, 'buy_sell', 1355479207),
(243, 227, 'VCD, DVD, and Blu-ray Players ', 'vcd-dvd-and-blu-ray-players-', 1, 0, 'buy_sell', 1355479222),
(244, 227, 'Digital Camera Accessories  ', 'digital-camera-accessories', 1, 0, 'buy_sell', 1355479236),
(245, 227, 'Digital Cameras  ', 'digital-cameras', 1, 0, 'buy_sell', 1355479246),
(246, 227, 'Non Digital Cameras  ', 'non-digital-cameras', 1, 0, 'buy_sell', 1355479257),
(247, 227, 'Satellite& Cable Equipment  ', 'satellite-cable-equipment', 1, 0, 'buy_sell', 1355479271),
(248, 227, 'Televisions, Plasma & LCD TVs  ', 'televisions-plasma--lcd-tvs', 1, 0, 'buy_sell', 1355479282),
(249, 227, 'TV, DVD & VCR Accessories ', 'tv-dvd--vcr-accessories-', 1, 0, 'buy_sell', 1355479295),
(250, 227, ' Other', '-other', 1, 0, 'buy_sell', 1355479359),
(252, 34, 'Accounts Assistant & Bookkeeping  ', 'accounts-assistant--bookkeeping', 1, 0, 'job', 1355537367),
(253, 34, 'Banking, Insurance & Investment  ', 'banking-insurance--investment', 1, 0, 'job', 1355537391),
(254, 34, 'Commerce, Finance & Industry  ', 'commerce-finance--industry', 1, 0, 'job', 1355537409),
(255, 34, 'Public & Non Profit  ', 'public--non-profit', 1, 0, 'job', 1355537421),
(256, 34, 'Public Practice Accounting  ', 'public-practice-accounting', 1, 0, 'job', 1355537433),
(257, 0, 'Administrative', 'administrative', 1, 0, 'job', 1355537455),
(258, 0, 'Architecture ', 'architecture-', 1, 0, 'job', 1355537464),
(259, 0, 'Automotive', 'automotive', 1, 0, 'job', 1355537475),
(260, 0, 'Bar Staff & Management', 'bar-staff--management', 1, 0, 'job', 1355537484),
(261, 0, 'Business and Management', 'business-and-management', 1, 0, 'job', 1355537495),
(262, 0, 'Call Center', 'call-center', 1, 0, 'job', 1355537505),
(263, 0, 'Chef, Cooks and Kitchen', 'chef-cooks-and-kitchen', 1, 0, 'job', 1355537515),
(264, 263, 'Chef de Partie', 'chef-de-partie', 1, 0, 'job', 1355537527),
(265, 263, 'Commis Chef  ', 'commis-chef', 1, 0, 'job', 1355537537),
(266, 263, 'Cooks  ', 'cooks', 1, 0, 'job', 1355537549),
(267, 263, 'Demi Chef de Partie', 'demi-chef-de-partie', 1, 0, 'job', 1355537560),
(268, 263, 'Head Chef  ', 'head-chef', 1, 0, 'job', 1355537572),
(269, 263, 'Kitchen  ', 'kitchen', 1, 0, 'job', 1355537584),
(270, 263, 'Pastry Chef  ', 'pastry-chef', 1, 0, 'job', 1355537596),
(271, 263, 'Sous Chef  ', 'sous-chef', 1, 0, 'job', 1355537608),
(272, 0, 'Computing & IT', 'computing--it', 1, 0, 'job', 1355537632),
(273, 272, 'ProjMgmt, Bus Analysis, Consulting  ', 'projmgmt-bus-analysis-consulting', 1, 0, 'job', 1355537762),
(274, 272, 'Software Dev, Programming & Testing Support, Database & Systems Admin  ', 'software-dev-programming--testing-support-database--systems-admin', 1, 0, 'job', 1355537776),
(275, 272, 'Web Design & Web Developers  ', 'web-design--web-developers', 1, 0, 'job', 1355537789),
(276, 272, 'Other ', 'other-', 1, 0, 'job', 1355537802),
(277, 0, 'Construction', 'construction', 1, 0, 'job', 1355537817),
(278, 277, 'Architecture  ', 'architecture', 1, 0, 'job', 1355537829),
(279, 277, 'Building Services & Maintenance  ', 'building-services--maintenance', 1, 0, 'job', 1355537841),
(280, 277, 'Tradesmen / Labour', 'tradesmen---labour', 1, 0, 'job', 1355537855),
(281, 0, 'Customer Service', 'customer-service', 1, 0, 'job', 1355538632),
(282, 0, 'Data Entry ', 'data-entry-', 1, 0, 'job', 1355539089),
(283, 0, 'Driving & Warehouse', 'driving--warehouse', 1, 0, 'job', 1355539101),
(285, 0, 'Editing', 'editing', 1, 0, 'job', 1355541464),
(286, 0, 'Education', 'education', 1, 0, 'job', 1355541476),
(287, 286, 'Nursery  ', 'nursery', 1, 0, 'job', 1355541511),
(288, 286, 'Primary | Key Stage 1  ', 'primary-|-key-stage-1', 1, 0, 'job', 1355541532),
(289, 286, 'Primary | Key Stage 2  ', 'primary-|-key-stage-2', 1, 0, 'job', 1355541569),
(290, 286, 'Primary | Other ', 'primary-|-other-', 1, 0, 'job', 1355541590),
(291, 286, 'Special Educational Needs  ', 'special-educational-needs', 1, 0, 'job', 1355541607),
(292, 286, 'Subject | Languages ', 'subject-|-languages-', 1, 0, 'job', 1355541629),
(293, 286, 'Subject | Science  ', 'subject-|-science', 1, 0, 'job', 1355541643),
(294, 286, 'Supply | Secondary  ', 'supply-|-secondary', 1, 0, 'job', 1355541660),
(295, 286, 'Teaching Assistant ', 'teaching-assistant-', 1, 0, 'job', 1355541693),
(296, 0, 'Engineering', 'engineering', 1, 0, 'job', 1355541713),
(297, 0, 'Farm, Vet, Garden and Landscaping', 'farm-vet-garden-and-landscaping', 1, 0, 'job', 1355541729),
(298, 297, 'Farming & Veterinary  ', 'farming--veterinary', 1, 0, 'job', 1355541743),
(299, 297, 'Gardening & Landscaping  ', 'gardening--landscaping', 1, 0, 'job', 1355541755),
(300, 0, 'Food and Beverage', 'food-and-beverage', 1, 0, 'job', 1355541790),
(302, 0, 'General Labor', 'general-labor', 1, 0, 'job', 1355541815),
(303, 0, 'General Jobs', 'general-jobs', 1, 0, 'job', 1355541915),
(304, 0, 'Government', 'government', 1, 0, 'job', 1355541927),
(305, 0, 'Healthcare', 'healthcare', 1, 0, 'job', 1355541950),
(306, 305, 'Biotechnology & Pharmaceutical  ', 'biotechnology--pharmaceutical', 1, 0, 'job', 1355541964),
(307, 305, 'Doctors ', 'doctors-', 1, 0, 'job', 1355541977),
(308, 305, 'Medical Secretarial & Medical Admin  ', 'medical-secretarial--medical-admin', 1, 0, 'job', 1355541990),
(309, 305, 'Nurses  ', 'nurses', 1, 0, 'job', 1355542002),
(310, 0, 'Hotel', 'hotel', 1, 0, 'job', 1355542035),
(311, 0, 'Internet Work', 'internet-work', 1, 0, 'job', 1355542044),
(312, 0, 'Legal', 'legal', 1, 0, 'job', 1355542098),
(313, 0, 'Manufacturing', 'manufacturing', 1, 0, 'job', 1355542109),
(314, 0, 'Marketing, Advertising & PR', 'marketing-advertising--pr', 1, 0, 'job', 1355542118),
(315, 314, 'Account Management  ', 'account-management', 1, 0, 'job', 1355542132),
(316, 314, 'Brand Management  ', 'brand-management', 1, 0, 'job', 1355542143),
(317, 314, 'Direct marketing  ', 'direct-marketing', 1, 0, 'job', 1355542153),
(318, 314, 'Event Management Internet Marketing & SEO  ', 'event-management-internet-marketing--seo', 1, 0, 'job', 1355542175),
(319, 314, 'Marketing Assistant/Exec Marketing Manager  ', 'marketing-assistant-exec-marketing-manager', 1, 0, 'job', 1355542218),
(320, 314, 'PR  ', 'pr', 1, 0, 'job', 1355542233),
(321, 0, 'Media, Design and Creative', 'media-design-and-creative', 1, 0, 'job', 1355542256),
(322, 321, 'Editorial, Writing & Journalism  ', 'editorial-writing--journalism', 1, 0, 'job', 1355542272),
(323, 321, 'Film, TV, Radio, & Photography  ', 'film-tv-radio--photography', 1, 0, 'job', 1355542285),
(324, 321, 'Graphic Design & DTP  ', 'graphic-design--dtp', 1, 0, 'job', 1355542298),
(325, 321, 'Interior, Fashion & Creative Design  ', 'interior-fashion--creative-design', 1, 0, 'job', 1355542312),
(326, 0, 'Medical& Legal Transcription', 'medical-legal-transcription', 1, 0, 'job', 1355542331),
(327, 0, 'Medical Professionals', 'medical-professionals', 1, 0, 'job', 1355542340),
(329, 0, 'Paralegal& Legal', 'paralegal-legal', 1, 0, 'job', 1355542662),
(330, 329, 'Conveyancing& Paralegal  ', 'conveyancing-paralegal', 1, 0, 'job', 1355542676),
(331, 329, 'Legal Secretarial & Legal Admin  ', 'legal-secretarial--legal-admin', 1, 0, 'job', 1355542698),
(332, 0, 'Programmers ', 'programmers-', 1, 0, 'job', 1355542719),
(333, 0, 'Real Estate', 'real-estate', 1, 0, 'job', 1355542726),
(334, 0, 'Receptiontionist', 'receptiontionist', 1, 0, 'job', 1355542733),
(335, 0, 'Recruitment Agents', 'recruitment-agents', 1, 0, 'job', 1355542741),
(336, 335, 'Executive Search  ', 'executive-search', 1, 0, 'job', 1355542756),
(337, 335, 'Recruitment Consultants  ', 'recruitment-consultants', 1, 0, 'job', 1355542771),
(338, 335, 'Trainee Resourcer', 'trainee-resourcer', 1, 0, 'job', 1355542785),
(339, 0, 'Sales', 'sales', 1, 0, 'job', 1355542803),
(340, 0, 'Sales, Retail & Customer Service', 'sales-retail--customer-service', 1, 0, 'job', 1355542812),
(341, 340, 'Retail  ', 'retail', 1, 0, 'job', 1355542824),
(342, 340, 'Sales & Customer Service  ', 'sales--customer-service', 1, 0, 'job', 1355542836),
(343, 0, 'Secretarial and Clerical Work', 'secretarial-and-clerical-work', 1, 0, 'job', 1355542846),
(344, 0, 'Security', 'security', 1, 0, 'job', 1355542854),
(345, 0, 'Technical Support', 'technical-support', 1, 0, 'job', 1355542877),
(346, 0, 'Transportation', 'transportation', 1, 0, 'job', 1355542893),
(347, 0, 'Travel and Overseas', 'travel-and-overseas', 1, 0, 'job', 1355542903),
(348, 347, 'Travel Agent & Travel Consultant  ', 'travel-agent--travel-consultant', 1, 0, 'job', 1355542921),
(349, 347, 'Travel, Overseas & Work Abroad  ', 'travel-overseas--work-abroad', 1, 0, 'job', 1355542937),
(350, 0, 'Virtual Assistants', 'virtual-assistants', 1, 0, 'job', 1355542964),
(351, 0, 'Waiting & Restaurant Management', 'waiting--restaurant-management', 1, 0, 'job', 1355542983),
(352, 351, 'Food & Beverage  ', 'food--beverage', 1, 0, 'job', 1355542998),
(353, 351, 'Head Waiter  ', 'head-waiter', 1, 0, 'job', 1355543009),
(354, 351, 'Restaurant Management  ', 'restaurant-management', 1, 0, 'job', 1355543027),
(355, 351, 'Waiting Staff  ', 'waiting-staff', 1, 0, 'job', 1355543035),
(356, 0, 'Web Design', 'web-design', 1, 0, 'job', 1355543712),
(357, 0, 'Wholesale', 'wholesale', 1, 0, 'job', 1355543721),
(358, 0, 'Work Wanted', 'work-wanted', 1, 0, 'job', 1355543729),
(359, 0, 'Writing and Editing', 'writing-and-editing', 1, 0, 'job', 1355543747),
(360, 0, 'Accounting', 'accounting', 1, 0, 'job', 1355543952),
(361, 0, 'Advertising', 'advertising', 1, 0, 'job', 1355543967),
(362, 0, 'Agriculture ', 'agriculture-', 1, 0, 'job', 1355543976),
(368, 0, 'House and Lot ', 'house-and-lot-', 1, 0, 'property', 1355544557),
(371, 0, 'Commercial Property', 'commercial-property', 1, 0, 'property', 1355544975),
(373, 0, 'Residential Lot ', 'residential-lot-', 1, 0, 'property', 1355544987),
(374, 0, 'Rooms For Rent', 'rooms-for-rent', 1, 0, 'property', 1355545118),
(375, 0, 'Condominium Unit  ', 'condominium-unit', 1, 0, 'property', 1355545126),
(376, 0, 'Townhouse', 'townhouse', 1, 0, 'property', 1355545136),
(377, 0, 'Subdivision', 'subdivision', 1, 0, 'property', 1355545150),
(378, 0, 'Commercial Land ', 'commercial-land-', 1, 0, 'property', 1355545160),
(379, 0, 'Agricultural Lot ', 'agricultural-lot-', 1, 0, 'property', 1355545201),
(380, 0, 'Beach House', 'beach-house', 1, 0, 'property', 1355545210),
(381, 0, 'Vacation House', 'vacation-house', 1, 0, 'property', 1355545219),
(382, 0, 'Nurses', 'nurses', 1, 0, 'job', 1355545408),
(383, 382, 'General  ', 'general', 1, 0, 'job', 1355545520),
(384, 382, 'Specialist  ', 'specialist', 1, 0, 'job', 1355545533),
(385, 382, 'Other  ', 'other', 1, 0, 'job', 1355545548),
(386, 351, 'Other  ', 'other', 1, 0, 'job', 1355545596),
(387, 263, 'Other', 'other', 1, 0, 'job', 1355545670),
(388, 277, 'Other', 'other', 1, 0, 'job', 1355545747),
(389, 283, 'Other', 'other', 1, 0, 'job', 1355545889),
(390, 283, 'Architecture  ', 'architecture', 1, 0, 'job', 1355545998),
(391, 283, 'Building Services & Maintenance  ', 'building-services--maintenance', 1, 0, 'job', 1355546017),
(392, 283, 'Tradesmen / Labour', 'tradesmen---labour', 1, 0, 'job', 1355546039),
(393, 286, 'Other  ', 'other', 1, 0, 'job', 1355546138),
(394, 297, 'Other  ', 'other', 1, 0, 'job', 1355546194),
(395, 305, 'Other', 'other', 1, 0, 'job', 1355546296),
(396, 314, 'Other', 'other', 1, 0, 'job', 1355546341),
(397, 321, 'Other', 'other', 1, 0, 'job', 1355546552),
(398, 329, 'Other  ', 'other', 1, 0, 'job', 1355546600),
(399, 335, 'Other  ', 'other', 1, 0, 'job', 1355546675),
(400, 347, 'Other', 'other', 1, 0, 'job', 1355551350),
(401, 0, 'Advertising', 'advertising', 1, 0, 'service', 1355551475),
(402, 0, 'Agriculture ', 'agriculture-', 1, 0, 'service', 1355551500),
(403, 0, 'Architecture', 'architecture', 1, 0, 'service', 1355551531),
(404, 0, 'Automotive', 'automotive', 1, 0, 'service', 1355551544),
(405, 0, 'Beauty', 'beauty', 1, 0, 'service', 1355551555),
(406, 405, 'Beauty Parlor', 'beauty-parlor', 1, 0, 'service', 1355551580),
(407, 405, 'Beauty Salon', 'beauty-salon', 1, 0, 'service', 1355551596),
(408, 405, 'Barber Shop', 'barber-shop', 1, 0, 'service', 1355551614),
(409, 405, 'Other', 'other', 1, 0, 'service', 1355551631),
(410, 0, 'Computer Support', 'computer-support', 1, 0, 'service', 1355551649),
(411, 410, 'Repair & Maintenance', 'repair--maintenance', 1, 0, 'service', 1355551684),
(412, 410, 'Parts and Accessories', 'parts-and-accessories', 1, 0, 'service', 1355551702),
(413, 410, 'Wireless Networking', 'wireless-networking', 1, 0, 'service', 1355551724),
(414, 410, 'Internet Connection', 'internet-connection', 1, 0, 'service', 1355551739),
(415, 410, 'Printer Repair', 'printer-repair', 1, 0, 'service', 1355551757),
(416, 410, 'Other Computer Support', 'other-computer-support', 1, 0, 'service', 1355551776),
(417, 0, 'Education', 'education', 1, 0, 'service', 1355551786),
(418, 0, 'Engineering', 'engineering', 1, 0, 'service', 1355551805),
(419, 0, 'Events Planner', 'events-planner', 1, 0, 'service', 1355551816),
(420, 419, 'Birthday Party', 'birthday-party', 1, 0, 'service', 1355551831),
(421, 419, 'Company Party', 'company-party', 1, 0, 'service', 1355551849),
(422, 419, 'Holiday Party', 'holiday-party', 1, 0, 'service', 1355551871),
(423, 419, 'Special Events Party', 'special-events-party', 1, 0, 'service', 1355551891),
(424, 419, 'Seminar and Workshop', 'seminar-and-workshop', 1, 0, 'service', 1355551907),
(425, 419, 'Wedding', 'wedding', 1, 0, 'service', 1355551925),
(426, 419, 'Concert ', 'concert-', 1, 0, 'service', 1355551943),
(427, 419, 'Other', 'other', 1, 0, 'service', 1355551957),
(428, 0, 'Food and Catering Services', 'food-and-catering-services', 1, 0, 'service', 1355551968),
(429, 0, 'Information Technology', 'information-technology', 1, 0, 'service', 1355551989),
(430, 429, 'Website Design', 'website-design', 1, 0, 'service', 1355552001),
(431, 429, '•	Programming and Software Development ', '•	programming-and-software-development-', 1, 0, 'service', 1355552017),
(432, 429, 'Hosting ', 'hosting-', 1, 0, 'service', 1355552034),
(433, 429, 'Data Processing', 'data-processing', 1, 0, 'service', 1355552077),
(435, 0, 'Internet Business', 'internet-business', 1, 0, 'service', 1355552126),
(436, 0, 'Business to Business', 'business-to-business', 1, 0, 'service', 1355552161),
(437, 0, 'Internet Marketing', 'internet-marketing', 1, 0, 'service', 1355552174),
(438, 0, 'Legal Services', 'legal-services', 1, 0, 'service', 1355552183),
(439, 0, 'Refrigeration and Maintenance', 'refrigeration-and-maintenance', 1, 0, 'service', 1355552193),
(440, 0, 'Plumbing & Sewerage', 'plumbing--sewerage', 1, 0, 'service', 1355552205),
(441, 0, 'Non-Profit', 'non-profit', 1, 0, 'service', 1355552213),
(442, 0, 'Others', 'others', 1, 0, 'service', 1355552220),
(443, 0, 'Pet Training', 'pet-training', 1, 0, 'service', 1355552233),
(444, 0, 'Photography & Video Editing', 'photography--video-editing', 1, 0, 'service', 1355552245),
(445, 0, 'Professional Consulting', 'professional-consulting', 1, 0, 'service', 1355552255),
(446, 0, 'Publishing', 'publishing', 1, 0, 'service', 1355552264),
(447, 0, 'Rental Services', 'rental-services', 1, 0, 'service', 1355552275),
(448, 447, 'Car Rental', 'car-rental', 1, 0, 'service', 1355552290),
(449, 447, 'Truck Rental', 'truck-rental', 1, 0, 'service', 1355552319),
(450, 447, 'Limo Rental', 'limo-rental', 1, 0, 'service', 1355552337),
(451, 447, 'Moving Services (Lipat Bahay)', 'moving-services-(lipat-bahay)', 1, 0, 'service', 1355552353),
(452, 447, 'Events Space Rental Services', 'events-space-rental-services', 1, 0, 'service', 1355552364),
(453, 447, 'Events Space Rental Services', 'events-space-rental-services', 1, 0, 'service', 1355552382),
(454, 447, 'Chairs, Tables and Other Party Rental Services', 'chairs-tables-and-other-party-rental-services', 1, 0, 'service', 1355552395),
(455, 447, 'General Equipments Rental Services', 'general-equipments-rental-services', 1, 0, 'service', 1355552416),
(456, 447, 'Other Rental Services', 'other-rental-services', 1, 0, 'service', 1355552427),
(457, 0, 'Retail', 'retail', 1, 0, 'service', 1355552436),
(458, 0, 'Security Services', 'security-services', 1, 0, 'service', 1355552447),
(459, 0, 'Small Business Training', 'small-business-training', 1, 0, 'service', 1355552455),
(460, 0, 'Telecommunications', 'telecommunications', 1, 0, 'service', 1355552467),
(461, 460, 'Broadband Internet Service Provider', 'broadband-internet-service-provider', 1, 0, 'service', 1355552482),
(462, 460, 'Phone Service Service Provider', 'phone-service-service-provider', 1, 0, 'service', 1355552492),
(463, 460, 'Home and Cable Service Provider', 'home-and-cable-service-provider', 1, 0, 'service', 1355552504),
(464, 460, 'VoIP Service Provider', 'voip-service-provider', 1, 0, 'service', 1355552515),
(465, 0, 'Travel and Vacation', 'travel-and-vacation', 1, 0, 'service', 1355552536),
(466, 465, 'Tour Packages ', 'tour-packages-', 1, 0, 'service', 1355552938),
(467, 465, 'Hotels and Accommodations  ', 'hotels-and-accommodations', 1, 0, 'service', 1355552953),
(468, 0, 'Subject Tutorial', 'subject-tutorial', 1, 0, 'service', 1355552971),
(469, 468, 'Math', 'math', 1, 0, 'service', 1355552987),
(470, 468, 'Science', 'science', 1, 0, 'service', 1355553006),
(471, 468, 'History', 'history', 1, 0, 'service', 1355553024),
(472, 468, 'English', 'english', 1, 0, 'service', 1355553055),
(473, 468, 'Language Arts', 'language-arts', 1, 0, 'service', 1355553066),
(474, 468, 'Writing', 'writing', 1, 0, 'service', 1355553096),
(475, 468, 'Foreign Language', 'foreign-language', 1, 0, 'service', 1355553116),
(476, 468, 'Other', 'other', 1, 0, 'service', 1355553131),
(477, 0, 'Non-Academic Tutorial', 'non-academic-tutorial', 1, 0, 'service', 1355553144),
(478, 477, 'Piano Lesson', 'piano-lesson', 1, 0, 'service', 1355553171),
(479, 477, 'Voice Lesson', 'voice-lesson', 1, 0, 'service', 1355553182),
(480, 477, 'Other Musical Instruments', 'other-musical-instruments', 1, 0, 'service', 1355553197),
(481, 477, 'Other Musical Instruments', 'other-musical-instruments', 1, 0, 'service', 1355553212),
(482, 0, 'Web Design', 'web-design', 1, 0, 'service', 1355553230),
(483, 0, 'Writing and Editorial', 'writing-and-editorial', 1, 0, 'service', 1355553240),
(484, 0, 'Other Services-Uncategorized', 'other-services-uncategorized', 1, 0, 'service', 1355553249),
(485, 0, 'Work-At-Home Business', 'work-at-home-business', 1, 0, 'bussiness', 1355553504),
(486, 0, 'Multi-Level Marketing (MLM)', 'multi-level-marketing-(mlm)', 1, 0, 'bussiness', 1355553514),
(487, 0, 'Direct Selling', 'direct-selling', 1, 0, 'bussiness', 1355553897),
(488, 0, 'Distributorship', 'distributorship', 1, 0, 'bussiness', 1355553916),
(489, 0, 'Drop and Shipping Business', 'drop-and-shipping-business', 1, 0, 'bussiness', 1355554073),
(490, 0, 'Franchising', 'franchising', 1, 0, 'bussiness', 1355554083),
(491, 0, 'ECommerce Business', 'ecommerce-business', 1, 0, 'bussiness', 1355554113),
(492, 0, 'Other', 'other', 1, 0, 'bussiness', 1355554122),
(493, 36, 'Auction', 'auction', 1, 0, 'community', 1355554599),
(494, 36, 'Classes and Training', 'classes-and-training', 1, 0, 'community', 1355554615),
(496, 36, 'Charity', 'charity', 1, 0, 'community', 1355555165),
(497, 36, 'Concerts', 'concerts', 1, 0, 'community', 1355555269),
(498, 36, 'Bazaar and Grand Sale Events', 'bazaar-and-grand-sale-events', 1, 0, 'community', 1355555292),
(499, 36, 'Workshops, and Seminars ', 'workshops-and-seminars-', 1, 0, 'community', 1355555307),
(500, 36, 'Family and Recreational ', 'family-and-recreational-', 1, 0, 'community', 1355555321),
(501, 36, 'Exhibits ', 'exhibits-', 1, 0, 'community', 1355555334),
(502, 36, 'Stage Performances and Theaters ', 'stage-performances-and-theaters-', 1, 0, 'community', 1355555355),
(503, 36, 'Resumes', 'resumes', 1, 0, 'community', 1355555370),
(504, 36, 'Small Gigs', 'small-gigs', 1, 0, 'community', 1355555385),
(505, 36, 'Musical Events', 'musical-events', 1, 0, 'community', 1355555446),
(506, 36, 'Holiday Events', 'holiday-events', 1, 0, 'community', 1355555462),
(507, 36, 'Forum', 'forum', 1, 0, 'community', 1355555476),
(508, 36, 'Special Events', 'special-events', 1, 0, 'community', 1355555489),
(509, 36, 'Nightlife and Live Bands ', 'nightlife-and-live-bands-', 1, 0, 'community', 1355555504),
(510, 36, 'Other', 'other', 1, 0, 'community', 1355555533);

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

--
-- Table structure for table `mk_cities`
--

CREATE TABLE IF NOT EXISTS `mk_cities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `country_id` mediumint(5) NOT NULL,
  `region_id` mediumint(6) NOT NULL,
  `title` char(40) NOT NULL,
  `latitude` float NOT NULL,
  `longitude` float NOT NULL,
  `time_zone` varchar(40) NOT NULL,
  `dma_id` mediumint(9) NOT NULL,
  `code` varchar(5) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=43104 ;

--
-- Dumping data for table `mk_cities`
--

INSERT INTO `mk_cities` (`id`, `country_id`, `region_id`, `title`, `latitude`, `longitude`, `time_zone`, `dma_id`, `code`) VALUES
(42965, 0, 3534, 'Ipil', 0, 0, '', 0, ''),
(42966, 0, 3535, 'Dapitan City', 0, 0, '', 0, ''),
(42967, 0, 3535, 'Dipolog City', 0, 0, '', 0, ''),
(42968, 0, 3536, 'Tandag City', 0, 0, '', 0, ''),
(42969, 0, 3536, 'Bislig City', 0, 0, '', 0, ''),
(42970, 0, 3537, 'Surigao City', 0, 0, '', 0, ''),
(42971, 0, 3538, 'Jolo', 0, 0, '', 0, ''),
(42972, 0, 3539, 'Isulan', 0, 0, '', 0, ''),
(42973, 0, 3540, 'Maasin City', 0, 0, '', 0, ''),
(42975, 0, 3541, 'Siquijor City', 0, 0, '', 0, ''),
(42976, 0, 3542, 'Alabel', 0, 0, '', 0, ''),
(42977, 0, 3543, 'Calbayog', 0, 0, '', 0, ''),
(42978, 0, 3543, 'Catbalogan', 0, 0, '', 0, ''),
(42979, 0, 3544, 'Romblon', 0, 0, '', 0, ''),
(42980, 0, 3545, 'Cabarroguis', 0, 0, '', 0, ''),
(42986, 0, 3546, 'Calapan City', 0, 0, '', 0, ''),
(42987, 0, 3547, 'Mamburao', 0, 0, '', 0, ''),
(42988, 0, 3546, 'Calapan City', 0, 0, '', 0, ''),
(42989, 0, 3548, 'Bayombong', 0, 0, '', 0, ''),
(42990, 0, 3549, 'Cabanatuan City', 0, 0, '', 0, ''),
(42991, 0, 3549, 'Gapan City', 0, 0, '', 0, ''),
(42992, 0, 3549, 'Palayan City', 0, 0, '', 0, ''),
(42993, 0, 3549, 'San Jose City', 0, 0, '', 0, ''),
(42994, 0, 3549, 'Science City of Muñoz', 0, 0, '', 0, ''),
(43010, 0, 3550, 'Bontoc', 0, 0, '', 0, ''),
(43017, 0, 3551, 'Manila', 0, 0, '', 0, ''),
(43018, 0, 3551, 'Mandaluyong', 0, 0, '', 0, ''),
(43019, 0, 3551, 'Marikina', 0, 0, '', 0, ''),
(43020, 0, 3551, 'Pasig', 0, 0, '', 0, ''),
(43021, 0, 3551, 'Quezon City', 0, 0, '', 0, ''),
(43022, 0, 3551, 'San Juan', 0, 0, '', 0, ''),
(43023, 0, 3551, 'Las Piñas', 0, 0, '', 0, ''),
(43024, 0, 3551, 'Makati', 0, 0, '', 0, ''),
(43025, 0, 3551, 'Muntinlupa', 0, 0, '', 0, ''),
(43026, 0, 3551, 'Parañaque', 0, 0, '', 0, ''),
(43027, 0, 3551, 'Pasay', 0, 0, '', 0, ''),
(43028, 0, 3551, 'Pateros', 0, 0, '', 0, ''),
(43029, 0, 3551, 'Taguig', 0, 0, '', 0, ''),
(43030, 0, 3551, 'Caloocan', 0, 0, '', 0, ''),
(43031, 0, 3551, 'Malabon', 0, 0, '', 0, ''),
(43032, 0, 3551, 'Navotas', 0, 0, '', 0, ''),
(43033, 0, 3551, 'Valenzuela', 0, 0, '', 0, ''),
(43034, 0, 3552, ' Masbate City', 0, 0, '', 0, ''),
(43035, 0, 3553, 'Boac', 0, 0, '', 0, ''),
(43036, 0, 3554, 'Buluan', 0, 0, '', 0, ''),
(43038, 0, 3555, 'Marawi City', 0, 0, '', 0, ''),
(43039, 0, 3556, 'Iligan City', 0, 0, '', 0, ''),
(43040, 0, 3556, 'Iligan City', 0, 0, '', 0, ''),
(43043, 0, 3557, 'Tabuk City', 0, 0, '', 0, ''),
(43045, 0, 3558, 'Cauayan City', 0, 0, '', 0, ''),
(43046, 0, 3558, 'Ilagan City2', 0, 0, '', 0, ''),
(43047, 0, 3558, 'Santiago City3', 0, 0, '', 0, ''),
(43048, 0, 3559, 'Laoag City', 0, 0, '', 0, ''),
(43049, 0, 3559, 'Batac City', 0, 0, '', 0, ''),
(43050, 0, 3560, 'Lagawe', 0, 0, '', 0, ''),
(43051, 0, 3561, 'Jordan', 0, 0, '', 0, ''),
(43052, 0, 3562, 'Borongan City', 0, 0, '', 0, ''),
(43053, 0, 3563, 'San Jose', 0, 0, '', 0, ''),
(43055, 0, 3564, 'Davao City', 0, 0, '', 0, ''),
(43056, 0, 3564, 'Digos City', 0, 0, '', 0, ''),
(43060, 0, 3565, 'Cotabato City', 0, 0, '', 0, ''),
(43061, 0, 3565, 'Kidapawan City', 0, 0, '', 0, ''),
(43062, 0, 3566, 'Nabunturan', 0, 0, '', 0, ''),
(43063, 0, 3567, 'Danao City', 0, 0, '', 0, ''),
(43064, 0, 3567, 'Talisay City', 0, 0, '', 0, ''),
(43065, 0, 3567, 'Toledo City', 0, 0, '', 0, ''),
(43066, 0, 3567, 'Bogo City', 0, 0, '', 0, ''),
(43067, 0, 3567, 'Carcar City', 0, 0, '', 0, ''),
(43068, 0, 3567, 'Naga City', 0, 0, '', 0, ''),
(43073, 0, 3568, 'Virac', 0, 0, '', 0, ''),
(43074, 0, 3569, 'Mambajao', 0, 0, '', 0, ''),
(43076, 0, 3570, 'Daet', 0, 0, '', 0, ''),
(43077, 0, 3571, 'Malolos City', 0, 0, '', 0, ''),
(43078, 0, 3571, 'Meycauayan City', 0, 0, '', 0, ''),
(43079, 0, 3571, ' San Jose del Monte City', 0, 0, '', 0, ''),
(43080, 0, 3572, 'Malaybalay City', 0, 0, '', 0, ''),
(43081, 0, 3572, 'Valencia City', 0, 0, '', 0, ''),
(43082, 0, 3573, 'Tagbilaran City', 0, 0, '', 0, ''),
(43083, 0, 3574, 'Naval', 0, 0, '', 0, ''),
(43084, 0, 3575, 'Baguio City', 0, 0, '', 0, ''),
(43085, 0, 3575, 'La Trinidad', 0, 0, '', 0, ''),
(43086, 0, 3576, 'Batangas City', 0, 0, '', 0, ''),
(43087, 0, 3576, 'Lipa City', 0, 0, '', 0, ''),
(43088, 0, 3576, 'Tanauan City', 0, 0, '', 0, ''),
(43089, 0, 3577, ' Basco', 0, 0, '', 0, ''),
(43090, 0, 3578, 'Balanga', 0, 0, '', 0, ''),
(43091, 0, 3579, 'Isabela City', 0, 0, '', 0, ''),
(43092, 0, 3579, 'Lamitan City', 0, 0, '', 0, ''),
(43093, 0, 3580, 'Baler', 0, 0, '', 0, ''),
(43094, 0, 3581, 'Kabugao', 0, 0, '', 0, ''),
(43095, 0, 3583, 'Legazpi City', 0, 0, '', 0, ''),
(43096, 0, 3583, 'Ligao City', 0, 0, '', 0, ''),
(43097, 0, 3583, 'Tabaco City', 0, 0, '', 0, ''),
(43098, 0, 3584, 'Kalibo', 0, 0, '', 0, ''),
(43099, 0, 3585, 'Bayugan City', 0, 0, '', 0, ''),
(43100, 0, 3586, 'Butuan', 0, 0, '', 0, ''),
(43102, 0, 3586, 'Cabadbaran City', 0, 0, '', 0, ''),
(43103, 0, 3587, 'Bangued', 0, 0, '', 0, '');

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

--
-- Table structure for table `mk_communities`
--

CREATE TABLE IF NOT EXISTS `mk_communities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adv_id` int(11) NOT NULL,
  `address` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `contact` tinytext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `mk_contacts`
--

CREATE TABLE IF NOT EXISTS `mk_contacts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `firstname` varchar(50) NOT NULL,
  `lastname` varchar(50) NOT NULL,
  `title` varchar(250) NOT NULL,
  `subject` varchar(250) NOT NULL,
  `email` varchar(250) NOT NULL,
  `content` text NOT NULL,
  `company` varchar(250) NOT NULL,
  `created` int(11) NOT NULL,
  `phone` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `mk_contacts`
--

INSERT INTO `mk_contacts` (`id`, `firstname`, `lastname`, `title`, `subject`, `email`, `content`, `company`, `created`, `phone`) VALUES
(1, 'sdaf', 'asdf', 'asdf', 'asdf', 'tam@giaiphapnhanh.com.vn', 'asdf', 'sdf', 1354935668, 'asf'),
(2, 'asf', 'asdf', 'sdaf', 'sadf', 'tam@yahoo.com', 'asdf', '123a', 1354935885, 'sadf'),
(3, 'fsdf', 'asdf', 'asdf', 'asdf', 'tam_duy24@yahoo.com', 'asdf', 'sadf', 1354935933, 'asf');

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

--
-- Table structure for table `mk_google_ad`
--

CREATE TABLE IF NOT EXISTS `mk_google_ad` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8_unicode_ci,
  `page` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `position` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `image` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `published` int(11) DEFAULT NULL,
  `ordering` int(11) DEFAULT NULL,
  `created` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=12 ;

--
-- Dumping data for table `mk_google_ad`
--

INSERT INTO `mk_google_ad` (`id`, `title`, `content`, `page`, `position`, `image`, `published`, `ordering`, `created`) VALUES
(1, 'asdf', '<script>adf</script><div>asdf</div>', NULL, 'left', '295933_419002658135639_1931300556_n.jpg', 1, 1, 1354776994),
(2, 'abc', '<script type="text/javascript"><!--\r\n                google_ad_client = "ca-pub-9600490168678620";\r\n                /* iPinoyWideSkyscraper160x600ImageOnly */\r\n                google_ad_slot = "2388455675";\r\n                google_ad_width = 160;\r\n                google_ad_height = 600;\r\n                //-->\r\n            </script> \r\n<script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>', 'index', 'left', '531113_10151228866868948_1374386990_n.jpg', 1, 2, 1354870024),
(3, 'Adv index right', '            <script type="text/javascript"><!--\n                google_ad_client = "ca-pub-9600490168678620";\n                /* iPinoy728x90-ImageOnly */\n                google_ad_slot = "5299246814";\n                google_ad_width = 928;\n                google_ad_height = 90;\n                //-->\n            </script>\n            <script type="text/javascript"\n                    src="http://pagead2.googlesyndication.com/pagead/show_ads.js">\n            </script>', 'index', 'right_middle', NULL, 1, 0, 1355482944),
(6, 'right', '<script type="text/javascript"><!--\ngoogle_ad_client = "ca-pub-9600490168678620";\n/* iPinoy250x250-ImageOnly */\ngoogle_ad_slot = "2279780645";\ngoogle_ad_width = 250;\ngoogle_ad_height = 250;\n//-->\n</script>\n<script type="text/javascript"\nsrc="http://pagead2.googlesyndication.com/pagead/show_ads.js">\n</script>', 'detail', 'right', NULL, 1, 0, 1355403999),
(8, 'bot', '<script type="text/javascript"><!--\ngoogle_ad_client = "ca-pub-9600490168678620";\n/* iPinoy728x90-ImageOnly */\ngoogle_ad_slot = "5299246814";\ngoogle_ad_width = 728;\ngoogle_ad_height = 90;\n//-->\n</script>\n<script type="text/javascript"\nsrc="http://pagead2.googlesyndication.com/pagead/show_ads.js">\n</script>', 'detail', 'bottom', NULL, 1, 0, 1355404116),
(9, 'gga', '<script type="text/javascript"><!--\ngoogle_ad_client = "ca-pub-9600490168678620";\n/* iPinoy728x90TextOnly */\ngoogle_ad_slot = "3341629500";\ngoogle_ad_width = 728;\ngoogle_ad_height = 90;\n//-->\n</script>\n<script type="text/javascript"\nsrc="http://pagead2.googlesyndication.com/pagead/show_ads.js">\n</script>\n', 'detail', 'top', NULL, 1, 0, 1355565338),
(10, 'Bottom right', '<script type="text/javascript"><!--\n                            google_ad_client = "ca-pub-9600490168678620";\n                            /* iPinoy728x90-ImageOnly */\n                            google_ad_slot = "5299246814";\n                            google_ad_width = 728;\n                            google_ad_height = 90;\n                            //-->\n                        </script>\n                        <script type="text/javascript"\n                                src="http://pagead2.googlesyndication.com/pagead/show_ads.js">\n                        </script>', 'index', 'right_bottom', NULL, 1, 0, 1355482813),
(11, 'right top', '        <script type="text/javascript"><!--\n                google_ad_client = "ca-pub-9600490168678620";\n                /* iPinoy728x90-ImageOnly */\n                google_ad_slot = "5299246814";\n                google_ad_width = 928;\n                google_ad_height = 90;\n                //-->\n            </script>\n            <script type="text/javascript"\n                    src="http://pagead2.googlesyndication.com/pagead/show_ads.js">\n            </script>', 'index', 'right_top', NULL, 1, 0, 1355562276);

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

--
-- Table structure for table `mk_jobs`
--

CREATE TABLE IF NOT EXISTS `mk_jobs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adv_id` int(11) NOT NULL,
  `item_number` int(11) DEFAULT NULL,
  `location` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `qualification` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `poster_type` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `classification` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `salary_offer` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `salary` float DEFAULT NULL,
  `company_name` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `company_address` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone_number` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `posted_by` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `contact` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;

--
-- Dumping data for table `mk_jobs`
--

INSERT INTO `mk_jobs` (`id`, `adv_id`, `item_number`, `location`, `qualification`, `poster_type`, `classification`, `salary_offer`, `salary`, `company_name`, `company_address`, `phone_number`, `posted_by`, `contact`) VALUES
(1, 21, 1, 'c', 'a', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2, 22, 2, 'c', 'a', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4, 35, 0, 'adad', 'asda adasd', 'Company Direct Hire', 'Full-Time', 'Hourly', 2222, '0', 'adada', '123132', 'Business Owner', 'asdada asdasada'),
(5, 47, NULL, 'asdf', '1', 'Company Direct Hire', 'Part-Time', 'Hourly', 123, 'sadf', 'asdf', '123', 'Job Recruiter', 'asdf');

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

--
-- Table structure for table `mk_oauth`
--

CREATE TABLE IF NOT EXISTS `mk_oauth` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `provider` varchar(10) NOT NULL,
  `provider_id` int(11) NOT NULL,
  `access_token` varchar(45) NOT NULL,
  `access_token_secret` varchar(45) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `mk_permission`
--

CREATE TABLE IF NOT EXISTS `mk_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `box_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `add_` int(11) DEFAULT NULL,
  `edit_` int(11) DEFAULT NULL,
  `del_` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=55 ;

--
-- Dumping data for table `mk_permission`
--

INSERT INTO `mk_permission` (`id`, `box_id`, `user_id`, `add_`, `edit_`, `del_`) VALUES
(14, 1, 21, 1, 0, 1),
(15, 2, 21, 0, 1, 0),
(16, 3, 22, 1, 1, 1),
(17, 4, 22, 1, 1, 1),
(18, 2, 21, 0, 1, 0),
(19, 1, 21, 1, 0, 1),
(20, 3, 22, 1, 1, 1),
(21, 1, 21, 1, 0, 1),
(22, 4, 22, 1, 1, 1),
(23, 1, 22, 1, 1, 1),
(24, 4, 21, 1, 0, 1),
(25, 3, 21, 1, 1, 1),
(26, 2, 22, 1, 1, 0),
(27, 9, 21, 1, 0, 0),
(28, 15, 1, 1, 1, 1),
(29, 1, 1, 1, 1, 1),
(30, 2, 1, 1, 1, 1),
(31, 3, 1, 1, 1, 1),
(32, 4, 1, 1, 1, 1),
(33, 5, 1, 1, 1, 1),
(34, 6, 1, 1, 1, 1),
(35, 7, 1, 1, 1, 1),
(36, 8, 1, 1, 1, 1),
(37, 9, 1, 1, 1, 1),
(38, 10, 1, 1, 1, 1),
(39, 11, 1, 1, 1, 1),
(40, 12, 1, 1, 1, 1),
(41, 13, 1, 1, 1, 1),
(42, 14, 1, 1, 1, 1),
(43, 16, 1, 1, 1, 1),
(44, 11, 21, 0, 0, 0),
(45, 5, 21, 0, 0, 0),
(46, 6, 21, 0, 0, 0),
(47, 7, 21, 0, 0, 0),
(48, 8, 21, 0, 0, 0),
(49, 10, 21, 0, 0, 0),
(50, 12, 21, 0, 0, 0),
(51, 13, 21, 0, 0, 0),
(52, 14, 21, 0, 0, 0),
(53, 15, 21, 0, 0, 0),
(54, 16, 21, 0, 0, 0);

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

--
-- Table structure for table `mk_properties`
--

CREATE TABLE IF NOT EXISTS `mk_properties` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adv_id` int(11) NOT NULL,
  `propert_name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `classification` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `this_is` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `bedroom` int(11) NOT NULL,
  `bathroom` int(11) NOT NULL,
  `kitchen` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `garage` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `maids_quarter` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `condition` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `location` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lot_area` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `payment` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `poster_type` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `contact` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `price` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;

--
-- Dumping data for table `mk_properties`
--

INSERT INTO `mk_properties` (`id`, `adv_id`, `propert_name`, `type`, `classification`, `this_is`, `bedroom`, `bathroom`, `kitchen`, `garage`, `maids_quarter`, `condition`, `location`, `lot_area`, `payment`, `poster_type`, `contact`, `price`) VALUES
(1, 31, 'a', 'b', '', 'c', 0, 0, NULL, '', '', NULL, NULL, NULL, NULL, NULL, NULL, '12'),
(3, 39, '', 'Apartments', 'For rent', NULL, 1, 1, 'New', '1 Car', 'Yes', 'Newly Built', 'ss', 'ss', 'ss', 'Direct Owner', 'asadasd', '19');

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

--
-- Table structure for table `mk_provinces`
--

CREATE TABLE IF NOT EXISTS `mk_provinces` (
  `id` mediumint(6) NOT NULL AUTO_INCREMENT,
  `country_id` mediumint(6) NOT NULL,
  `title` varchar(40) NOT NULL,
  `code` char(5) NOT NULL,
  `adm1code` char(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3588 ;

--
-- Dumping data for table `mk_provinces`
--

INSERT INTO `mk_provinces` (`id`, `country_id`, `title`, `code`, `adm1code`) VALUES
(3534, 0, 'Zamboanga Sibugay', '', ''),
(3535, 0, 'Zamboanga del Norte', '', ''),
(3536, 0, 'Surigao del Sur', '', ''),
(3537, 0, ' Surigao del Norte', '', ''),
(3538, 0, 'Sulu', '', ''),
(3539, 0, 'Sultan Kudarat', '', ''),
(3540, 0, 'Southern Leyte', '', ''),
(3541, 0, 'Siquijor', '', ''),
(3542, 0, 'Sarangani', '', ''),
(3543, 0, 'Samar', '', ''),
(3544, 0, 'Romblon', '', ''),
(3545, 0, 'Quirino', '', ''),
(3546, 0, ' Oriental Mindoro', '', ''),
(3547, 0, 'Occidental Mindoro', '', ''),
(3548, 0, 'Nueva Vizcaya', '', ''),
(3549, 0, 'Nueva Ecija', '', ''),
(3550, 0, 'Mountain Province', '', ''),
(3551, 0, 'Metro Manila', '', ''),
(3552, 0, ' Masbate', '', ''),
(3553, 0, 'Marinduque', '', ''),
(3554, 0, 'Maguindanao', '', ''),
(3555, 0, 'Lanao del Sur', '', ''),
(3556, 0, ' Lanao del Norte', '', ''),
(3557, 0, 'Kalinga', '', ''),
(3558, 0, ' Isabela', '', ''),
(3559, 0, 'Ilocos Norte', '', ''),
(3560, 0, 'Ifugao', '', ''),
(3561, 0, 'Guimaras', '', ''),
(3562, 0, ' Eastern Samar', '', ''),
(3563, 0, 'Dinagat Islands', '', ''),
(3564, 0, 'Davao del Sur', '', ''),
(3565, 0, 'Cotabato', '', ''),
(3566, 0, ' Compostela Valley', '', ''),
(3567, 0, 'Cebu', '', ''),
(3568, 0, 'Catanduanes', '', ''),
(3569, 0, 'Camiguin', '', ''),
(3570, 0, 'Camarines Norte', '', ''),
(3571, 0, 'Bulacan', '', ''),
(3572, 0, 'Bukidnon', '', ''),
(3573, 0, 'Bohol', '', ''),
(3574, 0, 'Biliran', '', ''),
(3575, 0, ' Benguet', '', ''),
(3576, 0, 'Batangas', '', ''),
(3577, 0, ' Batanes', '', ''),
(3578, 0, 'Bataan', '', ''),
(3579, 0, ' Basilan', '', ''),
(3580, 0, 'Aurora', '', ''),
(3581, 0, 'Apayao', '', ''),
(3582, 0, 'Antique', '', ''),
(3583, 0, 'Albay', '', ''),
(3584, 0, ' Aklan', '', ''),
(3585, 0, 'Agusan del Sur', '', ''),
(3586, 0, 'Agusan del Norte', '', ''),
(3587, 0, 'Abra', '', '');

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

--
-- Table structure for table `mk_reports`
--

CREATE TABLE IF NOT EXISTS `mk_reports` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `type` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `created` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=11 ;

--
-- Dumping data for table `mk_reports`
--

INSERT INTO `mk_reports` (`id`, `item_id`, `user_id`, `type`, `created`, `status`) VALUES
(3, 46, 13, 'ad', 1355285440, 0),
(4, 46, 13, 'ad', 1355285503, 0),
(5, 45, 13, 'ad', 1355286589, 0),
(6, 46, 8, 'ad', 1355301468, 0),
(7, 35, 8, 'ad', 1355301740, 0),
(8, 45, 13, 'ad', 1355399868, 0),
(9, 50, 21, 'ad', 1355467167, 0),
(10, 37, 8, 'ad', 1355492640, 0);

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

--
-- Table structure for table `mk_services`
--

CREATE TABLE IF NOT EXISTS `mk_services` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adv_id` int(11) NOT NULL,
  `address` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `contact` tinytext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;

--
-- Dumping data for table `mk_services`
--

INSERT INTO `mk_services` (`id`, `adv_id`, `address`, `contact`) VALUES
(1, 23, 'abc', ''),
(2, 24, 'defabc', ''),
(3, 48, '12 ASDF', '10201020'),
(4, 49, 'Please call our office prior to your first visit to give us your insurance information. \n\nWe will gladly file the insurance paper work for you and work with you to get you the maximum insurance benefi', '0');

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

--
-- Table structure for table `mk_settings`
--

CREATE TABLE IF NOT EXISTS `mk_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `key` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `value` text COLLATE utf8_unicode_ci NOT NULL,
  `autoload` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;

--
-- Dumping data for table `mk_settings`
--

INSERT INTO `mk_settings` (`id`, `key`, `value`, `autoload`) VALUES
(1, 'google_oauth', '{"application_id":"807397577789-h52p5j8advv1pv85mrvc2pgoch90gaks.apps.googleusercontent.com","application_secret":"76r3QDCz_KCIRMRMEP47l_83","redirect_uri":"http:\\/\\/hoanvusolutions.com\\/ci_freemarket\\/oauth\\/google"}', 0),
(2, 'twitter_oauth', '{"application_id":"rLooPJo9Fo0sUxdN3AJRgw","application_secret":"yCyUglNT0UlOF1PNvLou0SNgwPXnRAAC1js3UYyIoJg","redirect_uri":"http:\\/\\/localhost\\/ci_freemarket\\/oauth\\/twitter"}', 0),
(3, 'facebook_oauth', '{"application_id":"rLooPJo9Fo0sUxdN3AJRgw","application_secret":"yCyUglNT0UlOF1PNvLou0SNgwPXnRAAC1js3UYyIoJg","redirect_uri":"http:\\/\\/localhost\\/ci_freemarket\\/oauth\\/twitter"}', 0);

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

--
-- Table structure for table `mk_slide`
--

CREATE TABLE IF NOT EXISTS `mk_slide` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(160) COLLATE utf8_unicode_ci NOT NULL,
  `summary` tinytext COLLATE utf8_unicode_ci NOT NULL,
  `images` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `url` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `ordering` int(11) NOT NULL,
  `published` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `mk_stat`
--

CREATE TABLE IF NOT EXISTS `mk_stat` (
  `id` int(11) NOT NULL,
  `total_adv` int(11) DEFAULT NULL,
  `total_buysell_ad` int(11) NOT NULL,
  `total_service_ad` int(11) NOT NULL,
  `total_community_ad` int(11) NOT NULL,
  `total_vehicle_ad` int(11) NOT NULL,
  `total_job_ad` int(11) NOT NULL,
  `total_business_ad` int(11) NOT NULL,
  `total_property_ad` int(11) NOT NULL,
  `total_member` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `mk_stat`
--

INSERT INTO `mk_stat` (`id`, `total_adv`, `total_buysell_ad`, `total_service_ad`, `total_community_ad`, `total_vehicle_ad`, `total_job_ad`, `total_business_ad`, `total_property_ad`, `total_member`) VALUES
(1, 108, 5, 2, 0, 0, 1, 0, 0, 100);

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

--
-- Table structure for table `mk_subcribers`
--

CREATE TABLE IF NOT EXISTS `mk_subcribers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Dumping data for table `mk_subcribers`
--

INSERT INTO `mk_subcribers` (`id`, `name`, `email`) VALUES
(1, 'Your Name', 'admin@gmail.com'),
(2, 'Your Name', 'abc@gmail.com');

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

--
-- Table structure for table `mk_supports`
--

CREATE TABLE IF NOT EXISTS `mk_supports` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `question` varchar(250) NOT NULL DEFAULT '',
  `alias` varchar(250) NOT NULL DEFAULT '',
  `answer` text NOT NULL,
  `published` tinyint(1) NOT NULL,
  `ordering` int(11) NOT NULL,
  `date` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `mk_users`
--

CREATE TABLE IF NOT EXISTS `mk_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `location_address` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `office_address` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `avatar` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `provider` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `provider_id` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  `access_token` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `access_token_secret` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `link` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created` int(11) DEFAULT NULL,
  `role` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=26 ;

--
-- Dumping data for table `mk_users`
--

INSERT INTO `mk_users` (`id`, `username`, `password`, `type`, `name`, `location_address`, `office_address`, `email`, `phone`, `avatar`, `provider`, `provider_id`, `access_token`, `access_token_secret`, `link`, `created`, `role`) VALUES
(1, 'admin', 'e10adc3949ba59abbe56e057f20f883e', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, '', NULL, 'admin'),
(3, 'user2', 'e10adc3949ba59abbe56e057f20f883e', '', 'User2', '123', '123', 'user', '123', '', NULL, NULL, NULL, NULL, '', NULL, 'user'),
(4, 'User1', 'c56d0e9a7ccec67b4ea131655038d604', '', 'User1', '123 hcm', '123 hcm', 'user@gmail.com', '09876543', '', NULL, NULL, NULL, NULL, '', NULL, 'user'),
(5, 'asdf', '123', 'A job Recruiter', 'asdf', 'asdf', 'asdf', 'asdf@yahoo.com', '56789', '', NULL, NULL, NULL, NULL, '', NULL, NULL),
(8, '123', '202cb962ac59075b964b07152d234b70', '0', '123', '', '', '123@yahoo.com', '', '', NULL, NULL, NULL, NULL, '', NULL, NULL),
(13, 'Tuong Tran', '', '', 'Tuong Tran', '', '', 'ranger.ht@gmail.com', '', '', 'google', '112770961585632347083', 'ya29.AHES6ZQvuX06IISg3TdoLPt2I7zwo5pznho0Dp0xq8eQV', '', 'https://plus.google.com/112770961585632347083', 1354940466, 'user'),
(17, 'HtTuong', '', '', 'Tuong Tran', '', '', NULL, '', '', 'twitter', '996265122', '996265122-xvpleN5UVN81jR0tnPYS7pI03w6fjpCvvuTNfJs2', '321RHq27VUvqdp4eCoFVTIN1IfPHYZVOHes02zC9Pk', NULL, 1354941237, 'user'),
(18, 'Nguyễn Quốc Triệu', '', '', 'Nguyễn Quốc Triệu', '', '', 'nqtrieu2011@gmail.com', '', NULL, 'google', '106202945450754632678', 'ya29.AHES6ZSOczKOvXqE7dJnPzjwV9IPYLmo4iFsJCcDrV-P-', '', 'https://plus.google.com/106202945450754632678', 1355232312, 'user'),
(20, 'phamduytam', '202cb962ac59075b964b07152d234b70', 'a Buyer', 'phamduytam', 'lksdf', 'laskdf', 'phamduytam@yahoo.com', '123123', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(21, 'Minh', 'e10adc3949ba59abbe56e057f20f883e', 'a Buyer', 'Huu', '12 HDMT', 'HANTS', 'ptmhuu@gmail.com', '101010101010101', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(22, 'universe company', '', '', 'universe company', '', '', 'hvtransco@gmail.com', '', NULL, 'google', '108017338663855784310', 'ya29.AHES6ZRwf-NPsZxNRdf9gy6FdCE2RIPvZ3X_WKDaCjUhC', '', NULL, 1355544783, 'user'),
(23, 'Pinky M.', '', '', 'Pinky M.', '', '', 'goingplacesinasia@yahoo.com', '', NULL, 'google', '105503752171807289495', 'ya29.AHES6ZQcbFMNimPaB-ZJZ5KXUWcDWc-MgN25L_SGatPNx', '', NULL, 1355546520, 'user'),
(24, 'tmhai', '70a0f9894d2df18c2507d231a94caee8', 'a Buyer or a Seller', 'hai', 'erer', 'erere', 'truong_minhhai@yahoo.com', '1213232434', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(25, 'pinky', 'e10adc3949ba59abbe56e057f20f883e', 'a Seller', 'Miss Smith', 'USA', 'USA', 'arianna07728@yahoo.com', '101200120', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `mk_verhicles`
--

CREATE TABLE IF NOT EXISTS `mk_verhicles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adv_id` int(11) NOT NULL,
  `item_number` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `brand` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `model_year` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `fuel_type` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mileage` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `condition` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `negotiable` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `model_type` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `engine_type` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `accessory` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `payment` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `contact` text COLLATE utf8_unicode_ci,
  `price` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Dumping data for table `mk_verhicles`
--

INSERT INTO `mk_verhicles` (`id`, `adv_id`, `item_number`, `type`, `brand`, `model_year`, `fuel_type`, `mileage`, `condition`, `negotiable`, `model_type`, `engine_type`, `accessory`, `address`, `payment`, `contact`, `price`) VALUES
(1, 25, '11', NULL, 'a', 'b1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '121'),
(2, 37, '0', 'Car', 'Chrysler', '1978', 'Diesel', '61,000-70,000 Km', 'Second Hand', 'Other', 'asdasd', 'asdsad', 'asdsad', 'adsad', 'asd', 'adasdas', '1123');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;