-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Jul 19, 2024 at 11:44 AM -- Server version: 10.4.28-MariaDB -- PHP Version: 8.2.4 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: `discount_store` -- -- -------------------------------------------------------- -- -- Table structure for table `categories` -- CREATE TABLE `categories` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `description` 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 `categories` -- INSERT INTO `categories` (`id`, `name`, `description`, `created_at`, `updated_at`) VALUES (1, 'Electronics', 'All types Variety', '2024-07-15 04:06:36', '2024-07-15 04:06:36'), (2, 'Shoes', 'asgjfcgsdyufcg', '2024-07-15 05:19:14', '2024-07-15 05:19:14'), (3, 'Clothes', 'dhjcfgyubg', '2024-07-15 05:19:33', '2024-07-15 05:19:33'); -- -------------------------------------------------------- -- -- Table structure for table `discount_rules` -- CREATE TABLE `discount_rules` ( `id` bigint(20) UNSIGNED NOT NULL, `product_id` bigint(20) UNSIGNED NOT NULL, `performance_category_id` bigint(20) UNSIGNED NOT NULL, `user_type_id` bigint(20) UNSIGNED NOT NULL, `discount_percentage` decimal(5,2) NOT NULL, `tuition_discount_percentage` decimal(5,2) 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 `discount_rules` -- INSERT INTO `discount_rules` (`id`, `product_id`, `performance_category_id`, `user_type_id`, `discount_percentage`, `tuition_discount_percentage`, `created_at`, `updated_at`) VALUES (2, 4, 1, 3, 4.50, NULL, '2024-07-16 00:22:55', '2024-07-16 00:22:55'), (3, 3, 2, 1, 7.00, NULL, '2024-07-16 00:24:10', '2024-07-16 00:24:10'); -- -------------------------------------------------------- -- -- 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, '2019_12_14_000001_create_personal_access_tokens_table', 1), (2, '2024_07_15_075748_create_user_types_table', 1), (3, '2024_07_15_075956_create_categories_table', 2), (4, '2024_07_15_080124_create_subcategories_table', 3), (5, '2024_07_15_080230_create_products_table', 4), (6, '2024_07_15_080402_create_performance_categories_table', 5), (7, '2024_07_15_080533_create_discount_rules_table', 6); -- -------------------------------------------------------- -- -- Table structure for table `performance_categories` -- CREATE TABLE `performance_categories` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `min_score` int(11) NOT NULL, `max_score` int(11) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `performance_categories` -- INSERT INTO `performance_categories` (`id`, `name`, `min_score`, `max_score`, `created_at`, `updated_at`) VALUES (1, 'Good', 75, 84, '2024-07-15 04:47:53', '2024-07-15 04:47:53'), (2, 'Best', 85, 89, '2024-07-16 00:23:43', '2024-07-16 00:23:43'); -- -------------------------------------------------------- -- -- Table structure for table `personal_access_tokens` -- CREATE TABLE `personal_access_tokens` ( `id` bigint(20) UNSIGNED NOT NULL, `tokenable_type` varchar(255) NOT NULL, `tokenable_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `token` varchar(64) NOT NULL, `abilities` text DEFAULT NULL, `last_used_at` timestamp NULL DEFAULT NULL, `expires_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `products` -- CREATE TABLE `products` ( `id` bigint(20) UNSIGNED NOT NULL, `subcategory_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `base_price` decimal(10,2) NOT NULL, `sale_price` decimal(10,2) NOT NULL, `description` text DEFAULT NULL, `image_url` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `products` -- INSERT INTO `products` (`id`, `subcategory_id`, `name`, `base_price`, `sale_price`, `description`, `image_url`, `created_at`, `updated_at`) VALUES (3, 1, 'Laptop', 25000.00, 29999.99, 'hsdgcjhsdbc', 'storage/images/uVh5KSVxXONpHINfGSMIs1P5VZlb00o5SpwymxKR.jpg', '2024-07-15 05:37:47', '2024-07-15 05:37:47'), (4, 3, 'Bag', 1500.00, 1800.00, 'evjhdfgyucdbv', 'storage/images/oFuChhI3cyTYRuZt9oOeuOcrMgW13zTT3SAiRQHD.jpg', '2024-07-15 23:53:37', '2024-07-15 23:53:37'), (6, 1, 'Chair', 1200.00, 1400.00, 'dbsxjhbvcjhdcb', 'storage/images/BKGG7flwbDOr4497s8MDmqaacj1NumLpr1AwSLue.svg', '2024-07-16 00:52:29', '2024-07-16 00:52:29'); -- -------------------------------------------------------- -- -- Table structure for table `subcategories` -- CREATE TABLE `subcategories` ( `id` bigint(20) UNSIGNED NOT NULL, `category_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `description` 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 `subcategories` -- INSERT INTO `subcategories` (`id`, `category_id`, `name`, `description`, `created_at`, `updated_at`) VALUES (1, 1, 'AC', '(AC) is a system that removes heat and moisture from a space to create a more comfortable temperature and humidity level.', '2024-07-15 04:15:32', '2024-07-15 04:15:32'), (2, 2, 'Bata', 'ehdgbjeguf', '2024-07-15 05:20:02', '2024-07-15 05:20:02'), (3, 3, 'Gentext', 'wegfyuwgefyug', '2024-07-15 05:20:37', '2024-07-15 05:20:37'); -- -------------------------------------------------------- -- -- Table structure for table `user_types` -- CREATE TABLE `user_types` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `discount_multiplier` decimal(5,2) 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 `user_types` -- INSERT INTO `user_types` (`id`, `name`, `discount_multiplier`, `created_at`, `updated_at`) VALUES (1, 'Trainees', 1.00, '2024-07-15 03:58:23', '2024-07-15 03:58:23'), (2, 'Employees', 1.10, '2024-07-15 04:55:01', '2024-07-15 04:55:01'), (3, 'Outsiders', 0.90, '2024-07-15 04:55:08', '2024-07-15 04:55:08'); -- -- Indexes for dumped tables -- -- -- Indexes for table `categories` -- ALTER TABLE `categories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `discount_rules` -- ALTER TABLE `discount_rules` ADD PRIMARY KEY (`id`), ADD KEY `discount_rules_product_id_foreign` (`product_id`), ADD KEY `discount_rules_performance_category_id_foreign` (`performance_category_id`), ADD KEY `discount_rules_user_type_id_foreign` (`user_type_id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `performance_categories` -- ALTER TABLE `performance_categories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`), ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`); -- -- Indexes for table `products` -- ALTER TABLE `products` ADD PRIMARY KEY (`id`), ADD KEY `products_subcategory_id_foreign` (`subcategory_id`); -- -- Indexes for table `subcategories` -- ALTER TABLE `subcategories` ADD PRIMARY KEY (`id`), ADD KEY `subcategories_category_id_foreign` (`category_id`); -- -- Indexes for table `user_types` -- ALTER TABLE `user_types` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `categories` -- ALTER TABLE `categories` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `discount_rules` -- ALTER TABLE `discount_rules` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `performance_categories` -- ALTER TABLE `performance_categories` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- 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 `products` -- ALTER TABLE `products` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `subcategories` -- ALTER TABLE `subcategories` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `user_types` -- ALTER TABLE `user_types` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- Constraints for dumped tables -- -- -- Constraints for table `discount_rules` -- ALTER TABLE `discount_rules` ADD CONSTRAINT `discount_rules_performance_category_id_foreign` FOREIGN KEY (`performance_category_id`) REFERENCES `performance_categories` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `discount_rules_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `discount_rules_user_type_id_foreign` FOREIGN KEY (`user_type_id`) REFERENCES `user_types` (`id`) ON DELETE CASCADE; -- -- Constraints for table `products` -- ALTER TABLE `products` ADD CONSTRAINT `products_subcategory_id_foreign` FOREIGN KEY (`subcategory_id`) REFERENCES `subcategories` (`id`) ON DELETE CASCADE; -- -- Constraints for table `subcategories` -- ALTER TABLE `subcategories` ADD CONSTRAINT `subcategories_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;