-- phpMyAdmin SQL Dump
-- version 4.0.10deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 06, 2016 at 10:38 AM
-- Server version: 5.5.46-0ubuntu0.14.04.2
-- PHP Version: 5.5.9-1ubuntu4.14

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: `cc_adexchange`
--

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

--
-- Table structure for table `adv_categories`
--

CREATE TABLE IF NOT EXISTS `adv_categories` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `parent_id` varchar(20) NOT NULL,
  `type` enum('B','I') NOT NULL,
  `description` varchar(255) NOT NULL,
  `iab_id` varchar(20) DEFAULT NULL,
  `iab_parent_id` varchar(20) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=125 ;

--
-- Dumping data for table `adv_categories`
--

INSERT INTO `adv_categories` (`id`, `parent_id`, `type`, `description`, `iab_id`, `iab_parent_id`, `status`) VALUES
(1, '0', 'B', 'Business Services', 'IAB0', '', 1),
(2, '0', 'B', 'Professional services', 'IAB0', '', 1),
(3, '0', 'B', 'Local Services', 'IAB0', '', 1),
(4, '0', 'B', 'Brands', 'IAB24', '', 1),
(5, '0', 'B', 'Recreational', 'IAB17', '', 1),
(6, '0', 'B', 'Jobs', 'IAB4', '', 1),
(7, '0', 'B', 'Community & Events', 'IAB24', '', 1),
(8, '0', 'I', 'Personals / services', 'IAB14', '', 1),
(9, '0', 'I', 'Real Estate', 'IAB21', '', 1),
(10, '0', 'I', 'Resell Items', 'IAB0', '', 1),
(11, '10', 'I', 'Furniture & Furnishing', 'IAB10', '', 1),
(12, '10', 'I', 'Electronic & Electrical Items', 'IAB10', '', 1),
(13, '10', 'I', 'Kids & Baby Products', 'IAB6', '', 1),
(14, '10', 'I', 'Vehicles', 'IAB2', '', 1),
(15, '10', 'I', 'Mobile, Accessories & Others', 'IAB19', '', 1),
(16, '10', 'I', 'Books, clothing & Accessories', 'IAB18', '', 1),
(17, '9', 'I', 'Apartments', 'IAB21', '', 1),
(18, '9', 'I', 'Independent Houses, Villas/Bungalows', 'IAB21', '', 1),
(19, '9', 'I', 'Land - Plots', 'IAB21', '', 1),
(20, '9', 'I', 'Office & Shops Commercial Property', 'IAB21', '', 1),
(21, '9', 'I', 'Garage', 'IAB21', '', 1),
(22, '9', 'I', 'Guest Houses-Vacation Rentals, Timeshare', 'IAB21', '', 1),
(23, '8', 'I', 'Roommates/flatmate', 'IAB14', '', 1),
(24, '8', 'I', 'Musicians, Dancer & Singer', 'IAB4', '', 1),
(25, '8', 'I', 'Writer', 'IAB4', '', 1),
(26, '8', 'I', 'Astrologer', 'IAB23', '', 1),
(27, '8', 'I', 'Artist', 'IAB4', '', 1),
(28, '8', 'I', 'Acting - Modeling', 'IAB4', '', 1),
(29, '8', 'I', 'Photographers - Cameraman', 'IAB4', '', 1),
(30, '8', 'I', 'Fashion Designers - Stylists', 'IAB4', '', 1),
(31, '8', 'I', 'Gym, Health & Fitness Trainer', 'IAB4', '', 1),
(32, '8', 'I', 'Event -Party Planners - DJ', 'IAB24', '', 1),
(33, '7', 'B', 'Donation and Charity', 'IAB24', '', 1),
(34, '7', 'B', 'Announcements', 'IAB12', '', 1),
(35, '7', 'B', 'Tender Notices', 'IAB12', '', 1),
(36, '7', 'B', 'Lost - Found', 'IAB12', '', 1),
(37, '7', 'B', 'Events', 'IAB12', '', 1),
(38, '7', 'B', 'Political Campaigns', 'IAB11', '', 1),
(39, '6', 'B', 'Job Offers', 'IAB4', '', 1),
(40, '5', 'B', 'Adventure Sports', 'IAB17', '', 1),
(41, '5', 'B', 'Clubs & Swimming Pool', 'IAB17', '', 1),
(42, '5', 'B', 'Cultural Activities', 'IAB1', '', 1),
(43, '5', 'B', 'Meditation/Yoga', 'IAB7', '', 1),
(44, '5', 'B', 'Gym', 'IAB7', '', 1),
(45, '5', 'B', 'Musicians-Band', 'IAB9', '', 1),
(47, '4', 'B', 'Existing product', 'IAB24', '', 1),
(48, '4', 'B', 'Upcoming brands', 'IAB24', '', 1),
(49, '4', 'B', 'Contest', 'IAB24', '', 1),
(50, '4', 'B', 'Events', 'IAB24', '', 1),
(51, '4', 'B', 'Offer', 'IAB24', '', 1),
(52, '4', 'B', 'Regional Brands', 'IAB24', '', 1),
(53, '3', 'B', 'Restaurant & Bar', 'IAB8', '', 1),
(54, '3', 'B', 'Bakery', 'IAB8', '', 1),
(55, '3', 'B', 'Saloon & Beauty Parlor', 'IAB18', '', 1),
(56, '3', 'B', 'Clinic & Medical Stores', 'IAB7', '', 1),
(57, '3', 'B', 'Boutiques', 'IAB18', '', 1),
(58, '3', 'B', 'Hardware & Sanitary', 'IAB3', '', 1),
(59, '3', 'B', 'Furniture store', 'IAB9', '', 1),
(60, '3', 'B', 'Photo Studio-Photographers', 'IAB9', '', 1),
(61, '3', 'B', 'Home Based Business', 'IAB9', '', 1),
(62, '3', 'B', 'Hotels', 'IAB20', '', 1),
(63, '3', 'B', 'Guest House', 'IAB20', '', 1),
(64, '3', 'B', 'Departmental Stores', 'IAB22', '', 1),
(65, '3', 'B', 'Hostels', 'IAB20', '', 1),
(66, '3', 'B', 'Grocery', 'IAB22', '', 1),
(67, '3', 'B', 'Electronics Appliances & Repair', 'IAB10', '', 1),
(68, '3', 'B', 'Sports  Shop', 'IAB17', '', 1),
(69, '3', 'B', 'Coffee Shop', 'IAB8', '', 1),
(70, '3', 'B', 'Catering -Tiffin Services', 'IAB8', '', 1),
(71, '3', 'B', 'Household Services', 'IAB10', '', 1),
(72, '3', 'B', 'Agencies', 'IAB3', '', 1),
(73, '2', 'B', 'CA', 'IAB0', '', 1),
(74, '2', 'B', 'Legal', 'IAB11', '', 1),
(75, '2', 'B', 'Architect', 'IAB21', '', 1),
(76, '2', 'B', 'Educational services', 'IAB5', '', 1),
(77, '2', 'B', 'Contractor', 'IAB24', '', 1),
(78, '2', 'B', 'Doctor', 'IAB7', '', 1),
(79, '2', 'B', 'Financial Advisor-Loans & Insurance', 'IAB13', '', 1),
(80, '2', 'B', 'Writing Specialist', 'IAB9', '', 1),
(81, '2', 'B', 'Wedding Planner', 'IAB24', '', 1),
(82, '2', 'B', 'Fashion Designer', 'IAB24', '', 1),
(83, '2', 'B', 'IT Solutions', 'IAB19', '', 1),
(84, '2', 'B', 'Art Directors - Editors', 'IAB24', '', 1),
(85, '2', 'B', 'Sound Engineers', 'IAB24', '', 1),
(86, '2', 'B', 'Set Designers', 'IAB24', '', 1),
(87, '2', 'B', 'Religious Services-Astrology, Numerology & Vaastu', 'IAB23', '', 1),
(88, '2', 'B', 'Acting,  Modeling & Photography', 'IAB9', '', 1),
(89, '2', 'B', 'Broker & Agents', 'IAB3', '', 1),
(90, '1', 'B', 'Lifestyle Showrooms- Clothing & Accessories', 'IAB18', '', 1),
(91, '1', 'B', 'Modeling Agencies', 'IAB3', '', 1),
(92, '1', 'B', 'Event Management', 'IAB3', '', 1),
(93, '1', 'B', 'Training & skill development centers', 'IAB5', '', 1),
(94, '1', 'B', 'Moving & Packing services', 'IAB3', '', 1),
(95, '1', 'B', 'Health, Fitness & Beauty services', 'IAB7', '', 1),
(96, '1', 'B', 'Animal & Pet Services', 'IAB16', '', 1),
(97, '1', 'B', 'Investment,Taxation & Financial Planning', 'IAB13', '', 1),
(98, '1', 'B', 'Postal & Courier Services', 'IAB3', '', 1),
(99, '1', 'B', 'Institutes/Colleges', 'IAB5', '', 1),
(100, '1', 'B', 'Insurance Services', 'IAB13', '', 1),
(101, '1', 'B', 'Security Services', 'IAB3', '', 1),
(102, '1', 'B', 'Home Furniture, Furnishing &  Upholstery', 'IAB10', '', 1),
(103, '1', 'B', 'Automobile- Car, Bike', 'IAB2', '', 1),
(104, '1', 'B', 'Printing & Publishing Services', 'IAB3', '', 1),
(105, '1', 'B', 'Hospitals', 'IAB7', '', 1),
(106, '1', 'B', 'Banks', 'IAB13', '', 1),
(107, '1', 'B', 'Tickets, Tourism & Transport', 'IAB20', '', 1),
(108, '1', 'B', 'E-Commerce,Apps, Games, Entertainment', 'IAB19', '', 1),
(109, '1', 'B', 'Real Estate', 'IAB21', '', 1),
(110, '5', 'B', 'Arts & Entertainment', 'IAB1', '', 1),
(111, '1', 'B', 'Business Services', NULL, '', 1),
(112, '4', 'B', 'Brands', NULL, '', 1),
(113, '0', 'B', 'e-commerce', NULL, '', 1),
(114, '113', 'B', 'e-commerce', NULL, '', 1),
(115, '0', 'B', 'Marketers', NULL, '', 1),
(116, '115', 'B', 'Marketers', NULL, '', 1),
(117, '0', 'B', 'Automobile', NULL, '', 1),
(118, '117', 'B', 'Automobile', NULL, '', 1),
(119, '0', 'B', 'Entertainment', NULL, '', 1),
(120, '119', 'B', 'Entertainment', NULL, '', 1),
(121, '3', 'B', 'Local Services', NULL, '', 1),
(122, '8', 'I', 'Personals', NULL, '', 1),
(123, '9', 'I', 'Real Estate', NULL, '', 1),
(124, '10', 'I', 'Resell Items', NULL, '', 1);

/*!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 */;
