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

START TRANSACTION;



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

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

CREATE TABLE `categories` (
  `id` bigint UNSIGNED NOT NULL,
  `category_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `category_image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `categories` (`id`, `category_name`, `category_image`, `created_at`, `updated_at`) VALUES
(8, 'category 1', '1663491854.jpg', '2022-09-07 05:46:54', '2022-09-18 09:04:14'),
(9, 'category 2', '1665385216.jpg', '2022-09-07 06:19:44', '2022-10-10 07:00:16'),
(10, 'Songs', '1663576811.jpg', '2022-09-19 08:40:11', '2022-09-19 08:40:11');

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

--
-- Table structure for table `items`
--

CREATE TABLE `items` (
  `id` bigint UNSIGNED NOT NULL,
  `cat_id` bigint UNSIGNED NOT NULL,
  `video_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `video_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `video_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `video_thumbnail` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `video_duration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `video_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `video_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `size` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_views` int NOT NULL,
  `date_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `items`
--

INSERT INTO `items` (`id`, `cat_id`, `video_title`, `video_url`, `video_id`, `video_thumbnail`, `video_duration`, `video_description`, `video_type`, `size`, `total_views`, `date_time`, `created_at`, `updated_at`) VALUES
(29, 8, 'Puthiyoru Lokam Video Song | Hridayam', '2094072682.mp4', 'cda11up', '1666868373.webp', '00:00', '<span style=\"font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;\">Song: Puthiyoru Lokam \r\nSong composed, arranged, and programmed by Hesham Abdul Wahab\r\nSung by Vimal Roy and Bhadra Rajin\r\nLyrics by Kaithapram\r\nAdditional Vocals by Suroor Musthafa, Sara Maria Rose,\r\nAdwaith B Kumar and Amrutha KS\r\n\r\nSong mixed by Harishankar V at My Studio (Cochin)\r\nMix assisted by Akshay Kakkoth\r\nMy Studio sessions are managed by Murali Krishna Nair</span>', 'Upload', '20.20 MB', 13, '2022-09-07 10:37:44', '2022-09-07 10:37:44', '2022-10-27 10:59:33'),
(31, 9, 'Firebase Realtime Database Tutorial for Android(MVP)', 'https://www.youtube.com/watch?v=VUCbPZGjdzA', 'VUCbPZGjdzA', '1663487682.jpg', '00:05', '<div><span style=\"font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;\">-Fetching the stored data from Firebase Database</span><br></div><div><span style=\"font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;\">-Displaying the Fetched Items in a recycler view</span><br></div>', 'Youtube', '', 1, '2022-09-18 07:21:03', '2022-09-18 07:21:03', '2022-10-19 07:57:08'),
(32, 9, 'কোন ডিজিটাল স্কিলগুলো একুশ শতকে ম্যাটার করে', 'https://www.youtube.com/watch?v=EerV9PW7yto', 'EerV9PW7yto', '1663488460.jpg', '00:00', '<span style=\"font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;\">বহুব্রীহির কো</span><span style=\"font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;\">বহুব্রীহির কোর্সগুলো চেক করতে পারেন এই লিংকেঃ</span><span style=\"font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;\">র্সগুলো চেক করতে পারেন এই লিংকেঃ</span>', 'Youtube', '', 1, '2022-09-18 08:07:40', '2022-09-18 08:07:40', '2022-10-10 07:42:43'),
(33, 10, '96 Songs | The Life of Ram Video Song', 'https://www.youtube.com/watch?v=6LD30ChPsSs', '6LD30ChPsSs', '1663576910.jpg', '00:00', '<span dir=\"auto\" class=\"style-scope yt-formatted-string\" style=\"margin: 0px; padding: 0px; border: 0px; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;\">Madras Enterprises presents \"96\" Tamil Movie Songs\r\n\r\n96 Songs | </span><a class=\"yt-simple-endpoint style-scope yt-formatted-string\" spellcheck=\"false\" href=\"https://www.youtube.com/hashtag/thelifeofram\" dir=\"auto\" style=\"display: var(--yt-endpoint-display,inline-block); cursor: pointer; text-decoration: var(--yt-endpoint-text-regular-decoration,none); overflow-wrap: var(--yt-endpoint-word-wrap,none); word-break: var(--yt-endpoint-word-break,none); font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;\">#TheLifeofRam</a><span dir=\"auto\" class=\"style-scope yt-formatted-string\" style=\"margin: 0px; padding: 0px; border: 0px; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;\"> Video Song | </span><a class=\"yt-simple-endpoint style-scope yt-formatted-string\" spellcheck=\"false\" href=\"https://www.youtube.com/hashtag/vijaysethupathi\" dir=\"auto\" style=\"display: var(--yt-endpoint-display,inline-block); cursor: pointer; text-decoration: var(--yt-endpoint-text-regular-decoration,none); overflow-wrap: var(--yt-endpoint-word-wrap,none); word-break: var(--yt-endpoint-word-break,none); font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;\">#VijaySethupathi</a><span dir=\"auto\" class=\"style-scope yt-formatted-string\" style=\"margin: 0px; padding: 0px; border: 0px; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;\">, </span><a class=\"yt-simple-endpoint style-scope yt-formatted-string\" spellcheck=\"false\" href=\"https://www.youtube.com/hashtag/trisha\" dir=\"auto\" style=\"display: var(--yt-endpoint-display,inline-block); cursor: pointer; text-decoration: var(--yt-endpoint-text-regular-decoration,none); overflow-wrap: var(--yt-endpoint-word-wrap,none); word-break: var(--yt-endpoint-word-break,none); font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;\">#Trisha</a><span dir=\"auto\" class=\"style-scope yt-formatted-string\" style=\"margin: 0px; padding: 0px; border: 0px; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;\"> | </span><a class=\"yt-simple-endpoint style-scope yt-formatted-string\" spellcheck=\"false\" href=\"https://www.youtube.com/hashtag/govindvasantha\" dir=\"auto\" style=\"display: var(--yt-endpoint-display,inline-block); cursor: pointer; text-decoration: var(--yt-endpoint-text-regular-decoration,none); overflow-wrap: var(--yt-endpoint-word-wrap,none); word-break: var(--yt-endpoint-word-break,none); font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;\">#GovindVasantha</a><span dir=\"auto\" class=\"style-scope yt-formatted-string\" style=\"margin: 0px; padding: 0px; border: 0px; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;\"> | C. Prem Kumar\r\n\r\n#96 Ringback Tunes ► </span><a class=\"yt-simple-endpoint style-scope yt-formatted-string\" spellcheck=\"false\" href=\"https://www.youtube.com/redirect?event=video_description&amp;redir_token=QUFFLUhqa0JDSGhZZVZFY2E2cWdDZjJ5OWtQUGFIbEVkZ3xBQ3Jtc0trQlA3U3ZwSWlvR1E0Nmo2Mi0xbWEzZWhIQk9aZUpfcmRqM0dScEFaOU9sRUtkYjdyY05pSGppbW92VHBwMzhnOVdUSDZpOG0zYUUyNXVoLUNtV05hQW80UmQwY3ZEenI5Y2h4bF9QUjRnSzFGbUtFWQ&amp;q=https%3A%2F%2Fbit.ly%2F2woIXyu&amp;v=6LD30ChPsSs\" rel=\"nofollow\" target=\"_blank\" dir=\"auto\" style=\"display: var(--yt-endpoint-display,inline-block); cursor: pointer; text-decoration: var(--yt-endpoint-text-regular-decoration,none); overflow-wrap: var(--yt-endpoint-word-wrap,none); word-break: var(--yt-endpoint-word-break,none); font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;\">https://bit.ly/2woIXyu</a>', 'Youtube', '', 0, '2022-09-19 08:41:50', '2022-09-19 08:41:50', '2022-09-19 08:41:50'),
(35, 8, 'testting2222', 'https://youtu.be/QKW7_jOjTQ8', 'QKW7_jOjTQ8', NULL, '00:00', 'asdew', 'Youtube', '', 8, '2022-10-03 10:37:18', '2022-10-03 10:37:18', '2022-10-30 12:33:09'),
(36, 9, 'hsabhjb', 'https://www.youtube.com/watch?v=bTdW0hoz-J4', 'bTdW0hoz-J4', NULL, '00:00', 'sgsgsggs', 'Youtube', '', 4, '2022-10-03 10:53:24', '2022-10-03 10:53:24', '2022-10-30 12:25:18'),
(37, 8, 'rerer', 'https://ndtv24x7elemarchana.akamaized.net/hls/live/2003678/ndtv24x7/ndtv24x7master.m3u8', 'zpOULjyy-n8', '1664795149.jpg', '00:00', 'agagsf', 'Url', '', 14, '2022-10-03 11:05:49', '2022-10-03 11:05:49', '2022-10-27 10:37:36');

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

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

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(60, '2021_04_20_051617_create_regusers_table', 3),
(64, '2014_10_12_000000_create_users_table', 6),
(67, '2021_03_21_120852_create_admins_table', 6),
(69, '2021_06_21_062028_create_advertisements_table', 7),
(80, '2021_06_21_101831_create_settings_table', 8),
(81, '2021_06_24_112246_create_tokens_table', 8),
(82, '2021_06_29_060235_create_notifications_table', 8),
(88, '2021_07_14_080503_create_url_types_table', 8),
(89, '2021_07_14_090933_create_user_agent_types_table', 8),
(90, '2021_07_15_120252_create_token_types_table', 9),
(92, '2022_07_18_131753_create_categories_table', 11),
(95, '2021_05_27_075818_create_sliders_table', 13),
(96, '2022_07_19_064520_create_items_table', 14);

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

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notifications`
--

INSERT INTO `notifications` (`id`, `title`, `message`, `url`, `image_url`, `created_at`, `updated_at`) VALUES
(1, 'Hair Cut', 'asdgfhjhhhgf', 'https://www.google.com/', 'https://i.pinimg.com/736x/5c/a9/6f/5ca96fe550aab0f2cc2768d3dee9417d.jpg', '2021-07-25 04:46:15', '2021-07-25 04:46:15'),
(2, 'ashbfdjhb', 'sdjbkjdbnkj', 'cdsbckjbn', 'https://i.pinimg.com/736x/5c/a9/6f/5ca96fe550aab0f2cc2768d3dee9417d.jpg', '2022-07-20 10:27:12', '2022-07-20 10:27:12'),
(3, 'hi', 'hello', 'how r you', 'https://i.pinimg.com/736x/5c/a9/6f/5ca96fe550aab0f2cc2768d3dee9417d.jpg', '2022-09-07 05:14:50', '2022-09-07 05:14:50'),
(4, 'test', 'hello', 'https://www.youtube.com/watch?v=P2ra45c4Gp4', 'https://media.istockphoto.com/vectors/hand-holding-mobile-phone-with-new-email-icon-vector-illustration-vector-id1256767138?k=20&m=1256767138&s=612x612&w=0&h=CCNflxf6O4nT2g2vYyAljOaNGTJBXpvPj6t4bQhfh44=', '2022-09-18 09:13:55', '2022-09-18 09:13:55'),
(5, 'test', 'go ahead', 'https://www.youtube.com/watch?v=P2ra45c4Gp4', 'https://media.istockphoto.com/vectors/hand-holding-mobile-phone-with-new-email-icon-vector-illustration-vector-id1256767138?k=20&m=1256767138&s=612x612&w=0&h=CCNflxf6O4nT2g2vYyAljOaNGTJBXpvPj6t4bQhfh44=', '2022-09-18 10:04:28', '2022-09-18 10:04:28'),
(6, 'test', 'hello, good evening', 'https://www.youtube.com/watch?v=7REPYx4XMW8', 'https://upload.wikimedia.org/wikipedia/commons/thumb/b/b6/Image_created_with_a_mobile_phone.png/640px-Image_created_with_a_mobile_phone.png', '2022-10-03 12:40:12', '2022-10-03 12:40:12'),
(7, 'test 1', 'check', 'https://www.youtube.com/watch?v=7REPYx4XMW8', 'https://upload.wikimedia.org/wikipedia/commons/thumb/b/b6/Image_created_with_a_mobile_phone.png/640px-Image_created_with_a_mobile_phone.png', '2022-10-03 12:43:12', '2022-10-03 12:43:12');

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

--
-- Table structure for table `sliders`
--

CREATE TABLE `sliders` (
  `id` bigint UNSIGNED NOT NULL,
  `cat_id` bigint UNSIGNED NOT NULL,
  `video_title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `video_url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `video_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `video_thumbnail` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `video_duration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `video_description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `video_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `size` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_views` int NOT NULL,
  `date_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sliders`
--

INSERT INTO `sliders` (`id`, `cat_id`, `video_title`, `video_url`, `video_id`, `video_thumbnail`, `video_duration`, `video_description`, `video_type`, `size`, `total_views`, `date_time`, `created_at`, `updated_at`) VALUES
(29, 9, 'adhbajhbd', '1775228223.mp4', 'cda11up', '1663487661.jpg', '21', 'asffsa', 'Upload', '5.01 MB', 11, '2022-09-07 07:15:10', '2022-09-07 07:15:10', '2022-10-19 08:00:48'),
(30, 10, 'Test Slider', 'https://www.youtube.com/watch?v=H8MEOs-uSvY', 'H8MEOs-uSvY', '1663577533.jpg', '00:00', 'nothing', 'Youtube', '', 0, '2022-09-19 08:52:13', '2022-09-19 08:52:13', '2022-09-19 08:55:28'),
(31, 10, 'OneRepublic - Someday', '615563636.mp4', '', '1663578883.jpg', '00:00', 'video id missing test', 'Upload', '11.45 MB', 0, '2022-09-19 09:14:43', '2022-09-19 09:14:43', '2022-09-19 09:19:40'),
(32, 10, '96 Songs | The Life of Ram Video Song', 'https://youtu.be/VUCbPZGjdzA', 'VUCbPZGjdzA', '', '00:00', 'fsf', 'Youtube', '', 2, '2022-10-03 11:29:11', '2022-10-03 11:29:11', '2022-10-19 07:56:41');

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

--
-- Table structure for table `token_types`
--

CREATE TABLE `token_types` (
  `id` bigint UNSIGNED NOT NULL,
  `token_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token_type_value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `token_types`
--

INSERT INTO `token_types` (`id`, `token_name`, `token_type_value`, `created_at`, `updated_at`) VALUES
(1, 'json', '0', NULL, NULL);

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

--
-- Indexes for table `items`
--
ALTER TABLE `items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sliders_cat_id_foreign` (`cat_id`);

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

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

--
-- Indexes for table `sliders`
--
ALTER TABLE `sliders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sliders_cat_id_foreign` (`cat_id`);

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

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `items`
--
ALTER TABLE `items`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=97;

--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `sliders`
--
ALTER TABLE `sliders`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;

--
-- AUTO_INCREMENT for table `token_types`
--
ALTER TABLE `token_types`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `items`
--
ALTER TABLE `items`
  ADD CONSTRAINT `category_foregin_id_key` FOREIGN KEY (`cat_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `sliders`
--
ALTER TABLE `sliders`
  ADD CONSTRAINT `sliders_cat_id_foreign` FOREIGN KEY (`cat_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

