-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jul 01, 2024 at 11:54 AM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.2.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `ai_staging`
--

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

--
-- Table structure for table `tools`
--

CREATE TABLE `tools` (
  `id` int(11) NOT NULL,
  `name` varchar(251) NOT NULL,
  `is_upload` int(11) NOT NULL,
  `is_live` int(11) NOT NULL,
  `type` int(11) NOT NULL COMMENT '0=> Live, 1 => Upload, 2=> Both',
  `live_prompt` text NOT NULL,
  `upload_prompt` text NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp(),
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tools`
--

INSERT INTO `tools` (`id`, `name`, `is_upload`, `is_live`, `type`, `live_prompt`, `upload_prompt`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Summary', 1, 1, 2, 'Go through the whole transcription of this video and write a summary highlighting the key take aways from all the speakers. Cover all the speaker statements in a sequence. What are the key highlights or the result from all the deliberations. Write them clearly for mass audience to understand.\n', 'Go through the whole transcription of this video and write a summary highlighting the key take aways from all the speakers. Cover all the speaker statements in a sequence. What are the key highlights or the result from all the deliberations. Write them clearly for mass audience to understand.\n', 1, '2024-06-20 14:53:53', '2024-06-20 18:56:00', NULL),
(2, 'Newsletter', 1, 1, 2, 'Go through the whole transcription of this video and write a catchy newsletter for the industry to understand the key takeaways from the video. Do cover all the important points and highlight the same. Add a relevant call to action at the end also. Understand the context and give at least 2 options.', 'Go through the whole transcription of this video and write a catchy newsletter for the industry to understand the key takeaways from the video. Do cover all the important points and highlight the same. Add a relevant call to action at the end also. Understand the context and give at least 2 options.', 1, '2024-06-20 14:54:34', '2024-06-20 15:12:43', NULL),
(3, 'Emailer', 1, 0, 1, '', '', 0, '2024-06-20 14:55:20', '2024-06-20 16:14:20', NULL),
(4, 'Report', 1, 0, 1, '', '', 0, '2024-06-20 14:55:38', '2024-06-20 15:12:56', NULL),
(5, 'LinkedIn Article', 1, 1, 2, 'Go through the whole transcription of this video and write a catchy LinkedIn Article for the industry to understand the key takeaways from the video. Do cover all the important points and highlight the same. Add a relevant call to action at the end also. Add relevant hast tags\n', 'Go through the whole transcription of this video and write a catchy LinkedIn Article for the industry to understand the key takeaways from the video. Do cover all the important points and highlight the same. Add a relevant call to action at the end also. Add relevant hast tags\n', 1, '2024-06-20 14:55:54', '2024-06-20 18:56:26', NULL),
(6, 'LinkedIn Post', 1, 1, 2, 'Go through the whole transcription of this video and write a catchy LinkedIn Post for the industry to understand the key takeaways from the video. Do cover all the important points and highlight the same. Add a relevant call to action at the end also. Add relevant hast tags', 'Go through the whole transcription of this video and write a catchy LinkedIn Post for the industry to understand the key takeaways from the video. Do cover all the important points and highlight the same. Add a relevant call to action at the end also. Add relevant hast tags', 1, '2024-06-20 14:56:11', '2024-06-25 14:14:59', NULL),
(7, 'Instagram Reel ideas', 1, 1, 2, 'Go through the whole transcription of this video and give 2 Instagram reel ideas and scripts', 'Go through the whole transcription of this video and give 2 Instagram reel ideas and scripts', 1, '2024-06-20 14:56:22', '2024-06-25 14:15:02', NULL),
(8, 'Instagram Post (Caption and Catchy Line)', 1, 0, 1, '', '', 0, '2024-06-20 14:56:34', '2024-06-20 15:13:29', NULL),
(9, 'YouTube Shorts Script', 1, 1, 2, 'Go through the whole transcription of this video , we want to make 4 highlight YouTube shorts from this video. Please share the scripts and the parts to take from the video to make the YouTube Shorts', 'Go through the whole transcription of this video , we want to make 4 highlight YouTube shorts from this video. Please share the scripts and the parts to take from the video to make the YouTube Shorts', 1, '2024-06-20 14:56:45', '2024-06-25 14:15:06', NULL),
(10, 'YouTube trailer Video Script', 1, 0, 2, 'Go through the whole transcription of this video , we want to make a Yoube Trailer Video Script from this video. Please share the scripts and the parts to take from the video to make the YouTube Shorts', 'Go through the whole transcription of this video , we want to make a Yoube Trailer Video Script from this video. Please share the scripts and the parts to take from the video to make the YouTube Shorts', 1, '2024-06-20 14:56:57', '2024-06-25 14:15:08', NULL),
(11, 'Tweets', 1, 1, 2, '      Please craft a detailed tweet capturing important information and facts from the following speaker\'s words in 280 characters Make sure to maintain an engaging tone to attract interactions and retweets.', '      Please craft a detailed tweet capturing important information and facts from the following speaker\'s words in 280 characters Make sure to maintain an engaging tone to attract interactions and retweets.', 1, '2024-06-20 14:57:10', '2024-06-20 15:13:37', NULL),
(12, 'Press Release', 1, 1, 2, 'Go through the whole transcription of this video, we want to write a professional, official press release for the video. This video would be created from the event or webinar. Please write a detailed and catchy formal Press release.', 'Go through the whole transcription of this video, we want to write a professional, official press release for the video. This video would be created from the event or webinar. Please write a detailed and catchy formal Press release.', 1, '2024-06-20 14:57:22', '2024-06-25 14:33:08', NULL),
(13, 'Blog', 1, 1, 2, 'Go through the whole transcription of this video, we want to write interesting SEO ready Blogs. Write an 800 words blog for the website. This should be interesting and professional in tone.', 'Go through the whole transcription of this video, we want to write interesting SEO ready Blogs. Write an 800 words blog for the website. This should be interesting and professional in tone.', 1, '2024-06-20 14:57:32', '2024-06-25 14:15:12', NULL),
(14, 'Live Tweeting', 0, 1, 0, 'We are doing the live tweeting of an event, write quote tweets from the speakers reading at least 1 full paragraph and quote them as it is, do not change words. You need to take out the most relevant and positive statements only from their speech. With the tweet give their full name and designation and hashtags on the topic. Write at least 3 options each. ', 'We are doing the live tweeting of an event, write quote tweets from the speakers reading at least 1 full paragraph and quote them as it is, do not change words. You need to take out the most relevant and positive statements only from their speech. With the tweet give their full name and designation and hashtags on the topic. Write at least 3 options each. ', 1, '2024-06-20 14:59:40', '2024-06-25 14:15:14', NULL);

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `tools`
--
ALTER TABLE `tools`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
