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

START TRANSACTION;



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

--
-- Table structure for table `courses`
--

CREATE TABLE `courses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `image` text NOT NULL,
  `description` text 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 `courses`
--

INSERT INTO `courses` (`id`, `title`, `image`, `description`, `created_at`, `updated_at`) VALUES
(3, 'Learn Arabic', 'upload/course_images/734236285.moto1.jpeg', '𝐐𝐮𝐫𝐚𝐧 𝐂𝐨𝐮𝐫𝐬𝐞𝐬 𝐰𝐢𝐥𝐥 𝐭𝐞𝐚𝐜𝐡 𝐲𝐨𝐮 𝐡𝐨𝐰 𝐭𝐨 𝐜𝐨𝐦𝐦𝐮𝐧𝐢𝐜𝐚𝐭𝐞 𝐢𝐧 𝐀𝐫𝐚𝐛𝐢𝐜 𝐚𝐧𝐝 𝐡𝐚𝐯𝐞 𝐚 𝐟𝐥𝐮𝐞𝐧𝐭 𝐬𝐩𝐞𝐞𝐜𝐡. 𝐘𝐨𝐮 𝐜𝐚𝐧 𝐚𝐥𝐬𝐨 𝐥𝐞𝐚𝐫𝐧 𝐀𝐫𝐚𝐛𝐢𝐜 𝐧𝐮𝐦𝐛𝐞𝐫𝐬, 𝐜𝐨𝐧𝐣𝐮𝐠𝐚𝐭𝐞 𝐀𝐫𝐚𝐛𝐢𝐜 𝐯𝐞𝐫𝐛𝐬 𝐚𝐧𝐝 𝐀𝐫𝐚𝐛𝐢𝐜 𝐠𝐫𝐚𝐦𝐦𝐚𝐫 𝐚𝐬 𝐰𝐞𝐥𝐥.', '2024-04-24 06:48:47', '2024-05-06 04:45:23'),
(4, 'Learn Quran', 'upload/course_images/115618808.pc4.jpg', '𝐋𝐞𝐚𝐫𝐧 𝐐𝐮𝐫𝐚𝐧 𝐰𝐢𝐭𝐡 𝐓𝐡𝐞 𝐐𝐮𝐫𝐚𝐧 𝐂𝐨𝐮𝐫𝐬𝐞𝐬 𝐀𝐜𝐚𝐝𝐞𝐦𝐲. 𝐖𝐞 𝐡𝐚𝐯𝐞 𝐧𝐨𝐰 𝐝𝐞𝐬𝐢𝐠𝐧𝐞𝐝 𝐚 𝐬𝐞𝐫𝐢𝐞𝐬 𝐨𝐟 𝐐𝐮𝐫𝐚𝐧𝐢𝐜 𝐂𝐨𝐮𝐫𝐬𝐞𝐬 𝐟𝐨𝐫 𝐤𝐢𝐝𝐬 𝐚𝐧𝐝 𝐚𝐝𝐮𝐥𝐭𝐬 𝐭𝐨 𝐬𝐮𝐜𝐡 𝐚𝐬 𝐐𝐮𝐫𝐚𝐧 𝐌𝐞𝐦𝐨𝐫𝐢𝐳𝐚𝐭𝐢𝐨𝐧 𝐚𝐧𝐝 𝐐𝐮𝐫𝐚𝐧 𝐑𝐞𝐜𝐢𝐭𝐚𝐭𝐢𝐨𝐧', '2024-04-24 06:49:08', '2024-05-06 04:45:13'),
(5, 'Learn Tajweed', 'upload/course_images/1077675107.rose3.jpg', '𝐋𝐞𝐚𝐫𝐧 𝐭𝐡𝐞 𝐇𝐨𝐥𝐲 𝐐𝐮𝐫𝐚𝐧 𝐰𝐢𝐭𝐡 𝐓𝐚𝐣𝐰𝐞𝐞𝐝 𝐫𝐮𝐥𝐞𝐬 𝐨𝐧𝐥𝐢𝐧𝐞 𝐰𝐢𝐭𝐡 𝐪𝐮𝐚𝐥𝐢𝐟𝐢𝐞𝐝 𝐚𝐧𝐝 𝐞𝐱𝐩𝐞𝐫𝐭 𝐭𝐮𝐭𝐨𝐫𝐬 𝐟𝐫𝐨𝐦 𝐁𝐚𝐧𝐠𝐥𝐚𝐝𝐞𝐬𝐡 𝐭𝐨 𝐫𝐞𝐜𝐢𝐭𝐞 𝐭𝐡𝐞 𝐐𝐮𝐫𝐚𝐧 𝐩𝐫𝐨𝐩𝐞𝐫𝐥𝐲.', '2024-04-24 06:49:48', '2024-05-06 11:41:20'),
(6, 'Learn tafsir', 'upload/course_images/1013272777.fff.jpg', 'dfhfgjgfj gjgkhgh hgjkhlhjl jkkljk;hj;', '2024-04-30 07:22:54', '2024-05-06 04:32:27');

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

--
-- 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 `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, '2024_02_23_044001_create_admins_table', 1),
(6, '2024_04_24_105331_create_sliders_table', 2),
(7, '2024_04_24_120838_create_courses_table', 3),
(8, '2024_04_30_144627_create_testimonials_table', 4),
(9, '2024_04_30_153308_create_why_study_us_table', 5),
(10, '2024_05_06_170827_create_students_table', 6);

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

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

