--
-- Host: localhost    Database: zybertron
-- ------------------------------------------------------


--
-- Table structure for table `advertisements`
--

CREATE TABLE `advertisements` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `advertisements`
--

INSERT INTO `advertisements` VALUES (1,'adsense-header','',0,'2024-07-18 08:00:38','2024-07-18 08:00:38'),(2,'adsense-download-top-728x90','',0,'2024-07-18 08:00:38','2024-07-18 08:00:38'),(3,'adsense-download-bottom-728x90','',0,'2024-07-18 08:00:38','2024-07-18 08:00:38'),(4,'adsense-download-300x250','',0,'2024-07-18 08:00:38','2024-07-18 08:00:38'),(5,'adsense-frontend-features-728x90','',0,'2024-07-18 08:00:38','2024-07-18 08:00:38'),(6,'adsense-frontend-blogs-728x90','',0,'2024-07-18 08:00:38','2024-07-18 08:00:38');

--
-- Table structure for table `api_keys`
--

CREATE TABLE `api_keys` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `engine` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `api_key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `api_keys`
--


--
-- Table structure for table `article_wizards`
--

CREATE TABLE `article_wizards` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `titles` text COLLATE utf8mb4_unicode_ci,
  `keywords` text COLLATE utf8mb4_unicode_ci,
  `outlines` longtext COLLATE utf8mb4_unicode_ci,
  `talking_points` longtext COLLATE utf8mb4_unicode_ci,
  `current_step` int NOT NULL DEFAULT '1',
  `language` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image_description` longtext COLLATE utf8mb4_unicode_ci,
  `tone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `max_words` int DEFAULT NULL,
  `creativity` double(8,2) NOT NULL DEFAULT '0.50',
  `view_point` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `selected_keywords` longtext COLLATE utf8mb4_unicode_ci,
  `selected_title` longtext COLLATE utf8mb4_unicode_ci,
  `selected_outline` longtext COLLATE utf8mb4_unicode_ci,
  `selected_talking_points` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `article_wizards`
--

INSERT INTO `article_wizards` VALUES (1,1,'Explore the Ultimate Uber Clone Script for Your Taxi Business, Revolutionize Your Taxi Company with Cutting-Edge Taxi Dispatch Software, Attract More Customers with Our On-Demand Taxi Booking Software, Enhance Your Taxi Business with ZyberTaxi Uber Clone Script, Attract More Customers with ZyberTaxi Taxi Dispatch Software, Stay Ahead of Market Trends with ZyberTaxi On-Demand Taxi Booking Software, Revolutionize taxi industry with ZyberTaxi: The ultimate Uber clone script, Attract more riders with ZyberTaxi\'s innovative taxi dispatch software, Stay ahead of competition with ZyberTaxi: Your top choice for ride hailing software','taxi, software, development, features, market trends, taxi, software, features, market trends, sales','\"[\\\"Streamline Your Taxi Business Operations\\\",\\\"Enhance Customer Experience\\\",\\\"Increase Revenue Streams\\\",\\\"Customize Your Taxi Dispatch Software\\\",\\\"Stay Ahead of Competition\\\"]\"',NULL,5,'English (USA)','https://ai.zybertron.com/images/wizard-image-AwJNUoOODQ.png','ZyberTaxi','Professional',NULL,0.50,'first',0,'Uber clone script, Uber clone, Taxi dispatch software,  ride hailing software, on-demand taxi booking software','Explore the Ultimate Uber Clone Script for Your Taxi Business','[\"Streamline Your Taxi Business Operations\",\"Enhance Customer Experience\",\"Increase Revenue Streams\",\"Customize Your Taxi Dispatch Software\",\"Stay Ahead of Competition\"]','[[\"Optimize taxi business operations\",\"Increase efficiency with Uber clone\"],[\"Improve customer experience with Uber clone script\",\"Enhance taxi business with on-demand software\",\"\"],[\"Increase revenue with Uber clone\",\"Utilize taxi dispatch software\"],[\"Customize your taxi dispatch software\",\"Explore ultimate Uber clone script\"],[\"Stay ahead of competition with Uber clone script\",\"Explore the ultimate Uber clone\"]]','2024-07-18 09:31:59','2024-11-26 15:24:25'),(2,3,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0.50,NULL,0,NULL,NULL,NULL,NULL,'2024-07-19 06:34:18','2024-07-19 06:34:18'),(3,5,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0.50,NULL,0,NULL,NULL,NULL,NULL,'2024-07-20 00:45:19','2024-07-20 00:45:19'),(4,7,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0.50,NULL,0,NULL,NULL,NULL,NULL,'2024-07-20 18:53:43','2024-07-20 18:53:43'),(6,9,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0.50,NULL,0,NULL,NULL,NULL,NULL,'2024-08-06 02:17:37','2024-08-06 02:17:37'),(7,10,'New Arrivals in Wearables!, Exclusive Discounts on Gadgets, Hot Promotions for Wearables','Wearables, Gadgets, Discounts, New arrivals, Promotions','\"[\\\"Seasonal Sales on Cutting-Edge Gadgets\\\",\\\"Exclusive Deals for Early Shoppers\\\",\\\"Comparing Prices: Discounted vs. Full Price\\\",\\\"Gadget Bundles with Unbeatable Discounts\\\",\\\"Insider Tips for Maximizing Savings\\\"]\"',NULL,5,'English (USA)','https://ai.zybertron.com/images/wizard-image-9QOf0HZ4gt.png','image should show new smart watch and headphones','Professional',NULL,0.50,'first',0,'Wearables, Gadgets, Discounts, New arrivals, Promotions,','Exclusive Discounts on Gadgets','[\"Seasonal Sales on Cutting-Edge Gadgets\",\"Exclusive Deals for Early Shoppers\",\"Comparing Prices: Discounted vs. Full Price\",\"Gadget Bundles with Unbeatable Discounts\",\"Insider Tips for Maximizing Savings\"]','[[\"Exclusive wearables discounts\",\"New arrivals promotions\"],[\"Wearables New Arrivals\",\"Gadgets Early Discounts\"],[\"Wearables New Arrivals\",\"Gadget Promotions Discounts\"],[\"Wearables New Arrivals\",\"Exclusive Gadget Promotions\"],[\"Exclusive Wearable Discounts\",\"New Gadget Promotions\"]]','2024-08-06 21:31:32','2024-08-13 23:19:15'),(10,11,'The Looming Crisis Ahead, Will Conflict Erupt?, Global Tensions Rise, Nations on the Brink, Avoiding World War 3',NULL,NULL,NULL,1,'English (USA)',NULL,NULL,'Professional',NULL,0.50,'first',0,NULL,NULL,NULL,NULL,'2024-08-15 10:58:09','2024-08-15 10:58:50'),(11,10,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0.50,NULL,0,NULL,NULL,NULL,NULL,'2024-08-16 10:30:25','2024-08-16 10:30:25'),(12,12,'AI Productivity Tools Transformation, Automation: Future Innovation Impact, Technology-Impact on Productivity Enhancement','Automation, Machine Learning, Future Innovation, Productivity Enhancement, AI-evolution, future-prospects, productivity-enhancement, technology-impact','\"[\\\"AI Tools as Catalysts for Organizational Growth\\\",\\\"Transformative Effects of AI on Productivity\\\",\\\"Future Trends in AI-driven Productivity Tools\\\",\\\"Assessing the Benefits of AI in Business Processes\\\",\\\"Automation and Its Role in Modern Workplaces\\\"]\"',NULL,5,'English (USA)','https://ai.zybertron.com/images/wizard-image-dd76LyFN30.png','Create an image for unleashing the power of AI','Professional',NULL,0.50,'first',0,'AI Productivity Utility Tools, automation, future innovation, productivity enhancement, technology-impact','AI Productivity Tools Transformation','[\"AI Tools as Catalysts for Organizational Growth\",\"Transformative Effects of AI on Productivity\",\"Assessing the Benefits of AI in Business Processes\",\"Future Trends in AI-driven Productivity Tools\",\"Automation and Its Role in Modern Workplaces\"]','[[\"AI Productivity Utility Tools driving automation and efficiency.\",\"Future innovation through AI Productivity Utility Tools.\",\"Technology-impact on productivity enhancement with AI.\"],[\"AI Productivity Utility Tools drive productivity enhancement through automation.\",\"Future innovation in AI Productivity Utility Tools impacts technology-impact.\",\"Automation with AI Productivity Utility Tools revolutionizes productivity enhancement.\"],[\"AI Productivity Utility Tools driving future innovation in workplaces.\",\"Automation in AI tools enhancing productivity and efficiency.\",\"Future innovation in AI technology-impacting productivity enhancement.\"],[\"AI Productivity Utility Tools drive productivity enhancement.\",\"Automation through AI reduces operational inefficiencies.\",\"Future innovation relies on AI technology-impact.\"],[\"AI Productivity Utility Tools revolutionizing workplace automation.\",\"Future innovation driven by AI Productivity Utility Tools.\",\"Technology-impact on productivity enhancement through automation.\"]]','2024-08-17 15:39:36','2024-08-17 16:03:35'),(13,12,'AI Revolution: Boosting Efficiency and Automation with Deep Learning, Innovating Healthcare and Education Through Neural Networks and Data Security, Employment and Productivity in the Age of AI: Technology\'s Dual Impact, Automation and Employment: The AI Revolution in Productivity, Innovative Data Utilization: AI\'s Influence on Employment, AI Driven Automation: Boosting Productivity and Employment Trends, Automation in AI: Boosting Productivity and Innovation, Data-Driven Technology: The Evolution of AI Automation, AI\'s Impact on Technology: Productivity and Data Innovation, Automation and Productivity: The AI Technology Revolution, The Role of Data in Driving AI Innovation, AI Technology: Transforming Productivity through Automation, Innovation and Automation: AI Transforming Productivity, How AI Technology Boosts Productivity through Data Analysis, The Evolution of AI: Data-Driven Innovation in Automation','Automation, Efficiency, Ethics, Innovation, Employment, Cybersecurity, Healthcare, Education, Productivity, Data, Machine Learning, Automation, Neural Networks, Deep Learning, Robotics, Algorithms, Big Data, Innovation, Technology, Ethics, Automation, Machine Learning, Robotics, Innovation, Ethics, Machine learning, Automation, Ethics, Algorithms, Innovation','\"[\\\"Transforming Business Models with AI Automation\\\",\\\"Maximizing Output through Intelligent Systems\\\",\\\"Harnessing Data for Predictive Automation\\\",\\\"Cutting-edge AI Innovations in Industry\\\",\\\"The Evolution of Automation Technology\\\"]\"',NULL,5,'English (USA)','https://ai.zybertron.com/images/wizard-image-V5tKL2ATyp.png','AI assisting humans productivity','Professional',NULL,0.50,'first',0,'automation, productivity, data, innovation, technology','Automation in AI: Boosting Productivity and Innovation','[\"Transforming Business Models with AI Automation\",\"Maximizing Output through Intelligent Systems\",\"Harnessing Data for Predictive Automation\",\"Cutting-edge AI Innovations in Industry\",\"The Evolution of Automation Technology\"]','[[\"AI automation enhances productivity through advanced data-driven technology.\",\"Innovative business models leverage automation for increased productivity and innovation.\"],[\"Automation enhances productivity by leveraging advanced AI technology.\",\"Data-driven innovation through intelligent systems boosts productivity.\"],[\"Leveraging data-driven automation to enhance productivity and innovation.\",\"Utilizing advanced technology for predictive automation in AI.\"],[\"Automation driving productivity through cutting-edge AI technologies.\",\"Leveraging data for innovation in AI-driven automation.\"],[\"Automation technology enhances productivity through AI-driven data analysis.\",\"Innovative automation technology accelerates innovation in various industries.\"]]','2024-08-17 16:09:11','2024-08-29 11:10:29'),(14,8,'AI Futures: The Path Forward in Technology, Innovation in AI: Shaping Tomorrow\'s Automation, The Role of Intelligence in Future AI Development, Emerging Trends in AI Applications, Ethical Considerations for the Future of AI, Automation Revolution: The Future of Technology, The Next Wave of AI Innovations and Trends, AI\'s Impact on Future Technologies and Ethics, Exploring AI Development: Future Trends and Applications, The Ethical Landscape of AI and Its Future','AI, futures, technology, innovation, automation, intelligence, trends, ethics, development, applications','\"[\\\"The Role of AI in Modern Healthcare\\\",\\\"AI in Financial Services: Opportunities and Challenges\\\",\\\"Transforming Education with AI\\\",\\\"AI-driven Innovations in Retail\\\"]\"',NULL,5,'English (USA)','https://ai.zybertron.com/images/wizard-image-BZNO70WPdn.png','Ai and its future, man and woman in lab using AI,  realistic image,','Professional',NULL,0.50,'first',0,'AI, futures, technology, innovation, automation, intelligence, trends, ethics, development, applications,','Emerging Trends in AI Applications','[\"The Role of AI in Modern Healthcare\",\"AI in Financial Services: Opportunities and Challenges\",\"Transforming Education with AI\",\"AI-driven Innovations in Retail\"]','[[\"AI-driven diagnostics revolutionizing future healthcare applications.\",\"Ethics in AI development critical for healthcare innovation.\"],[\"AI futures: Shaping financial services through automation and intelligence.\",\"Ethics in AI applications: Balancing innovation with responsible development.\"],[\"AI-driven automation reshaping educational futures and innovative learning trends.\",\"Ethics in AI development: ensuring responsible technology in education.\"],[\"AI-driven automation revolutionizing retail futures and trends.\",\"Ethical AI development crucial for future retail innovation.\"]]','2024-08-28 22:53:27','2024-08-30 12:48:58'),(15,12,'Automation Through Machine Learning, AI Technology Boosts Efficiency, Data-Driven AI Advances','Automation, Technology, Innovation, Algorithms, Robotics, Efficiency, Machine Learning, Data, Ethics, Intelligence','\"[\\\"AI-Powered Tools for Business Optimization\\\",\\\"Data Analytics for Performance Improvement\\\",\\\"Machine Learning Models for Predictive Analysis\\\",\\\"Technology Integration for Operational Excellence\\\"]\"',NULL,5,'English (USA)','https://ai.zybertron.com/images/wizard-image-6nLlVytMjA.png','AI technology, tribal and common man using AI Technology','Professional',NULL,0.50,'first',0,'automation, technology, data, machine learning, efficiency','AI Technology Boosts Efficiency','[\"AI-Powered Tools for Business Optimization\",\"Data Analytics for Performance Improvement\",\"Machine Learning Models for Predictive Analysis\",\"Technology Integration for Operational Excellence\"]','[[\"Automation streamlines operations, enhancing efficiency through AI technology.\",\"Machine learning leverages data to optimize business processes efficiently.\"],[\"Automation in AI technology enhances data-driven efficiency.\",\"Machine learning optimizes performance through advanced data analytics.\"],[\"Automation in machine learning enhances data processing efficiency.\",\"AI technology boosts predictive analysis through advanced data models.\"],[\"Automation streamlines processes, increasing efficiency and accuracy.\",\"Machine learning enhances data analysis for operational excellence.\"]]','2024-08-29 11:13:46','2024-08-29 12:55:29'),(16,12,'AI: Evolution and Impact, Machine Learning Innovation, Ethics in Automation AI','AI, machine learning, deep learning, automation, robotics, algorithms, neural networks, big data, ethics, innovation','\"[\\\"Historical Development of AI\\\",\\\"Key Innovations in AI Technology\\\",\\\"Impact of AI on Modern Industries\\\"]\"',NULL,5,'English (USA)','https://ai.zybertron.com/images/wizard-image-ZKIhhhVzpv.png','AI in Future, Human walking on Streets','Professional',NULL,0.50,'first',0,'AI, machine learning, deep learning, automation, robotics, algorithms, neural networks, big data, ethics, innovation,','AI: Evolution and Impact','[\"Historical Development of AI\",\"Key Innovations in AI Technology\",\"Impact of AI on Modern Industries\"]','[[\"Early AI algorithms and neural networks innovation\",\"Machine learning and deep learning transforming automation\",\"\"],[\"Advancements in machine learning and deep learning algorithms.\",\"Ethical considerations in AI-driven automation and robotics.\"],[\"AI-driven automation reshaping traditional industry workflows.\",\"Machine learning algorithms enhancing data-driven decision making.\"]]','2024-08-29 12:56:39','2024-08-30 16:35:30'),(17,8,'Affordable Multi-Device Video Streaming Platform, Zyberflix: Netflix Clone with 12 Months of Support, User-Friendly On-Demand VOD Script App, White-Label OTT Script with 24 Months of Updates, Affordable Video Streaming Platform: 12 Months of Support, User-Friendly On-Demand App: Netflix Clone Features, Multi-Device VOD Script: 24 Months of Updates Included, White-Label OTT Script for Movies: Seamless Multi-Device Access','streaming, movies, series, subscription, entertainment, library, app, binge, films, content, streaming, movies, shows, series, entertainment, app, online, video, service, subscription, digital, film, TV, on-demand, platform, content, binge, library, episodes, access, quality, stream, download, watchlist, premium, compatible, affordable, HD, 4K, ad-free, originals, catalog, technology, updates, user-friendly, trending, genres, subtitles, multi-device, personalized, seamless, interface, mobile, browser, smart TV, Chromecast, Roku, Firestick','\"[\\\"Creating a Seamless User Experience\\\",\\\"Comparing Various On-Demand Platforms\\\",\\\"The Role of Multi-Device Accessibility\\\",\\\"Customizing with White-Label Solutions\\\",\\\"Maximizing ROI with Affordable VOD Scripts\\\"]\"',NULL,5,'English (USA)','https://ai.zybertron.com/images/wizard-image-4CH07edrx8.png','OTT Platform Logos','Professional',NULL,0.50,'first',0,'on-demand, platform, app, movies, affordable, user-friendly, multi-device, white-label OTT script, VOD script, Video Streaming Platform, Netflix Clone,  12 months of support and 24 months of updates','User-Friendly On-Demand VOD Script App','[\"Creating a Seamless User Experience\",\"Comparing Various On-Demand Platforms\",\"The Role of Multi-Device Accessibility\",\"Customizing with White-Label Solutions\",\"Maximizing ROI with Affordable VOD Scripts\"]','[[\"Affordable on-demand VOD script for multi-device platforms.\",\"User-friendly Netflix Clone with 12 months of support.\"],[\"Compare on-demand platforms for user-friendly VOD script apps.\",\"Explore affordable Netflix Clone with 12 months support.\"],[\"Enhance on-demand access with multi-device VOD script.\",\"Affordable Netflix Clone supports 12 months of updates.\"],[\"Customize your platform with a white-label OTT script.\",\"Affordable Netflix Clone app with 12 months of support.\"],[\"Maximize ROI with affordable, user-friendly VOD script app.\",\"Deploy on-demand movies on multi-device video streaming platform.\"]]','2024-08-30 12:51:33','2024-11-06 19:37:12'),(18,14,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0.50,NULL,0,NULL,NULL,NULL,NULL,'2024-09-09 12:13:10','2024-09-09 12:13:10'),(19,15,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0.50,NULL,0,NULL,NULL,NULL,NULL,'2024-09-11 21:44:15','2024-09-11 21:44:15'),(20,19,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0.50,NULL,0,NULL,NULL,NULL,NULL,'2024-09-18 00:25:22','2024-09-18 00:25:22'),(21,16,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0.50,NULL,0,NULL,NULL,NULL,NULL,'2024-09-19 11:14:01','2024-09-19 11:14:01'),(22,12,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0.50,NULL,0,NULL,NULL,NULL,NULL,'2024-10-05 17:53:15','2024-10-05 17:53:15'),(23,8,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0.50,NULL,0,NULL,NULL,NULL,NULL,'2024-11-06 19:38:12','2024-11-06 19:38:12'),(24,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,0.50,NULL,0,NULL,NULL,NULL,NULL,'2024-11-26 15:30:17','2024-11-26 15:30:17');

--
-- Table structure for table `blogs`
--

CREATE TABLE `blogs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_by` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` longtext COLLATE utf8mb4_unicode_ci,
  `title` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `keywords` longtext COLLATE utf8mb4_unicode_ci,
  `body` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blogs`
--


--
-- Table structure for table `brand_voices`
--

CREATE TABLE `brand_voices` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `website` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `products` longtext COLLATE utf8mb4_unicode_ci,
  `total` int NOT NULL DEFAULT '0',
  `audience` text COLLATE utf8mb4_unicode_ci,
  `tagline` text COLLATE utf8mb4_unicode_ci,
  `industry` text COLLATE utf8mb4_unicode_ci,
  `description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `brand_voices`
