text: -- phpMyAdmin SQL Dump
  -- version 5.1.1
  -- https://www.phpmyadmin.net/
  --
  -- Máy chủ: 127.0.0.1
  -- Thời gian đã tạo: Th1 12, 2022 lúc 02:04 PM
  -- Phiên bản máy phục vụ: 10.4.22-MariaDB
  -- Phiên bản PHP: 7.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 */;
  
  --
  -- Cơ sở dữ liệu: `maihanperfume`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `failed_jobs`
  --
  
  CREATE TABLE `failed_jobs` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `uuid` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
    `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
    `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `jobs`
  --
  
  CREATE TABLE `jobs` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `queue` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
    `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
    `attempts` tinyint(3) UNSIGNED NOT NULL,
    `reserved_at` int(10) UNSIGNED DEFAULT NULL,
    `available_at` int(10) UNSIGNED NOT NULL,
    `created_at` int(10) UNSIGNED NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `migrations`
  --
  
  CREATE TABLE `migrations` (
    `id` int(10) UNSIGNED NOT NULL,
    `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `batch` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `migrations`
  --
  
  INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
  (1, '2020_00_00_step1_create_tables_admin', 1),
  (2, '2020_00_00_step2_create_tables_shop', 2);
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `oauth_access_tokens`
  --
  
  CREATE TABLE `oauth_access_tokens` (
    `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `user_id` bigint(20) UNSIGNED DEFAULT NULL,
    `client_id` bigint(20) UNSIGNED NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `scopes` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `revoked` tinyint(1) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `expires_at` datetime DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `oauth_auth_codes`
  --
  
  CREATE TABLE `oauth_auth_codes` (
    `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `user_id` bigint(20) UNSIGNED NOT NULL,
    `client_id` bigint(20) UNSIGNED NOT NULL,
    `scopes` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `revoked` tinyint(1) NOT NULL,
    `expires_at` datetime DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `oauth_clients`
  --
  
  CREATE TABLE `oauth_clients` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `user_id` bigint(20) UNSIGNED DEFAULT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `secret` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `provider` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `redirect` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `personal_access_client` tinyint(1) NOT NULL,
    `password_client` tinyint(1) NOT NULL,
    `revoked` tinyint(1) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `oauth_clients`
  --
  
  INSERT INTO `oauth_clients` (`id`, `user_id`, `name`, `secret`, `provider`, `redirect`, `personal_access_client`, `password_client`, `revoked`, `created_at`, `updated_at`) VALUES
  (1, NULL, 'SCart Personal Access Client', 'xbbXuZP1q16KQSib7lMO1t5X5ZK6862srbLzzCj7', NULL, 'http://localhost', 1, 0, 0, '2022-01-12 13:04:07', '2022-01-12 13:04:07'),
  (2, NULL, 'SCart Password Grant Client', 'E278Mh8avrmFlmOMIN9p2PnuFP0mEqmAAHWUiWVG', 'users', 'http://localhost', 0, 1, 0, '2022-01-12 13:04:07', '2022-01-12 13:04:07');
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `oauth_personal_access_clients`
  --
  
  CREATE TABLE `oauth_personal_access_clients` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `client_id` bigint(20) UNSIGNED NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `oauth_personal_access_clients`
  --
  
  INSERT INTO `oauth_personal_access_clients` (`id`, `client_id`, `created_at`, `updated_at`) VALUES
  (1, 1, '2022-01-12 13:04:07', '2022-01-12 13:04:07');
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `oauth_refresh_tokens`
  --
  
  CREATE TABLE `oauth_refresh_tokens` (
    `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `access_token_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `revoked` tinyint(1) NOT NULL,
    `expires_at` datetime DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_admin_config`
  --
  
  CREATE TABLE `sc_admin_config` (
    `id` int(10) UNSIGNED NOT NULL,
    `group` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `code` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `key` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `value` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `store_id` int(11) NOT NULL DEFAULT 0,
    `sort` int(11) NOT NULL DEFAULT 0,
    `detail` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_admin_config`
  --
  
  INSERT INTO `sc_admin_config` (`id`, `group`, `code`, `key`, `value`, `store_id`, `sort`, `detail`) VALUES
  (1, 'Plugins', 'Payment', 'Cash', '1', 0, 0, 'Plugins/Payment/Cash::lang.title'),
  (2, 'Plugins', 'Shipping', 'ShippingStandard', '1', 0, 0, 'lang::Shipping Standard'),
  (3, 'global', 'env_global', 'ADMIN_LOG', 'on', 0, 0, 'lang::env.ADMIN_LOG'),
  (4, 'global', 'env_global', 'ADMIN_LOG_EXP', '', 0, 0, 'lang::env.ADMIN_LOG_EXP'),
  (5, 'global', 'env_global', 'ADMIN_FOOTER_OFF', '0', 0, 0, 'lang::env.ADMIN_FOOTER_OFF'),
  (6, 'global', 'seo_config', 'url_seo_lang', '0', 0, 1, 'lang::seo.url_seo_lang'),
  (7, 'global', 'webhook_config', 'LOG_SLACK_WEBHOOK_URL', '', 0, 0, 'lang::config.LOG_SLACK_WEBHOOK_URL'),
  (8, 'global', 'webhook_config', 'GOOGLE_CHAT_WEBHOOK_URL', '', 0, 0, 'lang::config.GOOGLE_CHAT_WEBHOOK_URL'),
  (9, 'global', 'webhook_config', 'CHATWORK_CHAT_WEBHOOK_URL', '', 0, 0, 'lang::config.CHATWORK_CHAT_WEBHOOK_URL'),
  (10, 'global', 'api_config', 'api_connection_required', '1', 0, 1, 'lang::api_connection.api_connection_required'),
  (11, 'global', 'cache', 'cache_status', '0', 0, 0, 'lang::cache.config_manager.cache_status'),
  (12, 'global', 'cache', 'cache_time', '600', 0, 0, 'lang::cache.config_manager.cache_time'),
  (13, 'global', 'cache', 'cache_category', '0', 0, 3, 'lang::cache.config_manager.cache_category'),
  (14, 'global', 'cache', 'cache_product', '0', 0, 4, 'lang::cache.config_manager.cache_product'),
  (15, 'global', 'cache', 'cache_news', '0', 0, 5, 'lang::cache.config_manager.cache_news'),
  (16, 'global', 'cache', 'cache_category_cms', '0', 0, 6, 'lang::cache.config_manager.cache_category_cms'),
  (17, 'global', 'cache', 'cache_content_cms', '0', 0, 7, 'lang::cache.config_manager.cache_content_cms'),
  (18, 'global', 'cache', 'cache_page', '0', 0, 8, 'lang::cache.config_manager.cache_page'),
  (19, 'global', 'cache', 'cache_country', '0', 0, 10, 'lang::cache.config_manager.cache_country'),
  (20, 'global', 'env_mail', 'smtp_mode', '', 0, 0, 'lang::email.smtp_mode'),
  (21, '', 'product_config_attribute', 'product_brand', '1', 1, 0, 'lang::product.config_manager.brand'),
  (22, '', 'product_config_attribute_required', 'product_brand_required', '0', 1, 0, ''),
  (23, '', 'product_config_attribute', 'product_supplier', '1', 1, 0, 'lang::product.config_manager.supplier'),
  (24, '', 'product_config_attribute_required', 'product_supplier_required', '0', 1, 0, ''),
  (25, '', 'product_config_attribute', 'product_price', '1', 1, 0, 'lang::product.config_manager.price'),
  (26, '', 'product_config_attribute_required', 'product_price_required', '1', 1, 0, ''),
  (27, '', 'product_config_attribute', 'product_cost', '1', 1, 0, 'lang::product.config_manager.cost'),
  (28, '', 'product_config_attribute_required', 'product_cost_required', '0', 1, 0, ''),
  (29, '', 'product_config_attribute', 'product_promotion', '1', 1, 0, 'lang::product.config_manager.promotion'),
  (30, '', 'product_config_attribute_required', 'product_promotion_required', '0', 1, 0, ''),
  (31, '', 'product_config_attribute', 'product_stock', '1', 1, 0, 'lang::product.config_manager.stock'),
  (32, '', 'product_config_attribute_required', 'product_stock_required', '0', 1, 0, ''),
  (33, '', 'product_config_attribute', 'product_kind', '1', 1, 0, 'lang::product.config_manager.kind'),
  (34, '', 'product_config_attribute', 'product_property', '1', 1, 0, 'lang::product.config_manager.property'),
  (35, '', 'product_config_attribute_required', 'product_property_required', '0', 1, 0, ''),
  (36, '', 'product_config_attribute', 'product_attribute', '1', 1, 0, 'lang::product.config_manager.attribute'),
  (37, '', 'product_config_attribute_required', 'product_attribute_required', '0', 1, 0, ''),
  (38, '', 'product_config_attribute', 'product_available', '1', 1, 0, 'lang::product.config_manager.available'),
  (39, '', 'product_config_attribute_required', 'product_available_required', '0', 1, 0, ''),
  (40, '', 'product_config_attribute', 'product_weight', '1', 1, 0, 'lang::product.config_manager.weight'),
  (41, '', 'product_config_attribute_required', 'product_weight_required', '0', 1, 0, ''),
  (42, '', 'product_config_attribute', 'product_length', '1', 1, 0, 'lang::product.config_manager.length'),
  (43, '', 'product_config_attribute_required', 'product_length_required', '0', 1, 0, ''),
  (44, '', 'product_config', 'product_display_out_of_stock', '1', 1, 19, 'lang::admin.product_display_out_of_stock'),
  (45, '', 'product_config', 'show_date_available', '1', 1, 21, 'lang::admin.show_date_available'),
  (46, '', 'product_config', 'product_tax', '1', 1, 0, 'lang::product.config_manager.tax'),
  (47, '', 'customer_config_attribute', 'customer_lastname', '1', 1, 1, 'lang::customer.config_manager.lastname'),
  (48, '', 'customer_config_attribute_required', 'customer_lastname_required', '1', 1, 1, ''),
  (49, '', 'customer_config_attribute', 'customer_address1', '1', 1, 2, 'lang::customer.config_manager.address1'),
  (50, '', 'customer_config_attribute_required', 'customer_address1_required', '1', 1, 2, ''),
  (51, '', 'customer_config_attribute', 'customer_address2', '1', 1, 2, 'lang::customer.config_manager.address2'),
  (52, '', 'customer_config_attribute_required', 'customer_address2_required', '1', 1, 2, ''),
  (53, '', 'customer_config_attribute', 'customer_address3', '0', 1, 2, 'lang::customer.config_manager.address3'),
  (54, '', 'customer_config_attribute_required', 'customer_address3_required', '0', 1, 2, ''),
  (55, '', 'customer_config_attribute', 'customer_company', '0', 1, 0, 'lang::customer.config_manager.company'),
  (56, '', 'customer_config_attribute_required', 'customer_company_required', '0', 1, 0, ''),
  (57, '', 'customer_config_attribute', 'customer_postcode', '0', 1, 0, 'lang::customer.config_manager.postcode'),
  (58, '', 'customer_config_attribute_required', 'customer_postcode_required', '0', 1, 0, ''),
  (59, '', 'customer_config_attribute', 'customer_country', '1', 1, 0, 'lang::customer.config_manager.country'),
  (60, '', 'customer_config_attribute_required', 'customer_country_required', '1', 1, 0, ''),
  (61, '', 'customer_config_attribute', 'customer_group', '0', 1, 0, 'lang::customer.config_manager.group'),
  (62, '', 'customer_config_attribute_required', 'customer_group_required', '0', 1, 0, ''),
  (63, '', 'customer_config_attribute', 'customer_birthday', '0', 1, 0, 'lang::customer.config_manager.birthday'),
  (64, '', 'customer_config_attribute_required', 'customer_birthday_required', '0', 1, 0, ''),
  (65, '', 'customer_config_attribute', 'customer_sex', '0', 1, 0, 'lang::customer.config_manager.sex'),
  (66, '', 'customer_config_attribute_required', 'customer_sex_required', '0', 1, 0, ''),
  (67, '', 'customer_config_attribute', 'customer_phone', '1', 1, 0, 'lang::customer.config_manager.phone'),
  (68, '', 'customer_config_attribute_required', 'customer_phone_required', '1', 1, 1, ''),
  (69, '', 'customer_config_attribute', 'customer_name_kana', '0', 1, 0, 'lang::customer.config_manager.name_kana'),
  (70, '', 'customer_config_attribute_required', 'customer_name_kana_required', '0', 1, 1, ''),
  (71, '', 'admin_config', 'ADMIN_NAME', 'S-Cart System', 1, 0, 'lang::env.ADMIN_NAME'),
  (72, '', 'admin_config', 'ADMIN_TITLE', 'S-Cart Admin', 1, 0, 'lang::env.ADMIN_TITLE'),
  (73, '', 'admin_config', 'ADMIN_LOGO', 'S-Cart Admin', 1, 0, 'lang::env.ADMIN_LOGO'),
  (74, '', 'display_config', 'product_top', '8', 1, 0, 'lang::admin.product_top'),
  (75, '', 'display_config', 'product_list', '12', 1, 0, 'lang::admin.list_product'),
  (76, '', 'display_config', 'product_relation', '4', 1, 0, 'lang::admin.relation_product'),
  (77, '', 'display_config', 'product_viewed', '4', 1, 0, 'lang::admin.viewed_product'),
  (78, '', 'display_config', 'item_list', '12', 1, 0, 'lang::admin.item_list'),
  (79, '', 'display_config', 'item_top', '8', 1, 0, 'lang::admin.item_top'),
  (80, '', 'order_config', 'shop_allow_guest', '1', 1, 11, 'lang::order.admin.shop_allow_guest'),
  (81, '', 'order_config', 'product_preorder', '1', 1, 18, 'lang::order.admin.product_preorder'),
  (82, '', 'order_config', 'product_buy_out_of_stock', '1', 1, 20, 'lang::order.admin.product_buy_out_of_stock'),
  (83, '', 'order_config', 'shipping_off', '0', 1, 20, 'lang::order.admin.shipping_off'),
  (84, '', 'order_config', 'payment_off', '0', 1, 20, 'lang::order.admin.payment_off'),
  (85, '', 'email_action', 'email_action_mode', '0', 1, 0, 'lang::email.email_action.email_action_mode'),
  (86, '', 'email_action', 'email_action_queue', '0', 1, 1, 'lang::email.email_action.email_action_queue'),
  (87, '', 'email_action', 'order_success_to_admin', '0', 1, 1, 'lang::email.email_action.order_success_to_admin'),
  (88, '', 'email_action', 'order_success_to_customer', '0', 1, 2, 'lang::email.email_action.order_success_to_cutomer'),
  (89, '', 'email_action', 'order_success_to_customer_pdf', '0', 1, 3, 'lang::email.email_action.order_success_to_cutomer_pdf'),
  (90, '', 'email_action', 'customer_verify', '0', 1, 4, 'lang::email.email_action.customer_verify'),
  (91, '', 'email_action', 'welcome_customer', '0', 1, 4, 'lang::email.email_action.welcome_customer'),
  (92, '', 'email_action', 'contact_to_admin', '1', 1, 6, 'lang::email.email_action.contact_to_admin'),
  (93, '', 'smtp_config', 'smtp_host', '', 1, 1, 'lang::email.smtp_host'),
  (94, '', 'smtp_config', 'smtp_user', '', 1, 2, 'lang::email.smtp_user'),
  (95, '', 'smtp_config', 'smtp_password', '', 1, 3, 'lang::email.smtp_password'),
  (96, '', 'smtp_config', 'smtp_security', '', 1, 4, 'lang::email.smtp_security'),
  (97, '', 'smtp_config', 'smtp_port', '', 1, 5, 'lang::email.smtp_port'),
  (98, '', 'smtp_config', 'smtp_name', '', 1, 6, 'lang::email.smtp_name'),
  (99, '', 'smtp_config', 'smtp_from', '', 1, 7, 'lang::email.smtp_from'),
  (100, '', 'url_config', 'SUFFIX_URL', '.html', 1, 0, 'lang::url.SUFFIX_URL'),
  (101, '', 'url_config', 'PREFIX_SHOP', 'shop', 1, 0, 'lang::env.PREFIX_SHOP'),
  (102, '', 'url_config', 'PREFIX_BRAND', 'brand', 1, 0, 'lang::env.PREFIX_BRAND'),
  (103, '', 'url_config', 'PREFIX_CATEGORY', 'category', 1, 0, 'lang::env.PREFIX_CATEGORY'),
  (104, '', 'url_config', 'PREFIX_SUB_CATEGORY', 'sub-category', 1, 0, 'lang::env.PREFIX_SUB_CATEGORY'),
  (105, '', 'url_config', 'PREFIX_PRODUCT', 'product', 1, 0, 'lang::env.PREFIX_PRODUCT'),
  (106, '', 'url_config', 'PREFIX_SEARCH', 'search', 1, 0, 'lang::env.PREFIX_SEARCH'),
  (107, '', 'url_config', 'PREFIX_CONTACT', 'contact', 1, 0, 'lang::env.PREFIX_CONTACT'),
  (108, '', 'url_config', 'PREFIX_NEWS', 'news', 1, 0, 'lang::env.PREFIX_NEWS'),
  (109, '', 'url_config', 'PREFIX_MEMBER', 'customer', 1, 0, 'lang::env.PREFIX_MEMBER'),
  (110, '', 'url_config', 'PREFIX_MEMBER_ORDER_LIST', 'order-list', 1, 0, 'lang::env.PREFIX_MEMBER_ORDER_LIST'),
  (111, '', 'url_config', 'PREFIX_MEMBER_CHANGE_PWD', 'change-password', 1, 0, 'lang::env.PREFIX_MEMBER_CHANGE_PWD'),
  (112, '', 'url_config', 'PREFIX_MEMBER_CHANGE_INFO', 'change-info', 1, 0, 'lang::env.PREFIX_MEMBER_CHANGE_INFO'),
  (113, '', 'url_config', 'PREFIX_CMS_CATEGORY', 'cms-category', 1, 0, 'lang::env.PREFIX_CMS_CATEGORY'),
  (114, '', 'url_config', 'PREFIX_CMS_ENTRY', 'entry', 1, 0, 'lang::env.PREFIX_CMS_ENTRY'),
  (115, '', 'url_config', 'PREFIX_CART_WISHLIST', 'wishlst', 1, 0, 'lang::env.PREFIX_CART_WISHLIST'),
  (116, '', 'url_config', 'PREFIX_CART_COMPARE', 'compare', 1, 0, 'lang::env.PREFIX_CART_COMPARE'),
  (117, '', 'url_config', 'PREFIX_CART_DEFAULT', 'cart', 1, 0, 'lang::env.PREFIX_CART_DEFAULT'),
  (118, '', 'url_config', 'PREFIX_CART_CHECKOUT', 'checkout', 1, 0, 'lang::env.PREFIX_CART_CHECKOUT'),
  (119, '', 'url_config', 'PREFIX_ORDER_SUCCESS', 'order-success', 1, 0, 'lang::env.PREFIX_ORDER_SUCCESS'),
  (120, '', 'captcha_config', 'captcha_mode', '0', 1, 20, 'lang::captcha.captcha_mode'),
  (121, '', 'captcha_config', 'captcha_page', '[]', 1, 10, 'lang::captcha.captcha_page'),
  (122, '', 'captcha_config', 'captcha_method', '', 1, 0, 'lang::captcha.captcha_method');
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_admin_log`
  --
  
  CREATE TABLE `sc_admin_log` (
    `id` int(10) UNSIGNED NOT NULL,
    `user_id` int(11) NOT NULL,
    `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `method` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
    `ip` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `user_agent` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `input` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_admin_log`
  --
  
  INSERT INTO `sc_admin_log` (`id`, `user_id`, `path`, `method`, `ip`, `user_agent`, `input`, `created_at`, `updated_at`) VALUES
  (1, 1, 'sc_admin', 'GET', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/97.0.4692.71 Safari/537.36', '[]', '2022-01-12 13:04:20', '2022-01-12 13:04:20');
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_admin_menu`
  --
  
  CREATE TABLE `sc_admin_menu` (
    `id` int(10) UNSIGNED NOT NULL,
    `parent_id` int(11) NOT NULL DEFAULT 0,
    `sort` int(11) NOT NULL DEFAULT 0,
    `title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `icon` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `uri` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `type` int(11) NOT NULL DEFAULT 0,
    `hidden` int(11) NOT NULL DEFAULT 0,
    `key` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_admin_menu`
  --
  
  INSERT INTO `sc_admin_menu` (`id`, `parent_id`, `sort`, `title`, `icon`, `uri`, `type`, `hidden`, `key`, `created_at`, `updated_at`) VALUES
  (1, 6, 1, 'lang::admin.menu_titles.order_manager', 'fas fa-cart-arrow-down', '', 0, 0, 'ORDER_MANAGER', NULL, NULL),
  (2, 6, 2, 'lang::admin.menu_titles.catalog_mamager', 'fas fa-folder-open', '', 0, 0, 'CATALOG_MANAGER', NULL, NULL),
  (3, 25, 3, 'lang::admin.menu_titles.customer_manager', 'fas fa-users', '', 0, 0, 'CUSTOMER_MANAGER', NULL, NULL),
  (4, 8, 201, 'lang::admin.menu_titles.template_layout', 'fab fa-windows', '', 0, 0, 'TEMPLATE', NULL, NULL),
  (5, 9, 2, 'lang::admin.menu_titles.admin_global', 'fab fa-whmcs', '', 0, 0, 'CONFIG_SYSTEM', NULL, NULL),
  (6, 0, 10, 'lang::admin.menu_titles.ADMIN_SHOP', 'fab fa-shopify', '', 0, 0, 'ADMIN_SHOP', NULL, NULL),
  (7, 0, 100, 'lang::admin.menu_titles.ADMIN_CONTENT', 'fas fa-file-signature', '', 0, 0, 'ADMIN_CONTENT', NULL, NULL),
  (8, 0, 300, 'lang::admin.menu_titles.ADMIN_EXTENSION', 'fas fa-th', '', 0, 0, 'ADMIN_EXTENSION', NULL, NULL),
  (9, 0, 400, 'lang::admin.menu_titles.ADMIN_SYSTEM', 'fas fa-cogs', '', 0, 0, 'ADMIN_SYSTEM', NULL, NULL),
  (10, 7, 102, 'lang::page.admin.title', 'fas fa-clone', 'admin::page', 0, 0, NULL, NULL, NULL),
  (11, 27, 2, 'lang::shipping_status.admin.title', 'fas fa-truck', 'admin::shipping_status', 0, 0, NULL, NULL, NULL),
  (12, 1, 3, 'lang::order.admin.title', 'fas fa-shopping-cart', 'admin::order', 0, 0, NULL, NULL, NULL),
  (13, 27, 1, 'lang::order_status.admin.title', 'fas fa-asterisk', 'admin::order_status', 0, 0, NULL, NULL, NULL),
  (14, 27, 3, 'lang::payment_status.admin.title', 'fas fa-recycle', 'admin::payment_status', 0, 0, NULL, NULL, NULL),
  (15, 2, 0, 'lang::product.admin.title', 'far fa-file-image', 'admin::product', 0, 0, NULL, NULL, NULL),
  (16, 2, 0, 'lang::category.admin.title', 'fas fa-folder-open', 'admin::category', 0, 0, NULL, NULL, NULL),
  (17, 27, 4, 'lang::supplier.admin.title', 'fas fa-user-secret', 'admin::supplier', 0, 0, NULL, NULL, NULL),
  (18, 27, 5, 'lang::brand.admin.title', 'fas fa-university', 'admin::brand', 0, 0, NULL, NULL, NULL),
  (19, 27, 8, 'lang::attribute_group.admin.title', 'fas fa-bars', 'admin::attribute_group', 0, 0, NULL, NULL, NULL),
  (20, 3, 0, 'lang::customer.admin.title', 'fas fa-user', 'admin::customer', 0, 0, NULL, NULL, NULL),
  (21, 3, 0, 'lang::subscribe.admin.title', 'fas fa-user-circle', 'admin::subscribe', 0, 0, NULL, NULL, NULL),
  (22, 67, 1, 'lang::store_block.admin.title', 'far fa-newspaper', 'admin::store_block', 0, 0, NULL, NULL, NULL),
  (23, 67, 2, 'lang::admin.menu_titles.block_link', 'fab fa-chrome', 'admin::store_link', 0, 0, NULL, NULL, NULL),
  (24, 4, 0, 'lang::admin.menu_titles.template_manager', 'fas fa-columns', 'admin::template', 0, 0, NULL, NULL, NULL),
  (25, 0, 200, 'lang::admin.menu_titles.ADMIN_MARKETING', 'fas fa-sort-amount-up', '', 0, 0, 'MARKETING', NULL, NULL),
  (26, 65, 1, 'lang::store.admin.title', 'fas fa-h-square', 'admin::store_info', 0, 0, NULL, NULL, NULL),
  (27, 9, 3, 'lang::admin.menu_titles.setting_system', 'fas fa-tools', '', 0, 0, 'SETTING_SYSTEM', NULL, NULL),
  (28, 9, 4, 'lang::admin.menu_titles.error_log', 'far fa-clone', '', 0, 0, '', NULL, NULL),
  (29, 25, 0, 'lang::email_template.admin.title', 'fas fa-bars', 'admin::email_template', 0, 0, NULL, NULL, NULL),
  (30, 9, 5, 'lang::admin.menu_titles.localisation', 'fab fa-shirtsinbulk', '', 0, 0, NULL, NULL, NULL),
  (31, 30, 0, 'lang::language.admin.title', 'fas fa-language', 'admin::language', 0, 0, NULL, NULL, NULL),
  (32, 30, 0, 'lang::currency.admin.title', 'far fa-money-bill-alt', 'admin::currency', 0, 0, NULL, NULL, NULL),
  (33, 7, 101, 'lang::banner.admin.title', 'fas fa-image', 'admin::banner', 0, 0, NULL, NULL, NULL),
  (34, 5, 5, 'lang::backup.admin.title', 'fas fa-save', 'admin::backup', 0, 0, NULL, NULL, NULL),
  (35, 8, 202, 'lang::admin.menu_titles.plugins', 'fas fa-puzzle-piece', '', 0, 0, 'PLUGIN', NULL, NULL),
  (36, 28, 2, 'lang::admin.menu_titles.webhook', 'fab fa-diaspora', 'admin::config/webhook', 0, 0, NULL, NULL, NULL),
  (37, 25, 5, 'lang::admin.menu_titles.report_manager', 'fas fa-chart-pie', '', 0, 0, 'REPORT_MANAGER', NULL, NULL),
  (38, 9, 1, 'lang::admin.menu_titles.user_permission', 'fas fa-users-cog', '', 0, 0, 'ADMIN', NULL, NULL),
  (39, 35, 0, 'plugin.Payment', 'far fa-money-bill-alt', 'admin::plugin/payment', 0, 0, NULL, NULL, NULL),
  (40, 35, 0, 'plugin.Shipping', 'fas fa-ambulance', 'admin::plugin/shipping', 0, 0, NULL, NULL, NULL),
  (41, 35, 0, 'plugin.Total', 'fas fa-cog', 'admin::plugin/total', 0, 0, NULL, NULL, NULL),
  (42, 35, 100, 'plugin.Other', 'far fa-circle', 'admin::plugin/other', 0, 0, NULL, NULL, NULL),
  (43, 35, 0, 'plugin.Cms', 'fab fa-modx', 'admin::plugin/cms', 0, 0, NULL, NULL, NULL),
  (44, 67, 2, 'lang::admin.menu_titles.css', 'far fa-file-code', 'admin::store_css', 0, 0, NULL, NULL, NULL),
  (45, 25, 4, 'lang::admin.menu_titles.seo_manager', 'fab fa-battle-net', '', 0, 0, 'SEO_MANAGER', NULL, NULL),
  (46, 38, 0, 'lang::admin.menu_titles.users', 'fas fa-users', 'admin::user', 0, 0, NULL, NULL, NULL),
  (47, 38, 0, 'lang::admin.menu_titles.roles', 'fas fa-user-tag', 'admin::role', 0, 0, NULL, NULL, NULL),
  (48, 38, 0, 'lang::admin.menu_titles.permission', 'fas fa-ban', 'admin::permission', 0, 0, NULL, NULL, NULL),
  (49, 5, 0, 'lang::admin.menu_titles.menu', 'fas fa-bars', 'admin::menu', 0, 0, NULL, NULL, NULL),
  (50, 28, 0, 'lang::admin.menu_titles.operation_log', 'fas fa-history', 'admin::log', 0, 0, NULL, NULL, NULL),
  (51, 45, 0, 'lang::admin.menu_titles.seo_config', 'fas fa-bars', 'admin::seo/config', 0, 0, NULL, NULL, NULL),
  (52, 7, 103, 'lang::news.admin.title', 'far fa-file-powerpoint', 'admin::news', 0, 0, NULL, NULL, NULL),
  (53, 5, 0, 'lang::admin.menu_titles.env_config', 'fas fa-tasks', 'admin::env/config', 0, 0, NULL, NULL, NULL),
  (54, 37, 0, 'lang::admin.menu_titles.report_product', 'fas fa-bars', 'admin::report/product', 0, 0, NULL, NULL, NULL),
  (57, 65, 2, 'lang::admin.menu_titles.store_config', 'fas fa-cog', 'admin::store_config', 0, 0, NULL, NULL, NULL),
  (58, 5, 5, 'lang::admin.menu_titles.cache_manager', 'fab fa-tripadvisor', 'admin::cache_config', 0, 0, NULL, NULL, NULL),
  (59, 9, 7, 'lang::admin.menu_titles.api_manager', 'fas fa-plug', '', 0, 0, 'API_MANAGER', NULL, NULL),
  (60, 65, 3, 'lang::store_maintain.config_manager.title', 'fas fa-wrench', 'admin::store_maintain', 0, 0, NULL, NULL, NULL),
  (61, 27, 9, 'lang::tax.admin.admin_title', 'far fa-calendar-minus', 'admin::tax', 0, 0, NULL, NULL, NULL),
  (62, 27, 6, 'lang::weight.admin.title', 'fas fa-balance-scale', 'admin::weight_unit', 0, 0, NULL, NULL, NULL),
  (63, 27, 7, 'lang::length.admin.title', 'fas fa-minus', 'admin::length_unit', 0, 0, NULL, NULL, NULL),
  (65, 0, 250, 'lang::admin.menu_titles.ADMIN_SHOP_SETTING', 'fas fa-store-alt', '', 0, 0, 'ADMIN_SHOP_SETTING', NULL, NULL),
  (66, 59, 1, 'lang::admin.menu_titles.api_config', 'fas fa fa-cog', 'admin::api_connection', 0, 0, NULL, NULL, NULL),
  (67, 65, 5, 'lang::admin.menu_titles.layout', 'far fa-object-group', '', 0, 0, NULL, NULL, NULL),
  (68, 27, 5, 'lang::custom_field.admin.title', 'fa fa-american-sign-language-interpreting', 'admin::custom_field', 0, 0, NULL, NULL, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_admin_permission`
  --
  
  CREATE TABLE `sc_admin_permission` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `slug` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `http_uri` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_admin_permission`
  --
  
  INSERT INTO `sc_admin_permission` (`id`, `name`, `slug`, `http_uri`, `created_at`, `updated_at`) VALUES
  (1, 'Auth manager', 'auth.full', 'ANY::sc_admin/auth/*', '2022-01-12 13:04:06', NULL),
  (2, 'Dashboard', 'dashboard', 'GET::sc_admin', '2022-01-12 13:04:06', NULL),
  (3, 'Base setting', 'base.setting', 'ANY::sc_admin/order_status/*,ANY::sc_admin/shipping_status/*,ANY::sc_admin/payment_status/*,ANY::sc_admin/supplier/*,ANY::sc_admin/brand/*,ANY::sc_admin/custom_field/*,ANY::sc_admin/weight_unit/*,ANY::sc_admin/length_unit/*,ANY::sc_admin/attribute_group/*,ANY::sc_admin/tax/*', '2022-01-12 13:04:06', NULL),
  (4, 'Store manager', 'store.full', 'ANY::sc_admin/store_info/*,ANY::sc_admin/store_maintain/*,ANY::sc_admin/store_config/*,ANY::sc_admin/store_css/*,ANY::sc_admin/store_block/*,ANY::sc_admin/store_link/*', '2022-01-12 13:04:06', NULL),
  (5, 'Product manager', 'product.full', 'ANY::sc_admin/product/*,ANY::sc_admin/product_property/*,ANY::sc_admin/product_tag/*', '2022-01-12 13:04:06', NULL),
  (6, 'Category manager', 'category.full', 'ANY::sc_admin/category/*', '2022-01-12 13:04:06', NULL),
  (7, 'Order manager', 'order.full', 'ANY::sc_admin/order/*', '2022-01-12 13:04:06', NULL),
  (8, 'Upload management', 'upload.full', 'ANY::sc_admin/uploads/*', '2022-01-12 13:04:06', NULL),
  (9, 'Extension manager', 'extension.full', 'ANY::sc_admin/template/*,ANY::sc_admin/plugin/*', '2022-01-12 13:04:06', NULL),
  (10, 'Marketing manager', 'marketing.full', 'ANY::sc_admin/shop_discount/*,ANY::sc_admin/email_template/*,ANY::sc_admin/customer/*,ANY::sc_admin/subscribe/*,ANY::sc_admin/seo/*', '2022-01-12 13:04:06', NULL),
  (11, 'Report manager', 'report.full', 'ANY::sc_admin/report/*', '2022-01-12 13:04:06', NULL),
  (12, 'CMS manager', 'cms.full', 'ANY::sc_admin/page/*,ANY::sc_admin/banner/*,ANY::sc_admin/banner_type/*, ANY::sc_admin/cms_category/*,ANY::sc_admin/cms_content/*,ANY::sc_admin/news/*', '2022-01-12 13:04:06', NULL),
  (13, 'Update config', 'change.config', 'POST::sc_admin/store_config/update', '2022-01-12 13:04:06', NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_admin_role`
  --
  
  CREATE TABLE `sc_admin_role` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `slug` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_admin_role`
  --
  
  INSERT INTO `sc_admin_role` (`id`, `name`, `slug`, `created_at`, `updated_at`) VALUES
  (1, 'Administrator', 'administrator', '2022-01-12 13:04:06', NULL),
  (2, 'Group only View', 'view.all', '2022-01-12 13:04:06', NULL),
  (3, 'Manager', 'manager', '2022-01-12 13:04:06', NULL),
  (4, 'CMS', 'cms', '2022-01-12 13:04:06', NULL),
  (5, 'Accountant', 'accountant', '2022-01-12 13:04:06', NULL),
  (6, 'Marketing', 'maketing', '2022-01-12 13:04:06', NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_admin_role_permission`
  --
  
  CREATE TABLE `sc_admin_role_permission` (
    `role_id` int(11) NOT NULL,
    `permission_id` int(11) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_admin_role_permission`
  --
  
  INSERT INTO `sc_admin_role_permission` (`role_id`, `permission_id`, `created_at`, `updated_at`) VALUES
  (3, 1, '2022-01-12 13:04:06', NULL),
  (3, 2, '2022-01-12 13:04:06', NULL),
  (3, 3, '2022-01-12 13:04:06', NULL),
  (3, 4, '2022-01-12 13:04:06', NULL),
  (3, 5, '2022-01-12 13:04:06', NULL),
  (3, 6, '2022-01-12 13:04:06', NULL),
  (3, 7, '2022-01-12 13:04:06', NULL),
  (3, 8, '2022-01-12 13:04:06', NULL),
  (3, 9, '2022-01-12 13:04:06', NULL),
  (3, 10, '2022-01-12 13:04:06', NULL),
  (3, 11, '2022-01-12 13:04:06', NULL),
  (3, 12, '2022-01-12 13:04:06', NULL),
  (3, 13, '2022-01-12 13:04:06', NULL),
  (4, 1, '2022-01-12 13:04:06', NULL),
  (4, 12, '2022-01-12 13:04:06', NULL),
  (5, 1, '2022-01-12 13:04:06', NULL),
  (5, 2, '2022-01-12 13:04:06', NULL),
  (5, 7, '2022-01-12 13:04:06', NULL),
  (5, 11, '2022-01-12 13:04:06', NULL),
  (6, 1, '2022-01-12 13:04:06', NULL),
  (6, 2, '2022-01-12 13:04:06', NULL),
  (6, 8, '2022-01-12 13:04:06', NULL),
  (6, 10, '2022-01-12 13:04:06', NULL),
  (6, 11, '2022-01-12 13:04:06', NULL),
  (6, 12, '2022-01-12 13:04:06', NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_admin_role_user`
  --
  
  CREATE TABLE `sc_admin_role_user` (
    `role_id` int(11) NOT NULL,
    `user_id` int(11) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_admin_role_user`
  --
  
  INSERT INTO `sc_admin_role_user` (`role_id`, `user_id`, `created_at`, `updated_at`) VALUES
  (1, 1, NULL, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_admin_store`
  --
  
  CREATE TABLE `sc_admin_store` (
    `id` int(10) UNSIGNED NOT NULL,
    `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `long_phone` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `email` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `time_active` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `address` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `office` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `warehouse` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `template` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `domain` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `partner` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
    `code` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `language` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
    `timezone` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `currency` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
    `status` int(11) NOT NULL DEFAULT 1 COMMENT '0:Lock, 1: unlock',
    `active` int(11) NOT NULL DEFAULT 1 COMMENT '0:Maintain, 1: Active'
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_admin_store`
  --
  
  INSERT INTO `sc_admin_store` (`id`, `logo`, `phone`, `long_phone`, `email`, `time_active`, `address`, `office`, `warehouse`, `template`, `domain`, `partner`, `code`, `language`, `timezone`, `currency`, `status`, `active`) VALUES
  (1, 'data/logo/scart-mid.png', '0123456789', 'Support: 0987654321', 'admin@admin', '', '123st - abc - xyz', NULL, NULL, 's-cart-light', 'localhost/maihanperfume/public', '0', 'root', 'vi', 'Asia/Ho_Chi_Minh', 'USD', 1, 1);
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_admin_store_description`
  --
  
  CREATE TABLE `sc_admin_store_description` (
    `store_id` int(11) NOT NULL,
    `lang` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
    `title` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `description` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `keyword` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `maintain_content` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `maintain_note` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_admin_store_description`
  --
  
  INSERT INTO `sc_admin_store_description` (`store_id`, `lang`, `title`, `description`, `keyword`, `maintain_content`, `maintain_note`) VALUES
  (1, 'en', 'Demo S-Cart : Free Laravel eCommerce', 'Free website shopping cart for business', '', '<center><img src=\"/images/maintenance.png\" />\n    <h3><span style=\"color:#e74c3c;\"><strong>Sorry! We are currently doing site maintenance!</strong></span></h3>\n    </center>', 'Website is in maintenance mode!'),
  (1, 'vi', 'Demo S-Cart: Mã nguồn website thương mại điện tử miễn phí', 'Laravel shopping cart for business', '', '<center><img src=\"/images/maintenance.png\" />\n    <h3><span style=\"color:#e74c3c;\"><strong>Xin lỗi! Hiện tại website đang bảo trì!</strong></span></h3>\n    </center>', 'Website đang trong chế độ bảo trì!');
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_admin_user`
  --
  
  CREATE TABLE `sc_admin_user` (
    `id` int(10) UNSIGNED NOT NULL,
    `username` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `password` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
    `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
    `avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `theme` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_admin_user`
  --
  
  INSERT INTO `sc_admin_user` (`id`, `username`, `password`, `name`, `email`, `avatar`, `remember_token`, `theme`, `created_at`, `updated_at`) VALUES
  (1, 'admin', '$2y$10$j8MoUV9V3/DsStylz5DfoOlAk951GEjZaQQmerGg7gh3NjGFkfJF.', 'Administrator', 'admin@admin', '/admin/avatar/user.jpg', '7sQt5FBxYX87CSMvm418zRuxERdiEpbU4kOO6h4yMzmw3PgIKQ6Y0viyrv1v', NULL, '2022-01-12 13:04:06', NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_admin_user_permission`
  --
  
  CREATE TABLE `sc_admin_user_permission` (
    `user_id` int(11) NOT NULL,
    `permission_id` int(11) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_admin_user_store`
  --
  
  CREATE TABLE `sc_admin_user_store` (
    `user_id` int(11) NOT NULL,
    `store_id` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_api_connection`
  --
  
  CREATE TABLE `sc_api_connection` (
    `id` int(10) UNSIGNED NOT NULL,
    `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `apiconnection` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `apikey` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
    `expire` date DEFAULT NULL,
    `last_active` datetime DEFAULT NULL,
    `status` tinyint(4) NOT NULL DEFAULT 0
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_api_connection`
  --
  
  INSERT INTO `sc_api_connection` (`id`, `description`, `apiconnection`, `apikey`, `expire`, `last_active`, `status`) VALUES
  (1, 'Demo api connection', 'appmobile', '61ded1c682ad7', NULL, NULL, 0);
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_attribute_group`
  --
  
  CREATE TABLE `sc_shop_attribute_group` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `status` tinyint(4) NOT NULL DEFAULT 0,
    `sort` int(11) NOT NULL DEFAULT 0,
    `type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'radio,select,checkbox'
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_shop_attribute_group`
  --
  
  INSERT INTO `sc_shop_attribute_group` (`id`, `name`, `status`, `sort`, `type`) VALUES
  (1, 'Color', 1, 1, 'radio'),
  (2, 'Size', 1, 2, 'select');
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_banner`
  --
  
  CREATE TABLE `sc_shop_banner` (
    `id` int(10) UNSIGNED NOT NULL,
    `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `url` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `target` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `html` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `status` tinyint(4) NOT NULL DEFAULT 0,
    `sort` int(11) NOT NULL DEFAULT 0,
    `click` int(11) NOT NULL DEFAULT 0,
    `type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
    `store_id` int(11) NOT NULL DEFAULT 1,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_shop_banner`
  --
  
  INSERT INTO `sc_shop_banner` (`id`, `title`, `image`, `url`, `target`, `html`, `status`, `sort`, `click`, `type`, `store_id`, `created_at`, `updated_at`) VALUES
  (1, 'Banner 1', '/data/banner/Main-banner-1-1903x600.jpg', NULL, '_self', '<h1 class=\"swiper-title-1\" data-caption-animate=\"fadeScale\" data-caption-delay=\"100\">Top-notch Furniture</h1><p class=\"biggest text-white-70\" data-caption-animate=\"fadeScale\" data-caption-delay=\"200\">Sofa Store provides the best furniture and accessories for homes and offices.</p><div class=\"button-wrap\" data-caption-animate=\"fadeInUp\" data-caption-delay=\"300\"> <span class=\"button button-zachem-tak-delat button-white button-zakaria\"> Shop now</span> </div>', 1, 0, 0, 'banner', 1, NULL, NULL),
  (2, 'Banner 2', '/data/banner/Main-banner-3-1903x600.jpg', NULL, '_self', '<h1 class=\"swiper-title-1\" data-caption-animate=\"fadeScale\" data-caption-delay=\"100\">Top-notch Furniture</h1><p class=\"biggest text-white-70\" data-caption-animate=\"fadeScale\" data-caption-delay=\"200\">Sofa Store provides the best furniture and accessories for homes and offices.</p><div class=\"button-wrap\" data-caption-animate=\"fadeInUp\" data-caption-delay=\"300\"> <span class=\"button button-zachem-tak-delat button-white button-zakaria\"> Shop now</span> </div>', 1, 0, 0, 'banner', 1, NULL, NULL),
  (3, 'Banner 3', '/data/banner/bgbr.jpg', NULL, '_self', '', 1, 0, 0, 'breadcrumb', 1, NULL, NULL),
  (4, 'Banner 4', '/data/banner/store-1.jpg', NULL, '_self', '', 1, 0, 0, 'banner-store', 1, NULL, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_banner_type`
  --
  
  CREATE TABLE `sc_shop_banner_type` (
    `id` int(10) UNSIGNED NOT NULL,
    `code` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_shop_banner_type`
  --
  
  INSERT INTO `sc_shop_banner_type` (`id`, `code`, `name`) VALUES
  (1, 'banner', 'Banner website'),
  (2, 'background', 'Background website'),
  (3, 'breadcrumb', 'Breadcrumb website'),
  (4, 'banner-store', 'Banner store'),
  (5, 'other', 'Other');
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_brand`
  --
  
  CREATE TABLE `sc_shop_brand` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `alias` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
    `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `url` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `status` tinyint(4) NOT NULL DEFAULT 0,
    `sort` int(11) NOT NULL DEFAULT 0
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_shop_brand`
  --
  
  INSERT INTO `sc_shop_brand` (`id`, `name`, `alias`, `image`, `url`, `status`, `sort`) VALUES
  (1, 'Husq', 'husq', '/data/brand/01-181x52.png', '', 1, 0),
  (2, 'Ideal', 'ideal', '/data/brand/02-181x52.png', '', 1, 0),
  (3, 'Apex', 'apex', '/data/brand/03-181x52.png', '', 1, 0),
  (4, 'CST', 'cst', '/data/brand/04-181x52.png', '', 1, 0),
  (5, 'Klein', 'klein', '/data/brand/05-181x52.png', '', 1, 0),
  (6, 'Metabo', 'metabo', '/data/brand/06-181x52.png', '', 1, 0),
  (7, 'Avatar', 'avatar', '/data/brand/07-181x52.png', '', 1, 0),
  (8, 'Brand KA', 'brand-ka', '/data/brand/08-181x52.png', '', 1, 0);
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_category`
  --
  
  CREATE TABLE `sc_shop_category` (
    `id` int(10) UNSIGNED NOT NULL,
    `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `alias` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
    `parent` int(11) NOT NULL DEFAULT 0,
    `top` int(11) DEFAULT 0,
    `status` tinyint(4) NOT NULL DEFAULT 0,
    `sort` int(11) NOT NULL DEFAULT 0
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_shop_category`
  --
  
  INSERT INTO `sc_shop_category` (`id`, `image`, `alias`, `parent`, `top`, `status`, `sort`) VALUES
  (1, '/data/category/img-40.jpg', 'electronics', 0, 1, 1, 0),
  (2, '/data/category/img-44.jpg', 'clothing-wears', 0, 1, 1, 0),
  (3, '/data/category/img-42.jpg', 'mobile', 1, 1, 1, 0),
  (4, '/data/category/img-18.jpg', 'accessaries-extras', 0, 1, 1, 0),
  (5, '/data/category/img-14.jpg', 'computers', 1, 1, 1, 0),
  (6, '/data/category/img-14.jpg', 'tablets', 1, 0, 1, 0),
  (7, '/data/category/img-40.jpg', 'appliances', 1, 0, 1, 0),
  (8, '/data/category/img-14.jpg', 'men-clothing', 2, 0, 1, 0),
  (9, '/data/category/img-18.jpg', 'women-clothing', 2, 1, 1, 0),
  (10, '/data/category/img-14.jpg', 'kid-wear', 2, 0, 1, 0),
  (11, '/data/category/img-40.jpg', 'mobile-accessaries', 4, 0, 1, 0),
  (12, '/data/category/img-42.jpg', 'women-accessaries', 4, 0, 1, 3),
  (13, '/data/category/img-40.jpg', 'men-accessaries', 4, 0, 1, 3);
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_category_description`
  --
  
  CREATE TABLE `sc_shop_category_description` (
    `category_id` int(11) NOT NULL,
    `lang` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
    `title` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `keyword` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `description` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_shop_category_description`
  --
  
  INSERT INTO `sc_shop_category_description` (`category_id`, `lang`, `title`, `keyword`, `description`) VALUES
  (1, 'en', 'Electronics', '', ''),
  (1, 'vi', 'Thiết bị điện tử', '', ''),
  (2, 'en', 'Clothing & Wears', '', ''),
  (2, 'vi', 'Quần áo', '', ''),
  (3, 'en', 'Mobile', '', ''),
  (3, 'vi', 'Điện thoại', '', ''),
  (4, 'en', 'Accessaries & Extras', '', ''),
  (4, 'vi', 'Phụ kiện ', '', ''),
  (5, 'en', 'Computers', '', ''),
  (5, 'vi', 'Máy tính', '', ''),
  (6, 'en', 'Tablets', '', ''),
  (6, 'vi', 'Máy tính bảng', '', ''),
  (7, 'en', 'Appliances', '', ''),
  (7, 'vi', 'Thiết bị', '', ''),
  (8, 'en', 'Men\'s Clothing', '', ''),
  (8, 'vi', 'Quần áo nam', '', ''),
  (9, 'en', 'Women\'s Clothing', '', ''),
  (9, 'vi', 'Quần áo nữ', '', ''),
  (10, 'en', 'Kid\'s Wear', '', ''),
  (10, 'vi', 'Đồ trẻ em', '', ''),
  (11, 'en', 'Mobile Accessaries', '', ''),
  (11, 'vi', 'Phụ kiện điện thoại', '', ''),
  (12, 'en', 'Women\'s Accessaries', '', ''),
  (12, 'vi', 'Phụ kiện nữ', '', ''),
  (13, 'en', 'Men\'s Accessaries', '', ''),
  (13, 'vi', 'Phụ kiện nam', '', '');
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_country`
  --
  
  CREATE TABLE `sc_shop_country` (
    `id` int(10) UNSIGNED NOT NULL,
    `code` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
    `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_shop_country`
  --
  
  INSERT INTO `sc_shop_country` (`id`, `code`, `name`) VALUES
  (1, 'AL', 'Albania'),
  (2, 'DZ', 'Algeria'),
  (3, 'DS', 'American Samoa'),
  (4, 'AD', 'Andorra'),
  (5, 'AO', 'Angola'),
  (6, 'AI', 'Anguilla'),
  (7, 'AQ', 'Antarctica'),
  (8, 'AG', 'Antigua and Barbuda'),
  (9, 'AR', 'Argentina'),
  (10, 'AM', 'Armenia'),
  (11, 'AW', 'Aruba'),
  (12, 'AU', 'Australia'),
  (13, 'AT', 'Austria'),
  (14, 'AZ', 'Azerbaijan'),
  (15, 'BS', 'Bahamas'),
  (16, 'BH', 'Bahrain'),
  (17, 'BD', 'Bangladesh'),
  (18, 'BB', 'Barbados'),
  (19, 'BY', 'Belarus'),
  (20, 'BE', 'Belgium'),
  (21, 'BZ', 'Belize'),
  (22, 'BJ', 'Benin'),
  (23, 'BM', 'Bermuda'),
  (24, 'BT', 'Bhutan'),
  (25, 'BO', 'Bolivia'),
  (26, 'BA', 'Bosnia and Herzegovina'),
  (27, 'BW', 'Botswana'),
  (28, 'BV', 'Bouvet Island'),
  (29, 'BR', 'Brazil'),
  (30, 'IO', 'British Indian Ocean Territory'),
  (31, 'BN', 'Brunei Darussalam'),
  (32, 'BG', 'Bulgaria'),
  (33, 'BF', 'Burkina Faso'),
  (34, 'BI', 'Burundi'),
  (35, 'KH', 'Cambodia'),
  (36, 'CM', 'Cameroon'),
  (37, 'CA', 'Canada'),
  (38, 'CV', 'Cape Verde'),
  (39, 'KY', 'Cayman Islands'),
  (40, 'CF', 'Central African Republic'),
  (41, 'TD', 'Chad'),
  (42, 'CL', 'Chile'),
  (43, 'CN', 'China'),
  (44, 'CX', 'Christmas Island'),
  (45, 'CC', 'Cocos (Keeling) Islands'),
  (46, 'CO', 'Colombia'),
  (47, 'KM', 'Comoros'),
  (48, 'CG', 'Congo'),
  (49, 'CK', 'Cook Islands'),
  (50, 'CR', 'Costa Rica'),
  (51, 'HR', 'Croatia (Hrvatska)'),
  (52, 'CU', 'Cuba'),
  (53, 'CY', 'Cyprus'),
  (54, 'CZ', 'Czech Republic'),
  (55, 'DK', 'Denmark'),
  (56, 'DJ', 'Djibouti'),
  (57, 'DM', 'Dominica'),
  (58, 'DO', 'Dominican Republic'),
  (59, 'TP', 'East Timor'),
  (60, 'EC', 'Ecuador'),
  (61, 'EG', 'Egypt'),
  (62, 'SV', 'El Salvador'),
  (63, 'GQ', 'Equatorial Guinea'),
  (64, 'ER', 'Eritrea'),
  (65, 'EE', 'Estonia'),
  (66, 'ET', 'Ethiopia'),
  (67, 'FK', 'Falkland Islands (Malvinas)'),
  (68, 'FO', 'Faroe Islands'),
  (69, 'FJ', 'Fiji'),
  (70, 'FI', 'Finland'),
  (71, 'FR', 'France'),
  (72, 'FX', 'France, Metropolitan'),
  (73, 'GF', 'French Guiana'),
  (74, 'PF', 'French Polynesia'),
  (75, 'TF', 'French Southern Territories'),
  (76, 'GA', 'Gabon'),
  (77, 'GM', 'Gambia'),
  (78, 'GE', 'Georgia'),
  (79, 'DE', 'Germany'),
  (80, 'GH', 'Ghana'),
  (81, 'GI', 'Gibraltar'),
  (82, 'GK', 'Guernsey'),
  (83, 'GR', 'Greece'),
  (84, 'GL', 'Greenland'),
  (85, 'GD', 'Grenada'),
  (86, 'GP', 'Guadeloupe'),
  (87, 'GU', 'Guam'),
  (88, 'GT', 'Guatemala'),
  (89, 'GN', 'Guinea'),
  (90, 'GW', 'Guinea-Bissau'),
  (91, 'GY', 'Guyana'),
  (92, 'HT', 'Haiti'),
  (93, 'HM', 'Heard and Mc Donald Islands'),
  (94, 'HN', 'Honduras'),
  (95, 'HK', 'Hong Kong'),
  (96, 'HU', 'Hungary'),
  (97, 'IS', 'Iceland'),
  (98, 'IN', 'India'),
  (99, 'IM', 'Isle of Man'),
  (100, 'ID', 'Indonesia'),
  (101, 'IR', 'Iran (Islamic Republic of)'),
  (102, 'IQ', 'Iraq'),
  (103, 'IE', 'Ireland'),
  (104, 'IL', 'Israel'),
  (105, 'IT', 'Italy'),
  (106, 'CI', 'Ivory Coast'),
  (107, 'JE', 'Jersey'),
  (108, 'JM', 'Jamaica'),
  (109, 'JP', 'Japan'),
  (110, 'JO', 'Jordan'),
  (111, 'KZ', 'Kazakhstan'),
  (112, 'KE', 'Kenya'),
  (113, 'KI', 'Kiribati'),
  (114, 'KP', 'Korea,Democratic People\'s Republic of'),
  (115, 'KR', 'Korea, Republic of'),
  (116, 'XK', 'Kosovo'),
  (117, 'KW', 'Kuwait'),
  (118, 'KG', 'Kyrgyzstan'),
  (119, 'LA', 'Lao People\'s Democratic Republic'),
  (120, 'LV', 'Latvia'),
  (121, 'LB', 'Lebanon'),
  (122, 'LS', 'Lesotho'),
  (123, 'LR', 'Liberia'),
  (124, 'LY', 'Libyan Arab Jamahiriya'),
  (125, 'LI', 'Liechtenstein'),
  (126, 'LT', 'Lithuania'),
  (127, 'LU', 'Luxembourg'),
  (128, 'MO', 'Macau'),
  (129, 'MK', 'Macedonia'),
  (130, 'MG', 'Madagascar'),
  (131, 'MW', 'Malawi'),
  (132, 'MY', 'Malaysia'),
  (133, 'MV', 'Maldives'),
  (134, 'ML', 'Mali'),
  (135, 'MT', 'Malta'),
  (136, 'MH', 'Marshall Islands'),
  (137, 'MQ', 'Martinique'),
  (138, 'MR', 'Mauritania'),
  (139, 'MU', 'Mauritius'),
  (140, 'TY', 'Mayotte'),
  (141, 'MX', 'Mexico'),
  (142, 'FM', 'Micronesia, Federated States of'),
  (143, 'MD', 'Moldova, Republic of'),
  (144, 'MC', 'Monaco'),
  (145, 'MN', 'Mongolia'),
  (146, 'ME', 'Montenegro'),
  (147, 'MS', 'Montserrat'),
  (148, 'MA', 'Morocco'),
  (149, 'MZ', 'Mozambique'),
  (150, 'MM', 'Myanmar'),
  (151, 'NA', 'Namibia'),
  (152, 'NR', 'Nauru'),
  (153, 'NP', 'Nepal'),
  (154, 'NL', 'Netherlands'),
  (155, 'AN', 'Netherlands Antilles'),
  (156, 'NC', 'New Caledonia'),
  (157, 'NZ', 'New Zealand'),
  (158, 'NI', 'Nicaragua'),
  (159, 'NE', 'Niger'),
  (160, 'NG', 'Nigeria'),
  (161, 'NU', 'Niue'),
  (162, 'NF', 'Norfolk Island'),
  (163, 'MP', 'Northern Mariana Islands'),
  (164, 'NO', 'Norway'),
  (165, 'OM', 'Oman'),
  (166, 'PK', 'Pakistan'),
  (167, 'PW', 'Palau'),
  (168, 'PS', 'Palestine'),
  (169, 'PA', 'Panama'),
  (170, 'PG', 'Papua New Guinea'),
  (171, 'PY', 'Paraguay'),
  (172, 'PE', 'Peru'),
  (173, 'PH', 'Philippines'),
  (174, 'PN', 'Pitcairn'),
  (175, 'PL', 'Poland'),
  (176, 'PT', 'Portugal'),
  (177, 'PR', 'Puerto Rico'),
  (178, 'QA', 'Qatar'),
  (179, 'RE', 'Reunion'),
  (180, 'RO', 'Romania'),
  (181, 'RU', 'Russian Federation'),
  (182, 'RW', 'Rwanda'),
  (183, 'KN', 'Saint Kitts and Nevis'),
  (184, 'LC', 'Saint Lucia'),
  (185, 'VC', 'Saint Vincent and the Grenadines'),
  (186, 'WS', 'Samoa'),
  (187, 'SM', 'San Marino'),
  (188, 'ST', 'Sao Tome and Principe'),
  (189, 'SA', 'Saudi Arabia'),
  (190, 'SN', 'Senegal'),
  (191, 'RS', 'Serbia'),
  (192, 'SC', 'Seychelles'),
  (193, 'SL', 'Sierra Leone'),
  (194, 'SG', 'Singapore'),
  (195, 'SK', 'Slovakia'),
  (196, 'SI', 'Slovenia'),
  (197, 'SB', 'Solomon Islands'),
  (198, 'SO', 'Somalia'),
  (199, 'ZA', 'South Africa'),
  (200, 'GS', 'South Georgia South Sandwich Islands'),
  (201, 'SS', 'South Sudan'),
  (202, 'ES', 'Spain'),
  (203, 'LK', 'Sri Lanka'),
  (204, 'SH', 'St. Helena'),
  (205, 'PM', 'St. Pierre and Miquelon'),
  (206, 'SD', 'Sudan'),
  (207, 'SR', 'Suriname'),
  (208, 'SJ', 'Svalbard and Jan Mayen Islands'),
  (209, 'SZ', 'Swaziland'),
  (210, 'SE', 'Sweden'),
  (211, 'CH', 'Switzerland'),
  (212, 'SY', 'Syrian Arab Republic'),
  (213, 'TW', 'Taiwan'),
  (214, 'TJ', 'Tajikistan'),
  (215, 'TZ', 'Tanzania, United Republic of'),
  (216, 'TH', 'Thailand'),
  (217, 'TG', 'Togo'),
  (218, 'TK', 'Tokelau'),
  (219, 'TO', 'Tonga'),
  (220, 'TT', 'Trinidad and Tobago'),
  (221, 'TN', 'Tunisia'),
  (222, 'TR', 'Turkey'),
  (223, 'TM', 'Turkmenistan'),
  (224, 'TC', 'Turks and Caicos Islands'),
  (225, 'TV', 'Tuvalu'),
  (226, 'UG', 'Uganda'),
  (227, 'UA', 'Ukraine'),
  (228, 'AE', 'United Arab Emirates'),
  (229, 'GB', 'United Kingdom'),
  (230, 'US', 'United States'),
  (231, 'UM', 'United States minor outlying islands'),
  (232, 'UY', 'Uruguay'),
  (233, 'UZ', 'Uzbekistan'),
  (234, 'VU', 'Vanuatu'),
  (235, 'VA', 'Vatican City State'),
  (236, 'VE', 'Venezuela'),
  (237, 'VN', 'Vietnam'),
  (238, 'VG', 'Virgin Islands (British)'),
  (239, 'VI', 'Virgin Islands (U.S.)'),
  (240, 'WF', 'Wallis and Futuna Islands'),
  (241, 'EH', 'Western Sahara'),
  (242, 'YE', 'Yemen'),
  (243, 'ZR', 'Zaire'),
  (244, 'ZM', 'Zambia'),
  (245, 'ZW', 'Zimbabwe');
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_currency`
  --
  
  CREATE TABLE `sc_shop_currency` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `code` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
    `symbol` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
    `exchange_rate` double(8,2) NOT NULL,
    `precision` tinyint(4) NOT NULL DEFAULT 2,
    `symbol_first` tinyint(4) NOT NULL DEFAULT 0,
    `thousands` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ',',
    `status` tinyint(4) NOT NULL DEFAULT 0,
    `sort` int(11) NOT NULL DEFAULT 0
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_shop_currency`
  --
  
  INSERT INTO `sc_shop_currency` (`id`, `name`, `code`, `symbol`, `exchange_rate`, `precision`, `symbol_first`, `thousands`, `status`, `sort`) VALUES
  (1, 'USD Dola', 'USD', '$', 1.00, 0, 1, ',', 1, 0),
  (2, 'VietNam Dong', 'VND', '₫', 20.00, 0, 0, ',', 1, 1);
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_customer`
  --
  
  CREATE TABLE `sc_shop_customer` (
    `id` int(10) UNSIGNED NOT NULL,
    `first_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `last_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `first_name_kana` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `last_name_kana` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `email` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `sex` tinyint(4) DEFAULT NULL COMMENT '0:women, 1:men',
    `birthday` date DEFAULT NULL,
    `password` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `address_id` int(11) NOT NULL DEFAULT 0,
    `postcode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `address1` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `address2` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `address3` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `company` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `country` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT 'VN',
    `phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `store_id` int(11) NOT NULL DEFAULT 1,
    `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `status` tinyint(4) NOT NULL DEFAULT 1,
    `group` tinyint(4) NOT NULL DEFAULT 1,
    `email_verified_at` timestamp NULL DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `provider` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `provider_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_shop_customer`
  --
  
  INSERT INTO `sc_shop_customer` (`id`, `first_name`, `last_name`, `first_name_kana`, `last_name_kana`, `email`, `sex`, `birthday`, `password`, `address_id`, `postcode`, `address1`, `address2`, `address3`, `company`, `country`, `phone`, `store_id`, `remember_token`, `status`, `group`, `email_verified_at`, `created_at`, `updated_at`, `provider`, `provider_id`) VALUES
  (1, 'Naruto', 'Kun', NULL, NULL, 'test@test.com', NULL, NULL, '$2y$10$4nTcfgmdnOHWaejIt..jG.QZU9TJ1kEwNf8CpDq9QFL7ey8AG29ci', 0, '70000', 'HCM', 'HCM city', NULL, 'KTC', 'VN', '0667151172', 1, NULL, 1, 1, NULL, '2022-01-12 13:04:06', NULL, NULL, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_customer_address`
  --
  
  CREATE TABLE `sc_shop_customer_address` (
    `id` int(10) UNSIGNED NOT NULL,
    `customer_id` int(11) NOT NULL,
    `first_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `last_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `first_name_kana` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `last_name_kana` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `postcode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `address1` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `address2` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `address3` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `country` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT 'VN',
    `phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_shop_customer_address`
  --
  
  INSERT INTO `sc_shop_customer_address` (`id`, `customer_id`, `first_name`, `last_name`, `first_name_kana`, `last_name_kana`, `postcode`, `address1`, `address2`, `address3`, `country`, `phone`) VALUES
  (1, 1, 'Naruto', 'Kun', NULL, NULL, '70000', 'HCM', 'HCM city', NULL, 'VN', '0667151172');
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_custom_field`
  --
  
  CREATE TABLE `sc_shop_custom_field` (
    `id` int(10) UNSIGNED NOT NULL,
    `type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'product, customer',
    `code` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
    `required` int(11) NOT NULL DEFAULT 0,
    `status` int(11) NOT NULL DEFAULT 1,
    `option` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'radio, select, input',
    `default` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '{"value1":"name1", "value2":"name2"}'
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_custom_field_detail`
  --
  
  CREATE TABLE `sc_shop_custom_field_detail` (
    `id` int(10) UNSIGNED NOT NULL,
    `custom_field_id` int(11) NOT NULL,
    `rel_id` int(11) NOT NULL,
    `text` text COLLATE utf8mb4_unicode_ci DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_email_template`
  --
  
  CREATE TABLE `sc_shop_email_template` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `group` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `text` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `store_id` int(11) NOT NULL DEFAULT 1,
    `status` tinyint(4) NOT NULL DEFAULT 0
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_shop_email_template`
  --
  
  INSERT INTO `sc_shop_email_template` (`id`, `name`, `group`, `text`, `store_id`, `status`) VALUES
  (1, 'Reset password', 'forgot_password', '\n<h1 style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box;color:#2f3133;font-size:19px;font-weight:bold;margin-top:0;text-align:left\">{{$title}}</h1>\n<p style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box;color:#74787e;font-size:16px;line-height:1.5em;margin-top:0;text-align:left\">{{$reason_sendmail}}</p>\n<table class=\"action\" align=\"center\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box;margin:30px auto;padding:0;text-align:center;width:100%\">\n<tbody><tr>\n  <td align=\"center\" style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box\">\n  <table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box\">\n      <tbody><tr>\n      <td align=\"center\" style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box\">\n          <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box\">\n          <tbody><tr>\n              <td style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box\">\n              <a href=\"{{$reset_link}}\" class=\"button button-primary\" style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box;border-radius:3px;color:#fff;display:inline-block;text-decoration:none;background-color:#3097d1;border-top:10px solid #3097d1;border-right:18px solid #3097d1;border-bottom:10px solid #3097d1;border-left:18px solid #3097d1\" target=\"_blank\">{{$reset_button}}</a>\n              </td>\n          </tr>\n          </tbody>\n      </table>\n      </td>\n      </tr>\n  </tbody>\n  </table>\n  </td>\n</tr>\n</tbody>\n</table>\n<p style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box;color:#74787e;font-size:16px;line-height:1.5em;margin-top:0;text-align:left\">\n{{$note_sendmail}}\n</p>\n<table class=\"subcopy\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box;border-top:1px solid #edeff2;margin-top:25px;padding-top:25px\">\n<tbody><tr>\n<td style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box\">\n  <p style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box;color:#74787e;line-height:1.5em;margin-top:0;text-align:left;font-size:12px\">{{$note_access_link}}</p>\n  </td>\n  </tr>\n</tbody>\n</table>', 1, 1),
  (2, 'Customer verification', 'customer_verify', '\n<h1 style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box;color:#2f3133;font-size:19px;font-weight:bold;margin-top:0;text-align:left\">{{$title}}</h1>\n<p style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box;color:#74787e;font-size:16px;line-height:1.5em;margin-top:0;text-align:left\">{{$reason_sendmail}}</p>\n<table class=\"action\" align=\"center\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box;margin:30px auto;padding:0;text-align:center;width:100%\">\n<tbody><tr>\n  <td align=\"center\" style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box\">\n  <table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box\">\n      <tbody><tr>\n      <td align=\"center\" style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box\">\n          <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box\">\n          <tbody><tr>\n              <td style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box\">\n              <a href=\"{{$url_verify}}\" class=\"button button-primary\" style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box;border-radius:3px;color:#fff;display:inline-block;text-decoration:none;background-color:#3097d1;border-top:10px solid #3097d1;border-right:18px solid #3097d1;border-bottom:10px solid #3097d1;border-left:18px solid #3097d1\" target=\"_blank\">{{$button}}</a>\n              </td>\n          </tr>\n          </tbody>\n      </table>\n      </td>\n      </tr>\n  </tbody>\n  </table>\n  </td>\n</tr>\n</tbody>\n</table>\n<p style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box;color:#74787e;font-size:16px;line-height:1.5em;margin-top:0;text-align:left\">\n{{$note_sendmail}}\n</p>\n<table class=\"subcopy\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box;border-top:1px solid #edeff2;margin-top:25px;padding-top:25px\">\n<tbody><tr>\n<td style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box\">\n  <p style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box;color:#74787e;line-height:1.5em;margin-top:0;text-align:left;font-size:12px\">{{$note_access_link}}</p>\n  </td>\n  </tr>\n</tbody>\n</table>', 1, 1),
  (3, 'Welcome new customer', 'welcome_customer', '\n<h1 style=\"font-family:Avenir,Helvetica,sans-serif;box-sizing:border-box;color:#2f3133;font-size:19px;font-weight:bold;margin-top:0;text-align:center\">{{$title}}</h1>\n<p style=\"text-align:center;\">Welcome to my site!</p>', 1, 1),
  (4, 'Send form contact to admin', 'contact_to_admin', '\n<table class=\"inner-body\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\n<tr>\n<td>\n<b>Name</b>: {{$name}}<br>\n<b>Email</b>: {{$email}}<br>\n<b>Phone</b>: {{$phone}}<br>\n</td>\n</tr>\n</table>\n<hr>\n<p style=\"text-align: center;\">Content:<br>\n<table class=\"inner-body\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\n<tr>\n<td>{{$content}}</td>\n</tr>\n</table>', 1, 1),
  (5, 'New order to admin', 'order_success_to_admin', '\n<table class=\"inner-body\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\n  <tr>\n      <td>\n          <b>Order ID</b>: {{$orderID}}<br>\n          <b>Customer name</b>: {{$toname}}<br>\n          <b>Email</b>: {{$email}}<br>\n          <b>Address</b>: {{$address}}<br>\n          <b>Phone</b>: {{$phone}}<br>\n          <b>Order note</b>: {{$comment}}\n      </td>\n  </tr>\n</table>\n<hr>\n<p style=\"text-align: center;\">Order detail:<br>\n===================================<br></p>\n<table class=\"inner-body\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\" border=\"1\">\n  {{$orderDetail}}\n  <tr>\n      <td colspan=\"2\"></td>\n      <td colspan=\"2\" style=\"font-weight: bold;\">Sub total</td>\n      <td colspan=\"2\" align=\"right\">{{$subtotal}}</td>\n  </tr>\n  <tr>\n      <td colspan=\"2\"></td>\n      <td colspan=\"2\" style=\"font-weight: bold;\">Shipping fee</td>\n      <td colspan=\"2\" align=\"right\">{{$shipping}}</td>\n  </tr>\n  <tr>\n      <td colspan=\"2\"></td>\n      <td colspan=\"2\" style=\"font-weight: bold;\">Discount</td>\n      <td colspan=\"2\" align=\"right\">{{$discount}}</td>\n  </tr>\n  <tr>\n      <td colspan=\"2\"></td>\n      <td colspan=\"2\" style=\"font-weight: bold;\">Total</td>\n      <td colspan=\"2\" align=\"right\">{{$total}}</td>\n  </tr>\n</table>', 1, 1),
  (6, 'New order to customr', 'order_success_to_customer', '\n<table class=\"inner-body\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\n<tr>\n  <td>\n      <b>Order ID</b>: {{$orderID}}<br>\n      <b>Customer name</b>: {{$toname}}<br>\n      <b>Address</b>: {{$address}}<br>\n      <b>Phone</b>: {{$phone}}<br>\n      <b>Order note</b>: {{$comment}}\n  </td>\n</tr>\n</table>\n<hr>\n<p style=\"text-align: center;\">Order detail:<br>\n===================================<br></p>\n<table class=\"inner-body\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\" border=\"1\">\n{{$orderDetail}}\n<tr>\n  <td colspan=\"2\"></td>\n  <td colspan=\"2\" style=\"font-weight: bold;\">Sub total</td>\n  <td colspan=\"2\" align=\"right\">{{$subtotal}}</td>\n</tr>\n<tr>\n  <td colspan=\"2\"></td>\n  <td colspan=\"2\" style=\"font-weight: bold;\">Shipping fee</td>\n  <td colspan=\"2\" align=\"right\">{{$shipping}}</td>\n</tr>\n<tr>\n  <td colspan=\"2\"></td>\n  <td colspan=\"2\" style=\"font-weight: bold;\">Discount</td>\n  <td colspan=\"2\" align=\"right\">{{$discount}}</td>\n</tr>\n<tr>\n  <td colspan=\"2\"></td>\n  <td colspan=\"2\" style=\"font-weight: bold;\">Total</td>\n  <td colspan=\"2\" align=\"right\">{{$total}}</td>\n</tr>\n</table>', 1, 1);
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_language`
  --
  
  CREATE TABLE `sc_shop_language` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `code` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `icon` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `status` tinyint(4) NOT NULL DEFAULT 0,
    `rtl` tinyint(4) DEFAULT 0 COMMENT 'Layout RTL',
    `sort` int(11) NOT NULL DEFAULT 0
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_shop_language`
  --
  
  INSERT INTO `sc_shop_language` (`id`, `name`, `code`, `icon`, `status`, `rtl`, `sort`) VALUES
  (1, 'English', 'en', '/data/language/flag_uk.png', 1, 0, 1),
  (2, 'Tiếng Việt', 'vi', '/data/language/flag_vn.png', 1, 0, 1);
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_layout_page`
  --
  
  CREATE TABLE `sc_shop_layout_page` (
    `id` int(10) UNSIGNED NOT NULL,
    `key` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_shop_layout_page`
  --
  
  INSERT INTO `sc_shop_layout_page` (`id`, `key`, `name`) VALUES
  (1, 'home', 'lang::layout.page_position.home'),
  (2, 'shop_home', 'lang::layout.page_position.shop_home'),
  (3, 'shop_product_list', 'lang::layout.page_position.product_list'),
  (4, 'product_detail', 'lang::layout.page_position.product_detail'),
  (5, 'shop_cart', 'lang::layout.page_position.shop_cart'),
  (6, 'shop_item_list', 'lang::layout.page_position.item_list'),
  (7, 'shop_item_detail', 'lang::layout.page_position.item_detail'),
  (8, 'shop_news', 'lang::layout.page_position.news_list'),
  (9, 'shop_news_detail', 'lang::layout.page_position.news_detail'),
  (10, 'shop_auth', 'lang::layout.page_position.shop_auth'),
  (11, 'shop_profile', 'lang::layout.page_position.shop_profile'),
  (12, 'shop_page', 'lang::layout.page_position.shop_page'),
  (13, 'shop_contact', 'lang::layout.page_position.shop_contact'),
  (14, 'content_list', 'lang::layout.page_position.content_list'),
  (15, 'content_detail', 'lang::layout.page_position.content_detail'),
  (16, 'store_home', 'lang::layout.page_position.store_home'),
  (17, 'store_product_list', 'lang::layout.page_position.store_product_list');
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_layout_position`
  --
  
  CREATE TABLE `sc_shop_layout_position` (
    `id` int(10) UNSIGNED NOT NULL,
    `key` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_shop_layout_position`
  --
  
  INSERT INTO `sc_shop_layout_position` (`id`, `key`, `name`) VALUES
  (1, 'meta', 'lang::layout.page_block.meta'),
  (2, 'header', 'lang::layout.page_block.header'),
  (3, 'top', 'lang::layout.page_block.top'),
  (4, 'bottom', 'lang::layout.page_block.bottom'),
  (5, 'left', 'lang::layout.page_block.left'),
  (6, 'right', 'lang::layout.page_block.right'),
  (7, 'banner_top', 'lang::layout.page_block.banner_top');
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_length`
  --
  
  CREATE TABLE `sc_shop_length` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `description` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_shop_length`
  --
  
  INSERT INTO `sc_shop_length` (`id`, `name`, `description`) VALUES
  (1, 'mm', 'Millimeter'),
  (2, 'cm', 'Centimeter'),
  (3, 'm', 'Meter'),
  (4, 'in', 'Inch');
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_link`
  --
  
  CREATE TABLE `sc_shop_link` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `url` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `target` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `group` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `module` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `status` tinyint(4) NOT NULL DEFAULT 0,
    `sort` int(11) NOT NULL DEFAULT 0,
    `store_id` int(11) NOT NULL DEFAULT 1
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_shop_link`
  --
  
  INSERT INTO `sc_shop_link` (`id`, `name`, `url`, `target`, `group`, `module`, `status`, `sort`, `store_id`) VALUES
  (1, 'lang::front.contact', 'route::contact', '_self', 'menu', '', 1, 3, 1),
  (2, 'lang::front.about', 'route::page.detail::about', '_self', 'menu', '', 1, 4, 1),
  (3, 'lang::front.my_profile', 'route::login', '_self', 'footer', '', 1, 5, 1),
  (4, 'lang::front.compare_page', 'route::compare', '_self', 'footer', '', 1, 4, 1),
  (5, 'lang::front.wishlist_page', 'route::wishlist', '_self', 'footer', '', 1, 3, 1);
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_news`
  --
  
  CREATE TABLE `sc_shop_news` (
    `id` int(10) UNSIGNED NOT NULL,
    `image` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `alias` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
    `sort` int(11) NOT NULL DEFAULT 0,
    `status` tinyint(4) NOT NULL DEFAULT 0,
    `store_id` int(11) NOT NULL DEFAULT 1,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_shop_news`
  --
  
  INSERT INTO `sc_shop_news` (`id`, `image`, `alias`, `sort`, `status`, `store_id`, `created_at`, `updated_at`) VALUES
  (1, '/data/content/blog-1.jpg', 'demo-alias-blog-1', 0, 1, 1, '2022-01-11 17:00:00', NULL),
  (2, '/data/content/blog-2.jpg', 'demo-alias-blog-2', 0, 1, 1, '2022-01-11 17:00:00', NULL),
  (3, '/data/content/blog-3.jpg', 'demo-alias-blog-3', 0, 1, 1, '2022-01-11 17:00:00', NULL),
  (4, '/data/content/blog-4.jpg', 'demo-alias-blog-4', 0, 1, 1, '2022-01-11 17:00:00', NULL),
  (5, '/data/content/blog-5.jpg', 'demo-alias-blog-5', 0, 1, 1, '2022-01-11 17:00:00', NULL),
  (6, '/data/content/blog-6.jpg', 'demo-alias-blog-6', 0, 1, 1, '2022-01-11 17:00:00', NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_news_description`
  --
  
  CREATE TABLE `sc_shop_news_description` (
    `news_id` int(11) NOT NULL,
    `lang` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
    `title` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `keyword` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `description` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `content` text COLLATE utf8mb4_unicode_ci DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_shop_news_description`
  --
  
  INSERT INTO `sc_shop_news_description` (`news_id`, `lang`, `title`, `keyword`, `description`, `content`) VALUES
  (1, 'en', 'Easy Polo Black Edition 1', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (1, 'vi', 'Easy Polo Black Edition 1', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (2, 'en', 'Easy Polo Black Edition 2', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (2, 'vi', 'Easy Polo Black Edition 2', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (3, 'en', 'Easy Polo Black Edition 3', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (3, 'vi', 'Easy Polo Black Edition 3', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (4, 'en', 'Easy Polo Black Edition 4', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (4, 'vi', 'Easy Polo Black Edition 4', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (5, 'en', 'Easy Polo Black Edition 5', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (5, 'vi', 'Easy Polo Black Edition 5', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (6, 'en', 'Easy Polo Black Edition 6', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (6, 'vi', 'Easy Polo Black Edition 6', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>');
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_order`
  --
  
  CREATE TABLE `sc_shop_order` (
    `id` int(10) UNSIGNED NOT NULL,
    `customer_id` int(11) NOT NULL,
    `domain` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `subtotal` int(11) DEFAULT 0,
    `shipping` int(11) DEFAULT 0,
    `discount` int(11) DEFAULT 0,
    `payment_status` int(11) NOT NULL DEFAULT 1,
    `shipping_status` int(11) NOT NULL DEFAULT 1,
    `status` int(11) NOT NULL DEFAULT 0,
    `tax` int(11) DEFAULT 0,
    `total` int(11) DEFAULT 0,
    `currency` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
    `exchange_rate` double(8,2) DEFAULT NULL,
    `received` int(11) DEFAULT 0,
    `balance` int(11) DEFAULT 0,
    `first_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `last_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `first_name_kana` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `last_name_kana` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `address1` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `address2` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `address3` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `country` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT 'VN',
    `company` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `postcode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `email` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
    `comment` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `payment_method` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `shipping_method` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `user_agent` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `ip` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `transaction` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_order_detail`
  --
  
  CREATE TABLE `sc_shop_order_detail` (
    `id` int(10) UNSIGNED NOT NULL,
    `order_id` int(11) NOT NULL,
    `product_id` int(11) NOT NULL,
    `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `price` int(11) NOT NULL DEFAULT 0,
    `qty` int(11) NOT NULL DEFAULT 0,
    `store_id` int(11) NOT NULL DEFAULT 1,
    `total_price` int(11) NOT NULL DEFAULT 0,
    `tax` int(11) NOT NULL DEFAULT 0,
    `sku` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `currency` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
    `exchange_rate` double(8,2) DEFAULT NULL,
    `attribute` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_order_history`
  --
  
  CREATE TABLE `sc_shop_order_history` (
    `id` int(10) UNSIGNED NOT NULL,
    `order_id` int(11) NOT NULL,
    `content` varchar(300) COLLATE utf8mb4_unicode_ci NOT NULL,
    `admin_id` int(11) NOT NULL DEFAULT 0,
    `customer_id` int(11) NOT NULL DEFAULT 0,
    `order_status_id` int(11) NOT NULL DEFAULT 0,
    `add_date` datetime NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_order_status`
  --
  
  CREATE TABLE `sc_shop_order_status` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_shop_order_status`
  --
  
  INSERT INTO `sc_shop_order_status` (`id`, `name`) VALUES
  (1, 'New'),
  (2, 'Processing'),
  (3, 'Hold'),
  (4, 'Canceled'),
  (5, 'Done'),
  (6, 'Failed');
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_order_total`
  --
  
  CREATE TABLE `sc_shop_order_total` (
    `id` int(10) UNSIGNED NOT NULL,
    `order_id` int(11) NOT NULL,
    `title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `code` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `value` int(11) NOT NULL DEFAULT 0,
    `text` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `sort` int(11) NOT NULL DEFAULT 1,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_page`
  --
  
  CREATE TABLE `sc_shop_page` (
    `id` int(10) UNSIGNED NOT NULL,
    `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `alias` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
    `status` int(11) NOT NULL DEFAULT 0,
    `store_id` int(11) NOT NULL DEFAULT 1
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_shop_page`
  --
  
  INSERT INTO `sc_shop_page` (`id`, `image`, `alias`, `status`, `store_id`) VALUES
  (1, '', 'about', 1, 1);
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_page_description`
  --
  
  CREATE TABLE `sc_shop_page_description` (
    `page_id` int(11) NOT NULL,
    `lang` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
    `title` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `keyword` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `description` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `content` text COLLATE utf8mb4_unicode_ci DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_shop_page_description`
  --
  
  INSERT INTO `sc_shop_page_description` (`page_id`, `lang`, `title`, `keyword`, `description`, `content`) VALUES
  (1, 'en', 'About', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-2.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>\n    '),
  (1, 'vi', 'Giới thiệu', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-2.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>\n    ');
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_password_resets`
  --
  
  CREATE TABLE `sc_shop_password_resets` (
    `email` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
    `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` datetime NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_payment_status`
  --
  
  CREATE TABLE `sc_shop_payment_status` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_shop_payment_status`
  --
  
  INSERT INTO `sc_shop_payment_status` (`id`, `name`) VALUES
  (1, 'Unpaid'),
  (2, 'Partial payment'),
  (3, 'Paid'),
  (4, 'Refurn');
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_product`
  --
  
  CREATE TABLE `sc_shop_product` (
    `id` int(10) UNSIGNED NOT NULL,
    `sku` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `upc` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'upc code',
    `ean` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'ean code',
    `jan` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'jan code',
    `isbn` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'isbn code',
    `mpn` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'mpn code',
    `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `brand_id` int(11) DEFAULT 0,
    `supplier_id` int(11) DEFAULT 0,
    `price` int(11) DEFAULT 0,
    `cost` int(11) DEFAULT 0,
    `stock` int(11) DEFAULT 0,
    `sold` int(11) DEFAULT 0,
    `minimum` int(11) DEFAULT 0,
    `weight_class` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `weight` int(11) DEFAULT 0,
    `length_class` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `length` int(11) DEFAULT 0,
    `width` int(11) DEFAULT 0,
    `height` int(11) DEFAULT 0,
    `kind` tinyint(4) DEFAULT 0 COMMENT '0:single, 1:bundle, 2:group',
    `property` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT 'physical',
    `tax_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '0' COMMENT '0:No-tax, auto: Use tax default',
    `status` tinyint(4) NOT NULL DEFAULT 0,
    `sort` int(11) NOT NULL DEFAULT 0,
    `view` int(11) NOT NULL DEFAULT 0,
    `alias` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
    `category_store_id` int(11) DEFAULT 1,
    `store_id` int(11) NOT NULL DEFAULT 1,
    `date_lastview` datetime DEFAULT NULL,
    `date_available` date DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_shop_product`
  --
  
  INSERT INTO `sc_shop_product` (`id`, `sku`, `upc`, `ean`, `jan`, `isbn`, `mpn`, `image`, `brand_id`, `supplier_id`, `price`, `cost`, `stock`, `sold`, `minimum`, `weight_class`, `weight`, `length_class`, `length`, `width`, `height`, `kind`, `property`, `tax_id`, `status`, `sort`, `view`, `alias`, `category_store_id`, `store_id`, `date_lastview`, `date_available`, `created_at`, `updated_at`) VALUES
  (1, 'ABCZZ', NULL, NULL, NULL, NULL, NULL, '/data/product/product-1.png', 1, 1, 15000, 10000, 99, 1, 0, NULL, 0, NULL, 0, 0, 0, 0, 'physical', 'auto', 1, 0, 0, 'demo-alias-name-product-1', 1, 1, NULL, '2022-02-12', NULL, NULL),
  (2, 'LEDFAN1', NULL, NULL, NULL, NULL, NULL, '/data/product/product-2.png', 1, 1, 15000, 10000, 100, 0, 0, NULL, 0, NULL, 0, 0, 0, 0, 'physical', 'auto', 1, 0, 0, 'demo-alias-name-product-2', 1, 1, NULL, NULL, NULL, NULL),
  (3, 'CLOCKFAN1', NULL, NULL, NULL, NULL, NULL, '/data/product/product-3.png', 2, 1, 15000, 10000, 100, 0, 0, NULL, 0, NULL, 0, 0, 0, 0, 'physical', 'auto', 1, 0, 0, 'demo-alias-name-product-3', 1, 1, NULL, NULL, NULL, NULL),
  (4, 'CLOCKFAN2', NULL, NULL, NULL, NULL, NULL, '/data/product/product-4.png', 3, 1, 15000, 10000, 100, 0, 10, NULL, 0, NULL, 0, 0, 0, 0, 'physical', 'auto', 1, 0, 0, 'demo-alias-name-product-4', 1, 1, NULL, NULL, NULL, NULL),
  (5, 'CLOCKFAN3', NULL, NULL, NULL, NULL, NULL, '/data/product/product-5.png', 1, 1, 15000, 10000, 100, 0, 0, NULL, 0, NULL, 0, 0, 0, 0, 'physical', 'auto', 1, 0, 0, 'demo-alias-name-product-5', 1, 1, NULL, NULL, NULL, NULL),
  (6, 'TMC2208', NULL, NULL, NULL, NULL, NULL, '/data/product/product-6.png', 1, 1, 15000, 10000, 100, 0, 0, NULL, 0, NULL, 0, 0, 0, 0, 'physical', 'auto', 1, 0, 0, 'demo-alias-name-product-6', 1, 1, NULL, NULL, NULL, NULL),
  (7, 'FILAMENT', NULL, NULL, NULL, NULL, NULL, '/data/product/product-7.png', 2, 1, 15000, 10000, 100, 0, 0, NULL, 0, NULL, 0, 0, 0, 0, 'physical', 'auto', 1, 0, 0, 'demo-alias-name-product-7', 1, 1, NULL, NULL, NULL, NULL),
  (8, 'A4988', NULL, NULL, NULL, NULL, NULL, '/data/product/product-8.png', 2, 1, 15000, 10000, 100, 0, 0, NULL, 0, NULL, 0, 0, 0, 0, 'physical', 'auto', 1, 0, 0, 'demo-alias-name-product-8', 1, 1, NULL, NULL, NULL, NULL),
  (9, 'ANYCUBIC-P', NULL, NULL, NULL, NULL, NULL, '/data/product/product-9.png', 2, 1, 15000, 10000, 100, 0, 0, NULL, 0, NULL, 0, 0, 0, 0, 'physical', 'auto', 1, 0, 0, 'demo-alias-name-product-9', 1, 1, NULL, NULL, NULL, NULL),
  (10, '3DHLFD-P', NULL, NULL, NULL, NULL, NULL, '/data/product/product-10.png', 4, 1, 15000, 10000, 100, 0, 0, NULL, 0, NULL, 0, 0, 0, 0, 'physical', 'auto', 1, 0, 0, 'demo-alias-name-product-10', 1, 1, NULL, NULL, NULL, NULL),
  (11, 'SS495A', NULL, NULL, NULL, NULL, NULL, '/data/product/product-11.png', 2, 1, 15000, 10000, 100, 0, 0, NULL, 0, NULL, 0, 0, 0, 0, 'physical', 'auto', 1, 0, 0, 'demo-alias-name-product-11', 1, 1, NULL, NULL, NULL, NULL),
  (12, '3D-CARBON175', NULL, NULL, NULL, NULL, NULL, '/data/product/product-12.png', 2, 1, 15000, 10000, 100, 0, 5, NULL, 0, NULL, 0, 0, 0, 0, 'physical', 'auto', 1, 0, 0, 'demo-alias-name-product-12', 1, 1, NULL, NULL, NULL, NULL),
  (13, '3D-GOLD175', NULL, NULL, NULL, NULL, NULL, '/data/product/product-13.png', 3, 1, 10000, 5000, 0, 0, 0, NULL, 0, NULL, 0, 0, 0, 0, 'physical', 'auto', 1, 0, 0, 'demo-alias-name-product-13', 1, 1, NULL, NULL, NULL, NULL),
  (14, 'LCD12864-3D', NULL, NULL, NULL, NULL, NULL, '/data/product/product-14.png', 3, 1, 15000, 10000, 100, 0, 0, NULL, 0, NULL, 0, 0, 0, 0, 'physical', 'auto', 1, 0, 0, 'demo-alias-name-product-14', 1, 1, NULL, NULL, NULL, NULL),
  (15, 'LCD2004-3D', NULL, NULL, NULL, NULL, NULL, '/data/product/product-15.png', 3, 1, 15000, 10000, 100, 0, 10, NULL, 0, NULL, 0, 0, 0, 1, 'physical', 'auto', 1, 0, 0, 'demo-alias-name-product-15', 1, 1, NULL, NULL, NULL, NULL),
  (16, 'RAMPS15-3D', NULL, NULL, NULL, NULL, NULL, '/data/product/product-16.png', 2, 1, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, 0, 0, 2, 'physical', 'auto', 1, 0, 0, 'demo-alias-name-product-16', 1, 1, NULL, NULL, NULL, NULL),
  (17, 'ALOKK1-AY', NULL, NULL, NULL, NULL, NULL, '/data/product/product-10.png', 3, 1, 15000, 10000, 100, 0, 5, NULL, 0, NULL, 0, 0, 0, 0, 'physical', 'auto', 1, 0, 0, 'demo-alias-name-product-17', 1, 1, NULL, NULL, NULL, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_product_attribute`
  --
  
  CREATE TABLE `sc_shop_product_attribute` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `attribute_group_id` int(11) NOT NULL,
    `product_id` int(11) NOT NULL,
    `add_price` int(11) NOT NULL DEFAULT 0,
    `sort` int(11) NOT NULL DEFAULT 0,
    `status` tinyint(4) NOT NULL DEFAULT 1
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_shop_product_attribute`
  --
  
  INSERT INTO `sc_shop_product_attribute` (`id`, `name`, `attribute_group_id`, `product_id`, `add_price`, `sort`, `status`) VALUES
  (1, 'Blue', 1, 17, 50, 0, 1),
  (2, 'White', 1, 17, 0, 0, 1),
  (3, 'S', 2, 17, 20, 0, 1),
  (4, 'XL', 2, 17, 30, 0, 1),
  (5, 'Blue', 1, 10, 150, 0, 1),
  (6, 'Red', 1, 10, 0, 0, 1),
  (7, 'S', 2, 10, 0, 0, 1),
  (8, 'M', 2, 10, 0, 0, 1);
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_product_build`
  --
  
  CREATE TABLE `sc_shop_product_build` (
    `build_id` int(11) NOT NULL,
    `product_id` int(11) NOT NULL,
    `quantity` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_shop_product_build`
  --
  
  INSERT INTO `sc_shop_product_build` (`build_id`, `product_id`, `quantity`) VALUES
  (15, 6, 1),
  (15, 7, 2);
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_product_category`
  --
  
  CREATE TABLE `sc_shop_product_category` (
    `product_id` int(11) NOT NULL,
    `category_id` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_shop_product_category`
  --
  
  INSERT INTO `sc_shop_product_category` (`product_id`, `category_id`) VALUES
  (1, 6),
  (1, 10),
  (1, 13),
  (2, 13),
  (3, 11),
  (4, 11),
  (5, 11),
  (6, 11),
  (7, 12),
  (8, 10),
  (9, 6),
  (10, 11),
  (11, 10),
  (12, 9),
  (13, 5),
  (14, 11),
  (15, 6),
  (16, 9),
  (17, 9);
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_product_description`
  --
  
  CREATE TABLE `sc_shop_product_description` (
    `product_id` int(11) NOT NULL,
    `lang` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
    `name` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `keyword` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `description` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `content` text COLLATE utf8mb4_unicode_ci DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_shop_product_description`
  --
  
  INSERT INTO `sc_shop_product_description` (`product_id`, `lang`, `name`, `keyword`, `description`, `content`) VALUES
  (1, 'en', 'Easy Polo Black Edition 1', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (1, 'vi', 'Easy Polo Black Edition 1', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (2, 'en', 'Easy Polo Black Edition 2', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (2, 'vi', 'Easy Polo Black Edition 2', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (3, 'en', 'Easy Polo Black Edition 3', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (3, 'vi', 'Easy Polo Black Edition 3', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (4, 'en', 'Easy Polo Black Edition 4', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (4, 'vi', 'Easy Polo Black Edition 4', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (5, 'en', 'Easy Polo Black Edition 5', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (5, 'vi', 'Easy Polo Black Edition 5', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (6, 'en', 'Easy Polo Black Edition 6', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (6, 'vi', 'Easy Polo Black Edition 6', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (7, 'en', 'Easy Polo Black Edition 7', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (7, 'vi', 'Easy Polo Black Edition 7', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (8, 'en', 'Easy Polo Black Edition 8', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (8, 'vi', 'Easy Polo Black Edition 8', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (9, 'en', 'Easy Polo Black Edition 9', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (9, 'vi', 'Easy Polo Black Edition 9', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (10, 'en', 'Easy Polo Black Edition 10', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (10, 'vi', 'Easy Polo Black Edition 10', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (11, 'en', 'Easy Polo Black Edition 11', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (11, 'vi', 'Easy Polo Black Edition 11', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (12, 'en', 'Easy Polo Black Edition 12', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (12, 'vi', 'Easy Polo Black Edition 12', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (13, 'en', 'Easy Polo Black Edition 13', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (13, 'vi', 'Easy Polo Black Edition 13', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (14, 'en', 'Easy Polo Black Edition 14', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (14, 'vi', 'Easy Polo Black Edition 14', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (15, 'en', 'Easy Polo Black Edition 15', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (15, 'vi', 'Easy Polo Black Edition 15', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (16, 'en', 'Easy Polo Black Edition 16', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (16, 'vi', 'Easy Polo Black Edition 16', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (17, 'en', 'Easy Polo Black Edition 17', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>'),
  (17, 'vi', 'Easy Polo Black Edition 17', '', '', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.<img alt=\"\" src=\"/data/product/product-10.png\" style=\"width: 262px; height: 262px; float: right; margin: 10px;\" /></p>\n    <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>');
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_product_download`
  --
  
  CREATE TABLE `sc_shop_product_download` (
    `id` int(10) UNSIGNED NOT NULL,
    `product_id` int(11) NOT NULL,
    `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_product_group`
  --
  
  CREATE TABLE `sc_shop_product_group` (
    `group_id` int(11) NOT NULL,
    `product_id` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_shop_product_group`
  --
  
  INSERT INTO `sc_shop_product_group` (`group_id`, `product_id`) VALUES
  (16, 1),
  (16, 2);
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_product_image`
  --
  
  CREATE TABLE `sc_shop_product_image` (
    `id` int(10) UNSIGNED NOT NULL,
    `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `product_id` int(11) NOT NULL DEFAULT 0
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_shop_product_image`
  --
  
  INSERT INTO `sc_shop_product_image` (`id`, `image`, `product_id`) VALUES
  (1, '/data/product/product-2.png', 1),
  (2, '/data/product/product-11.png', 1),
  (3, '/data/product/product-8.png', 11),
  (4, '/data/product/product-6.png', 2),
  (5, '/data/product/product-13.png', 11),
  (6, '/data/product/product-12.png', 5),
  (7, '/data/product/product-6.png', 5),
  (8, '/data/product/product-1.png', 2),
  (9, '/data/product/product-15.png', 2),
  (10, '/data/product/product-5.png', 9),
  (11, '/data/product/product-8.png', 8),
  (12, '/data/product/product-2.png', 7),
  (13, '/data/product/product-6.png', 7),
  (14, '/data/product/product-11.png', 5),
  (15, '/data/product/product-13.png', 4),
  (16, '/data/product/product-13.png', 15),
  (17, '/data/product/product-6.png', 15),
  (18, '/data/product/product-12.png', 17),
  (19, '/data/product/product-6.png', 17),
  (20, '/data/product/product-2.png', 17);
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_product_promotion`
  --
  
  CREATE TABLE `sc_shop_product_promotion` (
    `product_id` int(11) NOT NULL,
    `price_promotion` int(11) NOT NULL,
    `date_start` datetime DEFAULT NULL,
    `date_end` datetime DEFAULT NULL,
    `status_promotion` int(11) NOT NULL DEFAULT 1,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_shop_product_promotion`
  --
  
  INSERT INTO `sc_shop_product_promotion` (`product_id`, `price_promotion`, `date_start`, `date_end`, `status_promotion`, `created_at`, `updated_at`) VALUES
  (1, 5000, NULL, NULL, 1, NULL, NULL),
  (2, 3000, NULL, NULL, 1, NULL, NULL),
  (11, 600, NULL, NULL, 1, NULL, NULL),
  (13, 4000, NULL, NULL, 1, NULL, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_product_property`
  --
  
  CREATE TABLE `sc_shop_product_property` (
    `id` int(10) UNSIGNED NOT NULL,
    `code` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_shop_product_property`
  --
  
  INSERT INTO `sc_shop_product_property` (`id`, `code`, `name`) VALUES
  (1, 'physical', 'Product physical'),
  (2, 'download', 'Product download');
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_sessions`
  --
  
  CREATE TABLE `sc_shop_sessions` (
    `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `customer_id` int(10) UNSIGNED DEFAULT NULL,
    `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `user_agent` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `payload` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `last_activity` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_shipping_standard`
  --
  
  CREATE TABLE `sc_shop_shipping_standard` (
    `id` int(10) UNSIGNED NOT NULL,
    `fee` int(11) NOT NULL,
    `shipping_free` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_shop_shipping_standard`
  --
  
  INSERT INTO `sc_shop_shipping_standard` (`id`, `fee`, `shipping_free`) VALUES
  (1, 20, 10000);
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_shipping_status`
  --
  
  CREATE TABLE `sc_shop_shipping_status` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_shop_shipping_status`
  --
  
  INSERT INTO `sc_shop_shipping_status` (`id`, `name`) VALUES
  (1, 'Not sent'),
  (2, 'Sending'),
  (3, 'Shipping done');
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_shoppingcart`
  --
  
  CREATE TABLE `sc_shop_shoppingcart` (
    `identifier` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `instance` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `content` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `store_id` int(11) NOT NULL DEFAULT 1
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_store_block`
  --
  
  CREATE TABLE `sc_shop_store_block` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `position` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `page` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `type` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
    `text` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `status` tinyint(4) NOT NULL DEFAULT 0,
    `sort` int(11) NOT NULL DEFAULT 0,
    `store_id` int(11) NOT NULL DEFAULT 1
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_shop_store_block`
  --
  
  INSERT INTO `sc_shop_store_block` (`id`, `name`, `position`, `page`, `type`, `text`, `status`, `sort`, `store_id`) VALUES
  (1, 'Facebook code', 'top', '*', 'html', '\n  <div id=\"fb-root\"></div>\n  <script>(function(d, s, id) {\n  var js, fjs = d.getElementsByTagName(s)[0];\n  if (d.getElementById(id)) return;\n  js = d.createElement(s); js.id = id;\n  js.src = \'//connect.facebook.net/vi_VN/sdk.js#xfbml=1&version=v2.8&appId=934208239994473\';\n  fjs.parentNode.insertBefore(js, fjs);\n  }(document, \'script\', \'facebook-jssdk\'));\n  </script>', 1, 0, 1),
  (2, 'Google Analytics', 'header', '*', 'html', '\n  <!-- Global site tag (gtag.js) - Google Analytics -->\n  <script async src=\"https://www.googletagmanager.com/gtag/js?id=UA-128658138-1\"></script>\n  <script>\n  window.dataLayer = window.dataLayer || [];\n  function gtag(){dataLayer.push(arguments);}\n  gtag(\'js\', new Date());\n  gtag(\'config\', \'UA-128658138-1\');\n  </script>', 1, 0, 1),
  (3, 'Product special', 'left', '*', 'view', 'product_special', 1, 1, 1),
  (4, 'Brands', 'left', '*', 'view', 'brands_left', 1, 3, 1),
  (5, 'Banner home', 'banner_top', 'home', 'view', 'banner_image', 1, 0, 1),
  (6, 'Categories', 'left', 'home,shop_home', 'view', 'categories', 1, 4, 1),
  (7, 'Product last view', 'left', '*', 'view', 'product_lastview', 1, 0, 1);
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_store_css`
  --
  
  CREATE TABLE `sc_shop_store_css` (
    `css` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `store_id` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_shop_store_css`
  --
  
  INSERT INTO `sc_shop_store_css` (`css`, `store_id`) VALUES
  ('\n.sc-overlay {\n  position: fixed;\n  top: 50%;\n  left: 50%;\n  transform: translate(-50%, -50%);\n  transform: -webkit-translate(-50%, -50%);\n  transform: -moz-translate(-50%, -50%);\n  transform: -ms-translate(-50%, -50%);\n  color:#1f222b;\n  z-index: 9999;\n  background: rgba(255,255,255,0.7);\n}\n  \n#sc-loading{\n  display: none;\n  position: absolute;\n  top: 0;\n  left: 0;\n  width: 100%;\n  height: 100%;\n  z-index: 50;\n  background: rgba(255,255,255,0.7);\n}\n/*end loading */\n  \n/*price*/\n.sc-new-price{\n  color:#FE980F;\n  font-size: 14px;\n  padding: 10px 5px;\n  font-weight:bold;\n  }\n  .sc-old-price {\n  text-decoration: line-through;\n  color: #a95d5d;\n  font-size: 13px;\n  padding: 10px;\n  }\n  /*end price*/\n.sc-product-build{\n  font-size: 20px;\n  font-weight: bold;\n}\n.sc-product-build img{\n  width: 50px;\n}\n.sc-product-group  img{\n  width: 100px;\n  cursor: pointer;\n  }\n.sc-product-group:hover{\n  box-shadow: 0px 0px 2px #999;\n}\n.sc-product-group:active{\n  box-shadow: 0px 0px 2px #ff00ff;\n}\n.sc-product-group.active{\n  box-shadow: 0px 0px 2px #ff00ff;\n}\n\n.sc-shipping-address td{\n  padding: 3px !important;\n}\n.sc-shipping-address textarea,\n.sc-shipping-address input[type=\"text\"],\n.sc-shipping-address option{\n  width: 100%;\n  padding: 7px !important;\n}\n.row_cart>td{\n  vertical-align: middle !important;\n}\ninput[type=\"number\"]{\n  text-align: center;\n  padding:2px;\n}\n.sc-notice{\n  clear: both;\n  clear: both;\n  font-size: 20px;\n  background: #f3f3f3;\n  width: 100%;\n}\nimg.new {\n  position: absolute;\n  right: 0px;\n  top: 0px;\n  padding: 0px !important;\n}\n.pointer {\n  cursor: pointer;\n}\n.add-to-cart-list {\n  padding: 5px 10px !important;\n  margin: 2px !important;\n  letter-spacing: 0px !important;\n  font-size: 12px !important;\n  border-radius: 5px;\n}\n.help-block {\n  font-size: 12px;\n  color: red;\n  font-style: italic;\n}\n                  ', 1);
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_subscribe`
  --
  
  CREATE TABLE `sc_shop_subscribe` (
    `id` int(10) UNSIGNED NOT NULL,
    `email` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
    `phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `content` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `status` tinyint(4) NOT NULL DEFAULT 1,
    `store_id` int(11) NOT NULL DEFAULT 1,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_supplier`
  --
  
  CREATE TABLE `sc_shop_supplier` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `alias` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `address` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `url` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `status` tinyint(4) NOT NULL DEFAULT 1,
    `store_id` int(11) NOT NULL DEFAULT 1,
    `sort` int(11) NOT NULL DEFAULT 0
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_shop_supplier`
  --
  
  INSERT INTO `sc_shop_supplier` (`id`, `name`, `alias`, `email`, `phone`, `image`, `address`, `url`, `status`, `store_id`, `sort`) VALUES
  (1, 'ABC distributor', 'abc-distributor', 'abc@abc.com', '012496657567', '/data/supplier/supplier.png', '', '', 1, 1, 0),
  (2, 'XYZ distributor', 'xyz-distributor', 'xyz@xyz.com', '012496657567', '/data/supplier/supplier.png', '', '', 1, 1, 0);
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_tax`
  --
  
  CREATE TABLE `sc_shop_tax` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `value` int(11) NOT NULL DEFAULT 0
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_shop_tax`
  --
  
  INSERT INTO `sc_shop_tax` (`id`, `name`, `value`) VALUES
  (1, 'Tax default (10%)', 10);
  
  -- --------------------------------------------------------
  
  --
  -- Cấu trúc bảng cho bảng `sc_shop_weight`
  --
  
  CREATE TABLE `sc_shop_weight` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `description` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Đang đổ dữ liệu cho bảng `sc_shop_weight`
  --
  
  INSERT INTO `sc_shop_weight` (`id`, `name`, `description`) VALUES
  (1, 'g', 'Gram'),
  (2, 'kg', 'Kilogram'),
  (3, 'lb', 'Pound '),
  (4, 'oz', 'Ounce ');
  
  --
  -- Chỉ mục cho các bảng đã đổ
  --
  
  --
  -- Chỉ mục cho bảng `failed_jobs`
  --
  ALTER TABLE `failed_jobs`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);
  
  --
  -- Chỉ mục cho bảng `jobs`
  --
  ALTER TABLE `jobs`
    ADD PRIMARY KEY (`id`),
    ADD KEY `jobs_queue_index` (`queue`);
  
  --
  -- Chỉ mục cho bảng `migrations`
  --
  ALTER TABLE `migrations`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Chỉ mục cho bảng `oauth_access_tokens`
  --
  ALTER TABLE `oauth_access_tokens`
    ADD PRIMARY KEY (`id`),
    ADD KEY `oauth_access_tokens_user_id_index` (`user_id`);
  
  --
  -- Chỉ mục cho bảng `oauth_auth_codes`
  --
  ALTER TABLE `oauth_auth_codes`
    ADD PRIMARY KEY (`id`),
    ADD KEY `oauth_auth_codes_user_id_index` (`user_id`);
  
  --
  -- Chỉ mục cho bảng `oauth_clients`
  --
  ALTER TABLE `oauth_clients`
    ADD PRIMARY KEY (`id`),
    ADD KEY `oauth_clients_user_id_index` (`user_id`);
  
  --
  -- Chỉ mục cho bảng `oauth_personal_access_clients`
  --
  ALTER TABLE `oauth_personal_access_clients`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Chỉ mục cho bảng `oauth_refresh_tokens`
  --
  ALTER TABLE `oauth_refresh_tokens`
    ADD PRIMARY KEY (`id`),
    ADD KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`);
  
  --
  -- Chỉ mục cho bảng `sc_admin_config`
  --
  ALTER TABLE `sc_admin_config`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `sc_admin_config_key_store_id_unique` (`key`,`store_id`),
    ADD KEY `sc_admin_config_code_index` (`code`);
  
  --
  -- Chỉ mục cho bảng `sc_admin_log`
  --
  ALTER TABLE `sc_admin_log`
    ADD PRIMARY KEY (`id`),
    ADD KEY `sc_admin_log_user_id_index` (`user_id`);
  
  --
  -- Chỉ mục cho bảng `sc_admin_menu`
  --
  ALTER TABLE `sc_admin_menu`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `sc_admin_menu_key_unique` (`key`);
  
  --
  -- Chỉ mục cho bảng `sc_admin_permission`
  --
  ALTER TABLE `sc_admin_permission`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `sc_admin_permission_name_unique` (`name`),
    ADD UNIQUE KEY `sc_admin_permission_slug_unique` (`slug`);
  
  --
  -- Chỉ mục cho bảng `sc_admin_role`
  --
  ALTER TABLE `sc_admin_role`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `sc_admin_role_slug_unique` (`slug`);
  
  --
  -- Chỉ mục cho bảng `sc_admin_role_permission`
  --
  ALTER TABLE `sc_admin_role_permission`
    ADD PRIMARY KEY (`role_id`,`permission_id`),
    ADD KEY `sc_admin_role_permission_role_id_permission_id_index` (`role_id`,`permission_id`);
  
  --
  -- Chỉ mục cho bảng `sc_admin_role_user`
  --
  ALTER TABLE `sc_admin_role_user`
    ADD KEY `sc_admin_role_user_role_id_user_id_index` (`role_id`,`user_id`);
  
  --
  -- Chỉ mục cho bảng `sc_admin_store`
  --
  ALTER TABLE `sc_admin_store`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `sc_admin_store_code_unique` (`code`),
    ADD KEY `sc_admin_store_domain_index` (`domain`),
    ADD KEY `sc_admin_store_partner_index` (`partner`);
  
  --
  -- Chỉ mục cho bảng `sc_admin_store_description`
  --
  ALTER TABLE `sc_admin_store_description`
    ADD PRIMARY KEY (`store_id`,`lang`),
    ADD KEY `sc_admin_store_description_lang_index` (`lang`);
  
  --
  -- Chỉ mục cho bảng `sc_admin_user`
  --
  ALTER TABLE `sc_admin_user`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `sc_admin_user_username_unique` (`username`),
    ADD UNIQUE KEY `sc_admin_user_email_unique` (`email`);
  
  --
  -- Chỉ mục cho bảng `sc_admin_user_permission`
  --
  ALTER TABLE `sc_admin_user_permission`
    ADD PRIMARY KEY (`user_id`,`permission_id`),
    ADD KEY `sc_admin_user_permission_user_id_permission_id_index` (`user_id`,`permission_id`);
  
  --
  -- Chỉ mục cho bảng `sc_admin_user_store`
  --
  ALTER TABLE `sc_admin_user_store`
    ADD PRIMARY KEY (`user_id`,`store_id`);
  
  --
  -- Chỉ mục cho bảng `sc_api_connection`
  --
  ALTER TABLE `sc_api_connection`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `sc_api_connection_apiconnection_unique` (`apiconnection`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_attribute_group`
  --
  ALTER TABLE `sc_shop_attribute_group`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_banner`
  --
  ALTER TABLE `sc_shop_banner`
    ADD PRIMARY KEY (`id`),
    ADD KEY `sc_shop_banner_type_index` (`type`),
    ADD KEY `sc_shop_banner_store_id_index` (`store_id`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_banner_type`
  --
  ALTER TABLE `sc_shop_banner_type`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `sc_shop_banner_type_code_unique` (`code`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_brand`
  --
  ALTER TABLE `sc_shop_brand`
    ADD PRIMARY KEY (`id`),
    ADD KEY `sc_shop_brand_alias_index` (`alias`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_category`
  --
  ALTER TABLE `sc_shop_category`
    ADD PRIMARY KEY (`id`),
    ADD KEY `sc_shop_category_alias_index` (`alias`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_category_description`
  --
  ALTER TABLE `sc_shop_category_description`
    ADD UNIQUE KEY `sc_shop_category_description_category_id_lang_unique` (`category_id`,`lang`),
    ADD KEY `sc_shop_category_description_lang_index` (`lang`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_country`
  --
  ALTER TABLE `sc_shop_country`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `sc_shop_country_code_unique` (`code`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_currency`
  --
  ALTER TABLE `sc_shop_currency`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `sc_shop_currency_code_unique` (`code`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_customer`
  --
  ALTER TABLE `sc_shop_customer`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `sc_shop_customer_email_provider_provider_id_unique` (`email`,`provider`,`provider_id`),
    ADD KEY `sc_shop_customer_address_id_index` (`address_id`),
    ADD KEY `sc_shop_customer_store_id_index` (`store_id`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_customer_address`
  --
  ALTER TABLE `sc_shop_customer_address`
    ADD PRIMARY KEY (`id`),
    ADD KEY `sc_shop_customer_address_customer_id_index` (`customer_id`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_custom_field`
  --
  ALTER TABLE `sc_shop_custom_field`
    ADD PRIMARY KEY (`id`),
    ADD KEY `sc_shop_custom_field_type_index` (`type`),
    ADD KEY `sc_shop_custom_field_code_index` (`code`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_custom_field_detail`
  --
  ALTER TABLE `sc_shop_custom_field_detail`
    ADD PRIMARY KEY (`id`),
    ADD KEY `sc_shop_custom_field_detail_custom_field_id_index` (`custom_field_id`),
    ADD KEY `sc_shop_custom_field_detail_rel_id_index` (`rel_id`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_email_template`
  --
  ALTER TABLE `sc_shop_email_template`
    ADD PRIMARY KEY (`id`),
    ADD KEY `sc_shop_email_template_store_id_index` (`store_id`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_language`
  --
  ALTER TABLE `sc_shop_language`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `sc_shop_language_code_unique` (`code`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_layout_page`
  --
  ALTER TABLE `sc_shop_layout_page`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `sc_shop_layout_page_key_unique` (`key`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_layout_position`
  --
  ALTER TABLE `sc_shop_layout_position`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `sc_shop_layout_position_key_unique` (`key`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_length`
  --
  ALTER TABLE `sc_shop_length`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `sc_shop_length_name_unique` (`name`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_link`
  --
  ALTER TABLE `sc_shop_link`
    ADD PRIMARY KEY (`id`),
    ADD KEY `sc_shop_link_store_id_index` (`store_id`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_news`
  --
  ALTER TABLE `sc_shop_news`
    ADD PRIMARY KEY (`id`),
    ADD KEY `sc_shop_news_alias_index` (`alias`),
    ADD KEY `sc_shop_news_store_id_index` (`store_id`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_news_description`
  --
  ALTER TABLE `sc_shop_news_description`
    ADD UNIQUE KEY `sc_shop_news_description_news_id_lang_unique` (`news_id`,`lang`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_order`
  --
  ALTER TABLE `sc_shop_order`
    ADD PRIMARY KEY (`id`),
    ADD KEY `sc_shop_order_customer_id_index` (`customer_id`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_order_detail`
  --
  ALTER TABLE `sc_shop_order_detail`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_order_history`
  --
  ALTER TABLE `sc_shop_order_history`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_order_status`
  --
  ALTER TABLE `sc_shop_order_status`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_order_total`
  --
  ALTER TABLE `sc_shop_order_total`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_page`
  --
  ALTER TABLE `sc_shop_page`
    ADD PRIMARY KEY (`id`),
    ADD KEY `sc_shop_page_alias_index` (`alias`),
    ADD KEY `sc_shop_page_store_id_index` (`store_id`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_page_description`
  --
  ALTER TABLE `sc_shop_page_description`
    ADD UNIQUE KEY `sc_shop_page_description_page_id_lang_unique` (`page_id`,`lang`),
    ADD KEY `sc_shop_page_description_lang_index` (`lang`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_password_resets`
  --
  ALTER TABLE `sc_shop_password_resets`
    ADD KEY `sc_shop_password_resets_email_index` (`email`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_payment_status`
  --
  ALTER TABLE `sc_shop_payment_status`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_product`
  --
  ALTER TABLE `sc_shop_product`
    ADD PRIMARY KEY (`id`),
    ADD KEY `sc_shop_product_sku_index` (`sku`),
    ADD KEY `sc_shop_product_brand_id_index` (`brand_id`),
    ADD KEY `sc_shop_product_supplier_id_index` (`supplier_id`),
    ADD KEY `sc_shop_product_kind_index` (`kind`),
    ADD KEY `sc_shop_product_property_index` (`property`),
    ADD KEY `sc_shop_product_tax_id_index` (`tax_id`),
    ADD KEY `sc_shop_product_status_index` (`status`),
    ADD KEY `sc_shop_product_alias_index` (`alias`),
    ADD KEY `sc_shop_product_category_store_id_index` (`category_store_id`),
    ADD KEY `sc_shop_product_store_id_index` (`store_id`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_product_attribute`
  --
  ALTER TABLE `sc_shop_product_attribute`
    ADD PRIMARY KEY (`id`),
    ADD KEY `sc_shop_product_attribute_product_id_attribute_group_id_index` (`product_id`,`attribute_group_id`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_product_build`
  --
  ALTER TABLE `sc_shop_product_build`
    ADD PRIMARY KEY (`build_id`,`product_id`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_product_category`
  --
  ALTER TABLE `sc_shop_product_category`
    ADD PRIMARY KEY (`product_id`,`category_id`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_product_description`
  --
  ALTER TABLE `sc_shop_product_description`
    ADD UNIQUE KEY `sc_shop_product_description_product_id_lang_unique` (`product_id`,`lang`),
    ADD KEY `sc_shop_product_description_lang_index` (`lang`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_product_download`
  --
  ALTER TABLE `sc_shop_product_download`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_product_group`
  --
  ALTER TABLE `sc_shop_product_group`
    ADD PRIMARY KEY (`group_id`,`product_id`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_product_image`
  --
  ALTER TABLE `sc_shop_product_image`
    ADD PRIMARY KEY (`id`),
    ADD KEY `sc_shop_product_image_product_id_index` (`product_id`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_product_promotion`
  --
  ALTER TABLE `sc_shop_product_promotion`
    ADD PRIMARY KEY (`product_id`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_product_property`
  --
  ALTER TABLE `sc_shop_product_property`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `sc_shop_product_property_code_unique` (`code`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_sessions`
  --
  ALTER TABLE `sc_shop_sessions`
    ADD UNIQUE KEY `sc_shop_sessions_id_unique` (`id`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_shipping_standard`
  --
  ALTER TABLE `sc_shop_shipping_standard`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_shipping_status`
  --
  ALTER TABLE `sc_shop_shipping_status`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_shoppingcart`
  --
  ALTER TABLE `sc_shop_shoppingcart`
    ADD KEY `sc_shop_shoppingcart_identifier_instance_index` (`identifier`,`instance`),
    ADD KEY `sc_shop_shoppingcart_store_id_index` (`store_id`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_store_block`
  --
  ALTER TABLE `sc_shop_store_block`
    ADD PRIMARY KEY (`id`),
    ADD KEY `sc_shop_store_block_store_id_index` (`store_id`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_store_css`
  --
  ALTER TABLE `sc_shop_store_css`
    ADD UNIQUE KEY `sc_shop_store_css_store_id_unique` (`store_id`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_subscribe`
  --
  ALTER TABLE `sc_shop_subscribe`
    ADD PRIMARY KEY (`id`),
    ADD KEY `sc_shop_subscribe_email_index` (`email`),
    ADD KEY `sc_shop_subscribe_store_id_index` (`store_id`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_supplier`
  --
  ALTER TABLE `sc_shop_supplier`
    ADD PRIMARY KEY (`id`),
    ADD KEY `sc_shop_supplier_alias_index` (`alias`),
    ADD KEY `sc_shop_supplier_store_id_index` (`store_id`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_tax`
  --
  ALTER TABLE `sc_shop_tax`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Chỉ mục cho bảng `sc_shop_weight`
  --
  ALTER TABLE `sc_shop_weight`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `sc_shop_weight_name_unique` (`name`);
  
  --
  -- AUTO_INCREMENT cho các bảng đã đổ
  --
  
  --
  -- AUTO_INCREMENT cho bảng `failed_jobs`
  --
  ALTER TABLE `failed_jobs`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT cho bảng `jobs`
  --
  ALTER TABLE `jobs`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT cho bảng `migrations`
  --
  ALTER TABLE `migrations`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT cho bảng `oauth_clients`
  --
  ALTER TABLE `oauth_clients`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT cho bảng `oauth_personal_access_clients`
  --
  ALTER TABLE `oauth_personal_access_clients`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_admin_config`
  --
  ALTER TABLE `sc_admin_config`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=124;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_admin_log`
  --
  ALTER TABLE `sc_admin_log`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_admin_menu`
  --
  ALTER TABLE `sc_admin_menu`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=69;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_admin_permission`
  --
  ALTER TABLE `sc_admin_permission`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_admin_role`
  --
  ALTER TABLE `sc_admin_role`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_admin_store`
  --
  ALTER TABLE `sc_admin_store`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_admin_user`
  --
  ALTER TABLE `sc_admin_user`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_api_connection`
  --
  ALTER TABLE `sc_api_connection`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_shop_attribute_group`
  --
  ALTER TABLE `sc_shop_attribute_group`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_shop_banner`
  --
  ALTER TABLE `sc_shop_banner`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_shop_banner_type`
  --
  ALTER TABLE `sc_shop_banner_type`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_shop_brand`
  --
  ALTER TABLE `sc_shop_brand`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_shop_category`
  --
  ALTER TABLE `sc_shop_category`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_shop_country`
  --
  ALTER TABLE `sc_shop_country`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=246;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_shop_currency`
  --
  ALTER TABLE `sc_shop_currency`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_shop_customer`
  --
  ALTER TABLE `sc_shop_customer`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_shop_customer_address`
  --
  ALTER TABLE `sc_shop_customer_address`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_shop_custom_field`
  --
  ALTER TABLE `sc_shop_custom_field`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_shop_custom_field_detail`
  --
  ALTER TABLE `sc_shop_custom_field_detail`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_shop_email_template`
  --
  ALTER TABLE `sc_shop_email_template`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_shop_language`
  --
  ALTER TABLE `sc_shop_language`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_shop_layout_page`
  --
  ALTER TABLE `sc_shop_layout_page`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_shop_layout_position`
  --
  ALTER TABLE `sc_shop_layout_position`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_shop_length`
  --
  ALTER TABLE `sc_shop_length`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_shop_link`
  --
  ALTER TABLE `sc_shop_link`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_shop_news`
  --
  ALTER TABLE `sc_shop_news`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_shop_order`
  --
  ALTER TABLE `sc_shop_order`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_shop_order_detail`
  --
  ALTER TABLE `sc_shop_order_detail`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_shop_order_history`
  --
  ALTER TABLE `sc_shop_order_history`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_shop_order_status`
  --
  ALTER TABLE `sc_shop_order_status`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_shop_order_total`
  --
  ALTER TABLE `sc_shop_order_total`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_shop_page`
  --
  ALTER TABLE `sc_shop_page`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_shop_payment_status`
  --
  ALTER TABLE `sc_shop_payment_status`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_shop_product`
  --
  ALTER TABLE `sc_shop_product`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_shop_product_attribute`
  --
  ALTER TABLE `sc_shop_product_attribute`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_shop_product_download`
  --
  ALTER TABLE `sc_shop_product_download`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_shop_product_image`
  --
  ALTER TABLE `sc_shop_product_image`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_shop_product_property`
  --
  ALTER TABLE `sc_shop_product_property`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_shop_shipping_standard`
  --
  ALTER TABLE `sc_shop_shipping_standard`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_shop_shipping_status`
  --
  ALTER TABLE `sc_shop_shipping_status`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_shop_store_block`
  --
  ALTER TABLE `sc_shop_store_block`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_shop_subscribe`
  --
  ALTER TABLE `sc_shop_subscribe`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_shop_supplier`
  --
  ALTER TABLE `sc_shop_supplier`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_shop_tax`
  --
  ALTER TABLE `sc_shop_tax`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT cho bảng `sc_shop_weight`
  --
  ALTER TABLE `sc_shop_weight`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  COMMIT;
  
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  