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

START TRANSACTION;



--
-- Database: `bdspk_test`
--

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

--
-- Table structure for table `banks`
--

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

INSERT INTO `banks` (`id`, `name`, `created_at`, `updated_at`) VALUES
(4, 'Agrani Bank LTD', '2025-02-13 15:31:44', '2025-02-13 19:05:58'),
(5, 'BRAC Bank', '2025-02-13 15:31:54', '2025-02-13 19:06:24'),
(6, 'Pubali Bank LTD', '2025-02-19 15:00:19', '2025-02-19 15:00:19');

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

--
-- Table structure for table `brands`
--

CREATE TABLE `brands` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_id` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT 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 `brands`
--

INSERT INTO `brands` (`id`, `category_id`, `name`, `image`, `description`, `created_at`, `updated_at`) VALUES
(1, '11', 'Samsung', NULL, NULL, '2025-02-08 13:47:51', '2025-02-08 13:47:51'),
(2, '12', 'Riversong', NULL, NULL, '2025-02-08 13:50:31', '2025-02-08 13:50:31'),
(3, '14', 'Hitachi', NULL, NULL, '2025-02-08 13:50:47', '2025-02-12 07:01:44'),
(4, '11', 'iPhone', NULL, NULL, '2025-02-08 14:14:08', '2025-02-08 14:19:52'),
(5, '11', 'Redmi', NULL, NULL, '2025-02-08 14:14:18', '2025-02-08 14:14:18'),
(6, '13', 'Hisense', '1739255494.svg', NULL, '2025-02-08 14:14:39', '2025-02-11 06:31:34'),
(7, '13', 'Samsung', '1739078190.png', NULL, '2025-02-08 14:14:46', '2025-02-09 05:16:30'),
(8, '15', 'Gree', NULL, NULL, '2025-02-08 14:15:06', '2025-02-08 14:15:06'),
(9, '15', 'Hisense', NULL, NULL, '2025-02-08 14:15:14', '2025-02-08 14:15:14'),
(10, '15', 'Haier', NULL, NULL, '2025-02-08 14:15:22', '2025-02-08 14:15:22'),
(11, '17', 'Whirlpool', NULL, NULL, '2025-02-08 14:16:10', '2025-02-08 14:16:10'),
(12, '16', 'Whirlpool', NULL, NULL, '2025-02-08 18:36:16', '2025-02-08 18:36:16'),
(13, '17', 'Walton', NULL, NULL, '2025-02-08 18:45:04', '2025-02-08 18:45:04'),
(14, '17', 'Sharp', NULL, NULL, '2025-02-08 18:45:14', '2025-02-08 18:45:14'),
(15, '17', 'Panasonic', NULL, NULL, '2025-02-08 18:45:22', '2025-02-08 18:45:22'),
(16, '14', 'Samsung', NULL, NULL, '2025-02-09 04:57:11', '2025-02-09 04:57:11'),
(17, '14', 'Whirlpool', NULL, NULL, '2025-02-09 04:57:50', '2025-02-09 04:57:50'),
(18, '14', 'Hisense', NULL, NULL, '2025-02-09 04:58:00', '2025-02-09 04:58:00'),
(19, '13', 'Haier', NULL, NULL, '2025-02-11 08:16:52', '2025-02-11 08:16:52'),
(21, '17', 'Hisense', NULL, NULL, '2025-02-12 15:18:53', '2025-02-12 15:18:53'),
(22, '16', 'Hisense', NULL, NULL, '2025-02-13 11:11:17', '2025-02-13 11:11:17'),
(23, '16', 'Samsung', NULL, NULL, '2025-02-13 11:11:25', '2025-02-13 11:11:25'),
(24, '11', 'Honor', NULL, NULL, '2025-02-17 06:34:57', '2025-02-17 06:34:57'),
(25, '18', 'Philips', NULL, NULL, '2025-02-18 13:41:58', '2025-02-18 13:41:58'),
(26, '12', 'TP Link', NULL, NULL, '2025-02-24 10:52:26', '2025-02-24 10:52:26'),
(27, '12', 'Tenda', NULL, NULL, '2025-02-26 08:04:11', '2025-02-26 08:04:11'),
(28, '12', 'TX 20 Pro', NULL, NULL, '2025-02-27 14:02:53', '2025-02-27 14:02:53');

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

--
-- Table structure for table `carts`
--

CREATE TABLE `carts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` varchar(255) DEFAULT NULL,
  `product_id` varchar(255) DEFAULT NULL,
  `productserial_id` varchar(255) DEFAULT NULL,
  `quantity` varchar(255) DEFAULT NULL,
  `discount_id` varchar(255) DEFAULT NULL,
  `discount_amount` varchar(255) DEFAULT NULL,
  `price_after_discount` varchar(255) DEFAULT NULL,
  `costing` 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 `carts`
--

INSERT INTO `carts` (`id`, `order_id`, `product_id`, `productserial_id`, `quantity`, `discount_id`, `discount_amount`, `price_after_discount`, `costing`, `created_at`, `updated_at`) VALUES
(90, '42', '52', '60', '1', '9', '5000', '26500.00', NULL, '2025-02-15 07:14:38', '2025-02-15 07:14:38'),
(92, '44', '87', '105', '1', '9', '15990', '63000.00', NULL, '2025-02-17 06:18:58', '2025-02-17 06:18:58'),
(93, '45', '48', '55', '1', NULL, NULL, '54900.00', NULL, '2025-02-17 07:47:35', '2025-02-17 07:47:35'),
(94, '46', '40', '43', '1', NULL, NULL, '51900.00', NULL, '2025-02-17 14:57:51', '2025-02-17 14:57:51'),
(97, '49', '47', '54', '1', NULL, '8900', '48900.00', NULL, '2025-02-18 07:20:23', '2025-02-18 07:20:23'),
(98, '50', '96', '112', '1', '9', '12190', '36000.00', NULL, '2025-02-18 14:04:41', '2025-02-18 14:04:41'),
(99, '51', '97', '113', '1', '9', NULL, '7500.00', NULL, '2025-02-18 14:06:30', '2025-02-18 14:06:30'),
(100, '52', '60', '69', '1', '9', '21900', '58000.00', NULL, '2025-02-19 15:00:50', '2025-02-19 15:00:50'),
(101, '53', '99', '116', '1', '9', '200', '10799.00', NULL, '2025-02-19 15:12:46', '2025-02-19 15:12:46'),
(102, '54', '99', '115', '1', '9', '200', '10799.00', NULL, '2025-02-19 15:19:36', '2025-02-19 15:19:36'),
(108, '60', '60', '70', '1', '9', '17900', '62000.00', NULL, '2025-02-20 04:47:39', '2025-02-20 04:47:39'),
(109, '61', '100', '121', '1', '9', '6900', '35000.00', NULL, '2025-02-22 14:11:17', '2025-02-22 14:11:17'),
(110, '62', '52', '61', '1', '9', '3500', '28000.00', NULL, '2025-02-23 13:33:43', '2025-02-23 13:33:43'),
(111, '63', '52', '62', '1', '9', '6500', '25000.00', NULL, '2025-02-24 06:44:19', '2025-02-24 06:44:19'),
(112, '64', '71', '86', '1', '9', '17900', '102000.00', NULL, '2025-02-24 07:39:23', '2025-02-24 07:39:23'),
(113, '65', '48', '128', '1', '9', '8400', '46500.00', NULL, '2025-02-24 10:50:34', '2025-02-24 10:50:34'),
(114, '66', '102', '131', '1', NULL, NULL, '3000.00', NULL, '2025-02-24 11:02:26', '2025-02-24 11:02:26'),
(115, '67', '47', '129', '1', '9', '7400', '41500.00', NULL, '2025-02-24 11:19:29', '2025-02-24 11:19:29'),
(118, '70', '60', '124', '1', '9', '12900', '67000.00', NULL, '2025-02-25 05:02:05', '2025-02-25 05:02:05'),
(124, '76', '85', '118', '1', '9', '3000', '17990.00', NULL, '2025-02-26 05:21:49', '2025-02-26 05:21:49'),
(125, '77', '103', '133', '1', NULL, NULL, '1600.00', NULL, '2025-02-26 08:10:49', '2025-02-26 08:10:49'),
(126, '78', '41', '39', '1', '9', '7890', '35500.00', NULL, '2025-02-27 13:26:12', '2025-02-27 13:26:12'),
(127, '79', '105', '135', '1', '9', '590', '2200.00', NULL, '2025-02-27 15:10:55', '2025-02-27 15:10:55'),
(128, '80', '73', '88', '1', '9', '7190', '41000.00', NULL, '2025-02-27 16:07:01', '2025-02-27 16:07:01'),
(129, '81', '107', '137', '1', '9', '14990', '48000.00', NULL, '2025-02-28 06:03:17', '2025-02-28 06:03:17'),
(130, '82', '72', '87', '1', '9', '5890', '34000.00', '500', '2025-03-01 09:34:15', '2025-03-01 09:34:15'),
(131, '83', '109', '139', '1', NULL, NULL, '28699.00', NULL, '2025-03-01 13:58:19', '2025-03-01 13:58:19'),
(132, '84', '106', '136', '1', '9', '5490', '36500.00', NULL, '2025-03-04 09:28:50', '2025-03-04 09:28:50'),
(133, '85', '63', '76', '1', '9', '18990', '56000.00', NULL, '2025-03-04 15:54:32', '2025-03-04 15:54:32'),
(134, '86', '110', '142', '1', '9', '2500', '30000.00', NULL, '2025-03-06 09:09:21', '2025-03-06 09:09:21'),
(135, '87', '96', '147', '1', '9', '9690', '40000.00', NULL, '2025-03-06 10:24:29', '2025-03-06 10:24:29'),
(136, '88', '106', '148', '1', '9', '5990', '36000.00', NULL, '2025-03-06 13:06:28', '2025-03-06 13:06:28'),
(137, '89', '60', '125', '1', NULL, '23900', '56000.00', NULL, '2025-03-08 08:41:00', '2025-03-08 08:41:00'),
(138, '90', '60', '126', '1', '9', '19900', '60000.00', '1200', '2025-03-09 09:14:28', '2025-03-09 09:14:28');

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT 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`, `image`, `description`, `created_at`, `updated_at`) VALUES
(11, 'Smartphones', NULL, NULL, '2025-02-08 13:41:43', '2025-02-17 06:34:45'),
(12, 'Gadgets', NULL, NULL, '2025-02-08 13:41:55', '2025-02-08 13:41:55'),
(13, 'TV', NULL, NULL, '2025-02-08 13:41:59', '2025-02-09 11:31:54'),
(14, 'Refregerator', NULL, NULL, '2025-02-08 13:42:10', '2025-02-08 13:42:10'),
(15, 'Air Conditioner', NULL, NULL, '2025-02-08 13:42:22', '2025-02-08 13:42:22'),
(16, 'Washing Machine', NULL, NULL, '2025-02-08 13:42:31', '2025-02-08 13:42:31'),
(17, 'Oven', NULL, NULL, '2025-02-08 13:42:36', '2025-02-08 13:42:36'),
(18, 'Home Appliances', NULL, NULL, '2025-02-08 13:42:46', '2025-02-08 13:42:46'),
(20, 'Smart Watch', NULL, NULL, '2025-02-23 14:30:04', '2025-02-23 14:30:04');

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

