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

START TRANSACTION;



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

--
-- Table structure for table `attendance`
--

CREATE TABLE `attendance` (
  `id` bigint(20) NOT NULL,
  `date` date NOT NULL,
  `status` varchar(10) NOT NULL,
  `employee_id` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `auth_group`
--

CREATE TABLE `auth_group` (
  `id` int(11) NOT NULL,
  `name` varchar(150) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `auth_group_permissions`
--

CREATE TABLE `auth_group_permissions` (
  `id` bigint(20) NOT NULL,
  `group_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `auth_permission`
--

CREATE TABLE `auth_permission` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `content_type_id` int(11) NOT NULL,
  `codename` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `auth_permission`
--

INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES
(1, 'Can add log entry', 1, 'add_logentry'),
(2, 'Can change log entry', 1, 'change_logentry'),
(3, 'Can delete log entry', 1, 'delete_logentry'),
(4, 'Can view log entry', 1, 'view_logentry'),
(5, 'Can add permission', 2, 'add_permission'),
(6, 'Can change permission', 2, 'change_permission'),
(7, 'Can delete permission', 2, 'delete_permission'),
(8, 'Can view permission', 2, 'view_permission'),
(9, 'Can add group', 3, 'add_group'),
(10, 'Can change group', 3, 'change_group'),
(11, 'Can delete group', 3, 'delete_group'),
(12, 'Can view group', 3, 'view_group'),
(13, 'Can add user', 4, 'add_user'),
(14, 'Can change user', 4, 'change_user'),
(15, 'Can delete user', 4, 'delete_user'),
(16, 'Can view user', 4, 'view_user'),
(17, 'Can add content type', 5, 'add_contenttype'),
(18, 'Can change content type', 5, 'change_contenttype'),
(19, 'Can delete content type', 5, 'delete_contenttype'),
(20, 'Can view content type', 5, 'view_contenttype'),
(21, 'Can add session', 6, 'add_session'),
(22, 'Can change session', 6, 'change_session'),
(23, 'Can delete session', 6, 'delete_session'),
(24, 'Can view session', 6, 'view_session'),
(25, 'Can add department', 7, 'add_department'),
(26, 'Can change department', 7, 'change_department'),
(27, 'Can delete department', 7, 'delete_department'),
(28, 'Can view department', 7, 'view_department'),
(29, 'Can add designation', 8, 'add_designation'),
(30, 'Can change designation', 8, 'change_designation'),
(31, 'Can delete designation', 8, 'delete_designation'),
(32, 'Can view designation', 8, 'view_designation'),
(33, 'Can add employee', 9, 'add_employee'),
(34, 'Can change employee', 9, 'change_employee'),
(35, 'Can delete employee', 9, 'delete_employee'),
(36, 'Can view employee', 9, 'view_employee'),
(37, 'Can add module', 10, 'add_module'),
(38, 'Can change module', 10, 'change_module'),
(39, 'Can delete module', 10, 'delete_module'),
(40, 'Can view module', 10, 'view_module'),
(41, 'Can add module menu', 11, 'add_modulemenu'),
(42, 'Can change module menu', 11, 'change_modulemenu'),
(43, 'Can delete module menu', 11, 'delete_modulemenu'),
(44, 'Can view module menu', 11, 'view_modulemenu'),
(45, 'Can add user access control', 12, 'add_useraccesscontrol'),
(46, 'Can change user access control', 12, 'change_useraccesscontrol'),
(47, 'Can delete user access control', 12, 'delete_useraccesscontrol'),
(48, 'Can view user access control', 12, 'view_useraccesscontrol'),
(49, 'Can add payroll', 13, 'add_payroll'),
(50, 'Can change payroll', 13, 'change_payroll'),
(51, 'Can delete payroll', 13, 'delete_payroll'),
(52, 'Can view payroll', 13, 'view_payroll'),
(53, 'Can add leave request', 14, 'add_leaverequest'),
(54, 'Can change leave request', 14, 'change_leaverequest'),
(55, 'Can delete leave request', 14, 'delete_leaverequest'),
(56, 'Can view leave request', 14, 'view_leaverequest'),
(57, 'Can add attendance', 15, 'add_attendance'),
(58, 'Can change attendance', 15, 'change_attendance'),
(59, 'Can delete attendance', 15, 'delete_attendance'),
(60, 'Can view attendance', 15, 'view_attendance'),
(61, 'Can add Product Wise Size', 16, 'add_productwisesize'),
(62, 'Can change Product Wise Size', 16, 'change_productwisesize'),
(63, 'Can delete Product Wise Size', 16, 'delete_productwisesize'),
(64, 'Can view Product Wise Size', 16, 'view_productwisesize'),
(65, 'Can add product category', 17, 'add_productcategory'),
(66, 'Can change product category', 17, 'change_productcategory'),
(67, 'Can delete product category', 17, 'delete_productcategory'),
(68, 'Can view product category', 17, 'view_productcategory'),
(69, 'Can add product color', 18, 'add_productcolor'),
(70, 'Can change product color', 18, 'change_productcolor'),
(71, 'Can delete product color', 18, 'delete_productcolor'),
(72, 'Can view product color', 18, 'view_productcolor'),
(73, 'Can add product list', 19, 'add_productlist'),
(74, 'Can change product list', 19, 'change_productlist'),
(75, 'Can delete product list', 19, 'delete_productlist'),
(76, 'Can view product list', 19, 'view_productlist'),
(77, 'Can add Product Wise Color', 20, 'add_productwisecolor'),
(78, 'Can change Product Wise Color', 20, 'change_productwisecolor'),
(79, 'Can delete Product Wise Color', 20, 'delete_productwisecolor'),
(80, 'Can view Product Wise Color', 20, 'view_productwisecolor'),
(81, 'Can add product image', 21, 'add_productimage'),
(82, 'Can change product image', 21, 'change_productimage'),
(83, 'Can delete product image', 21, 'delete_productimage'),
(84, 'Can view product image', 21, 'view_productimage'),
(85, 'Can add product brand', 22, 'add_productbrand'),
(86, 'Can change product brand', 22, 'change_productbrand'),
(87, 'Can delete product brand', 22, 'delete_productbrand'),
(88, 'Can view product brand', 22, 'view_productbrand'),
(89, 'Can add product size', 23, 'add_productsize'),
(90, 'Can change product size', 23, 'change_productsize'),
(91, 'Can delete product size', 23, 'delete_productsize'),
(92, 'Can view product size', 23, 'view_productsize'),
(93, 'Can add brand list', 22, 'add_brandlist'),
(94, 'Can change brand list', 22, 'change_brandlist'),
(95, 'Can delete brand list', 22, 'delete_brandlist'),
(96, 'Can view brand list', 22, 'view_brandlist'),
(97, 'Can add category list', 17, 'add_categorylist'),
(98, 'Can change category list', 17, 'change_categorylist'),
(99, 'Can delete category list', 17, 'delete_categorylist'),
(100, 'Can view category list', 17, 'view_categorylist'),
(101, 'Can add color list', 18, 'add_colorlist'),
(102, 'Can change color list', 18, 'change_colorlist'),
(103, 'Can delete color list', 18, 'delete_colorlist'),
(104, 'Can view color list', 18, 'view_colorlist'),
(105, 'Can add size list', 23, 'add_sizelist'),
(106, 'Can change size list', 23, 'change_sizelist'),
(107, 'Can delete size list', 23, 'delete_sizelist'),
(108, 'Can view size list', 23, 'view_sizelist'),
(109, 'Can add Product Wise Category', 24, 'add_productwisecategory'),
(110, 'Can change Product Wise Category', 24, 'change_productwisecategory'),
(111, 'Can delete Product Wise Category', 24, 'delete_productwisecategory'),
(112, 'Can view Product Wise Category', 24, 'view_productwisecategory'),
(113, 'Can add district list', 25, 'add_districtlist'),
(114, 'Can change district list', 25, 'change_districtlist'),
(115, 'Can delete district list', 25, 'delete_districtlist'),
(116, 'Can view district list', 25, 'view_districtlist'),
(117, 'Can add courier service', 26, 'add_courierservice'),
(118, 'Can change courier service', 26, 'change_courierservice'),
(119, 'Can delete courier service', 26, 'delete_courierservice'),
(120, 'Can view courier service', 26, 'view_courierservice'),
(121, 'Can add customar list', 27, 'add_CustomerList'),
(122, 'Can change customar list', 27, 'change_CustomerList'),
(123, 'Can delete customar list', 27, 'delete_CustomerList'),
(124, 'Can view customar list', 27, 'view_CustomerList'),
(125, 'Can add Sales Order Detail', 28, 'add_salesorderdetails'),
(126, 'Can change Sales Order Detail', 28, 'change_salesorderdetails'),
(127, 'Can delete Sales Order Detail', 28, 'delete_salesorderdetails'),
(128, 'Can view Sales Order Detail', 28, 'view_salesorderdetails'),
(129, 'Can add Sales Order', 29, 'add_salesorder'),
(130, 'Can change Sales Order', 29, 'change_salesorder'),
(131, 'Can delete Sales Order', 29, 'delete_salesorder'),
(132, 'Can view Sales Order', 29, 'view_salesorder'),
(133, 'Can add upozilla list', 30, 'add_upozillalist'),
(134, 'Can change upozilla list', 30, 'change_upozillalist'),
(135, 'Can delete upozilla list', 30, 'delete_upozillalist'),
(136, 'Can view upozilla list', 30, 'view_upozillalist'),
(137, 'Can add Business Profile', 31, 'add_businessprofile'),
(138, 'Can change Business Profile', 31, 'change_businessprofile'),
(139, 'Can delete Business Profile', 31, 'delete_businessprofile'),
(140, 'Can view Business Profile', 31, 'view_businessprofile'),
(141, 'Can add add to cart', 32, 'add_addtocart'),
(142, 'Can change add to cart', 32, 'change_addtocart'),
(143, 'Can delete add to cart', 32, 'delete_addtocart'),
(144, 'Can view add to cart', 32, 'view_addtocart'),
(145, 'Can add Slider', 33, 'add_sliderlist'),
(146, 'Can change Slider', 33, 'change_sliderlist'),
(147, 'Can delete Slider', 33, 'delete_sliderlist'),
(148, 'Can view Slider', 33, 'view_sliderlist');

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

--
-- Table structure for table `auth_user_groups`
--

CREATE TABLE `auth_user_groups` (
  `id` bigint(20) NOT NULL,
  `user_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `auth_user_user_permissions`
--

CREATE TABLE `auth_user_user_permissions` (
  `id` bigint(20) NOT NULL,
  `user_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `brand_list`
--

CREATE TABLE `brand_list` (
  `id` bigint(20) NOT NULL,
  `brand_name` varchar(60) DEFAULT NULL,
  `details` longtext DEFAULT NULL,
  `ordering` int(11) NOT NULL,
  `created` datetime(6) NOT NULL,
  `status` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `brand_list`
--

INSERT INTO `brand_list` (`id`, `brand_name`, `details`, `ordering`, `created`, `status`) VALUES
(1, 'Samsung', 'Leading electronics brand', 1, '2025-08-26 23:13:43.000000', 1),
(2, 'IKEA', 'Famous furniture and home brand', 2, '2025-08-26 23:13:43.000000', 1),
(3, 'Nike', 'Sportswear and apparel brand', 3, '2025-08-26 23:13:43.000000', 1),
(4, 'Sony', 'Electronics and entertainment products', 4, '2025-08-26 23:13:43.000000', 1),
(5, 'Philips', 'Home and kitchen appliances', 5, '2025-08-26 23:13:43.000000', 1);

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

--
-- Table structure for table `business_profile`
--

CREATE TABLE `business_profile` (
  `id` bigint(20) NOT NULL,
  `business_name` varchar(250) NOT NULL,
  `tagline` varchar(250) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `email` varchar(150) DEFAULT NULL,
  `mobile` varchar(20) DEFAULT NULL,
  `mobile_optional` varchar(20) DEFAULT NULL,
  `address` longtext DEFAULT NULL,
  `map_embed_code` longtext DEFAULT NULL,
  `logo` varchar(100) DEFAULT NULL,
  `favicon` varchar(100) DEFAULT NULL,
  `facebook` varchar(250) DEFAULT NULL,
  `instagram` varchar(250) DEFAULT NULL,
  `twitter` varchar(250) DEFAULT NULL,
  `linkedin` varchar(250) DEFAULT NULL,
  `youtube` varchar(250) DEFAULT NULL,
  `seo_meta_title` varchar(70) DEFAULT NULL,
  `seo_meta_description` varchar(160) DEFAULT NULL,
  `seo_keywords` varchar(250) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `updated` datetime(6) NOT NULL,
  `shipping_cost_inside` int(11) NOT NULL,
  `shipping_cost_outside` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `business_profile`
--

INSERT INTO `business_profile` (`id`, `business_name`, `tagline`, `description`, `email`, `mobile`, `mobile_optional`, `address`, `map_embed_code`, `logo`, `favicon`, `facebook`, `instagram`, `twitter`, `linkedin`, `youtube`, `seo_meta_title`, `seo_meta_description`, `seo_keywords`, `is_active`, `created`, `updated`, `shipping_cost_inside`, `shipping_cost_outside`) VALUES
(1, 'Akmam Shop', 'A Faster Ecommerce Shop', 'ad fadf', 'akkas.cse49@gmail.com', '01902353773', '01629920564', '456 Abdullah Bhabon, South Goran, Khilgaon, Dhaka.', '', 'business/logo/akmamshop_new_logo.jpg', 'business/favicon/akmamshop_favicon.png', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2025-09-14 09:23:53.075122', '2025-09-20 09:26:04.752671', 100, 140);

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

--
-- Table structure for table `category_list`
--

CREATE TABLE `category_list` (
  `id` bigint(20) NOT NULL,
  `name` varchar(100) NOT NULL,
  `description` longtext NOT NULL,
  `ordering` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `updated` datetime(6) NOT NULL,
  `image` varchar(100) DEFAULT NULL,
  `is_homepage` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `category_list`
--

INSERT INTO `category_list` (`id`, `name`, `description`, `ordering`, `status`, `created`, `updated`, `image`, `is_homepage`) VALUES
(1, 'বোরকা ফ্যাশন', 'All kinds of electronic products', 4, 1, '2025-08-26 23:13:14.000000', '2025-08-26 23:13:14.000000', 'category_images/burka.png', 1),
(2, 'বাচ্চাদের খেলনা', 'Computer Accessories', 3, 1, '2025-08-26 23:13:14.000000', '2025-08-26 23:13:14.000000', 'category_images/toys.png', 1),
(3, 'মোবাইল পণ্য', 'Accessories and office supplies', 12, 1, '2025-08-26 23:13:14.000000', '2025-08-26 23:13:14.000000', 'category_images/4.jpg', 0),
(4, 'মেয়েদের পোশাক', 'Men, women and kids clothing', 2, 1, '2025-08-26 23:13:14.000000', '2025-08-26 23:13:14.000000', 'category_images/ladis.png', 1),
(5, 'ছেলেদের পোশাক', 'Kitchen and home appliances', 1, 1, '2025-08-26 23:13:14.000000', '2025-08-26 23:13:14.000000', 'category_images/gents.png', 1),
(6, 'হিজাব ও নিকাব', '', 5, 1, '2025-09-14 15:36:03.042885', '2025-09-14 15:36:00.000000', 'category_images/women-hijab-icon-beautiful-muslim-girl-avatar-free-vector.jpg', 0),
(7, 'ছেলেদের ব্যাগ', '', 6, 1, '2025-09-14 15:38:36.362051', '2025-09-14 15:38:32.000000', 'category_images/bag.png', 1),
(8, 'অন্যান্য পণ্য', '', 7, 1, '2025-09-14 15:39:54.196084', '2025-09-14 15:39:51.000000', 'category_images/accessories.png', 0),
(9, 'টুপি ও তাজবি', '', 8, 1, '2025-09-14 15:42:50.534869', '2025-09-14 15:42:47.000000', 'category_images/b07ebb060addb1177a00e5fd2da3befe.jpg_960x960q80.jpg_.webp', 0);

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

--
-- Table structure for table `color_list`
--

CREATE TABLE `color_list` (
  `id` bigint(20) NOT NULL,
  `color_name` varchar(60) DEFAULT NULL,
  `details` longtext DEFAULT NULL,
  `ordering` int(11) NOT NULL,
  `created` datetime(6) NOT NULL,
  `status` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `color_list`
--

INSERT INTO `color_list` (`id`, `color_name`, `details`, `ordering`, `created`, `status`) VALUES
(1, 'Red', 'Bright red color', 1, '2025-08-26 23:14:18.000000', 1),
(2, 'Blue', 'Sky blue shade', 2, '2025-08-26 23:14:18.000000', 1),
(3, 'Green', 'Natural green color', 3, '2025-08-26 23:14:18.000000', 1),
(4, 'Black', 'Classic black color', 4, '2025-08-26 23:14:18.000000', 1),
(5, 'White', 'Pure white shade', 5, '2025-08-26 23:14:18.000000', 1);

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

--
-- Table structure for table `courier_service_list`
--

CREATE TABLE `courier_service_list` (
  `id` bigint(20) NOT NULL,
  `courier_name` varchar(60) DEFAULT NULL,
  `courier_address` longtext DEFAULT NULL,
  `ordering` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `department_list`
--

CREATE TABLE `department_list` (
  `id` bigint(20) NOT NULL,
  `name` varchar(100) NOT NULL,
  `rank` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `department_list`
--

INSERT INTO `department_list` (`id`, `name`, `rank`, `status`, `created`) VALUES
(1, 'Admin', 1, 1, '0000-00-00 00:00:00.000000');

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

--
-- Table structure for table `designation_list`
--

CREATE TABLE `designation_list` (
  `id` bigint(20) NOT NULL,
  `name` varchar(100) NOT NULL,
  `rank` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `designation_list`
--

INSERT INTO `designation_list` (`id`, `name`, `rank`, `status`, `created`) VALUES
(1, 'Admin', 1, 1, '0000-00-00 00:00:00.000000');

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

--
-- Table structure for table `district_list`
--

CREATE TABLE `district_list` (
  `id` bigint(20) NOT NULL,
  `name` varchar(230) NOT NULL,
  `rank` int(11) NOT NULL,
  `shipping_cost` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `django_admin_log`
--

CREATE TABLE `django_admin_log` (
  `id` int(11) NOT NULL,
  `action_time` datetime(6) NOT NULL,
  `object_id` longtext DEFAULT NULL,
  `object_repr` varchar(200) NOT NULL,
  `action_flag` smallint(5) UNSIGNED NOT NULL CHECK (`action_flag` >= 0),
  `change_message` longtext NOT NULL,
  `content_type_id` int(11) DEFAULT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `django_admin_log`
--

INSERT INTO `django_admin_log` (`id`, `action_time`, `object_id`, `object_repr`, `action_flag`, `change_message`, `content_type_id`, `user_id`) VALUES
(1, '2025-09-14 09:08:19.017092', '5', 'Appliances', 2, '[{\"changed\": {\"fields\": [\"Image\"]}}]', 17, 1),
(2, '2025-09-14 09:08:50.310550', '5', 'Appliances', 2, '[{\"changed\": {\"fields\": [\"Is homepage\"]}}]', 17, 1),
(3, '2025-09-14 09:09:51.877680', '4', 'Clothing', 2, '[{\"changed\": {\"fields\": [\"Image\", \"Is homepage\"]}}]', 17, 1),
(4, '2025-09-14 09:10:35.565238', '3', 'Mobile Accessories', 2, '[{\"changed\": {\"fields\": [\"Name\", \"Description\", \"Image\", \"Is homepage\"]}}]', 17, 1),
(5, '2025-09-14 09:23:53.077122', '1', 'Akmam Shop', 1, '[{\"added\": {}}]', 31, 1),
(6, '2025-09-14 09:47:29.084421', '2', 'Computer Accessories', 2, '[{\"changed\": {\"fields\": [\"Name\", \"Description\", \"Image\", \"Is homepage\"]}}]', 17, 1),
(7, '2025-09-14 09:47:40.052036', '1', 'Electronics', 2, '[{\"changed\": {\"fields\": [\"Image\"]}}]', 17, 1),
(8, '2025-09-14 15:27:16.173081', '5', 'ছেলেদের পোশাক', 2, '[{\"changed\": {\"fields\": [\"Name\", \"Ordering\", \"Image\"]}}]', 17, 1),
(9, '2025-09-14 15:27:47.519694', '4', 'মেয়েদের পোশাক', 2, '[{\"changed\": {\"fields\": [\"Name\", \"Ordering\", \"Image\"]}}]', 17, 1),
(10, '2025-09-14 15:29:46.667035', '3', 'মোবাইল পণ্য', 2, '[{\"changed\": {\"fields\": [\"Name\", \"Ordering\"]}}]', 17, 1),
(11, '2025-09-14 15:31:40.566515', '2', 'বাচ্চাদের খেলনা', 2, '[{\"changed\": {\"fields\": [\"Name\", \"Ordering\", \"Image\"]}}]', 17, 1),
(12, '2025-09-14 15:33:49.905634', '1', 'বোরকা ফ্যাশন', 2, '[{\"changed\": {\"fields\": [\"Name\", \"Ordering\", \"Image\"]}}]', 17, 1),
(13, '2025-09-14 15:34:11.203904', '1', 'বোরকা ফ্যাশন', 2, '[{\"changed\": {\"fields\": [\"Ordering\", \"Is homepage\"]}}]', 17, 1),
(14, '2025-09-14 15:36:03.042885', '6', 'হিজাব ও নিকাব', 1, '[{\"added\": {}}]', 17, 1),
(15, '2025-09-14 15:36:33.590796', '6', 'হিজাব ও নিকাব', 2, '[{\"changed\": {\"fields\": [\"Image\"]}}]', 17, 1),
(16, '2025-09-14 15:38:36.362051', '7', 'ছেলেদের ব্যাগ', 1, '[{\"added\": {}}]', 17, 1),
(17, '2025-09-14 15:39:54.197050', '8', 'অন্যান্য পণ্য', 1, '[{\"added\": {}}]', 17, 1),
(18, '2025-09-14 15:42:50.537045', '9', 'টুপি ও তাজবি', 1, '[{\"added\": {}}]', 17, 1),
(19, '2025-09-14 16:31:20.475359', '3', 'Aspen Silva', 2, '[{\"changed\": {\"fields\": [\"Stock status\", \"Updated\", \"Product image\"]}}]', 19, 1),
(20, '2025-09-14 16:37:35.237896', '3', 'Aspen Silva', 2, '[{\"changed\": {\"fields\": [\"Unit price\", \"Discount\", \"Discount price\", \"Discount status\", \"Quantity\"]}}]', 19, 1),
(21, '2025-09-14 16:38:25.307982', '2', 'Preston Michael', 2, '[{\"changed\": {\"fields\": [\"Discount price\", \"Discount status\", \"Updated\", \"Seo focus keyword\"]}}]', 19, 1),
(22, '2025-09-14 16:39:19.874435', '1', 'Thomas Norman', 2, '[{\"changed\": {\"fields\": [\"Discount\", \"Discount price\", \"Discount status\", \"Quantity\", \"Updated\", \"Product image\", \"Seo meta title\", \"Seo focus keyword\"]}}]', 19, 1),
(23, '2025-09-15 14:41:25.347217', '5', 'Product 1', 2, '[{\"changed\": {\"fields\": [\"Product image\"]}}]', 19, 1),
(24, '2025-09-15 14:41:41.111086', '24', 'Product 20', 2, '[{\"changed\": {\"fields\": [\"Product image\"]}}]', 19, 1),
(25, '2025-09-15 14:41:55.181982', '23', 'Product 19', 2, '[{\"changed\": {\"fields\": [\"Product image\"]}}]', 19, 1),
(26, '2025-09-15 14:42:09.391122', '22', 'Product 18', 2, '[{\"changed\": {\"fields\": [\"Product image\"]}}]', 19, 1),
(27, '2025-09-15 14:44:21.080574', '21', 'Product 17', 2, '[{\"changed\": {\"fields\": [\"Product image\"]}}]', 19, 1),
(28, '2025-09-15 14:44:36.312700', '20', 'Product 16', 2, '[{\"changed\": {\"fields\": [\"Product image\"]}}]', 19, 1),
(29, '2025-09-15 14:44:48.588829', '19', 'Product 15', 2, '[{\"changed\": {\"fields\": [\"Product image\"]}}]', 19, 1),
(30, '2025-09-15 14:45:01.826366', '18', 'Product 14', 2, '[{\"changed\": {\"fields\": [\"Product image\"]}}]', 19, 1),
(31, '2025-09-15 14:45:25.143658', '17', 'Product 13', 2, '[{\"changed\": {\"fields\": [\"Product image\"]}}]', 19, 1),
(32, '2025-09-15 14:46:30.018334', '16', 'Product 12', 2, '[{\"changed\": {\"fields\": [\"Product image\"]}}]', 19, 1),
(33, '2025-09-15 14:46:43.818631', '15', 'Product 11', 2, '[{\"changed\": {\"fields\": [\"Product image\"]}}]', 19, 1),
(34, '2025-09-15 14:46:56.772431', '14', 'Product 10', 2, '[{\"changed\": {\"fields\": [\"Product image\"]}}]', 19, 1),
(35, '2025-09-15 14:47:10.448868', '13', 'Product 9', 2, '[{\"changed\": {\"fields\": [\"Product image\"]}}]', 19, 1),
(36, '2025-09-15 14:47:25.604200', '12', 'Product 8', 2, '[{\"changed\": {\"fields\": [\"Product image\"]}}]', 19, 1),
(37, '2025-09-15 14:47:43.039051', '11', 'Product 7', 2, '[{\"changed\": {\"fields\": [\"Product image\"]}}]', 19, 1),
(38, '2025-09-15 14:48:02.810501', '10', 'Product 6', 2, '[{\"changed\": {\"fields\": [\"Product image\"]}}]', 19, 1),
(39, '2025-09-15 14:48:14.226515', '9', 'Product 5', 2, '[{\"changed\": {\"fields\": [\"Product image\"]}}]', 19, 1),
(40, '2025-09-15 14:48:33.210836', '6', 'Product 2', 2, '[{\"changed\": {\"fields\": [\"Product image\"]}}]', 19, 1),
(41, '2025-09-15 14:48:49.720044', '8', 'Product 4', 2, '[{\"changed\": {\"fields\": [\"Product image\"]}}]', 19, 1),
(42, '2025-09-15 14:49:09.773571', '7', 'Product 3', 2, '[{\"changed\": {\"fields\": [\"Product image\"]}}]', 19, 1),
(43, '2025-09-16 14:56:05.445423', '1', 'Slider 1', 1, '[{\"added\": {}}]', 33, 1),
(44, '2025-09-16 14:56:22.297461', '2', 'Slider 2', 1, '[{\"added\": {}}]', 33, 1),
(45, '2025-09-16 14:56:37.595292', '3', 'Slider 3', 1, '[{\"added\": {}}]', 33, 1),
(46, '2025-09-16 16:55:28.799884', '3', 'Slider 3', 2, '[{\"changed\": {\"fields\": [\"Status\"]}}]', 33, 1),
(47, '2025-09-18 17:30:26.541889', '9', 'টুপি ও তাজবি', 2, '[{\"changed\": {\"fields\": [\"Is homepage\"]}}]', 17, 1),
(48, '2025-09-18 17:30:34.845241', '8', 'অন্যান্য পণ্য', 2, '[{\"changed\": {\"fields\": [\"Is homepage\"]}}]', 17, 1),
(49, '2025-09-18 17:30:44.530887', '6', 'হিজাব ও নিকাব', 2, '[{\"changed\": {\"fields\": [\"Is homepage\"]}}]', 17, 1),
(50, '2025-09-18 17:30:54.648051', '3', 'মোবাইল পণ্য', 2, '[{\"changed\": {\"fields\": [\"Is homepage\"]}}]', 17, 1),
(51, '2025-09-18 17:33:31.751740', '32', 'Kelsey Cole', 2, '[{\"changed\": {\"fields\": [\"Brand\", \"Updated\", \"Product image\"]}}]', 19, 1),
(52, '2025-09-18 17:33:53.405814', '31', 'Kelsey Cole', 2, '[{\"changed\": {\"fields\": [\"Brand\", \"Updated\", \"Product image\"]}}]', 19, 1),
(53, '2025-09-18 17:34:13.774791', '30', 'Kelsey Cole', 3, '', 19, 1),
(54, '2025-09-18 17:34:13.785191', '29', 'Kelsey Cole', 3, '', 19, 1),
(55, '2025-09-18 17:34:13.791317', '28', 'Kelsey Cole', 3, '', 19, 1),
(56, '2025-09-18 17:34:58.702286', '28', 'Kelsey Cole', 2, '[{\"changed\": {\"fields\": [\"Brand\", \"Updated\", \"Product image\"]}}]', 19, 1),
(57, '2025-09-18 17:35:18.618516', '29', 'Kelsey Cole', 2, '[{\"changed\": {\"fields\": [\"Brand\", \"Updated\", \"Product image\"]}}]', 19, 1),
(58, '2025-09-18 17:35:34.139546', '30', 'Kelsey Cole', 2, '[{\"changed\": {\"fields\": [\"Brand\", \"Updated\", \"Product image\"]}}]', 19, 1),
(59, '2025-09-20 09:21:17.981097', '1', 'Akmam Shop', 2, '[{\"changed\": {\"fields\": [\"Shipping cost inside\", \"Shipping cost outside\"]}}]', 31, 1),
(60, '2025-09-20 09:24:14.885176', '1', 'Akmam Shop', 2, '[{\"changed\": {\"fields\": [\"Favicon\"]}}]', 31, 1),
(61, '2025-09-20 09:26:04.754671', '1', 'Akmam Shop', 2, '[{\"changed\": {\"fields\": [\"Shipping cost inside\", \"Shipping cost outside\"]}}]', 31, 1);

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

--
-- Table structure for table `django_content_type`
--

CREATE TABLE `django_content_type` (
  `id` int(11) NOT NULL,
  `app_label` varchar(100) NOT NULL,
  `model` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `django_content_type`
--

INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES
(1, 'admin', 'logentry'),
(3, 'auth', 'group'),
(2, 'auth', 'permission'),
(4, 'auth', 'user'),
(5, 'contenttypes', 'contenttype'),
(32, 'hr', 'addtocart'),
(15, 'hr', 'attendance'),
(31, 'hr', 'businessprofile'),
(7, 'hr', 'department'),
(8, 'hr', 'designation'),
(9, 'hr', 'employee'),
(14, 'hr', 'leaverequest'),
(10, 'hr', 'module'),
(11, 'hr', 'modulemenu'),
(13, 'hr', 'payroll'),
(33, 'hr', 'sliderlist'),
(12, 'hr', 'useraccesscontrol'),
(22, 'inventory_app', 'brandlist'),
(17, 'inventory_app', 'categorylist'),
(18, 'inventory_app', 'colorlist'),
(26, 'inventory_app', 'courierservice'),
(27, 'inventory_app', 'CustomerList'),
(25, 'inventory_app', 'districtlist'),
(21, 'inventory_app', 'productimage'),
(19, 'inventory_app', 'productlist'),
(24, 'inventory_app', 'productwisecategory'),
(20, 'inventory_app', 'productwisecolor'),
(16, 'inventory_app', 'productwisesize'),
(29, 'inventory_app', 'salesorder'),
(28, 'inventory_app', 'salesorderdetails'),
(23, 'inventory_app', 'sizelist'),
(30, 'inventory_app', 'upozillalist'),
(6, 'sessions', 'session');

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

--
-- Table structure for table `django_migrations`
--

CREATE TABLE `django_migrations` (
  `id` bigint(20) NOT NULL,
  `app` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `applied` datetime(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `django_migrations`
--

INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES
(1, 'contenttypes', '0001_initial', '2025-08-05 08:16:53.836029'),
(2, 'auth', '0001_initial', '2025-08-05 08:16:54.367303'),
(3, 'admin', '0001_initial', '2025-08-05 08:16:54.476520'),
(4, 'admin', '0002_logentry_remove_auto_add', '2025-08-05 08:16:54.492143'),
(5, 'admin', '0003_logentry_add_action_flag_choices', '2025-08-05 08:16:54.492143'),
(6, 'contenttypes', '0002_remove_content_type_name', '2025-08-05 08:16:54.554661'),
(7, 'auth', '0002_alter_permission_name_max_length', '2025-08-05 08:16:54.617115'),
(8, 'auth', '0003_alter_user_email_max_length', '2025-08-05 08:16:54.663979'),
(9, 'auth', '0004_alter_user_username_opts', '2025-08-05 08:16:54.663979'),
(10, 'auth', '0005_alter_user_last_login_null', '2025-08-05 08:16:54.710845'),
(11, 'auth', '0006_require_contenttypes_0002', '2025-08-05 08:16:54.710845'),
(12, 'auth', '0007_alter_validators_add_error_messages', '2025-08-05 08:16:54.726534'),
(13, 'auth', '0008_alter_user_username_max_length', '2025-08-05 08:16:54.742123'),
(14, 'auth', '0009_alter_user_last_name_max_length', '2025-08-05 08:16:54.757743'),
(15, 'auth', '0010_alter_group_name_max_length', '2025-08-05 08:16:54.820197'),
(16, 'auth', '0011_update_proxy_permissions', '2025-08-05 08:16:54.820197'),
(17, 'auth', '0012_alter_user_first_name_max_length', '2025-08-05 08:16:54.835820'),
(18, 'hr', '0001_initial', '2025-08-05 08:16:55.507554'),
(19, 'sessions', '0001_initial', '2025-08-05 08:16:55.538796'),
(20, 'inventory_app', '0001_initial', '2025-08-14 18:08:29.857108'),
(21, 'inventory_app', '0002_rename_productbrand_brandlist_and_more', '2025-08-26 17:12:52.055171'),
(22, 'inventory_app', '0003_remove_productlist_product_brand_and_more', '2025-08-26 17:40:32.469265'),
(23, 'inventory_app', '0004_rename_origin_productlist_seo_focus_keyword_and_more', '2025-08-28 10:05:09.483782'),
(24, 'inventory_app', '0005_productwisecolor_color_image_and_more', '2025-09-02 11:03:49.292288'),
(25, 'inventory_app', '0006_productwisecategory', '2025-09-02 11:05:56.549502'),
(26, 'inventory_app', '0007_productlist_brand', '2025-09-02 11:13:57.666354'),
(27, 'inventory_app', '0008_alter_productwisecategory_category', '2025-09-02 11:18:03.989483'),
(28, 'inventory_app', '0009_alter_productlist_discount_and_more', '2025-09-02 17:40:12.291140'),
(29, 'inventory_app', '0010_courierservice_CustomerList_districtlist_salesorder_and_more', '2025-09-11 16:40:40.939529'),
(30, 'inventory_app', '0011_categorylist_image_categorylist_is_homepage', '2025-09-14 09:05:00.298113'),
(31, 'hr', '0002_businessprofile', '2025-09-14 09:18:40.898259'),
(32, 'inventory_app', '0012_alter_productlist_stock_status', '2025-09-15 09:24:17.788699'),
(33, 'hr', '0003_addtocart', '2025-09-15 09:24:17.929776'),
(34, 'hr', '0004_alter_addtocart_options_alter_addtocart_table', '2025-09-15 09:26:55.745528'),
(35, 'hr', '0005_sliderlist', '2025-09-16 14:55:11.616261'),
(36, 'inventory_app', '0013_remove_productwisecolor_color_image_and_more', '2025-09-17 17:29:00.530850'),
(37, 'inventory_app', '0014_remove_productwisecolor_discount_price_and_more', '2025-09-17 18:17:46.696022'),
(38, 'inventory_app', '0015_productwisesize_discount', '2025-09-17 18:24:02.336301'),
(39, 'inventory_app', '0016_productlist_is_variant', '2025-09-17 18:30:22.788130'),
(40, 'hr', '0006_businessprofile_shipping_cost_inside_and_more', '2025-09-20 09:18:32.601816'),
(41, 'hr', '0007_addtocart_color_addtocart_size', '2025-09-21 15:57:11.906148'),
(42, 'inventory_app', '0017_salesorderdetails_color_salesorderdetails_size', '2025-09-28 17:30:24.726378');

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

--
-- Table structure for table `leave_request`
--

CREATE TABLE `leave_request` (
  `id` bigint(20) NOT NULL,
  `from_date` date NOT NULL,
  `to_date` date NOT NULL,
  `reason` longtext NOT NULL,
  `status` varchar(20) NOT NULL,
  `employee_id` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `module_list`
--

CREATE TABLE `module_list` (
  `id` bigint(20) NOT NULL,
  `name` varchar(100) NOT NULL,
  `rank` int(11) NOT NULL,
  `icon` varchar(100) DEFAULT NULL,
  `color` varchar(100) DEFAULT NULL,
  `status` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `module_list`
--

INSERT INTO `module_list` (`id`, `name`, `rank`, `icon`, `color`, `status`, `created`) VALUES
(1, 'HR & Payroll', 1, 'fas fa-users-cog', '#fd7e14', 1, '2025-08-05 14:18:32.000000'),
(2, 'Purchase', 2, 'fas fa-shopping-cart', '#28a745', 1, '2025-08-05 14:18:32.000000'),
(3, 'Sales', 3, 'fas fa-cash-register', '#17a2b8', 1, '2025-08-05 14:18:32.000000'),
(4, 'Delivery', 4, 'fas fa-truck', '#ffc107', 1, '2025-08-05 14:18:32.000000'),
(5, 'Accounting', 5, 'fas fa-file-invoice-dollar', '#6f42c1', 1, '2025-08-05 14:18:32.000000'),
(6, 'Product & Inventory', 6, 'fas fa-box', '#007bff', 1, '2025-08-05 14:18:32.000000'),
(7, 'Support', 7, 'fas fa-headset', '#20c997', 1, '2025-08-05 14:18:32.000000'),
(8, 'CMS', 8, 'fas fa-cogs', '#6610f2', 1, '2025-08-05 14:18:32.000000'),
(9, 'Settings', 9, 'fas fa-tools', '#343a40', 1, '2025-08-05 14:18:32.000000'),
(13, 'Customers', 10, 'fas fa-users', '#343a40', 1, '2025-08-05 14:18:32.000000');

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

--
-- Table structure for table `module_menu_list`
--

CREATE TABLE `module_menu_list` (
  `id` bigint(20) NOT NULL,
  `name` varchar(100) NOT NULL,
  `menu_url` varchar(100) DEFAULT NULL,
  `icon` varchar(100) DEFAULT NULL,
  `color` varchar(100) DEFAULT NULL,
  `module_id` bigint(20) DEFAULT NULL,
  `rank` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `module_menu_list`
--

INSERT INTO `module_menu_list` (`id`, `name`, `menu_url`, `icon`, `color`, `module_id`, `rank`, `status`, `created`) VALUES
(1, 'Employee List', '/hr/employees/', 'fas fa-users', NULL, 1, 1, 1, '2025-08-05 17:57:37.000000'),
(2, 'Employee Add', '/hr/employees/create/', 'fas fa-users', NULL, 1, 2, 1, '2025-08-05 17:57:37.000000'),
(3, 'Department List', '/hr/department-list/', 'fas fa-users', NULL, 1, 3, 1, '2025-08-05 17:57:37.000000'),
(4, 'Product List', '/inventory/product-list/', 'fas fa-boxes', NULL, 6, 2, 1, '2025-08-05 17:57:37.000000'),
(5, 'Menu Add', '/hr/module-menu/add/', 'fas fa-cogs', NULL, 9, 1, 1, '2025-08-05 12:13:29.658532'),
(6, 'Menu List', '/hr/module-menus/', 'fa fa-home', '', 9, 2, 1, '2025-08-05 12:39:40.976885'),
(8, 'User Access Control', '/hr/access-control/bulk/', 'fa fa-home', '', 9, 3, 1, '2025-08-05 13:12:01.285715'),
(9, 'Sales History', '/sales/history/', 'fas fa-briefcase', '', 5, 1, 1, '2025-08-05 13:46:08.801762'),
(10, 'Monthly Income', '/sales/monthly-income/', 'fa fa-home', '', 5, 2, 1, '2025-08-05 13:47:28.290699'),
(11, 'Dhaka', '', '', '', 2, 1, 1, '2025-08-06 02:47:03.129642'),
(12, 'Maris Beach', '', '', '', 1, 1, 1, '2025-08-06 02:47:49.674073'),
(13, 'Product Entry', '/inventory/product-add/', 'fa fa-home', '', 6, 1, 1, '2025-08-14 17:57:03.546496'),
(15, 'Sales Order Create', '/inventory/sales-order/', '', '', 3, 1, 1, '2025-09-02 17:53:34.556897'),
(16, 'Sales Order List', '/inventory/sales-order-list/', '', '', 3, 2, 1, '2025-09-02 17:53:34.556897'),
(17, 'Customer List', '/inventory/customer-list/', '', '', 13, 1, 1, '2025-09-02 17:53:34.556897');

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

--
-- Table structure for table `payroll`
--

CREATE TABLE `payroll` (
  `id` bigint(20) NOT NULL,
  `month` varchar(20) NOT NULL,
  `salary` decimal(10,2) NOT NULL,
  `paid_on` date NOT NULL,
  `employee_id` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `product_image`
--

CREATE TABLE `product_image` (
  `id` bigint(20) NOT NULL,
  `image` varchar(100) NOT NULL,
  `product_id` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `product_image`
--

INSERT INTO `product_image` (`id`, `image`, `product_id`) VALUES
(1, 'product_images/f9caf0d88c5cf83678cea75264551221.jpg_170x170q80.jpg_.webp', 1),
(2, 'product_images/88c3092c37a9f2d2bb1114d04b50cc2c.jpg_170x170q80.jpg_.webp', 1),
(3, 'product_images/Se4e5862ba38341a79a4735d4496fcbbeA.jpg_170x170q80.jpg_.webp', 1),
(4, 'product_images/f9caf0d88c5cf83678cea75264551221.jpg_170x170q80.jpg__hgyrXXU.webp', 2),
(5, 'product_images/88c3092c37a9f2d2bb1114d04b50cc2c.jpg_170x170q80.jpg__oG9QD53.webp', 2),
(6, 'product_images/Se4e5862ba38341a79a4735d4496fcbbeA.jpg_170x170q80.jpg__WXth3XQ.webp', 3),
(7, 'product_images/f9caf0d88c5cf83678cea75264551221.jpg_170x170q80.jpg__0RK9gsF.webp', 3),
(8, 'product_images/88c3092c37a9f2d2bb1114d04b50cc2c.jpg_170x170q80.jpg__yxq4Odd.webp', 3),
(9, 'product_images/Se4e5862ba38341a79a4735d4496fcbbeA.jpg_170x170q80.jpg__rs7Xt5M.webp', 3),
(10, 'product_images/Sefef7094a1634e01811ae2d0ef1d3ba6s.webp', 4),
(11, 'product_images/WhatsApp202024-05-052012.webp', 4),
(12, 'product_images/71-h5jI3FQL._UY1000_.jpg', 4),
(13, 'product_images/dress-plaid-baby-girls-dresses-with-hat-1_800x.jpg', 4),
(14, 'product_images/81eca3c788ef44b1cdc02e3ffa73f3c8.jpg', 25),
(15, 'product_images/323_16736737340846_thumb_1_4x.jpg', 25),
(16, 'product_images/afgani-cap-500x500.webp', 25),
(17, 'product_images/b07ebb060addb1177a00e5fd2da3befe.jpg_960x960q80.jpg_.webp', 25),
(18, 'product_images/Black-1.png', 25),
(19, 'product_images/download.jpg', 25),
(20, 'product_images/1.jpg', 26),
(21, 'product_images/1_7c1a3982-fd5c-4a95-95a6-e7156b0da5c1.webp', 26),
(22, 'product_images/2.webp', 26),
(23, 'product_images/3.webp', 26),
(24, 'product_images/4.webp', 26),
(25, 'product_images/6.webp', 26),
(26, 'product_images/81eca3c788ef44b1cdc02e3ffa73f3c8_FzZ90ra.jpg', 26),
(27, 'product_images/b07ebb060addb1177a00e5fd2da3befe.jpg_960x960q80.jpg__JciWT9P.webp', 26),
(28, 'product_images/Copy_of_Blue_Yellow_Simple_New_Arrival_Streetwear_Instagram_Post_4.webp', 26),
(29, 'product_images/religious-janamaz-500x500.webp', 26),
(30, 'product_images/z1246450743_2.webp', 27),
(31, 'product_images/281e812b-f0ac-467a-adc1-025af241a1c3.4f2d253cc3e6182cd50cdf4457c09d8f.webp', 27),
(32, 'product_images/75f27fad-d49e-4781-baaa-1a03773a0734.0d1e8e84ffe438a64ef8acb75bdf3ea3.webp', 27),
(33, 'product_images/WhatsApp202024-05-052012_blOEQK8.webp', 33),
(34, 'product_images/71-h5jI3FQL._UY1000__RAqUl6H.jpg', 33),
(35, 'product_images/dress-plaid-baby-girls-dresses-with-hat-1_800x_OLTCtQR.jpg', 33),
(36, 'product_images/mebi-baby-girls-blue-check-dress-210719-d08062aa00af457b8f195c8e69a9f4dd91bb5cc7.jpg', 33),
(37, 'product_images/WhatsApp202024-05-052012_tlZoSMS.webp', 34),
(38, 'product_images/71-h5jI3FQL._UY1000__oH7TtJv.jpg', 34),
(39, 'product_images/dress-plaid-baby-girls-dresses-with-hat-1_800x_AhLNH6H.jpg', 34),
(40, 'product_images/mebi-baby-girls-blue-check-dress-210719-d08062aa00af457b8f195c8e69a9f4dd9_B7UxY5r.jpg', 34),
(41, 'product_images/4cf66fe937bfe65fe96dcaacea4d2bee.jpg', 34),
(42, 'product_images/car-print-t-shirt-for-baby-boys-and-girls-578258.webp', 34),
(43, 'product_images/WhatsApp202024-05-052012_FDVFe5b.webp', 35),
(44, 'product_images/71-h5jI3FQL._UY1000__ENc5VKV.jpg', 35),
(45, 'product_images/dress-plaid-baby-girls-dresses-with-hat-1_800x_mjmG0VB.jpg', 35),
(46, 'product_images/mebi-baby-girls-blue-check-dress-210719-d08062aa00af457b8f195c8e69a9f4dd9_G5sHGQU.jpg', 35),
(47, 'product_images/4cf66fe937bfe65fe96dcaacea4d2bee_l0SOq5Q.jpg', 35),
(48, 'product_images/car-print-t-shirt-for-baby-boys-and-girls-578258_4SR1C9M.webp', 35),
(49, 'product_images/IMG_0324_1.webp', 36),
(50, 'product_images/IMG_0324.webp', 36),
(51, 'product_images/IMG_0324-ezgif.com-jpg-to-webp-converter.webp', 36);

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

--
-- Table structure for table `product_list`
--

CREATE TABLE `product_list` (
  `id` bigint(20) NOT NULL,
  `name_bangla` varchar(250) DEFAULT NULL,
  `name_english` varchar(250) DEFAULT NULL,
  `slug` varchar(250) DEFAULT NULL,
  `sku_code` varchar(50) NOT NULL,
  `unit_price` decimal(10,2) NOT NULL,
  `discount` decimal(10,2) DEFAULT NULL,
  `discount_price` decimal(10,2) DEFAULT NULL,
  `discount_status` int(11) NOT NULL,
  `quantity` int(11) NOT NULL,
  `seo_focus_keyword` varchar(100) DEFAULT NULL,
  `delivery_min_day` int(11) DEFAULT NULL,
  `delivery_max_day` int(11) DEFAULT NULL,
  `stock_status` varchar(10) NOT NULL,
  `full_detail` longtext DEFAULT NULL,
  `created` date NOT NULL,
  `updated` date DEFAULT NULL,
  `deleted_status` tinyint(1) NOT NULL,
  `product_image` varchar(100) DEFAULT NULL,
  `seo_meta_description` varchar(160) DEFAULT NULL,
  `seo_meta_title` varchar(70) DEFAULT NULL,
  `seo_og_image` varchar(100) DEFAULT NULL,
  `brand_id` bigint(20) DEFAULT NULL,
  `is_variant` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `product_list`
--

INSERT INTO `product_list` (`id`, `name_bangla`, `name_english`, `slug`, `sku_code`, `unit_price`, `discount`, `discount_price`, `discount_status`, `quantity`, `seo_focus_keyword`, `delivery_min_day`, `delivery_max_day`, `stock_status`, `full_detail`, `created`, `updated`, `deleted_status`, `product_image`, `seo_meta_description`, `seo_meta_title`, `seo_og_image`, `brand_id`, `is_variant`) VALUES
(1, 'Ivana Dorsey', 'Thomas Norman', 'thomas-norman', '250828000001', '220.00', '30.00', '190.00', 1, 22, 'Sint ipsum ea nisi', NULL, NULL, '2', 'Where does it come from?\nContrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.\n\nThe standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.\n\nWhere can I get some?\nThere are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.', '2025-08-28', '2025-09-14', 1, 'product_img/Copy_of_Blue_Yellow_Simple_New_Arrival_Streetwear_Instagram_Post_4.webp', 'Est provident solut', 'Et quis est cumque', 'product/og_images/88c3092c37a9f2d2bb1114d04b50cc2c.jpg_170x170q80.jpg__NmnJpam.webp', 2, 0),
(2, 'Mary Page', 'Preston Michael', 'preston-michael', '250828000002', '295.00', '10.00', '250.00', 1, 79, 'Autem quam est eos', NULL, NULL, '1', 'Where does it come from?\nContrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.\n\nThe standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.\n\nWhere can I get some?\nThere are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.', '2025-08-28', '2025-09-14', 0, 'product_img/88c3092c37a9f2d2bb1114d04b50cc2c.jpg_170x170q80.jpg_.webp', 'Sequi voluptas repre', 'Amet reprehenderit', '', 1, 0),
(3, 'Gary Mendez', 'Aspen Silva', 'aspen-silva', '250902000001', '1000.00', '20.00', '800.00', 1, 20, 'Odit expedita cum fu', NULL, NULL, '1', 'Where does it come from?\nContrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.\n\nThe standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.\n\nWhere can I get some?\nThere are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.', '2025-09-02', '2025-09-14', 0, 'product_img/6.webp', 'Voluptate dicta quis', 'Cillum labore qui nu', 'product/og_images/f9caf0d88c5cf83678cea75264551221.jpg_170x170q80.jpg__g7vch4F.webp', 2, 0),
(4, 'Baby Girls Floral Long Tutu skart Wedding', 'Baby Girls Floral Long Tutu skart Wedding', 'baby-girls-floral-long-tutu-skart-wedding', '250915000001', '1000.00', '36.00', '640.00', 0, 20, 'Nulla ipsum eum solu', NULL, NULL, '1', 'Product Type: baby Girls skirts set\r\n1 tops and 1 skirt\r\ncolore: As shown in the image\r\nFabrics : China Lilen\r\nMain Materials:Lilen\r\nGender:Girls\r\nNew design and style\r\nSeason: Summer\r\nOccasion: suitable for all occasion\r\nAge : 0-4\r\n\r\n#বাচ্চাদের জামা\r\nসম্পূর্ণ আমাদের নিজেদের হাতে তৈরী ।\r\n১০০ % ইন্ডিয়ান হাই কুয়ালিটি কাপড় দিয়ে অত্যন্ত যত্ন সহকারে আপনার সোনামণির জন্য তৈরী করা হয়েছে । \r\nআমাদের দেশের আবহাওয়ার কথা মাথায় রেখেই আমরা এই আরামদায়ক ড্রেসটি তৈরী করেছি ।\r\nছবির সাথে পোশাকটির কোন পার্থক্য নেই বরং ছবির থেকে বাস্তবে আরো গর্জিয়াস । \r\nসে যাবে না ।', '2025-09-15', NULL, 0, 'product_img/WhatsApp202024-05-052012.webp', 'Culpa ipsa at quis', 'Et possimus officia', 'product/og_images/WhatsApp202024-05-052012.webp', 4, 0),
(5, 'পণ্যের নাম ১', 'Product 1', 'product-1', 'SKU001', '1000.00', '100.00', '900.00', 1, 50, NULL, 2, 5, '1', 'Product 1 full detail here', '2025-09-15', '2025-09-15', 0, 'product_img/75f27fad-d49e-4781-baaa-1a03773a0734.0d1e8e84ffe438a64ef8acb75bdf3ea3.webp', NULL, NULL, '', 1, 0),
(6, 'পণ্যের নাম ২', 'Product 2', 'product-2', 'SKU002', '1200.00', '0.00', '1200.00', 0, 30, NULL, 3, 6, '1', 'Product 2 full detail here', '2025-09-15', '2025-09-15', 0, 'product_img/7.jpeg', NULL, NULL, '', 2, 0),
(7, 'পণ্যের নাম ৩', 'Product 3', 'product-3', 'SKU003', '800.00', '50.00', '750.00', 1, 20, NULL, 1, 4, '1', 'Product 3 full detail here', '2025-09-15', '2025-09-15', 0, 'product_img/1.jpg', NULL, NULL, '', 3, 0),
(8, 'পণ্যের নাম ৪', 'Product 4', 'product-4', 'SKU004', '1500.00', '0.00', '1500.00', 0, 10, NULL, 2, 5, '1', 'Product 4 full detail here', '2025-09-15', '2025-09-15', 0, 'product_img/b07ebb060addb1177a00e5fd2da3befe.jpg_960x960q80.jpg_.webp', NULL, NULL, '', 1, 0),
(9, 'পণ্যের নাম ৫', 'Product 5', 'product-5', 'SKU005', '2000.00', '200.00', '1800.00', 1, 5, NULL, 3, 7, '1', 'Product 5 full detail here', '2025-09-15', '2025-09-15', 0, 'product_img/download_L5FaBmL.jpg', NULL, NULL, '', 2, 0),
(10, 'পণ্যের নাম ৬', 'Product 6', 'product-6', 'SKU006', '950.00', '0.00', '950.00', 0, 15, NULL, 2, 6, '1', 'Product 6 full detail here', '2025-09-15', '2025-09-15', 0, 'product_img/0daf2da4feb59443745000a0f5eea5d8.jpg_720x720q80.jpg', NULL, NULL, '', 3, 0),
(11, 'পণ্যের নাম ৭', 'Product 7', 'product-7', 'SKU007', '1100.00', '100.00', '1000.00', 1, 25, NULL, 1, 3, '1', 'Product 7 full detail here', '2025-09-15', '2025-09-15', 0, 'product_img/Black-1.png', NULL, NULL, '', 1, 0),
(12, 'পণ্যের নাম ৮', 'Product 8', 'product-8', 'SKU008', '1250.00', '50.00', '1200.00', 1, 18, NULL, 2, 5, '1', 'Product 8 full detail here', '2025-09-15', '2025-09-15', 0, 'product_img/81eca3c788ef44b1cdc02e3ffa73f3c8.jpg', NULL, NULL, '', 2, 0),
(13, 'পণ্যের নাম ৯', 'Product 9', 'product-9', 'SKU009', '1400.00', '0.00', '1400.00', 0, 12, NULL, 3, 6, '1', 'Product 9 full detail here', '2025-09-15', '2025-09-15', 0, 'product_img/323_16736737340846_thumb_1_4x.jpg', NULL, NULL, '', 3, 0),
(14, 'পণ্যের নাম ১০', 'Product 10', 'product-10', 'SKU010', '1600.00', '150.00', '1450.00', 1, 8, NULL, 2, 5, '1', 'Product 10 full detail here', '2025-09-15', '2025-09-15', 0, 'product_img/3661495324817314b2a60a03c35dcb61.jpg_720x720q80.jpg', NULL, NULL, '', 4, 0),
(15, 'পণ্যের নাম ১১', 'Product 11', 'product-11', 'SKU011', '1700.00', '0.00', '1700.00', 0, 30, NULL, 2, 6, '1', 'Product 11 full detail here', '2025-09-15', '2025-09-15', 0, 'product_img/download.jpg', NULL, NULL, '', 2, 0),
(16, 'পণ্যের নাম ১২', 'Product 12', 'product-12', 'SKU012', '950.00', '50.00', '900.00', 1, 20, NULL, 1, 4, '1', 'Product 12 full detail here', '2025-09-15', '2025-09-15', 0, 'product_img/1740929561263_IMG-20250227-021248.webp', NULL, NULL, '', 3, 0),
(17, 'পণ্যের নাম ১৩', 'Product 13', 'product-13', 'SKU013', '1300.00', '0.00', '1300.00', 0, 25, NULL, 2, 5, '1', 'Product 13 full detail here', '2025-09-15', '2025-09-15', 0, 'product_img/17206045.png', NULL, NULL, '', 1, 0),
(18, 'পণ্যের নাম ১৪', 'Product 14', 'product-14', 'SKU014', '1500.00', '200.00', '1300.00', 1, 15, NULL, 2, 6, '1', 'Product 14 full detail here', '2025-09-15', '2025-09-15', 0, 'product_img/4cf66fe937bfe65fe96dcaacea4d2bee.jpg', NULL, NULL, '', 2, 0),
(19, 'পণ্যের নাম ১৫', 'Product 15', 'product-15', 'SKU015', '1750.00', '0.00', '1750.00', 0, 12, NULL, 3, 7, '1', 'Product 15 full detail here', '2025-09-15', '2025-09-15', 0, 'product_img/car-print-t-shirt-for-baby-boys-and-girls-578258.webp', NULL, NULL, '', 3, 0),
(20, 'পণ্যের নাম ১৬', 'Product 16', 'product-16', 'SKU016', '900.00', '50.00', '850.00', 1, 22, NULL, 1, 4, '1', 'Product 16 full detail here', '2025-09-15', '2025-09-15', 0, 'product_img/mebi-baby-girls-blue-check-dress-210719-d08062aa00af457b8f195c8e69a9f4dd91bb5cc7.jpg', NULL, NULL, '', 1, 0),
(21, 'পণ্যের নাম ১৭', 'Product 17', 'product-17', 'SKU017', '1200.00', '0.00', '1200.00', 0, 28, NULL, 2, 5, '1', 'Product 17 full detail here', '2025-09-15', '2025-09-15', 0, 'product_img/71-h5jI3FQL._UY1000_.jpg', NULL, NULL, '', 2, 0),
(22, 'পণ্যের নাম ১৮', 'Product 18', 'product-18', 'SKU018', '1100.00', '100.00', '1000.00', 1, 18, NULL, 2, 5, '1', 'Product 18 full detail here', '2025-09-15', '2025-09-15', 0, 'product_img/Sefef7094a1634e01811ae2d0ef1d3ba6s.webp', NULL, NULL, '', 3, 0),
(23, 'পণ্যের নাম ১৯', 'Product 19', 'product-19', 'SKU019', '1400.00', '150.00', '1250.00', 1, 10, NULL, 3, 6, '1', 'Product 19 full detail here', '2025-09-15', '2025-09-15', 0, 'product_img/z1246450743_2.webp', NULL, NULL, '', 1, 0),
(24, 'পণ্যের নাম ২০', 'Product 20', 'product-20', 'SKU020', '1600.00', '0.00', '1600.00', 0, 15, NULL, 2, 5, '1', 'Product 20 full detail here', '2025-09-15', '2025-09-15', 0, 'product_img/281e812b-f0ac-467a-adc1-025af241a1c3.4f2d253cc3e6182cd50cdf4457c09d8f.webp', NULL, NULL, '', 2, 0),
(25, 'Sean Schmidt', 'Madaline Ashley', 'madaline-ashley', '250915000002', '381.00', '19.00', '320.00', 1, 63, 'Eveniet vero quis a', NULL, NULL, '1', 'In ea et non quis su', '2025-09-15', NULL, 0, 'product_img/323_16736737340846_thumb_1_4x_AZ5Tx0O.jpg', 'Mollitia ea quo in d', 'Quae aut maiores lab', '', NULL, 0),
(26, 'Susan Whitney', 'Chantale Reid', 'chantale-reid', '250915000003', '1400.00', '33.00', '938.00', 1, 153, 'Et velit repudiandae', NULL, NULL, '1', 'Illum error voluptaIllum error voluptaIllum error voluptaIllum error voluptaIllum error voluptaIllum error voluptaIllum error voluptaIllum error voluptaIllum error voluptaIllum error voluptaIllum error voluptaIllum error voluptaIllum error voluptaIllum error voluptaIllum error voluptaIllum error voluptaIllum error voluptaIllum error voluptaIllum error voluptaIllum error voluptaIllum error voluptaIllum error voluptaIllum error voluptaIllum error voluptaIllum error voluptaIllum error voluptaIllum error voluptaIllum error volupta', '2025-09-15', NULL, 0, 'product_img/1_7c1a3982-fd5c-4a95-95a6-e7156b0da5c1.webp', 'Sunt ullam ea nesciu', 'Sit ad sed non et a', '', NULL, 0),
(27, 'Philip Greene', 'Quinlan Hubbard qwertyu', 'quinlan-hubbard-qwertyu', '250917000001', '400.00', '20.00', '320.00', 1, 123, 'Amet iusto aliquip ', NULL, NULL, '1', 'Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex Eum duis tempora ex ', '2025-09-17', NULL, 0, 'product_img/281e812b-f0ac-467a-adc1-025af241a1c3.4f2d253cc3e6182cd50cdf4457c09d8f_aGdarLF.webp', 'Tempora omnis provid', 'Aut tempore magnam ', '', NULL, 0),
(28, 'Jayme Lancaster', 'Kelsey Cole', 'kelsey-cole', '250918000001', '0.00', '0.00', '0.00', 0, 0, 'Commodi in ut volupt', NULL, NULL, '1', 'Fugit quia aut beat', '2025-09-18', '2025-09-18', 0, 'product_img/Sefef7094a1634e01811ae2d0ef1d3ba6s_mmVE6vl.webp', 'Quasi ut unde iste d', 'Iste amet doloremqu', '', 3, 0),
(29, 'Jayme Lancaster', 'Kelsey Cole', 'kelsey-cole', '250918000001', '0.00', '0.00', '0.00', 0, 0, 'Commodi in ut volupt', NULL, NULL, '1', 'Fugit quia aut beat', '2025-09-18', '2025-09-18', 0, 'product_img/mebi-baby-girls-blue-check-dress-210719-d08062aa00af457b8f195c8e69a9f4dd91bb_NY1fUAg.jpg', 'Quasi ut unde iste d', 'Iste amet doloremqu', '', 4, 0),
(30, 'Jayme Lancaster', 'Kelsey Cole', 'kelsey-cole', '250918000001', '0.00', '0.00', '0.00', 0, 0, 'Commodi in ut volupt', NULL, NULL, '1', 'Fugit quia aut beat', '2025-09-18', '2025-09-18', 0, 'product_img/4cf66fe937bfe65fe96dcaacea4d2bee_KHYgli6.jpg', 'Quasi ut unde iste d', 'Iste amet doloremqu', '', 3, 0),
(31, 'Jayme Lancaster', 'Kelsey Cole', 'kelsey-cole', '250918000001', '0.00', '0.00', '0.00', 0, 0, 'Commodi in ut volupt', NULL, NULL, '1', 'Fugit quia aut beat', '2025-09-18', '2025-09-18', 0, 'product_img/z1246450743_2_ZyEwgFL.webp', 'Quasi ut unde iste d', 'Iste amet doloremqu', '', 3, 0),
(32, 'Jayme Lancaster', 'Kelsey Cole', 'kelsey-cole', '250918000001', '0.00', '0.00', '0.00', 0, 0, 'Commodi in ut volupt', NULL, NULL, '1', 'Fugit quia aut beat', '2025-09-18', '2025-09-18', 0, 'product_img/car-print-t-shirt-for-baby-boys-and-girls-964959.webp', 'Quasi ut unde iste d', 'Iste amet doloremqu', '', 1, 0),
(33, 'Jayme Lancaster', 'Kelsey Cole', 'kelsey-cole', '250918000001', '0.00', '0.00', '0.00', 0, 0, 'Commodi in ut volupt', NULL, NULL, '1', 'Fugit quia aut beat', '2025-09-18', NULL, 0, 'product_img/dress-plaid-baby-girls-dresses-with-hat-1_800x.jpg', 'Quasi ut unde iste d', 'Iste amet doloremqu', '', NULL, 1),
(34, 'Taylor English', 'Hasad Bartlett', 'hasad-bartlett', '250918000001', '0.00', '0.00', '0.00', 0, 0, 'Veniam et temporibu', NULL, NULL, '1', 'Enim magnam praesent', '2025-09-18', NULL, 0, 'product_img/mebi-baby-girls-blue-check-dress-210719-d08062aa00af457b8f195c8e69a9f4dd91bb_1p48Q2D.jpg', 'Sunt do natus ut ali', 'Doloribus impedit e', '', NULL, 1),
(35, 'This is Test Product Name', 'This is Test Product Name', 'this-is-test-product-name', '250922000001', '0.00', '0.00', '0.00', 0, 0, 'This is product details. This is product details. This is product details.  ', NULL, NULL, '1', 'This is product details. This is product details. This is product details. This is product details. This is product details. This is product details. This is product details. This is product details. This is product details. This is product details. This is product details. This is product details. This is product details. This is product details. This is product details. This is product details. This is product details. This is product details. This is product details. This is product details. ', '2025-09-22', NULL, 0, 'product_img/IMG_0458.jpg', 'This is product details. This is product details. This is product details ', 'This is product details. This is product details.', '', NULL, 1),
(36, 'Top Men Full hand 100% cotton Shirt', 'Top Men Full hand 100% cotton Shirt', 'top-men-full-hand-100-cotton-shirt', '250922000001', '400.00', '10.00', '360.00', 1, 11, ' adf ', NULL, NULL, '1', 'a fkasd;lkfjklasdjf', '2025-09-22', NULL, 0, 'product_img/old_money_3.webp', ' adf', 'ad f', '', NULL, 1);

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

--
-- Table structure for table `product_wise_category`
--

CREATE TABLE `product_wise_category` (
  `id` bigint(20) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `category_id` bigint(20) DEFAULT NULL,
  `product_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `product_wise_category`
--

INSERT INTO `product_wise_category` (`id`, `status`, `created`, `category_id`, `product_id`) VALUES
(1, 1, '2025-09-02 11:18:11.432293', 1, 2),
(2, 1, '2025-09-02 11:18:11.432293', 2, 2),
(3, 1, '2025-09-02 11:18:11.432293', 3, 2),
(4, 1, '2025-09-02 17:49:03.969325', 1, 3),
(5, 1, '2025-09-02 17:49:03.988611', 3, 3),
(6, 1, '2025-09-15 14:34:47.814771', 4, 4),
(7, 1, '2025-09-15 15:48:53.656682', 5, 24),
(8, 1, '2025-09-15 15:48:53.674910', 8, 24),
(9, 1, '2025-09-16 15:52:14.639359', 9, 14),
(10, 1, '2025-09-16 15:52:14.645418', 8, 14),
(11, 1, '2025-09-17 17:59:13.107139', 5, 27),
(12, 1, '2025-09-17 17:59:13.111135', 8, 27),
(13, 1, '2025-09-17 18:14:58.053847', 2, 28),
(14, 1, '2025-09-17 18:14:58.053847', 4, 28),
(15, 1, '2025-09-17 18:16:02.146841', 2, 29),
(16, 1, '2025-09-17 18:16:02.146841', 4, 29),
(17, 1, '2025-09-17 18:17:55.622914', 2, 30),
(18, 1, '2025-09-17 18:17:55.622914', 4, 30),
(19, 1, '2025-09-17 18:24:09.974969', 2, 31),
(20, 1, '2025-09-17 18:24:09.982985', 4, 31),
(21, 1, '2025-09-17 18:24:49.475651', 2, 32),
(22, 1, '2025-09-17 18:24:49.475651', 4, 32),
(23, 1, '2025-09-17 18:25:11.274300', 2, 33),
(24, 1, '2025-09-17 18:25:11.274300', 4, 33),
(25, 1, '2025-09-17 18:32:24.681731', 4, 34),
(26, 1, '2025-09-17 18:32:24.681731', 6, 34),
(27, 1, '2025-09-22 16:39:39.313159', 1, 35),
(28, 1, '2025-09-22 16:39:39.317331', 4, 35),
(29, 1, '2025-09-22 17:46:13.026885', 5, 36),
(30, 1, '2025-09-22 17:46:13.030881', 8, 36);

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

--
-- Table structure for table `product_wise_color`
--

CREATE TABLE `product_wise_color` (
  `id` bigint(20) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `color_id` bigint(20) DEFAULT NULL,
  `product_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `product_wise_color`
--

INSERT INTO `product_wise_color` (`id`, `status`, `created`, `color_id`, `product_id`) VALUES
(1, 1, '2025-09-02 11:18:11.448316', 1, 2),
(2, 1, '2025-09-02 11:18:11.448316', 3, 2),
(3, 1, '2025-09-02 17:49:03.988611', 2, 3),
(4, 1, '2025-09-02 17:49:03.999897', 4, 3),
(5, 1, '2025-09-15 14:34:47.822235', 1, 4),
(6, 1, '2025-09-15 14:34:47.828199', 5, 4),
(7, 1, '2025-09-16 15:52:14.652152', 3, 14),
(8, 1, '2025-09-16 15:52:14.655279', 5, 14),
(9, 1, '2025-09-16 15:52:14.662280', 1, 14),
(10, 1, '2025-09-17 18:17:55.622914', 1, 30),
(11, 1, '2025-09-17 18:17:55.638551', 2, 30),
(12, 1, '2025-09-17 18:17:55.638551', 3, 30),
(13, 1, '2025-09-17 18:24:09.982985', 1, 31),
(14, 1, '2025-09-17 18:24:09.982985', 2, 31),
(15, 1, '2025-09-17 18:24:09.982985', 3, 31),
(16, 1, '2025-09-17 18:24:49.475651', 1, 32),
(17, 1, '2025-09-17 18:24:49.475651', 2, 32),
(18, 1, '2025-09-17 18:24:49.491312', 3, 32),
(19, 1, '2025-09-17 18:25:11.274300', 1, 33),
(20, 1, '2025-09-17 18:25:11.285313', 2, 33),
(21, 1, '2025-09-17 18:25:11.290390', 3, 33),
(22, 1, '2025-09-17 18:32:24.699375', 2, 34),
(23, 1, '2025-09-17 18:32:24.705384', 4, 34),
(24, 1, '2025-09-22 16:39:39.321301', 1, 35),
(25, 1, '2025-09-22 16:39:39.325939', 2, 35),
(26, 1, '2025-09-22 16:39:39.330227', 4, 35),
(27, 1, '2025-09-22 16:39:39.334890', 3, 35),
(28, 1, '2025-09-22 17:46:13.039668', 1, 36),
(29, 1, '2025-09-22 17:46:13.044164', 5, 36),
(30, 1, '2025-09-22 17:46:13.048737', 4, 36);

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

--
-- Table structure for table `product_wise_size`
--

CREATE TABLE `product_wise_size` (
  `id` bigint(20) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `product_id` bigint(20) DEFAULT NULL,
  `size_id` bigint(20) DEFAULT NULL,
  `discount_price` decimal(10,2) NOT NULL,
  `quantity` int(10) UNSIGNED NOT NULL CHECK (`quantity` >= 0),
  `unit_price` decimal(10,2) NOT NULL,
  `discount` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `product_wise_size`
--

INSERT INTO `product_wise_size` (`id`, `status`, `created`, `product_id`, `size_id`, `discount_price`, `quantity`, `unit_price`, `discount`) VALUES
(1, 1, '2025-09-02 11:18:11.448316', 2, 1, '1.00', 0, '1.00', '1.00'),
(2, 1, '2025-09-02 11:18:11.463964', 2, 3, '1.00', 0, '1.00', '1.00'),
(3, 1, '2025-09-02 17:49:04.008277', 3, 1, '1.00', 0, '1.00', '1.00'),
(4, 1, '2025-09-02 17:49:04.014691', 3, 3, '1.00', 0, '1.00', '1.00'),
(5, 1, '2025-09-15 14:34:47.836205', 4, 2, '1.00', 0, '1.00', '1.00'),
(6, 1, '2025-09-15 14:34:47.843508', 4, 3, '1.00', 0, '1.00', '1.00'),
(7, 1, '2025-09-15 14:34:47.851588', 4, 4, '1.00', 0, '1.00', '1.00'),
(8, 1, '2025-09-15 15:48:53.678661', 24, 2, '1.00', 0, '1.00', '1.00'),
(9, 1, '2025-09-15 15:48:53.683660', 24, 3, '1.00', 0, '1.00', '1.00'),
(10, 1, '2025-09-16 15:52:14.665883', 14, 1, '1.00', 0, '1.00', '1.00'),
(11, 1, '2025-09-16 15:52:14.669893', 14, 2, '1.00', 0, '1.00', '1.00'),
(12, 1, '2025-09-16 15:52:14.672897', 14, 4, '1.00', 0, '1.00', '1.00'),
(13, 1, '2025-09-17 18:25:11.290390', 33, 2, '450.00', 10, '500.00', '10.00'),
(14, 1, '2025-09-17 18:25:11.290390', 33, 3, '528.00', 13, '600.00', '12.00'),
(15, 1, '2025-09-17 18:32:24.709370', 34, 3, '240.00', 20, '300.00', '20.00'),
(16, 1, '2025-09-17 18:32:24.715060', 34, 4, '288.00', 40, '360.00', '20.00'),
(17, 1, '2025-09-22 16:39:39.342130', 35, 1, '90.00', 10, '100.00', '10.00'),
(18, 1, '2025-09-22 16:39:39.345971', 35, 2, '117.00', 10, '130.00', '10.00'),
(19, 1, '2025-09-22 16:39:39.349756', 35, 3, '130.50', 12, '150.00', '13.00'),
(20, 1, '2025-09-22 16:39:39.360593', 35, 4, '147.90', 13, '170.00', '13.00'),
(21, 1, '2025-09-22 17:46:13.052765', 36, 1, '360.00', 11, '400.00', '10.00'),
(22, 1, '2025-09-22 17:46:13.059228', 36, 2, '400.50', 11, '450.00', '11.00'),
(23, 1, '2025-09-22 17:46:13.062794', 36, 3, '435.00', 13, '500.00', '13.00');

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

--
-- Table structure for table `sales_order_details`
--

CREATE TABLE `sales_order_details` (
  `id` bigint(20) NOT NULL,
  `unit_price` decimal(10,2) NOT NULL,
  `discount` decimal(10,2) DEFAULT NULL,
  `discount_price` decimal(10,2) DEFAULT NULL,
  `quantity` int(11) NOT NULL,
  `total_price` decimal(10,2) DEFAULT NULL,
  `remarks` longtext NOT NULL,
  `created` datetime(6) NOT NULL,
  `updated` datetime(6) DEFAULT NULL,
  `status` tinyint(1) NOT NULL,
  `order_no_id` bigint(20) DEFAULT NULL,
  `product_id` bigint(20) DEFAULT NULL,
  `color_id` bigint(20) DEFAULT NULL,
  `size_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `sales_order_details`
--

INSERT INTO `sales_order_details` (`id`, `unit_price`, `discount`, `discount_price`, `quantity`, `total_price`, `remarks`, `created`, `updated`, `status`, `order_no_id`, `product_id`, `color_id`, `size_id`) VALUES
(1, '320.00', '20.00', '320.00', 3, '960.00', '', '2025-09-28 05:42:53.138435', NULL, 1, 1, 27, NULL, NULL),
(2, '640.00', '36.00', '640.00', 6, '3840.00', '', '2025-09-28 05:42:53.138435', NULL, 1, 1, 4, NULL, NULL),
(3, '360.00', '10.00', '360.00', 5, '1800.00', '', '2025-09-28 05:42:53.138435', NULL, 1, 1, 36, NULL, NULL),
(4, '1600.00', '0.00', '1600.00', 1, '1600.00', '', '2025-09-28 05:42:53.152322', NULL, 1, 1, 24, NULL, NULL),
(5, '320.00', '20.00', '320.00', 2, '640.00', '', '2025-09-28 17:08:55.856871', NULL, 1, 2, 27, NULL, NULL),
(6, '250.00', '10.00', '250.00', 2, '500.00', '', '2025-09-28 17:27:52.391878', NULL, 1, 3, 2, NULL, NULL),
(7, '320.00', '20.00', '320.00', 3, '960.00', '', '2025-09-28 17:27:52.394641', NULL, 1, 3, 27, NULL, NULL),
(8, '800.00', '20.00', '800.00', 4, '3200.00', '', '2025-09-28 17:36:00.197349', NULL, 1, 4, 3, 4, 3),
(9, '640.00', '36.00', '640.00', 4, '2560.00', '', '2025-09-28 17:36:00.197349', NULL, 1, 4, 4, 1, 4),
(10, '640.00', '36.00', '640.00', 3, '1920.00', '', '2025-09-29 03:29:12.913329', NULL, 1, 5, 4, 1, 2),
(11, '1600.00', '0.00', '1600.00', 5, '8000.00', '', '2025-09-29 03:29:12.913329', NULL, 1, 5, 24, NULL, 3),
(12, '360.00', '10.00', '360.00', 1, '360.00', '', '2025-09-30 16:26:33.716423', NULL, 1, 6, 36, 5, 3),
(13, '320.00', '20.00', '320.00', 2, '640.00', '', '2025-09-30 16:30:30.453415', NULL, 1, 7, 27, NULL, NULL),
(14, '250.00', '10.00', '250.00', 5, '1250.00', '', '2025-10-03 15:59:10.832459', NULL, 1, 8, 2, NULL, 3),
(15, '640.00', '36.00', '640.00', 4, '2560.00', '', '2025-10-03 15:59:10.835510', NULL, 1, 8, 4, NULL, 2),
(16, '1600.00', '0.00', '1600.00', 6, '9600.00', '', '2025-10-03 16:51:51.047437', NULL, 1, 9, 24, NULL, 3),
(17, '640.00', '36.00', '640.00', 2, '1280.00', '', '2025-10-05 09:27:30.079567', NULL, 1, 10, 4, NULL, 2),
(18, '320.00', '20.00', '320.00', 1, '320.00', '', '2025-10-05 09:27:30.097590', NULL, 1, 10, 27, NULL, NULL),
(19, '0.00', '0.00', NULL, 3, '0.00', '', '2025-10-05 09:27:30.098589', NULL, 1, 10, 32, NULL, NULL),
(20, '640.00', '36.00', '640.00', 4, '2560.00', '', '2025-10-05 16:24:38.042892', NULL, 1, 11, 4, NULL, 2),
(21, '250.00', '10.00', '250.00', 5, '1250.00', '', '2025-10-06 17:33:42.562813', NULL, 1, 12, 2, NULL, 1),
(22, '800.00', '20.00', '800.00', 7, '5600.00', '', '2025-10-06 17:33:42.562813', NULL, 1, 12, 3, NULL, 1);

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

--
-- Table structure for table `size_list`
--

CREATE TABLE `size_list` (
  `id` bigint(20) NOT NULL,
  `size_name` varchar(60) DEFAULT NULL,
  `short_code` varchar(10) DEFAULT NULL,
  `ordering` int(11) NOT NULL,
  `created` datetime(6) NOT NULL,
  `status` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `size_list`
--

INSERT INTO `size_list` (`id`, `size_name`, `short_code`, `ordering`, `created`, `status`) VALUES
(1, 'Small', 'S', 1, '2025-08-26 23:14:57.000000', 1),
(2, 'Medium', 'M', 2, '2025-08-26 23:14:57.000000', 1),
(3, 'Large', 'L', 3, '2025-08-26 23:14:57.000000', 1),
(4, 'Extra Large', 'XL', 4, '2025-08-26 23:14:57.000000', 1),
(5, 'Double Extra Large', 'XXL', 5, '2025-08-26 23:14:57.000000', 1);

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

--
-- Table structure for table `slider_list`
--

CREATE TABLE `slider_list` (
  `id` bigint(20) NOT NULL,
  `title` varchar(200) DEFAULT NULL,
  `subtitle` varchar(250) DEFAULT NULL,
  `image` varchar(100) NOT NULL,
  `ordering` int(10) UNSIGNED NOT NULL CHECK (`ordering` >= 0),
  `status` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `updated` datetime(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `slider_list`
--

INSERT INTO `slider_list` (`id`, `title`, `subtitle`, `image`, `ordering`, `status`, `created`, `updated`) VALUES
(1, 'Slider 1', 'Slider 1', 'sliders/slider3.jpg', 1, 1, '2025-09-16 14:56:05.444420', '2025-09-16 14:56:05.444420'),
(2, 'Slider 2', NULL, 'sliders/slider2.jpg', 2, 1, '2025-09-16 14:56:22.296475', '2025-09-16 14:56:22.296475'),
(3, 'Slider 3', NULL, 'sliders/slider1.jpg', 3, 1, '2025-09-16 14:56:37.593285', '2025-09-16 16:55:28.798543');

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

--
-- Table structure for table `upozilla_list`
--

CREATE TABLE `upozilla_list` (
  `id` bigint(20) NOT NULL,
  `name` varchar(230) NOT NULL,
  `rank` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `district_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `user_access_control`
--

CREATE TABLE `user_access_control` (
  `id` bigint(20) NOT NULL,
  `can_create` tinyint(1) NOT NULL,
  `can_read` tinyint(1) NOT NULL,
  `can_update` tinyint(1) NOT NULL,
  `can_delete` tinyint(1) NOT NULL,
  `created_by_id` bigint(20) DEFAULT NULL,
  `employee_id` bigint(20) DEFAULT NULL,
  `menu_id` bigint(20) DEFAULT NULL,
  `module_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `user_access_control`
--

INSERT INTO `user_access_control` (`id`, `can_create`, `can_read`, `can_update`, `can_delete`, `created_by_id`, `employee_id`, `menu_id`, `module_id`) VALUES
(1, 1, 1, 1, 1, 4, 4, 1, 1),
(2, 1, 1, 1, 1, 4, 4, 3, 1),
(3, 1, 1, 1, 1, 4, 4, 5, 9),
(4, 1, 1, 1, 1, 4, 4, 6, 9),
(5, 1, 1, 1, 1, 4, 4, 8, 9),
(6, 1, 1, 1, 1, 4, 4, 4, 6),
(7, 1, 1, 1, 1, 4, 4, 13, 6),
(8, 1, 1, 1, 1, 4, 4, 15, 3),
(9, 1, 1, 1, 1, 4, 4, 16, 3),
(10, 1, 1, 1, 1, 4, 6, 4, 6),
(11, 1, 1, 1, 1, 4, 4, 17, 13);

--
-- Indexes for table `attendance`
--
ALTER TABLE `attendance`
  ADD PRIMARY KEY (`id`),
  ADD KEY `attendance_employee_id_882f95e1_fk_employee_list_id` (`employee_id`);

--
-- Indexes for table `auth_group`
--
ALTER TABLE `auth_group`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `auth_group_permissions`
--
ALTER TABLE `auth_group_permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` (`group_id`,`permission_id`),
  ADD KEY `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` (`permission_id`);

--
-- Indexes for table `auth_permission`
--
ALTER TABLE `auth_permission`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `auth_permission_content_type_id_codename_01ab375a_uniq` (`content_type_id`,`codename`);

--
-- Indexes for table `auth_user_groups`
--
ALTER TABLE `auth_user_groups`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `auth_user_groups_user_id_group_id_94350c0c_uniq` (`user_id`,`group_id`),
  ADD KEY `auth_user_groups_group_id_97559544_fk_auth_group_id` (`group_id`);

--
-- Indexes for table `auth_user_user_permissions`
--
ALTER TABLE `auth_user_user_permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `auth_user_user_permissions_user_id_permission_id_14a6b632_uniq` (`user_id`,`permission_id`),
  ADD KEY `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` (`permission_id`);

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

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

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

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

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

--
-- Indexes for table `department_list`
--
ALTER TABLE `department_list`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `designation_list`
--
ALTER TABLE `designation_list`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

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

--
-- Indexes for table `django_admin_log`
--
ALTER TABLE `django_admin_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `django_admin_log_content_type_id_c4bce8eb_fk_django_co` (`content_type_id`),
  ADD KEY `django_admin_log_user_id_c564eba6_fk_auth_user_id` (`user_id`);

--
-- Indexes for table `django_content_type`
--
ALTER TABLE `django_content_type`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `django_content_type_app_label_model_76bd3d3b_uniq` (`app_label`,`model`);

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

--
-- Indexes for table `leave_request`
--
ALTER TABLE `leave_request`
  ADD PRIMARY KEY (`id`),
  ADD KEY `leave_request_employee_id_0dd5db52_fk_employee_list_id` (`employee_id`);

--
-- Indexes for table `module_list`
--
ALTER TABLE `module_list`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `module_menu_list`
--
ALTER TABLE `module_menu_list`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`),
  ADD KEY `module_menu_list_module_id_67121058_fk_module_list_id` (`module_id`);

--
-- Indexes for table `payroll`
--
ALTER TABLE `payroll`
  ADD PRIMARY KEY (`id`),
  ADD KEY `payroll_employee_id_67de6c80_fk_employee_list_id` (`employee_id`);

--
-- Indexes for table `product_image`
--
ALTER TABLE `product_image`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_image_product_id_8b9355c5_fk_product_list_id` (`product_id`);

--
-- Indexes for table `product_list`
--
ALTER TABLE `product_list`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_list_brand_id_b8691ca9_fk_brand_list_id` (`brand_id`);

--
-- Indexes for table `product_wise_category`
--
ALTER TABLE `product_wise_category`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_wise_category_product_id_42fa40d8_fk_product_list_id` (`product_id`),
  ADD KEY `product_wise_category_category_id_e22c848c_fk_category_list_id` (`category_id`);

--
-- Indexes for table `product_wise_color`
--
ALTER TABLE `product_wise_color`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_wise_color_product_id_00ab6db5_fk_product_list_id` (`product_id`),
  ADD KEY `product_wise_color_color_id_15e368d4_fk_product_color_list_id` (`color_id`);

--
-- Indexes for table `product_wise_size`
--
ALTER TABLE `product_wise_size`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_wise_size_product_id_fb7d5d7f_fk_product_list_id` (`product_id`),
  ADD KEY `product_wise_size_size_id_ea7319f8_fk_product_size_list_id` (`size_id`);

--
-- Indexes for table `sales_order_details`
--
ALTER TABLE `sales_order_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sales_order_details_order_no_id_22210675_fk_sales_order_id` (`order_no_id`),
  ADD KEY `sales_order_details_product_id_cc6af7e3_fk_product_list_id` (`product_id`),
  ADD KEY `sales_order_details_color_id_fdb55112_fk_color_list_id` (`color_id`),
  ADD KEY `sales_order_details_size_id_4f8792c2_fk_size_list_id` (`size_id`);

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

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

--
-- Indexes for table `upozilla_list`
--
ALTER TABLE `upozilla_list`
  ADD PRIMARY KEY (`id`),
  ADD KEY `upozilla_list_district_id_d1c18f48_fk_district_list_id` (`district_id`);

--
-- Indexes for table `user_access_control`
--
ALTER TABLE `user_access_control`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_access_control_created_by_id_ce5fda76_fk_employee_list_id` (`created_by_id`),
  ADD KEY `user_access_control_employee_id_288ea4ba_fk_employee_list_id` (`employee_id`),
  ADD KEY `user_access_control_menu_id_63ecee08_fk_module_menu_list_id` (`menu_id`),
  ADD KEY `user_access_control_module_id_a64c4b57_fk_module_list_id` (`module_id`);

--
-- AUTO_INCREMENT for table `attendance`
--
ALTER TABLE `attendance`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `auth_group`
--
ALTER TABLE `auth_group`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `auth_group_permissions`
--
ALTER TABLE `auth_group_permissions`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `auth_permission`
--
ALTER TABLE `auth_permission`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=149;

--
-- AUTO_INCREMENT for table `auth_user_groups`
--
ALTER TABLE `auth_user_groups`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `auth_user_user_permissions`
--
ALTER TABLE `auth_user_user_permissions`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

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

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

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

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

--
-- AUTO_INCREMENT for table `courier_service_list`
--
ALTER TABLE `courier_service_list`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

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

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

--
-- AUTO_INCREMENT for table `district_list`
--
ALTER TABLE `district_list`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `django_admin_log`
--
ALTER TABLE `django_admin_log`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=62;

--
-- AUTO_INCREMENT for table `django_content_type`
--
ALTER TABLE `django_content_type`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;

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

--
-- AUTO_INCREMENT for table `leave_request`
--
ALTER TABLE `leave_request`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

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

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

--
-- AUTO_INCREMENT for table `payroll`
--
ALTER TABLE `payroll`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `upozilla_list`
--
ALTER TABLE `upozilla_list`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

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

--
-- Constraints for table `attendance`
--
ALTER TABLE `attendance`
  ADD CONSTRAINT `attendance_employee_id_882f95e1_fk_employee_list_id` FOREIGN KEY (`employee_id`) REFERENCES `employee_list` (`id`);

--
-- Constraints for table `auth_group_permissions`
--
ALTER TABLE `auth_group_permissions`
  ADD CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
  ADD CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`);

--
-- Constraints for table `auth_permission`
--
ALTER TABLE `auth_permission`
  ADD CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`);

--
-- Constraints for table `auth_user_groups`
--
ALTER TABLE `auth_user_groups`
  ADD CONSTRAINT `auth_user_groups_group_id_97559544_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`),
  ADD CONSTRAINT `auth_user_groups_user_id_6a12ed8b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`);

--
-- Constraints for table `auth_user_user_permissions`
--
ALTER TABLE `auth_user_user_permissions`
  ADD CONSTRAINT `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
  ADD CONSTRAINT `auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`);

--
-- Constraints for table `django_admin_log`
--
ALTER TABLE `django_admin_log`
  ADD CONSTRAINT `django_admin_log_content_type_id_c4bce8eb_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`),
  ADD CONSTRAINT `django_admin_log_user_id_c564eba6_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`);

--
-- Constraints for table `leave_request`
--
ALTER TABLE `leave_request`
  ADD CONSTRAINT `leave_request_employee_id_0dd5db52_fk_employee_list_id` FOREIGN KEY (`employee_id`) REFERENCES `employee_list` (`id`);

--
-- Constraints for table `module_menu_list`
--
ALTER TABLE `module_menu_list`
  ADD CONSTRAINT `module_menu_list_module_id_67121058_fk_module_list_id` FOREIGN KEY (`module_id`) REFERENCES `module_list` (`id`);

--
-- Constraints for table `payroll`
--
ALTER TABLE `payroll`
  ADD CONSTRAINT `payroll_employee_id_67de6c80_fk_employee_list_id` FOREIGN KEY (`employee_id`) REFERENCES `employee_list` (`id`);

--
-- Constraints for table `product_image`
--
ALTER TABLE `product_image`
  ADD CONSTRAINT `product_image_product_id_8b9355c5_fk_product_list_id` FOREIGN KEY (`product_id`) REFERENCES `product_list` (`id`);

--
-- Constraints for table `product_list`
--
ALTER TABLE `product_list`
  ADD CONSTRAINT `product_list_brand_id_b8691ca9_fk_brand_list_id` FOREIGN KEY (`brand_id`) REFERENCES `brand_list` (`id`);

--
-- Constraints for table `product_wise_category`
--
ALTER TABLE `product_wise_category`
  ADD CONSTRAINT `product_wise_category_category_id_e22c848c_fk_category_list_id` FOREIGN KEY (`category_id`) REFERENCES `category_list` (`id`),
  ADD CONSTRAINT `product_wise_category_product_id_42fa40d8_fk_product_list_id` FOREIGN KEY (`product_id`) REFERENCES `product_list` (`id`);

--
-- Constraints for table `product_wise_color`
--
ALTER TABLE `product_wise_color`
  ADD CONSTRAINT `product_wise_color_color_id_15e368d4_fk_product_color_list_id` FOREIGN KEY (`color_id`) REFERENCES `color_list` (`id`),
  ADD CONSTRAINT `product_wise_color_product_id_00ab6db5_fk_product_list_id` FOREIGN KEY (`product_id`) REFERENCES `product_list` (`id`);

--
-- Constraints for table `product_wise_size`
--
ALTER TABLE `product_wise_size`
  ADD CONSTRAINT `product_wise_size_product_id_fb7d5d7f_fk_product_list_id` FOREIGN KEY (`product_id`) REFERENCES `product_list` (`id`),
  ADD CONSTRAINT `product_wise_size_size_id_ea7319f8_fk_product_size_list_id` FOREIGN KEY (`size_id`) REFERENCES `size_list` (`id`);

--
-- Constraints for table `sales_order_details`
--
ALTER TABLE `sales_order_details`
  ADD CONSTRAINT `sales_order_details_color_id_fdb55112_fk_color_list_id` FOREIGN KEY (`color_id`) REFERENCES `color_list` (`id`),
  ADD CONSTRAINT `sales_order_details_order_no_id_22210675_fk_sales_order_id` FOREIGN KEY (`order_no_id`) REFERENCES `sales_order` (`id`),
  ADD CONSTRAINT `sales_order_details_product_id_cc6af7e3_fk_product_list_id` FOREIGN KEY (`product_id`) REFERENCES `product_list` (`id`),
  ADD CONSTRAINT `sales_order_details_size_id_4f8792c2_fk_size_list_id` FOREIGN KEY (`size_id`) REFERENCES `size_list` (`id`);

--
-- Constraints for table `upozilla_list`
--
ALTER TABLE `upozilla_list`
  ADD CONSTRAINT `upozilla_list_district_id_d1c18f48_fk_district_list_id` FOREIGN KEY (`district_id`) REFERENCES `district_list` (`id`);

--
-- Constraints for table `user_access_control`
--
ALTER TABLE `user_access_control`
  ADD CONSTRAINT `user_access_control_created_by_id_ce5fda76_fk_employee_list_id` FOREIGN KEY (`created_by_id`) REFERENCES `employee_list` (`id`),
  ADD CONSTRAINT `user_access_control_employee_id_288ea4ba_fk_employee_list_id` FOREIGN KEY (`employee_id`) REFERENCES `employee_list` (`id`),
  ADD CONSTRAINT `user_access_control_menu_id_63ecee08_fk_module_menu_list_id` FOREIGN KEY (`menu_id`) REFERENCES `module_menu_list` (`id`),
  ADD CONSTRAINT `user_access_control_module_id_a64c4b57_fk_module_list_id` FOREIGN KEY (`module_id`) REFERENCES `module_list` (`id`);
COMMIT;

