· 11 years ago · Mar 07, 2015, 03:42 PM
1-- phpMyAdmin SQL Dump
2-- version 3.5.2.2
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Dec 17, 2012 at 12:52 PM
7-- Server version: 5.5.27
8-- PHP Version: 5.4.7
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `market`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `mk_advertises`
27--
28
29CREATE TABLE IF NOT EXISTS `mk_advertises` (
30 `id` int(11) NOT NULL AUTO_INCREMENT,
31 `website` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
32 `email` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
33 `user_id` int(11) NOT NULL,
34 `title` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
35 `alias` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
36 `summary` tinytext COLLATE utf8_unicode_ci,
37 `content` text COLLATE utf8_unicode_ci,
38 `image` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
39 `type` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
40 `category_id` int(11) NOT NULL,
41 `created` int(11) DEFAULT NULL,
42 `updated` int(11) DEFAULT NULL,
43 `city_id` int(11) DEFAULT NULL,
44 `province_id` int(11) DEFAULT NULL,
45 `published` tinyint(1) NOT NULL DEFAULT '0',
46 `ordering` int(11) DEFAULT NULL,
47 `negotiable` tinyint(1) DEFAULT '0',
48 `total_view` int(11) NOT NULL,
49 PRIMARY KEY (`id`)
50) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=54 ;
51
52--
53-- Dumping data for table `mk_advertises`
54--
55
56INSERT 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
57(2, NULL, 'pndtam@gmail.com', 1, 'abcd', 'abcd', 'abc', 'def', '15fc7bc19277da666d96a9175f8a9810.jpg', 'job', 34, 1354357171, 1354357171, 3, 2, 1, 2, NULL, 0),
58(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),
59(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),
60(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),
61(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),
62(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),
63(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),
64(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),
65(35, NULL, 'tam_duy24@yahoo.com', 1, 'asda', 'asd', 'adasd', 'adasd', '', 'job', 34, 1354959367, 1354959972, 0, 3530, 1, 0, 0, 0),
66(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),
67(39, 'assad', 'ranger.ht@gmail.com', 13, 'ss', '', 'asdsad', '<p>asdsad</p>', NULL, 'property', 33, NULL, 1355114989, 0, 3532, 1, 0, 1, 2),
68(40, '', 'ranger.ht@gmail.com', 13, 'asd', '', 'sda', '<p>adad</p>', '', 'buy_sell', 30, NULL, 1355399490, 0, 0, 1, 0, 1, 0),
69(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),
70(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),
71(45, NULL, 'pndtam@gmail.com', 1, 'ssdsd', 'ssdsd', 'ewr', '<p> erer</p>', 'avatar.jpg', 'buy_sell', 31, 1355194827, 1355194827, 0, 3532, 1, 0, 0, 0),
72(46, '', 'ranger.ht@gmail.com', 13, 'asda', '', 'adasd', '<p>adad</p>', 'avatar1.jpg', 'buy_sell', 30, 1355280770, 1355280806, 0, 3399, 1, 0, 1, 0),
73(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),
74(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. </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. </span>', 'c39c37d39e9102b7cec7126ea325dc7e.jpg', 'service', 32, 1355396702, NULL, 43099, 3585, 0, NULL, 1, 0),
75(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),
76(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> 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.</p>', 'TN135537449050c95f9a79717.jpg', 'buy_sell', 41, 1355456243, 1355456243, 43103, 3587, 1, 0, 0, 0),
77(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> Táºn hưởng kỳ nghỉ 2N1Ä dành cho 2 ngÆ°á»i tại Rock Water Bay Beach Resort & Spa, phòng Duluxe Ocean View Villa, Ä‚n tối và Dịch Vụ Spa.</p>', 'thumb135536772750c9452fe5ce7.jpg', 'buy_sell', 41, 1355457292, 1355457317, 43102, 3586, 0, 0, 0, 0),
78(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),
79(53, 'sadf', '123@yahoo.com', 8, 'sdf', '', 'asdf', '<p>Tại kyÌ€ hoÌ£p HÄND HaÌ€ NôÌ£i vÆ°Ì€a qua, thảo luáºn vá» Nghị quyết vá» tổng biên chế hành chính, sá»± nghiệp của Hà Ná»™i, ông Trần Trá»ng Dá»±c, Chủ nhiệm Uá»· ban Kiểm tra Thành uá»· Hà Ná»™i Ä‘ã coÌ phaÌt biểu khiêÌn dÆ° luâÌ£n thÆ°Ì£c sÆ°Ì£ sôÌc. “Chúng tôi phát hiện ra 2 giáo viên có Ä‘ánh dấu bài của thí sinh để chấm bài. Tôi Ä‘ã yêu cầu lãnh đạo trÆ°á»ng Ä‘ào tạo cán bá»™ Lê Hồng Phong phải kiểm Ä‘iểm và xem xét trách nhiệm vá»›i hai giáo viên này”. Ông Dá»±c nháºn định: “Bây giá» ngÆ°á»i ta nói rằng dÆ°á»›i 100 triệu không Ä‘á»— Ä‘âu… Chất lượng thi công chức không ổn má»™t tý nào váºy lấy gì đảm bảo chất lượng?”.</p>\n<p>Kể lại sá»± việc này vÆ¡Ìi chuÌng tôi, má»™t nhân chứng trong kỳ thi nói trên (xin giâÌu tên) cho biêÌt: Äầu năm 2012, kỳ thi công chức diá»…n ra tại Ä‘Æ¡n vị mà anh Ä‘ang được Ä‘ào tạo. “Äây cÅ©ng là lúc “sếp trưởng” sắp vá» hÆ°u nên ai muốn Ä‘á»— công chức Ä‘á»u tranh thủ “quan hệ” vá»›i sếp. Tuy nhiên, má»i việc quá lá»™ liá»…u, cấp trên cá» Ä‘oàn thanh tra vá» theo dõi kỳ thi. Kết quả, Ä‘Æ°á»ng dây bị lá»™, 2 giám thị bị Ä‘á» nghị ká»· luáºt, những ngÆ°á»i Ä‘ã “chạy” Ä‘á»u lâm cảnh tiá»n mất táºt mang”.</p>\n<p><img src="http://hcm.24h.com.vn/upload/4-2012/images/2012-12-14/1355467440-cong-chuc-3.jpg" alt="Không tiá»n đừng “mÆ¡” công chức, Tin tức trong ngà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ý dá»± thi công chức cấp huyện (Ảnh minh há»a)</p>\n<p>VêÌ€ phát biểu của ông Trần Trá»ng Dá»±c taÌ£i phiên hoÌ£p HÄND TP.HaÌ€ NôÌ£i, ông Bùi Khánh Thụy, nguyên chuyên viê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ành ủy phải có cÆ¡ sở, có bằng chứng rõ ràng vá» việc này.</p>', '295933_419002658135639_1931300556_n18.jpg', 'buy_sell', 227, 1355491343, 1355491368, 43100, 3586, 1, 0, 1, 0);
80
81-- --------------------------------------------------------
82
83--
84-- Table structure for table `mk_blogs`
85--
86
87CREATE TABLE IF NOT EXISTS `mk_blogs` (
88 `id` int(11) NOT NULL AUTO_INCREMENT,
89 `title` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
90 `alias` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
91 `summary` text COLLATE utf8_unicode_ci NOT NULL,
92 `content` text COLLATE utf8_unicode_ci NOT NULL,
93 `created` int(11) NOT NULL,
94 `ordering` int(11) NOT NULL,
95 `published` tinyint(1) NOT NULL,
96 `type` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
97 `image` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
98 PRIMARY KEY (`id`)
99) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=15 ;
100
101--
102-- Dumping data for table `mk_blogs`
103--
104
105INSERT INTO `mk_blogs` (`id`, `title`, `alias`, `summary`, `content`, `created`, `ordering`, `published`, `type`, `image`) VALUES
106(1, 'test1', 'test1', 'asd', 'asdf', 1354768300, 1, 1, 'blogs', ''),
107(3, 'About us', 'about-us', '0', 'asdf \r\nasdf\r\nasd\r\nasdf\r\n', 1354774268, 1, 1, 'about_us', ''),
108(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'),
109(5, 'asdf', 'asdf', '0', '<p>asdf</p>', 1355300803, 0, 1, 'follow_us_on_twitter', ''),
110(6, 'sadf', 'sadf', '0', '<p>sdf</p>', 1355300810, 0, 1, 'follow_us_on_twitter', ''),
111(7, 'disclaimer', 'disclaimer', '0', '<p> asdsdsd</p>', 1355403081, 0, 1, 'disclaimer', ''),
112(8, 'privacy_policy', 'privacy_policy', '0', '<p> sss</p>', 1355403097, 0, 1, 'privacy_policy', ''),
113(9, 'Site map', 'site-map', '0', '<p>site map</p>', 1355451495, 0, 1, 'site_map', ''),
114(10, 'Terms and Conditions', 'terms-and-conditions', '0', '<p>sadf</p>', 1355451512, 0, 1, 'terms_and_conditions', ''),
115(11, 'testface', 'testface', '0', '<p>test</p>', 1355454982, 0, 1, 'follow_us_on_facebook', ''),
116(12, 'Restricted Items', 'restricted-items', '0', '<p>sdf</p>', 1355484120, 0, 1, 'restricted_items', ''),
117(13, 'For your safety', 'for-your-safety', '0', '<p>for your safety</p>', 1355484150, 0, 1, 'for_your_safety', ''),
118(14, 'Dos and Donts', 'dos-and-donts', '0', '<p>dos and donts</p>', 1355484177, 0, 1, 'dos_and_donts', '');
119
120-- --------------------------------------------------------
121
122--
123-- Table structure for table `mk_bussiness`
124--
125
126CREATE TABLE IF NOT EXISTS `mk_bussiness` (
127 `id` int(11) NOT NULL AUTO_INCREMENT,
128 `adv_id` int(11) NOT NULL,
129 `classification` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
130 `address` tinytext COLLATE utf8_unicode_ci NOT NULL,
131 `poster_type` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
132 `contact` tinytext COLLATE utf8_unicode_ci NOT NULL,
133 `price` float NOT NULL,
134 PRIMARY KEY (`id`)
135) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
136
137--
138-- Dumping data for table `mk_bussiness`
139--
140
141INSERT INTO `mk_bussiness` (`id`, `adv_id`, `classification`, `address`, `poster_type`, `contact`, `price`) VALUES
142(1, 44, 'Free Membership', 'adsasdsss', 'Agent', 'adadassd', 123212000);
143
144-- --------------------------------------------------------
145
146--
147-- Table structure for table `mk_buysell`
148--
149
150CREATE TABLE IF NOT EXISTS `mk_buysell` (
151 `id` int(11) NOT NULL AUTO_INCREMENT,
152 `adv_id` int(11) NOT NULL,
153 `item_number` int(11) NOT NULL,
154 `title` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
155 `condition` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
156 `price` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
157 `regular_price` float DEFAULT NULL,
158 `type` tinyint(1) NOT NULL,
159 PRIMARY KEY (`id`)
160) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=13 ;
161
162--
163-- Dumping data for table `mk_buysell`
164--
165
166INSERT INTO `mk_buysell` (`id`, `adv_id`, `item_number`, `title`, `condition`, `price`, `regular_price`, `type`) VALUES
167(3, 26, 3, '', 'New', '1', 1, 0),
168(5, 40, 5, '', 'New', '123123', 0, 0),
169(6, 41, 6, '', 'New', '232', 0, 0),
170(7, 45, 123213, '', 'New', '123', 1223, 0),
171(8, 46, 8, '', 'Old', '123213', 12323, 0),
172(9, 50, 0, '', 'New', '85.000', 0, 0),
173(10, 51, 10, '', 'New', '1.250.000', 0, 0),
174(11, 52, 10, '', 'New', '1200', 0, 0),
175(12, 53, 12, '', 'New', '12123', 0, 0);
176
177-- --------------------------------------------------------
178
179--
180-- Table structure for table `mk_categories`
181--
182
183CREATE TABLE IF NOT EXISTS `mk_categories` (
184 `id` int(11) NOT NULL AUTO_INCREMENT,
185 `parent_id` int(11) NOT NULL,
186 `title` varchar(250) NOT NULL,
187 `alias` varchar(250) NOT NULL,
188 `published` tinyint(1) NOT NULL,
189 `ordering` int(11) NOT NULL,
190 `type` varchar(40) NOT NULL,
191 `created` int(11) NOT NULL,
192 PRIMARY KEY (`id`)
193) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=511 ;
194
195--
196-- Dumping data for table `mk_categories`
197--
198
199INSERT INTO `mk_categories` (`id`, `parent_id`, `title`, `alias`, `published`, `ordering`, `type`, `created`) VALUES
200(30, 0, 'Antiques', '0', 1, 2, 'buy_sell', 1355475336),
201(31, 0, 'Arts and Crafts', '0', 1, 1, 'buy_sell', 1355475352),
202(32, 0, 'Accounting', '0', 1, 4, 'service', 1355544181),
203(33, 0, 'Apartments', '0', 1, 1, 'property', 1355544526),
204(34, 0, 'Accounting and Finance', '0', 1, 0, 'job', 1355537246),
205(35, 0, 'Verhicles', 'verhicles', 1, 1, 'verhicle', 1354614565),
206(36, 0, 'Bulletin Board and Events Announcements', '0', 1, 1, 'community', 1355554574),
207(38, 0, 'Online & Internet Business', '0', 1, 0, 'bussiness', 1355553480),
208(39, 31, 'Drawings and Paintings ', '0', 1, 0, 'buy_sell', 1355475367),
209(41, 31, 'Metal, Wood, and Glass ', '0', 1, 0, 'buy_sell', 1355475430),
210(42, 31, 'Photographs and Prints ', '0', 1, 0, 'buy_sell', 1355475454),
211(43, 31, 'Sculptures, Ceramic, and Clay ', '0', 1, 0, 'buy_sell', 1355475516),
212(44, 31, 'Needlework and Textiles ', '0', 1, 0, 'buy_sell', 1355475548),
213(45, 0, 'Babies, Toddlers & Children', '0', 1, 0, 'buy_sell', 1355475588),
214(46, 45, 'Baby Clothes ', 'baby-clothes', 1, 0, 'buy_sell', 1355475638),
215(47, 45, 'Baby Toys ', 'baby-toys', 1, 0, 'buy_sell', 1355475696),
216(48, 45, 'Baby Footwear', 'baby-footwear', 1, 0, 'buy_sell', 1355475717),
217(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),
218(50, 45, 'Children Clothes', 'children-clothes', 1, 0, 'buy_sell', 1355475787),
219(51, 45, 'Children Toys', 'children-toys', 1, 0, 'buy_sell', 1355475804),
220(52, 45, 'Children Footwear', 'children-footwear', 1, 0, 'buy_sell', 1355475825),
221(53, 45, 'Other', 'other', 1, 0, 'buy_sell', 1355475841),
222(54, 0, 'Bicycle', 'bicycle', 1, 0, 'buy_sell', 1355475907),
223(55, 0, 'Books', 'books', 1, 0, 'buy_sell', 1355475928),
224(56, 55, 'E-books and E-zines ', 'e-books-and-e-zines-', 1, 0, 'buy_sell', 1355475967),
225(57, 55, 'Books ', 'books-', 1, 0, 'buy_sell', 1355475993),
226(58, 55, 'Magazines ', 'magazines-', 1, 0, 'buy_sell', 1355476013),
227(59, 55, 'Comics', 'comics', 1, 0, 'buy_sell', 1355476029),
228(60, 0, 'CDs, DVDs and Blu-rays', 'cds-dvds-and-blu-rays', 1, 0, 'buy_sell', 1355476051),
229(61, 60, 'CDs ', 'cds', 1, 0, 'buy_sell', 1355476087),
230(62, 60, 'DVDs ', 'dvds-', 1, 0, 'buy_sell', 1355476112),
231(63, 60, 'Games & Board Games ', 'games--board-games', 1, 0, 'buy_sell', 1355476129),
232(64, 60, 'Audio and Music ', 'audio-and-music-', 1, 0, 'buy_sell', 1355476144),
233(65, 60, 'Shows and Movies', 'shows-and-movies', 1, 0, 'buy_sell', 1355476159),
234(66, 0, 'Cellphones and Gadgets', 'cellphones-and-gadgets', 1, 0, 'buy_sell', 1355476193),
235(67, 66, 'Telephones & Answering Machines ', 'telephones--answering-machines', 1, 0, 'buy_sell', 1355476217),
236(68, 66, 'Cellphone, Cellular, Mobile Phone, and Smartphone ', 'cellphone-cellular-mobile-phone-and-smartphone-', 1, 0, 'buy_sell', 1355476258),
237(69, 66, 'Accessories and Parts for Phones ', 'accessories-and-parts-for-phones-', 1, 0, 'buy_sell', 1355476279),
238(70, 66, 'PDA and Handhelds (Non-phone Devices) ', 'pda-and-handhelds-(non-phone-devices)-', 1, 0, 'buy_sell', 1355476303),
239(71, 66, 'Cordless and Wireless Landline ', 'cordless-and-wireless-landline-', 1, 0, 'buy_sell', 1355476318),
240(72, 66, 'Corded ', 'corded-', 1, 0, 'buy_sell', 1355476337),
241(73, 0, 'Bags, Clothings&Footwears', 'bags-clothingsfootwears', 1, 0, 'buy_sell', 1355476356),
242(74, 73, 'MensFootwear & Shoes ', 'mensfootwear--shoes-', 1, 0, 'buy_sell', 1355476374),
243(75, 73, 'Womens Footwear & Shoes', 'womens-footwear--shoes', 1, 0, 'buy_sell', 1355476397),
244(76, 73, 'WomensJewelry ', 'womensjewelry-', 1, 0, 'buy_sell', 1355476416),
245(77, 73, 'Mens Jewelry', 'mens-jewelry', 1, 0, 'buy_sell', 1355476435),
246(78, 73, 'Mens Clothing ', 'mens-clothing', 1, 0, 'buy_sell', 1355476454),
247(79, 73, 'Mens Accessories ', 'mens-accessories-', 1, 0, 'buy_sell', 1355476470),
248(80, 73, 'Mens Bags, Luggages& Wallets', 'mens-bags-luggages-wallets', 1, 0, 'buy_sell', 1355476485),
249(81, 73, 'MensSunglasses ', 'menssunglasses', 1, 0, 'buy_sell', 1355476501),
250(82, 73, 'MensWatches ', 'menswatches', 1, 0, 'buy_sell', 1355476519),
251(83, 73, 'Womens Clothing ', 'womens-clothing', 1, 0, 'buy_sell', 1355476533),
252(84, 73, 'Womens Bags ', 'womens-bags-', 1, 0, 'buy_sell', 1355476549),
253(85, 73, 'Womens Accessories', 'womens-accessories', 1, 0, 'buy_sell', 1355476565),
254(86, 73, 'Womens Wallets', 'womens-wallets', 1, 0, 'buy_sell', 1355476580),
255(87, 73, 'Womens Watches', 'womens-watches', 1, 0, 'buy_sell', 1355476594),
256(88, 73, 'Unisex Watches', 'unisex-watches', 1, 0, 'buy_sell', 1355476608),
257(89, 73, 'Unisex Sunglasses', 'unisex-sunglasses', 1, 0, 'buy_sell', 1355476634),
258(90, 73, 'Unisex Bags, Luggages and Wallets', 'unisex-bags-luggages-and-wallets', 1, 0, 'buy_sell', 1355476645),
259(91, 73, 'Unisex Outerwear', 'unisex-outerwear', 1, 0, 'buy_sell', 1355476661),
260(92, 73, 'Mens Casual Wear', 'mens-casual-wear', 1, 0, 'buy_sell', 1355476678),
261(93, 73, 'Womens Casual Wear', 'womens-casual-wear', 1, 0, 'buy_sell', 1355476692),
262(94, 73, 'Womens Dresses', 'womens-dresses', 1, 0, 'buy_sell', 1355476708),
263(95, 73, 'Womens Prom Dresses', 'womens-prom-dresses', 1, 0, 'buy_sell', 1355476723),
264(96, 73, 'Womens Wedding Dresses', 'womens-wedding-dresses', 1, 0, 'buy_sell', 1355476738),
265(97, 73, 'Womens Formal Dresses', 'womens-formal-dresses', 1, 0, 'buy_sell', 1355476752),
266(98, 73, 'MensFormal Wears', 'mensformal-wears', 1, 0, 'buy_sell', 1355476774),
267(99, 73, 'Womens Formal Wears', 'womens-formal-wears', 1, 0, 'buy_sell', 1355476797),
268(100, 73, 'Sportswear and Swimwear ', 'sportswear-and-swimwear-', 1, 0, 'buy_sell', 1355476811),
269(101, 73, 'Costumes', 'costumes', 1, 0, 'buy_sell', 1355476825),
270(102, 73, 'Sleepwear and Underwear ', 'sleepwear-and-underwear-', 1, 0, 'buy_sell', 1355476838),
271(103, 0, 'Collectibles ', 'collectibles-', 1, 0, 'buy_sell', 1355477038),
272(104, 103, 'Action Figures and Dolls ', 'action-figures-and-dolls-', 1, 0, 'buy_sell', 1355477067),
273(105, 103, 'Cards ', 'cards-', 1, 0, 'buy_sell', 1355477080),
274(106, 103, 'Antiques ', 'antiques-', 1, 0, 'buy_sell', 1355477096),
275(107, 103, 'Coins and Currency ', 'coins-and-currency-', 1, 0, 'buy_sell', 1355477111),
276(108, 103, 'Memorabilia ', 'memorabilia-', 1, 0, 'buy_sell', 1355477125),
277(109, 103, 'Comics ', 'comics-', 1, 0, 'buy_sell', 1355477139),
278(110, 103, 'Stamps', 'stamps', 1, 0, 'buy_sell', 1355477152),
279(111, 0, 'Commercial and Industrial Equipments', 'commercial-and-industrial-equipments', 1, 0, 'buy_sell', 1355477166),
280(112, 0, 'Computers and Peripherals', 'computers-and-peripherals', 1, 0, 'buy_sell', 1355477176),
281(113, 112, 'Computers, PCs & Laptops ', 'computers-pcs--laptops', 1, 0, 'buy_sell', 1355477195),
282(114, 112, 'Software ', 'software', 1, 0, 'buy_sell', 1355477210),
283(115, 112, 'Video Games ', 'video-games', 1, 0, 'buy_sell', 1355477230),
284(116, 112, 'Notebooks, and Netbooks ', 'notebooks-and-netbooks-', 1, 0, 'buy_sell', 1355477245),
285(117, 112, 'Accessories and Parts for Notebooks, Laptops and Netbooks ', 'accessories-and-parts-for-notebooks-laptops-and-netbooks-', 1, 0, 'buy_sell', 1355477267),
286(118, 112, 'Peripherals, Components, and Parts ', 'peripherals-components-and-parts-', 1, 0, 'buy_sell', 1355477288),
287(119, 112, 'Printers and Scanners ', 'printers-and-scanners-', 1, 0, 'buy_sell', 1355477303),
288(120, 112, 'Tablets ', 'tablets-', 1, 0, 'buy_sell', 1355477319),
289(121, 112, 'Desktops ', 'desktops-', 1, 0, 'buy_sell', 1355477332),
290(122, 112, 'Storage Devices ', 'storage-devices-', 1, 0, 'buy_sell', 1355477347),
291(123, 112, 'Networking and Servers', 'networking-and-servers', 1, 0, 'buy_sell', 1355477361),
292(124, 112, 'Software ', 'software-', 1, 0, 'buy_sell', 1355477377),
293(125, 112, 'Internet Gadgets ', 'internet-gadgets-', 1, 0, 'buy_sell', 1355477399),
294(126, 112, 'Monitors ', 'monitors-', 1, 0, 'buy_sell', 1355477412),
295(127, 112, 'Game System', 'game-system', 1, 0, 'buy_sell', 1355477485),
296(128, 0, 'Health and Beauty', 'health-and-beauty', 1, 0, 'buy_sell', 1355477545),
297(129, 0, 'Hobbies', 'hobbies', 1, 0, 'buy_sell', 1355477560),
298(130, 0, 'Home & Garden', 'home--garden', 1, 0, 'buy_sell', 1355477572),
299(131, 130, 'Garden & Patio Furniture ', 'garden--patio-furniture-', 1, 0, 'buy_sell', 1355477598),
300(132, 130, 'Flowers and Plants ', 'flowers-and-plants-', 1, 0, 'buy_sell', 1355477612),
301(133, 130, 'Garden Items and Supplies ', 'garden-items-and-supplies-', 1, 0, 'buy_sell', 1355477624),
302(134, 130, 'Home and Office Furnitures', 'home-and-office-furnitures', 1, 0, 'buy_sell', 1355477640),
303(135, 130, 'Beds & Bedroom Furniture ', 'beds--bedroom-furniture', 1, 0, 'buy_sell', 1355477654),
304(136, 130, 'Dining, Living Room Furniture ', 'dining-living-room-furniture-', 1, 0, 'buy_sell', 1355477667),
305(137, 130, 'Cooking and Ovens ', 'cooking-and-ovens-', 1, 0, 'buy_sell', 1355477681),
306(138, 130, 'Refrigerators and Freezers ', 'refrigerators-and-freezers-', 1, 0, 'buy_sell', 1355477695),
307(139, 130, 'Other Kitchen Appliances ', 'other-kitchen-appliances-', 1, 0, 'buy_sell', 1355477707),
308(140, 130, 'Water Dispensers and Purifiers ', 'water-dispensers-and-purifiers-', 1, 0, 'buy_sell', 1355477722),
309(141, 130, 'Washers and Dryers ', 'washers-and-dryers-', 1, 0, 'buy_sell', 1355477735),
310(142, 130, 'Sewing Machines ', 'sewing-machines-', 1, 0, 'buy_sell', 1355477754),
311(143, 130, 'Electric Fans ', 'electric-fans-', 1, 0, 'buy_sell', 1355477771),
312(144, 130, 'Lighting and Electricals', 'lighting-and-electricals', 1, 0, 'buy_sell', 1355477783),
313(145, 130, 'AirConditioning and Heating', 'airconditioning-and-heating', 1, 0, 'buy_sell', 1355477796),
314(146, 130, 'Office ', 'office-', 1, 0, 'buy_sell', 1355477809),
315(147, 130, 'Family and Living Room ', 'family-and-living-room-', 1, 0, 'buy_sell', 1355477821),
316(148, 130, 'Bath Room', 'bath-room', 1, 0, 'buy_sell', 1355477840),
317(149, 130, 'Kids Room ', 'kids-room-', 1, 0, 'buy_sell', 1355477848),
318(150, 130, 'Shed and Garage ', 'shed-and-garage-', 1, 0, 'buy_sell', 1355477862),
319(151, 0, 'Household', 'household', 1, 0, 'buy_sell', 1355477888),
320(152, 151, 'Kitchen Appliances & Accessories ', 'kitchen-appliances--accessories', 1, 0, 'buy_sell', 1355477898),
321(153, 151, 'Other Home Appliances ', 'other-home-appliances', 1, 0, 'buy_sell', 1355477910),
322(154, 151, 'Other Household Goods', 'other-household-goods', 1, 0, 'buy_sell', 1355477927),
323(156, 0, 'Jewelry', 'jewelry', 1, 0, 'buy_sell', 1355478034),
324(157, 0, 'Miscellaneous Goods', 'miscellaneous-goods', 1, 0, 'buy_sell', 1355478048),
325(158, 0, 'Aquariums', 'aquariums', 1, 0, 'buy_sell', 1355478062),
326(159, 0, 'Health & Beauty ', 'health--beauty', 1, 0, 'buy_sell', 1355478075),
327(160, 0, 'Hobbies, Interests & Collectibles ', 'hobbies-interests--collectibles', 1, 0, 'buy_sell', 1355478088),
328(161, 0, 'Scrapbooking, Sewing, Art, Craft ', 'scrapbooking-sewing-art-craft', 1, 0, 'buy_sell', 1355478101),
329(162, 0, 'Tools ', 'tools', 1, 0, 'buy_sell', 1355478117),
330(163, 0, 'Musical Instruments', 'musical-instruments', 1, 0, 'buy_sell', 1355478144),
331(164, 163, 'String Instruments ', 'string-instruments-', 1, 0, 'buy_sell', 1355478161),
332(165, 163, 'Accessories and Parts for Musical Instruments ', 'accessories-and-parts-for-musical-instruments-', 1, 0, 'buy_sell', 1355478178),
333(166, 163, 'Keyboard Instruments ', 'keyboard-instruments-', 1, 0, 'buy_sell', 1355478193),
334(167, 163, 'Percussion Instruments ', 'percussion-instruments-', 1, 0, 'buy_sell', 1355478206),
335(168, 163, 'Woodwind Instruments ', 'woodwind-instruments-', 1, 0, 'buy_sell', 1355478218),
336(169, 163, 'Brass Instruments ', 'brass-instruments-', 1, 0, 'buy_sell', 1355478230),
337(170, 163, 'Vinyl', 'vinyl', 1, 0, 'buy_sell', 1355478243),
338(171, 163, 'Studio & Live Music Equipment', 'studio--live-music-equipment', 1, 0, 'buy_sell', 1355478253),
339(172, 163, 'Guitars and Guitar Amps', 'guitars-and-guitar-amps', 1, 0, 'buy_sell', 1355478272),
340(173, 163, 'Keyboards and Pianos', 'keyboards-and-pianos', 1, 0, 'buy_sell', 1355478285),
341(174, 163, 'Percussion & Drums', 'percussion--drums', 1, 0, 'buy_sell', 1355478298),
342(175, 163, 'Sheet Music', 'sheet-music', 1, 0, 'buy_sell', 1355478316),
343(176, 0, 'Office Furniture & Equipment', 'office-furniture--equipment', 1, 0, 'buy_sell', 1355478347),
344(177, 176, 'Cartridges & Toners ', 'cartridges--toners', 1, 0, 'buy_sell', 1355478360),
345(178, 176, 'Chairs ', 'chairs', 1, 0, 'buy_sell', 1355478381),
346(179, 176, 'Copiers ', 'copiers', 1, 0, 'buy_sell', 1355478389),
347(180, 176, 'Desks ', 'desks', 1, 0, 'buy_sell', 1355478399),
348(181, 176, 'Faxes ', 'faxes', 1, 0, 'buy_sell', 1355478410),
349(182, 176, 'Multimedia Projectors ', 'multimedia-projectors', 1, 0, 'buy_sell', 1355478421),
350(183, 176, 'Printers ', 'printers-', 1, 0, 'buy_sell', 1355478435),
351(184, 176, 'Shredders ', 'shredders', 1, 0, 'buy_sell', 1355478450),
352(185, 176, 'Storage & Filing ', 'storage--filing', 1, 0, 'buy_sell', 1355478460),
353(186, 0, 'Sporting Goods', 'sporting-goods', 1, 0, 'buy_sell', 1355478483),
354(187, 186, 'Ball & Racquet Sport Equipment ', 'ball--racquet-sport-equipment', 1, 0, 'buy_sell', 1355478494),
355(188, 186, 'Bicycle Accessories ', 'bicycle-accessories', 1, 0, 'buy_sell', 1355478507),
356(189, 186, 'Bicycles ', 'bicycles', 1, 0, 'buy_sell', 1355478520),
357(190, 186, 'Camping & Hiking ', 'camping--hiking', 1, 0, 'buy_sell', 1355478532),
358(191, 186, 'Fishing Equipment ', 'fishing-equipment', 1, 0, 'buy_sell', 1355478543),
359(192, 186, 'Golf Equipment ', 'golf-equipment', 1, 0, 'buy_sell', 1355478553),
360(193, 186, 'Gym Equipment ', 'gym-equipment', 1, 0, 'buy_sell', 1355478563),
361(194, 186, 'Other Sports & Leisure ', 'other-sports--leisure', 1, 0, 'buy_sell', 1355478575),
362(195, 186, 'Water Sports ', 'water-sports', 1, 0, 'buy_sell', 1355478586),
363(196, 186, 'Winter Sports ', 'winter-sports', 1, 0, 'buy_sell', 1355478597),
364(197, 0, 'Sports and Hobbies', 'sports-and-hobbies', 1, 0, 'buy_sell', 1355478621),
365(198, 197, 'Camping and Biking ', 'camping-and-biking-', 1, 0, 'buy_sell', 1355478645),
366(199, 197, 'Exercise and Body Building ', 'exercise-and-body-building-', 1, 0, 'buy_sell', 1355478658),
367(200, 197, 'Airsoft (AEG) ', 'airsoft-(aeg)-', 1, 0, 'buy_sell', 1355478671),
368(201, 197, 'Sports Gear and Accessories ', 'sports-gear-and-accessories-', 1, 0, 'buy_sell', 1355478682),
369(202, 197, 'Water Sports ', 'water-sports-', 1, 0, 'buy_sell', 1355478694),
370(203, 197, 'Racket Sports ', 'racket-sports-', 1, 0, 'buy_sell', 1355478706),
371(204, 197, 'Combat Sports ', 'combat-sports-', 1, 0, 'buy_sell', 1355478716),
372(205, 197, 'Field Sports ', 'field-sports-', 1, 0, 'buy_sell', 1355478726),
373(206, 197, 'Skateboards and Rollerblades ', 'skateboards-and-rollerblades-', 1, 0, 'buy_sell', 1355478736),
374(207, 197, 'Billiards and Bowling ', 'billiards-and-bowling-', 1, 0, 'buy_sell', 1355478747),
375(208, 197, 'Binoculars and Parts ', 'binoculars-and-parts-', 1, 0, 'buy_sell', 1355478759),
376(209, 197, 'Board Games ', 'board-games-', 1, 0, 'buy_sell', 1355478770),
377(210, 0, 'Stuff Wanted', 'stuff-wanted', 1, 0, 'buy_sell', 1355478782),
378(211, 0, 'Tickets', 'tickets', 1, 0, 'buy_sell', 1355478794),
379(212, 211, 'Music & Other ', 'music--other', 1, 0, 'buy_sell', 1355478804),
380(213, 211, 'Sports ', 'sports', 1, 0, 'buy_sell', 1355478819),
381(214, 211, 'Travel ', 'travel', 1, 0, 'buy_sell', 1355478830),
382(217, 0, 'Toys, Video Games, and Related Items ', 'toys-video-games-and-related-items-', 1, 0, 'buy_sell', 1355478912),
383(218, 217, 'Toys and Playthings ', 'toys-and-playthings-', 1, 0, 'buy_sell', 1355478923),
384(219, 217, 'Other Baby Stuff ', 'other-baby-stuff-', 1, 0, 'buy_sell', 1355478935),
385(220, 217, 'Game Systems (Consoles) ', 'game-systems-(consoles)-', 1, 0, 'buy_sell', 1355478945),
386(221, 217, 'Game Cartridges and CDs ', 'game-cartridges-and-cds-', 1, 0, 'buy_sell', 1355478955),
387(222, 217, 'Handheld Systems ', 'handheld-systems-', 1, 0, 'buy_sell', 1355478965),
388(223, 217, 'Game Accounts ', 'game-accounts-', 1, 0, 'buy_sell', 1355478976),
389(224, 217, 'Control Pads ', 'control-pads-', 1, 0, 'buy_sell', 1355478985),
390(225, 217, 'Memory ', 'memory-', 1, 0, 'buy_sell', 1355478998),
391(226, 0, 'Travel and Vacation', 'travel-and-vacation', 1, 0, 'buy_sell', 1355479020),
392(227, 0, 'TV, Audio and Video', 'tv-audio-and-video', 1, 0, 'buy_sell', 1355479032),
393(228, 227, 'Decks & DJ Accessories ', 'decks--dj-accessories', 1, 0, 'buy_sell', 1355479051),
394(229, 227, 'Home Cinema ', 'home-cinema', 1, 0, 'buy_sell', 1355479062),
395(230, 227, 'Karaoke Equipment ', 'karaoke-equipment', 1, 0, 'buy_sell', 1355479074),
396(231, 227, 'Other Stereo & Audio ', 'other-stereo--audio', 1, 0, 'buy_sell', 1355479086),
397(232, 227, 'Personal Stereos ', 'personal-stereos', 1, 0, 'buy_sell', 1355479097),
398(233, 227, 'Stereos & Accessories ', 'stereos--accessories', 1, 0, 'buy_sell', 1355479107),
399(234, 227, 'Camcorders and Cameras ', 'camcorders-and-cameras-', 1, 0, 'buy_sell', 1355479121),
400(235, 227, 'Accessories and Parts for Camcorders and Cameras ', 'accessories-and-parts-for-camcorders-and-cameras-', 1, 0, 'buy_sell', 1355479132),
401(236, 227, 'CD, DVD, MP3, and MP4 Audio Players ', 'cd-dvd-mp3-and-mp4-audio-players-', 1, 0, 'buy_sell', 1355479143),
402(237, 227, 'Headphones and Earphones ', 'headphones-and-earphones-', 1, 0, 'buy_sell', 1355479153),
403(238, 227, 'TVs ', 'tvs-', 1, 0, 'buy_sell', 1355479163),
404(239, 227, 'Speakers ', 'speakers-', 1, 0, 'buy_sell', 1355479174),
405(240, 227, 'Amplifiers ', 'amplifiers-', 1, 0, 'buy_sell', 1355479186),
406(241, 227, 'Projectors ', 'projectors-', 1, 0, 'buy_sell', 1355479196),
407(242, 227, 'Antennas and Cables ', 'antennas-and-cables-', 1, 0, 'buy_sell', 1355479207),
408(243, 227, 'VCD, DVD, and Blu-ray Players ', 'vcd-dvd-and-blu-ray-players-', 1, 0, 'buy_sell', 1355479222),
409(244, 227, 'Digital Camera Accessories ', 'digital-camera-accessories', 1, 0, 'buy_sell', 1355479236),
410(245, 227, 'Digital Cameras ', 'digital-cameras', 1, 0, 'buy_sell', 1355479246),
411(246, 227, 'Non Digital Cameras ', 'non-digital-cameras', 1, 0, 'buy_sell', 1355479257),
412(247, 227, 'Satellite& Cable Equipment ', 'satellite-cable-equipment', 1, 0, 'buy_sell', 1355479271),
413(248, 227, 'Televisions, Plasma & LCD TVs ', 'televisions-plasma--lcd-tvs', 1, 0, 'buy_sell', 1355479282),
414(249, 227, 'TV, DVD & VCR Accessories ', 'tv-dvd--vcr-accessories-', 1, 0, 'buy_sell', 1355479295),
415(250, 227, ' Other', '-other', 1, 0, 'buy_sell', 1355479359),
416(252, 34, 'Accounts Assistant & Bookkeeping ', 'accounts-assistant--bookkeeping', 1, 0, 'job', 1355537367),
417(253, 34, 'Banking, Insurance & Investment ', 'banking-insurance--investment', 1, 0, 'job', 1355537391),
418(254, 34, 'Commerce, Finance & Industry ', 'commerce-finance--industry', 1, 0, 'job', 1355537409),
419(255, 34, 'Public & Non Profit ', 'public--non-profit', 1, 0, 'job', 1355537421),
420(256, 34, 'Public Practice Accounting ', 'public-practice-accounting', 1, 0, 'job', 1355537433),
421(257, 0, 'Administrative', 'administrative', 1, 0, 'job', 1355537455),
422(258, 0, 'Architecture ', 'architecture-', 1, 0, 'job', 1355537464),
423(259, 0, 'Automotive', 'automotive', 1, 0, 'job', 1355537475),
424(260, 0, 'Bar Staff & Management', 'bar-staff--management', 1, 0, 'job', 1355537484),
425(261, 0, 'Business and Management', 'business-and-management', 1, 0, 'job', 1355537495),
426(262, 0, 'Call Center', 'call-center', 1, 0, 'job', 1355537505),
427(263, 0, 'Chef, Cooks and Kitchen', 'chef-cooks-and-kitchen', 1, 0, 'job', 1355537515),
428(264, 263, 'Chef de Partie', 'chef-de-partie', 1, 0, 'job', 1355537527),
429(265, 263, 'Commis Chef ', 'commis-chef', 1, 0, 'job', 1355537537),
430(266, 263, 'Cooks ', 'cooks', 1, 0, 'job', 1355537549),
431(267, 263, 'Demi Chef de Partie', 'demi-chef-de-partie', 1, 0, 'job', 1355537560),
432(268, 263, 'Head Chef ', 'head-chef', 1, 0, 'job', 1355537572),
433(269, 263, 'Kitchen ', 'kitchen', 1, 0, 'job', 1355537584),
434(270, 263, 'Pastry Chef ', 'pastry-chef', 1, 0, 'job', 1355537596),
435(271, 263, 'Sous Chef ', 'sous-chef', 1, 0, 'job', 1355537608),
436(272, 0, 'Computing & IT', 'computing--it', 1, 0, 'job', 1355537632),
437(273, 272, 'ProjMgmt, Bus Analysis, Consulting ', 'projmgmt-bus-analysis-consulting', 1, 0, 'job', 1355537762),
438(274, 272, 'Software Dev, Programming & Testing Support, Database & Systems Admin ', 'software-dev-programming--testing-support-database--systems-admin', 1, 0, 'job', 1355537776),
439(275, 272, 'Web Design & Web Developers ', 'web-design--web-developers', 1, 0, 'job', 1355537789),
440(276, 272, 'Other ', 'other-', 1, 0, 'job', 1355537802),
441(277, 0, 'Construction', 'construction', 1, 0, 'job', 1355537817),
442(278, 277, 'Architecture ', 'architecture', 1, 0, 'job', 1355537829),
443(279, 277, 'Building Services & Maintenance ', 'building-services--maintenance', 1, 0, 'job', 1355537841),
444(280, 277, 'Tradesmen / Labour', 'tradesmen---labour', 1, 0, 'job', 1355537855),
445(281, 0, 'Customer Service', 'customer-service', 1, 0, 'job', 1355538632),
446(282, 0, 'Data Entry ', 'data-entry-', 1, 0, 'job', 1355539089),
447(283, 0, 'Driving & Warehouse', 'driving--warehouse', 1, 0, 'job', 1355539101),
448(285, 0, 'Editing', 'editing', 1, 0, 'job', 1355541464),
449(286, 0, 'Education', 'education', 1, 0, 'job', 1355541476),
450(287, 286, 'Nursery ', 'nursery', 1, 0, 'job', 1355541511),
451(288, 286, 'Primary | Key Stage 1 ', 'primary-|-key-stage-1', 1, 0, 'job', 1355541532),
452(289, 286, 'Primary | Key Stage 2 ', 'primary-|-key-stage-2', 1, 0, 'job', 1355541569),
453(290, 286, 'Primary | Other ', 'primary-|-other-', 1, 0, 'job', 1355541590),
454(291, 286, 'Special Educational Needs ', 'special-educational-needs', 1, 0, 'job', 1355541607),
455(292, 286, 'Subject | Languages ', 'subject-|-languages-', 1, 0, 'job', 1355541629),
456(293, 286, 'Subject | Science ', 'subject-|-science', 1, 0, 'job', 1355541643),
457(294, 286, 'Supply | Secondary ', 'supply-|-secondary', 1, 0, 'job', 1355541660),
458(295, 286, 'Teaching Assistant ', 'teaching-assistant-', 1, 0, 'job', 1355541693),
459(296, 0, 'Engineering', 'engineering', 1, 0, 'job', 1355541713),
460(297, 0, 'Farm, Vet, Garden and Landscaping', 'farm-vet-garden-and-landscaping', 1, 0, 'job', 1355541729),
461(298, 297, 'Farming & Veterinary ', 'farming--veterinary', 1, 0, 'job', 1355541743),
462(299, 297, 'Gardening & Landscaping ', 'gardening--landscaping', 1, 0, 'job', 1355541755),
463(300, 0, 'Food and Beverage', 'food-and-beverage', 1, 0, 'job', 1355541790),
464(302, 0, 'General Labor', 'general-labor', 1, 0, 'job', 1355541815),
465(303, 0, 'General Jobs', 'general-jobs', 1, 0, 'job', 1355541915),
466(304, 0, 'Government', 'government', 1, 0, 'job', 1355541927),
467(305, 0, 'Healthcare', 'healthcare', 1, 0, 'job', 1355541950),
468(306, 305, 'Biotechnology & Pharmaceutical ', 'biotechnology--pharmaceutical', 1, 0, 'job', 1355541964),
469(307, 305, 'Doctors ', 'doctors-', 1, 0, 'job', 1355541977),
470(308, 305, 'Medical Secretarial & Medical Admin ', 'medical-secretarial--medical-admin', 1, 0, 'job', 1355541990),
471(309, 305, 'Nurses ', 'nurses', 1, 0, 'job', 1355542002),
472(310, 0, 'Hotel', 'hotel', 1, 0, 'job', 1355542035),
473(311, 0, 'Internet Work', 'internet-work', 1, 0, 'job', 1355542044),
474(312, 0, 'Legal', 'legal', 1, 0, 'job', 1355542098),
475(313, 0, 'Manufacturing', 'manufacturing', 1, 0, 'job', 1355542109),
476(314, 0, 'Marketing, Advertising & PR', 'marketing-advertising--pr', 1, 0, 'job', 1355542118),
477(315, 314, 'Account Management ', 'account-management', 1, 0, 'job', 1355542132),
478(316, 314, 'Brand Management ', 'brand-management', 1, 0, 'job', 1355542143),
479(317, 314, 'Direct marketing ', 'direct-marketing', 1, 0, 'job', 1355542153),
480(318, 314, 'Event Management Internet Marketing & SEO ', 'event-management-internet-marketing--seo', 1, 0, 'job', 1355542175),
481(319, 314, 'Marketing Assistant/Exec Marketing Manager ', 'marketing-assistant-exec-marketing-manager', 1, 0, 'job', 1355542218),
482(320, 314, 'PR ', 'pr', 1, 0, 'job', 1355542233),
483(321, 0, 'Media, Design and Creative', 'media-design-and-creative', 1, 0, 'job', 1355542256),
484(322, 321, 'Editorial, Writing & Journalism ', 'editorial-writing--journalism', 1, 0, 'job', 1355542272),
485(323, 321, 'Film, TV, Radio, & Photography ', 'film-tv-radio--photography', 1, 0, 'job', 1355542285),
486(324, 321, 'Graphic Design & DTP ', 'graphic-design--dtp', 1, 0, 'job', 1355542298),
487(325, 321, 'Interior, Fashion & Creative Design ', 'interior-fashion--creative-design', 1, 0, 'job', 1355542312),
488(326, 0, 'Medical& Legal Transcription', 'medical-legal-transcription', 1, 0, 'job', 1355542331),
489(327, 0, 'Medical Professionals', 'medical-professionals', 1, 0, 'job', 1355542340),
490(329, 0, 'Paralegal& Legal', 'paralegal-legal', 1, 0, 'job', 1355542662),
491(330, 329, 'Conveyancing& Paralegal ', 'conveyancing-paralegal', 1, 0, 'job', 1355542676),
492(331, 329, 'Legal Secretarial & Legal Admin ', 'legal-secretarial--legal-admin', 1, 0, 'job', 1355542698),
493(332, 0, 'Programmers ', 'programmers-', 1, 0, 'job', 1355542719),
494(333, 0, 'Real Estate', 'real-estate', 1, 0, 'job', 1355542726),
495(334, 0, 'Receptiontionist', 'receptiontionist', 1, 0, 'job', 1355542733),
496(335, 0, 'Recruitment Agents', 'recruitment-agents', 1, 0, 'job', 1355542741),
497(336, 335, 'Executive Search ', 'executive-search', 1, 0, 'job', 1355542756),
498(337, 335, 'Recruitment Consultants ', 'recruitment-consultants', 1, 0, 'job', 1355542771),
499(338, 335, 'Trainee Resourcer', 'trainee-resourcer', 1, 0, 'job', 1355542785),
500(339, 0, 'Sales', 'sales', 1, 0, 'job', 1355542803),
501(340, 0, 'Sales, Retail & Customer Service', 'sales-retail--customer-service', 1, 0, 'job', 1355542812),
502(341, 340, 'Retail ', 'retail', 1, 0, 'job', 1355542824),
503(342, 340, 'Sales & Customer Service ', 'sales--customer-service', 1, 0, 'job', 1355542836),
504(343, 0, 'Secretarial and Clerical Work', 'secretarial-and-clerical-work', 1, 0, 'job', 1355542846),
505(344, 0, 'Security', 'security', 1, 0, 'job', 1355542854),
506(345, 0, 'Technical Support', 'technical-support', 1, 0, 'job', 1355542877),
507(346, 0, 'Transportation', 'transportation', 1, 0, 'job', 1355542893),
508(347, 0, 'Travel and Overseas', 'travel-and-overseas', 1, 0, 'job', 1355542903),
509(348, 347, 'Travel Agent & Travel Consultant ', 'travel-agent--travel-consultant', 1, 0, 'job', 1355542921),
510(349, 347, 'Travel, Overseas & Work Abroad ', 'travel-overseas--work-abroad', 1, 0, 'job', 1355542937),
511(350, 0, 'Virtual Assistants', 'virtual-assistants', 1, 0, 'job', 1355542964),
512(351, 0, 'Waiting & Restaurant Management', 'waiting--restaurant-management', 1, 0, 'job', 1355542983),
513(352, 351, 'Food & Beverage ', 'food--beverage', 1, 0, 'job', 1355542998),
514(353, 351, 'Head Waiter ', 'head-waiter', 1, 0, 'job', 1355543009),
515(354, 351, 'Restaurant Management ', 'restaurant-management', 1, 0, 'job', 1355543027),
516(355, 351, 'Waiting Staff ', 'waiting-staff', 1, 0, 'job', 1355543035),
517(356, 0, 'Web Design', 'web-design', 1, 0, 'job', 1355543712),
518(357, 0, 'Wholesale', 'wholesale', 1, 0, 'job', 1355543721),
519(358, 0, 'Work Wanted', 'work-wanted', 1, 0, 'job', 1355543729),
520(359, 0, 'Writing and Editing', 'writing-and-editing', 1, 0, 'job', 1355543747),
521(360, 0, 'Accounting', 'accounting', 1, 0, 'job', 1355543952),
522(361, 0, 'Advertising', 'advertising', 1, 0, 'job', 1355543967),
523(362, 0, 'Agriculture ', 'agriculture-', 1, 0, 'job', 1355543976),
524(368, 0, 'House and Lot ', 'house-and-lot-', 1, 0, 'property', 1355544557),
525(371, 0, 'Commercial Property', 'commercial-property', 1, 0, 'property', 1355544975),
526(373, 0, 'Residential Lot ', 'residential-lot-', 1, 0, 'property', 1355544987),
527(374, 0, 'Rooms For Rent', 'rooms-for-rent', 1, 0, 'property', 1355545118),
528(375, 0, 'Condominium Unit ', 'condominium-unit', 1, 0, 'property', 1355545126),
529(376, 0, 'Townhouse', 'townhouse', 1, 0, 'property', 1355545136),
530(377, 0, 'Subdivision', 'subdivision', 1, 0, 'property', 1355545150),
531(378, 0, 'Commercial Land ', 'commercial-land-', 1, 0, 'property', 1355545160),
532(379, 0, 'Agricultural Lot ', 'agricultural-lot-', 1, 0, 'property', 1355545201),
533(380, 0, 'Beach House', 'beach-house', 1, 0, 'property', 1355545210),
534(381, 0, 'Vacation House', 'vacation-house', 1, 0, 'property', 1355545219),
535(382, 0, 'Nurses', 'nurses', 1, 0, 'job', 1355545408),
536(383, 382, 'General ', 'general', 1, 0, 'job', 1355545520),
537(384, 382, 'Specialist ', 'specialist', 1, 0, 'job', 1355545533),
538(385, 382, 'Other ', 'other', 1, 0, 'job', 1355545548),
539(386, 351, 'Other ', 'other', 1, 0, 'job', 1355545596),
540(387, 263, 'Other', 'other', 1, 0, 'job', 1355545670),
541(388, 277, 'Other', 'other', 1, 0, 'job', 1355545747),
542(389, 283, 'Other', 'other', 1, 0, 'job', 1355545889),
543(390, 283, 'Architecture ', 'architecture', 1, 0, 'job', 1355545998),
544(391, 283, 'Building Services & Maintenance ', 'building-services--maintenance', 1, 0, 'job', 1355546017),
545(392, 283, 'Tradesmen / Labour', 'tradesmen---labour', 1, 0, 'job', 1355546039),
546(393, 286, 'Other ', 'other', 1, 0, 'job', 1355546138),
547(394, 297, 'Other ', 'other', 1, 0, 'job', 1355546194),
548(395, 305, 'Other', 'other', 1, 0, 'job', 1355546296),
549(396, 314, 'Other', 'other', 1, 0, 'job', 1355546341),
550(397, 321, 'Other', 'other', 1, 0, 'job', 1355546552),
551(398, 329, 'Other ', 'other', 1, 0, 'job', 1355546600),
552(399, 335, 'Other ', 'other', 1, 0, 'job', 1355546675),
553(400, 347, 'Other', 'other', 1, 0, 'job', 1355551350),
554(401, 0, 'Advertising', 'advertising', 1, 0, 'service', 1355551475),
555(402, 0, 'Agriculture ', 'agriculture-', 1, 0, 'service', 1355551500),
556(403, 0, 'Architecture', 'architecture', 1, 0, 'service', 1355551531),
557(404, 0, 'Automotive', 'automotive', 1, 0, 'service', 1355551544),
558(405, 0, 'Beauty', 'beauty', 1, 0, 'service', 1355551555),
559(406, 405, 'Beauty Parlor', 'beauty-parlor', 1, 0, 'service', 1355551580),
560(407, 405, 'Beauty Salon', 'beauty-salon', 1, 0, 'service', 1355551596),
561(408, 405, 'Barber Shop', 'barber-shop', 1, 0, 'service', 1355551614),
562(409, 405, 'Other', 'other', 1, 0, 'service', 1355551631),
563(410, 0, 'Computer Support', 'computer-support', 1, 0, 'service', 1355551649),
564(411, 410, 'Repair & Maintenance', 'repair--maintenance', 1, 0, 'service', 1355551684),
565(412, 410, 'Parts and Accessories', 'parts-and-accessories', 1, 0, 'service', 1355551702),
566(413, 410, 'Wireless Networking', 'wireless-networking', 1, 0, 'service', 1355551724),
567(414, 410, 'Internet Connection', 'internet-connection', 1, 0, 'service', 1355551739),
568(415, 410, 'Printer Repair', 'printer-repair', 1, 0, 'service', 1355551757),
569(416, 410, 'Other Computer Support', 'other-computer-support', 1, 0, 'service', 1355551776),
570(417, 0, 'Education', 'education', 1, 0, 'service', 1355551786),
571(418, 0, 'Engineering', 'engineering', 1, 0, 'service', 1355551805),
572(419, 0, 'Events Planner', 'events-planner', 1, 0, 'service', 1355551816),
573(420, 419, 'Birthday Party', 'birthday-party', 1, 0, 'service', 1355551831),
574(421, 419, 'Company Party', 'company-party', 1, 0, 'service', 1355551849),
575(422, 419, 'Holiday Party', 'holiday-party', 1, 0, 'service', 1355551871),
576(423, 419, 'Special Events Party', 'special-events-party', 1, 0, 'service', 1355551891),
577(424, 419, 'Seminar and Workshop', 'seminar-and-workshop', 1, 0, 'service', 1355551907),
578(425, 419, 'Wedding', 'wedding', 1, 0, 'service', 1355551925),
579(426, 419, 'Concert ', 'concert-', 1, 0, 'service', 1355551943),
580(427, 419, 'Other', 'other', 1, 0, 'service', 1355551957),
581(428, 0, 'Food and Catering Services', 'food-and-catering-services', 1, 0, 'service', 1355551968),
582(429, 0, 'Information Technology', 'information-technology', 1, 0, 'service', 1355551989),
583(430, 429, 'Website Design', 'website-design', 1, 0, 'service', 1355552001),
584(431, 429, '• Programming and Software Development ', '• programming-and-software-development-', 1, 0, 'service', 1355552017),
585(432, 429, 'Hosting ', 'hosting-', 1, 0, 'service', 1355552034),
586(433, 429, 'Data Processing', 'data-processing', 1, 0, 'service', 1355552077),
587(435, 0, 'Internet Business', 'internet-business', 1, 0, 'service', 1355552126),
588(436, 0, 'Business to Business', 'business-to-business', 1, 0, 'service', 1355552161),
589(437, 0, 'Internet Marketing', 'internet-marketing', 1, 0, 'service', 1355552174),
590(438, 0, 'Legal Services', 'legal-services', 1, 0, 'service', 1355552183),
591(439, 0, 'Refrigeration and Maintenance', 'refrigeration-and-maintenance', 1, 0, 'service', 1355552193),
592(440, 0, 'Plumbing & Sewerage', 'plumbing--sewerage', 1, 0, 'service', 1355552205),
593(441, 0, 'Non-Profit', 'non-profit', 1, 0, 'service', 1355552213),
594(442, 0, 'Others', 'others', 1, 0, 'service', 1355552220),
595(443, 0, 'Pet Training', 'pet-training', 1, 0, 'service', 1355552233),
596(444, 0, 'Photography & Video Editing', 'photography--video-editing', 1, 0, 'service', 1355552245),
597(445, 0, 'Professional Consulting', 'professional-consulting', 1, 0, 'service', 1355552255),
598(446, 0, 'Publishing', 'publishing', 1, 0, 'service', 1355552264),
599(447, 0, 'Rental Services', 'rental-services', 1, 0, 'service', 1355552275),
600(448, 447, 'Car Rental', 'car-rental', 1, 0, 'service', 1355552290),
601(449, 447, 'Truck Rental', 'truck-rental', 1, 0, 'service', 1355552319),
602(450, 447, 'Limo Rental', 'limo-rental', 1, 0, 'service', 1355552337),
603(451, 447, 'Moving Services (Lipat Bahay)', 'moving-services-(lipat-bahay)', 1, 0, 'service', 1355552353),
604(452, 447, 'Events Space Rental Services', 'events-space-rental-services', 1, 0, 'service', 1355552364),
605(453, 447, 'Events Space Rental Services', 'events-space-rental-services', 1, 0, 'service', 1355552382),
606(454, 447, 'Chairs, Tables and Other Party Rental Services', 'chairs-tables-and-other-party-rental-services', 1, 0, 'service', 1355552395),
607(455, 447, 'General Equipments Rental Services', 'general-equipments-rental-services', 1, 0, 'service', 1355552416),
608(456, 447, 'Other Rental Services', 'other-rental-services', 1, 0, 'service', 1355552427),
609(457, 0, 'Retail', 'retail', 1, 0, 'service', 1355552436),
610(458, 0, 'Security Services', 'security-services', 1, 0, 'service', 1355552447),
611(459, 0, 'Small Business Training', 'small-business-training', 1, 0, 'service', 1355552455),
612(460, 0, 'Telecommunications', 'telecommunications', 1, 0, 'service', 1355552467),
613(461, 460, 'Broadband Internet Service Provider', 'broadband-internet-service-provider', 1, 0, 'service', 1355552482),
614(462, 460, 'Phone Service Service Provider', 'phone-service-service-provider', 1, 0, 'service', 1355552492),
615(463, 460, 'Home and Cable Service Provider', 'home-and-cable-service-provider', 1, 0, 'service', 1355552504),
616(464, 460, 'VoIP Service Provider', 'voip-service-provider', 1, 0, 'service', 1355552515),
617(465, 0, 'Travel and Vacation', 'travel-and-vacation', 1, 0, 'service', 1355552536),
618(466, 465, 'Tour Packages ', 'tour-packages-', 1, 0, 'service', 1355552938),
619(467, 465, 'Hotels and Accommodations ', 'hotels-and-accommodations', 1, 0, 'service', 1355552953),
620(468, 0, 'Subject Tutorial', 'subject-tutorial', 1, 0, 'service', 1355552971),
621(469, 468, 'Math', 'math', 1, 0, 'service', 1355552987),
622(470, 468, 'Science', 'science', 1, 0, 'service', 1355553006),
623(471, 468, 'History', 'history', 1, 0, 'service', 1355553024),
624(472, 468, 'English', 'english', 1, 0, 'service', 1355553055),
625(473, 468, 'Language Arts', 'language-arts', 1, 0, 'service', 1355553066),
626(474, 468, 'Writing', 'writing', 1, 0, 'service', 1355553096),
627(475, 468, 'Foreign Language', 'foreign-language', 1, 0, 'service', 1355553116),
628(476, 468, 'Other', 'other', 1, 0, 'service', 1355553131),
629(477, 0, 'Non-Academic Tutorial', 'non-academic-tutorial', 1, 0, 'service', 1355553144),
630(478, 477, 'Piano Lesson', 'piano-lesson', 1, 0, 'service', 1355553171),
631(479, 477, 'Voice Lesson', 'voice-lesson', 1, 0, 'service', 1355553182),
632(480, 477, 'Other Musical Instruments', 'other-musical-instruments', 1, 0, 'service', 1355553197),
633(481, 477, 'Other Musical Instruments', 'other-musical-instruments', 1, 0, 'service', 1355553212),
634(482, 0, 'Web Design', 'web-design', 1, 0, 'service', 1355553230),
635(483, 0, 'Writing and Editorial', 'writing-and-editorial', 1, 0, 'service', 1355553240),
636(484, 0, 'Other Services-Uncategorized', 'other-services-uncategorized', 1, 0, 'service', 1355553249),
637(485, 0, 'Work-At-Home Business', 'work-at-home-business', 1, 0, 'bussiness', 1355553504),
638(486, 0, 'Multi-Level Marketing (MLM)', 'multi-level-marketing-(mlm)', 1, 0, 'bussiness', 1355553514),
639(487, 0, 'Direct Selling', 'direct-selling', 1, 0, 'bussiness', 1355553897),
640(488, 0, 'Distributorship', 'distributorship', 1, 0, 'bussiness', 1355553916),
641(489, 0, 'Drop and Shipping Business', 'drop-and-shipping-business', 1, 0, 'bussiness', 1355554073),
642(490, 0, 'Franchising', 'franchising', 1, 0, 'bussiness', 1355554083),
643(491, 0, 'ECommerce Business', 'ecommerce-business', 1, 0, 'bussiness', 1355554113),
644(492, 0, 'Other', 'other', 1, 0, 'bussiness', 1355554122),
645(493, 36, 'Auction', 'auction', 1, 0, 'community', 1355554599),
646(494, 36, 'Classes and Training', 'classes-and-training', 1, 0, 'community', 1355554615),
647(496, 36, 'Charity', 'charity', 1, 0, 'community', 1355555165),
648(497, 36, 'Concerts', 'concerts', 1, 0, 'community', 1355555269),
649(498, 36, 'Bazaar and Grand Sale Events', 'bazaar-and-grand-sale-events', 1, 0, 'community', 1355555292),
650(499, 36, 'Workshops, and Seminars ', 'workshops-and-seminars-', 1, 0, 'community', 1355555307),
651(500, 36, 'Family and Recreational ', 'family-and-recreational-', 1, 0, 'community', 1355555321),
652(501, 36, 'Exhibits ', 'exhibits-', 1, 0, 'community', 1355555334),
653(502, 36, 'Stage Performances and Theaters ', 'stage-performances-and-theaters-', 1, 0, 'community', 1355555355),
654(503, 36, 'Resumes', 'resumes', 1, 0, 'community', 1355555370),
655(504, 36, 'Small Gigs', 'small-gigs', 1, 0, 'community', 1355555385),
656(505, 36, 'Musical Events', 'musical-events', 1, 0, 'community', 1355555446),
657(506, 36, 'Holiday Events', 'holiday-events', 1, 0, 'community', 1355555462),
658(507, 36, 'Forum', 'forum', 1, 0, 'community', 1355555476),
659(508, 36, 'Special Events', 'special-events', 1, 0, 'community', 1355555489),
660(509, 36, 'Nightlife and Live Bands ', 'nightlife-and-live-bands-', 1, 0, 'community', 1355555504),
661(510, 36, 'Other', 'other', 1, 0, 'community', 1355555533);
662
663-- --------------------------------------------------------
664
665--
666-- Table structure for table `mk_cities`
667--
668
669CREATE TABLE IF NOT EXISTS `mk_cities` (
670 `id` int(11) NOT NULL AUTO_INCREMENT,
671 `country_id` mediumint(5) NOT NULL,
672 `region_id` mediumint(6) NOT NULL,
673 `title` char(40) NOT NULL,
674 `latitude` float NOT NULL,
675 `longitude` float NOT NULL,
676 `time_zone` varchar(40) NOT NULL,
677 `dma_id` mediumint(9) NOT NULL,
678 `code` varchar(5) NOT NULL,
679 PRIMARY KEY (`id`)
680) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=43104 ;
681
682--
683-- Dumping data for table `mk_cities`
684--
685
686INSERT INTO `mk_cities` (`id`, `country_id`, `region_id`, `title`, `latitude`, `longitude`, `time_zone`, `dma_id`, `code`) VALUES
687(42965, 0, 3534, 'Ipil', 0, 0, '', 0, ''),
688(42966, 0, 3535, 'Dapitan City', 0, 0, '', 0, ''),
689(42967, 0, 3535, 'Dipolog City', 0, 0, '', 0, ''),
690(42968, 0, 3536, 'Tandag City', 0, 0, '', 0, ''),
691(42969, 0, 3536, 'Bislig City', 0, 0, '', 0, ''),
692(42970, 0, 3537, 'Surigao City', 0, 0, '', 0, ''),
693(42971, 0, 3538, 'Jolo', 0, 0, '', 0, ''),
694(42972, 0, 3539, 'Isulan', 0, 0, '', 0, ''),
695(42973, 0, 3540, 'Maasin City', 0, 0, '', 0, ''),
696(42975, 0, 3541, 'Siquijor City', 0, 0, '', 0, ''),
697(42976, 0, 3542, 'Alabel', 0, 0, '', 0, ''),
698(42977, 0, 3543, 'Calbayog', 0, 0, '', 0, ''),
699(42978, 0, 3543, 'Catbalogan', 0, 0, '', 0, ''),
700(42979, 0, 3544, 'Romblon', 0, 0, '', 0, ''),
701(42980, 0, 3545, 'Cabarroguis', 0, 0, '', 0, ''),
702(42986, 0, 3546, 'Calapan City', 0, 0, '', 0, ''),
703(42987, 0, 3547, 'Mamburao', 0, 0, '', 0, ''),
704(42988, 0, 3546, 'Calapan City', 0, 0, '', 0, ''),
705(42989, 0, 3548, 'Bayombong', 0, 0, '', 0, ''),
706(42990, 0, 3549, 'Cabanatuan City', 0, 0, '', 0, ''),
707(42991, 0, 3549, 'Gapan City', 0, 0, '', 0, ''),
708(42992, 0, 3549, 'Palayan City', 0, 0, '', 0, ''),
709(42993, 0, 3549, 'San Jose City', 0, 0, '', 0, ''),
710(42994, 0, 3549, 'Science City of Muñoz', 0, 0, '', 0, ''),
711(43010, 0, 3550, 'Bontoc', 0, 0, '', 0, ''),
712(43017, 0, 3551, 'Manila', 0, 0, '', 0, ''),
713(43018, 0, 3551, 'Mandaluyong', 0, 0, '', 0, ''),
714(43019, 0, 3551, 'Marikina', 0, 0, '', 0, ''),
715(43020, 0, 3551, 'Pasig', 0, 0, '', 0, ''),
716(43021, 0, 3551, 'Quezon City', 0, 0, '', 0, ''),
717(43022, 0, 3551, 'San Juan', 0, 0, '', 0, ''),
718(43023, 0, 3551, 'Las Piñas', 0, 0, '', 0, ''),
719(43024, 0, 3551, 'Makati', 0, 0, '', 0, ''),
720(43025, 0, 3551, 'Muntinlupa', 0, 0, '', 0, ''),
721(43026, 0, 3551, 'Parañaque', 0, 0, '', 0, ''),
722(43027, 0, 3551, 'Pasay', 0, 0, '', 0, ''),
723(43028, 0, 3551, 'Pateros', 0, 0, '', 0, ''),
724(43029, 0, 3551, 'Taguig', 0, 0, '', 0, ''),
725(43030, 0, 3551, 'Caloocan', 0, 0, '', 0, ''),
726(43031, 0, 3551, 'Malabon', 0, 0, '', 0, ''),
727(43032, 0, 3551, 'Navotas', 0, 0, '', 0, ''),
728(43033, 0, 3551, 'Valenzuela', 0, 0, '', 0, ''),
729(43034, 0, 3552, ' Masbate City', 0, 0, '', 0, ''),
730(43035, 0, 3553, 'Boac', 0, 0, '', 0, ''),
731(43036, 0, 3554, 'Buluan', 0, 0, '', 0, ''),
732(43038, 0, 3555, 'Marawi City', 0, 0, '', 0, ''),
733(43039, 0, 3556, 'Iligan City', 0, 0, '', 0, ''),
734(43040, 0, 3556, 'Iligan City', 0, 0, '', 0, ''),
735(43043, 0, 3557, 'Tabuk City', 0, 0, '', 0, ''),
736(43045, 0, 3558, 'Cauayan City', 0, 0, '', 0, ''),
737(43046, 0, 3558, 'Ilagan City2', 0, 0, '', 0, ''),
738(43047, 0, 3558, 'Santiago City3', 0, 0, '', 0, ''),
739(43048, 0, 3559, 'Laoag City', 0, 0, '', 0, ''),
740(43049, 0, 3559, 'Batac City', 0, 0, '', 0, ''),
741(43050, 0, 3560, 'Lagawe', 0, 0, '', 0, ''),
742(43051, 0, 3561, 'Jordan', 0, 0, '', 0, ''),
743(43052, 0, 3562, 'Borongan City', 0, 0, '', 0, ''),
744(43053, 0, 3563, 'San Jose', 0, 0, '', 0, ''),
745(43055, 0, 3564, 'Davao City', 0, 0, '', 0, ''),
746(43056, 0, 3564, 'Digos City', 0, 0, '', 0, ''),
747(43060, 0, 3565, 'Cotabato City', 0, 0, '', 0, ''),
748(43061, 0, 3565, 'Kidapawan City', 0, 0, '', 0, ''),
749(43062, 0, 3566, 'Nabunturan', 0, 0, '', 0, ''),
750(43063, 0, 3567, 'Danao City', 0, 0, '', 0, ''),
751(43064, 0, 3567, 'Talisay City', 0, 0, '', 0, ''),
752(43065, 0, 3567, 'Toledo City', 0, 0, '', 0, ''),
753(43066, 0, 3567, 'Bogo City', 0, 0, '', 0, ''),
754(43067, 0, 3567, 'Carcar City', 0, 0, '', 0, ''),
755(43068, 0, 3567, 'Naga City', 0, 0, '', 0, ''),
756(43073, 0, 3568, 'Virac', 0, 0, '', 0, ''),
757(43074, 0, 3569, 'Mambajao', 0, 0, '', 0, ''),
758(43076, 0, 3570, 'Daet', 0, 0, '', 0, ''),
759(43077, 0, 3571, 'Malolos City', 0, 0, '', 0, ''),
760(43078, 0, 3571, 'Meycauayan City', 0, 0, '', 0, ''),
761(43079, 0, 3571, ' San Jose del Monte City', 0, 0, '', 0, ''),
762(43080, 0, 3572, 'Malaybalay City', 0, 0, '', 0, ''),
763(43081, 0, 3572, 'Valencia City', 0, 0, '', 0, ''),
764(43082, 0, 3573, 'Tagbilaran City', 0, 0, '', 0, ''),
765(43083, 0, 3574, 'Naval', 0, 0, '', 0, ''),
766(43084, 0, 3575, 'Baguio City', 0, 0, '', 0, ''),
767(43085, 0, 3575, 'La Trinidad', 0, 0, '', 0, ''),
768(43086, 0, 3576, 'Batangas City', 0, 0, '', 0, ''),
769(43087, 0, 3576, 'Lipa City', 0, 0, '', 0, ''),
770(43088, 0, 3576, 'Tanauan City', 0, 0, '', 0, ''),
771(43089, 0, 3577, ' Basco', 0, 0, '', 0, ''),
772(43090, 0, 3578, 'Balanga', 0, 0, '', 0, ''),
773(43091, 0, 3579, 'Isabela City', 0, 0, '', 0, ''),
774(43092, 0, 3579, 'Lamitan City', 0, 0, '', 0, ''),
775(43093, 0, 3580, 'Baler', 0, 0, '', 0, ''),
776(43094, 0, 3581, 'Kabugao', 0, 0, '', 0, ''),
777(43095, 0, 3583, 'Legazpi City', 0, 0, '', 0, ''),
778(43096, 0, 3583, 'Ligao City', 0, 0, '', 0, ''),
779(43097, 0, 3583, 'Tabaco City', 0, 0, '', 0, ''),
780(43098, 0, 3584, 'Kalibo', 0, 0, '', 0, ''),
781(43099, 0, 3585, 'Bayugan City', 0, 0, '', 0, ''),
782(43100, 0, 3586, 'Butuan', 0, 0, '', 0, ''),
783(43102, 0, 3586, 'Cabadbaran City', 0, 0, '', 0, ''),
784(43103, 0, 3587, 'Bangued', 0, 0, '', 0, '');
785
786-- --------------------------------------------------------
787
788--
789-- Table structure for table `mk_communities`
790--
791
792CREATE TABLE IF NOT EXISTS `mk_communities` (
793 `id` int(11) NOT NULL AUTO_INCREMENT,
794 `adv_id` int(11) NOT NULL,
795 `address` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
796 `contact` tinytext COLLATE utf8_unicode_ci NOT NULL,
797 PRIMARY KEY (`id`)
798) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
799
800-- --------------------------------------------------------
801
802--
803-- Table structure for table `mk_contacts`
804--
805
806CREATE TABLE IF NOT EXISTS `mk_contacts` (
807 `id` int(11) NOT NULL AUTO_INCREMENT,
808 `firstname` varchar(50) NOT NULL,
809 `lastname` varchar(50) NOT NULL,
810 `title` varchar(250) NOT NULL,
811 `subject` varchar(250) NOT NULL,
812 `email` varchar(250) NOT NULL,
813 `content` text NOT NULL,
814 `company` varchar(250) NOT NULL,
815 `created` int(11) NOT NULL,
816 `phone` varchar(20) DEFAULT NULL,
817 PRIMARY KEY (`id`)
818) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
819
820--
821-- Dumping data for table `mk_contacts`
822--
823
824INSERT INTO `mk_contacts` (`id`, `firstname`, `lastname`, `title`, `subject`, `email`, `content`, `company`, `created`, `phone`) VALUES
825(1, 'sdaf', 'asdf', 'asdf', 'asdf', 'tam@giaiphapnhanh.com.vn', 'asdf', 'sdf', 1354935668, 'asf'),
826(2, 'asf', 'asdf', 'sdaf', 'sadf', 'tam@yahoo.com', 'asdf', '123a', 1354935885, 'sadf'),
827(3, 'fsdf', 'asdf', 'asdf', 'asdf', 'tam_duy24@yahoo.com', 'asdf', 'sadf', 1354935933, 'asf');
828
829-- --------------------------------------------------------
830
831--
832-- Table structure for table `mk_google_ad`
833--
834
835CREATE TABLE IF NOT EXISTS `mk_google_ad` (
836 `id` int(11) NOT NULL AUTO_INCREMENT,
837 `title` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
838 `content` text COLLATE utf8_unicode_ci,
839 `page` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
840 `position` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
841 `image` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
842 `published` int(11) DEFAULT NULL,
843 `ordering` int(11) DEFAULT NULL,
844 `created` int(11) NOT NULL,
845 PRIMARY KEY (`id`)
846) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=12 ;
847
848--
849-- Dumping data for table `mk_google_ad`
850--
851
852INSERT INTO `mk_google_ad` (`id`, `title`, `content`, `page`, `position`, `image`, `published`, `ordering`, `created`) VALUES
853(1, 'asdf', '<script>adf</script><div>asdf</div>', NULL, 'left', '295933_419002658135639_1931300556_n.jpg', 1, 1, 1354776994),
854(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),
855(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),
856(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),
857(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),
858(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),
859(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),
860(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);
861
862-- --------------------------------------------------------
863
864--
865-- Table structure for table `mk_jobs`
866--
867
868CREATE TABLE IF NOT EXISTS `mk_jobs` (
869 `id` int(11) NOT NULL AUTO_INCREMENT,
870 `adv_id` int(11) NOT NULL,
871 `item_number` int(11) DEFAULT NULL,
872 `location` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
873 `qualification` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
874 `poster_type` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
875 `classification` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
876 `salary_offer` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
877 `salary` float DEFAULT NULL,
878 `company_name` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
879 `company_address` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
880 `phone_number` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
881 `posted_by` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
882 `contact` text COLLATE utf8_unicode_ci,
883 PRIMARY KEY (`id`)
884) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;
885
886--
887-- Dumping data for table `mk_jobs`
888--
889
890INSERT 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
891(1, 21, 1, 'c', 'a', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
892(2, 22, 2, 'c', 'a', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
893(4, 35, 0, 'adad', 'asda adasd', 'Company Direct Hire', 'Full-Time', 'Hourly', 2222, '0', 'adada', '123132', 'Business Owner', 'asdada asdasada'),
894(5, 47, NULL, 'asdf', '1', 'Company Direct Hire', 'Part-Time', 'Hourly', 123, 'sadf', 'asdf', '123', 'Job Recruiter', 'asdf');
895
896-- --------------------------------------------------------
897
898--
899-- Table structure for table `mk_oauth`
900--
901
902CREATE TABLE IF NOT EXISTS `mk_oauth` (
903 `id` int(11) NOT NULL AUTO_INCREMENT,
904 `user_id` int(11) NOT NULL,
905 `provider` varchar(10) NOT NULL,
906 `provider_id` int(11) NOT NULL,
907 `access_token` varchar(45) NOT NULL,
908 `access_token_secret` varchar(45) DEFAULT NULL,
909 `link` varchar(255) DEFAULT NULL,
910 PRIMARY KEY (`id`)
911) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
912
913-- --------------------------------------------------------
914
915--
916-- Table structure for table `mk_permission`
917--
918
919CREATE TABLE IF NOT EXISTS `mk_permission` (
920 `id` int(11) NOT NULL AUTO_INCREMENT,
921 `box_id` int(11) DEFAULT NULL,
922 `user_id` int(11) DEFAULT NULL,
923 `add_` int(11) DEFAULT NULL,
924 `edit_` int(11) DEFAULT NULL,
925 `del_` int(11) DEFAULT NULL,
926 PRIMARY KEY (`id`)
927) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=55 ;
928
929--
930-- Dumping data for table `mk_permission`
931--
932
933INSERT INTO `mk_permission` (`id`, `box_id`, `user_id`, `add_`, `edit_`, `del_`) VALUES
934(14, 1, 21, 1, 0, 1),
935(15, 2, 21, 0, 1, 0),
936(16, 3, 22, 1, 1, 1),
937(17, 4, 22, 1, 1, 1),
938(18, 2, 21, 0, 1, 0),
939(19, 1, 21, 1, 0, 1),
940(20, 3, 22, 1, 1, 1),
941(21, 1, 21, 1, 0, 1),
942(22, 4, 22, 1, 1, 1),
943(23, 1, 22, 1, 1, 1),
944(24, 4, 21, 1, 0, 1),
945(25, 3, 21, 1, 1, 1),
946(26, 2, 22, 1, 1, 0),
947(27, 9, 21, 1, 0, 0),
948(28, 15, 1, 1, 1, 1),
949(29, 1, 1, 1, 1, 1),
950(30, 2, 1, 1, 1, 1),
951(31, 3, 1, 1, 1, 1),
952(32, 4, 1, 1, 1, 1),
953(33, 5, 1, 1, 1, 1),
954(34, 6, 1, 1, 1, 1),
955(35, 7, 1, 1, 1, 1),
956(36, 8, 1, 1, 1, 1),
957(37, 9, 1, 1, 1, 1),
958(38, 10, 1, 1, 1, 1),
959(39, 11, 1, 1, 1, 1),
960(40, 12, 1, 1, 1, 1),
961(41, 13, 1, 1, 1, 1),
962(42, 14, 1, 1, 1, 1),
963(43, 16, 1, 1, 1, 1),
964(44, 11, 21, 0, 0, 0),
965(45, 5, 21, 0, 0, 0),
966(46, 6, 21, 0, 0, 0),
967(47, 7, 21, 0, 0, 0),
968(48, 8, 21, 0, 0, 0),
969(49, 10, 21, 0, 0, 0),
970(50, 12, 21, 0, 0, 0),
971(51, 13, 21, 0, 0, 0),
972(52, 14, 21, 0, 0, 0),
973(53, 15, 21, 0, 0, 0),
974(54, 16, 21, 0, 0, 0);
975
976-- --------------------------------------------------------
977
978--
979-- Table structure for table `mk_properties`
980--
981
982CREATE TABLE IF NOT EXISTS `mk_properties` (
983 `id` int(11) NOT NULL AUTO_INCREMENT,
984 `adv_id` int(11) NOT NULL,
985 `propert_name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
986 `type` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
987 `classification` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
988 `this_is` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
989 `bedroom` int(11) NOT NULL,
990 `bathroom` int(11) NOT NULL,
991 `kitchen` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
992 `garage` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
993 `maids_quarter` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
994 `condition` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
995 `location` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
996 `lot_area` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
997 `payment` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
998 `poster_type` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
999 `contact` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
1000 `price` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
1001 PRIMARY KEY (`id`)
1002) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;
1003
1004--
1005-- Dumping data for table `mk_properties`
1006--
1007
1008INSERT 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
1009(1, 31, 'a', 'b', '', 'c', 0, 0, NULL, '', '', NULL, NULL, NULL, NULL, NULL, NULL, '12'),
1010(3, 39, '', 'Apartments', 'For rent', NULL, 1, 1, 'New', '1 Car', 'Yes', 'Newly Built', 'ss', 'ss', 'ss', 'Direct Owner', 'asadasd', '19');
1011
1012-- --------------------------------------------------------
1013
1014--
1015-- Table structure for table `mk_provinces`
1016--
1017
1018CREATE TABLE IF NOT EXISTS `mk_provinces` (
1019 `id` mediumint(6) NOT NULL AUTO_INCREMENT,
1020 `country_id` mediumint(6) NOT NULL,
1021 `title` varchar(40) NOT NULL,
1022 `code` char(5) NOT NULL,
1023 `adm1code` char(10) NOT NULL,
1024 PRIMARY KEY (`id`)
1025) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3588 ;
1026
1027--
1028-- Dumping data for table `mk_provinces`
1029--
1030
1031INSERT INTO `mk_provinces` (`id`, `country_id`, `title`, `code`, `adm1code`) VALUES
1032(3534, 0, 'Zamboanga Sibugay', '', ''),
1033(3535, 0, 'Zamboanga del Norte', '', ''),
1034(3536, 0, 'Surigao del Sur', '', ''),
1035(3537, 0, ' Surigao del Norte', '', ''),
1036(3538, 0, 'Sulu', '', ''),
1037(3539, 0, 'Sultan Kudarat', '', ''),
1038(3540, 0, 'Southern Leyte', '', ''),
1039(3541, 0, 'Siquijor', '', ''),
1040(3542, 0, 'Sarangani', '', ''),
1041(3543, 0, 'Samar', '', ''),
1042(3544, 0, 'Romblon', '', ''),
1043(3545, 0, 'Quirino', '', ''),
1044(3546, 0, ' Oriental Mindoro', '', ''),
1045(3547, 0, 'Occidental Mindoro', '', ''),
1046(3548, 0, 'Nueva Vizcaya', '', ''),
1047(3549, 0, 'Nueva Ecija', '', ''),
1048(3550, 0, 'Mountain Province', '', ''),
1049(3551, 0, 'Metro Manila', '', ''),
1050(3552, 0, ' Masbate', '', ''),
1051(3553, 0, 'Marinduque', '', ''),
1052(3554, 0, 'Maguindanao', '', ''),
1053(3555, 0, 'Lanao del Sur', '', ''),
1054(3556, 0, ' Lanao del Norte', '', ''),
1055(3557, 0, 'Kalinga', '', ''),
1056(3558, 0, ' Isabela', '', ''),
1057(3559, 0, 'Ilocos Norte', '', ''),
1058(3560, 0, 'Ifugao', '', ''),
1059(3561, 0, 'Guimaras', '', ''),
1060(3562, 0, ' Eastern Samar', '', ''),
1061(3563, 0, 'Dinagat Islands', '', ''),
1062(3564, 0, 'Davao del Sur', '', ''),
1063(3565, 0, 'Cotabato', '', ''),
1064(3566, 0, ' Compostela Valley', '', ''),
1065(3567, 0, 'Cebu', '', ''),
1066(3568, 0, 'Catanduanes', '', ''),
1067(3569, 0, 'Camiguin', '', ''),
1068(3570, 0, 'Camarines Norte', '', ''),
1069(3571, 0, 'Bulacan', '', ''),
1070(3572, 0, 'Bukidnon', '', ''),
1071(3573, 0, 'Bohol', '', ''),
1072(3574, 0, 'Biliran', '', ''),
1073(3575, 0, ' Benguet', '', ''),
1074(3576, 0, 'Batangas', '', ''),
1075(3577, 0, ' Batanes', '', ''),
1076(3578, 0, 'Bataan', '', ''),
1077(3579, 0, ' Basilan', '', ''),
1078(3580, 0, 'Aurora', '', ''),
1079(3581, 0, 'Apayao', '', ''),
1080(3582, 0, 'Antique', '', ''),
1081(3583, 0, 'Albay', '', ''),
1082(3584, 0, ' Aklan', '', ''),
1083(3585, 0, 'Agusan del Sur', '', ''),
1084(3586, 0, 'Agusan del Norte', '', ''),
1085(3587, 0, 'Abra', '', '');
1086
1087-- --------------------------------------------------------
1088
1089--
1090-- Table structure for table `mk_reports`
1091--
1092
1093CREATE TABLE IF NOT EXISTS `mk_reports` (
1094 `id` int(11) NOT NULL AUTO_INCREMENT,
1095 `item_id` int(11) NOT NULL,
1096 `user_id` int(11) NOT NULL,
1097 `type` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
1098 `created` int(11) NOT NULL,
1099 `status` tinyint(4) NOT NULL,
1100 PRIMARY KEY (`id`)
1101) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=11 ;
1102
1103--
1104-- Dumping data for table `mk_reports`
1105--
1106
1107INSERT INTO `mk_reports` (`id`, `item_id`, `user_id`, `type`, `created`, `status`) VALUES
1108(3, 46, 13, 'ad', 1355285440, 0),
1109(4, 46, 13, 'ad', 1355285503, 0),
1110(5, 45, 13, 'ad', 1355286589, 0),
1111(6, 46, 8, 'ad', 1355301468, 0),
1112(7, 35, 8, 'ad', 1355301740, 0),
1113(8, 45, 13, 'ad', 1355399868, 0),
1114(9, 50, 21, 'ad', 1355467167, 0),
1115(10, 37, 8, 'ad', 1355492640, 0);
1116
1117-- --------------------------------------------------------
1118
1119--
1120-- Table structure for table `mk_services`
1121--
1122
1123CREATE TABLE IF NOT EXISTS `mk_services` (
1124 `id` int(11) NOT NULL AUTO_INCREMENT,
1125 `adv_id` int(11) NOT NULL,
1126 `address` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
1127 `contact` tinytext COLLATE utf8_unicode_ci NOT NULL,
1128 PRIMARY KEY (`id`)
1129) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
1130
1131--
1132-- Dumping data for table `mk_services`
1133--
1134
1135INSERT INTO `mk_services` (`id`, `adv_id`, `address`, `contact`) VALUES
1136(1, 23, 'abc', ''),
1137(2, 24, 'defabc', ''),
1138(3, 48, '12 ASDF', '10201020'),
1139(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');
1140
1141-- --------------------------------------------------------
1142
1143--
1144-- Table structure for table `mk_settings`
1145--
1146
1147CREATE TABLE IF NOT EXISTS `mk_settings` (
1148 `id` int(11) NOT NULL AUTO_INCREMENT,
1149 `key` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
1150 `value` text COLLATE utf8_unicode_ci NOT NULL,
1151 `autoload` tinyint(1) NOT NULL,
1152 PRIMARY KEY (`id`)
1153) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;
1154
1155--
1156-- Dumping data for table `mk_settings`
1157--
1158
1159INSERT INTO `mk_settings` (`id`, `key`, `value`, `autoload`) VALUES
1160(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),
1161(2, 'twitter_oauth', '{"application_id":"rLooPJo9Fo0sUxdN3AJRgw","application_secret":"yCyUglNT0UlOF1PNvLou0SNgwPXnRAAC1js3UYyIoJg","redirect_uri":"http:\\/\\/localhost\\/ci_freemarket\\/oauth\\/twitter"}', 0),
1162(3, 'facebook_oauth', '{"application_id":"rLooPJo9Fo0sUxdN3AJRgw","application_secret":"yCyUglNT0UlOF1PNvLou0SNgwPXnRAAC1js3UYyIoJg","redirect_uri":"http:\\/\\/localhost\\/ci_freemarket\\/oauth\\/twitter"}', 0);
1163
1164-- --------------------------------------------------------
1165
1166--
1167-- Table structure for table `mk_slide`
1168--
1169
1170CREATE TABLE IF NOT EXISTS `mk_slide` (
1171 `id` int(11) NOT NULL AUTO_INCREMENT,
1172 `title` varchar(160) COLLATE utf8_unicode_ci NOT NULL,
1173 `summary` tinytext COLLATE utf8_unicode_ci NOT NULL,
1174 `images` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
1175 `url` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
1176 `ordering` int(11) NOT NULL,
1177 `published` tinyint(1) NOT NULL,
1178 PRIMARY KEY (`id`)
1179) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
1180
1181-- --------------------------------------------------------
1182
1183--
1184-- Table structure for table `mk_stat`
1185--
1186
1187CREATE TABLE IF NOT EXISTS `mk_stat` (
1188 `id` int(11) NOT NULL,
1189 `total_adv` int(11) DEFAULT NULL,
1190 `total_buysell_ad` int(11) NOT NULL,
1191 `total_service_ad` int(11) NOT NULL,
1192 `total_community_ad` int(11) NOT NULL,
1193 `total_vehicle_ad` int(11) NOT NULL,
1194 `total_job_ad` int(11) NOT NULL,
1195 `total_business_ad` int(11) NOT NULL,
1196 `total_property_ad` int(11) NOT NULL,
1197 `total_member` int(11) DEFAULT NULL,
1198 PRIMARY KEY (`id`)
1199) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1200
1201--
1202-- Dumping data for table `mk_stat`
1203--
1204
1205INSERT 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
1206(1, 108, 5, 2, 0, 0, 1, 0, 0, 100);
1207
1208-- --------------------------------------------------------
1209
1210--
1211-- Table structure for table `mk_subcribers`
1212--
1213
1214CREATE TABLE IF NOT EXISTS `mk_subcribers` (
1215 `id` int(11) NOT NULL AUTO_INCREMENT,
1216 `name` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
1217 `email` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
1218 PRIMARY KEY (`id`)
1219) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
1220
1221--
1222-- Dumping data for table `mk_subcribers`
1223--
1224
1225INSERT INTO `mk_subcribers` (`id`, `name`, `email`) VALUES
1226(1, 'Your Name', 'admin@gmail.com'),
1227(2, 'Your Name', 'abc@gmail.com');
1228
1229-- --------------------------------------------------------
1230
1231--
1232-- Table structure for table `mk_supports`
1233--
1234
1235CREATE TABLE IF NOT EXISTS `mk_supports` (
1236 `id` int(11) NOT NULL AUTO_INCREMENT,
1237 `question` varchar(250) NOT NULL DEFAULT '',
1238 `alias` varchar(250) NOT NULL DEFAULT '',
1239 `answer` text NOT NULL,
1240 `published` tinyint(1) NOT NULL,
1241 `ordering` int(11) NOT NULL,
1242 `date` int(11) NOT NULL,
1243 PRIMARY KEY (`id`)
1244) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1245
1246-- --------------------------------------------------------
1247
1248--
1249-- Table structure for table `mk_users`
1250--
1251
1252CREATE TABLE IF NOT EXISTS `mk_users` (
1253 `id` int(11) NOT NULL AUTO_INCREMENT,
1254 `username` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
1255 `password` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
1256 `type` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
1257 `name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
1258 `location_address` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
1259 `office_address` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
1260 `email` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
1261 `phone` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
1262 `avatar` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
1263 `provider` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
1264 `provider_id` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
1265 `access_token` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
1266 `access_token_secret` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
1267 `link` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
1268 `created` int(11) DEFAULT NULL,
1269 `role` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
1270 PRIMARY KEY (`id`)
1271) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=26 ;
1272
1273--
1274-- Dumping data for table `mk_users`
1275--
1276
1277INSERT 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
1278(1, 'admin', 'e10adc3949ba59abbe56e057f20f883e', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, '', NULL, 'admin'),
1279(3, 'user2', 'e10adc3949ba59abbe56e057f20f883e', '', 'User2', '123', '123', 'user', '123', '', NULL, NULL, NULL, NULL, '', NULL, 'user'),
1280(4, 'User1', 'c56d0e9a7ccec67b4ea131655038d604', '', 'User1', '123 hcm', '123 hcm', 'user@gmail.com', '09876543', '', NULL, NULL, NULL, NULL, '', NULL, 'user'),
1281(5, 'asdf', '123', 'A job Recruiter', 'asdf', 'asdf', 'asdf', 'asdf@yahoo.com', '56789', '', NULL, NULL, NULL, NULL, '', NULL, NULL),
1282(8, '123', '202cb962ac59075b964b07152d234b70', '0', '123', '', '', '123@yahoo.com', '', '', NULL, NULL, NULL, NULL, '', NULL, NULL),
1283(13, 'Tuong Tran', '', '', 'Tuong Tran', '', '', 'ranger.ht@gmail.com', '', '', 'google', '112770961585632347083', 'ya29.AHES6ZQvuX06IISg3TdoLPt2I7zwo5pznho0Dp0xq8eQV', '', 'https://plus.google.com/112770961585632347083', 1354940466, 'user'),
1284(17, 'HtTuong', '', '', 'Tuong Tran', '', '', NULL, '', '', 'twitter', '996265122', '996265122-xvpleN5UVN81jR0tnPYS7pI03w6fjpCvvuTNfJs2', '321RHq27VUvqdp4eCoFVTIN1IfPHYZVOHes02zC9Pk', NULL, 1354941237, 'user'),
1285(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'),
1286(20, 'phamduytam', '202cb962ac59075b964b07152d234b70', 'a Buyer', 'phamduytam', 'lksdf', 'laskdf', 'phamduytam@yahoo.com', '123123', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
1287(21, 'Minh', 'e10adc3949ba59abbe56e057f20f883e', 'a Buyer', 'Huu', '12 HDMT', 'HANTS', 'ptmhuu@gmail.com', '101010101010101', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
1288(22, 'universe company', '', '', 'universe company', '', '', 'hvtransco@gmail.com', '', NULL, 'google', '108017338663855784310', 'ya29.AHES6ZRwf-NPsZxNRdf9gy6FdCE2RIPvZ3X_WKDaCjUhC', '', NULL, 1355544783, 'user'),
1289(23, 'Pinky M.', '', '', 'Pinky M.', '', '', 'goingplacesinasia@yahoo.com', '', NULL, 'google', '105503752171807289495', 'ya29.AHES6ZQcbFMNimPaB-ZJZ5KXUWcDWc-MgN25L_SGatPNx', '', NULL, 1355546520, 'user'),
1290(24, 'tmhai', '70a0f9894d2df18c2507d231a94caee8', 'a Buyer or a Seller', 'hai', 'erer', 'erere', 'truong_minhhai@yahoo.com', '1213232434', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
1291(25, 'pinky', 'e10adc3949ba59abbe56e057f20f883e', 'a Seller', 'Miss Smith', 'USA', 'USA', 'arianna07728@yahoo.com', '101200120', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
1292
1293-- --------------------------------------------------------
1294
1295--
1296-- Table structure for table `mk_verhicles`
1297--
1298
1299CREATE TABLE IF NOT EXISTS `mk_verhicles` (
1300 `id` int(11) NOT NULL AUTO_INCREMENT,
1301 `adv_id` int(11) NOT NULL,
1302 `item_number` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
1303 `type` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
1304 `brand` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
1305 `model_year` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
1306 `fuel_type` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
1307 `mileage` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
1308 `condition` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
1309 `negotiable` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
1310 `model_type` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
1311 `engine_type` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
1312 `accessory` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
1313 `address` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
1314 `payment` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
1315 `contact` text COLLATE utf8_unicode_ci,
1316 `price` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
1317 PRIMARY KEY (`id`)
1318) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
1319
1320--
1321-- Dumping data for table `mk_verhicles`
1322--
1323
1324INSERT 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
1325(1, 25, '11', NULL, 'a', 'b1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '121'),
1326(2, 37, '0', 'Car', 'Chrysler', '1978', 'Diesel', '61,000-70,000 Km', 'Second Hand', 'Other', 'asdasd', 'asdsad', 'asdsad', 'adsad', 'asd', 'adasdas', '1123');
1327
1328/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1329/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1330/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;