-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `adgen`
--

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

--
-- Table structure for table `ad_drafts`
--

CREATE TABLE `ad_drafts` (
  `id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) UNSIGNED DEFAULT NULL,
  `campaign_id` int(11) UNSIGNED DEFAULT NULL,
  `lead_id` int(11) UNSIGNED NOT NULL,
  `platform` enum('facebook','google','instagram','linkedin','twitter') NOT NULL,
  `strategy` varchar(255) DEFAULT NULL,
  `ad_type` enum('text','image','video','carousel') NOT NULL DEFAULT 'text',
  `headline` varchar(255) DEFAULT NULL,
  `content` text DEFAULT NULL,
  `cta` varchar(100) DEFAULT NULL,
  `strategy_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`strategy_data`)),
  `audience_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`audience_data`)),
  `performance_metrics` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`performance_metrics`)),
  `status` enum('draft','active','paused','completed') DEFAULT 'draft',
  `copy` text DEFAULT NULL,
  `image_url` varchar(500) DEFAULT NULL,
  `settings` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`settings`)),
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ad_drafts`
--

INSERT INTO `ad_drafts` (`id`, `user_id`, `campaign_id`, `lead_id`, `platform`, `strategy`, `ad_type`, `headline`, `content`, `cta`, `strategy_data`, `audience_data`, `performance_metrics`, `status`, `copy`, `image_url`, `settings`, `created_at`, `updated_at`) VALUES
(2, 1, 2, 4, 'facebook', NULL, 'text', '\r\n                        Get Fit with 305 Fitness - Free Trial Offer in New York, NY!                    ', '\r\n                        Experience the energy of 305 Fitness! Sign up for a free trial and dance your way to fitness in the heart of New York City. Our high-energy classes will have you sweating and smiling in no time. Limited time offer - claim your free trial now!                    ', '\r\n                            Learn More                        ', '{\"name\":\"Lead Generation Campaign\",\"type\":\"lead_generation\",\"description\":\"Offer a free trial or discount for new members. Target audience: Individuals in the local area interested in dance fitness classes.\",\"icon\":\"\\ud83d\\udcca\",\"objective\":\"Lead Generation\",\"recommended_budget\":{\"min\":400,\"max\":800,\"suggested\":600},\"duration_days\":14,\"key_features\":[\"Lead ads with sign-up forms\",\"Retargeting based on engagement\",\"Local awareness targeting\"],\"ai_reasoning\":\"Providing a free trial or discount incentivizes potential customers to take action, while local targeting ensures higher relevance and conversion rates.\",\"id\":\"strategy_68aee09249501\",\"estimated_performance\":{\"estimated_reach\":50000,\"estimated_impressions\":160000,\"estimated_clicks\":2304,\"estimated_leads\":92,\"cost_per_click\":0.26,\"cost_per_lead\":6.52,\"duration_days\":14}}', '[]', NULL, 'draft', '\r\n                        Get Fit with 305 Fitness - Free Trial Offer in New York, NY!                    \n\n\r\n                        Experience the energy of 305 Fitness! Sign up for a free trial and dance your way to fitness in the heart of New York City. Our high-energy classes will have you sweating and smiling in no time. Limited time offer - claim your free trial now!                    \n\nCTA: \r\n                            Learn More                        ', NULL, NULL, '2025-08-27 10:40:44', '2025-08-27 10:40:44'),
(4, 1, 1, 3, 'google', 'keyword_targeting', 'text', 'Professional Services in New York', 'Get quality services from Astor Smile Dental. Target keywords: pediatric dentist near me. Contact us today for a free consultation!', 'Get Quote', '{\"selected_keywords\":[{\"keyword\":\"pediatric dentist near me\",\"volume\":3500,\"intent\":75,\"competition\":\"medium\"}],\"target_location\":\"New York, NY\",\"business_type\":\"general\"}', NULL, NULL, 'draft', 'pediatric dentist near me', NULL, '{\"keyword_match_type\":\"broad\",\"daily_budget\":50,\"bid_strategy\":\"maximize_clicks\"}', '2025-08-28 05:27:42', '2025-08-28 05:27:42'),
(8, 1, 1, 3, 'google', 'keyword_targeting', 'text', 'Professional Services in New York', 'Get quality services from Astor Smile Dental. Target keywords: Astor Smile Dental prices. Contact us today for a free consultation!', 'Get Quote', '{\"selected_keywords\":[{\"keyword\":\"Astor Smile Dental prices\",\"volume\":80,\"intent\":70,\"competition\":\"low\"}],\"target_location\":\"New York, NY\",\"business_type\":\"general\"}', NULL, NULL, 'draft', 'Astor Smile Dental prices', NULL, '{\"keyword_match_type\":\"broad\",\"daily_budget\":50,\"bid_strategy\":\"maximize_clicks\"}', '2025-08-28 13:05:11', '2025-08-28 13:05:11'),
(9, 1, 1, 12, 'facebook', NULL, 'text', '\r\n                        Indulge in Authentic Italian Cuisine at Olio e Più, New York\'s Culinary Gem!                    ', '\r\n                        Calling all Food Enthusiasts! Immerse yourself in a culinary journey like no other at Olio e Più. From our handcrafted pasta to savory antipasti, every dish is a masterpiece of flavors. Join us for a sensory experience that transports you to the heart of Italy. Claim your exclusive offer today and savor the taste of true Italian tradition in the heart of New York City.                    ', '\r\n                            Learn More                        ', '{\"name\":\"Food Enthusiasts Engagement\",\"type\":\"lead_generation\",\"description\":\"Target food enthusiasts and culinary aficionados with engaging content, recipes, behind-the-scenes footage, and exclusive offers to capture leads.\",\"icon\":\"\\ud83d\\udcca\",\"objective\":\"Lead Generation\",\"recommended_budget\":{\"min\":400,\"max\":600,\"suggested\":500},\"duration_days\":21,\"key_features\":[\"Interest Targeting: Food & Dining\",\"Interactive Content\",\"Lead Generation Forms\"],\"ai_reasoning\":\"Targeting food enthusiasts ensures reaching an audience already interested in culinary experiences, increasing the likelihood of lead generation and conversions.\",\"id\":\"strategy_68b15184d55d4\",\"estimated_performance\":{\"estimated_reach\":50000,\"estimated_impressions\":160000,\"estimated_clicks\":2304,\"estimated_leads\":92,\"cost_per_click\":0.22,\"cost_per_lead\":5.43,\"duration_days\":21}}', '[]', NULL, 'draft', '\r\n                        Indulge in Authentic Italian Cuisine at Olio e Più, New York\'s Culinary Gem!                    \n\n\r\n                        Calling all Food Enthusiasts! Immerse yourself in a culinary journey like no other at Olio e Più. From our handcrafted pasta to savory antipasti, every dish is a masterpiece of flavors. Join us for a sensory experience that transports you to the heart of Italy. Claim your exclusive offer today and savor the taste of true Italian tradition in the heart of New York City.                    \n\nCTA: \r\n                            Learn More                        ', NULL, NULL, '2025-08-29 07:07:11', '2025-08-29 07:07:11'),
(10, 1, 7, 13, 'facebook', NULL, 'text', '\r\n                        Family Dental Care in Ukiah, CA - Book Your Free Consultation Now!                    ', '\r\n                        Dr. Steven R Boettger DDS is your trusted family dentist in Ukiah, CA, providing top-quality dental services for all ages. Book now to avail of our exclusive family discount and experience expert care for your loved ones. From routine check-ups to orthodontics, we\'ve got your family covered. Don\'t miss out on this limited-time offer - prioritize your family\'s oral health today!                    ', '\r\n                            Learn More                        ', '{\"name\":\"Dental Service Promotion for Families\",\"type\":\"lead_generation\",\"description\":\"Target parents aged 25-45 with children in the specified location. Offer a family discount or free initial consultation. Use carousel ads to showcase various dental services for the whole family.\",\"icon\":\"\\ud83d\\udcca\",\"objective\":\"Lead Generation\",\"recommended_budget\":{\"min\":350,\"max\":600,\"suggested\":500},\"duration_days\":28,\"key_features\":[\"Demographic Targeting\",\"Promotional Offer\",\"Carousel Ads\"],\"ai_reasoning\":\"By targeting parents with children, this strategy taps into a key demographic likely to seek dental services for the entire family, increasing lead generation potential.\",\"id\":\"strategy_68b19ef9d2de2\",\"estimated_performance\":{\"estimated_reach\":50000,\"estimated_impressions\":160000,\"estimated_clicks\":2304,\"estimated_leads\":92,\"cost_per_click\":0.22,\"cost_per_lead\":5.43,\"duration_days\":28}}', '[]', NULL, 'draft', '\r\n                        Family Dental Care in Ukiah, CA - Book Your Free Consultation Now!                    \n\n\r\n                        Dr. Steven R Boettger DDS is your trusted family dentist in Ukiah, CA, providing top-quality dental services for all ages. Book now to avail of our exclusive family discount and experience expert care for your loved ones. From routine check-ups to orthodontics, we\'ve got your family covered. Don\'t miss out on this limited-time offer - prioritize your family\'s oral health today!                    \n\nCTA: \r\n                            Learn More                        ', NULL, NULL, '2025-08-29 12:39:16', '2025-08-29 12:39:16'),
(12, 1, 12, 17, 'facebook', NULL, 'text', '\r\n                        Discover Holistic Healing with Thrive Acupuncture in New York                    ', '\r\n                        Unlock the power of ancient healing practices at Thrive Acupuncture. Specializing in personalized treatments for pain relief, stress management, and overall wellness. Our expert acupuncturists ensure a comfortable, calming experience. Book now and start your journey to optimal health!                    ', '\r\n                            Learn More                        ', '{\"name\":\"Interest Targeting for Wellness Enthusiasts\",\"type\":\"lead_generation\",\"description\":\"Target audiences interested in wellness, holistic health, acupuncture, and alternative medicine to generate leads for Thrive Acupuncture.\",\"icon\":\"\\ud83d\\udcca\",\"objective\":\"Lead Generation\",\"recommended_budget\":{\"min\":300,\"max\":700,\"suggested\":500},\"duration_days\":21,\"key_features\":[\"Interest Targeting\",\"Lead Form Ads\",\"Custom Audiences\"],\"ai_reasoning\":\"Interest targeting allows Thrive Acupuncture to reach a relevant audience interested in healthcare alternatives, increasing the likelihood of lead generation.\",\"id\":\"strategy_68b589c4bc152\",\"estimated_performance\":{\"estimated_reach\":50000,\"estimated_impressions\":160000,\"estimated_clicks\":2304,\"estimated_leads\":92,\"cost_per_click\":0.22,\"cost_per_lead\":5.43,\"duration_days\":21}}', '[]', NULL, 'draft', '\r\n                        Discover Holistic Healing with Thrive Acupuncture in New York                    \n\n\r\n                        Unlock the power of ancient healing practices at Thrive Acupuncture. Specializing in personalized treatments for pain relief, stress management, and overall wellness. Our expert acupuncturists ensure a comfortable, calming experience. Book now and start your journey to optimal health!                    \n\nCTA: \r\n                            Learn More                        ', NULL, NULL, '2025-09-01 11:56:17', '2025-09-01 11:56:17'),
(13, 1, 14, 19, 'google', 'keyword_targeting', 'text', 'Professional Restaurant in New York', 'Get quality restaurant from Ye\'s Apothecary 夜莺. Target keywords: top-rated dim sum in New York. Contact us today for a free consultation!', 'Get Quote', '{\"selected_keywords\":[{\"keyword\":\"top-rated dim sum in New York\",\"volume\":5000,\"intent\":88,\"competition\":\"medium\"}],\"target_location\":\"New York, NY\",\"business_type\":\"Restaurant\"}', NULL, NULL, 'draft', 'top-rated dim sum in New York', NULL, '{\"keyword_match_type\":\"broad\",\"daily_budget\":50,\"bid_strategy\":\"maximize_clicks\"}', '2025-09-01 12:53:55', '2025-09-01 12:53:55'),
(14, 1, 16, 22, 'facebook', NULL, 'image', '\r\n                        Savor Our Chef\'s Creations                    ', '\r\n                        Indulge in exquisite flavors & culinary artistry. Book your table now!                    ', '\r\n                            Book Now                        ', '{\"name\":\"Food Enthusiasts\",\"type\":\"conversion\",\"description\":\"Create Facebook ads targeting food enthusiasts, such as food bloggers, critics, and influencers. Showcase signature dishes, chef profiles, and customer testimonials to drive conversions.\",\"icon\":\"\\ud83d\\udcca\",\"objective\":\"Conversions\",\"recommended_budget\":{\"min\":400,\"max\":900,\"suggested\":650},\"duration_days\":21,\"key_features\":[\"Interest targeting\",\"Influencer partnerships\",\"Social proof\"],\"ai_reasoning\":\"Targeting food enthusiasts ensures reaching a highly engaged audience with a strong interest in culinary experiences, leading to higher conversion rates.\",\"id\":\"strategy_68b6eb7f9ecb9\",\"estimated_performance\":{\"estimated_reach\":40000,\"estimated_impressions\":128000,\"estimated_clicks\":1536,\"estimated_leads\":115,\"cost_per_click\":0.42,\"cost_per_lead\":5.65,\"duration_days\":21}}', '[]', NULL, 'draft', '\r\n                        Savor Our Chef\'s Creations                    \n\n\r\n                        Indulge in exquisite flavors & culinary artistry. Book your table now!                    \n\nCTA: \r\n                            Book Now                        ', NULL, NULL, '2025-09-02 13:08:01', '2025-09-02 13:08:01'),
(15, 1, 17, 25, 'facebook', NULL, 'text', '\r\n                        Join Just Train\'s Local Community Events & Classes in New York, NY!                    ', '\r\n                        Discover a vibrant fitness community at Just Train in New York, NY. Engage with our exclusive local events, dynamic classes, and unrivaled membership benefits. Hear from our members about their transformational journeys. Limited-time offer: Sign up now and receive a special local discount! Your fitness journey starts here at Just Train.                    ', '\r\n                            Learn More                        ', '{\"name\":\"Local Community Engagement\",\"type\":\"awareness\",\"description\":\"Run a campaign targeting local residents within a 10-mile radius of the gym location, promoting Just Train\'s community events, classes, and membership benefits.\",\"icon\":\"\\ud83d\\udcca\",\"objective\":\"Brand Awareness\",\"recommended_budget\":{\"min\":300,\"max\":600,\"suggested\":450},\"duration_days\":21,\"key_features\":[\"Local event promotion\",\"Member testimonials\",\"Exclusive local offers\"],\"ai_reasoning\":\"Localized targeting helps create a sense of community and trust. Promoting events and benefits increases brand awareness.\",\"id\":\"strategy_68b7d6d5a11d6\",\"estimated_performance\":{\"estimated_reach\":75000,\"estimated_impressions\":240000,\"estimated_clicks\":2304,\"estimated_leads\":34,\"cost_per_click\":0.2,\"cost_per_lead\":13.24,\"duration_days\":21}}', '[]', NULL, 'draft', '\r\n                        Join Just Train\'s Local Community Events & Classes in New York, NY!                    \n\n\r\n                        Discover a vibrant fitness community at Just Train in New York, NY. Engage with our exclusive local events, dynamic classes, and unrivaled membership benefits. Hear from our members about their transformational journeys. Limited-time offer: Sign up now and receive a special local discount! Your fitness journey starts here at Just Train.                    \n\nCTA: \r\n                            Learn More                        ', NULL, NULL, '2025-09-03 05:49:29', '2025-09-03 05:49:29');

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