--
-- Table structure for table `costs`
--

CREATE TABLE `costs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `date` date DEFAULT NULL,
  `costbankaccount_id` varchar(255) DEFAULT NULL,
  `amount` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `remark` text DEFAULT NULL,
  `status` 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;

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

--
-- Table structure for table `cost_bank_accounts`
--

CREATE TABLE `cost_bank_accounts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` 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;

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

--
-- Table structure for table `cost_singles`
--

CREATE TABLE `cost_singles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `cost_id` varchar(255) DEFAULT NULL,
  `costsupplier_id` varchar(255) DEFAULT NULL,
  `amount` varchar(255) DEFAULT NULL,
  `remark` text 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 `cost_suppliers`
--

CREATE TABLE `cost_suppliers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `company` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `mobile` varchar(255) DEFAULT NULL,
  `address` 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;

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

--
-- Table structure for table `discounts`
--

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

INSERT INTO `discounts` (`id`, `name`, `created_at`, `updated_at`) VALUES
(8, 'Summer Offer', '2025-02-13 17:02:07', '2025-02-13 18:07:21'),
(9, 'Smart Plaza Offer', '2025-02-13 17:02:14', '2025-02-15 06:35:55');

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

--
-- Table structure for table `employees`
--

CREATE TABLE `employees` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `mobile` varchar(255) DEFAULT NULL,
  `designation` varchar(255) DEFAULT NULL,
  `nid` varchar(255) DEFAULT NULL,
  `image` text DEFAULT NULL,
  `address` text DEFAULT NULL,
  `salary` varchar(255) DEFAULT NULL,
  `status` 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 `employees`
--

INSERT INTO `employees` (`id`, `name`, `mobile`, `designation`, `nid`, `image`, `address`, `salary`, `status`, `created_at`, `updated_at`) VALUES
(15, 'Aabir Ahammed', '01677781890', 'Manager', NULL, NULL, NULL, '30000', NULL, '2025-02-13 17:01:25', '2025-02-15 06:33:11'),
(17, 'Md. Reajul Hasan', '01711744433', 'Manager', NULL, NULL, NULL, '35000', NULL, '2025-03-01 09:43:50', '2025-03-01 09:43:50'),
(18, 'Md. Emon Shaikh', '01618280078', 'Other', '3282020910', NULL, NULL, '10000', NULL, '2025-03-01 09:44:47', '2025-03-01 09:44:47'),
(19, 'Nahid Afandi', '01960254386', 'SalesMan', NULL, NULL, NULL, '10000', NULL, '2025-03-05 06:58:51', '2025-03-05 06:58:51');

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_reset_tokens_table', 1),
(3, '2014_10_12_100000_create_password_resets_table', 1),
(4, '2019_08_19_000000_create_failed_jobs_table', 1),
(5, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(7, '2025_01_15_144822_create_categories_table', 2),
(8, '2025_01_15_144830_create_products_table', 2),
(9, '2025_01_16_064145_create_orders_table', 3),
(10, '2025_01_16_070214_create_carts_table', 3),
(11, '2025_01_19_121509_create_cost_bank_accounts_table', 4),
(12, '2025_01_19_121520_create_costs_table', 4),
(13, '2025_01_19_121537_create_cost_suppliers_table', 4),
(14, '2025_01_19_121552_create_cost_singles_table', 4),
(15, '2025_02_04_164031_create_product_images_table', 5),
(16, '2025_02_04_164627_create_product_serials_table', 6),
(17, '2025_02_05_042336_create_employees_table', 7),
(18, '2025_01_15_144811_create_brands_table', 8),
(19, '2025_02_08_142538_create_types_table', 9),
(20, '2025_02_08_164102_create_sizes_table', 10),
(21, '2025_02_13_044623_create_discounts_table', 11),
(22, '2025_02_13_092955_create_payments_table', 12),
(23, '2025_02_13_141544_create_banks_table', 13);

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `client_name` varchar(255) DEFAULT NULL,
  `client_mobile` varchar(255) DEFAULT NULL,
  `client_email` varchar(255) DEFAULT NULL,
  `client_address` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `date_time` datetime DEFAULT NULL,
  `employee_id` 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 `orders`
--

INSERT INTO `orders` (`id`, `client_name`, `client_mobile`, `client_email`, `client_address`, `status`, `date_time`, `employee_id`, `created_at`, `updated_at`) VALUES
(42, 'Pradip Biswas', '01766127132', NULL, 'Patna, Noragati, Narail', 'Complete', '2025-02-15 13:14:00', '15', '2025-02-15 07:14:38', '2025-02-18 06:08:40'),
(44, 'MD Mahbub Hasan Munna', '01711029593', NULL, '1, Kakolibag, Royal Morh, Khulna', 'Complete', '2025-02-17 12:18:00', '15', '2025-02-17 06:18:58', '2025-02-18 06:08:20'),
(45, 'Uzzal', '01915975119', NULL, 'G1/4, Madhobi Port Colony, Mongla, Bagerhat.', 'Complete', '2025-02-17 13:47:00', '15', '2025-02-17 07:47:35', '2025-02-18 06:07:35'),
(46, 'Santa', '01911717392', NULL, '444/5, 2nd Phase, Sonadanga R/A, Khulna', 'Complete', '2025-02-17 20:57:00', '15', '2025-02-17 14:57:51', '2025-02-18 06:04:54'),
(49, 'Md. Rafiqul Islam', '01986928244', 'babuislam0187@gmail.com', 'Digraj, Mongla, Bagerhat', 'Complete', '2025-02-18 13:20:00', '15', '2025-02-18 07:20:23', '2025-02-18 07:20:23'),
(50, 'Mr. Ripon', '01968292643', NULL, 'Jomidar Bari, Belayet Hossain Sarak, Rupsha, Khulna', 'Complete', '2025-02-18 19:57:00', '15', '2025-02-18 14:04:41', '2025-02-18 14:04:41'),
(51, 'Mr. Ripon', '01968292643', NULL, 'Jomidar Bari, Belayet Hossain Sarak, Rupsha, Khulna', 'Complete', '2025-02-18 20:05:00', '15', '2025-02-18 14:06:30', '2025-02-18 14:06:30'),
(52, 'Md Harun-ar-Rashid', '01918452297', NULL, '23/3 Gha, Syed Ali Hossain Sarak, Al-Faruk Society, Sonadanga, Khulna', 'Complete', '2025-02-19 20:52:00', '15', '2025-02-19 15:00:50', '2025-02-19 15:00:50'),
(53, 'MD Mehedi Hasan', '01916494959', NULL, 'Boyra, Khulna', 'Complete', '2025-02-19 21:11:00', '15', '2025-02-19 15:12:46', '2025-02-19 15:12:46'),
(54, 'Mrinal Kanti Sarkar', '01711399078', NULL, '64, Nandanik Abedin Villa, Babu Khan Road, Khulna', 'Complete', '2025-02-13 16:33:00', '15', '2025-02-19 15:19:36', '2025-02-19 15:19:36'),
(60, 'Ibrahim Talukdar', '01911838224', NULL, 'Grameen Abashik, Sonadanga, Khulna', 'Complete', '2025-02-20 10:47:39', '15', '2025-02-20 04:47:39', '2025-02-20 04:47:39'),
(61, 'Mr. Mahfuj', '01775810670', NULL, '14, Ferryghat Road, Khulna', 'Complete', '2025-02-22 20:11:17', '15', '2025-02-22 14:11:17', '2025-02-22 14:11:17'),
(62, 'Sagor Molla', '01751255783', NULL, 'Condoni Mahal, Mosjid, Digholia, Senhati', 'Complete', '2025-02-23 19:33:43', '15', '2025-02-23 13:33:43', '2025-02-23 13:33:43'),
(63, 'Animesh Sarkar', '01719481542', NULL, 'Kaliganj, Shatkhira, Khulna', 'Complete', '2025-02-24 12:44:19', '15', '2025-02-24 06:44:19', '2025-02-24 06:44:19'),
(64, 'Samiur Rahman', '01798146111', NULL, 'BNS Titumir (Navy Base), Khalishpur, Khulna', 'Complete', '2025-02-24 13:39:23', '15', '2025-02-24 07:39:23', '2025-02-24 07:39:23'),
(65, 'M Jahir Raihan', '01712381225', NULL, 'Navy R/A, Boyra, Khulna', 'Complete', '2025-02-24 16:50:34', '15', '2025-02-24 10:50:34', '2025-02-24 10:50:34'),
(66, 'M Jahir Raihan', '01712381225', NULL, 'Navy R/A, Boyra, Khulna', 'Complete', '2025-02-24 17:02:26', '15', '2025-02-24 11:02:26', '2025-02-24 11:02:26'),
(67, 'Gour Kha', '01720349345', NULL, 'Pujakhola, Boyra, Khulna', 'Complete', '2025-02-24 17:19:29', '15', '2025-02-24 11:19:29', '2025-02-24 11:19:29'),
(70, 'MD Tarikul Islam', '01617247906', NULL, 'Khalishpur, Khulna', 'Complete', '2025-02-25 11:02:05', '15', '2025-02-25 05:02:05', '2025-02-25 05:02:05'),
(76, 'Farzana Islam Swarna', '01959275801', NULL, 'Staff Quarter, Mannan Store, Sheikhpara, Khulna', 'Complete', '2025-02-26 11:21:49', '15', '2025-02-26 05:21:49', '2025-02-26 05:21:49'),
(77, 'Mr. Shamsher', '01711076788', NULL, 'West Tutpara, Khulna', 'Complete', '2025-02-26 14:10:49', '15', '2025-02-26 08:10:49', '2025-02-26 08:10:49'),
(78, 'Reron', '01744417886', NULL, 'Lemon City, BGB Camp, Khulna', 'Complete', '2025-02-27 19:26:12', '15', '2025-02-27 13:26:12', '2025-02-27 13:26:12'),
(79, 'Mr. Nibir', '01911786528', NULL, 'Natun Bazar, Khulna', 'Complete', '2025-02-27 21:10:55', '15', '2025-02-27 15:10:55', '2025-02-27 15:10:55'),
(80, 'MD. Masud', '01993418777', NULL, 'Behind Al-Hera School, Hafiz Nagar, Khulna', 'Complete', '2025-02-27 22:07:01', '15', '2025-02-27 16:07:01', '2025-02-27 16:07:01'),
(81, 'Md Shafiqul Islam', '01711308508', NULL, 'Rowshan Monjil, 25, Haji Ismail Road, Dolphin Morh, Banorgati Bazar, Khulna', 'Complete', '2025-02-28 12:03:17', '15', '2025-02-28 06:03:17', '2025-02-28 06:03:17'),
(82, 'Md Masud Sarder', '01721428181', NULL, 'Nij Khamar, Zero Point, Khulna', 'Complete', '2025-03-01 15:34:15', '15', '2025-03-01 09:34:15', '2025-03-01 09:34:15'),
(83, 'Tawfique', '01791339628', NULL, 'Mia Para, Khulna', 'Complete', '2025-03-01 19:58:19', '15', '2025-03-01 13:58:19', '2025-03-01 13:58:19'),
(84, 'Nayeem Khan', '01717352963', NULL, 'Mohashin Morh, Dawlatpur, Khulna', 'Complete', '2025-03-04 15:28:50', '15', '2025-03-04 09:28:50', '2025-03-04 09:28:50'),
(85, 'Sankar Prashad Banik', '01626719693', NULL, '29/2 Boyra Central Road, Boyra, Khulna', 'Complete', '2025-03-04 21:54:32', '15', '2025-03-04 15:54:32', '2025-03-04 15:54:32'),
(86, 'MD. Sultan Hossain', '01962010167', NULL, 'Kohinoor Morh, Khalishpur, Khulna', 'Complete', '2025-03-06 15:09:21', '15', '2025-03-06 09:09:21', '2025-03-06 09:09:21'),
(87, 'Shopon Shom', '01716131587', NULL, 'West Hospital Para, Khulna', 'Complete', '2025-03-06 16:24:29', '15', '2025-03-06 10:24:29', '2025-03-06 10:24:29'),
(88, 'Saiful Islam', '01710720123', NULL, 'Babu Khan Road, Khulna', 'Complete', '2025-03-06 19:06:28', '18', '2025-03-06 13:06:28', '2025-03-06 13:06:28'),
(89, 'Md. Abdul Kashem', '01708919580', NULL, '64, West Tootpara, Haji Rahmat Ali Road, Khulna', 'Complete', '2025-03-08 14:41:00', '17', '2025-03-08 08:41:00', '2025-03-08 08:41:00'),
(90, 'Nurul Islam', '01791324801', NULL, 'Deara, 12 Punner mor, Aichgati, Rupsha. Khulna', 'Complete', '2025-03-09 15:14:28', '15', '2025-03-09 09:14:28', '2025-03-09 09:14:28');

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

--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` varchar(255) DEFAULT NULL,
  `paymant_type` varchar(255) DEFAULT NULL,
  `amount` varchar(255) DEFAULT NULL,
  `mobile_number` varchar(255) DEFAULT NULL,
  `txid` varchar(255) DEFAULT NULL,
  `bank_id` varchar(255) DEFAULT NULL,
  `bank_acc_number` varchar(255) DEFAULT NULL,
  `card_type` varchar(255) DEFAULT NULL,
  `card_acc_number` 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 `payments`