--

INSERT INTO `brand_voices` VALUES (1,10,'Ghouse1','Ghouse.com','Professional','[{\"name\":\"IT sales\",\"description\":null,\"type\":\"product\"}]',1,'MNC salaried employees and businessman. youth college student, Family groups',NULL,'IT','Companies provides IT sales and software services in web and mobile applications.','2024-08-03 23:52:09','2024-08-03 23:52:09'),(2,11,'protonix','www.protonix.com','Professional','[{\"name\":\"protonix smart watches , earphones\",\"description\":\"We are a company that specializes in creating wearable technology starting from smart watches, Headphones and Earphones, fitness bands\",\"type\":\"product\"}]',1,'entrepruners, people with White collar jobs','Wear the future','Electronic wearables','we produce wearables like smartwatches, smart shoes, smart keys, smart bracelets etc...','2024-08-15 13:37:33','2024-08-15 13:37:33'),(3,12,'Protonix','protonix.com','Professional','[{\"name\":\"Protnix\",\"description\":\"we are a electronic wear manufacturing company with innovative idea and design to match top class quality.\",\"type\":\"product\"}]',1,'office goers, teenagers, premium brand owners','Wear it, Feel it','electronics','we are a electronic wear manufacturing company with innovative idea and design to match top class quality.','2024-08-30 16:08:31','2024-08-30 16:08:31'),(4,16,'doo.world','Doo.world','Engaging','[{\"name\":\"ninja saas\",\"description\":\"saas\",\"type\":\"service\"}]',2,'all','giving back','value added services and revenue sharing applications','delivering value added services and revenue sharing applications','2024-09-17 23:42:26','2024-09-17 23:42:26'),(5,8,'ZyberTaxi','https://www.zybertron.com/uber-clone-script','Professional','[]',1,'Entreprenuers , Startups','Uber Clone - Bring your Ride-Hailing Business into Reality','ride-hailing service Software','Introducing a cutting-edge taxi booking app solution designed to empower entrepreneurs in the ride-hailing industry.  ZyberTaxi offers a state-of-the-art Uber clone application packed with essential features and impressive interfaces, making it easier to establish and expand your taxi business. Our advanced technology simplifies launching and managing a taxi fleet, improving overall business efficiency.','2024-11-06 18:17:18','2024-11-06 18:17:18'),(6,8,'ZyberDelivery','https://www.zybertron.com/ubereats-clone-script','Professional','[]',1,'Entreprenuers , Startups','Bring your Food delivery Business into real-time action.','Food delivery software','Transform your food delivery business with our UberEats Clone App. Our script is built on a successful framework, ensuring a top-notch user experience and incorporating a robust UberEats clone script. With the ability to efficiently handle high volumes of activities, our ZyberDelievry -UberEats like app includes unique features that will bolster your business ideas and help you reach your goals faster.','2024-11-06 18:25:53','2024-11-06 18:25:53'),(7,1,'Zybertron','https://www.zybertron.com/','Professional','[{\"name\":\"ZyberTaxi\",\"description\":\"Uber Clone Application, Software and Mobile Application\",\"type\":\"product\"},{\"name\":\"ZyberDelivery\",\"description\":\"Ubereats Clone Application, Software and Mobile Application\",\"type\":\"product\"},{\"name\":\"ZyberFlix\",\"description\":\"Netflix Clone, Software and Mobile Application\",\"type\":\"product\"},{\"name\":\"ZyberAI\",\"description\":\"ChatGPT Clone, Software Application\",\"type\":\"product\"}]',4,'Start ups, Business owners, Entrepreneur','Empowering Businesses with Seamless Solutions','Mobile Application Development, Clone Apps','Zybertron is a leading development company with ready-for-market clone app scripts and delivers custom Web and Mobile applications. we specialize in developing tailored digital platforms that drive business growth and Quick market penetration. Our approach combines industry insight with cutting-edge technology to deliver Scalable, Robust and Efficient Applications. we specialize in constructing frameworks for On-Demand Applications that align with these customer expectations. Our expertise enables you to swiftly enter the market with these applications, saving you time and resources that would be spent on developing from the ground up. Our ready-to-launch apps are built with latest technologies and are adept for complete customization to suit your business needs.','2024-11-29 13:15:22','2024-11-29 13:46:23');

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