--
-- Table structure for table `audit_logs`
--

CREATE TABLE `audit_logs` (
  `id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) UNSIGNED DEFAULT NULL,
  `action` varchar(50) NOT NULL,
  `data` text DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` varchar(500) DEFAULT NULL,
  `table_name` varchar(100) NOT NULL,
  `record_id` int(11) UNSIGNED DEFAULT NULL,
  `old_values` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`old_values`)),
  `new_values` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`new_values`)),
  `created_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `audit_logs`
--

INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `data`, `ip_address`, `user_agent`, `table_name`, `record_id`, `old_values`, `new_values`, `created_at`) VALUES
(1, NULL, 'campaign.duplicated', '{\"campaign_id\":4,\"original_campaign_id\":2,\"original_campaign_name\":\"Test 2\",\"new_campaign_name\":\"Copy of Test 2\",\"copied_leads\":1,\"copied_ad_drafts\":1,\"copied_keywords\":0}', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', '', NULL, NULL, NULL, '2025-08-28 06:41:54'),
(2, NULL, 'campaign.duplicated', '{\"campaign_id\":5,\"original_campaign_id\":2,\"original_campaign_name\":\"Test 2\",\"new_campaign_name\":\"Copy of Test 2\",\"copied_leads\":1,\"copied_ad_drafts\":1,\"copied_keywords\":0}', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', '', NULL, NULL, NULL, '2025-08-28 06:52:23'),
(3, NULL, 'campaign.duplicated', '{\"campaign_id\":6,\"original_campaign_id\":2,\"original_campaign_name\":\"Test 2\",\"new_campaign_name\":\"Copy of Test 2\",\"copied_leads\":1,\"copied_ad_drafts\":1,\"copied_keywords\":0}', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', '', NULL, NULL, NULL, '2025-08-28 07:02:25'),
(4, NULL, 'campaign.duplicated', '{\"campaign_id\":8,\"original_campaign_id\":7,\"original_campaign_name\":\"Test 3\",\"new_campaign_name\":\"Copy of Test 3\",\"copied_leads\":2,\"copied_ad_drafts\":1,\"copied_keywords\":0}', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', '', NULL, NULL, NULL, '2025-09-01 09:48:16');

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

--
-- Table structure for table `campaigns`
--

CREATE TABLE `campaigns` (
  `id` int(11) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `image` varchar(500) DEFAULT NULL,
  `owner_id` int(11) UNSIGNED NOT NULL,
  `status` enum('active','inactive','archived','draft','paused') DEFAULT 'draft',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `campaigns`
--

INSERT INTO `campaigns` (`id`, `name`, `image`, `owner_id`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Test1', NULL, 1, 'inactive', '2025-08-26 07:16:40', '2025-08-26 07:16:40'),
(2, 'Test 2', NULL, 1, 'active', '2025-08-26 12:32:28', '2025-08-26 12:32:28'),
(7, 'Test 3', NULL, 1, 'active', '2025-08-29 12:10:16', '2025-08-29 12:10:16'),
(12, 'Test 7', NULL, 1, 'draft', '2025-09-01 10:50:33', '2025-09-01 11:06:31'),
(14, 'Demo Test', NULL, 1, 'active', '2025-09-01 12:52:57', '2025-09-01 12:52:57'),
(16, 'QA Test Campaign 2025', NULL, 1, 'draft', '2025-09-02 12:59:20', '2025-09-02 12:59:20'),
(17, 'QA Testing Campaign 2025', NULL, 1, 'draft', '2025-09-02 13:16:05', '2025-09-02 13:16:05'),
(18, 'Phase 2 Testing Campaign - Core Features Validation', NULL, 1, 'draft', '2025-09-03 07:05:29', '2025-09-03 07:05:29');

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

--
-- Table structure for table `keywords`
--

CREATE TABLE `keywords` (
  `id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL,
  `lead_id` int(11) UNSIGNED DEFAULT NULL,
  `campaign_id` int(11) UNSIGNED DEFAULT NULL,
  `seed_keyword` varchar(255) NOT NULL,
  `keyword` varchar(255) NOT NULL,
  `volume` int(11) NOT NULL DEFAULT 0,
  `intent` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Commercial intent percentage 0-100',
  `competition` enum('low','medium','high') NOT NULL DEFAULT 'medium',
  `status` enum('generated','selected','used') NOT NULL DEFAULT 'generated',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `keywords`
--