--

INSERT INTO `payments` (`id`, `order_id`, `paymant_type`, `amount`, `mobile_number`, `txid`, `bank_id`, `bank_acc_number`, `card_type`, `card_acc_number`, `created_at`, `updated_at`) VALUES
(19, '42', 'Cash', '26500', NULL, NULL, NULL, NULL, NULL, NULL, '2025-02-15 07:14:38', '2025-02-15 07:14:38'),
(22, '44', 'Cash', '63000', NULL, NULL, NULL, NULL, NULL, NULL, '2025-02-17 06:18:58', '2025-02-17 06:18:58'),
(23, '45', 'Cash', '45000', NULL, NULL, NULL, NULL, NULL, NULL, '2025-02-17 07:47:35', '2025-02-17 07:47:35'),
(24, '46', 'Cash', '43000', NULL, NULL, NULL, NULL, NULL, NULL, '2025-02-17 14:57:51', '2025-02-17 14:57:51'),
(27, '49', 'Cash', '40000', NULL, NULL, NULL, NULL, NULL, NULL, '2025-02-18 07:20:23', '2025-02-18 07:20:23'),
(28, '50', 'Cash', '36000', NULL, NULL, NULL, NULL, NULL, NULL, '2025-02-18 14:04:41', '2025-02-18 14:04:41'),
(29, '51', 'Cash', '7500', NULL, NULL, NULL, NULL, NULL, NULL, '2025-02-18 14:06:30', '2025-02-18 14:06:30'),
(30, '52', 'Cash', '50000', NULL, NULL, NULL, NULL, NULL, NULL, '2025-02-19 15:00:50', '2025-02-19 15:00:50'),
(31, '52', 'Bank', '8000', NULL, '118393', NULL, NULL, NULL, NULL, '2025-02-19 15:00:50', '2025-02-19 15:00:50'),
(32, '53', 'Cash', '10799', NULL, NULL, NULL, NULL, NULL, NULL, '2025-02-19 15:12:46', '2025-02-19 15:12:46'),
(33, '54', 'Cash', '10799', NULL, NULL, NULL, NULL, NULL, NULL, '2025-02-19 15:19:36', '2025-02-19 15:19:36'),
(39, '60', 'Cash', '62000', NULL, NULL, NULL, NULL, NULL, NULL, '2025-02-20 04:47:39', '2025-02-20 04:47:39'),
(40, '61', 'Cash', '35000', NULL, NULL, NULL, NULL, NULL, NULL, '2025-02-22 14:11:17', '2025-02-22 14:11:17'),
(41, '62', 'Cash', '28000', NULL, NULL, NULL, NULL, NULL, NULL, '2025-02-23 13:33:43', '2025-02-23 13:33:43'),
(42, '63', 'b-Kash', '25000', NULL, 'CB054RB55B', NULL, NULL, NULL, NULL, '2025-02-24 06:44:19', '2025-02-24 06:44:19'),
(43, '64', 'Cash', '102000', NULL, NULL, NULL, NULL, NULL, NULL, '2025-02-24 07:39:23', '2025-02-24 07:39:23'),
(44, '65', 'Cash', '46500', NULL, NULL, NULL, NULL, NULL, NULL, '2025-02-24 10:50:34', '2025-02-24 10:50:34'),
(45, '66', 'Cash', '3000', NULL, NULL, NULL, NULL, NULL, NULL, '2025-02-24 11:02:26', '2025-02-24 11:02:26'),
(46, '67', 'Bank', '41500', NULL, '637005', '6', NULL, NULL, NULL, '2025-02-24 11:19:29', '2025-02-24 11:19:29'),
(50, '70', 'Cash', '67000', NULL, NULL, NULL, NULL, NULL, NULL, '2025-02-25 05:02:05', '2025-02-25 05:02:05'),
(52, '76', 'Cash', '17990', NULL, NULL, NULL, NULL, NULL, NULL, '2025-02-26 05:21:49', '2025-02-26 05:21:49'),
(53, '77', 'Cash', '1600', NULL, NULL, NULL, NULL, NULL, NULL, '2025-02-26 08:10:49', '2025-02-26 08:10:49'),
(54, '78', 'Cash', '35500', NULL, NULL, NULL, NULL, NULL, NULL, '2025-02-27 13:26:12', '2025-02-27 13:26:12'),
(55, '79', 'Cash', '2200', NULL, NULL, NULL, NULL, NULL, NULL, '2025-02-27 15:10:55', '2025-02-27 15:10:55'),
(56, '80', 'Cash', '41000', NULL, NULL, NULL, NULL, NULL, NULL, '2025-02-27 16:07:01', '2025-02-27 16:07:01'),
(57, '81', 'Cash', '48000', NULL, NULL, NULL, NULL, NULL, NULL, '2025-02-28 06:03:17', '2025-02-28 06:03:17'),
(58, '82', 'Cash', '31000', NULL, NULL, NULL, NULL, NULL, NULL, '2025-03-01 09:34:15', '2025-03-01 09:34:15'),
(59, '83', 'Cash', '0', NULL, NULL, NULL, NULL, NULL, NULL, '2025-03-01 13:58:19', '2025-03-01 13:58:19'),
(60, '84', 'Cash', '36500', NULL, NULL, NULL, NULL, NULL, NULL, '2025-03-04 09:28:50', '2025-03-04 09:28:50'),
(61, '85', 'Cash', '56000', NULL, NULL, NULL, NULL, NULL, NULL, '2025-03-04 15:54:32', '2025-03-04 15:54:32'),
(62, '86', 'Cash', '25000', NULL, NULL, NULL, NULL, NULL, NULL, '2025-03-06 09:09:21', '2025-03-06 09:09:21'),
(63, '87', 'Cash', '30000', NULL, NULL, NULL, NULL, NULL, NULL, '2025-03-06 10:24:29', '2025-03-06 10:24:29'),
(64, '88', 'Cash', '36000', NULL, NULL, NULL, NULL, NULL, NULL, '2025-03-06 13:06:28', '2025-03-06 13:06:28'),
(65, '89', 'Cash', '56000', NULL, NULL, NULL, NULL, NULL, NULL, '2025-03-08 08:41:00', '2025-03-08 08:41:00'),
(66, '90', 'Cash', '60000', NULL, NULL, NULL, NULL, NULL, NULL, '2025-03-09 09:14:28', '2025-03-09 09:14:28');

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_id` varchar(255) DEFAULT NULL,
  `brand_id` varchar(255) DEFAULT NULL,
  `type_id` varchar(255) DEFAULT NULL,
  `size_id` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `serial` varchar(255) DEFAULT NULL,
  `model` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `main_price` varchar(255) DEFAULT NULL,
  `discount_price` varchar(255) DEFAULT NULL,
  `price` varchar(255) DEFAULT NULL,
  `purchase` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `stock` 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`, `category_id`, `brand_id`, `type_id`, `size_id`, `name`, `serial`, `model`, `image`, `main_price`, `discount_price`, `price`, `purchase`, `description`, `stock`, `created_at`, `updated_at`) VALUES
