database.sql

-- phpMyAdmin SQL Dump
-- version 2.11.5.1
-- http://www.phpmyadmin.net
--
-- Host: professorX.nu-designs.com
-- Generation Time: Feb 11, 2010 at 12:15 AM
-- Server version: 4.1.22
-- PHP Version: 5.2.12

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `dc_api`
--

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

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

CREATE TABLE IF NOT EXISTS `categories` (
  `id` int(10) NOT NULL auto_increment,
  `title` varchar(255) default NULL,
  `created` datetime default NULL,
  `modified` datetime default NULL,
  `status_id` int(10) NOT NULL default '1',
  `alias` varchar(255) default NULL,
  `synonyms` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=404 ;

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

INSERT INTO `categories` (`id`, `title`, `created`, `modified`, `status_id`, `alias`, `synonyms`) VALUES
(1, 'Accounting', '2006-11-20 15:35:29', '2008-11-13 11:34:30', 1, 'accounting', NULL),
(2, 'Air Duct & Dryer Duct Cleaning', '2006-11-20 15:35:29', '2007-02-26 13:44:56', 1, 'air_duct_dryer_duct_cleaning', NULL),
(3, 'Air Duct Cleaning', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'air_duct_cleaning', NULL),
(4, 'Aircraft Charters', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'aircraft_charters', NULL),
(5, 'Alarm & Security Systems', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'alarm_security_systems', NULL),
(6, 'Appliances', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'appliances', NULL),
(7, 'Art Gallery', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'art_gallery', NULL),
(8, 'Assisted Living Facilities', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'assisted_living_facilities', NULL),
(9, 'Audio - Video - Home Theater', '2006-11-20 15:35:29', '2006-12-18 15:44:47', 1, 'audio_video_home_theater', NULL),
(10, 'Audiologist', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'audiologist', NULL),
(11, 'Auto - Air Conditioning', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'auto_air_conditioning', NULL),
(12, 'Auto - Mobile Battery Replacement', '2006-11-20 15:35:29', '2007-02-26 13:44:50', 1, 'auto_mobile_battery_replacement', NULL),
(13, 'Auto - Oil Change', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'auto_oil_change', NULL),
(14, 'Auto - Smog', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'auto_smog', NULL),
(15, 'Auto - Smog Test Only', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'auto_smog_test_only', NULL),
(16, 'Auto Accessories', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'auto_accessories', NULL),
(17, 'Auto Body', '2006-11-20 15:35:29', '2006-12-20 15:57:04', 1, 'auto_body', NULL),
(18, 'Auto Body - Paintless Dent Repair', '2006-11-20 15:35:29', '2007-02-26 13:44:46', 1, 'auto_body_paintless_dent_repair', NULL),
(19, 'Auto Brokers', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'auto_brokers', NULL),
(20, 'Auto Dealer - New & Used Sales', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'auto_dealer_new_used_sales', NULL),
(21, 'Auto Diagnostics', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'auto_diagnostics', NULL),
(22, 'Auto Glass', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'auto_glass', NULL),
(23, 'Auto Mufflers', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'auto_mufflers', NULL),
(24, 'Auto Mufflers & Brakes', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'auto_mufflers_brakes', NULL),
(25, 'Auto Repair', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'auto_repair', NULL),
(26, 'Auto Repair - Dealership', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'auto_repair_dealership', NULL),
(27, 'Auto Repair - Porsche Specialist', '2006-11-20 15:35:29', '2009-05-08 10:46:47', 1, 'auto_repair_porsche_specialist', ''),
(28, 'Auto Stereo', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'auto_stereo', NULL),
(29, 'Auto Stereo, Mobile Video, Navigation, Security', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'auto_stereo_mobile_video_navigation_security', NULL),
(30, 'Auto Tire, Wheel, & Alignment', '2006-11-20 15:35:29', '2008-11-13 12:15:57', 1, 'auto_tire_wheel_alignment', NULL),
(31, 'Auto Tires', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'auto_tires', NULL),
(32, 'Auto Tops & Upholstery', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'auto_tops_upholstery', NULL),
(33, 'Auto Transmission', '2006-11-20 15:35:29', '2008-03-04 13:49:01', 8, 'auto_transmission', NULL),
(34, 'Auto Transmissions', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'auto_transmissions', NULL),
(35, 'Auto Wheels - Tires, Brakes, Alignment', '2006-11-20 15:35:29', '2008-05-06 13:57:19', 8, 'auto_wheels_tires_brakes_alignment', NULL),
(36, 'Awnings', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'awnings', NULL),
(37, 'Bamboo Flooring', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'bamboo_flooring', NULL),
(38, 'Bathtubs & Showers', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'bathtubs_showers', NULL),
(39, 'Bathtubs & Tile Refinishing', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'bathtubs_tile_refinishing', NULL),
(40, 'Beauty Supplies', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'beauty_supplies', NULL),
(41, 'Bicycles - Sales & Service', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'bicycles_sales_service', NULL),
(42, 'Bookkeeping', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'bookkeeping', NULL),
(43, 'Cabinets', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'cabinets', NULL),
(44, 'Cabinets - Dealers', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'cabinets_dealers', NULL),
(45, 'Cabinets - Refacing', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'cabinets_refacing', NULL),
(46, 'Cabinets - Roll-out Shelving', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'cabinets_roll_out_shelving', NULL),
(47, 'Camera & Camcorder Repair', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'camera_camcorder_repair', NULL),
(48, 'Carpet & Rug Cleaning', '2006-11-20 15:35:29', '2009-05-07 10:14:22', 8, 'carpet_rug_cleaning', ''),
(49, 'Carpet Cleaning', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'carpet_cleaning', NULL),
(50, 'Carpet Showrooms', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'carpet_showrooms', NULL),
(51, 'Catering', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'catering', NULL),
(52, 'Ceiling Contractors', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'ceiling_contractors', NULL),
(53, 'Cemetery', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'cemetery', NULL),
(54, 'Chimney Sweep', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'chimney_sweep', NULL),
(55, 'Chiropractors', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'chiropractors', NULL),
(56, 'Civil Engineers', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'civil_engineers', NULL),
(57, 'Closet & Home Office Organizing', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'closet_home_office_organizing', NULL),
(58, 'Computer - Printer Repair', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'computer_printer_repair', NULL),
(59, 'Computer - Networks', '2006-11-20 15:35:29', '2009-03-31 16:28:01', 1, 'computer_networking', ''),
(60, 'Computer Sales & Service', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'computer_sales_service', NULL),
(61, 'Computer Service & Repair', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'computer_service_repair', NULL),
(62, 'Concrete - Ready Mix', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'concrete_ready_mix', NULL),
(63, 'Concrete Contractors', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'concrete_contractors', NULL),
(64, 'Consignment Service', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'consignment_service', NULL),
(65, 'Contractors - Commercial', '2006-11-20 15:35:29', '2008-03-04 14:00:53', 1, 'contractors_commercial', NULL),
(66, 'Contractors - Custom Home Builders2', '2006-11-20 15:35:29', '2009-05-01 16:55:10', 8, 'contractors_custom_home_builders', ''),
(67, 'Contractors - Design and Build', '2006-11-20 15:35:29', '2009-04-13 13:50:24', 1, 'contractors_design_and_build', ''),
(68, 'Contractors - Water & Fire Damage', '2006-11-20 15:35:29', '2008-06-05 09:58:57', 1, 'contractors_water_fire_damage', NULL),
(69, 'Contractors - Custom Home Builders', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'contractors_custom_home_builders_2', NULL),
(70, 'Contractors - Design & Build', '2006-11-20 15:35:29', '2009-03-24 15:56:18', 1, 'contractors_design_build', ''),
(71, 'Contractors - Fire & Water Damage', '2006-11-20 15:35:29', '2008-03-04 14:09:59', 8, 'contractors_fire_water_damage', NULL),
(72, 'Contractors - Green Builder', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'contractors_green_builder', NULL),
(73, 'Countertops', '2006-11-20 15:35:29', '2007-11-13 08:33:49', 1, 'countertops', NULL),
(74, 'Crystals', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'crystals', NULL),
(75, 'Deck & Patio', '2006-11-20 15:35:29', '2008-03-04 15:10:09', 8, 'deck_patio', NULL),
(76, 'Decks', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'decks', NULL),
(77, 'Decks & Patios', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'decks_patios', NULL),
(78, 'Dentists', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'dentists', NULL),
(79, 'Doors - Interior', '2006-11-20 15:35:29', '2008-03-04 15:15:36', 1, 'doors_interior', NULL),
(80, 'Doors - Entry & Custom', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'doors_entry_custom', NULL),
(81, 'Doors - Specialty', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'doors_specialty', NULL),
(82, 'Drainage', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'drainage', NULL),
(83, 'Driving Schools', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'driving_schools', NULL),
(84, 'Dry Cleaners', '2006-11-20 15:35:29', '2008-12-16 11:23:25', 1, 'dry_cleaners', ''),
(85, 'Dry Cleaning', '2006-11-20 15:35:29', '2008-03-04 15:21:10', 8, 'dry_cleaning', NULL),
(86, 'Dry Cleaners and Laundry', '2006-11-20 15:35:29', '2009-01-29 11:31:13', 1, 'dry_cleaning_laundry', ''),
(87, 'Drywall Contractors', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'drywall_contractors', NULL),
(88, 'Electrical Contractors', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'electrical_contractors', NULL),
(89, 'Fence Contractors', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'fence_contractors', NULL),
(90, 'Fences', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'fences', NULL),
(91, 'Fire Protection', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'fire_protection', NULL),
(92, 'Fireplaces & Stoves', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'fireplaces_stoves', NULL),
(93, 'Floor Installation', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'floor_installation', NULL),
(94, 'Flooring Showroom_do not use', '2006-11-20 15:35:29', '2009-05-06 21:15:54', 8, 'flooring', ''),
(95, 'Hardwood Floor Refinishing', '2006-11-20 15:35:29', '2009-04-17 09:40:00', 1, 'flooring_hardwood_refinishing', ''),
(96, 'Foundation Contractors', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'foundation_contractors', NULL),
(97, 'Foundation Repair', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'foundation_repair', NULL),
(98, 'Framing Contractors', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'framing_contractors', NULL),
(99, 'Fumigation', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'fumigation', NULL),
(100, 'Funeral Services', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'funeral_services', NULL),
(101, 'Furniture', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'furniture', NULL),
(102, 'Furniture - Custom', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'furniture_custom', NULL),
(103, 'Furniture - Deck & Patio', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'furniture_deck_patio', NULL),
(104, 'Furniture - Home', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'furniture_home', NULL),
(105, 'Furniture - Teak', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'furniture_teak', NULL),
(106, 'Garage Doors', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'garage_doors', NULL),
(107, 'Garage Doors/Gate - Specialty', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'garage_doors_gate_specialty', NULL),
(108, 'Gates - Automatic', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'gates_automatic', NULL),
(109, 'Gazebos', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'gazebos', NULL),
(110, 'General Contractors', '2006-11-20 15:35:29', '2008-03-04 15:22:41', 1, 'general_contractors', NULL),
(111, 'General Contractors', '2006-11-20 15:35:29', '2008-03-04 15:22:57', 8, 'general_contractors_2', NULL),
(112, 'Glass', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'glass', NULL),
(113, 'Gutter Protection', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'gutter_protection', NULL),
(114, 'Gutters', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'gutters', NULL),
(115, 'Hair Replacement', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'hair_replacement', NULL),
(116, 'Handyman', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'handyman', NULL),
(117, 'Handyman - Home Repairs', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'handyman_home_repairs', NULL),
(118, 'Hardwood Floors', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'hardwood_floors', NULL),
(119, 'Hauling', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'hauling', NULL),
(120, 'Health Clubs', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'health_clubs', NULL),
(121, 'Hearing Aids', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'hearing_aids', NULL),
(122, 'Hearing Aids - Audiologists', '2006-11-20 15:35:29', '2008-12-08 14:14:53', 8, 'hearing_aids_audiologists', ''),
(123, 'Heating, Air Conditioning & Ventilation (HVAC)', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'heating_air_conditioning_ventilation_hvac', NULL),
(124, 'Home Builders - Communities', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'home_builders_communities', NULL),
(125, 'Home Improvement Centers', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'home_improvement_centers', NULL),
(126, 'Home Security Sales & Service', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'home_security_sales_service', NULL),
(127, 'Hot Tub Facilities', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'hot_tub_facilities', NULL),
(128, 'Hot Tubs', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'hot_tubs', NULL),
(129, 'House Cleaning', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'house_cleaning', NULL),
(130, 'Insulation', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'insulation', NULL),
(131, 'Insurance - Auto & Home', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'insurance_auto_home', NULL),
(132, 'Insurance - Employee Benefits', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'insurance_employee_benefits', NULL),
(133, 'Insurance - Health & Employee Benefits', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'insurance_health_employee_benefits', NULL),
(134, 'Iron Ornamental Work', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'iron_ornamental_work', NULL),
(135, 'Jeweler', '2006-11-20 15:35:29', '2008-03-04 15:02:01', 8, 'jeweler', NULL),
(136, 'Jewelers', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'jewelers', NULL),
(137, 'Kitchen & Bath - Contractors', '2006-11-20 15:35:29', '2008-12-18 15:17:07', 1, 'kitchen_bathroom_contractors', ''),
(138, 'Kitchen & Bath - Showrooms & Design', '2006-11-20 15:35:29', '2008-12-18 15:16:47', 1, 'kitchen_bathroom_showrooms_design', ''),
(139, 'Land Surveyors', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'land_surveyors', NULL),
(140, 'Landscape - Designers & Consultants', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'landscape_designers_consultants', NULL),
(141, 'Landscape - Contractors', '2006-11-20 15:35:29', '2009-10-22 10:30:47', 1, 'landscape_contractors', ''),
(142, 'Landscape - Contractor', '2006-11-20 15:35:29', '2009-10-22 10:21:13', 1, 'landscaping', ''),
(143, 'Landscaping Materials', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'landscaping_materials', NULL),
(144, 'Lawns - Synthetic Turf', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'lawns_synthetic_turf', NULL),
(145, 'Lead Abatement', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'lead_abatement', NULL),
(146, 'Lighting Showroom', '2006-11-20 15:35:29', '2008-03-04 15:24:33', 8, 'lighting_showroom', NULL),
(147, 'Lighting Showrooms', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'lighting_showrooms', NULL),
(148, 'Limousines', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'limousines', NULL),
(149, 'Locksmith', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'locksmith', NULL),
(150, 'Lumber', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'lumber', NULL),
(151, 'Marble & Stone', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'marble_stone', NULL),
(152, 'Marble & Stone Restoration', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'marble_stone_restoration', NULL),
(153, 'Massage Therapy Centers', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'massage_therapy_centers', NULL),
(154, 'Mattresses', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'mattresses', NULL),
(155, 'Medical Equipment', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'medical_equipment', NULL),
(156, 'Medical Lifts and Ramps', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'medical_lifts_and_ramps', NULL),
(157, 'Medical Supplies & Equipment', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'medical_supplies_equipment', NULL),
(158, 'Mortgage - Banks', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'mortgage_banks', NULL),
(159, 'Mortgage - Brokers', '2006-11-20 15:35:29', '2009-06-16 21:09:36', 1, 'mortgage_brokers', ''),
(160, 'Mortgage Brokers', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'mortgage_brokers_2', NULL),
(161, 'Motorcycle Parts & Accessories', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'motorcycle_parts_accessories', NULL),
(162, 'Moulding', '2006-11-20 15:35:29', '2009-04-06 13:26:22', 8, 'moulding', ''),
(163, 'Moulding & Trim Installation', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'moulding_trim_installation', NULL),
(164, 'Movers', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'movers', NULL),
(165, 'Notary Public', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'notary_public', NULL),
(166, 'Optometrists', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'optometrists', NULL),
(167, 'Paint Stores', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'paint_stores', NULL),
(168, 'Painting - Faux & Decorative Finishes', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'painting_faux_decorative_finishes', NULL),
(169, 'Painting - Wood Restoration', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'painting_wood_restoration', NULL),
(170, 'Painting - Contractor', '2006-11-20 15:35:29', '2009-10-14 16:00:34', 1, 'painting_contractors', ''),
(171, 'Paving - Asphalt, Stamping', '2006-11-20 15:35:29', '2009-03-24 14:42:38', 1, 'paving_asphalt_stamping', ''),
(172, 'Paving - Specialty Engineering', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'paving_specialty_engineering', NULL),
(173, 'Paving Stones', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'paving_stones', NULL),
(174, 'Pest Control', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'pest_control', NULL),
(175, 'Pet Sitting', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'pet_sitting', NULL),
(176, 'Pets - Feedstore and Supplies', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'pets_feedstore_and_supplies', NULL),
(177, 'Plastering', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'plastering', NULL),
(178, 'Plumbing', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'plumbing', NULL),
(179, 'Plumbing Fixture Showrooms', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'plumbing_fixture_showrooms', NULL),
(180, 'Podiatrist', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'podiatrist', NULL),
(181, 'Pool & Spa Service & Repair', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'pool_spa_service_repair', NULL),
(182, 'Printed Circuit Board - Design & Manufacturing', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'printed_circuit_board_design_manufacturing', NULL),
(183, 'Printers', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'printers', NULL),
(184, 'Property Management', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'property_management', NULL),
(185, 'Real Estate', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'real_estate', NULL),
(186, 'Real Estate - Commercial', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'real_estate_commercial', NULL),
(187, 'Real Estate - Home Staging', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'real_estate_home_staging', NULL),
(188, 'Real Estate Brokers', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'real_estate_brokers', NULL),
(189, 'Real Estate - Exchange & Reverse Exchange Services', '2006-11-20 15:35:29', '2009-09-22 13:25:24', 1, 'real_estate_exchange_reverse_exchange_services', ''),
(190, 'Real Estate Sales', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'real_estate_sales', NULL),
(191, 'Records Management', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'records_management', NULL),
(192, 'Renewable Resources', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'renewable_resources', NULL),
(193, 'Restoration: Mold & Water', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'restoration_mold_water', NULL),
(194, 'Restoration: Water & Mold', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'restoration_water_mold', NULL),
(195, 'Roofing', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'roofing', NULL),
(196, 'Roofing - Slate', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'roofing_slate', NULL),
(197, 'Rug Cleaning & Restoration', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'rug_cleaning_restoration', NULL),
(198, 'Rugs - Sales & Service', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'rugs_sales_service', NULL),
(199, 'RV Sales & Service', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'rv_sales_service', NULL),
(200, 'Scaffolding', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'scaffolding', NULL),
(201, 'Screen Printing & Embroidery', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'screen_printing_embroidery', NULL),
(202, 'Screens', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'screens', NULL),
(203, 'Security Video Surveillance System', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'security_video_surveillance_system', NULL),
(204, 'Septic Install & Repair', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'septic_install_repair', NULL),
(205, 'Septic Tanks', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'septic_tanks', NULL),
(206, 'Shower Enclosures', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'shower_enclosures', NULL),
(207, 'Shredding', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'shredding', NULL),
(208, 'Shutters', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'shutters', NULL),
(209, 'Siding', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'siding', NULL),
(210, 'Siding - Wood Shingles', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'siding_wood_shingles', NULL),
(211, 'Skylights', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'skylights', NULL),
(212, 'Solar', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'solar', NULL),
(213, 'Solar Attic Fans', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'solar_attic_fans', NULL),
(214, 'Solar Energy Systems', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'solar_energy_systems', NULL),
(215, 'Stone, Brick & Masonry Materials', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'stone_brick_masonry_materials', NULL),
(216, 'Stone, Tile & Grout Cleaning', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'stone_tile_grout_cleaning', NULL),
(217, 'Storage - Self', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'storage_self', NULL),
(218, 'Sunrooms', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'sunrooms', NULL),
(219, 'Sustainable Energy', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'sustainable_energy', NULL),
(220, 'Swimming Pool - Solar Heating', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'swimming_pool_solar_heating', NULL),
(221, 'Swimming Pool & Spa Service', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'swimming_pool_spa_service', NULL),
(222, 'Swimming Pool Contractors', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'swimming_pool_contractors', NULL),
(223, 'Swimming Pool Service & Retail', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'swimming_pool_service_retail', NULL),
(224, 'Swimming Pools', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'swimming_pools', NULL),
(225, 'Tattoo & Body Piercing', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'tattoo_body_piercing', NULL),
(226, 'Tax Preparation', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'tax_preparation', NULL),
(227, 'Telecommunications', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'telecommunications', NULL),
(228, 'Termite Control', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'termite_control', NULL),
(229, 'Tile - Showrooms', '2006-11-20 15:35:29', '2009-05-08 11:56:02', 1, 'tile_showrooms', ''),
(230, 'Tile & Stone - Showrooms', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'tile_stone_showrooms', NULL),
(231, 'Tile Contractors', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'tile_contractors', NULL),
(232, 'Towing', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'towing', NULL),
(233, 'Tree Service', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'tree_service', NULL),
(234, 'Upholstery', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'upholstery', NULL),
(235, 'Vacuum - Central System', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'vacuum_central_system', NULL),
(236, 'Veterinary', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'veterinary', NULL),
(237, 'Video & Multi-Media Services', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'video_multi_media_services', NULL),
(238, 'Water Treatment', '2006-11-20 15:35:29', '2008-11-24 14:53:34', 1, 'water_treatment', 'Bottled Water, Drinking Water, Water Softening, Water Softener'),
(239, 'Water Well & Pump', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'water_well_pump', NULL),
(240, 'Water Well Drilling', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'water_well_drilling', NULL),
(241, 'Waterproofing', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'waterproofing', NULL),
(242, 'Web Services', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'web_services', NULL),
(243, 'Weddings & Events - Banquet Facilities & Reception Venues', '2006-11-20 15:35:29', '2009-05-01 13:10:07', 1, 'weddings_events_banquet_facilities', ''),
(244, 'Weddings & Events - Catering', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'weddings_events_catering', NULL),
(245, 'Weddings & Events - DJ', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'weddings_events_dj', NULL),
(246, 'Weddings & Events - Venue Out-of-the-County', '2006-11-20 15:35:29', '2009-04-24 16:16:54', 1, 'weddings_events_reception_venues', ''),
(247, 'Weight Loss', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'weight_loss', NULL),
(248, 'Window & Door', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'window_door', NULL),
(249, 'Window Cleaning', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'window_cleaning', NULL),
(250, 'Window Coverings', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'window_coverings', NULL),
(251, 'Window Tinting', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'window_tinting', NULL),
(252, 'Window Washing', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'window_washing', NULL),
(253, 'Window Coverings (OLD/INACTIVE)', '2006-11-20 15:35:29', '2008-10-23 11:19:34', 8, 'window_coverings_old_inactive', NULL),
(254, 'Wine Cellars', '2006-11-20 15:35:29', '2006-11-20 15:35:29', 1, 'wine_cellars', NULL),
(265, 'Appliance Showroom', '2007-03-27 12:16:17', '2008-03-04 13:28:58', 8, 'appliance_showroom', NULL),
(266, 'Appliance Showroom1', '2007-03-27 12:19:34', '2009-05-08 15:04:11', 8, 'appliance_showroom_1', ''),
(267, 'Business Broker', '2007-04-02 14:44:15', '2007-04-02 14:44:15', 1, 'business_broker', NULL),
(269, 'Contractors - Remodel & Additions', '2007-07-26 13:07:37', '2007-07-26 13:07:37', 1, 'contractors_remodel_additions', NULL),
(270, 'Roofing - Metal', '2007-07-31 12:17:07', '2007-07-31 12:17:07', 1, 'roofing_metal', NULL),
(271, 'Demolition', '2007-08-03 16:20:00', '2007-08-03 16:20:00', 1, 'demolition', NULL),
(272, 'Excavation', '2007-08-06 12:20:07', '2007-08-06 12:20:07', 1, 'excavation', NULL),
(273, 'Gas Lines - Installation & Repair', '2007-08-07 10:07:47', '2008-03-04 15:21:52', 1, 'gas_lines_installation_repair', NULL),
(274, 'Mold Removal and Repair', '2007-08-07 16:29:01', '2008-12-17 16:42:45', 1, 'mold_water_damage_repair', ''),
(275, 'Retirement Community', '2007-08-08 15:44:44', '2009-05-08 19:38:25', 1, 'retirement_community', ''),
(276, 'Tile, Stone & Grout Cleaning (INACTIVE)', '2007-08-09 12:37:12', '2008-08-13 12:30:15', 8, 'tile_stone_grout_cleaning_inactive', NULL),
(277, 'Weddings & Events - Transportation', '2007-08-09 13:31:53', '2007-08-09 13:31:53', 1, 'weddings_events_transportation', NULL),
(278, 'Bus - Tours & Transportation', '2007-08-13 14:03:04', '2007-08-13 14:03:04', 1, 'bus_tours_transportation', NULL),
(279, 'Furniture - Outdoor', '2007-08-15 12:31:39', '2007-08-15 12:31:39', 1, 'furniture_outdoor', NULL),
(280, 'Interior Designers', '2007-08-16 10:13:54', '2007-08-16 10:13:54', 1, 'interior_designers', NULL),
(281, 'Janitorial Services', '2007-08-16 10:33:57', '2007-08-16 10:33:57', 1, 'janitorial_services', NULL),
(282, 'Stucco', '2007-08-21 12:53:35', '2007-08-21 12:53:35', 1, 'stucco', NULL),
(283, 'Windows', '2007-08-22 10:01:25', '2008-03-04 15:31:07', 8, 'windows', NULL),
(284, 'Auto Repair - Hybrid Specialist', '2007-08-22 16:17:04', '2009-05-08 10:51:58', 1, 'auto_repair_hybrid_specialist', ''),
(285, 'Bathroom - Vanities', '2007-08-23 11:24:10', '2007-08-23 11:24:10', 1, 'bathroom_vanities', NULL),
(286, 'Insurance - Commercial', '2007-08-27 13:46:57', '2007-08-27 13:46:57', 1, 'insurance_commercial', NULL),
(287, 'Insurance - Life', '2007-08-27 15:02:51', '2007-08-27 15:02:51', 1, 'insurance_life', NULL),
(288, 'Embroidery and Screen Printing', '2007-08-29 14:56:26', '2007-08-29 14:56:26', 1, 'embroidery_and_screen_printing', NULL),
(289, 'Deck Cleaning & Restoration', '2007-08-30 11:35:52', '2007-08-30 11:35:52', 1, 'deck_cleaning_restoration', NULL),
(290, 'Real Estate - Agents', '2007-09-05 12:44:43', '2007-09-05 12:44:43', 1, 'real_estate_agents', NULL),
(291, 'Water and Fire Damage Restoration', '2007-09-06 11:49:38', '2008-12-17 16:43:18', 1, 'water_damage_clean_up', ''),
(292, 'Air Quality - Indoor', '2007-09-06 16:28:32', '2007-11-07 10:27:46', 1, 'air_quality_indoor', NULL),
(294, 'Auto Body - Paintless Dent Repair', '2007-11-07 14:40:40', '2008-03-04 13:42:01', 8, 'auto_body_paintless_dent_repair_2', NULL),
(295, 'Auto Dealers - Used Sales', '2007-11-08 09:23:20', '2007-11-09 10:23:31', 1, 'auto_dealers_used_sales', NULL),
(296, 'Auto Repair - European Specialist', '2007-11-08 13:38:59', '2007-11-08 13:50:51', 1, 'auto_repair_european_specialist', NULL),
(297, 'Auto Repair - Subaru Specialist', '2007-11-08 14:50:55', '2007-11-08 14:50:55', 1, 'auto_repair_subaru_specialist', NULL),
(298, 'Children Camps - Resident and Day', '2007-11-09 12:59:34', '2008-04-14 15:11:28', 1, 'children_camps_resident_and_day', NULL),
(299, 'Contractors - Remodel and Additions', '2007-11-12 10:50:35', '2009-04-16 11:09:26', 1, 'contractors_remodel_additions_2', ''),
(300, 'Real Estate - Home Inspection', '2007-11-15 10:35:58', '2007-11-15 10:35:58', 1, 'real_estate_home_inspection', NULL),
(301, 'Recreational Vehicle Service', '2007-11-15 11:18:15', '2007-11-15 11:18:15', 1, 'recreational_vehicle_service', NULL),
(302, 'Tile, Stone & Grout Cleaning', '2007-11-16 10:12:48', '2007-11-16 10:12:48', 1, 'tile_stone_grout_cleaning', NULL),
(303, 'Building Maintenance', '2007-11-19 11:36:48', '2007-11-19 11:36:48', 1, 'building_maintenance', NULL),
(304, 'Computer - Business Enterprise Systems', '2007-11-20 08:58:00', '2007-11-20 08:58:00', 1, 'computer_business_enterprise_systems', NULL),
(305, 'Electrical Generators', '2007-11-21 09:03:42', '2007-11-21 09:03:42', 1, 'electrical_generators', NULL),
(306, 'Home Theaters & Automation', '2007-11-26 08:54:22', '2008-08-13 11:58:01', 8, 'home_theaters_automation', NULL),
(307, 'Mobility Contractor', '2007-11-26 12:52:33', '2007-11-26 12:52:33', 1, 'mobility_contractor', NULL),
(308, 'Mobility Dealer', '2007-11-26 13:01:31', '2007-11-26 13:01:31', 1, 'mobility_dealer', NULL),
(309, 'Mold and Water Damage', '2007-11-26 13:11:00', '2007-11-26 13:11:00', 1, 'mold_and_water_damage', NULL),
(310, 'Siding - Wood Shingles', '2007-11-28 08:47:57', '2008-03-04 15:30:13', 8, 'siding_wood_shingles_2', NULL),
(311, 'Skylights - Showroom & Installation', '2007-11-28 08:57:26', '2007-11-28 08:57:26', 1, 'skylights_showroom_installation', NULL),
(312, 'Swimming Pool Construction', '2007-11-28 10:25:49', '2007-11-28 10:25:49', 1, 'swimming_pool_construction', NULL),
(313, 'Windows', '2007-11-28 12:45:43', '2007-11-28 12:45:43', 1, 'windows_2', NULL),
(314, 'Dental - General & Cosmetic', '2007-12-10 09:44:01', '2009-03-31 17:07:46', 8, 'dental_general_cosmetic', ''),
(315, 'Retirement Communities', '2007-12-10 14:42:52', '2009-05-08 19:38:43', 8, 'retirement_communities', ''),
(316, 'Opticians', '2007-12-11 11:45:42', '2008-03-04 15:24:50', 1, 'opticians', NULL),
(317, 'Gas Line - Installation & Repair', '2007-12-11 12:15:51', '2008-03-04 15:21:44', 8, 'gas_line_installation_repair', NULL),
(318, 'Concrete Pumping', '2007-12-13 10:52:19', '2007-12-13 10:52:19', 1, 'concrete_pumping', NULL),
(319, 'Personal Training', '2007-12-21 15:03:38', '2007-12-21 15:03:38', 1, 'personal_training', NULL),
(320, 'Credit Card Merchant Services', '2008-01-09 11:13:39', '2008-01-09 11:13:39', 1, 'credit_card_merchant_services', NULL),
(321, 'Beauty Salons', '2008-02-06 13:36:56', '2008-02-06 13:36:56', 1, 'beauty_salons', NULL),
(322, 'Pressure Washing', '2008-02-12 11:08:26', '2008-02-12 11:08:26', 1, 'pressure_washing', NULL),
(323, 'Cement - Decorative', '2008-02-13 11:48:59', '2008-02-13 11:48:59', 1, 'cement_decorative', NULL),
(324, 'Doors', '2008-02-13 12:41:29', '2008-02-13 12:41:29', 1, 'doors', NULL),
(325, 'Asbestos Removal', '2008-02-13 13:01:30', '2008-02-13 13:01:30', 1, 'asbestos_removal', NULL),
(326, 'Security Guard Patrol', '2008-02-15 12:37:30', '2008-02-15 12:37:30', 1, 'security_guard_patrol', NULL),
(327, 'Sewer Contractor', '2008-02-20 14:51:33', '2009-06-17 12:02:32', 8, 'sewer_contractors', ''),
(328, 'Home Theater & Automation', '2008-02-21 11:04:23', '2008-02-21 11:04:23', 1, 'home_theater_automation', NULL),
(329, 'Fence Contractors - Vinyl Only', '2008-02-21 11:24:12', '2008-02-21 11:24:12', 1, 'fence_contractors_vinyl_only', NULL),
(330, 'Day Spa', '2008-02-26 12:43:28', '2009-01-29 11:28:29', 1, 'day_spa_and_pilates', ''),
(331, 'Marble & Granite Supplier', '2008-02-26 14:35:31', '2008-02-26 14:35:31', 1, 'marble_granite_supplier', NULL),
(332, 'Water Fountains & Gardens', '2008-02-27 10:15:26', '2008-02-27 10:15:26', 1, 'water_fountains_gardens', NULL),
(333, 'Ponds, Waterfalls & Gardens', '2008-03-04 10:28:30', '2008-03-13 12:39:38', 1, 'ponds_waterfalls_gardens', NULL),
(334, 'Electrical Contractors - Commercial', '2008-03-04 10:51:37', '2008-03-04 10:51:37', 1, 'electrical_contractors_commercial', NULL),
(335, 'Pilates', '2008-03-12 14:24:48', '2008-03-12 14:24:48', 1, 'pilates', NULL),
(336, 'Sewer Line Contractor', '2008-03-13 10:19:37', '2009-06-17 12:02:56', 1, 'sewer_line_contractors', ''),
(337, 'Children Entertainment - Animals', '2008-03-13 10:38:17', '2008-03-13 10:38:17', 1, 'children_entertainment_animals', NULL),
(338, 'Carpet & Upholstery Cleaning', '2008-03-13 10:59:14', '2008-03-13 10:59:14', 1, 'carpet_upholstery_cleaning', NULL),
(339, 'Water & Fire Damage Restoration', '2008-03-13 12:19:34', '2008-03-13 12:19:34', 1, 'water_fire_damage_restoration', NULL),
(340, 'Septic Services', '2008-03-13 14:39:40', '2008-03-13 14:39:40', 1, 'septic_services', NULL),
(341, 'Patio Covers', '2008-03-25 13:43:53', '2008-03-25 13:43:53', 1, 'patio_covers', NULL),
(342, 'Masonry', '2008-04-16 12:32:25', '2008-04-16 12:32:25', 1, 'masonry', NULL),
(343, 'Concrete - Overlays', '2008-06-19 14:40:34', '2008-06-19 14:40:34', 1, 'concrete_overlays', NULL),
(344, 'Landscape - Architects', '2008-07-07 16:10:36', '2010-01-15 15:48:53', 1, 'landscape_architects', ''),
(345, 'Home Lifts & Ramps', '2008-07-07 16:15:59', '2008-07-07 16:15:59', 1, 'home_lifts_ramps', NULL),
(346, 'Party & Event Venue', '2008-07-07 16:32:53', '2008-07-07 16:32:53', 1, 'party_event_venue', NULL),
(347, 'Kitchen Mobile Showrooms', '2008-07-27 20:20:46', '2008-07-27 20:20:46', 1, 'kitchen_mobile_showrooms', NULL),
(348, 'Flooring Showrooms', '2008-07-28 17:33:56', '2008-07-28 17:33:56', 1, 'flooring_showrooms', NULL),
(349, 'Air Conditioning, Heating & Ventilation (HVAC)', '2008-08-06 18:31:42', '2008-08-06 18:31:42', 1, 'air_conditioning_heating_ventilation_hvac', NULL),
(350, 'Roof Inspections', '2008-09-25 14:01:44', '2008-09-25 14:04:29', 8, 'roof_inspections', NULL),
(351, 'Real Estate - Roof Inspections', '2008-09-25 14:03:33', '2008-09-25 14:04:09', 1, 'real_estate_roof_inspections', NULL),
(352, 'Auto Detailing & Washing', '2008-11-11 09:12:08', '2008-11-11 09:12:08', 1, 'auto_detailing_washing', NULL),
(353, 'Water Treatment', '2008-11-30 21:46:40', '2008-12-17 16:37:29', 8, '', ''),
(354, 'Roofing - Commercial', '2008-12-16 12:01:14', '2008-12-16 12:01:14', 1, NULL, NULL),
(355, 'Moulding & Trim', '2008-12-17 10:42:56', '2008-12-17 10:42:56', 1, NULL, NULL),
(356, 'Landscape - Maintenance', '2008-12-17 11:06:38', '2010-01-15 15:49:18', 1, '', ''),
(357, 'Architect', '2008-12-22 15:06:48', '2009-01-29 10:53:46', 1, '', ''),
(358, 'Carpet and Upholstery Cleaning', '2008-12-24 08:57:55', '2009-04-16 11:22:42', 8, '', ''),
(359, 'Financial Planning', '2008-12-29 15:53:07', '2008-12-29 15:53:07', 1, NULL, NULL),
(360, 'Real Estate Sales - Agents', '2009-01-07 09:48:13', '2009-01-07 09:48:13', 1, NULL, NULL),
(361, 'Insurance - Auto, Home, & Life', '2009-01-07 09:56:51', '2009-01-07 09:56:51', 1, NULL, NULL),
(362, 'Bathtubs - Walk In', '2009-01-07 10:06:23', '2009-01-07 10:06:23', 1, NULL, NULL),
(363, 'Electrical Contractors - Residential', '2009-01-20 15:46:10', '2009-01-20 15:46:10', 1, NULL, NULL),
(364, 'Windows - Wood Restoration', '2009-01-27 15:18:03', '2009-01-27 15:18:03', 1, NULL, NULL),
(365, 'Kitchen & Bath - Showrooms', '2009-01-28 11:16:55', '2009-04-03 15:45:14', 1, '', ''),
(366, 'Janitorial Supplies', '2009-01-29 11:40:19', '2009-01-29 11:40:19', 1, NULL, NULL),
(367, 'Solar System Maintenance', '2009-02-18 11:25:03', '2009-02-18 11:25:03', 1, NULL, NULL),
(368, 'Flooring Installation', '2009-02-22 16:41:41', '2009-02-22 16:41:41', 1, NULL, NULL),
(369, 'Energy Conservation Contractor', '2009-02-23 12:49:59', '2009-02-23 12:49:59', 1, NULL, NULL),
(370, 'Contractor - Construction Defect Investigation', '2009-02-23 16:05:18', '2009-02-23 16:05:18', 1, NULL, NULL),
(371, 'Real Estate - Appraisals', '2009-02-25 11:39:19', '2009-02-25 11:39:19', 1, NULL, NULL),
(372, 'Appliance Repairs', '2009-02-25 15:39:31', '2009-02-25 15:39:31', 1, NULL, NULL),
(373, 'Real Estate Sales - Agent', '2009-03-19 11:05:59', '2009-03-19 11:05:59', 1, NULL, NULL),
(374, 'Marble & Granite', '2009-03-19 15:54:47', '2009-03-19 15:54:47', 1, NULL, NULL),
(375, 'Accounting Services', '2009-03-19 16:39:49', '2009-03-19 16:39:49', 1, NULL, NULL),
(376, 'Gutter Cleaning', '2009-03-23 15:19:12', '2009-03-23 15:19:12', 1, NULL, NULL),
(377, 'Paving - Asphalt & Stamping', '2009-03-24 09:41:44', '2009-03-24 09:41:44', 1, NULL, NULL),
(378, 'Recyclers - Paper', '2009-03-24 10:14:20', '2009-03-24 10:14:20', 1, NULL, NULL),
(379, 'Dryer Duct Cleaning', '2009-03-29 17:41:22', '2009-03-29 17:41:22', 1, NULL, NULL),
(380, 'Lumber - Redwood', '2009-04-05 10:09:02', '2009-04-05 10:09:02', 1, NULL, NULL),
(381, 'Garage Storage & Organizing', '2009-04-14 12:05:38', '2009-04-14 12:05:38', 1, NULL, NULL),
(382, 'Home Care', '2009-04-14 15:56:19', '2009-04-14 15:56:19', 1, NULL, NULL),
(383, 'Solar - Plumbing', '2009-04-15 09:53:47', '2009-04-15 09:53:47', 1, NULL, NULL),
(384, 'Retirement Planning', '2009-04-17 08:21:39', '2009-04-17 08:21:39', 1, NULL, NULL),
(385, 'Noise Control', '2009-04-17 12:58:13', '2009-04-17 12:58:13', 1, NULL, NULL),
(386, 'Landscapes - Ponds & Water Gardens', '2009-04-18 18:48:26', '2009-04-18 18:57:48', 1, 'landscape_ponds_watergardens', ''),
(387, 'Lighting - Low Voltage Halogen', '2009-04-20 08:55:07', '2009-04-20 08:55:07', 1, NULL, NULL),
(388, 'Hot Tubs & Spas', '2009-04-21 15:50:58', '2009-04-21 15:50:58', 1, NULL, NULL),
(389, 'Real Estate Sales - Brokers', '2009-05-08 11:48:22', '2009-05-08 11:48:22', 1, NULL, NULL),
(390, 'Pest Bird Control', '2009-05-08 19:20:01', '2009-05-08 19:20:01', 1, NULL, NULL),
(391, 'Contractor - Community Home Builders', '2009-05-20 11:05:52', '2009-05-20 11:05:52', 1, NULL, NULL),
(392, 'Home Maintenance Program', '2009-05-21 11:01:50', '2009-05-21 11:01:50', 1, NULL, NULL),
(393, 'Weddings & Events - Banquet Halls & Reception Venues', '2009-06-09 08:26:32', '2009-06-09 08:26:32', 1, NULL, NULL),
(394, 'Appliance Showrooms', '2009-06-10 08:38:41', '2009-06-10 08:38:41', 1, NULL, NULL),
(395, 'Insurance - Auto, Home & Life', '2009-06-10 13:08:51', '2009-06-10 13:08:51', 1, NULL, NULL),
(396, 'Kitchen & Bathroom - Showroom', '2009-06-10 14:05:02', '2009-06-10 14:05:02', 1, NULL, NULL),
(397, 'Massage Therapists', '2009-06-12 09:09:09', '2009-06-12 09:09:09', 1, NULL, NULL),
(398, 'Auto Broker', '2009-06-14 17:17:25', '2009-06-14 17:17:25', 1, NULL, NULL),
(399, 'Computer Networking', '2009-06-14 17:44:45', '2009-06-14 17:44:45', 1, NULL, NULL),
(400, 'Furniture - Patio & Garden', '2009-06-16 13:41:33', '2009-06-16 13:41:33', 1, NULL, NULL),
(401, 'Rug Cleaning - Restoration', '2009-06-16 22:08:17', '2009-06-16 22:08:17', 1, NULL, NULL),
(402, 'Marketing', '2009-09-17 16:06:31', '2009-09-17 16:54:49', 1, '', ''),
(403, 'Party Rental', '2009-12-11 12:45:32', '2009-12-11 12:45:32', 1, NULL, NULL);

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

--
-- Table structure for table `cities`
--

CREATE TABLE IF NOT EXISTS `cities` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `region_id` int(11) default NULL,
  `created` datetime default NULL,
  `modified` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=231 ;

--
-- Dumping data for table `cities`
--

INSERT INTO `cities` (`id`, `name`, `region_id`, `created`, `modified`) VALUES
(1, 'Annapolis', 7, '2007-03-23 10:47:22', '2007-04-05 08:30:44'),
(2, 'Bodega', 7, '2007-03-23 10:50:06', '2007-03-23 10:50:06'),
(3, 'Bodega Bay', 7, '2007-03-23 10:50:12', '2007-03-23 10:50:12'),
(4, 'Boyes Hot Springs', 7, '2007-03-23 10:50:18', '2007-03-23 10:50:18'),
(5, 'Camp Meeker', 7, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(7, 'Cazadero', 7, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(8, 'Cloverdale', 7, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(9, 'Cotati', 7, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(10, 'Duncans Mills', 7, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(11, 'El Verano', 7, '2007-03-23 10:50:24', '2007-03-23 11:59:41'),
(12, 'Eldridge', 7, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(13, 'Forestville', 7, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(14, 'Freestone', 7, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(15, 'Fulton', 7, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(16, 'Geyserville', 7, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(17, 'Glen Ellen', 7, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(18, 'Graton', 7, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(19, 'Gualala', 7, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(20, 'Guerneville', 7, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(21, 'Healdsburg', 7, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(22, 'Jenner', 7, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(23, 'Kenwood', 7, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(24, 'Monte Rio', 7, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(25, 'Occidental', 7, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(26, 'Penngrove', 7, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(27, 'Petaluma', 7, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(28, 'Rio Nido', 7, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(29, 'Rohnert Park', 7, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(30, 'Santa Rosa', 7, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(31, 'Sebastopol', 7, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(32, 'Sheridan', 7, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(33, 'Sonoma', 7, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(34, 'Stewarts Point', 7, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(35, 'The Sea Ranch', 7, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(36, 'Valley Ford', 7, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(37, 'Villa Grande', 7, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(38, 'Vineburg', 7, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(39, 'Windsor', 7, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(40, 'Alameda', 1, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(41, 'Albany', 1, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(42, 'Berkeley', 1, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(43, 'Castro Valley', 1, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(44, 'Dublin', 1, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(45, 'Emeryville', 1, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(46, 'Fremont', 1, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(47, 'Hayward', 1, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(48, 'Kensington', 1, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(49, 'Livermore', 1, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(50, 'Mount Eden', 1, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(51, 'Newark', 1, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(52, 'Oakland', 1, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(53, 'Piedmont', 1, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(54, 'Pleasanton', 1, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(55, 'San Leandro', 1, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(56, 'San Lorenzo', 1, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(57, 'Sunol', 1, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(58, 'Union City', 1, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(59, 'Alamo', 2, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(60, 'Antioch', 2, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(61, 'Bay Point', 2, '2007-03-23 10:50:24', '2007-03-23 12:00:46'),
(62, 'Bethel Island', 2, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(63, 'Brentwood', 2, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(64, 'Byron', 2, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(65, 'Canyon', 2, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(66, 'Clayton', 2, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(67, 'Concord', 2, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(68, 'Crockett', 2, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(69, 'Danville', 2, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(70, 'Diablo', 2, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(71, 'Discovery Bay', 2, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(72, 'El Cerrito', 2, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(73, 'El Sobrante', 2, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(74, 'Hercules', 2, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(75, 'Knightsen', 2, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(76, 'Lafayette', 2, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(77, 'Martinez', 2, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(78, 'Moraga', 2, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(79, 'Oakley', 2, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(80, 'Orinda', 2, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(81, 'Pacheco', 2, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(82, 'Pinole', 2, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(83, 'Pittsburg', 2, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(84, 'Pleasant Hill', 2, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(85, 'Point Richmond', 2, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(86, 'Port Costa', 2, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(87, 'Richmond', 2, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(88, 'Rodeo', 2, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(89, 'San Pablo', 2, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(90, 'San Ramon', 2, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(91, 'Walnut Creek', 2, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(92, 'Belvedere', 3, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(93, 'Bolinas', 3, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(94, 'Corte Madera', 3, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(95, 'Dillon Beach', 3, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(96, 'Fairfax', 3, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(97, 'Forest Knolls', 3, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(98, 'Greenbrae', 3, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(99, 'Ignacio', 3, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(100, 'Inverness', 3, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(101, 'Kentfield', 3, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(102, 'Lagunitas', 3, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(103, 'Larkspur', 3, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(104, 'Marshall', 3, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(105, 'Mill Valley', 3, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(106, 'Muir Beach', 3, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(107, 'Nicasio', 3, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(108, 'Novato', 3, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(109, 'Olema', 3, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(110, 'Point Reyes Station', 3, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(111, 'Ross', 3, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(112, 'San Anselmo', 3, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(113, 'San Geronimo', 3, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(114, 'San Quentin', 3, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(115, 'San Rafael', 3, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(116, 'Sausalito', 3, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(117, 'Stinson Beach', 3, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(118, 'Terra Linda', 3, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(119, 'Tiburon', 3, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(120, 'Tomales', 3, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(121, 'Woodacre', 3, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(122, 'San Francisco', 4, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(123, 'Atherton', 23, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(124, 'Belmont', 23, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(125, 'Brisbane', 23, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(126, 'Burlingame', 23, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(127, 'Colma', 23, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(128, 'Daly City', 23, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(129, 'East Palo Alto', 23, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(130, 'El Granada', 23, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(131, 'Foster City', 23, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(132, 'Half Moon Bay', 23, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(133, 'Hillsborough', 23, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(134, 'La Honda', 23, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(135, 'Loma Mar', 23, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(136, 'Menlo Park', 23, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(137, 'Millbrae', 23, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(138, 'Montara', 23, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(139, 'Moss Beach', 23, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(140, 'Pacifica', 23, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(141, 'Pescadero', 23, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(142, 'Portola Valley', 23, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(143, 'Princeton By The Sea', 23, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(144, 'Redwood City', 23, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(145, 'San Bruno', 23, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(146, 'San Carlos', 23, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(147, 'San Gregorio', 23, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(148, 'San Mateo', 23, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(149, 'South San Francisco', 23, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(150, 'West Menlo Park', 23, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(151, 'Woodside', 23, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(152, 'Alviso', 6, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(153, 'Campbell', 6, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(154, 'Coyote', 6, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(155, 'Cupertino', 6, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(156, 'Gilroy', 6, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(157, 'Los Altos', 6, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(158, 'Los Altos Hills', 6, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(159, 'Los Gatos', 6, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(160, 'Milpitas', 6, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(161, 'Monte Sereno', 6, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(162, 'Morgan Hill', 6, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(163, 'Mount Hamilton', 6, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(164, 'Mountain View', 6, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(165, 'New Almaden', 6, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(166, 'Palo Alto', 6, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(167, 'Redwood Estates', 6, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(168, 'San Jose', 6, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(169, 'San Martin', 6, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(170, 'Santa Clara', 6, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(171, 'Saratoga', 6, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(172, 'Sunnyvale', 6, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(173, 'Albion', 13, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(174, 'Anchor Bay', 13, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(175, 'Boonville', 13, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(176, 'Branscomb', 13, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(177, 'Calpella', 13, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(178, 'Caspar', 13, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(179, 'Comptche', 13, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(180, 'Covelo', 13, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(181, 'Dos Rios', 13, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(182, 'Elk', 13, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(183, 'Fort Bragg', 13, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(184, 'Hopland', 13, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(185, 'Laytonville', 13, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(186, 'Leggett', 13, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(187, 'Little River', 13, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(188, 'Manchester', 13, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(189, 'Mendocino', 13, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(190, 'Navarro', 13, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(191, 'Philo', 13, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(192, 'Piercy', 13, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(193, 'Point Arena', 13, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(194, 'Potter Valley', 13, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(195, 'Redwood Valley', 13, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(196, 'Talmage', 13, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(197, 'Ukiah', 13, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(198, 'Westport', 13, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(199, 'Willits', 13, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(200, 'Yorkville', 13, '2007-03-23 10:50:24', '2007-03-23 10:50:24'),
(202, 'Soquel', 16, '2007-11-09 13:12:17', '2007-11-09 13:12:17'),
(203, 'Vacaville', 18, '2007-12-12 14:04:32', '2007-12-12 14:04:32'),
(204, 'Santa Cruz', 16, '2007-12-20 12:45:42', '2007-12-20 12:45:42'),
(205, 'Monterey', 17, '2007-12-20 13:26:50', '2007-12-20 13:26:50'),
(206, 'Vallejo', 18, '2008-01-09 12:26:39', '2008-01-09 12:26:39'),
(207, 'Napa', 22, '2008-03-12 12:16:22', '2008-03-12 12:16:22'),
(208, 'American Canyon', 22, '2008-04-18 10:55:44', '2008-04-18 10:55:44'),
(209, 'Pacific Grove', 17, '2008-05-06 11:58:37', '2008-05-06 11:58:37'),
(210, 'Fairfield', 18, '2008-05-06 13:29:52', '2008-05-06 13:29:52'),
(211, 'Freedom', 16, '2008-05-21 13:26:00', '2008-05-21 13:26:00'),
(212, 'Benicia', 18, '2008-07-23 13:48:02', '2008-07-23 13:49:27'),
(213, 'Seaside', 17, '2008-09-29 20:31:19', '2008-09-29 20:31:19'),
(214, 'Rancho Cordova', 18, '2008-10-10 21:56:48', '2008-10-10 21:56:48'),
(215, 'Salinas', 17, '2008-11-05 16:24:24', '2008-11-05 16:24:24'),
(216, 'Sand City', 17, '2008-11-20 15:30:14', '2008-11-20 15:32:24'),
(217, 'Carmel', 17, '2008-11-26 11:01:03', '2008-11-26 11:01:03'),
(218, 'Marina', 17, '2009-01-26 12:55:17', '2009-01-26 12:55:17'),
(219, 'Moorpark', 20, '2009-02-08 15:51:11', '2009-02-08 15:51:11'),
(220, 'Oceanside', 1, '2009-02-08 15:53:01', '2009-02-08 15:53:01'),
(221, 'St. Helena', 7, '2009-02-11 08:34:02', '2009-02-11 08:34:02'),
(222, 'Yountville', 7, '2009-02-11 08:36:01', '2009-02-11 08:36:01'),
(223, 'Felton', 16, '2009-02-25 11:24:44', '2009-02-25 11:24:44'),
(224, 'Santa Clara County', 6, '2009-04-28 08:39:52', '2009-04-28 08:39:52'),
(225, 'Contra Costa', 2, '2009-04-28 08:48:02', '2009-04-28 08:48:02'),
(226, 'San Benito', 17, '2009-04-28 08:49:14', '2009-04-28 08:49:14'),
(227, 'Marin', 3, '2009-04-28 08:49:22', '2009-04-28 08:49:22'),
(228, 'Silicon Valley', 6, '2009-04-30 14:17:26', '2009-04-30 14:17:26'),
(229, 'Yorba Linda', 20, '2009-10-14 14:20:44', '2009-10-14 14:20:44'),
(230, 'Middletown', 7, '2009-11-21 22:36:17', '2009-11-21 22:36:17');

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

--
-- Table structure for table `regions`
--

CREATE TABLE IF NOT EXISTS `regions` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) default NULL,
  `abbreviation_1` varchar(10) default NULL,
  `abbreviation_2` varchar(255) default NULL,
  `created` datetime default NULL,
  `modified` datetime default NULL,
  `status_id` int(11) NOT NULL default '1',
  `alias` varchar(255) default NULL,
  PRIMARY KEY  (`id`),
  KEY `alias` (`alias`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=24 ;

--
-- Dumping data for table `regions`
--

INSERT INTO `regions` (`id`, `title`, `abbreviation_1`, `abbreviation_2`, `created`, `modified`, `status_id`, `alias`) VALUES
(1, 'Alameda County', 'al', 'alameda', '2006-11-17 15:06:46', '2010-01-15 15:50:18', 1, 'alameda'),
(2, 'Contra Costa County', 'cc', 'contracosta', '2006-11-17 15:07:05', '2010-01-15 15:51:36', 1, 'contra_costa'),
(3, 'Marin County', 'mc', 'marin', '2006-11-17 15:07:20', '2010-01-18 19:06:49', 1, 'marin'),
(4, 'San Francisco', 'sf', 'sanfrancisco', '2006-11-17 15:07:37', '2010-01-21 16:11:36', 1, 'san_francisco'),
(23, 'San Mateo County', 'sm', 'sanmateo', '2008-04-15 14:52:46', '2010-01-15 15:57:27', 1, 'san_mateo'),
(6, 'Santa Clara County', 'sc', 'santaclara', '2006-11-17 15:08:35', '2010-01-15 15:53:55', 1, 'santa_clara'),
(7, 'Sonoma County', 'so', 'sonoma', '2006-11-17 15:08:51', '2010-01-20 12:36:06', 1, 'sonoma'),
(13, 'Mendocino County', 'me', 'mendocino', '2007-03-19 15:26:46', '2008-11-12 12:00:00', 8, 'mendocino'),
(16, 'Santa Cruz County', 'sa', 'santacruz', '2007-11-09 13:11:48', '2010-01-15 15:55:36', 1, 'santa_cruz'),
(17, 'Monterey & San Benito Counties', 'mo', 'montereysanbenito', '2007-12-10 08:27:55', '2010-01-15 15:56:04', 1, 'monterey_san_benito'),
(18, 'Solano County', 'sl', 'solano', '2007-12-12 14:02:37', '2010-01-15 15:56:25', 1, 'solano'),
(19, 'Orange County', 'or', 'orange', '2007-12-13 13:37:11', '2009-10-14 12:58:10', 1, 'orange'),
(20, 'Other Counties', 'ot', 'other', '2008-02-12 10:19:20', '2009-10-14 12:58:52', 1, 'other'),
(21, 'San Joaquin County', 'sq', 'sanjoaquin', '2008-02-12 10:20:31', '2009-07-28 09:49:13', 8, 'san_joaquin'),
(22, 'Napa', 'na', 'napa', '2008-03-12 12:16:08', '2009-09-29 14:42:32', 1, 'napa');

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

--
-- Table structure for table `statuses`
--

CREATE TABLE IF NOT EXISTS `statuses` (
  `id` int(10) NOT NULL auto_increment,
  `title` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `statuses`
--

INSERT INTO `statuses` (`id`, `title`) VALUES
(8, 'Inactive'),
(1, 'Active');