INSERT INTO `keywords` (`id`, `user_id`, `lead_id`, `campaign_id`, `seed_keyword`, `keyword`, `volume`, `intent`, `competition`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 3, NULL, 'dentist', 'dentist in New York', 5000, 90, 'high', 'generated', '2025-08-27 11:43:44', '2025-08-27 11:43:44'),
(2, 1, 3, NULL, 'dentist', 'best dental clinic NYC', 800, 95, 'medium', 'generated', '2025-08-27 11:43:44', '2025-08-27 11:43:44'),
(3, 1, 3, NULL, 'dentist', 'emergency dentist near me', 2500, 80, 'high', 'generated', '2025-08-27 11:43:44', '2025-08-27 11:43:44'),
(4, 1, 3, NULL, 'dentist', 'cosmetic dentistry New York', 1500, 85, 'medium', 'generated', '2025-08-27 11:43:44', '2025-08-27 11:43:44'),
(5, 1, 3, NULL, 'dentist', 'affordable dental care in NY', 700, 75, 'low', 'generated', '2025-08-27 11:43:44', '2025-08-27 11:43:44'),
(6, 1, 3, NULL, 'dentist', 'teeth whitening services', 3000, 90, 'high', 'selected', '2025-08-27 11:43:44', '2025-08-28 05:27:42'),
(7, 1, 3, NULL, 'dentist', 'pediatric dentist Upper East Side', 400, 80, 'low', 'generated', '2025-08-27 11:43:44', '2025-08-27 11:43:44'),
(8, 1, 3, NULL, 'dentist', 'orthodontist Manhattan', 1000, 85, 'medium', 'generated', '2025-08-27 11:43:44', '2025-08-27 11:43:44'),
(9, 1, 3, NULL, 'dentist', 'dental implants cost NYC', 1200, 90, 'high', 'generated', '2025-08-27 11:43:44', '2025-08-27 11:43:44'),
(10, 1, 3, NULL, 'dentist', 'root canal specialist in New York', 600, 80, 'low', 'generated', '2025-08-27 11:43:44', '2025-08-27 11:43:44'),
(11, 1, 3, NULL, 'dentist', 'emergency tooth extraction NYC', 300, 75, 'low', 'generated', '2025-08-27 11:43:44', '2025-08-27 11:43:44'),
(12, 1, 3, NULL, 'dentist', 'invisalign provider in NY', 800, 85, 'medium', 'generated', '2025-08-27 11:43:44', '2025-08-27 11:43:44'),
(13, 1, 3, NULL, 'dentist', 'dental check-up Midtown', 500, 80, 'low', 'selected', '2025-08-27 11:43:44', '2025-08-27 12:56:36'),
(14, 1, 3, NULL, 'dentist', 'oral surgeon New York', 700, 85, 'medium', 'generated', '2025-08-27 11:43:44', '2025-08-27 11:43:44'),
(15, 1, 3, NULL, 'dentist', 'affordable braces in NYC', 400, 80, 'low', 'generated', '2025-08-27 11:43:44', '2025-08-27 11:43:44'),
(16, 1, 3, NULL, 'dentist', 'cosmetic dental veneers NY', 600, 85, 'medium', 'generated', '2025-08-27 11:43:44', '2025-08-27 11:43:44'),
(17, 1, 3, NULL, 'dentist', 'TMJ specialist Manhattan', 300, 75, 'low', 'selected', '2025-08-27 11:43:44', '2025-08-28 13:05:11'),
(18, 1, 3, NULL, 'dentist', 'emergency dental care New York', 800, 90, 'high', 'generated', '2025-08-27 11:43:44', '2025-08-27 11:43:44'),
(19, 1, 3, NULL, 'dentist', 'sedation dentistry NYC', 500, 85, 'medium', 'generated', '2025-08-27 11:43:44', '2025-08-27 11:43:44'),
(20, 1, 3, NULL, 'dentist', 'implant-supported dentures NY', 200, 75, 'low', 'generated', '2025-08-27 11:43:44', '2025-08-27 11:43:44'),
(21, 1, 3, NULL, 'dentist', 'best dentist in New York', 8000, 90, 'high', 'generated', '2025-08-27 12:47:45', '2025-08-27 12:47:45'),
(22, 1, 3, NULL, 'dentist', 'emergency dental care NYC', 1500, 80, 'medium', 'generated', '2025-08-27 12:47:45', '2025-08-27 12:47:45'),
(23, 1, 3, NULL, 'dentist', 'affordable dental clinic near me', 3000, 70, 'medium', 'generated', '2025-08-27 12:47:45', '2025-08-27 12:47:45'),
(24, 1, 3, NULL, 'dentist', 'cosmetic dentistry Astor Smile Dental', 500, 70, 'low', 'generated', '2025-08-27 12:47:45', '2025-08-27 12:47:45'),
(25, 1, 3, NULL, 'dentist', 'teeth whitening services in NY', 2000, 75, 'medium', 'generated', '2025-08-27 12:47:45', '2025-08-27 12:47:45'),
(26, 1, 3, NULL, 'dentist', 'pediatric dentist New York', 1000, 80, 'high', 'generated', '2025-08-27 12:47:45', '2025-08-27 12:47:45'),
(27, 1, 3, NULL, 'dentist', 'root canal specialist NYC', 600, 75, 'low', 'generated', '2025-08-27 12:47:45', '2025-08-27 12:47:45'),
(28, 1, 3, NULL, 'dentist', 'dental implants Astor Smile Dental', 700, 85, 'medium', 'generated', '2025-08-27 12:47:45', '2025-08-27 12:47:45'),
(29, 1, 3, NULL, 'dentist', 'orthodontist in Manhattan', 1200, 75, 'high', 'generated', '2025-08-27 12:47:45', '2025-08-27 12:47:45'),
(30, 1, 3, NULL, 'dentist', 'invisalign braces New York', 2500, 85, 'high', 'generated', '2025-08-27 12:47:45', '2025-08-27 12:47:45'),
(31, 1, 3, NULL, 'dentist', 'oral surgeon Astor Smile Dental', 300, 70, 'low', 'generated', '2025-08-27 12:47:45', '2025-08-27 12:47:45'),
(32, 1, 3, NULL, 'dentist', 'dental check-up near me', 3500, 75, 'medium', 'generated', '2025-08-27 12:47:45', '2025-08-27 12:47:45'),
(33, 1, 3, NULL, 'dentist', 'emergency dentist in Brooklyn', 900, 80, 'medium', 'generated', '2025-08-27 12:47:45', '2025-08-27 12:47:45'),
(34, 1, 3, NULL, 'dentist', 'cosmetic dentistry NYC', 1800, 80, 'high', 'generated', '2025-08-27 12:47:45', '2025-08-27 12:47:45'),
(35, 1, 3, NULL, 'dentist', 'teeth cleaning services in Manhattan', 1000, 70, 'low', 'generated', '2025-08-27 12:47:45', '2025-08-27 12:47:45'),
(36, 1, 3, NULL, 'dentist', 'sedation dentistry Astor Smile Dental', 400, 75, 'low', 'generated', '2025-08-27 12:47:45', '2025-08-27 12:47:45'),
(37, 1, 3, NULL, 'dentist', 'affordable braces in Queens', 700, 85, 'medium', 'generated', '2025-08-27 12:47:45', '2025-08-27 12:47:45'),
(38, 1, 3, NULL, 'dentist', 'periodontist in New York', 800, 75, 'high', 'generated', '2025-08-27 12:47:45', '2025-08-27 12:47:45'),
(39, 1, 3, NULL, 'dentist', 'cosmetic dental veneers Astor Smile Dental', 300, 70, 'low', 'generated', '2025-08-27 12:47:45', '2025-08-27 12:47:45'),
(40, 1, 3, NULL, 'dentist', 'cosmetic dentist NYC', 3000, 90, 'high', 'generated', '2025-08-27 12:48:14', '2025-08-27 12:48:14'),
(41, 1, 3, NULL, 'dentist', 'teeth whitening specialist in NY', 500, 85, 'high', 'generated', '2025-08-27 12:48:14', '2025-08-27 12:48:14'),
(42, 1, 3, NULL, 'dentist', 'affordable dental implants in NYC', 700, 95, 'high', 'generated', '2025-08-27 12:48:14', '2025-08-27 12:48:14'),
(43, 1, 3, NULL, 'dentist', 'pediatric dentist near me', 1000, 70, 'medium', 'generated', '2025-08-27 12:48:14', '2025-08-27 12:48:14'),
(44, 1, 3, NULL, 'dentist', 'Invisalign provider New York', 400, 80, 'medium', 'generated', '2025-08-27 12:48:14', '2025-08-27 12:48:14'),
(45, 1, 3, NULL, 'dentist', 'root canal specialist in Manhattan', 300, 75, 'low', 'generated', '2025-08-27 12:48:14', '2025-08-27 12:48:14'),
(46, 1, 3, NULL, 'dentist', 'dental crowns NYC cost', 600, 85, 'high', 'generated', '2025-08-27 12:48:14', '2025-08-27 12:48:14'),
(47, 1, 3, NULL, 'dentist', 'best orthodontist in Brooklyn', 900, 90, 'high', 'generated', '2025-08-27 12:48:14', '2025-08-27 12:48:14'),
(48, 1, 3, NULL, 'dentist', 'sedation dentistry Upper East Side', 200, 70, 'low', 'generated', '2025-08-27 12:48:14', '2025-08-27 12:48:14'),
(49, 1, 3, NULL, 'dentist', 'teeth cleaning service in Queens', 400, 80, 'medium', 'generated', '2025-08-27 12:48:14', '2025-08-27 12:48:14'),
(50, 1, 3, NULL, 'dentist', 'dental check-up Midtown Manhattan', 250, 75, 'low', 'generated', '2025-08-27 12:48:14', '2025-08-27 12:48:14'),
(51, 1, 3, NULL, 'dentist', 'cosmetic dentistry near Central Park', 150, 70, 'low', 'generated', '2025-08-27 12:48:14', '2025-08-27 12:48:14'),
(52, 1, 3, NULL, 'dentist', 'emergency tooth extraction in Harlem', 100, 75, 'low', 'generated', '2025-08-27 12:48:14', '2025-08-27 12:48:14'),
(53, 1, 3, NULL, 'dentist', 'affordable braces in Staten Island', 300, 80, 'medium', 'generated', '2025-08-27 12:48:14', '2025-08-27 12:48:14'),
(54, 1, 3, NULL, 'dentist', 'dental implants specialist in Bronx', 200, 85, 'high', 'generated', '2025-08-27 12:48:14', '2025-08-27 12:48:14'),
(55, 1, 3, NULL, 'dentist', 'TMJ treatment in Westchester', 150, 70, 'low', 'generated', '2025-08-27 12:48:14', '2025-08-27 12:48:14'),
(56, 1, 3, NULL, 'dentist', 'emergency dentist near Times Square', 500, 85, 'high', 'generated', '2025-08-27 12:48:14', '2025-08-27 12:48:14'),
(57, 1, 3, NULL, 'dentist', 'denture clinic in Financial District', 100, 75, 'low', 'generated', '2025-08-27 12:48:14', '2025-08-27 12:48:14'),
(58, 1, 3, NULL, 'dentist', 'oral surgery specialist in Long Island City', 200, 80, 'medium', 'generated', '2025-08-27 12:48:14', '2025-08-27 12:48:14'),
(59, 1, 3, NULL, 'dentist', 'cosmetic dentist Astor Smile Dental', 600, 85, 'high', 'generated', '2025-08-27 12:55:55', '2025-08-27 12:55:55'),
(60, 1, 3, NULL, 'dentist', 'affordable dental clinic New York', 1200, 80, 'medium', 'generated', '2025-08-27 12:55:55', '2025-08-27 12:55:55'),
(61, 1, 3, NULL, 'dentist', 'teeth whitening services NY', 400, 70, 'low', 'generated', '2025-08-27 12:55:55', '2025-08-27 12:55:55'),
(62, 1, 3, NULL, 'dentist', 'Invisalign dentist NYC', 700, 85, 'medium', 'generated', '2025-08-27 12:55:55', '2025-08-27 12:55:55'),
(63, 1, 3, NULL, 'dentist', 'root canal specialist New York', 300, 80, 'medium', 'generated', '2025-08-27 12:55:55', '2025-08-27 12:55:55'),
(64, 1, 3, NULL, 'dentist', 'TMJ treatment Astor Smile Dental', 200, 70, 'low', 'generated', '2025-08-27 12:55:55', '2025-08-27 12:55:55'),
(65, 1, 3, NULL, 'dentist', 'sedation dentist in NY', 600, 80, 'medium', 'generated', '2025-08-27 12:55:55', '2025-08-27 12:55:55'),
(66, 1, 3, NULL, 'dentist', 'affordable orthodontist New York', 900, 85, 'high', 'generated', '2025-08-27 12:55:55', '2025-08-27 12:55:55'),
(67, 1, 3, NULL, 'dentist', 'dental crowns Astor Smile Dental', 300, 80, 'medium', 'generated', '2025-08-27 12:55:55', '2025-08-27 12:55:55'),
(68, 1, 3, NULL, 'dentist', 'emergency dental services NY', 500, 90, 'high', 'generated', '2025-08-27 12:55:55', '2025-08-27 12:55:55'),
(69, 1, 3, NULL, 'dentist', 'affordable dental cleaning NYC', 700, 80, 'medium', 'generated', '2025-08-27 12:55:55', '2025-08-27 12:55:55'),
(70, 1, 3, NULL, 'dentist', 'best dentist Astor Smile Dental', 300, 90, 'high', 'generated', '2025-08-27 12:56:10', '2025-08-27 12:56:10'),
(71, 1, 3, NULL, 'dentist', 'cosmetic dentistry near me', 1500, 75, 'medium', 'generated', '2025-08-27 12:56:10', '2025-08-27 12:56:10'),
(72, 1, 3, NULL, 'dentist', 'affordable dental clinic Astor Smile Dental', 200, 60, 'low', 'generated', '2025-08-27 12:56:10', '2025-08-27 12:56:10'),
(73, 1, 3, NULL, 'dentist', 'teeth whitening services New York', 600, 85, 'high', 'generated', '2025-08-27 12:56:10', '2025-08-27 12:56:10'),
(74, 1, 3, NULL, 'dentist', 'root canal specialist Astor Smile Dental', 100, 70, 'low', 'generated', '2025-08-27 12:56:10', '2025-08-27 12:56:10'),
(75, 1, 3, NULL, 'dentist', 'pediatric dentist Astor Smile Dental', 400, 80, 'medium', 'generated', '2025-08-27 12:56:10', '2025-08-27 12:56:10'),
(76, 1, 3, NULL, 'dentist', 'dental implants cost in NYC', 700, 90, 'high', 'generated', '2025-08-27 12:56:10', '2025-08-27 12:56:10'),
(77, 1, 3, NULL, 'dentist', 'orthodontist near Astor Smile Dental', 150, 65, 'low', 'generated', '2025-08-27 12:56:10', '2025-08-27 12:56:10'),
(78, 1, 3, NULL, 'dentist', 'emergency tooth extraction New York', 300, 75, 'medium', 'generated', '2025-08-27 12:56:10', '2025-08-27 12:56:10'),
(79, 1, 3, NULL, 'dentist', 'dentures specialist Astor Smile Dental', 80, 60, 'low', 'generated', '2025-08-27 12:56:10', '2025-08-27 12:56:10'),
(80, 1, 3, NULL, 'dentist', 'oral surgery clinic in NY', 200, 75, 'medium', 'generated', '2025-08-27 12:56:10', '2025-08-27 12:56:10'),
(81, 1, 3, NULL, 'dentist', 'emergency dentist Astor Smile Dental', 500, 80, 'high', 'generated', '2025-08-27 12:56:10', '2025-08-27 12:56:10'),
(82, 1, 3, NULL, 'dentist', 'teeth cleaning services New York', 1000, 85, 'high', 'generated', '2025-08-27 12:56:10', '2025-08-27 12:56:10'),
(83, 1, 3, NULL, 'dentist', 'periodontist near Astor Smile Dental', 120, 65, 'low', 'generated', '2025-08-27 12:56:10', '2025-08-27 12:56:10'),
(84, 1, 3, NULL, 'dentist', 'dental veneers Astor Smile Dental', 150, 70, 'low', 'generated', '2025-08-27 12:56:10', '2025-08-27 12:56:10'),
(85, 1, 3, NULL, 'dentist', 'emergency root canal NYC', 200, 75, 'medium', 'generated', '2025-08-27 12:56:10', '2025-08-27 12:56:10'),
(86, 1, 3, NULL, 'dentist', 'cosmetic dental surgery New York', 300, 80, 'high', 'generated', '2025-08-27 12:56:10', '2025-08-27 12:56:10'),
(87, 1, 3, NULL, 'dentist', 'TMJ specialist in NY', 150, 65, 'low', 'generated', '2025-08-27 12:56:10', '2025-08-27 12:56:10'),
(88, 1, 3, NULL, 'dentist', 'emergency wisdom teeth removal New York', 100, 70, 'low', 'generated', '2025-08-27 12:56:10', '2025-08-27 12:56:10'),
(89, 1, 3, NULL, 'dentist', 'teeth straightening Astor Smile Dental', 80, 75, 'medium', 'generated', '2025-08-27 12:56:10', '2025-08-27 12:56:10'),
(90, 1, 3, NULL, 'dentist', 'affordable braces NYC', 200, 80, 'high', 'generated', '2025-08-27 12:56:10', '2025-08-27 12:56:10'),
(91, 1, 3, NULL, 'dentist', 'best dental clinic near me', 3000, 80, 'medium', 'generated', '2025-08-27 12:56:25', '2025-08-27 12:56:25'),
(92, 1, 3, NULL, 'dentist', 'teeth whitening services Astor Smile Dental', 300, 70, 'low', 'generated', '2025-08-27 12:56:25', '2025-08-27 12:56:25'),
(93, 1, 3, NULL, 'dentist', 'pediatric dentist NYC', 1500, 80, 'high', 'generated', '2025-08-27 12:56:25', '2025-08-27 12:56:25'),
(94, 1, 3, NULL, 'dentist', 'dentures specialist near Astor Smile Dental', 200, 60, 'low', 'generated', '2025-08-27 12:56:25', '2025-08-27 12:56:25'),
(95, 1, 3, NULL, 'dentist', 'orthodontist Astor Smile Dental', 400, 70, 'medium', 'generated', '2025-08-27 12:56:25', '2025-08-27 12:56:25'),
(96, 1, 3, NULL, 'dentist', 'root canal treatment in New York', 700, 75, 'medium', 'generated', '2025-08-27 12:56:25', '2025-08-27 12:56:25'),
(97, 1, 3, NULL, 'dentist', 'dental implants NYC', 1200, 85, 'high', 'generated', '2025-08-27 12:56:25', '2025-08-27 12:56:25'),
(98, 1, 3, NULL, 'dentist', '24-hour dentist in NY', 150, 60, 'low', 'generated', '2025-08-27 12:56:25', '2025-08-27 12:56:25'),
(99, 1, 3, NULL, 'dentist', 'oral surgery Astor Smile Dental', 250, 70, 'low', 'generated', '2025-08-27 12:56:25', '2025-08-27 12:56:25'),
(100, 1, 3, NULL, 'dentist', 'prosthodontist in NY', 300, 70, 'medium', 'generated', '2025-08-27 12:56:25', '2025-08-27 12:56:25'),
(101, 1, 3, NULL, 'dentist', 'dental cleaning Astor Smile Dental', 600, 75, 'medium', 'generated', '2025-08-27 12:56:25', '2025-08-27 12:56:25'),
(102, 1, 3, NULL, 'dentist', 'TMJ specialist in New York', 200, 60, 'low', 'generated', '2025-08-27 12:56:25', '2025-08-27 12:56:25'),
(103, 1, 3, NULL, 'dentist', 'teeth whitening cost Astor Smile Dental', 100, 50, 'low', 'generated', '2025-08-27 12:56:25', '2025-08-27 12:56:25'),
(104, 1, 3, NULL, 'dentist', 'oral hygiene clinic in NY', 400, 75, 'medium', 'generated', '2025-08-27 12:56:25', '2025-08-27 12:56:25'),
(105, 1, 3, NULL, 'dentist', 'wisdom teeth removal NYC', 1000, 85, 'high', 'generated', '2025-08-27 12:56:25', '2025-08-27 12:56:25'),
(106, 1, 3, NULL, 'dentist', 'cosmetic braces Astor Smile Dental', 150, 60, 'low', 'generated', '2025-08-27 12:56:25', '2025-08-27 12:56:25'),
(107, 1, 3, NULL, 'dentist', 'best cosmetic dentist Astor Smile Dental', 200, 80, 'low', 'generated', '2025-08-27 13:59:32', '2025-08-27 13:59:32'),
(108, 1, 3, NULL, 'dentist', 'teeth whitening services Manhattan', 1200, 85, 'medium', 'generated', '2025-08-27 13:59:32', '2025-08-27 13:59:32'),
(109, 1, 3, NULL, 'dentist', 'affordable dental implants New York', 600, 90, 'high', 'generated', '2025-08-27 13:59:32', '2025-08-27 13:59:32'),
(110, 1, 3, NULL, 'dentist', 'emergency root canal near me', 400, 95, 'high', 'generated', '2025-08-27 13:59:32', '2025-08-27 13:59:32'),
(111, 1, 3, NULL, 'dentist', 'orthodontist in Midtown Manhattan', 300, 85, 'low', 'generated', '2025-08-27 13:59:32', '2025-08-27 13:59:32'),
(112, 1, 3, NULL, 'dentist', '24-hour dentist New York', 1000, 90, 'high', 'generated', '2025-08-27 13:59:32', '2025-08-27 13:59:32'),
(113, 1, 3, NULL, 'dentist', 'dental checkup Astor Smile Dental', 150, 75, 'low', 'generated', '2025-08-27 13:59:32', '2025-08-27 13:59:32'),
(114, 1, 3, NULL, 'dentist', 'affordable teeth cleaning NYC', 400, 85, 'medium', 'generated', '2025-08-27 13:59:32', '2025-08-27 13:59:32'),
(115, 1, 3, NULL, 'dentist', 'sedation dentist in New York', 300, 90, 'medium', 'generated', '2025-08-27 13:59:32', '2025-08-27 13:59:32'),
(116, 1, 3, NULL, 'dentist', 'dental crowns UES', 150, 85, 'low', 'generated', '2025-08-27 13:59:32', '2025-08-27 13:59:32'),
(117, 1, 3, NULL, 'dentist', 'Invisalign provider Astor Smile Dental', 200, 80, 'low', 'generated', '2025-08-27 13:59:32', '2025-08-27 13:59:32'),
(118, 1, 3, NULL, 'dentist', 'root canal specialist Manhattan', 400, 90, 'medium', 'generated', '2025-08-27 13:59:32', '2025-08-27 13:59:32'),
(119, 1, 3, NULL, 'dentist', 'emergency dentist near Central Park', 600, 95, 'high', 'generated', '2025-08-27 13:59:32', '2025-08-27 13:59:32'),
(120, 1, 3, NULL, 'dentist', 'dental emergency Astor Smile Dental', 100, 75, 'low', 'generated', '2025-08-27 13:59:32', '2025-08-27 13:59:32'),
(121, 1, 3, NULL, 'dentist', 'oral surgeon in New York', 250, 85, 'low', 'generated', '2025-08-27 13:59:32', '2025-08-27 13:59:32'),
(122, 1, 3, NULL, 'dentist', 'cosmetic dentistry services', 5000, 80, 'medium', 'generated', '2025-08-28 05:26:57', '2025-08-28 05:26:57'),
(123, 1, 3, NULL, 'dentist', 'teeth whitening specialists', 3000, 85, 'high', 'generated', '2025-08-28 05:26:57', '2025-08-28 05:26:57'),
(124, 1, 3, NULL, 'dentist', 'affordable dental implants', 2000, 90, 'medium', 'generated', '2025-08-28 05:26:57', '2025-08-28 05:26:57'),
(125, 1, 3, NULL, 'dentist', 'Invisalign providers in NY', 2500, 85, 'high', 'generated', '2025-08-28 05:26:57', '2025-08-28 05:26:57'),
(126, 1, 3, NULL, 'dentist', 'root canal treatment cost', 1800, 80, 'low', 'generated', '2025-08-28 05:26:57', '2025-08-28 05:26:57'),
(127, 1, 3, NULL, 'dentist', 'dental check-up specials', 1200, 70, 'low', 'generated', '2025-08-28 05:26:57', '2025-08-28 05:26:57'),
(128, 1, 3, NULL, 'dentist', 'TMJ treatment in New York', 1000, 85, 'medium', 'generated', '2025-08-28 05:26:57', '2025-08-28 05:26:57'),
(129, 1, 3, NULL, 'dentist', 'sedation dentistry options', 900, 75, 'low', 'generated', '2025-08-28 05:26:57', '2025-08-28 05:26:57'),
(130, 1, 3, NULL, 'dentist', 'dental crowns and bridges', 3000, 80, 'medium', 'generated', '2025-08-28 05:26:57', '2025-08-28 05:26:57'),
(131, 1, 3, NULL, 'dentist', 'cosmetic smile makeover', 2500, 85, 'high', 'generated', '2025-08-28 05:26:57', '2025-08-28 05:26:57'),
(132, 1, 3, NULL, 'dentist', 'emergency tooth extraction', 1600, 90, 'medium', 'generated', '2025-08-28 05:26:57', '2025-08-28 05:26:57'),
(133, 1, 3, NULL, 'dentist', 'teeth cleaning services NYC', 2200, 75, 'medium', 'generated', '2025-08-28 05:26:57', '2025-08-28 05:26:57'),
(134, 1, 3, NULL, 'dentist', 'dental veneers cost in NY', 1200, 85, 'high', 'generated', '2025-08-28 05:26:57', '2025-08-28 05:26:57'),
(135, 1, 3, NULL, 'dentist', 'oral surgery specialists', 1800, 80, 'medium', 'generated', '2025-08-28 05:26:57', '2025-08-28 05:26:57'),
(136, 1, 3, NULL, 'dentist', 'dental emergency clinic NY', 800, 90, 'low', 'generated', '2025-08-28 05:26:57', '2025-08-28 05:26:57'),
(137, 1, 3, NULL, 'dentist', 'implant-supported dentures', 700, 85, 'low', 'generated', '2025-08-28 05:26:57', '2025-08-28 05:26:57'),
(138, 1, 3, NULL, 'dentist', 'teeth sensitivity treatment', 1000, 75, 'low', 'generated', '2025-08-28 05:26:57', '2025-08-28 05:26:57'),
(139, 1, 3, NULL, 'dentist', 'invisalign braces nyc', 7500, 85, 'medium', 'generated', '2025-08-28 10:10:05', '2025-08-28 10:10:05'),
(140, 1, 3, NULL, 'dentist', '24 hour emergency dentist', 4800, 98, 'high', 'generated', '2025-08-28 10:10:05', '2025-08-28 10:10:05'),
(141, 1, 3, NULL, 'dentist', 'emergency root canal specialist', 4200, 98, 'high', 'generated', '2025-08-28 10:10:05', '2025-08-28 10:10:05'),
(142, 1, 3, NULL, 'dentist', 'top rated orthodontist nyc', 4000, 85, 'medium', 'generated', '2025-08-28 10:10:05', '2025-08-28 10:10:05'),
(143, 1, 3, NULL, 'dentist', 'emergency wisdom tooth extraction', 3800, 98, 'high', 'generated', '2025-08-28 10:10:05', '2025-08-28 10:10:05'),
(144, 1, 3, NULL, 'dentist', 'dental checkup midtown', 3200, 85, 'medium', 'generated', '2025-08-28 10:10:05', '2025-08-28 10:10:05'),
(145, 1, 3, NULL, 'dentist', 'family dentist near central park', 3000, 90, 'medium', 'generated', '2025-08-28 10:10:05', '2025-08-28 10:10:05'),
(146, 1, 3, NULL, 'dentist', 'cosmetic dentistry upper east side', 2500, 90, 'medium', 'generated', '2025-08-28 10:10:05', '2025-08-28 10:10:05'),
(147, 1, 3, NULL, 'dentist', 'best periodontist in nyc', 2200, 90, 'medium', 'generated', '2025-08-28 10:10:05', '2025-08-28 10:10:05'),
(148, 1, 3, NULL, 'dentist', 'sedation dentistry upper west side', 1500, 90, 'medium', 'generated', '2025-08-28 10:10:05', '2025-08-28 10:10:05'),
(149, 1, 3, NULL, 'dentist', 'emergency dental services NYC', 5000, 98, 'high', 'generated', '2025-08-28 13:04:51', '2025-08-28 13:04:51'),
(150, 1, 3, NULL, 'dentist', 'oral surgeon near me', 3000, 90, 'medium', 'generated', '2025-08-28 13:04:51', '2025-08-28 13:04:51'),
(151, 1, 3, NULL, 'dentist', 'dental emergency dentist Manhattan', 2800, 95, 'high', 'generated', '2025-08-28 13:04:51', '2025-08-28 13:04:51'),
(152, 1, 3, NULL, 'dentist', 'affordable dental implants NYC', 1200, 85, 'medium', 'generated', '2025-08-28 13:04:51', '2025-08-28 13:04:51'),
(153, 1, 3, NULL, 'dentist', 'teeth whitening Midtown', 1000, 85, 'medium', 'generated', '2025-08-28 13:04:51', '2025-08-28 13:04:51'),
(154, 1, 3, NULL, 'dentist', 'dental crown specialist Brooklyn', 600, 90, 'low', 'generated', '2025-08-28 13:04:51', '2025-08-28 13:04:51'),
(155, 1, 3, NULL, 'dentist', 'Astor Smile Dental reviews', 150, 75, 'low', 'generated', '2025-08-28 13:04:51', '2025-08-28 13:04:51'),
(156, 1, 3, NULL, 'dentist', 'Astor Smile Dental appointment', 100, 75, 'low', 'generated', '2025-08-28 13:04:51', '2025-08-28 13:04:51'),
(157, 1, 3, NULL, 'dentist', 'Astor Smile Dental prices', 80, 70, 'low', 'generated', '2025-08-28 13:04:51', '2025-08-28 13:04:51'),
(158, 1, 3, NULL, 'dentist', 'Astor Smile Dental contact', 70, 75, 'low', 'generated', '2025-08-28 13:04:51', '2025-08-28 13:04:51'),
(159, 1, 10, NULL, 'Generaldentistry', 'Emergency tooth extraction Bowery', 4200, 95, 'high', 'generated', '2025-09-01 12:43:47', '2025-09-01 12:43:47'),
(160, 1, 10, NULL, 'Generaldentistry', 'Emergency dentist near me', 3800, 95, 'medium', 'generated', '2025-09-01 12:43:47', '2025-09-01 12:43:47'),
(161, 1, 10, NULL, 'Generaldentistry', 'Emergency wisdom tooth removal NYC', 2800, 98, 'high', 'generated', '2025-09-01 12:43:47', '2025-09-01 12:43:47'),
(162, 1, 10, NULL, 'Generaldentistry', 'Emergency root canal treatment NYC', 2200, 98, 'high', 'generated', '2025-09-01 12:43:47', '2025-09-01 12:43:47'),
(163, 1, 10, NULL, 'Generaldentistry', 'Teeth whitening services NYC', 950, 75, 'medium', 'generated', '2025-09-01 12:43:47', '2025-09-01 12:43:47'),
(164, 1, 10, NULL, 'Generaldentistry', 'General dentistry services NYC', 700, 75, 'medium', 'generated', '2025-09-01 12:43:47', '2025-09-01 12:43:47'),
(165, 1, 10, NULL, 'Generaldentistry', 'Best dental crowns in NYC', 700, 85, 'medium', 'generated', '2025-09-01 12:43:47', '2025-09-01 12:43:47'),
(166, 1, 10, NULL, 'Generaldentistry', 'Top-rated cosmetic dentist NYC', 550, 80, 'medium', 'generated', '2025-09-01 12:43:47', '2025-09-01 12:43:47'),
(167, 1, 10, NULL, 'Generaldentistry', 'Best dental clinic in Bowery', 450, 85, 'medium', 'generated', '2025-09-01 12:43:47', '2025-09-01 12:43:47'),
(168, 1, 10, NULL, 'Generaldentistry', 'Bowery Dental implants cost', 300, 80, 'medium', 'generated', '2025-09-01 12:43:47', '2025-09-01 12:43:47'),
(169, 1, 10, NULL, 'Generaldentistry', 'Local family dentist Bowery', 250, 85, 'medium', 'generated', '2025-09-01 12:43:47', '2025-09-01 12:43:47'),
(170, 1, 10, NULL, 'Generaldentistry', 'Pediatric dental care Bowery', 180, 85, 'low', 'generated', '2025-09-01 12:43:47', '2025-09-01 12:43:47'),
(171, 1, 10, NULL, 'Generaldentistry', 'Local orthodontist in Bowery', 180, 85, 'low', 'generated', '2025-09-01 12:43:47', '2025-09-01 12:43:47'),
(172, 1, 10, NULL, 'Generaldentistry', 'Bowery Dental', 150, 80, 'low', 'generated', '2025-09-01 12:43:47', '2025-09-01 12:43:47'),
(173, 1, 10, NULL, 'Generaldentistry', 'Affordable dentures Bowery', 150, 85, 'low', 'generated', '2025-09-01 12:43:47', '2025-09-01 12:43:47'),
(174, 1, 10, NULL, 'Generaldentistry', 'Affordable teeth cleaning Bowery', 120, 90, 'low', 'generated', '2025-09-01 12:43:47', '2025-09-01 12:43:47'),
(175, 1, 10, NULL, 'Generaldentistry', 'Bowery dental check-up specials', 120, 90, 'low', 'generated', '2025-09-01 12:43:47', '2025-09-01 12:43:47'),
(176, 1, 10, NULL, 'Generaldentistry', 'Bowery dental care for seniors', 100, 90, 'low', 'generated', '2025-09-01 12:43:47', '2025-09-01 12:43:47'),
(177, 1, 10, NULL, 'Generaldentistry', 'Invisalign braces Bowery reviews', 80, 80, 'low', 'generated', '2025-09-01 12:43:47', '2025-09-01 12:43:47'),
(178, 1, 10, NULL, 'Generaldentistry', 'Bowery dental surgery specialists', 70, 85, 'low', 'generated', '2025-09-01 12:43:47', '2025-09-01 12:43:47'),
(179, 1, 19, NULL, 'Restaurant', 'top-rated dim sum in New York', 5000, 88, 'medium', 'generated', '2025-09-01 12:53:46', '2025-09-01 12:53:46'),
(180, 1, 19, NULL, 'Restaurant', 'New York City fine dining reservations', 4000, 88, 'medium', 'generated', '2025-09-01 12:53:46', '2025-09-01 12:53:46'),
(181, 1, 19, NULL, 'Restaurant', 'best late-night eats in NYC', 2500, 90, 'medium', 'generated', '2025-09-01 12:53:46', '2025-09-01 12:53:46'),
(182, 1, 19, NULL, 'Restaurant', 'best Chinese hot pot in New York', 2500, 90, 'medium', 'generated', '2025-09-01 12:53:46', '2025-09-01 12:53:46'),
(183, 1, 19, NULL, 'Restaurant', 'best Szechuan cuisine in NYC', 1800, 90, 'medium', 'generated', '2025-09-01 12:53:46', '2025-09-01 12:53:46'),
(184, 1, 19, NULL, 'Restaurant', 'authentic asian fusion cuisine NYC', 1500, 85, 'medium', 'generated', '2025-09-01 12:53:47', '2025-09-01 12:53:47'),
(185, 1, 19, NULL, 'Restaurant', 'order Peking duck online', 1200, 92, 'medium', 'generated', '2025-09-01 12:53:47', '2025-09-01 12:53:47'),
(186, 1, 19, NULL, 'Restaurant', 'top-rated Chinese tea house NYC', 1200, 88, 'medium', 'generated', '2025-09-01 12:53:47', '2025-09-01 12:53:47'),
(187, 1, 19, NULL, 'Restaurant', 'private event catering services NYC', 800, 85, 'medium', 'generated', '2025-09-01 12:53:47', '2025-09-01 12:53:47'),
(188, 1, 19, NULL, 'Restaurant', 'authentic Chinese hot pot experience', 700, 85, 'medium', 'generated', '2025-09-01 12:53:47', '2025-09-01 12:53:47'),
(189, 1, 19, NULL, 'Restaurant', 'order traditional Chinese desserts', 600, 92, 'medium', 'generated', '2025-09-01 12:53:47', '2025-09-01 12:53:47'),
(190, 1, 19, NULL, 'Restaurant', 'order dim sum for delivery NYC', 500, 92, 'medium', 'generated', '2025-09-01 12:53:47', '2025-09-01 12:53:47'),
(191, 1, 19, NULL, 'Restaurant', 'Ye\'s Apothecary dinner menu', 300, 80, 'low', 'generated', '2025-09-01 12:53:47', '2025-09-01 12:53:47'),
(192, 1, 19, NULL, 'Restaurant', 'authentic Peking duck delivery NYC', 300, 90, 'low', 'generated', '2025-09-01 12:53:47', '2025-09-01 12:53:47'),
(193, 1, 19, NULL, 'Restaurant', 'Ye\'s Apothecary lunch specials', 150, 85, 'low', 'generated', '2025-09-01 12:53:47', '2025-09-01 12:53:47'),
(194, 1, 19, NULL, 'Restaurant', 'Ye\'s Apothecary vegan-friendly options', 150, 95, 'low', 'generated', '2025-09-01 12:53:47', '2025-09-01 12:53:47'),
(195, 1, 19, NULL, 'Restaurant', 'Ye\'s Apothecary private dining events', 100, 95, 'low', 'generated', '2025-09-01 12:53:47', '2025-09-01 12:53:47'),
(196, 1, 19, NULL, 'Restaurant', 'Ye\'s Apothecary chef\'s tasting menu', 80, 95, 'low', 'generated', '2025-09-01 12:53:47', '2025-09-01 12:53:47'),
(197, 1, 19, NULL, 'Restaurant', 'Ye\'s Apothecary seasonal tasting menu', 70, 95, 'low', 'generated', '2025-09-01 12:53:47', '2025-09-01 12:53:47'),
(198, 1, NULL, 17, 'Gym', 'QA testing services', 25000, 80, 'high', 'generated', '2025-09-03 06:17:03', '2025-09-03 06:17:03'),
(199, 1, NULL, 17, 'Gym', 'QA testing tools', 18000, 85, 'medium', 'generated', '2025-09-03 06:17:03', '2025-09-03 06:17:03'),
(200, 1, NULL, 17, 'Gym', 'QA testing company', 15000, 75, 'medium', 'generated', '2025-09-03 06:17:03', '2025-09-03 06:17:03'),
(201, 1, NULL, 17, 'Gym', 'QA testing solutions', 12000, 90, 'high', 'generated', '2025-09-03 06:17:03', '2025-09-03 06:17:03'),
(202, 1, NULL, 17, 'Gym', 'QA testing process', 8000, 85, 'medium', 'generated', '2025-09-03 06:17:03', '2025-09-03 06:17:03'),
(203, 1, NULL, 17, 'Gym', 'QA testing strategies', 6000, 90, 'medium', 'generated', '2025-09-03 06:17:03', '2025-09-03 06:17:03'),
(204, 1, NULL, 17, 'Gym', 'QA testing tools 2025', 5000, 95, 'low', 'generated', '2025-09-03 06:17:03', '2025-09-03 06:17:03'),
(205, 1, NULL, 17, 'Gym', 'QA testing automation', 4500, 85, 'medium', 'generated', '2025-09-03 06:17:03', '2025-09-03 06:17:03'),
(206, 1, NULL, 17, 'Gym', 'QA testing best practices', 4000, 90, 'medium', 'generated', '2025-09-03 06:17:03', '2025-09-03 06:17:03'),
(207, 1, NULL, 17, 'Gym', 'QA testing trends', 3500, 80, 'medium', 'generated', '2025-09-03 06:17:03', '2025-09-03 06:17:03'),
(208, 1, NULL, 17, 'Gym', 'QA testing tools comparison', 3000, 95, 'low', 'generated', '2025-09-03 06:17:03', '2025-09-03 06:17:03'),
(209, 1, NULL, 17, 'Gym', 'QA testing methodologies', 2500, 85, 'medium', 'generated', '2025-09-03 06:17:03', '2025-09-03 06:17:03'),
(210, 1, NULL, 17, 'Gym', 'QA testing importance', 2000, 90, 'low', 'generated', '2025-09-03 06:17:03', '2025-09-03 06:17:03'),
(211, 1, NULL, 17, 'Gym', 'QA testing vs QC', 1800, 95, 'low', 'generated', '2025-09-03 06:17:03', '2025-09-03 06:17:03'),
(212, 1, NULL, 17, 'Gym', 'QA testing certification', 1500, 90, 'low', 'generated', '2025-09-03 06:17:03', '2025-09-03 06:17:03'),
(213, 1, NULL, 17, 'Gym', 'QA testing tools comparison 2025', 1200, 95, 'low', 'generated', '2025-09-03 06:17:03', '2025-09-03 06:17:03'),
(214, 1, NULL, 17, 'Gym', 'QA testing challenges', 1000, 85, 'low', 'generated', '2025-09-03 06:17:03', '2025-09-03 06:17:03'),
(215, 1, NULL, 17, 'Gym', 'QA testing services near me', 800, 90, 'medium', 'generated', '2025-09-03 06:17:03', '2025-09-03 06:17:03'),
(216, 1, NULL, 17, 'Gym', 'QA testing emergency services', 500, 98, 'high', 'generated', '2025-09-03 06:17:03', '2025-09-03 06:17:03'),
(217, 1, NULL, 17, 'Gym', 'QA testing tools for beginners', 300, 95, 'low', 'generated', '2025-09-03 06:17:03', '2025-09-03 06:17:03'),
(218, 1, NULL, 18, 'restaurant marketing', 'restaurant SEO services', 5000, 81, 'medium', 'generated', '2025-09-03 07:09:16', '2025-09-03 07:09:16'),
(219, 1, NULL, 18, 'restaurant marketing', 'restaurant marketing strategies', 4500, 80, 'medium', 'generated', '2025-09-03 07:09:16', '2025-09-03 07:09:16'),
(220, 1, NULL, 18, 'restaurant marketing', 'restaurant marketing trends', 4200, 84, 'medium', 'generated', '2025-09-03 07:09:16', '2025-09-03 07:09:16'),
(221, 1, NULL, 18, 'restaurant marketing', 'restaurant content marketing', 4000, 82, 'medium', 'generated', '2025-09-03 07:09:16', '2025-09-03 07:09:16'),
(222, 1, NULL, 18, 'restaurant marketing', 'restaurant influencer marketing', 3800, 83, 'medium', 'generated', '2025-09-03 07:09:16', '2025-09-03 07:09:16'),
(223, 1, NULL, 18, 'restaurant marketing', 'online marketing for restaurants', 3500, 82, 'medium', 'generated', '2025-09-03 07:09:16', '2025-09-03 07:09:16'),
(224, 1, NULL, 18, 'restaurant marketing', 'restaurant video marketing', 3400, 85, 'medium', 'generated', '2025-09-03 07:09:16', '2025-09-03 07:09:16'),
(225, 1, NULL, 18, 'restaurant marketing', 'restaurant email marketing', 3200, 86, 'medium', 'generated', '2025-09-03 07:09:16', '2025-09-03 07:09:16'),
(226, 1, NULL, 18, 'restaurant marketing', 'restaurant website optimization', 2800, 89, 'medium', 'generated', '2025-09-03 07:09:16', '2025-09-03 07:09:16'),
(227, 1, NULL, 18, 'restaurant marketing', 'restaurant PPC advertising', 2700, 88, 'medium', 'generated', '2025-09-03 07:09:16', '2025-09-03 07:09:16'),
(228, 1, NULL, 18, 'restaurant marketing', 'restaurant advertising ideas', 2500, 85, 'medium', 'generated', '2025-09-03 07:09:16', '2025-09-03 07:09:16'),
(229, 1, NULL, 18, 'restaurant marketing', 'restaurant mobile marketing', 2300, 90, 'medium', 'generated', '2025-09-03 07:09:16', '2025-09-03 07:09:16'),
(230, 1, NULL, 18, 'restaurant marketing', 'restaurant reputation management', 2000, 91, 'medium', 'generated', '2025-09-03 07:09:16', '2025-09-03 07:09:16'),
(231, 1, NULL, 18, 'restaurant marketing', 'restaurant promotion techniques', 1800, 88, 'medium', 'generated', '2025-09-03 07:09:16', '2025-09-03 07:09:16'),
(232, 1, NULL, 18, 'restaurant marketing', 'restaurant loyalty program ideas', 1500, 93, 'medium', 'generated', '2025-09-03 07:09:16', '2025-09-03 07:09:16'),
(233, 1, NULL, 18, 'restaurant marketing', 'restaurant branding strategies', 1200, 92, 'medium', 'generated', '2025-09-03 07:09:16', '2025-09-03 07:09:16'),
(234, 1, NULL, 18, 'restaurant marketing', 'restaurant influencer collaboration', 1100, 94, 'medium', 'generated', '2025-09-03 07:09:16', '2025-09-03 07:09:16'),
(235, 1, NULL, 18, 'restaurant marketing', 'restaurant customer retention strategies', 1000, 95, 'medium', 'generated', '2025-09-03 07:09:16', '2025-09-03 07:09:16'),
(236, 1, 26, NULL, 'Restaurant', 'Order food online', 25000, 88, 'high', 'generated', '2025-09-03 07:13:42', '2025-09-03 07:13:42'),
(237, 1, 26, NULL, 'Restaurant', 'Fine dining experience', 12000, 82, 'medium', 'generated', '2025-09-03 07:13:42', '2025-09-03 07:13:42'),
(238, 1, 26, NULL, 'Restaurant', 'Best rooftop restaurant', 6000, 85, 'medium', 'generated', '2025-09-03 07:13:42', '2025-09-03 07:13:42'),
(239, 1, 26, NULL, 'Restaurant', 'Order dinner delivery', 5000, 92, 'medium', 'generated', '2025-09-03 07:13:42', '2025-09-03 07:13:42'),
(240, 1, 26, NULL, 'Restaurant', 'Local vegan options near me', 4000, 88, 'medium', 'generated', '2025-09-03 07:13:42', '2025-09-03 07:13:42'),
(241, 1, 26, NULL, 'Restaurant', 'Local burger joint near me', 3500, 87, 'medium', 'generated', '2025-09-03 07:13:42', '2025-09-03 07:13:42'),
(242, 1, 26, NULL, 'Restaurant', 'Sample Business menu', 3000, 80, 'low', 'generated', '2025-09-03 07:13:42', '2025-09-03 07:13:42'),
(243, 1, 26, NULL, 'Restaurant', 'Local family-friendly dining', 3000, 83, 'medium', 'generated', '2025-09-03 07:13:42', '2025-09-03 07:13:42'),
(244, 1, 26, NULL, 'Restaurant', 'Best dessert place in town', 2500, 85, 'low', 'generated', '2025-09-03 07:13:42', '2025-09-03 07:13:42'),
(245, 1, 26, NULL, 'Restaurant', 'Best romantic restaurant', 2200, 80, 'low', 'generated', '2025-09-03 07:13:42', '2025-09-03 07:13:42'),
(246, 1, 26, NULL, 'Restaurant', 'Local seafood restaurant', 2000, 85, 'medium', 'generated', '2025-09-03 07:13:42', '2025-09-03 07:13:42'),
(247, 1, 26, NULL, 'Restaurant', 'Top-rated Sample Business', 1800, 78, 'low', 'generated', '2025-09-03 07:13:42', '2025-09-03 07:13:42'),
(248, 1, 26, NULL, 'Restaurant', 'Sample Business restaurant', 1500, 75, 'low', 'generated', '2025-09-03 07:13:42', '2025-09-03 07:13:42'),
(249, 1, 26, NULL, 'Restaurant', 'Sample Business catering services', 1500, 75, 'low', 'generated', '2025-09-03 07:13:42', '2025-09-03 07:13:42'),
(250, 1, 26, NULL, 'Restaurant', 'Sample Business happy hour specials', 1200, 82, 'low', 'generated', '2025-09-03 07:13:42', '2025-09-03 07:13:42'),
(251, 1, 26, NULL, 'Restaurant', 'Sample Business brunch menu', 1000, 80, 'low', 'generated', '2025-09-03 07:13:42', '2025-09-03 07:13:42');

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