(40, '13', '7', '11', '9', 'Samsung 43\" (DU7700) Crystal 4K UHD Smart TV', NULL, 'UA43DU7700RSER', NULL, '55900', '4000', '51900.00', '39150', NULL, NULL, '2025-02-09 04:53:41', '2025-02-22 07:30:01'),
(41, '14', '17', '1', '5', 'Whirlpool Frost Magic Pro Crystal Black', NULL, 'FMPGDCB', '1739077420.jpg', '43390', NULL, '43390.00', '31673', NULL, NULL, '2025-02-09 05:03:40', '2025-02-12 15:04:00'),
(45, '13', '6', '11', '11', 'Hisense 55\" Bezelless Dolby Vision 4K UHD Smart LED Voice Control Google DTS TV', NULL, '55A6F3', '1739257271.png', '79900', NULL, '79900.00', '61199', NULL, NULL, '2025-02-11 07:01:11', '2025-02-11 07:01:11'),
(46, '13', '6', '11', '10', 'Hisense 50\" Bezelless Dolby Vision 4K UHD Smart LED Voice Control Google DTS TV', NULL, '50A6F3', '1739258157.png', '67900', NULL, '67900.00', '52062', NULL, NULL, '2025-02-11 07:15:57', '2025-02-11 07:15:57'),
(47, '13', '6', '11', '9', 'Hisense 43\" Bezelless Dolby Vision 4K UHD Smart LED Voice Control Google DTS TV', NULL, '43A6F3', '1739259366.png', '48900', NULL, '48900.00', '37555', NULL, NULL, '2025-02-11 07:36:06', '2025-02-11 07:36:06'),
(48, '13', '6', '9', '9', 'Hisense 43\" Quantum Dot 4K ULED Smart Dolby Atmos Dolby Vision Voice Control Google TV', NULL, '43U6F3', '1739259830.png', '54900', NULL, '54900.00', '42200', NULL, NULL, '2025-02-11 07:43:50', '2025-02-11 07:53:37'),
(49, '13', '6', '10', '9', 'Hisesnse 43\" Bezelless Full HD Smart Android WIFI DTS TV', NULL, '43A4F4', '1739260872.png', '39900', NULL, '39900.00', '30588', NULL, NULL, '2025-02-11 08:01:12', '2025-02-11 08:01:12'),
(50, '13', '19', '10', '9', 'Haier 43\" FHD Google TV', NULL, 'H43K800FX', '1739262159.webp', '39900', '3000', '36900.00', '31000', NULL, NULL, '2025-02-11 08:22:39', '2025-02-11 08:25:28'),
(51, '13', '7', '11', '12', 'Samsung 65\" (DU7700) Crystal 4K UHD Smart TV', NULL, 'UA65DU7700RSER', '1739271882.avif', '139900', '5000', '134900.00', '10918', NULL, NULL, '2025-02-11 11:04:42', '2025-02-11 11:04:42'),
(52, '13', '7', '12', '8', 'Samsung 32\" (T4400) Smart HD TV', NULL, 'UA32T4400ARSER', '1739274237.avif', '31500', NULL, '31500.00', '20970', NULL, NULL, '2025-02-11 11:43:57', '2025-02-16 11:08:30'),
(53, '15', '9', '6', '18', 'Hisense 2 Ton Full DC Inverter AC', NULL, 'AS22TW4RXBTD00BU', '1739277361.png', '95900', NULL, '95900.00', '64882', NULL, NULL, '2025-02-11 12:36:01', '2025-02-11 12:36:01'),
(60, '15', '9', '6', '17', 'Hisense 1.5 Ton Full DC Inverter AC', NULL, 'AS18TW4RMATD01BU', NULL, '79900', NULL, '79900.00', '52600', NULL, NULL, '2025-02-11 12:53:31', '2025-02-22 13:10:23'),
(61, '15', '9', '6', '16', 'Hisense 1 Ton Full DC Inverter AC', NULL, 'AS12TW4RYETD00BU', '1739279685.png', '59900', NULL, '59900.00', '39018', NULL, NULL, '2025-02-11 13:14:45', '2025-02-11 13:14:45'),
(62, '15', '8', '7', '17', 'Gree GS-18XMU32-Gree Muse Split Type Air Conditioner (1.5 TON)', NULL, 'GS-18XMU32', '1739282054.jpg', '67990', NULL, '67990.00', '52000', NULL, NULL, '2025-02-11 13:54:14', '2025-02-11 14:03:47'),
(63, '15', '10', '6', '17', 'Haier CleanCool Inverter 1.5 Ton', NULL, 'HSU-18CleanCool:(INV)(3DF)(QA)', NULL, '74990', NULL, '74990.00', '54000', NULL, NULL, '2025-02-11 14:03:27', '2025-02-11 14:08:41'),
(64, '15', '10', '6', '17', 'Haier UVCool Inverter 1.5 Ton', NULL, 'HSU-18UVCool:(INV)(Wifi)(3DF)(PCS)', NULL, '77990', NULL, '77990.00', '59000', NULL, NULL, '2025-02-11 14:15:28', '2025-02-11 14:15:28'),
(65, '15', '10', '6', '17', 'Haier EnergyCool Inverter 1.5 Ton', NULL, 'HSU-18EnergyCool:(INV)(3DF)(QE)', NULL, '74990', NULL, '74990.00', '54000', NULL, NULL, '2025-02-11 14:24:53', '2025-02-11 14:24:53'),
(66, '15', '10', '6', '18', 'Haier CleanCool Inverter 2 Ton', NULL, 'HSU-24CleanCool:(INV)(3DF)(QA)', NULL, '90990', NULL, '90990.00', '67300', NULL, NULL, '2025-02-11 14:26:58', '2025-02-11 14:26:58'),
(67, '13', '6', '12', '8', 'Hisense 32\" Bezelless HD Smart Android WIFI DTS TV 32A4F4', NULL, '32A4F4', NULL, '27900', NULL, '27900.00', '21598', NULL, NULL, '2025-02-11 14:36:04', '2025-02-11 14:36:04'),
(68, '14', '3', '2', '19', 'Hitachi Stylish Line Refrigerator R-VG490P8PB (XRZ) (KD) 443 Litre', NULL, 'R-VG490P8PB', NULL, '157400', '7500', '149900.00', '118500', NULL, NULL, '2025-02-12 13:41:11', '2025-02-12 14:34:57'),
(69, '14', '3', '2', '21', 'Hitachi Stylish Line Refrigerator R-VG460P8PB (KD) (GBK) 403 Litre', NULL, 'R-VG460P8PB', NULL, '141650', '6750', '134900.00', '106240', NULL, NULL, '2025-02-12 13:58:14', '2025-02-12 14:35:19'),
(70, '14', '3', '2', '22', 'Hitachi Stylish Line Refrigerator R-VG420P8PB (KD) (XRZ) 375 Litre', NULL, 'R-VG420P8PB', NULL, '122750', '5850', '116900.00', '92065', NULL, NULL, '2025-02-12 14:15:17', '2025-02-12 14:35:37'),
(71, '14', '16', '2', '20', 'Samsung RT38 8A 393L Top Mount Freezer (Bespoke)', NULL, 'RT38CB66448AME', NULL, '129900', '10000', '119900.00', '100000', NULL, NULL, '2025-02-12 14:34:23', '2025-02-12 14:34:23'),
(72, '14', '17', '1', '5', 'Whirlpool Fresh Magic Pro 236 Litre Steel Onyx', NULL, 'FMPSO', NULL, '39890', NULL, '39890.00', '28721', NULL, NULL, '2025-02-12 15:02:38', '2025-02-12 15:02:38'),
(73, '14', '17', '1', '23', 'Whirlpool Frost Magic Pro Crystal Black', NULL, 'FMPGDCB', NULL, '49690', NULL, '49690.00', '35777', NULL, NULL, '2025-02-12 15:07:42', '2025-03-06 15:01:21'),
(74, '17', '11', '13', '25', 'Whirlpool Magicook Pro 25GE Grill Microwave 25L', NULL, 'MCP25GE', NULL, '17990', NULL, '17990.00', '12953', NULL, NULL, '2025-02-12 15:24:48', '2025-02-12 15:24:48'),
(75, '17', '21', '13', '25', 'Hisense 25L Solo MWO with Grey Cavity H25MOBS5H', NULL, 'H25MOBS5H', NULL, '15400', NULL, '15400.00', '11922', NULL, NULL, '2025-02-12 15:30:06', '2025-02-12 15:30:06'),
(76, '17', '21', '14', '26', 'Hisense 28L Convection MWO with Easy-Clean SS Cavity', NULL, 'H28MOBS10HC', NULL, '24900', NULL, '24900.00', '19276', NULL, NULL, '2025-02-12 15:33:17', '2025-02-12 15:33:17'),
(77, '17', '21', '14', '26', 'Hisense 28L Convection MWO with Easy-Clean SS Cavity (Push Door) HMBC2809DSC', NULL, 'HMBC2809DSC', NULL, '25900', NULL, '25900.00', '20050', NULL, NULL, '2025-02-12 15:36:07', '2025-02-12 15:36:07'),
(78, '14', '16', '2', '28', 'Samsung Refrigerator RT35CG5420B1 348 Litre', NULL, 'RT35CG5420B1', NULL, '102900', '5000', '97900.00', '75000', NULL, NULL, '2025-02-12 15:50:35', '2025-02-12 15:50:35'),
(82, '16', '22', '17', '1', 'Hisense 8 kg Top Load Washing Machine', NULL, 'WTJA8012UT/BD3', NULL, '34900', NULL, '34900.00', '27222', NULL, NULL, '2025-02-13 11:32:58', '2025-02-13 11:32:58'),
(83, '16', '22', '16', '1', 'Hisense 8 kg Front Load Washing Machine', NULL, 'WF3S8043BW', NULL, '64900', NULL, '64900.00', '50622', NULL, NULL, '2025-02-13 11:39:47', '2025-02-13 11:39:47'),
(84, '16', '12', '17', '31', 'Whirlpool PRO H Graphite 360 Bloomwash Washing Machine | 9.5KG (with Advanced In-Built Heater)', NULL, '360BWP-H9.5', NULL, '50490', NULL, '50490.00', '37363', NULL, NULL, '2025-02-13 11:57:02', '2025-02-13 11:57:02'),
(85, '17', '11', '19', NULL, 'Whirlpool Magicook Pro 30GE GRILL Microwave 30L', NULL, '50054', NULL, '20990', NULL, '20990.00', '15113', NULL, NULL, '2025-02-16 07:21:33', '2025-02-20 06:20:14'),
(86, '17', '11', '14', '27', 'Whirlpool Magicook Convection Black Mirror 30L MICROWAVE', NULL, '50039', NULL, '27990', NULL, '27990.00', '24351', NULL, NULL, '2025-02-16 07:28:23', '2025-02-20 06:14:06'),
(87, '16', '12', '16', '32', 'Whirlpool Sanicare WDC v11704RG-D (11 Kg) Front Load Washing Machine', NULL, 'WDC11704RG-X', NULL, '78990', NULL, '78990.00', '58453', NULL, NULL, '2025-02-17 06:15:55', '2025-02-17 06:15:55'),
(96, '14', '17', '1', '23', 'Whirlpool Fresh Magic Pro 278L Glow Refrigerator', NULL, 'FMP 278L GDG', NULL, '49690', NULL, '49690.00', '35777', NULL, NULL, '2025-02-18 13:40:21', '2025-03-06 10:21:07'),
(97, '18', '25', '18', '34', 'Philips HL7757 750W 3 Jar Mixer Grinder', NULL, 'HL7757/00', NULL, '9990', '2490', '7500.00', '6290', NULL, NULL, '2025-02-18 13:48:18', '2025-02-18 13:48:18'),
(98, '14', '17', '1', '23', 'Whirlpool Refrigerator Fresh Magic Pro 278L GD Direct Cool Mirror Inverter', NULL, 'FMP278LGDM', NULL, '51290', NULL, '51290.00', '36929', NULL, NULL, '2025-02-19 11:00:49', '2025-02-19 11:00:49'),
(99, '11', '24', NULL, NULL, 'HONOR X5b', NULL, 'X5b', NULL, '10999', NULL, '10999.00', '10425', NULL, NULL, '2025-02-19 15:08:01', '2025-02-19 15:08:01'),
(100, '14', '18', '20', '35', 'Hisense 189 L Chest Freezer', NULL, 'BD189BLK', NULL, '41900', NULL, '41900.00', '31583', NULL, NULL, '2025-02-22 12:49:33', '2025-02-22 12:49:33'),
(101, '14', '18', '20', '36', 'Hisense 240 L Chest Freezer', NULL, 'BD240BLK', NULL, '45900', NULL, '45900.00', '34800', NULL, NULL, '2025-02-22 12:52:31', '2025-02-22 12:52:31'),
(102, '12', '26', '21', NULL, 'TP Link AC1200 Wifi Router', NULL, 'Archer C64', NULL, '3200', '200', '3000.00', '2900', NULL, NULL, '2025-02-24 10:59:10', '2025-02-24 10:59:10'),
(103, '12', '27', '21', NULL, 'Router Tenda N300 MBPS F6 4 Antinawireless', NULL, 'F6', NULL, '1600', NULL, '1600.00', '1350', NULL, NULL, '2025-02-26 08:06:51', '2025-02-26 08:06:51'),
(104, '16', '23', '17', '37', 'Samsung Top Loading Washing Maching-7.5KG-WA75H4200SYUTL', NULL, 'WA75H4200SYUTL', NULL, '37900', '2000', '35900.00', '15500', NULL, NULL, '2025-02-26 10:56:08', '2025-02-26 10:56:08'),
(105, '12', '28', '22', NULL, 'TV Card TX 20 Pro', NULL, 'TX 20 Pro', NULL, '2790', NULL, '2790.00', '1890', NULL, NULL, '2025-02-27 14:05:20', '2025-02-27 14:05:20'),
(106, '16', '12', '17', '1', 'Whirlpool SW PRO 8.0 KG GREY 10YMW Fully Automatic Washing Machine', NULL, '31635', NULL, '41990', NULL, '41990.00', '31073', NULL, NULL, '2025-02-27 14:14:46', '2025-02-27 14:14:46'),
(107, '15', '10', '7', '17', 'Haier TurboCool Non-Inverter AC', NULL, 'HSU-18TurboCool:(FIX)(PA)', NULL, '62990', NULL, '62990.00', '44500', NULL, NULL, '2025-02-28 06:00:12', '2025-02-28 06:00:12'),
(108, '14', '17', '2', '23', 'Whirlpool Refrigerator Neofresh Inverter 278 Prm Crystal Black | 25008', NULL, '25008', NULL, '64890', NULL, '64890.00', NULL, NULL, NULL, '2025-03-01 05:45:09', '2025-03-01 05:45:09'),
(109, '11', '1', NULL, NULL, 'Samsung Galaxy A15 5G', NULL, 'SM-A156E/DS', NULL, '28699', NULL, '28699.00', '27100', NULL, NULL, '2025-03-01 13:56:11', '2025-03-01 13:56:11'),
(110, '13', '7', '12', '8', 'Samsung 32\" (T4450) Smart HD TV 80 cm', NULL, 'UA32T4450ARSER', NULL, '32500', NULL, '32500.00', '21200', NULL, NULL, '2025-03-01 14:55:32', '2025-03-06 09:04:30'),
(111, '11', '5', NULL, NULL, 'Redmi 10s Pro', NULL, '10s Pro', NULL, '26000', '500', '25500.00', '23000', NULL, NULL, '2025-03-03 04:20:02', '2025-03-03 04:20:02');

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