CREATE TABLE `categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `categories` VALUES (1,'Blog Posts','blog','original','Content for the generating articles, blog post','2024-07-18 08:00:38','2024-07-18 08:00:38'),(2,'Emails','email','original','Creative templates for email creation','2024-07-18 08:00:38','2024-07-18 08:00:38'),(3,'Other','other','original','Rest of the user tools that you can use','2024-07-18 08:00:38','2024-07-18 08:00:38'),(4,'Social Media','social','original','Flash tools for social media content','2024-07-18 08:00:38','2024-07-18 08:00:38'),(5,'Contents','text','original','Tools for writing creatives for different moods and tasks','2024-07-18 08:00:38','2024-07-18 08:00:38'),(6,'Video','video','original','Video creation tools from idea to script for millions of views','2024-07-18 08:00:38','2024-07-18 08:00:38'),(7,'Websites','web','original','Useful contents for websites','2024-07-18 08:00:38','2024-07-18 08:00:38'),(8,'Marketing','marketing','original','Professional PR tools for brand and business','2024-07-18 08:00:38','2024-07-18 08:00:38'),(9,'Ads','ad','original','Create ads much faster and be more creative','2024-07-18 08:00:38','2024-07-18 08:00:38'),(10,'SEO','seo','original','Search engine optimization related tools','2024-07-18 08:00:38','2024-07-18 08:00:38'),(11,'Frameworks','framework','original','The best marketing copywriting tools','2024-07-18 08:00:38','2024-07-18 08:00:38'),(12,'Ecommerce','ecommerce','original','Powerful tools for e-commerce, listings of your products','2024-07-18 08:00:38','2024-07-18 08:00:38');

--
-- Table structure for table `chat_categories`
--

CREATE TABLE `chat_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `chat_categories`
--