--
-- Table structure for table `leads`
--

CREATE TABLE `leads` (
  `id` int(11) UNSIGNED NOT NULL,
  `campaign_id` int(11) UNSIGNED DEFAULT NULL,
  `business_name` varchar(255) NOT NULL,
  `contact_name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `website` varchar(500) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL,
  `zip_code` varchar(20) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `industry` varchar(100) DEFAULT NULL,
  `google_place_id` varchar(255) DEFAULT NULL,
  `rating` decimal(3,2) DEFAULT NULL,
  `reviews` int(11) DEFAULT NULL,
  `monthly_visits` int(11) DEFAULT NULL,
  `brand_primary` varchar(7) DEFAULT NULL,
  `brand_secondary` varchar(7) DEFAULT NULL,
  `lead_image` varchar(500) DEFAULT NULL,
  `source` varchar(100) DEFAULT NULL,
  `external_id` varchar(255) DEFAULT NULL,
  `status` enum('new','contacted','qualified','converted','rejected') DEFAULT 'new',
  `notes` text DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `leads`
--

INSERT INTO `leads` (`id`, `campaign_id`, `business_name`, `contact_name`, `email`, `website`, `phone`, `address`, `city`, `state`, `zip_code`, `country`, `industry`, `google_place_id`, `rating`, `reviews`, `monthly_visits`, `brand_primary`, `brand_secondary`, `lead_image`, `source`, `external_id`, `status`, `notes`, `created_at`, `updated_at`) VALUES
(2, 1, 'CONBODY', NULL, NULL, 'https://www.yelp.com/biz/conbody-new-york?adjust_creative=wZ-ctRmninEUAn3QIsUGRw&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_lookup&utm_source=wZ-ctRmninEUAn3QIsUGRw', '+13472510423', '102 Orchard St, Fl 2, New York, NY 10002', 'New York', 'NY', '10002', 'US', NULL, NULL, 5.00, 116, NULL, NULL, NULL, NULL, 'yelp', 'hqecZgNzDzwbDXj4aOyX6Q', 'new', NULL, '2025-08-26 12:19:36', '2025-08-26 12:19:36'),
(3, 1, 'Astor Smile Dental', NULL, NULL, 'https://www.yelp.com/biz/astor-smile-dental-new-york-2?adjust_creative=wZ-ctRmninEUAn3QIsUGRw&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_lookup&utm_source=wZ-ctRmninEUAn3QIsUGRw', '+12122540800', '53 W 11th St, Ste G, New York, NY 10011', 'New York', 'NY', '10011', 'US', NULL, NULL, 4.90, 46, NULL, NULL, NULL, NULL, 'yelp', '0FqDFKYZwmczy84IXeV81g', 'new', NULL, '2025-08-26 12:34:24', '2025-08-26 12:34:24'),
(4, 2, '305 Fitness', NULL, NULL, 'https://www.yelp.com/biz/305-fitness-new-york-2?adjust_creative=wZ-ctRmninEUAn3QIsUGRw&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_lookup&utm_source=wZ-ctRmninEUAn3QIsUGRw', '+12126039931', '18 W 8th St, New York, NY 10011', 'New York', 'NY', '10011', 'US', NULL, NULL, 4.80, 197, NULL, NULL, NULL, NULL, 'yelp', 'Utcu3PrZG2wteeOnyT1DkA', 'new', NULL, '2025-08-27 07:11:51', '2025-08-27 07:11:51'),
(9, 2, 'Tribeca Dental Care', NULL, 'info@tribecanydentistoffice.com', 'https://tribecanydentistoffice.com', '(212) 431-4582', '402 Broadway, New York, NY, 10013', 'New York', 'NY', '10013', 'US', '15007', NULL, 7.80, 0, NULL, NULL, NULL, NULL, 'foursquare', '5a8233d9a6fe4d4b9f311667', 'new', NULL, '2025-08-29 05:47:55', '2025-08-29 05:47:55'),
(10, 2, 'Bowery Dental', NULL, NULL, 'https://www.yelp.com/biz/bowery-dental-new-york?adjust_creative=wZ-ctRmninEUAn3QIsUGRw&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_lookup&utm_source=wZ-ctRmninEUAn3QIsUGRw', '+19173883678', '145 Canal St, Fl 2, New York, NY 10002', 'New York', 'NY', '10002', 'US', 'Generaldentistry', NULL, 4.90, 99, NULL, NULL, NULL, NULL, 'yelp', 'PJwKOemcW4_BzQHTJNkbFw', 'new', NULL, '2025-08-29 06:07:47', '2025-08-29 06:07:47'),
(11, 2, 'Grand Central Bodywork', NULL, NULL, 'https://www.yelp.com/biz/grand-central-bodywork-new-york-10?adjust_creative=wZ-ctRmninEUAn3QIsUGRw&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_lookup&utm_source=wZ-ctRmninEUAn3QIsUGRw', '+16467870827', '135 W 29th St, Ste 403, New York, NY 10001', 'New York', 'NY', '10001', 'US', 'Massage', NULL, 4.80, 173, NULL, NULL, NULL, 'https://s3-media0.fl.yelpcdn.com/bphoto/eLjx52TbP9PTP39-RIAo1w/o.jpg', 'yelp', 'MJ4gzHI6A_OQMltd3ciuww', 'new', NULL, '2025-08-29 06:23:14', '2025-08-29 06:23:14'),
(12, 1, 'Olio e Più', NULL, NULL, 'https://www.yelp.com/biz/olio-e-pi%C3%B9-new-york-7?adjust_creative=wZ-ctRmninEUAn3QIsUGRw&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_lookup&utm_source=wZ-ctRmninEUAn3QIsUGRw', '+12122436546', '3 Greenwich Ave, New York, NY 10014', 'New York', 'NY', '10014', 'US', 'Restaurant', NULL, 4.50, 6903, NULL, NULL, NULL, 'https://s3-media0.fl.yelpcdn.com/bphoto/CUpPgz_Q4QBHxxxxDJJTTA/o.jpg', 'yelp', '16ZnHpuaaBt92XWeJHCC5A', 'new', NULL, '2025-08-29 06:50:23', '2025-08-29 06:50:23'),
(13, 7, 'Dr Steven R Boettger DDS', NULL, NULL, 'https://www.healthgrades.com/physician/dr-steven-boettger-x6gyq', '(707) 462-6983', '620 S Dora St, Ukiah, CA, 95482', 'Ukiah', 'CA', '95482', 'US', 'Dentist', NULL, 0.00, 0, NULL, NULL, NULL, 'https://placehold.co/600x400/6c757d/ffffff?text=🏢+Business', 'foursquare', '4e77b8c7e4cd1304299e6ef8', 'new', NULL, '2025-08-29 12:36:19', '2025-08-29 12:36:19'),
(14, 7, 'Sample Business', NULL, NULL, 'https://samplebusiness.com', '(675) 521-7937', '123 Main St, Sample City, ST 12345', NULL, NULL, NULL, 'US', 'Restaurant', NULL, 4.30, 269, NULL, NULL, NULL, NULL, 'unknown', 'mock_place_6_4507a12a3e756aa056962784c5b72230', 'new', NULL, '2025-09-01 06:21:50', '2025-09-01 06:21:50'),
(17, 12, 'Thrive Acupuncture', NULL, NULL, 'https://www.yelp.com/biz/thrive-acupuncture-new-york?adjust_creative=wZ-ctRmninEUAn3QIsUGRw&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_lookup&utm_source=wZ-ctRmninEUAn3QIsUGRw', '+12127636628', '27 W 20th St, Ste 401, New York, NY 10011', 'New York', 'NY', '10011', 'US', 'Healthcare', NULL, 5.00, 7, NULL, NULL, NULL, 'https://s3-media0.fl.yelpcdn.com/bphoto/00UWYt097f4jiNl11ZkqUw/o.jpg', 'yelp', 'UzQg8VVRcGcCv6AiiRPVAA', 'new', NULL, '2025-09-01 11:29:43', '2025-09-01 11:29:43'),
(18, 12, 'Sample Business', NULL, NULL, 'https://samplebusiness.com', '(581) 787-3146', '123 Main St, Sample City, ST 12345', NULL, NULL, NULL, 'US', 'Restaurant', NULL, 4.00, 14, NULL, NULL, NULL, NULL, 'unknown', 'mock_place_6_4507a12a3e756aa056962784c5b72230', 'new', NULL, '2025-09-01 12:40:24', '2025-09-01 12:40:24'),
(19, 14, 'Ye\'s Apothecary 夜莺', NULL, NULL, 'https://www.yelp.com/biz/yes-apothecary-%E5%A4%9C%E8%8E%BA-new-york-5?adjust_creative=wZ-ctRmninEUAn3QIsUGRw&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_lookup&utm_source=wZ-ctRmninEUAn3QIsUGRw', '+19296552515', '119 Orchard St, New York, NY 10002', 'New York', 'NY', '10002', 'US', 'Restaurant', NULL, 4.60, 986, NULL, NULL, NULL, 'https://s3-media0.fl.yelpcdn.com/bphoto/qWXVjXp7TZllPApC5HoFXw/o.jpg', 'yelp', '8YWLuLUKj0t_0_Xv06UUtw', 'new', NULL, '2025-09-01 12:53:23', '2025-09-01 12:53:23'),
(20, NULL, 'Sample Business', NULL, NULL, 'https://samplebusiness.com', '(333) 575-7130', '123 Main St, Sample City, ST 12345', NULL, NULL, NULL, 'US', 'Restaurant', NULL, 4.30, 171, NULL, NULL, NULL, NULL, 'unknown', 'mock_place_5_ec2358d058a6b92d359de51ac45dc492', 'new', NULL, '2025-09-02 06:13:17', '2025-09-02 06:13:17'),
(21, 14, 'Sample Business', NULL, NULL, 'https://samplebusiness.com', '(406) 748-6803', '123 Main St, Sample City, ST 12345', NULL, NULL, NULL, 'US', 'Pizza Restaurant', NULL, 3.60, 183, NULL, NULL, NULL, NULL, 'unknown', 'mock_place_5_ec2358d058a6b92d359de51ac45dc492', 'new', NULL, '2025-09-02 12:37:26', '2025-09-02 12:37:26'),
(22, 16, 'Sample Business', NULL, NULL, 'https://samplebusiness.com', '(469) 731-4978', '123 Main St, Sample City, ST 12345', NULL, NULL, NULL, 'US', 'Restaurant', NULL, 3.80, 338, NULL, NULL, NULL, NULL, 'unknown', 'mock_place_3_55dcace530c529744636ea73d4333441', 'new', NULL, '2025-09-02 13:02:34', '2025-09-02 13:02:34'),
(23, 17, 'Sample Business', NULL, NULL, 'https://samplebusiness.com', '(205) 588-1053', '123 Main St, Sample City, ST 12345', NULL, NULL, NULL, 'US', 'Coffee Shop', NULL, 4.40, 441, NULL, NULL, NULL, NULL, 'unknown', 'mock_place_7_3524101cf9e31e0d30b3b3b4f8eff699', 'new', NULL, '2025-09-02 13:18:12', '2025-09-02 13:18:12'),
(24, 17, 'Sample Business', NULL, NULL, 'https://samplebusiness.com', '(735) 558-1090', '123 Main St, Sample City, ST 12345', NULL, NULL, NULL, 'US', 'Coffee Shop', NULL, 4.60, 51, NULL, NULL, NULL, NULL, 'unknown', 'mock_place_7_3524101cf9e31e0d30b3b3b4f8eff699', 'new', NULL, '2025-09-02 13:18:45', '2025-09-02 13:18:45'),
(25, 17, 'Just Train', NULL, NULL, 'https://www.yelp.com/biz/just-train-new-york?adjust_creative=wZ-ctRmninEUAn3QIsUGRw&utm_campaign=yelp_api_v3&utm_medium=api_v3_business_lookup&utm_source=wZ-ctRmninEUAn3QIsUGRw', '+12129207739', '6 Maiden Ln, Fl 2, New York, NY 10038', 'New York', 'NY', '10038', 'US', 'Gym', NULL, 5.00, 48, NULL, NULL, NULL, 'https://s3-media0.fl.yelpcdn.com/bphoto/_IW-cR8tI6ANmwtuVNVB1Q/o.jpg', 'yelp', '2rTsFlLLoVVsaEZ71IdFLw', 'new', NULL, '2025-09-03 05:46:51', '2025-09-03 05:46:51'),
(26, 18, 'Sample Business', NULL, NULL, 'https://samplebusiness.com', '(900) 988-7323', '123 Main St, Sample City, ST 12345', NULL, NULL, NULL, 'US', 'Restaurant', NULL, 4.80, 184, NULL, NULL, NULL, NULL, 'unknown', 'mock_place_8_498185004c50f4cf69142ef488b76ff4', 'new', NULL, '2025-09-03 07:07:37', '2025-09-03 07:07:37');

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `version` varchar(255) NOT NULL,
  `class` varchar(255) NOT NULL,
  `group` varchar(255) NOT NULL,
  `namespace` varchar(255) NOT NULL,
  `time` int(11) NOT NULL,
  `batch` int(11) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `version`, `class`, `group`, `namespace`, `time`, `batch`) VALUES
(1, '2024-01-01-000001', 'App\\Database\\Migrations\\CreateUsersTable', 'default', 'App', 1756191569, 1),
(2, '2024-01-01-000002', 'App\\Database\\Migrations\\CreateCampaignsTable', 'default', 'App', 1756191569, 1),
(3, '2024-01-01-000003', 'App\\Database\\Migrations\\CreateLeadsTable', 'default', 'App', 1756191569, 1),
(4, '2024-01-01-000004', 'App\\Database\\Migrations\\CreateAdDraftsTable', 'default', 'App', 1756191569, 1),
(5, '2024-01-01-000005', 'App\\Database\\Migrations\\CreateKeywordsTable', 'default', 'App', 1756191569, 1),
(6, '2024-01-01-000006', 'App\\Database\\Migrations\\CreateAuditLogsTable', 'default', 'App', 1756191569, 1),
(7, '2025-08-25-172047', 'App\\Database\\Migrations\\AlterLeadsTableAddFields', 'default', 'App', 1756191569, 1),
(8, '2025-08-25-172541', 'App\\Database\\Migrations\\ModifyCampaignIdNullableInLeads', 'default', 'App', 1756191569, 1),
(9, '2025-08-26-034728', 'App\\Database\\Migrations\\CreateAdminAuditLogsColumns', 'default', 'App', 1756207674, 2),
(10, '2025-08-26-120000', 'App\\Database\\Migrations\\AddExternalIdToLeads', 'default', 'App', 1756209181, 3),
(11, '2025-08-27-101247', 'App\\Database\\Migrations\\AddColumnsToAdDraftsTable', 'default', 'App', 1756289670, 4),
(12, '2025-09-01-000001', 'App\\Database\\Migrations\\CreatePasswordResetTokensTable', 'default', 'App', 1756714218, 5),
(13, '2025-09-01-000002', 'App\\Database\\Migrations\\UpdateCampaignsStatusEnum', 'default', 'App', 1756724765, 6),
(14, '2025-09-03-061500', 'App\\Database\\Migrations\\ModifyKeywordsTableLeadIdNullable', 'default', 'App', 1756880174, 7),
(15, '2025-09-04-060037', 'App\\Database\\Migrations\\AddLastLoginToUsers', 'default', 'App', 1756965711, 8);

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

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

CREATE TABLE `settings` (
  `id` int(11) UNSIGNED NOT NULL,
  `user_id` int(11) UNSIGNED NOT NULL,
  `setting_name` varchar(255) NOT NULL,
  `setting_value` text NOT NULL,
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `settings` (`id`, `user_id`, `setting_name`, `setting_value`, `created_at`, `updated_at`) VALUES
(2, 1, 'yelp_api_key', 'piArLw/5qMhtoBb02wnRZowJGGPltXVPkZ6PhD1Gk3dvCG1+Pp9pkN2NdNHWlFiASlF+TALvXpY+n8IWwuZG3xwQqOsMNYPvXB+vRL9Efdgf5OZJKeQDgyBQGVvRqlcXhSkY2NvXiXOF/iTUaWzuYgkaSdqNK/+eLi+Anz5T31/NxjuuSi5nhx5RNuVlX5D4RpUmGVr2jTGDTYIg', '2025-08-26 08:38:48', '2025-08-26 08:38:48'),
(3, 1, 'openai_api_key', 'i1M4qPNhVSwCFwdd7ue0sL4uo03zOMKKZqp+OiGlmali391irQKXiqp2NSrGqxB9tin1N3Mte1mqOG/pZJ5W60+NQ96g/PyJL8NMltcAmiaRAQ7F7pW3qAzOpcchITyYKxAEkWUs8ukKx8t2cf/6irsYE08fU52u8eZSPSSJgVbBaGZyoJeBiJiVmOLg0KAANkDchpiKgGo34JNjUm6TUD1cgaCKl79n48gCNDM2tbbRL92KidgjtaMFAjrtYYO8', '2025-08-26 09:25:41', '2025-08-26 09:25:41'),
(4, 1, 'foursquare_api_key', '7dFBoxJO82Uyc2vLPYJsKzBs0L+bR9o9RVEWdbv8sCKwPgbrynKzsWRM8At238XsCAM585dDWS/FRTS1P2RWnP6WXcYuetazGMrNXg==', '2025-08-28 10:21:08', '2025-08-28 10:21:08');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `ad_drafts`
--
ALTER TABLE `ad_drafts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `lead_id` (`lead_id`),
  ADD KEY `platform_ad_type` (`platform`,`ad_type`),
  ADD KEY `ad_drafts_user_id_foreign` (`user_id`),
  ADD KEY `ad_drafts_campaign_id_foreign` (`campaign_id`);

--
-- Indexes for table `audit_logs`
--
ALTER TABLE `audit_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `table_name_record_id` (`table_name`,`record_id`),
  ADD KEY `action_created_at` (`action`,`created_at`);

--
-- Indexes for table `campaigns`
--
ALTER TABLE `campaigns`
  ADD PRIMARY KEY (`id`),
  ADD KEY `owner_id` (`owner_id`),
  ADD KEY `status_owner_id` (`status`,`owner_id`);

--
-- Indexes for table `keywords`
--
ALTER TABLE `keywords`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id_lead_id` (`user_id`,`lead_id`),
  ADD KEY `seed_keyword` (`seed_keyword`),
  ADD KEY `keyword` (`keyword`),
  ADD KEY `status` (`status`),
  ADD KEY `created_at` (`created_at`);

--
-- Indexes for table `leads`
--
ALTER TABLE `leads`
  ADD PRIMARY KEY (`id`),
  ADD KEY `campaign_id` (`campaign_id`),
  ADD KEY `business_name` (`business_name`),
  ADD KEY `city_state` (`city`,`state`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user_setting` (`user_id`,`setting_name`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `ad_drafts`
--
ALTER TABLE `ad_drafts`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `audit_logs`
--
ALTER TABLE `audit_logs`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `campaigns`
--
ALTER TABLE `campaigns`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `keywords`
--
ALTER TABLE `keywords`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=252;

--
-- AUTO_INCREMENT for table `leads`
--
ALTER TABLE `leads`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `ad_drafts`
--
ALTER TABLE `ad_drafts`
  ADD CONSTRAINT `ad_drafts_campaign_id_foreign` FOREIGN KEY (`campaign_id`) REFERENCES `campaigns` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `ad_drafts_lead_id_foreign` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `ad_drafts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Constraints for table `audit_logs`
--
ALTER TABLE `audit_logs`
  ADD CONSTRAINT `audit_logs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Constraints for table `campaigns`
--
ALTER TABLE `campaigns`
  ADD CONSTRAINT `campaigns_owner_id_foreign` FOREIGN KEY (`owner_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `leads`
--
ALTER TABLE `leads`
  ADD CONSTRAINT `leads_campaign_id_foreign` FOREIGN KEY (`campaign_id`) REFERENCES `campaigns` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `settings`
--
ALTER TABLE `settings`
  ADD CONSTRAINT `settings_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

