-- phpMyAdmin SQL Dump
-- version 5.2.3
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Oct 12, 2026 at 02:08 PM
-- Server version: 11.4.13-MariaDB
-- PHP Version: 8.4.26
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `freela36_skdealbd`
--
-- --------------------------------------------------------
--
-- Table structure for table `addbanners`
--
CREATE TABLE `addbanners` (
`id` bigint(20) UNSIGNED NOT NULL,
`add_link` text DEFAULT NULL,
`add_image` longtext NOT NULL,
`status` varchar(255) NOT NULL DEFAULT 'Active',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `addbanners`
--
INSERT INTO `addbanners` (`id`, `add_link`, `add_image`, `status`, `created_at`, `updated_at`) VALUES
(1, 'adads', 'public/images/addbanner/1662807006_DjWx5F5RsAa5AdYecJNZEFKnMi85D3DhZKQVZdfV.jpeg', 'Active', '2022-06-11 11:18:46', '2023-01-23 00:16:41'),
(2, 'http://localhost/ayebazar/', 'public/images/addbanner/1662806959_VidsR9T1K1RIMLA6RsPaheKq8m8UyeKHqHG9EFEX.jpeg', 'Active', '2022-06-11 11:18:46', '2023-01-23 00:16:45'),
(3, 'http://localhost/ayebazar/', 'public/images/addbanner/1662806969_6vwAQiK1GTQzOuGF4BbaKMnfUjH2jZbZNXuGHcg7.jpeg', 'Active', '2022-06-11 11:18:46', '2023-01-23 00:16:48'),
(4, 'http://localhost/ayebazar/', 'public/images/addbanner/1662806980_mrk0XIL2iXt7TPbwicn9YNwJK1RJot0EJ1MNKWBz.jpeg', 'Active', '2022-06-11 11:18:46', '2023-01-23 00:16:53');
-- --------------------------------------------------------
--
-- Table structure for table `admins`
--
CREATE TABLE `admins` (
`id` bigint(20) UNSIGNED NOT NULL,
`name` varchar(255) NOT NULL,
`phone` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`email_verified_at` timestamp NULL DEFAULT NULL,
`password` varchar(255) NOT NULL,
`status` varchar(255) NOT NULL DEFAULT 'Active',
`remember_token` varchar(100) 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 `admins`
--
INSERT INTO `admins` (`id`, `name`, `phone`, `email`, `email_verified_at`, `password`, `status`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'admin', '01611331621', 'admin@gmail.com', NULL, '$2y$10$9iiWFhqrSm4iuXfLh.5wo.1JBKEI1opUOHhrChbDKSMZ3xvoHekD.', 'Active', NULL, NULL, '2026-08-25 06:20:01'),
(5, 'Manager', '01545821458', 'manager@gmail.com', NULL, '$2y$12$shtVwvgty630MoeFScN2jebaiyINWWauGug2MrUIbJ1l6vFGIaPCu', 'Active', NULL, '2022-12-14 01:07:08', '2023-01-11 01:13:28'),
(6, 'md sohel', '01956850185', 'sohelranajhe2002@gmail.com', NULL, '$2y$12$29mpeI/xPz8FqgcC3ukL2O.kHv4i4aSR4OQEHzzrB2Mb4NVVHLVSa', 'Active', NULL, '2023-06-20 01:52:26', '2023-06-20 01:52:26');
-- --------------------------------------------------------
--
-- Table structure for table `attributes`
--
CREATE TABLE `attributes` (
`id` bigint(20) UNSIGNED NOT NULL,
`attribute_name` text DEFAULT NULL,
`status` varchar(255) NOT NULL DEFAULT 'Active',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `attributes`
--
INSERT INTO `attributes` (`id`, `attribute_name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Weight', 'Inactive', '2022-06-12 04:09:25', '2022-10-27 10:38:44'),
(2, 'Size', 'Active', '2022-06-12 04:09:32', '2026-08-18 03:25:30'),
(3, 'Colour', 'Active', '2022-06-13 11:18:47', '2022-06-13 11:18:47');
-- --------------------------------------------------------
--
-- Table structure for table `attrvalues`
--
CREATE TABLE `attrvalues` (
`id` bigint(20) UNSIGNED NOT NULL,
`attribute_id` bigint(20) UNSIGNED NOT NULL,
`attribute_name` text DEFAULT NULL,
`value` varchar(255) DEFAULT NULL,
`status` varchar(255) NOT NULL DEFAULT 'Active',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `attrvalues`
--
INSERT INTO `attrvalues` (`id`, `attribute_id`, `attribute_name`, `value`, `status`, `created_at`, `updated_at`) VALUES
(2, 2, 'Size', 'XL', 'Active', '2022-06-12 05:22:20', '2022-10-17 02:18:35'),
(3, 1, 'Weight', '350gm', 'Active', '2022-06-12 05:22:25', '2022-10-17 02:18:28'),
(4, 3, 'Colour', 'Red', 'Active', '2022-06-13 11:19:10', '2022-06-13 11:19:10'),
(5, 3, 'Colour', 'Black', 'Active', '2022-06-13 11:19:19', '2022-06-13 11:19:19'),
(6, 2, 'Size', 'XXL', 'Active', '2022-10-17 03:45:09', '2022-10-17 03:45:09'),
(7, 2, 'Size', 'XXXL', 'Active', '2022-10-17 03:45:16', '2022-10-17 03:45:16'),
(8, 3, 'Colour', 'Green', 'Active', '2022-10-27 10:44:38', '2022-10-27 10:44:38'),
(9, 2, 'Size', 'M', 'Active', '2022-11-04 22:46:01', '2022-11-04 22:46:01'),
(10, 2, 'Size', 'L', 'Active', '2022-11-04 22:46:11', '2022-11-04 22:46:11'),
(11, 2, 'Size', '34', 'Active', '2026-08-18 03:26:20', '2026-08-18 03:26:20'),
(12, 2, 'Size', '36', 'Active', '2026-08-18 03:26:28', '2026-08-18 03:26:28'),
(13, 2, 'Size', '38', 'Active', '2026-08-18 03:26:33', '2026-08-18 03:26:33'),
(14, 2, 'Size', '40', 'Active', '2026-08-18 03:26:37', '2026-08-18 03:26:37'),
(15, 2, 'Size', '42', 'Active', '2026-08-18 03:26:41', '2026-08-18 03:26:41'),
(16, 2, 'Size', '44', 'Active', '2026-08-18 03:26:48', '2026-08-18 03:26:48'),
(17, 2, 'Size', '46', 'Active', '2026-08-18 03:26:52', '2026-08-18 03:26:52');
-- --------------------------------------------------------
--
-- Table structure for table `basicinfos`
--
CREATE TABLE `basicinfos` (
`id` bigint(20) UNSIGNED NOT NULL,
`usd_rate` float(10,2) DEFAULT 0.00,
`phone_one` varchar(255) DEFAULT NULL,
`phone_two` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`logo` text DEFAULT NULL,
`address` text DEFAULT NULL,
`facebook_pixel` text DEFAULT NULL,
`google_analytics` text DEFAULT NULL,
`marquee_text` longtext DEFAULT NULL,
`chat_box` text DEFAULT NULL,
`inside_dhaka_charge` varchar(255) DEFAULT NULL,
`outside_dhaka_charge` varchar(255) DEFAULT NULL,
`insie_dhaka` varchar(255) DEFAULT NULL,
`outside_dhaka` varchar(255) DEFAULT NULL,
`cash_on_delivery` varchar(255) DEFAULT NULL,
`refund_rule` varchar(255) DEFAULT NULL,
`contact` varchar(255) DEFAULT NULL,
`facebook` varchar(255) DEFAULT NULL,
`twitter` varchar(255) DEFAULT NULL,
`google` varchar(255) DEFAULT NULL,
`rss` varchar(255) DEFAULT NULL,
`pinterest` varchar(255) DEFAULT NULL,
`linkedin` varchar(255) DEFAULT NULL,
`youtube` varchar(255) DEFAULT NULL,
`service_payment_status` varchar(255) NOT NULL DEFAULT 'Itstation',
`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 `basicinfos`
--
INSERT INTO `basicinfos` (`id`, `usd_rate`, `phone_one`, `phone_two`, `email`, `logo`, `address`, `facebook_pixel`, `google_analytics`, `marquee_text`, `chat_box`, `inside_dhaka_charge`, `outside_dhaka_charge`, `insie_dhaka`, `outside_dhaka`, `cash_on_delivery`, `refund_rule`, `contact`, `facebook`, `twitter`, `google`, `rss`, `pinterest`, `linkedin`, `youtube`, `service_payment_status`, `created_at`, `updated_at`) VALUES
(1, 99.00, '01911331621', '01781600488', 'support@skdealbd.com', 'public/images/categorybanner/1686121953_skdeal.jpg', 'Biswas Builders New market, City Complex, Level-1, Shop 123 Dhaka 1205', '\r\n\r\n![]()
\r\n', '\r\n\r\n\r\n\r\n\r\n\r\n