-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Oct 30, 2023 at 01:16 PM -- Server version: 10.4.28-MariaDB -- PHP Version: 8.0.28 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: `together_db` -- -- -------------------------------------------------------- -- -- Table structure for table `category` -- CREATE TABLE `category` ( `id` bigint(20) UNSIGNED NOT NULL, `category` varchar(255) NOT NULL, `images` text NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `status` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `category` -- INSERT INTO `category` (`id`, `category`, `images`, `created_at`, `updated_at`, `status`) VALUES (14, 'Business Managment', 'assets/media/course/653f9b7187a04_business.jpeg', '2023-10-30 06:32:57', '2023-10-30 06:32:57', '1'), (15, 'C Programming', 'assets/media/course/653f9b83b7e6a_ec2974b3e78fcbb2600af2e61c3c7b8d.jpg', '2023-10-30 06:33:15', '2023-10-30 06:33:15', '1'), (16, 'Python For Beginner', 'assets/media/course/653f9b99a6e83_python.jpeg', '2023-10-30 06:33:37', '2023-10-30 06:33:37', '1'); -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `uuid` varchar(255) NOT NULL, `connection` text NOT NULL, `queue` text NOT NULL, `payload` longtext NOT NULL, `exception` longtext NOT NULL, `failed_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `menus` -- CREATE TABLE `menus` ( `id` bigint(20) UNSIGNED NOT NULL, `menu_name` varchar(255) DEFAULT NULL, `show_menu` varchar(255) DEFAULT NULL, `routes` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `icon_class` varchar(255) DEFAULT NULL, `is_parent` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `menus` -- INSERT INTO `menus` (`id`, `menu_name`, `show_menu`, `routes`, `created_at`, `updated_at`, `icon_class`, `is_parent`) VALUES (1, 'Dashboard', 'Y', 'dashboard', '2023-10-17 10:35:42', '2023-10-19 02:24:30', 'fa fa-dashboard', 'Y'), (5, 'Setting', 'Y', 'menus', '2023-10-17 06:13:49', '2023-10-19 04:20:31', 'fa fa-gear', 'N'), (9, 'User', 'Y', 'user', '2023-10-19 04:22:37', '2023-10-19 04:28:10', 'fa fa-user', 'Y'), (10, 'Courses', 'Y', 'Course', '2023-10-19 04:24:16', '2023-10-19 04:24:16', 'fas fa-book-open', 'Y'); -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL, `migration` varchar(255) NOT NULL, `batch` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1, '2014_10_12_000000_create_users_table', 1), (2, '2014_10_12_100000_create_password_reset_tokens_table', 1), (3, '2019_08_19_000000_create_failed_jobs_table', 1), (4, '2019_12_14_000001_create_personal_access_tokens_table', 1), (5, '2023_10_17_102229_create_menus_table', 2), (9, '2023_10_17_104019_create_submenus_table', 3), (10, '2023_10_17_112353_create_your_table_name', 4), (11, '2023_10_17_112431_create_permissions_table', 5), (12, '2023_10_17_112844_create_roles_table', 6), (17, '2023_10_21_065742_create_category_table', 7), (18, '2023_10_17_112852_create_role_table', 8), (19, '2023_10_23_114244_create_topics_table', 9); -- -------------------------------------------------------- -- -- Table structure for table `password_reset_tokens` -- CREATE TABLE `password_reset_tokens` ( `email` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `password_reset_tokens` -- INSERT INTO `password_reset_tokens` (`email`, `token`, `created_at`) VALUES ('anshul@gmail.com', '$2y$10$ee.sP9EcoM8BZGF3Y3akZuNZg9wAL/zQrs2PxlMLzyis6TybhP8NK', '2023-10-19 23:53:17'); -- -------------------------------------------------------- -- -- Table structure for table `permission` -- CREATE TABLE `permission` ( `id` int(11) NOT NULL, `role_id` int(11) NOT NULL, `menu_id` varchar(255) DEFAULT NULL, `submenu_id` varchar(255) DEFAULT NULL, `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `permission` -- INSERT INTO `permission` (`id`, `role_id`, `menu_id`, `submenu_id`, `updated_at`, `created_at`) VALUES (6, 1, '[\"1\",\"5\",\"9\",\"10\"]', '[\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\"]', '2023-10-23 01:55:03', '2023-10-17 06:53:57'), (7, 2, '[\"1\"]', 'null', '2023-10-17 07:02:29', '2023-10-17 07:02:29'); -- -------------------------------------------------------- -- -- Table structure for table `permissions` -- CREATE TABLE `permissions` ( `id` bigint(20) UNSIGNED NOT NULL, `menu_id` varchar(255) DEFAULT NULL, `submenu_id` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `role_id` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `permissions` -- INSERT INTO `permissions` (`id`, `menu_id`, `submenu_id`, `created_at`, `updated_at`, `role_id`) VALUES (1, '[\"1\",\"5\"]', NULL, '2023-10-17 06:36:53', '2023-10-17 06:36:53', 1); -- -------------------------------------------------------- -- -- Table structure for table `personal_access_tokens` -- CREATE TABLE `personal_access_tokens` ( `id` bigint(20) UNSIGNED NOT NULL, `tokenable_type` varchar(255) NOT NULL, `tokenable_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `token` varchar(64) NOT NULL, `abilities` text DEFAULT NULL, `last_used_at` timestamp NULL DEFAULT NULL, `expires_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `role` -- CREATE TABLE `role` ( `id` bigint(20) UNSIGNED NOT NULL, `role` varchar(255) 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 `role` -- INSERT INTO `role` (`id`, `role`, `created_at`, `updated_at`) VALUES (1, 'super admin', NULL, NULL), (2, 'user\r\n', NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `roles` -- CREATE TABLE `roles` ( `id` bigint(20) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `submenus` -- CREATE TABLE `submenus` ( `id` bigint(20) UNSIGNED NOT NULL, `sub_menu_name` varchar(255) DEFAULT NULL, `menus_id` bigint(20) UNSIGNED DEFAULT NULL, `show` varchar(255) DEFAULT NULL, `routes` varchar(255) 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 `submenus` -- INSERT INTO `submenus` (`id`, `sub_menu_name`, `menus_id`, `show`, `routes`, `created_at`, `updated_at`) VALUES (1, 'Menus', 5, 'Y', 'menus', '2023-10-17 11:01:00', '2023-10-17 06:17:18'), (2, 'Sub Menus', 5, 'Y', 'submenu', '2023-10-17 06:18:21', '2023-10-17 06:18:21'), (3, 'User Rights', 5, 'Y', 'userright', '2023-10-17 06:19:12', '2023-10-17 06:19:12'), (4, 'All User', 9, 'Y', 'user', '2023-10-20 04:17:42', '2023-10-20 04:17:42'), (5, 'New User', 9, 'Y', 'usercreate', '2023-10-20 04:19:54', '2023-10-20 04:22:10'), (6, 'Category', 10, 'Y', 'Category', '2023-10-21 00:34:14', '2023-10-22 23:36:53'), (7, 'Topic', 10, 'Y', 'topic', '2023-10-21 00:35:00', '2023-10-21 00:35:00'), (8, 'All Courses', 10, 'Y', 'view_course', '2023-10-23 01:53:32', '2023-10-23 01:54:01'); -- -------------------------------------------------------- -- -- Table structure for table `topics` -- CREATE TABLE `topics` ( `id` bigint(20) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `topic` varchar(255) DEFAULT NULL, `thumbnail` varchar(255) DEFAULT NULL, `category_id` int(255) DEFAULT NULL, `description` text DEFAULT NULL, `video` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `user` -- CREATE TABLE `user` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) NOT NULL, `remember_token` varchar(100) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) NOT NULL, `remember_token` varchar(100) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `role` int(11) DEFAULT NULL, `photo` varchar(255) DEFAULT NULL, `mobile` varchar(255) DEFAULT NULL, `country_code` int(11) DEFAULT NULL, `address` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `role`, `photo`, `mobile`, `country_code`, `address`) VALUES (1, 'mahipal singh', 'singhmahipal23@gmail.com', NULL, '$2y$10$mJTabCNgTLlTWLYcq0CJLOQ2stV3jfZsQPXowa62/PGw6iWLPnDMy', NULL, '2023-10-13 00:55:00', '2023-10-30 04:59:41', 2, 'assets/media/avatars/653f859554b09_av.png', NULL, NULL, NULL), (2, 'mahipal singh', 'a@gmail.com', NULL, '$2y$10$Yy795DEit9F5ADZh0ENgpODyTdAgeNIUiwrg/Y3vGefea2Jz6SI4m', NULL, '2023-10-14 03:06:50', '2023-10-30 05:26:48', 1, 'assets/media/avatars/blank.png', NULL, NULL, NULL), (5, 'anshul', 'ansh@gmail.com', NULL, '$2y$10$M0IWQ/J/oFfgmWaLv/xcWOclPEX1r2nLlgtPgMJNhOYLQcfl.4/Ay', NULL, '2023-10-22 23:29:44', '2023-10-30 04:34:43', 1, 'assets/media/avatars/653f7fbbafafc_1692010040302-c54754ec-e595-48f4-a7af-ac396fb9767a.png', '09610092299', 91, 'udaipur rajsthan'), (6, 'fdfdfd', 'singhmahipal23@gmail.comwesdsd', NULL, '$2y$10$FfrY86a4C6Hk4RbYx2D.vOrafD9h.6WTMStd3EQCRjMhRaRjLhNSq', NULL, '2023-10-23 06:19:19', '2023-10-30 05:03:42', 2, 'assets/media/avatars/blank.png', '09610092299', NULL, '27 krishna vihar behind mds school'); -- -------------------------------------------------------- -- -- Table structure for table `your_table_name` -- CREATE TABLE `your_table_name` ( `id` bigint(20) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `category` -- ALTER TABLE `category` ADD PRIMARY KEY (`id`); -- -- Indexes for table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`); -- -- Indexes for table `menus` -- ALTER TABLE `menus` ADD PRIMARY KEY (`id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `password_reset_tokens` -- ALTER TABLE `password_reset_tokens` ADD PRIMARY KEY (`email`); -- -- Indexes for table `permission` -- ALTER TABLE `permission` ADD PRIMARY KEY (`id`); -- -- Indexes for table `permissions` -- ALTER TABLE `permissions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`), ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`); -- -- Indexes for table `role` -- ALTER TABLE `role` ADD PRIMARY KEY (`id`); -- -- Indexes for table `roles` -- ALTER TABLE `roles` ADD PRIMARY KEY (`id`); -- -- Indexes for table `submenus` -- ALTER TABLE `submenus` ADD PRIMARY KEY (`id`), ADD KEY `submenus_menu_id_foreign` (`menus_id`); -- -- Indexes for table `topics` -- ALTER TABLE `topics` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`); -- -- Indexes for table `your_table_name` -- ALTER TABLE `your_table_name` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `category` -- ALTER TABLE `category` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17; -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `menus` -- ALTER TABLE `menus` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20; -- -- AUTO_INCREMENT for table `permission` -- ALTER TABLE `permission` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `permissions` -- ALTER TABLE `permissions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `role` -- ALTER TABLE `role` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `roles` -- ALTER TABLE `roles` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `submenus` -- ALTER TABLE `submenus` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `topics` -- ALTER TABLE `topics` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `your_table_name` -- ALTER TABLE `your_table_name` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- Constraints for dumped tables -- -- -- Constraints for table `submenus` -- ALTER TABLE `submenus` ADD CONSTRAINT `submenus_menu_id_foreign` FOREIGN KEY (`menus_id`) REFERENCES `menus` (`id`) ON DELETE SET NULL; 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 */;