--
-- Table structure for table `product_images`
--

CREATE TABLE `product_images` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` varchar(255) DEFAULT NULL,
  `image` 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 `product_images`
--

INSERT INTO `product_images` (`id`, `product_id`, `image`, `created_at`, `updated_at`) VALUES
(10, '45', '1739257496.png', '2025-02-11 07:04:56', '2025-02-11 07:04:56'),
(11, '45', '1739257506.png', '2025-02-11 07:05:06', '2025-02-11 07:05:06'),
(12, '45', '1739257516.png', '2025-02-11 07:05:16', '2025-02-11 07:05:16'),
(13, '45', '1739257525.png', '2025-02-11 07:05:25', '2025-02-11 07:05:25');

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

--
-- Table structure for table `product_serials`
--

CREATE TABLE `product_serials` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` varchar(255) DEFAULT NULL,
  `serial` varchar(255) DEFAULT NULL,
  `quantity` 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 `product_serials`
--

INSERT INTO `product_serials` (`id`, `product_id`, `serial`, `quantity`, `created_at`, `updated_at`) VALUES
(39, '41', 'BDA244100068', '0', '2025-02-09 11:11:49', '2025-02-27 13:26:12'),
(43, '40', '0VK4389XA00240', '0', '2025-02-09 11:12:14', '2025-02-17 14:57:51'),
(51, '45', '55A6F3B8EX900770', '1', '2025-02-11 07:01:11', '2025-02-14 05:28:56'),
(52, '45', '55A6F3B8EX900943', '1', '2025-02-11 07:01:11', '2025-02-11 07:01:11'),
(53, '46', '3TE50K2405080', '1', '2025-02-11 07:15:57', '2025-02-11 07:15:57'),
(54, '47', '43A6F3V8EX900588', '0', '2025-02-11 07:36:06', '2025-02-18 07:20:23'),
(55, '48', '3TE43K24051Q0192EJS0451', '0', '2025-02-11 07:43:50', '2025-02-17 07:47:35'),
(56, '49', '43A4F4V8EX900960', '1', '2025-02-11 08:01:12', '2025-02-11 08:01:12'),
(57, '50', 'DH1U8RD050008Q6R4726', '1', '2025-02-11 08:22:39', '2025-02-11 08:22:39'),
(58, '51', '0VKD389XC00041', '1', '2025-02-11 11:04:42', '2025-03-12 03:03:26'),
(59, '52', '0BG1389XC00397', '1', '2025-02-11 11:43:57', '2025-02-11 11:43:57'),
(60, '52', '0BG1389XC00395', '0', '2025-02-11 11:43:57', '2025-02-15 07:14:38'),
(61, '52', '0BG1389XC00297', '0', '2025-02-11 11:43:57', '2025-02-23 13:33:43'),
(62, '52', '0BG1389XC00408', '0', '2025-02-11 11:43:57', '2025-02-24 06:44:19'),
(63, '53', 'AUC0A7SX602674T', '1', '2025-02-11 12:36:01', '2025-02-11 12:36:01'),
(64, '53', 'AUC0A7SX500045X', '1', '2025-02-11 12:36:01', '2025-02-11 12:36:01'),
(68, '60', 'AUB0A7SX903809Y', '1', '2025-02-11 12:53:31', '2025-03-12 03:03:32'),
(69, '60', 'AUB0A7SX903825W', '0', '2025-02-11 12:53:31', '2025-02-19 15:00:50'),
(70, '60', 'AUB0A7SX903818A', '0', '2025-02-11 12:53:31', '2025-02-20 04:47:39'),
(71, '61', 'AUA0A7SX901113L', '1', '2025-02-11 13:14:45', '2025-02-11 13:14:45'),
(72, '61', 'AUA0A7SX901101H', '1', '2025-02-11 13:14:45', '2025-02-11 13:14:45'),
(73, '62', '18BK016AA2603', '1', '2025-02-11 13:54:14', '2025-02-11 13:54:14'),
(74, '62', '18BK016AA2648', '1', '2025-02-11 13:54:14', '2025-02-11 13:54:14'),
(75, '63', 'AABUQCZ00001KQ6RB383', '1', '2025-02-11 14:03:27', '2025-02-11 14:03:27'),
(76, '63', 'AABUQCZ00001KQ6RB415', '0', '2025-02-11 14:03:27', '2025-03-04 15:54:32'),
(77, '63', 'AABUQCZ00001KQ6RA952', '1', '2025-02-11 14:03:27', '2025-02-11 14:03:27'),
(78, '64', 'AABUQBZ00001KQ6B3825', '1', '2025-02-11 14:15:28', '2025-02-11 14:15:28'),
(79, '65', 'AABUQAZ00001KQ745806', '1', '2025-02-11 14:24:53', '2025-02-11 14:24:53'),
(80, '66', 'AAC1UFZ01001KQ792713', '1', '2025-02-11 14:26:58', '2025-02-11 14:26:58'),
(81, '67', '32A4F4V8EY100878', '1', '2025-02-11 14:36:04', '2025-02-11 14:36:04'),
(82, '67', '32A4F4V8EY100896', '1', '2025-02-11 14:36:04', '2025-02-11 14:36:04'),
(83, '68', '2300008512', '1', '2025-02-12 13:41:11', '2025-02-12 13:41:11'),
(84, '69', '2300003512', '1', '2025-02-12 13:58:14', '2025-02-14 06:40:23'),
(85, '70', '2131100106', '1', '2025-02-12 14:15:17', '2025-02-12 14:15:17'),
(86, '71', '0KYR4DAXB00087X', '0', '2025-02-12 14:34:23', '2025-02-24 07:39:23'),
(87, '72', 'BDA245200082', '0', '2025-02-12 15:02:38', '2025-03-01 09:34:15'),
(88, '73', '7300301250300110', '0', '2025-02-12 15:07:42', '2025-02-27 16:07:01'),
(89, '74', 'CNC24070751', '1', '2025-02-12 15:24:48', '2025-03-10 23:05:13'),
(90, '75', 'MSB1M7SXA00410P', '1', '2025-02-12 15:30:06', '2025-02-12 15:30:06'),
(91, '76', 'MCA1M7SY100175B', '1', '2025-02-12 15:33:17', '2025-02-12 15:33:17'),
(92, '77', 'MCA2M7SY100407X', '1', '2025-02-12 15:36:07', '2025-02-12 15:36:07'),
(93, '78', '0L1R4DAXA00035', '1', '2025-02-12 15:50:35', '2025-03-11 14:24:34'),
(100, '82', 'WTB0W7SXC00229F', '1', '2025-02-13 11:32:58', '2025-03-12 03:03:26'),
(101, '83', '1WJ080843V0WW88UB120081', '1', '2025-02-13 11:39:47', '2025-03-11 14:39:48'),
(102, '84', '3149601244222148', '1', '2025-02-13 11:57:02', '2025-03-10 23:20:42'),
(103, '85', 'CNC24071025', '1', '2025-02-16 07:21:33', '2025-02-16 07:21:33'),
(104, '86', '540Q18603014C251100344', '1', '2025-02-16 07:28:23', '2025-03-12 03:03:32'),
(105, '87', '301G2773240712C09BV', '0', '2025-02-17 06:15:55', '2025-02-17 06:18:58'),
(112, '96', '7332201245200046', '0', '2025-02-18 13:40:21', '2025-02-18 14:04:41'),
(113, '97', 'N/A', '0', '2025-02-18 13:48:18', '2025-02-18 14:06:30'),
(114, '98', '7327001245200030', '1', '2025-02-19 11:00:49', '2025-02-19 11:00:49'),
(115, '99', '864426076862426', '0', '2025-02-19 15:08:01', '2025-02-19 15:19:36'),
(116, '99', '864426076844135', '0', '2025-02-19 15:08:01', '2025-02-19 15:12:46'),
(118, '85', 'CNC24071422', '0', '2025-02-20 06:51:57', '2025-02-26 05:21:49'),
(119, '51', '0VKD389X900199', '1', '2025-02-22 07:31:26', '2025-03-10 13:19:04'),
(120, '40', '0VK4389XB00341', '1', '2025-02-22 07:32:23', '2025-02-22 07:32:23'),
(121, '100', 'FCA3R7SXC00272', '0', '2025-02-22 12:49:33', '2025-02-22 14:11:17'),
(122, '101', 'FCB3R7SY200241', '1', '2025-02-22 12:52:31', '2025-02-22 12:52:31'),
(123, '99', '864426078728039', '1', '2025-02-22 12:54:58', '2025-02-26 05:20:30'),
(124, '60', 'AUB0A7SX605918K', '0', '2025-02-22 13:00:39', '2025-02-25 05:02:05'),
(125, '60', 'AUB0A7SX602820A', '0', '2025-02-22 13:01:53', '2025-03-08 08:41:00'),
(126, '60', 'AUB0A7SX602830M', '0', '2025-02-22 13:08:42', '2025-03-09 09:14:28'),
(127, '60', 'AUB0A7SX602668F', '1', '2025-02-22 13:09:27', '2025-02-22 13:09:27'),
(128, '48', '43U6F3V8EX800478', '0', '2025-02-23 14:01:35', '2025-02-24 10:50:34'),
(129, '47', '43A6F3V8EX900786', '0', '2025-02-23 14:02:37', '2025-02-24 11:19:29'),
(130, '52', '0BG1389XC00401', '1', '2025-02-24 07:25:45', '2025-02-24 07:25:45'),
(131, '102', '22451T0009410', '0', '2025-02-24 10:59:10', '2025-02-24 11:02:26'),
(132, '84', '3149601244222140', '1', '2025-02-24 13:45:47', '2025-02-24 13:45:47'),
(133, '103', 'E6895012427004304 D-99 050924', '0', '2025-02-26 08:06:51', '2025-02-26 08:10:49'),
(134, '104', '0J5457ST700082L', '1', '2025-02-26 10:56:08', '2025-03-10 13:03:56'),
(135, '105', '9C00D3814198', '0', '2025-02-27 14:05:20', '2025-02-27 15:10:55'),
(136, '106', 'INF244235970', '0', '2025-02-27 14:14:46', '2025-03-04 09:28:50'),
(137, '107', 'AABQ6CZ00001KR1D1315', '0', '2025-02-28 06:00:12', '2025-02-28 06:03:17'),
(138, '108', '250080124460003', '1', '2025-03-01 05:45:09', '2025-03-01 05:45:09'),
(139, '109', '351211130439084', '0', '2025-03-01 13:56:11', '2025-03-01 13:58:19'),
(140, '110', '0X44389Y200748', '1', '2025-03-01 14:55:32', '2025-03-01 14:55:32'),
(141, '110', '0X44389Y200746', '1', '2025-03-01 14:55:32', '2025-03-01 14:55:32'),
(142, '110', '0X44389Y200744', '0', '2025-03-01 14:55:32', '2025-03-06 09:09:21'),
(143, '110', '0X44389Y200743', '1', '2025-03-01 14:55:32', '2025-03-01 14:55:32'),
(144, '110', '0X44389Y200742', '1', '2025-03-01 14:55:32', '2025-03-01 14:55:32'),
(145, '111', '123456789', '1', '2025-03-03 04:20:02', '2025-03-11 06:01:29'),
(146, '111', '987654321', '1', '2025-03-03 04:20:02', '2025-03-10 23:05:13'),
(147, '96', '7332201245200051', '0', '2025-03-06 10:17:14', '2025-03-06 10:24:29'),
(148, '106', '3163501244235960', '0', '2025-03-06 13:03:22', '2025-03-06 13:06:28'),
(149, '96', '7332201245200044', '1', '2025-03-06 14:57:03', '2025-03-06 14:57:03'),
(150, '73', '7300301244800011', '1', '2025-03-06 15:02:25', '2025-03-06 15:02:25');

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

