-- phpMyAdmin SQL Dump -- version 5.0.2 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Nov 20, 2022 at 08:48 PM -- Server version: 10.4.11-MariaDB -- PHP Version: 7.4.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: `ecom-kapsul` -- -- -------------------------------------------------------- -- -- Table structure for table `carts` -- CREATE TABLE `carts` ( `id` bigint(20) UNSIGNED NOT NULL, `member_id` int(11) NOT NULL, `shipping_id` int(10) UNSIGNED DEFAULT NULL, `product_id` int(10) UNSIGNED NOT NULL, `product_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `product_image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `quantity` int(10) UNSIGNED NOT NULL, `price` int(10) UNSIGNED NOT NULL COMMENT 'not unit price', `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 `carts` -- INSERT INTO `carts` (`id`, `member_id`, `shipping_id`, `product_id`, `product_name`, `product_image`, `quantity`, `price`, `created_at`, `updated_at`) VALUES (2, 5, NULL, 25, 'BYHUBYENG Restaurant Pager Wireless Waiter Call System 1 Watch+5 Button Receiver', '/upload/products/image-1656488922.jpg', 2, 4000, '2022-06-29 09:20:52', '2022-06-29 09:20:57'), (3, 5, NULL, 13, 'EiD Special Premium Cotton Polo Shirt For Men', '/upload/products/image-1656487413.jpg', 3, 2700, '2022-06-29 09:21:54', '2022-06-29 09:21:59'), (4, 1, NULL, 6, 'Chocolate Combo Offer', '/upload/products/image-1656269442.jpg', 2, 1100, '2022-08-24 17:47:51', '2022-08-24 17:47:56'), (5, 1, NULL, 24, 'Smart Wifi RGB Symphony Lamp LED Pickup Light Bluetooth App Control Music Rhythm Lights Gaming Bar TV Computer Desk Ambient Lamp', '/upload/products/image-1656488852.jpg', 1, 18000, '2022-09-06 16:43:27', '2022-09-06 16:43:27'); -- -------------------------------------------------------- -- -- Table structure for table `categories` -- CREATE TABLE `categories` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `authored_by` 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 `categories` -- INSERT INTO `categories` (`id`, `name`, `authored_by`, `created_at`, `updated_at`) VALUES (1, 'MEN FASHION', 1, '2022-11-14 18:08:28', NULL); -- -------------------------------------------------------- -- -- 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 `members` -- CREATE TABLE `members` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `phone` varchar(255) NOT NULL, `address` text NOT NULL, `status` enum('Active','Inactive') NOT NULL COMMENT 'Active,Inactive', `image` varchar(255) DEFAULT NULL, `remember_token` varchar(255) DEFAULT NULL, `authored_by` int(11) DEFAULT NULL COMMENT 'authored_by needed if member is created by admin', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `members` -- INSERT INTO `members` (`id`, `name`, `email`, `password`, `phone`, `address`, `status`, `image`, `remember_token`, `authored_by`, `created_at`, `updated_at`) VALUES (1, 'Member1', 'member1@m.com', 'member1@m.com', '024656555', 'Address', 'Active', 'upload/member-profiles/avatar-1656087198.png', NULL, NULL, '2022-06-24 09:30:09', '2022-06-24 16:13:19'), (5, 'Member4', 'm4@m.com', 'm4@m.com', '6545656', 'adfasf', 'Active', 'upload/member-profiles/avatar-1656088994.png', NULL, NULL, '2022-06-24 16:43:14', '2022-06-24 16:43:14'); -- -------------------------------------------------------- -- -- 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 `orders` -- CREATE TABLE `orders` ( `id` int(11) NOT NULL, `member_id` varchar(255) NOT NULL, `payment_id` varchar(255) NOT NULL, `order_no` varchar(255) NOT NULL, `order_total` float NOT NULL, `shipping_date` varchar(255) NOT NULL, `address` text NOT NULL, `status` enum('Pending','Accepted','Shipping','Delivered','Cancelled') NOT NULL COMMENT 'Pending,Accepted,Shipping,Delivered,Cancelled', `authored_by` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `order_details` -- CREATE TABLE `order_details` ( `id` int(11) NOT NULL, `order_id` varchar(255) NOT NULL, `product_id` varchar(255) NOT NULL, `product_name` varchar(255) NOT NULL, `product_image` varchar(255) DEFAULT NULL, `quantity` int(11) NOT NULL, `price` float NOT NULL, `authored_by` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- 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 `payments` -- CREATE TABLE `payments` ( `id` int(11) NOT NULL, `payment_method` enum('cash_on_delivery','bKash') NOT NULL COMMENT 'cash_on_delivery,bKash', `trx_num` varchar(255) NOT NULL, `member_id` varchar(255) NOT NULL, `payment_from_mobile` varchar(255) DEFAULT NULL, `payment_to_mobile` varchar(255) DEFAULT NULL, `authored_by` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- 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 DEFAULT NULL, `last_used_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` int(11) NOT NULL, `name` varchar(255) NOT NULL, `category_id` varchar(255) NOT NULL, `price` float NOT NULL, `short_description` text DEFAULT NULL, `long_description` text DEFAULT NULL, `image` varchar(255) DEFAULT NULL, `authored_by` int(11) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `products` -- INSERT INTO `products` (`id`, `name`, `category_id`, `price`, `short_description`, `long_description`, `image`, `authored_by`, `created_at`, `updated_at`) VALUES (1, 'Grey Jeans', '1', 54.99, 'Grey-Jeans', 'Grey Jeans Grey Jeans Grey Jeans Grey Jeans Grey Jeans Grey Jeans Grey Jeans Grey Jeans ', 'images/men/mj01.jpg', 1, '2022-06-26 18:42:24', '2022-06-26 18:42:24'), (2, 'Blue Jeans', '1', 68.99, 'Blue Jeans', 'Blue Jeans Blue Jeans Blue Jeans Blue Jeans Blue Jeans', 'images/men/mj02.jpg', 1, '2022-06-26 18:42:24', '2022-06-26 18:42:24'), (27, 'Milk T-Shirt', '1', 34.99, 'Milk T-Shirt', 'Milk T-Shirt Milk T-Shirt Milk T-Shirt Milk T-Shirt ', 'images/men/mshi01.jpg', 1, '2022-11-14 18:12:03', '2022-11-14 18:12:03'), (28, 'Sport Shoes', '1', 42.99, 'Sport Shoes', 'Sport Shoes Sport Shoes Sport Shoes Sport Shoes Sport Shoes Sport Shoes ', 'images/men/msho01.jpg', 1, '2022-11-14 18:12:03', '2022-11-14 18:12:03'), (29, 'Casual Veston', '1', 42.99, 'Casual Veston', 'Casual Veston Casual Veston Casual Veston Casual Veston Casual Veston Casual Veston Casual Veston ', 'images/men/msu01.jpg', 1, '2022-11-14 18:12:03', '2022-11-14 18:12:03'), (30, 'White Blazer', '1', 42.99, 'White Blazer', 'White Blazer White Blazer White Blazer White Blazer White Blazer White Blazer ', 'images/men/msu02.jpg', 1, '2022-11-14 18:12:03', '2022-11-14 18:12:03'); -- -------------------------------------------------------- -- -- Table structure for table `sliders` -- CREATE TABLE `sliders` ( `id` int(11) NOT NULL, `slider_image` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `description` text DEFAULT NULL, `link` varchar(255) DEFAULT NULL, `authored_by` int(11) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `sliders` -- INSERT INTO `sliders` (`id`, `slider_image`, `title`, `description`, `link`, `authored_by`, `created_at`, `updated_at`) VALUES (2, '/upload/sliders/slider_image-1656007768.jpg', 'Gift', 'Gift', NULL, 1, '2022-06-23 18:09:28', '2022-06-23 18:09:28'), (4, '/upload/sliders/slider_image-1656144356.jpg', 'Men Collection', 'Men Collection', NULL, 1, '2022-06-25 08:05:56', '2022-06-25 08:05:56'), (5, '/upload/sliders/slider_image-1656144387.jpg', 'Mega Deals', 'Mega Deals', NULL, 1, '2022-06-25 08:06:27', '2022-06-25 08:06:27'), (6, '/upload/sliders/slider_image-1656144420.jpg', 'Phones and Accessories', 'Phones and Accessories', NULL, 1, '2022-06-25 08:07:00', '2022-06-25 08:07:00'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `role_id` int(10) UNSIGNED DEFAULT 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, `phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` enum('Inactive','Active') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Inactive' COMMENT 'Inactive, 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 `users` -- INSERT INTO `users` (`id`, `role_id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `phone`, `image`, `status`, `created_at`, `updated_at`) VALUES (1, NULL, 'Admin User', 'admin@admin.com', NULL, '$2y$10$dd2Z4JFXnMw/Vatp.t2ee.uVTbJhoIgJlRon8ITqYvYGcudwMJ', NULL, '154455', '/upload/profiles/User-1656071286.png', 'Active', '2021-10-28 01:57:36', '2022-06-24 11:48:06'); -- -- Indexes for dumped tables -- -- -- Indexes for table `carts` -- ALTER TABLE `carts` ADD PRIMARY KEY (`id`); -- -- Indexes for table `categories` -- ALTER TABLE `categories` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `categories_name_unique` (`name`); -- -- Indexes for table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`); -- -- Indexes for table `members` -- ALTER TABLE `members` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `email` (`email`), ADD UNIQUE KEY `phone` (`phone`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `orders` -- ALTER TABLE `orders` ADD PRIMARY KEY (`id`); -- -- Indexes for table `order_details` -- ALTER TABLE `order_details` ADD PRIMARY KEY (`id`); -- -- Indexes for table `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`email`); -- -- Indexes for table `payments` -- ALTER TABLE `payments` 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`); -- -- Indexes for table `sliders` -- ALTER TABLE `sliders` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`), ADD UNIQUE KEY `phone` (`phone`), ADD UNIQUE KEY `name` (`name`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `carts` -- ALTER TABLE `carts` 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=2; -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `members` -- ALTER TABLE `members` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `orders` -- ALTER TABLE `orders` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `order_details` -- ALTER TABLE `order_details` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `payments` -- ALTER TABLE `payments` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- 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` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31; -- -- AUTO_INCREMENT for table `sliders` -- ALTER TABLE `sliders` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=504; 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 */;