INSERT INTO `chat_categories` VALUES (1,'Business','business','original','2024-07-18 08:00:58','2024-07-18 08:00:58'),(2,'Coach','coach','original','2024-07-18 08:00:58','2024-07-18 08:00:58'),(3,'Education','education','original','2024-07-18 08:00:58','2024-07-18 08:00:58'),(4,'Health','health','original','2024-07-18 08:00:58','2024-07-18 08:00:58'),(5,'Leisure','leisure','original','2024-07-18 08:00:58','2024-07-18 08:00:58'),(6,'Specialist','specialist','original','2024-07-18 08:00:58','2024-07-18 08:00:58'),(7,'Other','other','original','2024-07-18 08:00:58','2024-07-18 08:00:58');

--
-- Table structure for table `chat_conversations`
--

CREATE TABLE `chat_conversations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `conversation_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `chat_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `messages` int DEFAULT NULL,
  `words` int DEFAULT NULL,
  `favorite` tinyint(1) NOT NULL DEFAULT '0',
  `vector_store` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `chat_conversations_user_id_foreign` (`user_id`),
  CONSTRAINT `chat_conversations_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `chat_conversations`
--

INSERT INTO `chat_conversations` VALUES (1,1,'4kkup7ozqe','VISION','AI Vision Conversation',1,26,0,NULL,'2024-07-18 16:11:44','2024-08-21 00:55:44'),(2,3,'Gzoj1ZJuHV','IMAGE','Chat Image Conversation',0,0,0,NULL,'2024-07-19 06:50:12','2024-07-19 06:50:12'),(3,3,'LgoPBFNSja','VISION','AI Vision Conversation',0,0,0,NULL,'2024-07-20 00:48:17','2024-07-20 00:48:17'),(4,3,'oxiIs93bZi','NBIDL','New Conversation',0,0,0,NULL,'2024-07-20 16:26:01','2024-07-20 16:26:01'),(5,3,'O2jvLWpotX','LBFJS','New Conversation',0,0,0,NULL,'2024-07-20 16:31:20','2024-07-20 16:31:20'),(6,7,'5Fu6YriwPr','IMAGE','NEW 1',0,0,0,NULL,'2024-07-23 08:54:52','2024-07-23 10:04:04'),(7,7,'OBj04YWCPd','IMAGE','Chat Image Conversation',1,0,0,NULL,'2024-07-23 10:04:09','2024-07-23 10:05:01'),(8,7,'ZsrfnOAogF','IMAGE','Chat Image Conversation',0,0,0,NULL,'2024-07-23 10:04:12','2024-07-23 10:04:12'),(9,7,'5UhREqE1WA','VISION','AI Vision Conversation',0,0,0,NULL,'2024-07-23 10:17:18','2024-07-23 10:17:18'),(10,8,'bRgGmB3beX','IUGJP','New Conversation',0,0,0,NULL,'2024-07-23 23:51:31','2024-07-23 23:51:31'),(11,8,'oluxmUfsuh','VISION','AI Vision Conversation',1,87,0,NULL,'2024-07-23 23:52:55','2024-07-23 23:54:33'),(12,7,'GWU5Skc9C5','AONHT','New Conversation',0,0,0,NULL,'2024-08-03 23:34:06','2024-08-03 23:34:06'),(13,9,'xJqMfM5c3N','MOHJJ','New Conversation',0,0,0,NULL,'2024-08-06 02:25:56','2024-08-06 02:25:56'),(14,9,'lWbiRMIWew','VISION','AI Vision Conversation',0,0,0,NULL,'2024-08-06 02:27:11','2024-08-06 02:27:11'),(15,9,'Asaev5sg3c','IMAGE','Chat Image Conversation',0,0,0,NULL,'2024-08-06 02:27:57','2024-08-06 02:27:57'),(16,10,'oaIP76zNwH','VISION','AI Vision Conversation',0,0,0,NULL,'2024-08-13 20:33:22','2024-08-13 20:33:22'),(17,10,'mMuoxvJFNA','VISION','New',2,32,0,NULL,'2024-08-13 20:33:31','2024-08-13 20:35:02'),(18,11,'742bQnNCI9','IMAGE','Realism',0,0,0,NULL,'2024-08-13 22:16:03','2024-08-13 22:16:28'),(19,1,'rlNoQPtcRJ','IMAGE','Chat Image Conversation',2,0,0,NULL,'2024-08-13 22:21:41','2024-08-13 22:52:20'),(20,11,'1DPHnSIRbg','IMAGE','Chat Image Conversation',0,0,0,NULL,'2024-08-13 22:24:44','2024-08-13 22:24:44'),(21,10,'JS0Vo8bV3Q','IMAGE','Chat Image Conversation',0,0,0,NULL,'2024-08-13 22:45:01','2024-08-13 22:45:01'),(22,10,'EhMRMeLSg3','LBFJS','New Conversation',2,108,0,NULL,'2024-08-13 23:38:38','2024-08-13 23:41:00'),(23,10,'27FAZ1SBHZ','VISION','AI Vision Conversation',2,24,0,NULL,'2024-08-13 23:44:22','2024-08-13 23:46:12'),(24,10,'DlnbPDX0d7','VISION','AI Vision Conversation',3,77,0,NULL,'2024-08-13 23:47:43','2024-08-15 18:26:45'),(25,11,'B6nDI13nQ2','VISION','AI Vision Conversation',0,0,0,NULL,'2024-08-14 20:12:25','2024-08-14 20:12:25'),(26,11,'pe76gHbzz7','KGYPC','New Conversation',0,0,0,NULL,'2024-08-15 15:13:25','2024-08-15 15:13:25'),(27,12,'tbOmwAnOD5','RTRZE','New Conversation',2,336,0,NULL,'2024-08-28 23:46:50','2024-08-29 11:46:37'),(28,12,'02VTD1tEF5','IMAGE','Chat Image Conversation',0,0,0,NULL,'2024-08-29 10:16:31','2024-08-29 10:16:31'),(30,12,'1wskxlK5ng','IUGJP','New Conversation',0,0,0,NULL,'2024-08-29 11:40:10','2024-08-29 11:40:10'),(31,12,'0zXqFDD1dZ','KGYPC','New Conversation',2,291,0,NULL,'2024-08-29 11:45:13','2024-08-29 11:46:04'),(32,12,'gsnXeUil1N','VISION','AI Vision Conversation',0,0,0,NULL,'2024-08-29 11:48:25','2024-08-29 11:48:25'),(34,8,'J0cjCGTgYc','IMAGE','Chat Image Conversation',4,0,0,NULL,'2024-08-30 08:52:54','2024-11-06 22:22:12'),(35,8,'5SRcYuckOM','KGYPC','New Conversation',1,406,0,NULL,'2024-08-30 13:35:49','2024-08-30 13:36:40'),(36,8,'bBhf8mj9Jt','LBFJS','New Conversation',1,448,0,NULL,'2024-08-30 13:36:56','2024-08-30 13:37:15'),(37,12,'G8FL8OesUq','LLUMQ','New Conversation',1,546,0,NULL,'2024-08-30 16:50:29','2024-08-30 16:51:35'),(38,5,'fZ3mQ43yiB','KGYPC','New Conversation',0,0,0,NULL,'2024-09-07 07:26:31','2024-09-07 07:26:31'),(39,5,'lbM3a3fCL1','KGYPC','New Conversation',0,0,0,NULL,'2024-09-07 07:26:38','2024-09-07 07:26:38'),(40,5,'a32oImkCaN','KGYPC','New Conversation',4,499,0,NULL,'2024-09-07 07:26:59','2024-09-07 07:31:19'),(41,16,'6S4eULzVJF','IMAGE','Chat Image Conversation',1,0,0,NULL,'2024-09-17 11:16:19','2024-10-11 19:46:15'),(42,16,'iqTCKccEQd','VISION','AI Vision Conversation',1,341,0,NULL,'2024-09-17 11:16:26','2024-11-07 16:23:11'),(43,16,'U9kbqJSNzD','HDOAK','New Conversation',0,0,0,NULL,'2024-09-17 11:27:37','2024-09-17 11:27:37'),(44,16,'4wcH9OdMv7','KGYPC','New Conversation',0,0,0,NULL,'2024-09-17 23:40:13','2024-09-17 23:40:13'),(45,16,'PcapOALRHp','QMVKR','New Conversation',2,657,0,NULL,'2024-09-18 17:57:37','2024-09-18 18:50:39'),(46,16,'thread_60Vgvaq4kDD5mJOxDzXywufZ','asst_MM9pSZ22JONRWNt6Vk56REFD','New Conversation',1,345,0,'vs_sKTvegImLucjYKnrwqAwXp8j','2024-09-19 11:11:48','2024-09-19 11:13:19'),(47,16,'tscoQFKReK','LXRZT','New Conversation',2,283,0,NULL,'2024-09-19 12:30:42','2024-09-19 12:31:29'),(48,16,'tujGd38546','KGEWX','New Conversation',3,446,0,NULL,'2024-09-19 14:53:34','2024-09-19 14:58:22'),(49,20,'juFAqa0Jsc','WXVQD','New Conversation',0,0,0,NULL,'2024-09-19 15:45:15','2024-09-19 15:45:15'),(50,16,'KwnGTzoEwn','IUGJP','New Conversation',2,288,0,NULL,'2024-10-21 12:12:12','2024-10-21 12:15:23'),(51,8,'J7ao103bCn','VISION','AI Vision Conversation',1,58,0,NULL,'2024-11-06 20:32:47','2024-11-06 20:33:22'),(52,8,'3CxqZFmjmz','KKMZN','New Conversation',2,448,0,NULL,'2024-11-16 13:12:16','2024-11-16 13:13:39'),(53,8,'J9eLQHtSTV','QMVKR','New Conversation',2,502,0,NULL,'2024-11-16 13:14:17','2024-11-16 13:14:42'),(54,1,'Ejpy3aCVtu','VISION','AI Vision Conversation',1,131,0,NULL,'2024-11-26 12:27:49','2024-11-26 12:28:40'),(55,1,'F0VFRBTMiH','KKMZN','New Conversation',0,0,0,NULL,'2024-11-26 13:37:48','2024-11-26 13:37:48'),(56,1,'8E6C2cNSJQ','AYHPP','New Conversation',2,19,0,NULL,'2024-11-26 13:38:02','2024-11-26 13:39:58'),(57,1,'NW8fvZrCfh','BONHA','New Conversation',0,0,0,NULL,'2024-11-26 13:40:18','2024-11-26 13:40:18'),(58,1,'FPYjEVsrOE','UOWKO','New Conversation',5,123,0,NULL,'2024-11-26 13:42:40','2024-11-26 13:52:45'),(59,1,'69dqni4Wwq','IMAGE','Chat Image Conversation',0,0,0,NULL,'2024-11-26 16:03:24','2024-11-26 16:03:24'),(60,1,'DxGdeyTNKl','KGYPC','New Conversation',0,0,0,NULL,'2024-11-26 16:26:20','2024-11-26 16:26:20'),(61,1,'LLhzdc46VT','LLUMQ','New Conversation',0,0,0,NULL,'2024-11-26 16:26:38','2024-11-26 16:26:38'),(63,1,'BXrokq8QmQ','UOWKO','New Conversation',3,20,0,NULL,'2024-11-30 16:31:39','2024-11-30 16:33:54'),(65,1,'6wSxI34fx8','UOWKO','New Conversation',0,0,0,NULL,'2024-11-30 23:14:40','2024-11-30 23:14:40'),(66,1,'CkCWm48Hdt','UOWKO','New Conversation',0,0,0,NULL,'2024-12-03 13:27:54','2024-12-03 13:27:54');

