-- Insert more categories for better organization INSERT INTO categories (id, name, slug, description, status, parent_id, is_indexable, category_type, created_at, updated_at) VALUES ('cat_gen_009', 'Marketing', 'marketing', 'Digital marketing, SEO, social media, and advertising strategies', TRUE, NULL, TRUE, 'GENERAL', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('cat_gen_010', 'Finance', 'finance', 'Personal finance, investing, banking, and financial planning', TRUE, NULL, TRUE, 'GENERAL', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('cat_gen_011', 'Real Estate', 'real-estate', 'Property buying, selling, investing, and real estate news', TRUE, NULL, TRUE, 'GENERAL', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('cat_gen_012', 'Gaming', 'gaming', 'Video games, esports, gaming reviews, and industry news', TRUE, NULL, TRUE, 'GENERAL', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('cat_gen_013', 'Lifestyle', 'lifestyle', 'Lifestyle tips, personal development, and daily living', TRUE, NULL, TRUE, 'GENERAL', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('cat_gen_014', 'Parenting', 'parenting', 'Parenting tips, child development, and family advice', TRUE, NULL, TRUE, 'GENERAL', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('cat_gen_015', 'Pets', 'pets', 'Pet care, animal health, and pet lifestyle', TRUE, NULL, TRUE, 'GENERAL', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('cat_gen_016', 'Automotive', 'automotive', 'Cars, vehicles, automotive news, and reviews', TRUE, NULL, TRUE, 'GENERAL', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('cat_gen_017', 'Home Improvement', 'home-improvement', 'Home renovation, DIY projects, and interior design', TRUE, NULL, TRUE, 'GENERAL', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('cat_gen_018', 'Science', 'science', 'Scientific discoveries, research, and innovation', TRUE, NULL, TRUE, 'GENERAL', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), -- Special Niche Categories ('cat_spec_007', 'Blockchain Technology', 'blockchain-technology', 'Blockchain, cryptocurrency, and Web3 technology insights', TRUE, NULL, TRUE, 'SPECIAL', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('cat_spec_008', 'AI & Machine Learning', 'ai-machine-learning', 'Artificial intelligence, ML, and data science content', TRUE, NULL, TRUE, 'SPECIAL', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('cat_spec_009', 'Luxury Real Estate', 'luxury-real-estate', 'Premium properties, luxury homes, and high-end real estate', TRUE, NULL, TRUE, 'SPECIAL', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('cat_spec_010', 'Investment Banking', 'investment-banking', 'Investment strategies, banking, and wealth management', TRUE, NULL, TRUE, 'SPECIAL', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('cat_spec_011', 'Medical Research', 'medical-research', 'Medical studies, healthcare research, and clinical trials', TRUE, NULL, TRUE, 'SPECIAL', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('cat_spec_012', 'Sustainable Living', 'sustainable-living', 'Eco-friendly living, sustainability, and green technology', TRUE, NULL, TRUE, 'SPECIAL', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); -- Standard Niche Websites (DA 30-70) INSERT INTO websites (id, name, slug, domain, da, dr, traffic, spam_score, backlinks, link_type, base_price, sale_price, content_service_price, category_id, niches, description, featured, status, created_at, updated_at) VALUES -- Technology Websites ('web_001', 'TechCrunch Daily', 'techcrunch-daily', 'techcrunchdaily.com', 85, 82, '2.5M', 5, 150000, 'Dofollow', 299.00, 249.00, 15.00, 'cat_gen_001', '["technology", "startups", "software"]', 'Leading technology news platform', TRUE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('web_002', 'TechGuru Blog', 'techguru-blog', 'techgurublog.com', 72, 68, '850K', 8, 75000, 'Dofollow', 199.00, 169.00, 12.00, 'cat_gen_001', '["technology", "gadgets", "reviews"]', 'Expert tech reviews and tutorials', FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('web_003', 'CodeMasters', 'codemasters', 'codemasters.io', 68, 65, '450K', 6, 45000, 'Dofollow', 179.00, 149.00, 12.00, 'cat_gen_001', '["programming", "software", "coding"]', 'Programming tutorials and resources', FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('web_004', 'Digital Trends Hub', 'digital-trends-hub', 'digitaltrendshub.com', 64, 60, '320K', 10, 35000, 'Dofollow', 159.00, 129.00, 10.00, 'cat_gen_001', '["technology", "digital", "trends"]', 'Latest digital trends and innovations', FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), -- Business Websites ('web_005', 'Business Insider Pro', 'business-insider-pro', 'businessinsiderpro.com', 88, 85, '3.2M', 4, 200000, 'Dofollow', 349.00, 299.00, 15.00, 'cat_gen_002', '["business", "entrepreneurship", "finance"]', 'Premium business insights and strategies', TRUE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('web_006', 'Startup Success', 'startup-success', 'startupsuccess.co', 75, 72, '620K', 7, 68000, 'Dofollow', 229.00, 189.00, 12.00, 'cat_gen_002', '["startups", "entrepreneurship", "funding"]', 'Startup guides and success stories', FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('web_007', 'Marketing Masters', 'marketing-masters', 'marketingmasters.com', 70, 68, '580K', 9, 55000, 'Dofollow', 199.00, 169.00, 12.00, 'cat_gen_009', '["marketing", "seo", "social media"]', 'Digital marketing strategies and tips', FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('web_008', 'Small Biz Hub', 'small-biz-hub', 'smallbizhub.com', 62, 58, '280K', 11, 32000, 'Dofollow', 149.00, 119.00, 10.00, 'cat_gen_002', '["small business", "entrepreneurship", "management"]', 'Resources for small business owners', FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), -- Health & Wellness ('web_009', 'HealthLine Today', 'healthline-today', 'healthlinetoday.com', 82, 79, '1.8M', 6, 120000, 'Dofollow', 279.00, 239.00, 15.00, 'cat_gen_003', '["health", "wellness", "fitness"]', 'Comprehensive health and wellness guides', TRUE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('web_010', 'Fitness Freak', 'fitness-freak', 'fitnessfreak.net', 71, 68, '720K', 8, 65000, 'Dofollow', 199.00, 169.00, 12.00, 'cat_gen_003', '["fitness", "workout", "nutrition"]', 'Fitness training and nutrition advice', FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('web_011', 'Yoga & Meditation', 'yoga-meditation', 'yogameditation.com', 65, 62, '340K', 5, 38000, 'Dofollow', 169.00, 139.00, 10.00, 'cat_gen_003', '["yoga", "meditation", "mindfulness"]', 'Yoga practices and meditation techniques', FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('web_012', 'Mental Wellness Hub', 'mental-wellness-hub', 'mentalwellnesshub.com', 68, 64, '410K', 7, 42000, 'Dofollow', 179.00, 149.00, 12.00, 'cat_gen_003', '["mental health", "therapy", "wellness"]', 'Mental health awareness and support', FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), -- Travel ('web_013', 'Wanderlust World', 'wanderlust-world', 'wanderlustworld.com', 78, 75, '950K', 6, 95000, 'Dofollow', 249.00, 209.00, 15.00, 'cat_gen_004', '["travel", "adventure", "destinations"]', 'Global travel guides and adventures', TRUE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('web_014', 'Budget Travel Tips', 'budget-travel-tips', 'budgettraveltips.com', 66, 63, '380K', 9, 40000, 'Dofollow', 169.00, 139.00, 10.00, 'cat_gen_004', '["budget travel", "backpacking", "tips"]', 'Travel on a budget', FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('web_015', 'Luxury Escapes', 'luxury-escapes', 'luxuryescapes.com', 73, 70, '560K', 4, 70000, 'Dofollow', 229.00, 189.00, 15.00, 'cat_spec_002', '["luxury travel", "resorts", "exclusive"]', 'Premium travel experiences', FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), -- Food & Cooking ('web_016', 'Gourmet Kitchen', 'gourmet-kitchen', 'gourmetkitchen.com', 74, 71, '680K', 5, 72000, 'Dofollow', 219.00, 179.00, 12.00, 'cat_gen_005', '["cooking", "recipes", "food"]', 'Gourmet recipes and cooking tips', TRUE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('web_017', 'Healthy Recipes Daily', 'healthy-recipes-daily', 'healthyrecipesdaily.com', 67, 64, '420K', 8, 45000, 'Dofollow', 179.00, 149.00, 10.00, 'cat_gen_005', '["healthy recipes", "nutrition", "meal prep"]', 'Healthy and delicious recipes', FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('web_018', 'Baking Masterclass', 'baking-masterclass', 'bakingmasterclass.com', 61, 58, '290K', 10, 28000, 'Dofollow', 149.00, 119.00, 10.00, 'cat_gen_005', '["baking", "desserts", "pastry"]', 'Baking tutorials and recipes', FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), -- Fashion ('web_019', 'Fashion Forward', 'fashion-forward', 'fashionforward.com', 76, 73, '780K', 7, 85000, 'Dofollow', 239.00, 199.00, 12.00, 'cat_gen_006', '["fashion", "style", "trends"]', 'Latest fashion trends and style guides', TRUE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('web_020', 'Street Style Hub', 'street-style-hub', 'streetstylehub.com', 63, 60, '310K', 11, 33000, 'Dofollow', 159.00, 129.00, 10.00, 'cat_gen_006', '["streetwear", "urban fashion", "style"]', 'Urban fashion and street style', FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('web_021', 'Luxury Designer Blog', 'luxury-designer-blog', 'luxurydesignerblog.com', 70, 67, '520K', 5, 58000, 'Dofollow', 209.00, 179.00, 15.00, 'cat_spec_004', '["designer fashion", "luxury brands", "haute couture"]', 'High-end fashion and designer news', FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), -- Sports ('web_022', 'Sports Central', 'sports-central', 'sportscentral.com', 80, 77, '1.2M', 6, 110000, 'Dofollow', 269.00, 229.00, 15.00, 'cat_gen_007', '["sports", "football", "basketball"]', 'Comprehensive sports coverage', TRUE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('web_023', 'Fitness Athlete', 'fitness-athlete', 'fitnessathlete.com', 69, 66, '480K', 8, 52000, 'Dofollow', 189.00, 159.00, 12.00, 'cat_gen_007', '["athlete training", "sports fitness", "workout"]', 'Athlete training and fitness tips', FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('web_024', 'Extreme Sports Mag', 'extreme-sports-mag', 'extremesportsmag.com', 64, 61, '350K', 9, 36000, 'Dofollow', 169.00, 139.00, 12.00, 'cat_gen_007', '["extreme sports", "adventure", "action sports"]', 'Extreme sports news and events', FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), -- Finance ('web_025', 'Wealth Management Pro', 'wealth-management-pro', 'wealthmanagementpro.com', 84, 81, '1.5M', 4, 140000, 'Dofollow', 299.00, 259.00, 15.00, 'cat_gen_010', '["finance", "investing", "wealth"]', 'Expert wealth management advice', TRUE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('web_026', 'Crypto Insider', 'crypto-insider', 'cryptoinsider.io', 77, 74, '890K', 8, 92000, 'Dofollow', 259.00, 219.00, 15.00, 'cat_spec_007', '["cryptocurrency", "blockchain", "bitcoin"]', 'Cryptocurrency news and analysis', FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('web_027', 'Stock Market Today', 'stock-market-today', 'stockmarkettoday.com', 72, 69, '650K', 7, 70000, 'Dofollow', 219.00, 179.00, 12.00, 'cat_gen_010', '["stocks", "trading", "investing"]', 'Stock market insights and tips', FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('web_028', 'Real Estate Investor', 'real-estate-investor', 'realestateinvestor.com', 75, 72, '580K', 6, 78000, 'Dofollow', 239.00, 199.00, 12.00, 'cat_gen_011', '["real estate", "property", "investing"]', 'Real estate investment strategies', FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), -- Real Estate ('web_029', 'Property Pulse', 'property-pulse', 'propertypulse.com', 71, 68, '490K', 7, 62000, 'Dofollow', 199.00, 169.00, 12.00, 'cat_gen_011', '["real estate", "property news", "market trends"]', 'Real estate market updates', FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('web_030', 'Luxury Estates', 'luxury-estates', 'luxuryestates.com', 79, 76, '720K', 5, 98000, 'Dofollow', 279.00, 239.00, 15.00, 'cat_spec_009', '["luxury homes", "premium properties", "real estate"]', 'Premium luxury properties worldwide', TRUE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), -- Education ('web_031', 'E-Learning Hub', 'e-learning-hub', 'elearninghub.com', 73, 70, '620K', 6, 71000, 'Dofollow', 219.00, 179.00, 12.00, 'cat_gen_008', '["education", "online learning", "courses"]', 'Online learning resources', FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('web_032', 'Study Abroad Guide', 'study-abroad-guide', 'studyabroadguide.com', 67, 64, '390K', 8, 44000, 'Dofollow', 179.00, 149.00, 10.00, 'cat_gen_008', '["study abroad", "international education", "scholarships"]', 'Study abroad opportunities', FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('web_033', 'Career Success', 'career-success', 'careersuccess.com', 70, 67, '510K', 7, 59000, 'Dofollow', 199.00, 169.00, 12.00, 'cat_gen_008', '["career advice", "job search", "professional development"]', 'Career guidance and tips', FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), -- Gaming ('web_034', 'Game Masters', 'game-masters', 'gamemasters.com', 76, 73, '950K', 8, 88000, 'Dofollow', 249.00, 209.00, 12.00, 'cat_gen_012', '["gaming", "video games", "esports"]', 'Gaming news and reviews', TRUE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('web_035', 'Esports Insider', 'esports-insider', 'esportsinsider.com', 72, 69, '680K', 7, 74000, 'Dofollow', 229.00, 189.00, 12.00, 'cat_gen_012', '["esports", "competitive gaming", "tournaments"]', 'Esports news and coverage', FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('web_036', 'RPG World', 'rpg-world', 'rpgworld.com', 64, 61, '340K', 9, 37000, 'Dofollow', 169.00, 139.00, 10.00, 'cat_gen_012', '["rpg", "role playing games", "game guides"]', 'RPG game guides and reviews', FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), -- AI & Technology Special ('web_037', 'AI Revolution', 'ai-revolution', 'airevolution.io', 86, 83, '1.1M', 4, 130000, 'Dofollow', 329.00, 279.00, 15.00, 'cat_spec_008', '["artificial intelligence", "machine learning", "AI"]', 'Latest AI developments and insights', TRUE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('web_038', 'ML Masters', 'ml-masters', 'mlmasters.com', 81, 78, '890K', 5, 105000, 'Dofollow', 299.00, 259.00, 15.00, 'cat_spec_008', '["machine learning", "data science", "analytics"]', 'Machine learning tutorials and resources', FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), -- Lifestyle ('web_039', 'Modern Lifestyle', 'modern-lifestyle', 'modernlifestyle.com', 69, 66, '460K', 8, 51000, 'Dofollow', 189.00, 159.00, 12.00, 'cat_gen_013', '["lifestyle", "personal development", "productivity"]', 'Modern living and lifestyle tips', FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('web_040', 'Home & Living', 'home-living', 'homeliving.com', 65, 62, '370K', 9, 39000, 'Dofollow', 169.00, 139.00, 10.00, 'cat_gen_017', '["home decor", "interior design", "DIY"]', 'Home improvement and decor', FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), -- Automotive ('web_041', 'Auto World', 'auto-world', 'autoworld.com', 74, 71, '710K', 7, 82000, 'Dofollow', 239.00, 199.00, 12.00, 'cat_gen_016', '["automotive", "cars", "vehicles"]', 'Automotive news and reviews', TRUE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('web_042', 'Electric Vehicles Hub', 'electric-vehicles-hub', 'electricvehicleshub.com', 71, 68, '540K', 6, 64000, 'Dofollow', 219.00, 179.00, 12.00, 'cat_gen_016', '["electric vehicles", "EV", "sustainable transport"]', 'Electric vehicle news and guides', FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), -- Science ('web_043', 'Science Daily Hub', 'science-daily-hub', 'sciencedailyhub.com', 83, 80, '980K', 4, 115000, 'Dofollow', 289.00, 249.00, 15.00, 'cat_gen_018', '["science", "research", "discovery"]', 'Latest scientific discoveries', TRUE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('web_044', 'Space Explorer', 'space-explorer', 'spaceexplorer.com', 78, 75, '760K', 5, 94000, 'Dofollow', 269.00, 229.00, 15.00, 'cat_gen_018', '["space", "astronomy", "cosmos"]', 'Space exploration news', FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), -- Parenting ('web_045', 'Parenting Pro', 'parenting-pro', 'parentingpro.com', 68, 65, '430K', 8, 47000, 'Dofollow', 179.00, 149.00, 10.00, 'cat_gen_014', '["parenting", "child development", "family"]', 'Parenting tips and advice', FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('web_046', 'Mommy Blog', 'mommy-blog', 'mommyblog.com', 62, 59, '290K', 10, 29000, 'Dofollow', 149.00, 119.00, 10.00, 'cat_gen_014', '["motherhood", "parenting", "family life"]', 'Mom lifestyle and parenting', FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), -- Pets ('web_047', 'Pet Care Central', 'pet-care-central', 'petcarecentral.com', 70, 67, '500K', 7, 56000, 'Dofollow', 199.00, 169.00, 12.00, 'cat_gen_015', '["pets", "pet care", "animals"]', 'Pet care guides and tips', FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('web_048', 'Dog World', 'dog-world', 'dogworld.com', 66, 63, '360K', 8, 41000, 'Dofollow', 169.00, 139.00, 10.00, 'cat_gen_015', '["dogs", "dog breeds", "pet training"]', 'Everything about dogs', FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), -- More Standard Websites ('web_049', 'Digital Nomad Life', 'digital-nomad-life', 'digitalnomadlife.com', 64, 61, '320K', 9, 34000, 'Dofollow', 159.00, 129.00, 10.00, 'cat_gen_004', '["digital nomad", "remote work", "travel"]', 'Remote work and travel lifestyle', FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('web_050', 'Eco Friendly Living', 'eco-friendly-living', 'ecofriendlyliving.com', 72, 69, '480K', 5, 66000, 'Dofollow', 209.00, 179.00, 12.00, 'cat_spec_012', '["sustainability", "eco friendly", "green living"]', 'Sustainable living guides', FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('web_051', 'Investment Banker', 'investment-banker', 'investmentbanker.com', 85, 82, '1.3M', 4, 160000, 'Dofollow', 349.00, 299.00, 15.00, 'cat_spec_010', '["investment banking", "finance", "wealth"]', 'Investment banking insights', TRUE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('web_052', 'Medical Research Today', 'medical-research-today', 'medicalresearchtoday.com', 82, 79, '920K', 5, 125000, 'Dofollow', 299.00, 259.00, 15.00, 'cat_spec_011', '["medical research", "healthcare", "clinical studies"]', 'Latest medical research', TRUE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); -- Standard Packages INSERT INTO packages (id, name, slug, description, package_type, base_price, sale_price, features, is_popular, is_featured, status, created_at, updated_at) VALUES ('pkg_std_001', 'Starter Guest Post Package', 'starter-guest-post-package', 'Perfect for beginners looking to build quality backlinks', 'standard', 499.00, 399.00, '[ "3 High-Quality Guest Posts", "DA 40+ Websites", "Dofollow Links", "Original Content (500 words each)", "1 Round of Revisions", "Basic Analytics Report", "7-10 Days Delivery" ]', TRUE, FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('pkg_std_002', 'Business Growth Package', 'business-growth-package', 'Ideal for growing businesses needing authority backlinks', 'standard', 899.00, 749.00, '[ "7 High-Quality Guest Posts", "DA 50+ Websites", "Dofollow Links", "Original Content (700 words each)", "2 Rounds of Revisions", "Detailed Analytics Report", "Priority Support", "10-14 Days Delivery" ]', TRUE, TRUE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('pkg_std_003', 'Enterprise SEO Package', 'enterprise-seo-package', 'Comprehensive solution for established businesses', 'standard', 1499.00, 1299.00, '[ "15 High-Quality Guest Posts", "DA 60+ Websites", "Dofollow Links", "Original Content (1000 words each)", "Unlimited Revisions", "Advanced Analytics Dashboard", "Dedicated Account Manager", "Priority Delivery", "15-20 Days Delivery" ]', FALSE, TRUE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('pkg_std_004', 'Local SEO Package', 'local-seo-package', 'Target local audiences with geo-targeted posts', 'standard', 599.00, 499.00, '[ "5 Local Guest Posts", "DA 35+ Local Websites", "Dofollow Links", "Local Keywords Optimization", "Google Maps Integration", "Local Citation Building", "7-10 Days Delivery" ]', FALSE, FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('pkg_std_005', 'Niche Specific Package', 'niche-specific-package', 'Target specific industry niches', 'standard', 799.00, 649.00, '[ "6 Niche-Relevant Posts", "DA 45+ Niche Websites", "Dofollow Links", "Niche Keyword Research", "Competitor Analysis", "Monthly Performance Report", "10-12 Days Delivery" ]', FALSE, FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), -- Special Niche Packages ('pkg_spec_001', 'Premium Authority Package', 'premium-authority-package', 'High DA websites for maximum authority', 'special_niche', 2499.00, 1999.00, '[ "10 Premium Guest Posts", "DA 75+ Websites", "Dofollow Links", "Premium Content (1500 words each)", "Infographics Included", "Video Content Available", "Featured Placement", "Social Media Promotion", "Lifetime Link Guarantee", "20-25 Days Delivery" ]', TRUE, TRUE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('pkg_spec_002', 'Luxury & Lifestyle Package', 'luxury-lifestyle-package', 'Target high-end luxury and lifestyle niches', 'special_niche', 1899.00, 1599.00, '[ "8 Luxury Niche Posts", "DA 70+ Luxury Websites", "Dofollow Links", "Premium Content (1200 words each)", "High-Quality Images", "Featured Placement", "Social Media Shoutout", "15-20 Days Delivery" ]', FALSE, TRUE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('pkg_spec_003', 'Tech & Innovation Package', 'tech-innovation-package', 'Cutting-edge technology and innovation niches', 'special_niche', 2199.00, 1799.00, '[ "12 Tech Guest Posts", "DA 70+ Tech Websites", "Dofollow Links", "Technical Content (1500 words)", "Code Snippets Included", "Developer Community Access", "Featured in Newsletters", "15-20 Days Delivery" ]', FALSE, FALSE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('pkg_spec_004', 'Finance & Investment Package', 'finance-investment-package', 'High-authority finance and investment websites', 'special_niche', 2999.00, 2499.00, '[ "10 Finance Guest Posts", "DA 80+ Finance Websites", "Dofollow Links", "Financial Expert Content", "Data-Driven Insights", "Investment Analysis Included", "Featured in Premium Sections", "25-30 Days Delivery" ]', TRUE, TRUE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), ('pkg_spec_005', 'Healthcare & Medical Package', 'healthcare-medical-package', 'Medical and healthcare authority websites', 'special_niche', 2799.00, 2299.00, '[ "8 Medical Guest Posts", "DA 75+ Medical Websites", "Dofollow Links", "Medically Reviewed Content", "Doctor Consultation Available", "Clinical References", "HIPAA Compliant", "20-25 Days Delivery" ]', FALSE, TRUE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP), -- Custom Packages ('pkg_cus_001', 'Custom Enterprise Solution', 'custom-enterprise-solution', 'Tailored package for enterprise needs', 'custom', 5000.00, 3999.00, '[ "Custom Number of Posts", "Custom DA Requirements", "Specific Niche Targeting", "Custom Content Strategy", "Dedicated Team", "API Access Available", "White Label Reporting", "30-45 Days Delivery" ]', FALSE, TRUE, 'active', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); -- Package 1: Starter Guest Post Package (pkg_std_001) - 3 websites INSERT INTO package_websites (id, package_id, website_id, created_at) VALUES (gen_random_uuid()::text, 'pkg_std_001', 'web_004', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_std_001', 'web_008', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_std_001', 'web_012', CURRENT_TIMESTAMP); -- Package 2: Business Growth Package (pkg_std_002) - 7 websites INSERT INTO package_websites (id, package_id, website_id, created_at) VALUES (gen_random_uuid()::text, 'pkg_std_002', 'web_002', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_std_002', 'web_006', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_std_002', 'web_007', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_std_002', 'web_010', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_std_002', 'web_017', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_std_002', 'web_023', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_std_002', 'web_029', CURRENT_TIMESTAMP); -- Package 3: Enterprise SEO Package (pkg_std_003) - 15 websites INSERT INTO package_websites (id, package_id, website_id, created_at) VALUES (gen_random_uuid()::text, 'pkg_std_003', 'web_001', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_std_003', 'web_005', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_std_003', 'web_009', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_std_003', 'web_013', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_std_003', 'web_016', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_std_003', 'web_019', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_std_003', 'web_022', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_std_003', 'web_025', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_std_003', 'web_031', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_std_003', 'web_034', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_std_003', 'web_039', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_std_003', 'web_041', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_std_003', 'web_043', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_std_003', 'web_047', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_std_003', 'web_049', CURRENT_TIMESTAMP); -- Package 4: Local SEO Package (pkg_std_004) - 5 websites INSERT INTO package_websites (id, package_id, website_id, created_at) VALUES (gen_random_uuid()::text, 'pkg_std_004', 'web_008', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_std_004', 'web_029', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_std_004', 'web_040', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_std_004', 'web_045', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_std_004', 'web_049', CURRENT_TIMESTAMP); -- Package 5: Niche Specific Package (pkg_std_005) - 6 websites INSERT INTO package_websites (id, package_id, website_id, created_at) VALUES (gen_random_uuid()::text, 'pkg_std_005', 'web_003', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_std_005', 'web_011', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_std_005', 'web_018', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_std_005', 'web_024', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_std_005', 'web_032', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_std_005', 'web_036', CURRENT_TIMESTAMP); -- Package 6: Premium Authority Package (pkg_spec_001) - 10 websites INSERT INTO package_websites (id, package_id, website_id, created_at) VALUES (gen_random_uuid()::text, 'pkg_spec_001', 'web_001', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_001', 'web_005', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_001', 'web_009', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_001', 'web_013', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_001', 'web_016', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_001', 'web_019', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_001', 'web_022', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_001', 'web_025', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_001', 'web_030', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_001', 'web_037', CURRENT_TIMESTAMP); -- Package 7: Luxury & Lifestyle Package (pkg_spec_002) - 8 websites INSERT INTO package_websites (id, package_id, website_id, created_at) VALUES (gen_random_uuid()::text, 'pkg_spec_002', 'web_015', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_002', 'web_021', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_002', 'web_030', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_002', 'web_039', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_002', 'web_040', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_002', 'web_049', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_002', 'web_050', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_002', 'web_046', CURRENT_TIMESTAMP); -- Package 8: Tech & Innovation Package (pkg_spec_003) - 12 websites INSERT INTO package_websites (id, package_id, website_id, created_at) VALUES (gen_random_uuid()::text, 'pkg_spec_003', 'web_001', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_003', 'web_002', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_003', 'web_003', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_003', 'web_004', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_003', 'web_037', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_003', 'web_038', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_003', 'web_043', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_003', 'web_044', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_003', 'web_026', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_003', 'web_034', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_003', 'web_035', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_003', 'web_036', CURRENT_TIMESTAMP); -- Package 9: Finance & Investment Package (pkg_spec_004) - 10 unique websites (FIXED - no duplicates) INSERT INTO package_websites (id, package_id, website_id, created_at) VALUES (gen_random_uuid()::text, 'pkg_spec_004', 'web_005', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_004', 'web_025', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_004', 'web_026', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_004', 'web_027', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_004', 'web_028', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_004', 'web_030', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_004', 'web_051', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_004', 'web_052', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_004', 'web_014', CURRENT_TIMESTAMP), -- New unique website (gen_random_uuid()::text, 'pkg_spec_004', 'web_020', CURRENT_TIMESTAMP); -- New unique website -- Package 10: Healthcare & Medical Package (pkg_spec_005) - 8 websites INSERT INTO package_websites (id, package_id, website_id, created_at) VALUES (gen_random_uuid()::text, 'pkg_spec_005', 'web_009', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_005', 'web_010', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_005', 'web_011', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_005', 'web_012', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_005', 'web_052', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_005', 'web_043', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_005', 'web_047', CURRENT_TIMESTAMP), (gen_random_uuid()::text, 'pkg_spec_005', 'web_045', CURRENT_TIMESTAMP);