--
-- Table structure for table `sizes`
--

CREATE TABLE `sizes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_id` varchar(255) DEFAULT NULL,
  `name` 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 `sizes`
--

INSERT INTO `sizes` (`id`, `category_id`, `name`, `created_at`, `updated_at`) VALUES
(1, '16', '8 KG', '2025-02-08 16:49:08', '2025-02-08 16:49:08'),
(3, '16', '10 KG', '2025-02-08 16:49:35', '2025-02-08 16:49:35'),
(4, '16', '12 KG', '2025-02-08 16:49:55', '2025-02-08 16:49:55'),
(5, '14', '236 Litre', '2025-02-08 16:50:53', '2025-02-08 16:52:30'),
(6, '14', '443 Litre', '2025-02-08 16:50:59', '2025-02-08 16:52:26'),
(7, '14', '700 Litre', '2025-02-08 16:51:10', '2025-02-08 16:52:22'),
(8, '13', '32 Inch', '2025-02-08 16:51:34', '2025-02-11 06:24:17'),
(9, '13', '43 Inch', '2025-02-08 16:51:39', '2025-02-11 06:24:10'),
(10, '13', '50 Inch', '2025-02-11 06:23:41', '2025-02-11 06:24:02'),
(11, '13', '55 Inch', '2025-02-11 06:23:55', '2025-02-11 06:23:55'),
(12, '13', '65 Inch', '2025-02-11 06:24:25', '2025-02-11 06:24:25'),
(13, '13', '75 Inch', '2025-02-11 06:24:35', '2025-02-11 06:24:35'),
(14, '13', '85 Inch', '2025-02-11 06:24:42', '2025-02-11 06:24:42'),
(15, '13', '100 Inch', '2025-02-11 06:24:50', '2025-02-11 06:24:50'),
(16, '15', '1 Ton', '2025-02-11 11:53:51', '2025-02-11 11:53:51'),
(17, '15', '1.5 Ton', '2025-02-11 11:54:01', '2025-02-11 11:54:01'),
(18, '15', '2 Ton', '2025-02-11 11:54:10', '2025-02-11 11:54:10'),
(19, '14', '443 Litre', '2025-02-12 13:36:51', '2025-02-12 13:36:51'),
(20, '14', '393 Litre', '2025-02-12 13:37:06', '2025-02-12 13:37:06'),
(21, '14', '403 Litre', '2025-02-12 13:37:27', '2025-02-12 13:37:27'),
(22, '14', '375 Litre', '2025-02-12 13:37:39', '2025-02-12 13:37:39'),
(23, '14', '278 Litre', '2025-02-12 15:05:16', '2025-02-12 15:05:16'),
(24, '17', '20 Litre', '2025-02-12 15:09:22', '2025-02-12 15:09:22'),
(25, '17', '25 Litre', '2025-02-12 15:09:30', '2025-02-12 15:09:30'),
(26, '17', '28 Litre', '2025-02-12 15:09:39', '2025-02-12 15:09:39'),
(27, '17', '30 Litre', '2025-02-12 15:09:53', '2025-02-12 15:09:53'),
(28, '14', '348 Litre', '2025-02-12 15:41:40', '2025-02-12 15:41:40'),
(29, '16', '7 KG', '2025-02-13 11:07:44', '2025-02-13 11:07:44'),
(30, '16', '9 KG', '2025-02-13 11:08:14', '2025-02-13 11:08:14'),
(31, '16', '9.5 KG', '2025-02-13 11:08:22', '2025-02-13 11:08:22'),
(32, '16', '11 KG', '2025-02-13 11:08:28', '2025-02-13 11:08:28'),
(33, '16', '13 KG', '2025-02-13 11:08:37', '2025-02-13 11:08:37'),
(34, '18', '750W', '2025-02-18 13:42:43', '2025-02-18 13:42:43'),
(35, '14', '189 Litre', '2025-02-22 12:19:26', '2025-02-22 12:19:26'),
(36, '14', '240 Litre', '2025-02-22 12:19:33', '2025-02-22 12:19:33'),
(37, '16', '7.5 KG', '2025-02-26 10:44:17', '2025-02-26 10:44:49');

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