CREATE TABLE `sliders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `image` text 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 `sliders`
--

INSERT INTO `sliders` (`id`, `image`, `created_at`, `updated_at`) VALUES
(5, 'upload/slider_images/535185529.banner2.jpg', '2024-04-24 06:04:15', '2024-05-06 04:17:26'),
(6, 'upload/slider_images/1157206115.banner3.jpg', '2024-04-30 07:22:02', '2024-04-30 07:22:02'),
(7, 'upload/slider_images/954367006.banner5.jpg', '2024-05-06 03:45:09', '2024-05-06 03:45:09');

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

--
-- Table structure for table `students`
--

CREATE TABLE `students` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `guardian_name` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `guardian_phone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `gender` varchar(255) DEFAULT NULL,
  `whatsapp` varchar(255) DEFAULT NULL,
  `course_name` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `plan` text 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 `students`
--

INSERT INTO `students` (`id`, `name`, `guardian_name`, `phone`, `guardian_phone`, `email`, `gender`, `whatsapp`, `course_name`, `country`, `city`, `address`, `image`, `plan`, `created_at`, `updated_at`) VALUES
(3, 'ujjal', 'solaiman', '44555', '2333', 'ujjal@gmail.com', 'male', '33434', 'Learn quran', 'Bangladesh', 'rajshahi', 'fdgh fghfgj ghkhk hjkghlghl singra natore', 'upload/student_images/1576646532.g4.jpg', 'A', '2024-05-08 05:03:54', '2024-05-08 05:03:54'),
(4, 'Misti khatun', 'Tarek', '44555', '2333', 'misti@gmail.com', 'female', '33434', 'Learn quran', 'Bangladesh', 'rajshahi', 'dsg fhfh ghjghk hjljhljhl jlj bogura', 'upload/student_images/653524329.rose4.jpg', 'A', '2024-05-08 05:05:14', '2024-05-08 05:05:14'),
(5, 'helal uddin', 'emdadul islam', '5767', '4556', 'helal@gmail.com', 'male', '33434', '5465657', 'Bangladesh', 'rajshahi', 'Natore rajshahi', 'upload/student_images/1019032769.jeet - Copy.jpg', 'D', '2024-05-08 05:06:26', '2024-05-08 05:06:26');

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

--
-- Table structure for table `testimonials`
--

CREATE TABLE `testimonials` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `description` text 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 `testimonials`
--

INSERT INTO `testimonials` (`id`, `name`, `country`, `description`, `created_at`, `updated_at`) VALUES
(3, 'mainul islam', 'bangladesh', 'need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to c.', '2024-04-30 09:27:25', '2024-05-06 05:58:32'),
(4, 'Jamil', 'India', 'need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to c.', '2024-04-30 09:27:47', '2024-05-06 05:58:24'),
(5, 'A.K Azad', 'Australia', 'need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to', '2024-05-06 05:45:21', '2024-05-06 05:58:17'),
(6, 'Joynal Abedin', 'Bangladesh', 'need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the .', '2024-05-06 05:46:05', '2024-05-06 05:58:08');

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

--
-- Table structure for table `why_study_us`
--

CREATE TABLE `why_study_us` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `image` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text 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 `why_study_us`
--

INSERT INTO `why_study_us` (`id`, `image`, `title`, `description`, `created_at`, `updated_at`) VALUES
(3, 'upload/why_study_us_images/392477339.blog1.jpg', '24/7 support', 'tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.', '2024-05-01 06:51:35', '2024-05-01 06:51:35'),
(4, 'upload/why_study_us_images/1175436877.g4.jpg', 'Expert teacher', 'tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.', '2024-05-01 06:51:55', '2024-05-01 06:51:55'),
(5, 'upload/why_study_us_images/1863894065.pc2.jpg', 'Beautiful Classroom', 'this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated', '2024-05-06 05:33:15', '2024-05-06 05:33:15'),
(6, 'upload/why_study_us_images/220991580.blog2.jpg', 'Alltime net connection', 'this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated', '2024-05-06 05:33:52', '2024-05-06 05:33:52');

--
-- Indexes for table `courses`
--
ALTER TABLE `courses`
  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 `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

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

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

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

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

--
-- AUTO_INCREMENT for table `courses`
--
ALTER TABLE `courses`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- 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=11;

--
-- AUTO_INCREMENT for table `sliders`
--
ALTER TABLE `sliders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `students`
--
ALTER TABLE `students`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `testimonials`
--
ALTER TABLE `testimonials`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `why_study_us`
--
ALTER TABLE `why_study_us`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
COMMIT;

