-- phpMyAdmin SQL Dump -- version 5.1.2 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Jul 17, 2025 at 02:04 PM -- Server version: 5.7.24 -- PHP Version: 8.3.1 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: `bahirasanghkailali` -- CREATE DATABASE IF NOT EXISTS `bahirasanghkailali` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; USE `bahirasanghkailali`; -- -------------------------------------------------------- -- -- Table structure for table `advertisemments` -- CREATE TABLE `advertisemments` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `button_text` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `page` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `position` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `expire_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `status` 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 `advertisemments` -- INSERT INTO `advertisemments` (`id`, `title`, `button_text`, `link`, `page`, `position`, `image`, `description`, `expire_date`, `status`, `created_at`, `updated_at`) VALUES (3, 'Cupidatat velit est', NULL, 'https://www.zatipakyty.co.uk', 'Home Page', '1', '1679290504.jpg', NULL, '2023-03-20 06:07:33', 'on', '2023-03-19 23:50:04', '2023-03-20 00:22:33'); -- -------------------------------------------------------- -- -- Table structure for table `blogs` -- CREATE TABLE `blogs` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` 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 `blogs` -- INSERT INTO `blogs` (`id`, `title`, `slug`, `description`, `image`, `status`, `created_at`, `updated_at`) VALUES (3, 'Test', 'test', '

test

', '1679382416.jpg', 'on', '2023-03-21 01:21:56', '2023-03-21 02:06:19'); -- -------------------------------------------------------- -- -- Table structure for table `company_profiles` -- CREATE TABLE `company_profiles` ( `id` bigint(20) UNSIGNED NOT NULL, `company_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `company_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `company_phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `company_address` text COLLATE utf8mb4_unicode_ci, `logo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `footer_logo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `favicon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `footer_text` text COLLATE utf8mb4_unicode_ci, `introduction` longtext COLLATE utf8mb4_unicode_ci, `vision` longtext COLLATE utf8mb4_unicode_ci, `mission` longtext COLLATE utf8mb4_unicode_ci, `map` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `facebook` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `instagram` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `twitter` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `youtube` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `meta_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `meta_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `meta_keywords` 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 `company_profiles` -- INSERT INTO `company_profiles` (`id`, `company_name`, `company_email`, `company_phone`, `company_address`, `logo`, `footer_logo`, `favicon`, `image`, `footer_text`, `introduction`, `vision`, `mission`, `map`, `facebook`, `instagram`, `twitter`, `youtube`, `meta_title`, `meta_description`, `meta_keywords`, `created_at`, `updated_at`) VALUES (4, 'Bahira Sangh Kailali', 'info@bahirasanghkailali.com', '+977 986-8585335', 'Dhangadhi, Kailali, Nepal', 'bahirasanglogo.png.png', 'bahira sang_logo.png.png', 'bahirasanglogo.png.png', 'bahira sang_logo.png.png', '
HELLO FOOTER
', 'Pellentesque in ipsum id orci porta dapibus. Pellentesque in ipsum id orci porta dapibus. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Donec velit neque, auctor sit amet aliquam vel, ullamcorper sit amet ligula. Pellentesque in ipsum id orci porta dapibus. Pellentesque in ipsum id orci porta dapibus. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Donec velit neque, auctor sit amet aliquam vel, ullamcorper sit amet ligula.
', '', '
Proin eget tortor risus. Nulla quis lorem ut libero malesuada feugiat. Vestibulum ac diam sit amet quam vehicula elementum sed sit amet dui. Curabitur aliquet quam id dui posuere blandit. Nulla porttitor accumsan tincidunt.

Nulla quis lorem ut libero malesuada feugiat. Curabitur arcu erat, accumsan id imperdiet et, porttitor at sem. Cras ultricies ligula sed magna dictum porta. Cras ultricies ligula sed magna dictum porta. Donec rutrum congue leo eget malesuada.
', '', NULL, NULL, 'on', '2025-07-11 07:33:00', '2025-07-11 07:33:00'), (5, '', NULL, NULL, 'on', '2025-07-11 07:41:52', '2025-07-11 07:41:52'); -- -------------------------------------------------------- -- -- Table structure for table `why_us` -- CREATE TABLE `why_us` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'on', `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 `advertisemments` -- ALTER TABLE `advertisemments` ADD PRIMARY KEY (`id`); -- -- Indexes for table `blogs` -- ALTER TABLE `blogs` ADD PRIMARY KEY (`id`); -- -- Indexes for table `company_profiles` -- ALTER TABLE `company_profiles` ADD PRIMARY KEY (`id`); -- -- Indexes for table `contacts` -- ALTER TABLE `contacts` ADD PRIMARY KEY (`id`); -- -- Indexes for table `expenses` -- ALTER TABLE `expenses` 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 `faqs` -- ALTER TABLE `faqs` ADD PRIMARY KEY (`id`); -- -- Indexes for table `galleries` -- ALTER TABLE `galleries` ADD PRIMARY KEY (`id`); -- -- Indexes for table `gallery_categories` -- ALTER TABLE `gallery_categories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `model_has_permissions` -- ALTER TABLE `model_has_permissions` ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`), ADD KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`); -- -- Indexes for table `model_has_roles` -- ALTER TABLE `model_has_roles` ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`), ADD KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`); -- -- Indexes for table `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`email`); -- -- Indexes for table `password_reset_tokens` -- ALTER TABLE `password_reset_tokens` ADD PRIMARY KEY (`email`); -- -- Indexes for table `permissions` -- ALTER TABLE `permissions` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`); -- -- 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 `roles` -- ALTER TABLE `roles` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`); -- -- Indexes for table `role_has_permissions` -- ALTER TABLE `role_has_permissions` ADD PRIMARY KEY (`permission_id`,`role_id`), ADD KEY `role_has_permissions_role_id_foreign` (`role_id`); -- -- Indexes for table `services` -- ALTER TABLE `services` ADD PRIMARY KEY (`id`); -- -- Indexes for table `service_categories` -- ALTER TABLE `service_categories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sliders` -- ALTER TABLE `sliders` ADD PRIMARY KEY (`id`); -- -- Indexes for table `teams` -- ALTER TABLE `teams` ADD PRIMARY KEY (`id`); -- -- Indexes for table `testimonials` -- ALTER TABLE `testimonials` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`), ADD KEY `role_id` (`role_id`); -- -- Indexes for table `vacancies` -- ALTER TABLE `vacancies` ADD PRIMARY KEY (`id`); -- -- Indexes for table `videos` -- ALTER TABLE `videos` ADD PRIMARY KEY (`id`); -- -- Indexes for table `why_us` -- ALTER TABLE `why_us` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `advertisemments` -- ALTER TABLE `advertisemments` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `blogs` -- ALTER TABLE `blogs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `company_profiles` -- ALTER TABLE `company_profiles` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `contacts` -- ALTER TABLE `contacts` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `expenses` -- ALTER TABLE `expenses` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `faqs` -- ALTER TABLE `faqs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `galleries` -- ALTER TABLE `galleries` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT for table `gallery_categories` -- ALTER TABLE `gallery_categories` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25; -- -- AUTO_INCREMENT for table `permissions` -- ALTER TABLE `permissions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=134; -- -- 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 `roles` -- ALTER TABLE `roles` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `services` -- ALTER TABLE `services` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `service_categories` -- ALTER TABLE `service_categories` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `sliders` -- ALTER TABLE `sliders` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `teams` -- ALTER TABLE `teams` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `testimonials` -- ALTER TABLE `testimonials` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `vacancies` -- ALTER TABLE `vacancies` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `videos` -- ALTER TABLE `videos` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `why_us` -- ALTER TABLE `why_us` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- Constraints for dumped tables -- -- -- Constraints for table `model_has_permissions` -- ALTER TABLE `model_has_permissions` ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE; -- -- Constraints for table `model_has_roles` -- ALTER TABLE `model_has_roles` ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE; -- -- Constraints for table `role_has_permissions` -- ALTER TABLE `role_has_permissions` ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE; -- -- Constraints for table `users` -- ALTER TABLE `users` ADD CONSTRAINT `users_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Database: `constructionsite` -- CREATE DATABASE IF NOT EXISTS `constructionsite` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; USE `constructionsite`; -- -------------------------------------------------------- -- -- Table structure for table `company_controllers` -- CREATE TABLE `company_controllers` ( `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 `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, '2019_12_14_000001_create_personal_access_tokens_table', 1), (5, '2025_07_11_164153_create_company_controllers_table', 1); -- -------------------------------------------------------- -- -- 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 `personal_access_tokens` -- CREATE TABLE `personal_access_tokens` ( `id` bigint(20) UNSIGNED NOT NULL, `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `tokenable_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `abilities` text COLLATE utf8mb4_unicode_ci, `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 `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 (1, 'sugam', 'sugam@sugam.com', NULL, '$2y$10$5N3qBQDZ0LHONyUCDN7pOuz/sG5IPYUYMOgPYdXyRiHmJO4fRUzBi', NULL, '2025-07-11 11:17:45', '2025-07-11 11:17:45'); -- -- Indexes for dumped tables -- -- -- Indexes for table `company_controllers` -- ALTER TABLE `company_controllers` 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 `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`email`); -- -- 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 `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `company_controllers` -- ALTER TABLE `company_controllers` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- 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=6; -- -- 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 `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- Database: `create_op` -- CREATE DATABASE IF NOT EXISTS `create_op` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; USE `create_op`; -- -------------------------------------------------------- -- -- Table structure for table `blogs` -- CREATE TABLE `blogs` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `short_desc` text COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci NOT NULL, `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `status` 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; -- -------------------------------------------------------- -- -- Table structure for table `course_management` -- CREATE TABLE `course_management` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `duration_weeks` int(11) NOT NULL, `start_date` date NOT NULL, `end_date` date DEFAULT NULL, `fees` decimal(8,2) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `course_management` -- INSERT INTO `course_management` (`id`, `name`, `description`, `duration_weeks`, `start_date`, `end_date`, `fees`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 'Blaze Mays', 'Maxime maiores et li', 7, '1973-01-01', '2018-05-02', NULL, '2025-07-01 02:37:15', '2025-07-01 02:37:34', '2025-07-01 02:37:34'), (2, 'sugam', 'In dicta molestias c', 44, '1998-03-23', '1970-05-04', NULL, '2025-07-01 02:38:05', '2025-07-01 02:38:26', '2025-07-01 02:38:26'); -- -------------------------------------------------------- -- -- 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, '2019_12_14_000001_create_personal_access_tokens_table', 1), (5, '2025_06_12_031900_create_stores_table', 1), (6, '2025_06_12_080344_rename_stores_to_students_table', 1), (7, '2025_06_15_080727_create_staff_table', 1), (8, '2025_06_18_072901_create_blogs_table', 1), (9, '2025_06_26_051030_create_course_management_table', 1), (10, '2025_06_26_080433_add_status_to_course_management_table', 1); -- -------------------------------------------------------- -- -- 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 `personal_access_tokens` -- CREATE TABLE `personal_access_tokens` ( `id` bigint(20) UNSIGNED NOT NULL, `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `tokenable_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `abilities` text COLLATE utf8mb4_unicode_ci, `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 `staffs` -- CREATE TABLE `staffs` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `post` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `salary` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `photo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` 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; -- -------------------------------------------------------- -- -- Table structure for table `students` -- CREATE TABLE `students` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `gender` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `image` 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; -- -------------------------------------------------------- -- -- 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 (1, 'Rosemarie Wiegand', 'kris.stella@example.net', '2025-07-01 02:34:04', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'DQTsOkmhhW', '2025-07-01 02:34:04', '2025-07-01 02:34:04'), (2, 'Velma McDermott', 'teagan.lebsack@example.org', '2025-07-01 02:34:04', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'tBhNVXCwVG', '2025-07-01 02:34:04', '2025-07-01 02:34:04'), (3, 'Rhea Gottlieb MD', 'schamberger.sasha@example.org', '2025-07-01 02:34:04', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'qMB8rLebsm', '2025-07-01 02:34:04', '2025-07-01 02:34:04'), (4, 'Chelsie Nikolaus', 'dtillman@example.net', '2025-07-01 02:34:04', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'HuWsCQAufP', '2025-07-01 02:34:04', '2025-07-01 02:34:04'), (5, 'Mr. Hardy Kub', 'jamison15@example.com', '2025-07-01 02:34:04', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'ZHwujkWTZu', '2025-07-01 02:34:04', '2025-07-01 02:34:04'), (6, 'Prof. Heath Jenkins', 'hbins@example.org', '2025-07-01 02:34:04', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'f3K5uRcdQV', '2025-07-01 02:34:04', '2025-07-01 02:34:04'), (7, 'Nelson Hoeger', 'jortiz@example.org', '2025-07-01 02:34:04', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'WJr290OCLz', '2025-07-01 02:34:04', '2025-07-01 02:34:04'), (8, 'Wilmer Walsh', 'jerod48@example.com', '2025-07-01 02:34:04', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'T10K0LQflQ', '2025-07-01 02:34:04', '2025-07-01 02:34:04'), (9, 'Heber Goldner', 'cruz12@example.com', '2025-07-01 02:34:04', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'WtWvGrfgUc', '2025-07-01 02:34:04', '2025-07-01 02:34:04'), (10, 'Dr. Mckenzie Donnelly', 'camron.fritsch@example.com', '2025-07-01 02:34:04', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', '1pPhajAnhX', '2025-07-01 02:34:04', '2025-07-01 02:34:04'), (11, 'Braeden O\'Hara', 'karine.johnson@example.com', '2025-07-01 02:34:12', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'PDsjo6B721', '2025-07-01 02:34:12', '2025-07-01 02:34:12'), (12, 'Wava Ratke', 'ocorwin@example.net', '2025-07-01 02:34:12', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'tmVc2F0IvJ', '2025-07-01 02:34:12', '2025-07-01 02:34:12'), (13, 'Dr. Coy O\'Hara', 'ayla79@example.net', '2025-07-01 02:34:12', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', '2MEuRmBfZT', '2025-07-01 02:34:12', '2025-07-01 02:34:12'), (14, 'Madyson Ullrich', 'gerda.donnelly@example.com', '2025-07-01 02:34:12', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'i17V5qeTHF', '2025-07-01 02:34:12', '2025-07-01 02:34:12'), (15, 'Prof. Donnie Welch Sr.', 'vthompson@example.org', '2025-07-01 02:34:12', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'OFOX0Au2Ur', '2025-07-01 02:34:12', '2025-07-01 02:34:12'), (16, 'Mrs. Antonietta McDermott IV', 'greenfelder.ramiro@example.org', '2025-07-01 02:34:12', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'NKCeO6unvW', '2025-07-01 02:34:12', '2025-07-01 02:34:12'), (17, 'Casandra Feeney', 'roob.hiram@example.org', '2025-07-01 02:34:12', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'Z83AJb8WC3', '2025-07-01 02:34:12', '2025-07-01 02:34:12'), (18, 'Prof. Molly Stark I', 'francisco43@example.com', '2025-07-01 02:34:12', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'GeLz2rvITl', '2025-07-01 02:34:12', '2025-07-01 02:34:12'), (19, 'Kelvin Konopelski MD', 'dusty35@example.net', '2025-07-01 02:34:12', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'OyjGzB1422', '2025-07-01 02:34:12', '2025-07-01 02:34:12'), (20, 'Adeline Reinger', 'shemar.wilderman@example.org', '2025-07-01 02:34:12', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'JMqgZyJv2H', '2025-07-01 02:34:12', '2025-07-01 02:34:12'), (21, 'Quinten Harvey DVM', 'xkassulke@example.net', '2025-07-01 02:36:11', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'SJvO8k4QGr', '2025-07-01 02:36:11', '2025-07-01 02:36:11'), (22, 'Ms. Kamille Walsh', 'ewald.waters@example.org', '2025-07-01 02:36:11', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'RZZrmHESmA', '2025-07-01 02:36:11', '2025-07-01 02:36:11'), (23, 'Prof. Carol Wiza II', 'tlangosh@example.net', '2025-07-01 02:36:11', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'ishAsCrVR3', '2025-07-01 02:36:11', '2025-07-01 02:36:11'), (24, 'Bette Kohler I', 'mariana91@example.org', '2025-07-01 02:36:11', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', '2fvmoZ8MMP', '2025-07-01 02:36:11', '2025-07-01 02:36:11'), (25, 'Prof. Terence Lehner II', 'harris.horacio@example.com', '2025-07-01 02:36:11', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'GuWpLbmi5d', '2025-07-01 02:36:11', '2025-07-01 02:36:11'), (26, 'Adolphus Will MD', 'dmiller@example.org', '2025-07-01 02:36:11', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'vpJHeU1BF1', '2025-07-01 02:36:12', '2025-07-01 02:36:12'), (27, 'Verla Bauch', 'aurelio34@example.net', '2025-07-01 02:36:11', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'eFI89A43sw', '2025-07-01 02:36:12', '2025-07-01 02:36:12'), (28, 'Kasandra Dicki', 'katherine30@example.net', '2025-07-01 02:36:11', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'Q0p15Eu64n', '2025-07-01 02:36:12', '2025-07-01 02:36:12'), (29, 'Grace Ferry', 'jbahringer@example.org', '2025-07-01 02:36:11', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'TJ9CqloUQf', '2025-07-01 02:36:12', '2025-07-01 02:36:12'), (30, 'Brooks Hagenes DDS', 'domenick.barrows@example.com', '2025-07-01 02:36:11', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'xaDg2rUwqN', '2025-07-01 02:36:12', '2025-07-01 02:36:12'), (31, 'Admin', 'admin@gmail.com', '2025-07-01 02:36:12', '$2y$10$sD1i.eBaU/vkV7EMhyCIq.M.qUVGKB2v7mg7maC6RXnz.dSEtxHO2', 'SkRJSaipAm', '2025-07-01 02:36:12', '2025-07-01 02:36:12'); -- -- Indexes for dumped tables -- -- -- Indexes for table `blogs` -- ALTER TABLE `blogs` ADD PRIMARY KEY (`id`); -- -- Indexes for table `course_management` -- ALTER TABLE `course_management` 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 `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`email`); -- -- 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 `staffs` -- ALTER TABLE `staffs` ADD PRIMARY KEY (`id`); -- -- Indexes for table `students` -- ALTER TABLE `students` 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 `blogs` -- ALTER TABLE `blogs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `course_management` -- ALTER TABLE `course_management` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- 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 `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `staffs` -- ALTER TABLE `staffs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `students` -- ALTER TABLE `students` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32; -- -- Database: `hajiribibaran` -- CREATE DATABASE IF NOT EXISTS `hajiribibaran` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; USE `hajiribibaran`; -- -------------------------------------------------------- -- -- Table structure for table `hajir` -- CREATE TABLE `hajir` ( `id` int(11) NOT NULL, `name` varchar(250) NOT NULL, `workDay` enum('p','a','half') NOT NULL, `totalDays` varchar(250) NOT NULL, `status` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `hajir` -- INSERT INTO `hajir` (`id`, `name`, `workDay`, `totalDays`, `status`) VALUES (1, 'Anant Chaudhary', 'p', '1', ''), (2, 'Madhu Chaudhary', 'p', '1', ''); -- -------------------------------------------------------- -- -- Table structure for table `hisabkitab` -- CREATE TABLE `hisabkitab` ( `id` int(11) NOT NULL, `name` varchar(250) NOT NULL, `date` date DEFAULT NULL, `moneyReceived` text, `status` varchar(50) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `hisabkitab` -- INSERT INTO `hisabkitab` (`id`, `name`, `date`, `moneyReceived`, `status`) VALUES (8, 'Anant Chaudhary', '1111-01-01', '123456', NULL), (12, 'Sugam Chaudhary', '2082-07-02', '50000', NULL); -- -- Indexes for dumped tables -- -- -- Indexes for table `hajir` -- ALTER TABLE `hajir` ADD PRIMARY KEY (`id`); -- -- Indexes for table `hisabkitab` -- ALTER TABLE `hisabkitab` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `hajir` -- ALTER TABLE `hajir` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `hisabkitab` -- ALTER TABLE `hisabkitab` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- Database: `laravel` -- CREATE DATABASE IF NOT EXISTS `laravel` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; USE `laravel`; -- -------------------------------------------------------- -- -- 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, '2019_12_14_000001_create_personal_access_tokens_table', 1); -- -------------------------------------------------------- -- -- 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 `personal_access_tokens` -- CREATE TABLE `personal_access_tokens` ( `id` bigint(20) UNSIGNED NOT NULL, `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `tokenable_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `abilities` text COLLATE utf8mb4_unicode_ci, `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 `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 (1, 'sugam', 'chaudharysugam56@gmail.com', NULL, '$2y$10$1zP4txqPCqfdznMYlE2MguJ1NWajhyetyV447P0CPfB/DIdaTMLXi', NULL, '2025-06-17 05:53:01', '2025-06-17 05:53:01'); -- -- 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 `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 `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=5; -- -- 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 `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- Database: `laravelstart` -- CREATE DATABASE IF NOT EXISTS `laravelstart` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; USE `laravelstart`; -- -------------------------------------------------------- -- -- 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, '2019_12_14_000001_create_personal_access_tokens_table', 1); -- -------------------------------------------------------- -- -- 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 `personal_access_tokens` -- CREATE TABLE `personal_access_tokens` ( `id` bigint(20) UNSIGNED NOT NULL, `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `tokenable_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `abilities` text COLLATE utf8mb4_unicode_ci, `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 `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; -- -- 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 PRIMARY KEY (`email`); -- -- 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 `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=5; -- -- 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 `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- Database: `loginregister` -- CREATE DATABASE IF NOT EXISTS `loginregister` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; USE `loginregister`; -- -------------------------------------------------------- -- -- 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, '2019_12_14_000001_create_personal_access_tokens_table', 1), (5, '2025_06_10_155351_table_student', 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 `personal_access_tokens` -- CREATE TABLE `personal_access_tokens` ( `id` bigint(20) UNSIGNED NOT NULL, `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `tokenable_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `abilities` text COLLATE utf8mb4_unicode_ci, `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 `projects` -- CREATE TABLE `projects` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `start_date` date NOT NULL, `end_date` date 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) 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 (1, 'sugam', 'chaudharysugam56@gmail.com', NULL, '$2y$10$aMWSIn5XMtNemOXcxZy/l.21bkk8Do8hsjoZjxddyz2kBBtsPtPJW', NULL, '2025-06-10 01:06:42', '2025-06-10 01:06:42'); -- -- 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 `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 `projects` -- ALTER TABLE `projects` 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=6; -- -- 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 `projects` -- ALTER TABLE `projects` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- Database: `newsportal` -- CREATE DATABASE IF NOT EXISTS `newsportal` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; USE `newsportal`; -- -------------------------------------------------------- -- -- Table structure for table `carousels` -- CREATE TABLE `carousels` ( `id` bigint(20) UNSIGNED NOT NULL, `carousel_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `carousel_header` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `carousel_description` 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 `carousels` -- INSERT INTO `carousels` (`id`, `carousel_image`, `carousel_header`, `carousel_description`, `created_at`, `updated_at`) VALUES (2, '1752427259_carousel_image.avif', 'sugam sugam', 'sedrftgyhujiokpl;[\'sugam', '2025-07-13 11:35:59', '2025-07-13 11:35:59'), (3, '1752428207_carousel_image.jpg', 'Ut error nisi anim n sugam', 'Quasi impedit iste sugam', '2025-07-13 11:51:47', '2025-07-13 11:51:47'), (4, '1752429172_carousel_image.jpg', 'Eum sequi rem non qu sugam', 'Maiores accusamus dosuga,', '2025-07-13 11:53:21', '2025-07-13 12:07:52'), (5, '1752429286_carousel_image.jpg', 'Voluptatem et a con chy chy', 'Provident corrupti chy chy', '2025-07-13 12:09:17', '2025-07-13 12:09:46'); -- -------------------------------------------------------- -- -- Table structure for table `categories` -- CREATE TABLE `categories` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active', `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default.png', `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`, `title`, `description`, `status`, `image`, `created_at`, `updated_at`) VALUES (3, 'shyams', 'Sed voluptates quo m', 'inactive', '1751618448.png', '2025-07-03 04:06:27', '2025-07-04 02:55:48'), (4, 'Eum commodo voluptat', 'Sed facilis iusto du', 'inactive', '1751536686.png', '2025-07-03 04:13:06', '2025-07-03 05:09:13'), (5, 'Sed a reprehenderit', 'Necessitatibus eos', 'active', '1751536719.png', '2025-07-03 04:13:39', '2025-07-03 04:13:39'), (6, 'Labore cum lorem duc', 'Veniam enim quidem', 'active', '1751536952.png', '2025-07-03 04:17:32', '2025-07-03 04:17:32'), (7, 'Sit duis accusamus', 'Molestiae et ipsa b', 'active', '1751537266.png', '2025-07-03 04:22:46', '2025-07-03 05:04:00'), (8, 'Dolor accusamus sit', 'Officia neque eos al', 'inactive', '1751539980.png', '2025-07-03 05:08:00', '2025-07-04 00:37:03'), (9, 'Voluptatem Tempor n', 'Adipisci minim minus', 'inactive', '1751610024.png', '2025-07-04 00:35:25', '2025-07-04 02:23:43'), (10, 'Voluptatem sint pers', 'Dolore debitis qui r', 'active', '1751614438.png', '2025-07-04 01:48:58', '2025-07-04 02:36:59'), (11, 'Consectetur mollitia', 'Porro suscipit sed e', 'active', '1751616931.png', '2025-07-04 02:30:31', '2025-07-04 02:32:05'); -- -------------------------------------------------------- -- -- Table structure for table `company_settings` -- CREATE TABLE `company_settings` ( `id` bigint(20) UNSIGNED NOT NULL, `company_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `company_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `company_phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `company_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `company_logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `company_favicon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `company__description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `company_keywords` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `company_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active', `favebook` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `twitter` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `instagram` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `youtube` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `image` 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 `company_settings` -- INSERT INTO `company_settings` (`id`, `company_name`, `company_email`, `company_phone`, `company_address`, `company_logo`, `company_favicon`, `company__description`, `company_keywords`, `company_status`, `favebook`, `twitter`, `instagram`, `youtube`, `image`, `created_at`, `updated_at`) VALUES (3, 'sugams construction', 'chaudharysugam56@gmail.com', '9822664451', 'dhangadhi kailali', '1752224623_logo.png', '1752051036_favicon.png', 'Build home one time in a life through our experiences workers', 'hello', 'active', 'fb.com', NULL, 'instagram.com', 'zupi@mailinator.com', '1752225331_image.jpg', '2025-07-09 03:01:20', '2025-07-11 03:30:31'); -- -------------------------------------------------------- -- -- 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, '2019_12_14_000001_create_personal_access_tokens_table', 1), (6, '2025_07_02_075236_create_categories_table', 2), (8, '2025_07_04_111508_create_news_table', 3), (9, '2025_07_05_024542_add_deleted_at_to_news_table', 4), (10, '2025_07_07_082435_create_tags_table', 5), (11, '2025_07_07_085329_create_news_tag_table', 6), (13, '2025_07_08_074245_create_company_settings_table', 7), (16, '2025_07_13_155941_create_carousels_table', 8); -- -------------------------------------------------------- -- -- Table structure for table `news` -- CREATE TABLE `news` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `short_description` text COLLATE utf8mb4_unicode_ci, `description` longtext COLLATE utf8mb4_unicode_ci, `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `category_id` bigint(20) UNSIGNED DEFAULT NULL, `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active', `deleted_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; -- -- Dumping data for table `news` -- INSERT INTO `news` (`id`, `title`, `slug`, `short_description`, `description`, `image`, `category_id`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES (32, 'Molestiae a neque ea', 'molestiae-a-neque-ea', 'Cum voluptatem ad ip', 'Illo ut eius dolore', 'default.png', 3, 'active', NULL, '2025-07-06 02:50:58', '2025-07-06 02:50:58'), (33, 'Minima blanditiis fu', 'minima-blanditiis-fu', 'Eum totam explicabo', 'Sit consequatur nem', 'default.png', 9, 'inactive', NULL, '2025-07-06 02:51:52', '2025-07-06 02:51:52'), (34, 'Omnis ut recusandae', 'omnis-ut-recusandae', 'In magna a officia t', 'Fuga Dolorem evenie', 'default.png', 3, 'active', NULL, '2025-07-07 02:35:32', '2025-07-07 02:35:32'), (35, 'Mollit recusandae I', 'mollit-recusandae-i', 'Soluta provident ve', 'Est qui perspiciatis', 'default.png', 3, 'inactive', NULL, '2025-07-07 02:35:54', '2025-07-07 02:35:54'), (36, 'Harum et esse repreh', 'harum-et-esse-repreh', 'Sequi sit amet reru', 'At odio facere dolor', 'default.png', 9, 'inactive', NULL, '2025-07-07 02:36:45', '2025-07-07 02:36:45'), (37, 'Natus facere laborum', 'natus-facere-laborum', 'Et minim in rerum vo', 'Ea natus repellendus', 'default.png', 3, 'inactive', NULL, '2025-07-08 00:26:51', '2025-07-08 00:26:51'), (38, 'sugam sugam', 'sugam-sugam', 'Culpa voluptate dolo', 'Minima exercitation', '1751955223.png', 3, 'inactive', NULL, '2025-07-08 00:28:44', '2025-07-08 00:29:00'); -- -------------------------------------------------------- -- -- Table structure for table `news_tag` -- CREATE TABLE `news_tag` ( `news_id` int(11) NOT NULL, `tag_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `news_tag` -- INSERT INTO `news_tag` (`news_id`, `tag_id`) VALUES (37, 2), (37, 4), (38, 1), (38, 2), (38, 3), (38, 4), (38, 5), (39, 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 `personal_access_tokens` -- CREATE TABLE `personal_access_tokens` ( `id` bigint(20) UNSIGNED NOT NULL, `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `tokenable_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `abilities` text COLLATE utf8mb4_unicode_ci, `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 `tags` -- CREATE TABLE `tags` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active', `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 `tags` -- INSERT INTO `tags` (`id`, `title`, `status`, `created_at`, `updated_at`) VALUES (1, 'Autem sunt voluptate', 'inactive', '2025-07-07 03:19:28', '2025-07-07 03:19:28'), (2, 'Adipisci fugiat ali', 'inactive', '2025-07-07 03:30:20', '2025-07-07 03:30:20'), (3, 'Consectetur molesti', 'active', '2025-07-07 03:47:02', '2025-07-07 03:47:02'), (4, 'Quasi commodi perspi', 'active', '2025-07-07 03:49:09', '2025-07-07 03:49:09'), (5, 'sugam', 'inactive', '2025-07-08 00:27:43', '2025-07-08 00:27:43'); -- -------------------------------------------------------- -- -- 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 (1, 'Prescott Reilly', 'folywe@mailinator.com', NULL, '$2y$10$QySIav5EmP6Mc7S/0HfCAuTk00hX3IQ2WOZy6qC8Q4SC.XSTy..0S', NULL, '2025-07-01 01:34:49', '2025-07-01 01:34:49'), (2, 'jasmine', 'jasmine@gmail.com', NULL, '$2y$10$LIKuOYfXKyEcdCv3jB8id.X21hU.KeZqRwnMXjySf4teYqa6d4yyq', NULL, '2025-07-01 01:36:08', '2025-07-01 01:36:08'), (3, 'sugam', 'sugam@sugam.com', NULL, '$2y$10$aOuJqjCZqvXPgwLbUmK9ZONTLyssObyiDwHXLMyL1CRNtxFhzEIvO', NULL, '2025-07-13 09:55:02', '2025-07-13 09:55:02'); -- -- Indexes for dumped tables -- -- -- Indexes for table `carousels` -- ALTER TABLE `carousels` ADD PRIMARY KEY (`id`); -- -- Indexes for table `categories` -- ALTER TABLE `categories` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `categories_title_unique` (`title`); -- -- Indexes for table `company_settings` -- ALTER TABLE `company_settings` 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 `news` -- ALTER TABLE `news` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `news_slug_unique` (`slug`); -- -- Indexes for table `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`email`); -- -- 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 `tags` -- ALTER TABLE `tags` 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 `carousels` -- ALTER TABLE `carousels` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `categories` -- ALTER TABLE `categories` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `company_settings` -- ALTER TABLE `company_settings` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- 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=17; -- -- AUTO_INCREMENT for table `news` -- ALTER TABLE `news` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39; -- -- 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 `tags` -- ALTER TABLE `tags` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- Database: `schoolmanagement` -- CREATE DATABASE IF NOT EXISTS `schoolmanagement` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; USE `schoolmanagement`; -- -------------------------------------------------------- -- -- 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, '2019_12_14_000001_create_personal_access_tokens_table', 1); -- -------------------------------------------------------- -- -- 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 `personal_access_tokens` -- CREATE TABLE `personal_access_tokens` ( `id` bigint(20) UNSIGNED NOT NULL, `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `tokenable_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `abilities` text COLLATE utf8mb4_unicode_ci, `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 `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 (1, 'school', 'school@school.com', NULL, '$2y$10$GphXRNuu4E3dK7myGx7QaOhrreOKi02tTe1gyYqZbzPevWtLsnMY2', NULL, '2025-07-14 02:05:06', '2025-07-14 02:05:06'); -- -- 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 `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 `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=5; -- -- 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 `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- Database: `storelist` -- CREATE DATABASE IF NOT EXISTS `storelist` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; USE `storelist`; -- -------------------------------------------------------- -- -- Table structure for table `password` -- CREATE TABLE `password` ( `id` int(11) NOT NULL, `name` varchar(250) NOT NULL, `email` varchar(255) NOT NULL, `password` varchar(250) NOT NULL, `status` enum('active','passive') NOT NULL DEFAULT 'active' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `password` -- INSERT INTO `password` (`id`, `name`, `email`, `password`, `status`) VALUES (1, 'sugam', 'sugam@gamil.com', '$2y$10$Pa48V/WFuvnZIiCps8oDgeT4LTgEdKzQnOrK9jS9Etd650wejcZgi', 'active'), (2, 'hello', 'hello@gamil.com', '$2y$10$Ddn0PDqDUoUz8/.KIFh5wO5KCSDIwwLeLhBRtsW4lFdVGEF0fFzVS', 'active'), (3, 'hey', 'hey@gmail.com', '$2y$10$jk5HcZHLgNpl2AsgZvMskexG9eqkayiZtkPONiov4y6U8qbO2U1sy', 'active'), (4, 'sugam', 'hello@gmail.com', '$2y$10$dhwi3IFnk3BExDB.4QhcruhsA.en6VUb4ZtFY7eT8BA9I/LnN53Jm', 'active'); -- -------------------------------------------------------- -- -- Table structure for table `proficiency` -- CREATE TABLE `proficiency` ( `id` int(11) NOT NULL, `proficiency` varchar(250) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `proficiency` -- INSERT INTO `proficiency` (`id`, `proficiency`) VALUES (1, 'web developer'), (2, 'promt engineering'), (3, 'graphic designer'); -- -------------------------------------------------------- -- -- Table structure for table `profile` -- CREATE TABLE `profile` ( `id` int(11) NOT NULL, `name` varchar(250) NOT NULL, `facebook` varchar(250) NOT NULL, `email` varchar(250) NOT NULL, `github` varchar(250) NOT NULL, `image` varchar(250) NOT NULL, `description` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `profile` -- INSERT INTO `profile` (`id`, `name`, `facebook`, `email`, `github`, `image`, `description`) VALUES (1, 'sugam', 'fb.com', 'hey@gmail.com', 'sugam655', 'IMG_3071.JPG', ''), (2, 'sugam', 'fb.com', 'hey@gmail.com', 'sugam655', 'IMG_3071.JPG', ''), (3, 'Sugams', 'facebook.com', 'chaudharysugam56@gmail.com', 'sugam655', 'IMG_3487.JPG', ''), (4, 'sugam1', 'su.com', 'sugam@gmail.com', 'sugam655', 'IMG_3465.JPG', ''), (5, 'sdfghj', 'asdfgh', 'dxfcvbnm@gmail.com', 'zsxcvbnm', 'IMG_3113.JPG', ''), (6, 'hello', 'fb.com', 'hey@gmail.com', 'sugam655', 'IMG_3416.JPG', ''), (7, 'sugam1', 'su.com', 'sugam@gmail.com', 'sugam655', 'IMG_3107.JPG', ''), (8, 'sugam1', 'su.com', 'sugam@gmail.com', 'sugam655', 'IMG_3107.JPG', ''), (9, 'aayush', 'fb.com', 'aayush@gmail.com', 'aayush54', '', ''), (10, 'aayush', 'fb.com', 'aayush@gmail.com', 'aayush54', '', ''), (11, 'shyam 1', 'fb.com', 'shyam@gmail.com', 'shyam54', '', ''), (12, 'shyam', 'fb.com', 'shyam@gmail.com', 'shyam54', '', ''), (13, 'shyam', 'fb.com', 'shyam@gmail.com', 'shyam54', '', ''), (14, 'shyam12', 'fb.com', 'shyam@gmail.com', 'shyam54', '', ''), (15, 'shyam12', 'fb.com', 'shyam@gmail.com', 'shyam54', '', ''), (16, 'shyam12', 'fb.com', 'shyam@gmail.com', 'shyam54', 'IMG_3109.JPG', ''), (17, 'shyam12', 'fb.com', 'shyam@gmail.com', 'shyam54', '', ''), (18, 'shyam12', 'fb.com', 'shyam@gmail.com', 'shyam54', '', ''), (19, 'shyam12', 'fb.com', 'shyam@gmail.com', 'shyam54', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `services` -- CREATE TABLE `services` ( `id` int(11) NOT NULL, `title` varchar(50) NOT NULL, `image` varchar(250) NOT NULL, `description` varchar(250) NOT NULL, `status` varchar(50) NOT NULL DEFAULT 'active' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `services` -- INSERT INTO `services` (`id`, `title`, `image`, `description`, `status`) VALUES (1, 'web hosting', 'IMG_3401.JPG', 'jajka', 'nkjaa'), (2, 'web devlopment', 'IMG_3397.JPG', 'jajlacndja', 'active'), (3, 'Graphic designer', 'IMG_3107.JPG', ' njadjlndkas', 'active'), (4, 'Full stack', 'IMG_3110.JPG', 'jkadsjlak', 'active'), (5, 'Full Stack', 'IMG_3432.JPG', 'njkajnal', 'active'), (6, 'sugam', 'IMG_3107.JPG', 'jhbdsahjak', 'active'), (7, '', '', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `store_list` -- CREATE TABLE `store_list` ( `id` int(11) NOT NULL, `name` varchar(250) NOT NULL, `image` varchar(250) DEFAULT NULL, `ordered` int(11) NOT NULL, `listed` int(11) NOT NULL, `shortage` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `store_list` -- INSERT INTO `store_list` (`id`, `name`, `image`, `ordered`, `listed`, `shortage`) VALUES (12, 'sugam chaudhary', 'IMG_3487.JPG', 123, 123, 123), (13, 'Samir chaudhary', 'IMG_3110.JPG', 1, 2, 3), (14, 'shyam', 'IMG_3180.JPG', 12, 1, 1), (16, 'Mannu singh', 'IMG_3140.JPG', 1, 1, 1), (17, 'sdfghj', 'IMG_3107.JPG', 12, 12, 12); -- -- Indexes for dumped tables -- -- -- Indexes for table `password` -- ALTER TABLE `password` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `email` (`email`); -- -- Indexes for table `proficiency` -- ALTER TABLE `proficiency` ADD PRIMARY KEY (`id`); -- -- Indexes for table `profile` -- ALTER TABLE `profile` ADD PRIMARY KEY (`id`); -- -- Indexes for table `services` -- ALTER TABLE `services` ADD PRIMARY KEY (`id`); -- -- Indexes for table `store_list` -- ALTER TABLE `store_list` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `password` -- ALTER TABLE `password` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `proficiency` -- ALTER TABLE `proficiency` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `profile` -- ALTER TABLE `profile` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20; -- -- AUTO_INCREMENT for table `services` -- ALTER TABLE `services` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `store_list` -- ALTER TABLE `store_list` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18; -- -- Database: `sugam` -- CREATE DATABASE IF NOT EXISTS `sugam` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; USE `sugam`; -- -------------------------------------------------------- -- -- Table structure for table `student-list` -- CREATE TABLE `student-list` ( `id` int(11) NOT NULL, `Name` varchar(50) NOT NULL, `Class` int(11) NOT NULL, `Roll` int(11) NOT NULL, `Status` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `student-list` -- INSERT INTO `student-list` (`id`, `Name`, `Class`, `Roll`, `Status`) VALUES (1, 'Sugam', 1, 2, 'active'), (2, 'Salina Lama', 1, 3, 'active'), (3, 'Mahesh', 2, 10, 'fail'), (4, 'Ashma', 10, 5, 'pass'); -- -- Indexes for dumped tables -- -- -- Indexes for table `student-list` -- ALTER TABLE `student-list` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `student-list` -- ALTER TABLE `student-list` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- Database: `team_db` -- CREATE DATABASE IF NOT EXISTS `team_db` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; USE `team_db`; -- -------------------------------------------------------- -- -- Table structure for table `teams` -- CREATE TABLE `teams` ( `id` int(11) NOT NULL, `NAME` varchar(100) NOT NULL, `role` varchar(100) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `teams` -- INSERT INTO `teams` (`id`, `NAME`, `role`, `created_at`) VALUES (2, 'wertyui', '3', '2025-05-26 09:09:08'); -- -- Indexes for dumped tables -- -- -- Indexes for table `teams` -- ALTER TABLE `teams` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `teams` -- ALTER TABLE `teams` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- Database: `workerlist` -- CREATE DATABASE IF NOT EXISTS `workerlist` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; USE `workerlist`; -- -------------------------------------------------------- -- -- Table structure for table `password` -- CREATE TABLE `password` ( `id` int(11) NOT NULL, `name` varchar(250) NOT NULL, `email` varchar(250) NOT NULL, `password` varchar(250) NOT NULL, `confirmpassword` varchar(250) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `password` -- INSERT INTO `password` (`id`, `name`, `email`, `password`, `confirmpassword`) VALUES (1, '', 'chaudharysugam56@gmail.com', '$2y$10$MI0rSSbhiRWOv7gyXHmQCO/CJ2UlY9JfR788SIlKwy5qXfpOfwJEq', ''), (2, '', 'hello@gmail.com', '$2y$10$ODuo9vAk8ReOCnbRIbjqseFPUFM4hyN0g7n4RS2KFVBYrGM9huUqa', ''), (3, '', 'hello@gmail.com', '$2y$10$ODuo9vAk8ReOCnbRIbjqseFPUFM4hyN0g7n4RS2KFVBYrGM9huUqa', ''); -- -------------------------------------------------------- -- -- Table structure for table `worker_list` -- CREATE TABLE `worker_list` ( `id` int(11) NOT NULL, `name` varchar(250) NOT NULL, `address` varchar(250) NOT NULL, `phone` varchar(50) NOT NULL, `post` varchar(250) NOT NULL, `basicsalary` varchar(250) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `worker_list` -- INSERT INTO `worker_list` (`id`, `name`, `address`, `phone`, `post`, `basicsalary`) VALUES (2, 'sugam', 'chaudhary', '234567', 'developer', '23456'), (6, 'sugam', 'dhn', '83473', 'jhsdala', '8932782'), (7, 'hjsjhL', 'jksjh', '983922982', 'HAHJA', '873874'), (8, 'jhajla', 'hahjakja', '8947457', 'hljalhja', '22222'), (9, 'sssss', 'aaaaa', '999999', 'jajaaaa', '0000'); -- -- Indexes for dumped tables -- -- -- Indexes for table `password` -- ALTER TABLE `password` ADD PRIMARY KEY (`id`); -- -- Indexes for table `worker_list` -- ALTER TABLE `worker_list` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `password` -- ALTER TABLE `password` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `worker_list` -- ALTER TABLE `worker_list` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; 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 */;