--
-- Table structure for table `types`
--

CREATE TABLE `types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_id` varchar(255) DEFAULT NULL,
  `name` 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 `types`
--

INSERT INTO `types` (`id`, `category_id`, `name`, `created_at`, `updated_at`) VALUES
(1, '14', 'Frost', '2025-02-08 14:31:55', '2025-02-08 14:31:55'),
(2, '14', 'No-Frost', '2025-02-08 14:32:05', '2025-02-12 13:35:36'),
(3, '12', 'Smart Watch', '2025-02-08 14:32:37', '2025-02-08 14:32:37'),
(5, '12', 'TWS Headphone', '2025-02-08 17:10:42', '2025-02-08 17:10:42'),
(6, '15', 'Inverter', '2025-02-08 18:42:46', '2025-02-08 18:42:46'),
(7, '15', 'Non-Inverter', '2025-02-08 18:42:59', '2025-02-08 18:42:59'),
(8, '13', '4K', '2025-02-09 04:48:17', '2025-02-09 04:48:17'),
(9, '13', '4K ULED', '2025-02-09 04:48:28', '2025-02-09 04:48:28'),
(10, '13', 'FHD', '2025-02-09 04:48:38', '2025-02-09 04:48:38'),
(11, '13', '4K UHD', '2025-02-09 04:48:50', '2025-02-09 04:48:50'),
(12, '13', 'HD', '2025-02-11 06:25:14', '2025-02-11 06:25:14'),
(13, '17', 'Microwave', '2025-02-12 15:19:17', '2025-02-12 15:19:17'),
(14, '17', 'Convection', '2025-02-12 15:19:26', '2025-02-12 15:19:26'),
(15, '17', 'Electric', '2025-02-12 15:19:36', '2025-02-12 15:19:36'),
(16, '16', 'Front Load', '2025-02-13 11:10:54', '2025-02-13 11:10:54'),
(17, '16', 'Top Load', '2025-02-13 11:11:01', '2025-02-13 11:11:01'),
(18, '18', 'Mixer Grinder', '2025-02-18 13:42:23', '2025-02-18 13:42:23'),
(19, '17', 'Grill', '2025-02-20 06:19:01', '2025-02-20 06:19:01'),
(20, '14', 'Chest Freezer', '2025-02-22 12:18:41', '2025-02-22 12:18:41'),
(21, '12', 'Router', '2025-02-24 10:52:46', '2025-02-24 10:52:46'),
(22, '12', 'TV Card', '2025-02-27 14:01:38', '2025-02-27 14:01:38');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