--
-- Table structure for table `chat_histories`
--

CREATE TABLE `chat_histories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `conversation_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `response` longtext COLLATE utf8mb4_unicode_ci,
  `prompt` longtext COLLATE utf8mb4_unicode_ci,
  `words` int DEFAULT NULL,
  `images` longtext COLLATE utf8mb4_unicode_ci,
  `model` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `input_tokens` int NOT NULL DEFAULT '0',
  `output_tokens` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `chat_histories_user_id_foreign` (`user_id`),
  CONSTRAINT `chat_histories_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `chat_histories`
--

INSERT INTO `chat_histories` VALUES (1,7,'OBj04YWCPd','https://ai.zybertron.com/images/chat-image-AoCaQ0wKYs.png','CREATE AN IMAGE WITH JESUS BLESSING HUMANS',0,NULL,NULL,0,0,'2024-07-23 10:04:45','2024-07-23 10:05:01'),(2,8,'oluxmUfsuh','The image shows a bustling street scene from what appears to be a historical Asian town or city, possibly during the late 19th or early 20th century. The architectural style of the buildings, with their wooden facades and balconies, hints at a Southeast Asian setting, potentially in a country like the Philippines, Thailand, or Malaysia. The presence of rickshaws and traditional attire of the people suggests an Asian context as well. However, without more specific details or landmarks, it is difficult to pinpoint the exact location.','which place is this image taken',86,'data:image/png;base64,[encoded data, 481206 characters]