-- phpMyAdmin SQL Dump -- version 5.0.4 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Apr 13, 2021 at 02:54 PM -- Server version: 10.4.16-MariaDB -- PHP Version: 7.3.24 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: `quiz` -- -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `connection` text COLLATE utf8mb4_unicode_ci NOT NULL, `queue` text COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `failed_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL, `migration` varchar(255) COLLATE utf8mb4_unicode_ci 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_resets_table', 1), (3, '2019_08_19_000000_create_failed_jobs_table', 1), (4, '2021_04_11_213704_create_quizess_table', 1), (5, '2021_04_12_095258_create_sections_table', 1), (6, '2021_04_12_104207_create_questions_table', 1), (7, '2021_04_12_182400_create_quizess_sections_table', 2); -- -------------------------------------------------------- -- -- Table structure for table `password_resets` -- CREATE TABLE `password_resets` ( `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `questions` -- CREATE TABLE `questions` ( `id` int(10) UNSIGNED NOT NULL, `quiz_id` int(10) UNSIGNED NOT NULL, `section_id` int(10) UNSIGNED NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `options` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `answer` varchar(255) 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 `questions` -- INSERT INTO `questions` (`id`, `quiz_id`, `section_id`, `title`, `type`, `options`, `answer`, `created_at`, `updated_at`) VALUES (9, 2, 6, 'Which one is correct team name in NBA?', 'single', '[\"New York Bulls\",\"Los Angeles Kings\",\"Golden State Warriros\",\"Huston Rocket\"]', '[\"4\"]', '2021-04-13 06:22:15', '2021-04-13 06:22:15'), (10, 2, 6, 'Who was the captain of Bangladesh cricket team?', 'multiple', '[\"Habibul Bashar Sumon\",\"Mohammad Rafiq\",\"Khaled Mahmud Sujan\",\"Mehrab Hossain\"]', '[\"1\",\"3\"]', '2021-04-13 06:23:19', '2021-04-13 06:23:19'), (11, 2, 7, '5 + 7 = ?', 'single', '[\"10\",\"11\",\"12\",\"13\"]', '[\"3\"]', '2021-04-13 06:23:54', '2021-04-13 06:23:54'), (12, 2, 7, '12 - 8 = ?', 'single', '[\"1\",\"2\",\"3\",\"4\"]', '[\"4\"]', '2021-04-13 06:24:26', '2021-04-13 06:24:26'), (13, 2, 7, 'What is correct answer?', 'multiple', '[\"3 > 9\",\"5 < 10\",\"7 != 5\",\"9 < 5\"]', '[\"2\",\"3\",\"4\"]', '2021-04-13 06:25:22', '2021-04-13 06:25:22'); -- -------------------------------------------------------- -- -- Table structure for table `quizess` -- CREATE TABLE `quizess` ( `id` int(10) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `total_time` int(11) NOT NULL, `total_mark` int(11) 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 `quizess` -- INSERT INTO `quizess` (`id`, `user_id`, `title`, `total_time`, `total_mark`, `created_at`, `updated_at`) VALUES (2, 2, 'Quiz 1', 5, 10, '2021-04-13 06:15:35', '2021-04-13 06:15:35'); -- -------------------------------------------------------- -- -- Table structure for table `quizess_sections` -- CREATE TABLE `quizess_sections` ( `quiz_id` int(10) UNSIGNED NOT NULL, `section_id` int(10) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `sections` -- CREATE TABLE `sections` ( `id` int(10) UNSIGNED NOT NULL, `title` 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 `sections` -- INSERT INTO `sections` (`id`, `title`, `created_at`, `updated_at`) VALUES (6, 'Sports', '2021-04-13 06:20:22', '2021-04-13 06:20:22'), (7, 'Math', '2021-04-13 06:21:07', '2021-04-13 06:21:07'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `remember_token` varchar(100) 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 `users` -- INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES (2, 'Md. Mehedi Hasan', 'mmhn.cse@gmail.com', NULL, '$2y$10$HF4bSTxhcvsmVqi1K0bvke57qPllGbhmJudSlzGulPiBYmUkHharu', NULL, '2021-04-12 12:18:14', '2021-04-12 12:18:14'); -- -- Indexes for dumped tables -- -- -- Indexes for table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`email`); -- -- Indexes for table `questions` -- ALTER TABLE `questions` ADD PRIMARY KEY (`id`), ADD KEY `questions_quiz_id_foreign` (`quiz_id`), ADD KEY `questions_section_id_foreign` (`section_id`); -- -- Indexes for table `quizess` -- ALTER TABLE `quizess` ADD PRIMARY KEY (`id`), ADD KEY `quizess_user_id_foreign` (`user_id`); -- -- Indexes for table `sections` -- ALTER TABLE `sections` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `questions` -- ALTER TABLE `questions` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `quizess` -- ALTER TABLE `quizess` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `sections` -- ALTER TABLE `sections` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- Constraints for dumped tables -- -- -- Constraints for table `questions` -- ALTER TABLE `questions` ADD CONSTRAINT `questions_quiz_id_foreign` FOREIGN KEY (`quiz_id`) REFERENCES `quizess` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `questions_section_id_foreign` FOREIGN KEY (`section_id`) REFERENCES `sections` (`id`) ON DELETE CASCADE; -- -- Constraints for table `quizess` -- ALTER TABLE `quizess` ADD CONSTRAINT `quizess_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; 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 */;