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

START TRANSACTION;



--
-- 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 `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 `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 `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');

--
-- 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 `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 `payments`
--
ALTER TABLE `payments`
  ADD PRIMARY KEY (`id`);

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

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

--
-- 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 `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 `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;
COMMIT;

