-- Dumping data for table `menu_locations`
--

INSERT INTO `menu_locations` VALUES (1,1,'main-menu','2026-05-07 01:57:53','2026-05-07 01:57:53'),(2,2,'footer-menu-1','2026-05-07 01:57:53','2026-05-07 01:57:53'),(3,3,'footer-menu-2','2026-05-07 01:57:53','2026-05-07 01:57:53'),(4,4,'main-menu','2026-05-07 01:57:58','2026-05-07 01:57:58'),(5,5,'footer-menu-1','2026-05-07 01:57:58','2026-05-07 01:57:58'),(6,6,'footer-menu-2','2026-05-07 01:57:58','2026-05-07 01:57:58'),(7,7,'main-menu','2026-05-07 01:57:58','2026-05-07 01:57:58'),(8,8,'footer-menu-1','2026-05-07 01:57:58','2026-05-07 01:57:58'),(9,9,'footer-menu-2','2026-05-07 01:57:58','2026-05-07 01:57:58'),(10,10,'main-menu','2026-05-07 01:57:58','2026-05-07 01:57:58'),(11,11,'footer-menu-1','2026-05-07 01:57:58','2026-05-07 01:57:58'),(12,12,'footer-menu-2','2026-05-07 01:57:58','2026-05-07 01:57:58'),(13,13,'main-menu','2026-05-07 01:57:58','2026-05-07 01:57:58'),(14,14,'footer-menu-1','2026-05-07 01:57:58','2026-05-07 01:57:58'),(15,15,'footer-menu-2','2026-05-07 01:57:58','2026-05-07 01:57:58');

--
-- Table structure for table `menu_nodes`
--

CREATE TABLE `menu_nodes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `menu_id` bigint unsigned NOT NULL,
  `parent_id` bigint unsigned NOT NULL DEFAULT '0',
  `reference_id` bigint unsigned DEFAULT NULL,
  `reference_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon_font` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `position` tinyint unsigned NOT NULL DEFAULT '0',
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `css_class` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `target` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '_self',
  `has_child` tinyint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `menu_nodes_menu_id_index` (`menu_id`),
  KEY `menu_nodes_parent_id_index` (`parent_id`),
  KEY `reference_id` (`reference_id`),
  KEY `reference_type` (`reference_type`)
) ENGINE=InnoDB AUTO_INCREMENT=178 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menu_nodes`
--

INSERT INTO `menu_nodes` VALUES (1,1,0,NULL,NULL,'https://amerce.botble.com',NULL,0,'Home','has-mega-menu','_self',1,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(2,1,1,NULL,NULL,'https://amerce.botble.com',NULL,0,'Main Demo',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(3,1,1,NULL,NULL,'https://amerce-mental.botble.com',NULL,1,'Home Mental',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(4,1,1,NULL,NULL,'https://amerce-electronics.botble.com',NULL,2,'Home Electronics',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(5,1,1,NULL,NULL,'https://amerce-pod.botble.com',NULL,3,'Home POD',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(6,1,1,NULL,NULL,'https://amerce-pet-care.botble.com',NULL,4,'Home Pet Care',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(7,1,1,NULL,NULL,'https://amerce-baby.botble.com',NULL,5,'Home Baby',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(8,1,1,NULL,NULL,'https://amerce-auto.botble.com',NULL,6,'Home Auto',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(9,1,1,NULL,NULL,'https://amerce-decor.botble.com',NULL,7,'Home Decor',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(10,1,1,NULL,NULL,'https://amerce-cosmetic.botble.com',NULL,8,'Home Cosmetic',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(11,1,1,NULL,NULL,'https://amerce-organic.botble.com',NULL,9,'Home Organic',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(12,1,1,NULL,NULL,'https://amerce-fashion.botble.com',NULL,10,'Home Fashion',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(13,1,1,NULL,NULL,'https://amerce-headphone.botble.com',NULL,11,'Home Headphone',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(14,1,1,NULL,NULL,'https://amerce-jewelry.botble.com',NULL,12,'Home Jewelry',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(15,1,1,NULL,NULL,'https://amerce-garden.botble.com',NULL,13,'Home Garden',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(16,1,1,NULL,NULL,'https://amerce-construct.botble.com',NULL,14,'Home Construct',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(17,1,1,NULL,NULL,'https://amerce-furniture.botble.com',NULL,15,'Home Furniture',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(18,1,1,NULL,NULL,'https://amerce-fashion-2.botble.com',NULL,16,'Home Fashion 2',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(19,1,1,NULL,NULL,'https://amerce-bag.botble.com',NULL,17,'Home Bag',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(20,1,1,NULL,NULL,'https://amerce-sport.botble.com',NULL,18,'Home Sport',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(21,1,1,NULL,NULL,'https://amerce-office.botble.com',NULL,19,'Home Office',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(22,1,1,NULL,NULL,'https://amerce-sneaker.botble.com',NULL,20,'Home Sneaker',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(23,1,0,NULL,NULL,'/products',NULL,1,'Shop','has-mega-menu','_self',1,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(24,1,23,NULL,NULL,'#',NULL,0,'Shop Layout',NULL,'_self',1,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(25,1,24,NULL,NULL,'/shop-default',NULL,0,'Default',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(26,1,24,NULL,NULL,'/shop-left-sidebar',NULL,1,'Left Sidebar',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(27,1,24,NULL,NULL,'/shop-right-sidebar',NULL,2,'Right Sidebar',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(28,1,24,NULL,NULL,'/shop-full-width',NULL,3,'Full Width',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(29,1,24,NULL,NULL,'/collections',NULL,4,'Collection List',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(30,1,24,NULL,NULL,'/shop-sub-collection',NULL,5,'Sub Collection',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(31,1,23,NULL,NULL,'#',NULL,1,'Browse',NULL,'_self',1,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(32,1,31,NULL,NULL,'/products',NULL,0,'All Products',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(33,1,31,NULL,NULL,'/products?source=latest',NULL,1,'New Arrivals',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(34,1,31,NULL,NULL,'/products?sort=best-seller',NULL,2,'Best Sellers',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(35,1,31,NULL,NULL,'/products?source=featured',NULL,3,'Featured',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(36,1,31,NULL,NULL,'/products?on_sale=1',NULL,4,'On Sale',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(37,1,0,NULL,NULL,'/products',NULL,2,'Product','has-mega-menu','_self',1,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(38,1,37,NULL,NULL,'#',NULL,0,'Product Layout',NULL,'_self',1,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(39,1,38,NULL,NULL,'/product-default',NULL,0,'Product Default',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(40,1,38,NULL,NULL,'/product-right-thumbnail',NULL,1,'Right Thumbnail',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(41,1,38,NULL,NULL,'/product-bottom-thumbnail',NULL,2,'Bottom Thumbnail',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(42,1,38,NULL,NULL,'/product-grid',NULL,3,'Product Grid',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(43,1,38,NULL,NULL,'/product-grid-2',NULL,4,'Product Grid 2',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(44,1,38,NULL,NULL,'/product-stacked',NULL,5,'Product Stacked',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(45,1,38,NULL,NULL,'/product-description-accordion',NULL,6,'Description Accordion',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(46,1,0,NULL,NULL,'/blog',NULL,3,'Blog',NULL,'_self',1,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(47,1,46,NULL,NULL,'/blog',NULL,0,'Blog',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(48,1,46,NULL,NULL,'/blog',NULL,1,'Blog Single',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(49,1,0,NULL,NULL,'/about',NULL,4,'Pages',NULL,'_self',1,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(50,1,49,NULL,NULL,'/about',NULL,0,'About Us',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(51,1,49,NULL,NULL,'/contact',NULL,1,'Contact Us',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(52,1,49,NULL,NULL,'/our-stores',NULL,2,'Our Store',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(53,1,49,NULL,NULL,'/orders/tracking',NULL,3,'Invoice',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(54,1,49,NULL,NULL,'/page-not-found',NULL,4,'404',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(55,1,49,NULL,NULL,'/compare',NULL,5,'Compare',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(56,1,49,NULL,NULL,'/customer/overview',NULL,6,'My Account',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(57,2,0,NULL,NULL,'/shipping',NULL,0,'Shipping',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(58,2,0,NULL,NULL,'/returns-refunds',NULL,1,'Return & Refund',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(59,2,0,NULL,NULL,'/privacy-policy',NULL,2,'Privacy Policy',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(60,2,0,NULL,NULL,'/faq',NULL,3,'Orders FAQs',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(61,3,0,NULL,NULL,'/about',NULL,0,'About Us',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(62,3,0,NULL,NULL,'/our-stores',NULL,1,'Our Stories',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(63,3,0,NULL,NULL,'/contact',NULL,2,'Contact us',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(64,3,0,NULL,NULL,'/blog',NULL,3,'Latest New',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(65,3,0,NULL,NULL,'/customer/overview',NULL,4,'My Account',NULL,'_self',0,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(66,4,0,NULL,NULL,'/',NULL,0,'Trang chủ',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(67,4,0,NULL,NULL,'/products',NULL,1,'Mua sắm',NULL,'_self',1,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(68,4,67,NULL,NULL,'/products?source=latest',NULL,0,'Hàng mới về',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(69,4,67,NULL,NULL,'/products?sort=best-seller',NULL,1,'Bán chạy nhất',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(70,4,67,NULL,NULL,'/products?on_sale=1',NULL,2,'Giảm giá',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(71,4,67,NULL,NULL,'/products',NULL,3,'Tất cả sản phẩm',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(72,4,0,NULL,NULL,'/products',NULL,2,'Danh mục',NULL,'_self',1,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(73,4,72,NULL,NULL,'/product-categories/outerwear',NULL,0,'Áo khoác',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(74,4,72,NULL,NULL,'/product-categories/tops-shirts',NULL,1,'Áo & Sơ mi',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(75,4,72,NULL,NULL,'/product-categories/bottoms',NULL,2,'Quần & Váy',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(76,4,72,NULL,NULL,'/product-categories/dresses',NULL,3,'Đầm',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(77,4,72,NULL,NULL,'/product-categories/footwear',NULL,4,'Giày dép',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(78,4,72,NULL,NULL,'/product-categories/accessories',NULL,5,'Phụ kiện',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(79,4,0,NULL,NULL,'/brands',NULL,3,'Thương hiệu',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(80,4,0,NULL,NULL,'/blog',NULL,4,'Tạp chí',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(81,4,0,NULL,NULL,'/about',NULL,5,'Giới thiệu',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(82,4,0,NULL,NULL,'/contact',NULL,6,'Liên hệ',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(83,5,0,NULL,NULL,'/contact',NULL,0,'Liên hệ với chúng tôi',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(84,5,0,NULL,NULL,'/faq',NULL,1,'Câu hỏi thường gặp',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(85,5,0,NULL,NULL,'/shipping',NULL,2,'Vận chuyển',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(86,5,0,NULL,NULL,'/returns-refunds',NULL,3,'Đổi trả & Hoàn tiền',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(87,5,0,NULL,NULL,'/customer/orders',NULL,4,'Theo dõi đơn hàng',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(88,6,0,NULL,NULL,'/about',NULL,0,'Giới thiệu',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(89,6,0,NULL,NULL,'/our-stores',NULL,1,'Cửa hàng',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(90,6,0,NULL,NULL,'/sustainability',NULL,2,'Phát triển bền vững',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(91,6,0,NULL,NULL,'/careers',NULL,3,'Tuyển dụng',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(92,6,0,NULL,NULL,'/privacy-policy',NULL,4,'Chính sách bảo mật',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(93,6,0,NULL,NULL,'/terms-conditions',NULL,5,'Điều khoản & Điều kiện',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(94,7,0,NULL,NULL,'/',NULL,0,'الرئيسية',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(95,7,0,NULL,NULL,'/products',NULL,1,'تسوّق',NULL,'_self',1,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(96,7,95,NULL,NULL,'/products?source=latest',NULL,0,'وصل حديثاً',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(97,7,95,NULL,NULL,'/products?sort=best-seller',NULL,1,'الأكثر مبيعاً',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(98,7,95,NULL,NULL,'/products?on_sale=1',NULL,2,'تخفيضات',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(99,7,95,NULL,NULL,'/products',NULL,3,'جميع المنتجات',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(100,7,0,NULL,NULL,'/products',NULL,2,'التصنيفات',NULL,'_self',1,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(101,7,100,NULL,NULL,'/product-categories/outerwear',NULL,0,'الملابس الخارجية',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(102,7,100,NULL,NULL,'/product-categories/tops-shirts',NULL,1,'البلوزات والقمصان',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(103,7,100,NULL,NULL,'/product-categories/bottoms',NULL,2,'البناطيل والتنانير',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(104,7,100,NULL,NULL,'/product-categories/dresses',NULL,3,'الفساتين',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(105,7,100,NULL,NULL,'/product-categories/footwear',NULL,4,'الأحذية',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(106,7,100,NULL,NULL,'/product-categories/accessories',NULL,5,'الإكسسوارات',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(107,7,0,NULL,NULL,'/brands',NULL,3,'العلامات التجارية',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(108,7,0,NULL,NULL,'/blog',NULL,4,'المدوّنة',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(109,7,0,NULL,NULL,'/about',NULL,5,'من نحن',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(110,7,0,NULL,NULL,'/contact',NULL,6,'تواصل معنا',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(111,8,0,NULL,NULL,'/contact',NULL,0,'تواصل معنا',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(112,8,0,NULL,NULL,'/faq',NULL,1,'الأسئلة الشائعة',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(113,8,0,NULL,NULL,'/shipping',NULL,2,'الشحن',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(114,8,0,NULL,NULL,'/returns-refunds',NULL,3,'الإرجاع والاسترداد',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(115,8,0,NULL,NULL,'/customer/orders',NULL,4,'تتبّع الطلب',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(116,9,0,NULL,NULL,'/about',NULL,0,'من نحن',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(117,9,0,NULL,NULL,'/our-stores',NULL,1,'متاجرنا',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(118,9,0,NULL,NULL,'/sustainability',NULL,2,'الاستدامة',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(119,9,0,NULL,NULL,'/careers',NULL,3,'الوظائف',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(120,9,0,NULL,NULL,'/privacy-policy',NULL,4,'سياسة الخصوصية',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(121,9,0,NULL,NULL,'/terms-conditions',NULL,5,'الشروط والأحكام',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(122,10,0,NULL,NULL,'/',NULL,0,'Accueil',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(123,10,0,NULL,NULL,'/products',NULL,1,'Boutique',NULL,'_self',1,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(124,10,123,NULL,NULL,'/products?source=latest',NULL,0,'Nouveautés',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(125,10,123,NULL,NULL,'/products?sort=best-seller',NULL,1,'Meilleures ventes',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(126,10,123,NULL,NULL,'/products?on_sale=1',NULL,2,'Promotions',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(127,10,123,NULL,NULL,'/products',NULL,3,'Tous les produits',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(128,10,0,NULL,NULL,'/products',NULL,2,'Catégories',NULL,'_self',1,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(129,10,128,NULL,NULL,'/product-categories/outerwear',NULL,0,'Vêtements d\'extérieur',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(130,10,128,NULL,NULL,'/product-categories/tops-shirts',NULL,1,'Hauts & chemises',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(131,10,128,NULL,NULL,'/product-categories/bottoms',NULL,2,'Bas',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(132,10,128,NULL,NULL,'/product-categories/dresses',NULL,3,'Robes',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(133,10,128,NULL,NULL,'/product-categories/footwear',NULL,4,'Chaussures',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(134,10,128,NULL,NULL,'/product-categories/accessories',NULL,5,'Accessoires',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(135,10,0,NULL,NULL,'/brands',NULL,3,'Marques',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(136,10,0,NULL,NULL,'/blog',NULL,4,'Journal',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(137,10,0,NULL,NULL,'/about',NULL,5,'À propos',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(138,10,0,NULL,NULL,'/contact',NULL,6,'Contact',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(139,11,0,NULL,NULL,'/contact',NULL,0,'Nous contacter',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(140,11,0,NULL,NULL,'/faq',NULL,1,'FAQ',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(141,11,0,NULL,NULL,'/shipping',NULL,2,'Livraison',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(142,11,0,NULL,NULL,'/returns-refunds',NULL,3,'Retours & remboursements',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(143,11,0,NULL,NULL,'/customer/orders',NULL,4,'Suivi de commande',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(144,12,0,NULL,NULL,'/about',NULL,0,'À propos',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(145,12,0,NULL,NULL,'/our-stores',NULL,1,'Nos boutiques',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(146,12,0,NULL,NULL,'/sustainability',NULL,2,'Durabilité',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(147,12,0,NULL,NULL,'/careers',NULL,3,'Recrutement',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(148,12,0,NULL,NULL,'/privacy-policy',NULL,4,'Politique de confidentialité',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(149,12,0,NULL,NULL,'/terms-conditions',NULL,5,'Conditions générales',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(150,13,0,NULL,NULL,'/',NULL,0,'Beranda',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(151,13,0,NULL,NULL,'/products',NULL,1,'Belanja',NULL,'_self',1,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(152,13,151,NULL,NULL,'/products?source=latest',NULL,0,'Baru Datang',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(153,13,151,NULL,NULL,'/products?sort=best-seller',NULL,1,'Terlaris',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(154,13,151,NULL,NULL,'/products?on_sale=1',NULL,2,'Diskon',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(155,13,151,NULL,NULL,'/products',NULL,3,'Semua Produk',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(156,13,0,NULL,NULL,'/products',NULL,2,'Kategori',NULL,'_self',1,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(157,13,156,NULL,NULL,'/product-categories/outerwear',NULL,0,'Outerwear',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(158,13,156,NULL,NULL,'/product-categories/tops-shirts',NULL,1,'Atasan & Kemeja',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(159,13,156,NULL,NULL,'/product-categories/bottoms',NULL,2,'Bawahan',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(160,13,156,NULL,NULL,'/product-categories/dresses',NULL,3,'Dress',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(161,13,156,NULL,NULL,'/product-categories/footwear',NULL,4,'Alas Kaki',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(162,13,156,NULL,NULL,'/product-categories/accessories',NULL,5,'Aksesori',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(163,13,0,NULL,NULL,'/brands',NULL,3,'Merek',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(164,13,0,NULL,NULL,'/blog',NULL,4,'Jurnal',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(165,13,0,NULL,NULL,'/about',NULL,5,'Tentang Kami',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(166,13,0,NULL,NULL,'/contact',NULL,6,'Kontak',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(167,14,0,NULL,NULL,'/contact',NULL,0,'Hubungi Kami',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(168,14,0,NULL,NULL,'/faq',NULL,1,'Pertanyaan Umum',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(169,14,0,NULL,NULL,'/shipping',NULL,2,'Pengiriman',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(170,14,0,NULL,NULL,'/returns-refunds',NULL,3,'Pengembalian & Refund',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(171,14,0,NULL,NULL,'/customer/orders',NULL,4,'Lacak Pesanan',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(172,15,0,NULL,NULL,'/about',NULL,0,'Tentang Kami',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(173,15,0,NULL,NULL,'/our-stores',NULL,1,'Toko Kami',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(174,15,0,NULL,NULL,'/sustainability',NULL,2,'Keberlanjutan',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(175,15,0,NULL,NULL,'/careers',NULL,3,'Karier',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(176,15,0,NULL,NULL,'/privacy-policy',NULL,4,'Kebijakan Privasi',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58'),(177,15,0,NULL,NULL,'/terms-conditions',NULL,5,'Syarat & Ketentuan',NULL,'_self',0,'2026-05-07 01:57:58','2026-05-07 01:57:58');

--
-- Table structure for table `menus`
--

CREATE TABLE `menus` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `menus_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menus`
--

INSERT INTO `menus` VALUES (1,'Main Menu','main-menu','published','2026-05-07 01:57:53','2026-05-07 01:57:53'),(2,'Footer Help','footer-help','published','2026-05-07 01:57:53','2026-05-07 01:57:53'),(3,'Footer Company','footer-company','published','2026-05-07 01:57:53','2026-05-07 01:57:53'),(4,'Menu chính','main-menu-vi','published','2026-05-07 01:57:58','2026-05-07 01:57:58'),(5,'Hỗ trợ','footer-help-vi','published','2026-05-07 01:57:58','2026-05-07 01:57:58'),(6,'Công ty','footer-company-vi','published','2026-05-07 01:57:58','2026-05-07 01:57:58'),(7,'القائمة الرئيسية','main-menu-ar','published','2026-05-07 01:57:58','2026-05-07 01:57:58'),(8,'المساعدة','footer-help-ar','published','2026-05-07 01:57:58','2026-05-07 01:57:58'),(9,'الشركة','footer-company-ar','published','2026-05-07 01:57:58','2026-05-07 01:57:58'),(10,'Menu principal','main-menu-fr','published','2026-05-07 01:57:58','2026-05-07 01:57:58'),(11,'Aide','footer-help-fr','published','2026-05-07 01:57:58','2026-05-07 01:57:58'),(12,'Société','footer-company-fr','published','2026-05-07 01:57:58','2026-05-07 01:57:58'),(13,'Menu Utama','main-menu-id','published','2026-05-07 01:57:58','2026-05-07 01:57:58'),(14,'Bantuan','footer-help-id','published','2026-05-07 01:57:58','2026-05-07 01:57:58'),(15,'Perusahaan','footer-company-id','published','2026-05-07 01:57:58','2026-05-07 01:57:58');

--
-- Table structure for table `meta_boxes`
--

CREATE TABLE `meta_boxes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_value` text COLLATE utf8mb4_unicode_ci,
  `reference_id` bigint unsigned NOT NULL,
  `reference_type` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `meta_boxes_reference_id_index` (`reference_id`),
  KEY `meta_boxes_ref_idx` (`reference_id`,`reference_type`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `meta_boxes`
--

INSERT INTO `meta_boxes` VALUES (1,'subtitle','[\"Discover the Art of Modern Activewear\"]',1,'Botble\\SimpleSlider\\Models\\SimpleSliderItem','2026-05-07 01:57:53','2026-05-07 01:57:53'),(2,'button_label','[\"Shop Styles\"]',1,'Botble\\SimpleSlider\\Models\\SimpleSliderItem','2026-05-07 01:57:53','2026-05-07 01:57:53'),(3,'alignment','[\"center\"]',1,'Botble\\SimpleSlider\\Models\\SimpleSliderItem','2026-05-07 01:57:53','2026-05-07 01:57:53'),(4,'subtitle','[\"Engineered for Movement\"]',2,'Botble\\SimpleSlider\\Models\\SimpleSliderItem','2026-05-07 01:57:53','2026-05-07 01:57:53'),(5,'button_label','[\"Shop Styles\"]',2,'Botble\\SimpleSlider\\Models\\SimpleSliderItem','2026-05-07 01:57:53','2026-05-07 01:57:53'),(6,'alignment','[\"center\"]',2,'Botble\\SimpleSlider\\Models\\SimpleSliderItem','2026-05-07 01:57:53','2026-05-07 01:57:53'),(7,'subtitle','[\"Performance Meets Style\"]',3,'Botble\\SimpleSlider\\Models\\SimpleSliderItem','2026-05-07 01:57:53','2026-05-07 01:57:53'),(8,'button_label','[\"Shop Styles\"]',3,'Botble\\SimpleSlider\\Models\\SimpleSliderItem','2026-05-07 01:57:53','2026-05-07 01:57:53'),(9,'alignment','[\"center\"]',3,'Botble\\SimpleSlider\\Models\\SimpleSliderItem','2026-05-07 01:57:53','2026-05-07 01:57:53'),(10,'faq_ids','[[1,3,7,9,12]]',1,'Botble\\Ecommerce\\Models\\Product','2026-05-07 01:57:54','2026-05-07 01:57:54'),(11,'faq_ids','[[4,5,9,12,13]]',2,'Botble\\Ecommerce\\Models\\Product','2026-05-07 01:57:54','2026-05-07 01:57:54'),(12,'faq_ids','[[1,4,7,9,10]]',3,'Botble\\Ecommerce\\Models\\Product','2026-05-07 01:57:54','2026-05-07 01:57:54'),(13,'faq_ids','[[5,7,9,10,12]]',4,'Botble\\Ecommerce\\Models\\Product','2026-05-07 01:57:54','2026-05-07 01:57:54'),(14,'faq_ids','[[4,6,9,11,13]]',5,'Botble\\Ecommerce\\Models\\Product','2026-05-07 01:57:54','2026-05-07 01:57:54'),(15,'faq_ids','[[1,4,6,8,13]]',6,'Botble\\Ecommerce\\Models\\Product','2026-05-07 01:57:54','2026-05-07 01:57:54'),(16,'faq_ids','[[1,3,4,11,12]]',7,'Botble\\Ecommerce\\Models\\Product','2026-05-07 01:57:54','2026-05-07 01:57:54');

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

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=334 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` VALUES (1,'0001_01_01_000001_create_cache_table',1),(2,'2013_04_09_032329_create_base_tables',1),(3,'2013_04_09_062329_create_revisions_table',1),(4,'2014_10_12_000000_create_users_table',1),(5,'2014_10_12_100000_create_password_reset_tokens_table',1),(6,'2015_06_18_033822_create_blog_table',1),(7,'2015_06_29_025744_create_audit_history',1),(8,'2016_05_28_112028_create_system_request_logs_table',1),(9,'2016_06_10_230148_create_acl_tables',1),(10,'2016_06_14_230857_create_menus_table',1),(11,'2016_06_17_091537_create_contacts_table',1),(12,'2016_06_28_221418_create_pages_table',1),(13,'2016_10_03_032336_create_languages_table',1),(14,'2016_10_05_074239_create_setting_table',1),(15,'2016_10_07_193005_create_translations_table',1),(16,'2016_10_13_150201_create_galleries_table',1),(17,'2016_11_28_032840_create_dashboard_widget_tables',1),(18,'2016_12_16_084601_create_widgets_table',1),(19,'2017_05_09_070343_create_media_tables',1),(20,'2017_05_18_080441_create_payment_tables',1),(21,'2017_07_11_140018_create_simple_slider_table',1),(22,'2017_10_24_154832_create_newsletter_table',1),(23,'2017_11_03_070450_create_slug_table',1),(24,'2018_07_09_214610_create_testimonial_table',1),(25,'2018_07_09_221238_create_faq_table',1),(26,'2019_01_05_053554_create_jobs_table',1),(27,'2019_08_19_000000_create_failed_jobs_table',1),(28,'2019_11_18_061011_create_country_table',1),(29,'2019_12_14_000001_create_personal_access_tokens_table',1),(30,'2020_03_05_041139_create_ecommerce_tables',1),(31,'2020_11_18_150916_ads_create_ads_table',1),(32,'2021_01_01_044147_ecommerce_create_flash_sale_table',1),(33,'2021_01_17_082713_add_column_is_featured_to_product_collections_table',1),(34,'2021_01_18_024333_add_zip_code_into_table_customer_addresses',1),(35,'2021_02_16_092633_remove_default_value_for_author_type',1),(36,'2021_02_18_073505_update_table_ec_reviews',1),(37,'2021_03_10_024419_add_column_confirmed_at_to_table_ec_customers',1),(38,'2021_03_10_025153_change_column_tax_amount',1),(39,'2021_03_20_033103_add_column_availability_to_table_ec_products',1),(40,'2021_03_27_144913_add_customer_type_into_table_payments',1),(41,'2021_04_28_074008_ecommerce_create_product_label_table',1),(42,'2021_05_24_034720_make_column_currency_nullable',1),(43,'2021_05_31_173037_ecommerce_create_ec_products_translations',1),(44,'2021_07_06_030002_create_marketplace_table',1),(45,'2021_08_09_161302_add_metadata_column_to_payments_table',1),(46,'2021_08_17_105016_remove_column_currency_id_in_some_tables',1),(47,'2021_08_30_142128_add_images_column_to_ec_reviews_table',1),(48,'2021_09_04_150137_add_vendor_verified_at_to_ec_customers_table',1),(49,'2021_10_04_030050_add_column_created_by_to_table_ec_products',1),(50,'2021_10_04_033903_add_column_approved_by_into_table_ec_products',1),(51,'2021_10_05_122616_add_status_column_to_ec_customers_table',1),(52,'2021_10_06_124943_add_transaction_id_column_to_mp_customer_withdrawals_table',1),(53,'2021_10_10_054216_add_columns_to_mp_customer_revenues_table',1),(54,'2021_10_19_020859_update_metadata_field',1),(55,'2021_10_25_021023_fix-priority-load-for-language-advanced',1),(56,'2021_11_03_025806_nullable_phone_number_in_ec_customer_addresses',1),(57,'2021_11_23_071403_correct_languages_for_product_variations',1),(58,'2021_11_28_031808_add_product_tags_translations',1),(59,'2021_12_01_031123_add_featured_image_to_ec_products',1),(60,'2021_12_02_035301_add_ads_translations_table',1),(61,'2021_12_03_030600_create_blog_translations',1),(62,'2021_12_03_075608_create_page_translations',1),(63,'2021_12_03_082134_create_faq_translations',1),(64,'2021_12_03_082953_create_gallery_translations',1),(65,'2021_12_03_083642_create_testimonials_translations',1),(66,'2021_12_03_084118_create_location_translations',1),(67,'2021_12_03_094518_migrate_old_location_data',1),(68,'2021_12_06_031304_update_table_mp_customer_revenues',1),(69,'2021_12_10_034440_switch_plugin_location_to_use_language_advanced',1),(70,'2022_01_01_033107_update_table_ec_shipments',1),(71,'2022_01_16_085908_improve_plugin_location',1),(72,'2022_02_16_042457_improve_product_attribute_sets',1),(73,'2022_03_22_075758_correct_product_name',1),(74,'2022_04_19_113334_add_index_to_ec_products',1),(75,'2022_04_19_113923_add_index_to_table_posts',1),(76,'2022_04_20_100851_add_index_to_media_table',1),(77,'2022_04_20_101046_add_index_to_menu_table',1),(78,'2022_04_28_144405_remove_unused_table',1),(79,'2022_04_30_034048_create_gallery_meta_translations_table',1),(80,'2022_05_05_115015_create_ec_customer_recently_viewed_products_table',1),(81,'2022_05_18_143720_add_index_to_table_ec_product_categories',1),(82,'2022_06_16_095633_add_index_to_some_tables',1),(83,'2022_06_28_151901_activate_paypal_stripe_plugin',1),(84,'2022_06_30_035148_create_order_referrals_table',1),(85,'2022_07_07_153354_update_charge_id_in_table_payments',1),(86,'2022_07_10_034813_move_lang_folder_to_root',1),(87,'2022_07_24_153815_add_completed_at_to_ec_orders_table',1),(88,'2022_08_04_051940_add_missing_column_expires_at',1),(89,'2022_08_04_052122_delete_location_backup_tables',1),(90,'2022_08_14_032836_create_ec_order_returns_table',1),(91,'2022_08_14_033554_create_ec_order_return_items_table',1),(92,'2022_08_15_040324_add_billing_address',1),(93,'2022_08_30_091114_support_digital_products_table',1),(94,'2022_09_01_000001_create_admin_notifications_tables',1),(95,'2022_09_13_095744_create_options_table',1),(96,'2022_09_13_104347_create_option_value_table',1),(97,'2022_10_05_163518_alter_table_ec_order_product',1),(98,'2022_10_12_041517_create_invoices_table',1),(99,'2022_10_12_142226_update_orders_table',1),(100,'2022_10_13_024916_update_table_order_returns',1),(101,'2022_10_14_024629_drop_column_is_featured',1),(102,'2022_10_19_152916_add_columns_to_mp_stores_table',1),(103,'2022_10_20_062849_create_mp_category_sale_commissions_table',1),(104,'2022_10_21_030830_update_columns_in_ec_shipments_table',1),(105,'2022_10_28_021046_update_columns_in_ec_shipments_table',1),(106,'2022_11_02_071413_add_more_info_for_store',1),(107,'2022_11_02_080444_add_tax_info',1),(108,'2022_11_16_034522_update_type_column_in_ec_shipping_rules_table',1),(109,'2022_11_18_063357_add_missing_timestamp_in_table_settings',1),(110,'2022_11_19_041643_add_ec_tax_product_table',1),(111,'2022_12_02_093615_update_slug_index_columns',1),(112,'2022_12_12_063830_update_tax_defadult_in_ec_tax_products_table',1),(113,'2022_12_17_041532_fix_address_in_order_invoice',1),(114,'2022_12_26_070329_create_ec_product_views_table',1),(115,'2023_01_04_033051_fix_product_categories',1),(116,'2023_01_09_050400_add_ec_global_options_translations_table',1),(117,'2023_01_10_093754_add_missing_option_value_id',1),(118,'2023_01_17_082713_add_column_barcode_and_cost_per_item_to_product_table',1),(119,'2023_01_26_021854_add_ec_customer_used_coupons_table',1),(120,'2023_01_30_024431_add_alt_to_media_table',1),(121,'2023_02_01_062030_add_store_translations',1),(122,'2023_02_08_015900_update_options_column_in_ec_order_product_table',1),(123,'2023_02_13_032133_update_fee_column_mp_customer_revenues_table',1),(124,'2023_02_16_042611_drop_table_password_resets',1),(125,'2023_02_17_023648_fix_store_prefix',1),(126,'2023_02_27_095752_remove_duplicate_reviews',1),(127,'2023_03_20_115757_add_user_type_column_to_ec_shipment_histories_table',1),(128,'2023_04_17_062645_add_open_in_new_tab',1),(129,'2023_04_21_082427_create_ec_product_categorizables_table',1),(130,'2023_04_23_005903_add_column_permissions_to_admin_notifications',1),(131,'2023_04_23_061847_increase_state_translations_abbreviation_column',1),(132,'2023_05_03_011331_add_missing_column_price_into_invoice_items_table',1),(133,'2023_05_10_075124_drop_column_id_in_role_users_table',1),(134,'2023_05_17_025812_fix_invoice_issue',1),(135,'2023_05_26_073140_move_option_make_phone_field_optional_at_checkout_page_to_mandatory_fields',1),(136,'2023_05_27_144611_fix_exchange_rate_setting',1),(137,'2023_06_22_084331_add_generate_license_code_to_ec_products_table',1),(138,'2023_06_30_042512_create_ec_order_tax_information_table',1),(139,'2023_07_06_011444_create_slug_translations_table',1),(140,'2023_07_14_022724_remove_column_id_from_ec_product_collection_products',1),(141,'2023_07_26_041451_add_more_columns_to_location_table',1),(142,'2023_07_27_041451_add_more_columns_to_location_translation_table',1),(143,'2023_08_09_012940_remove_column_status_in_ec_product_attributes',1),(144,'2023_08_11_060908_create_announcements_table',1),(145,'2023_08_15_064505_create_ec_tax_rules_table',1),(146,'2023_08_15_073307_drop_unique_in_states_cities_translations',1),(147,'2023_08_21_021819_make_column_address_in_ec_customer_addresses_nullable',1),(148,'2023_08_21_090810_make_page_content_nullable',1),(149,'2023_08_22_094114_drop_unique_for_barcode',1),(150,'2023_08_29_074620_make_column_author_id_nullable',1),(151,'2023_08_29_075308_make_column_user_id_nullable',1),(152,'2023_08_30_031811_add_apply_via_url_column_to_ec_discounts_table',1),(153,'2023_09_07_094312_add_index_to_product_sku_and_translations',1),(154,'2023_09_14_021936_update_index_for_slugs_table',1),(155,'2023_09_14_022423_add_index_for_language_table',1),(156,'2023_09_19_024955_create_discount_product_categories_table',1),(157,'2023_10_17_070728_add_icon_and_icon_image_to_product_categories_table',1),(158,'2023_10_21_065016_make_state_id_in_table_cities_nullable',1),(159,'2023_11_07_023805_add_tablet_mobile_image',1),(160,'2023_11_10_080225_migrate_contact_blacklist_email_domains_to_core',1),(161,'2023_11_14_033417_change_request_column_in_table_audit_histories',1),(162,'2023_11_17_063408_add_description_column_to_faq_categories_table',1),(163,'2023_11_22_154643_add_unique_in_table_ec_products_variations',1),(164,'2023_11_27_032313_add_price_columns_to_ec_product_cross_sale_relations_table',1),(165,'2023_12_06_023945_add_display_on_checkout_column_to_ec_discounts_table',1),(166,'2023_12_07_095130_add_color_column_to_media_folders_table',1),(167,'2023_12_12_105220_drop_translations_table',1),(168,'2023_12_17_162208_make_sure_column_color_in_media_folders_nullable',1),(169,'2023_12_25_040604_ec_create_review_replies_table',1),(170,'2023_12_26_090340_add_private_notes_column_to_ec_customers_table',1),(171,'2024_01_15_000001_create_fob_product_size_guides_table',1),(172,'2024_01_15_000002_create_fob_product_size_guide_relations_table',1),(173,'2024_01_15_000003_create_fob_size_guide_headers_table',1),(174,'2024_01_15_000004_create_fob_size_guide_headers_translations_table',1),(175,'2024_01_16_070706_fix_translation_tables',1),(176,'2024_01_23_075227_add_proof_file_to_ec_orders_table',1),(177,'2024_03_14_041050_migrate_lazy_load_theme_options',1),(178,'2024_03_20_080001_migrate_change_attribute_email_to_nullable_form_contacts_table',1),(179,'2024_03_21_100334_update_section_title_shape',1),(180,'2024_03_25_000001_update_captcha_settings_for_contact',1),(181,'2024_03_25_000001_update_captcha_settings_for_newsletter',1),(182,'2024_03_26_041531_add_cancel_reason_to_ec_orders_table',1),(183,'2024_03_27_062402_create_ec_customer_deletion_requests_table',1),(184,'2024_03_29_042242_migrate_old_captcha_settings',1),(185,'2024_03_29_093946_create_ec_order_return_histories_table',1),(186,'2024_04_01_043317_add_google_adsense_slot_id_to_ads_table',1),(187,'2024_04_01_063523_add_customer_columns_to_ec_reviews_table',1),(188,'2024_04_03_062451_add_cover_image_to_table_mp_stores',1),(189,'2024_04_04_110758_update_value_column_in_user_meta_table',1),(190,'2024_04_15_092654_migrate_ecommerce_google_tag_manager_code_setting',1),(191,'2024_04_16_035713_add_min_max_order_quantity_columns_to_products_table',1),(192,'2024_04_19_063914_create_custom_fields_table',1),(193,'2024_04_27_100730_improve_analytics_setting',1),(194,'2024_05_07_073153_improve_table_wishlist',1),(195,'2024_05_07_082630_create_mp_messages_table',1),(196,'2024_05_07_093703_add_missing_zip_code_into_table_store_locators',1),(197,'2024_05_12_091229_add_column_visibility_to_table_media_files',1),(198,'2024_05_15_021503_fix_invoice_path',1),(199,'2024_06_20_160724_create_ec_shared_wishlists_table',1),(200,'2024_06_28_025104_add_notify_attachment_updated_column_to_ec_products_table',1),(201,'2024_07_03_030900_add_downloaded_at_column_to_ec_order_product_table',1),(202,'2024_07_04_083133_create_payment_logs_table',1),(203,'2024_07_07_091316_fix_column_url_in_menu_nodes_table',1),(204,'2024_07_12_100000_change_random_hash_for_media',1),(205,'2024_07_14_071826_make_customer_email_nullable',1),(206,'2024_07_15_104916_add_video_media_column_to_ec_products_table',1),(207,'2024_07_19_131849_add_documents_to_mp_stores_table',1),(208,'2024_07_26_052530_add_percentage_to_tax_rules_table',1),(209,'2024_07_30_091615_fix_order_column_in_categories_table',1),(210,'2024_08_14_123028_add_customer_delivered_confirmed_at_column_to_ec_shipments_table',1),(211,'2024_08_17_094600_add_image_into_countries',1),(212,'2024_08_18_083119_add_tax_id_column_to_mp_stores_table',1),(213,'2024_08_19_132849_create_specification_tables',1),(214,'2024_08_27_141244_add_block_reason_to_ec_customers_table',1),(215,'2024_09_07_060744_add_author_column_to_specification_tables',1),(216,'2024_09_14_064023_add_can_use_with_flash_sale_column_to_ec_discounts_table',1),(217,'2024_09_14_100108_add_stripe_connect_details_to_ec_customers_table',1),(218,'2024_09_17_125408_add_square_logo_to_stores_table',1),(219,'2024_09_25_073928_remove_wrong_product_slugs',1),(220,'2024_09_30_024515_create_sessions_table',1),(221,'2024_12_01_000000_add_indexes_to_blog_translations_tables',1),(222,'2024_12_01_000000_add_indexes_to_contact_translations_tables',1),(223,'2024_12_01_000000_add_indexes_to_ecommerce_translations_tables',1),(224,'2024_12_01_000000_add_indexes_to_faq_translations_tables',1),(225,'2024_12_01_000000_add_indexes_to_gallery_translations_tables',1),(226,'2024_12_01_000000_add_indexes_to_pages_translations_table',1),(227,'2024_12_01_000000_add_indexes_to_slugs_translations_table',1),(228,'2024_12_01_000000_add_indexes_to_testimonials_translations_table',1),(229,'2024_12_01_000000_add_key_prefix_index_to_slugs_table',1),(230,'2024_12_19_000001_create_device_tokens_table',1),(231,'2024_12_19_000002_create_push_notifications_table',1),(232,'2024_12_19_000003_create_push_notification_recipients_table',1),(233,'2024_12_30_000001_create_user_settings_table',1),(234,'2025_01_06_033807_add_default_value_for_categories_author_type',1),(235,'2025_01_08_093652_add_zip_code_to_cities',1),(236,'2025_01_10_000000_fix_order_invoice_rounding_issues',1),(237,'2025_01_12_094943_correct_blog_posts_images',1),(238,'2025_01_15_050230_migrate_old_theme_options',1),(239,'2025_01_15_optimize_products_export_index',1),(240,'2025_01_17_082713_correct_column_barcode_and_cost_per_item_to_product_table',1),(241,'2025_01_24_044641_migrate_old_country_data',1),(242,'2025_01_28_233602_add_private_notes_into_ec_orders_table',1),(243,'2025_02_11_153025_add_action_label_to_announcement_translations',1),(244,'2025_02_13_021247_add_tax_translations',1),(245,'2025_02_24_152621_add_text_color_to_product_labels_table',1),(246,'2025_04_08_040931_create_social_logins_table',1),(247,'2025_04_12_000001_add_payment_fee_to_ec_orders_table',1),(248,'2025_04_12_000002_add_payment_fee_to_ec_invoices_table',1),(249,'2025_04_12_000003_add_payment_fee_to_payments_table',1),(250,'2025_04_21_000000_add_tablet_mobile_image_to_ads_translations_table',1),(251,'2025_05_05_000001_add_user_type_to_audit_histories_table',1),(252,'2025_05_05_092036_make_user_id_and_tax_amount_nullable',1),(253,'2025_05_15_082342_drop_email_unique_index_in_ec_customers_table',1),(254,'2025_05_22_000001_add_payment_fee_type_to_settings_table',1),(255,'2025_06_07_081731_add_translations_for_specification_groups_and_tables',1),(256,'2025_06_17_091813_increase_note_in_shipments_table',1),(257,'2025_06_24_000001_create_ec_product_license_codes_table',1),(258,'2025_06_24_080427_add_license_code_type_to_products_table',1),(259,'2025_07_06_030754_add_phone_to_users_table',1),(260,'2025_07_06_062402_create_ec_customer_deletion_requests_table',1),(261,'2025_07_07_161729_change_license_code_to_text_in_ec_product_license_codes_table',1),(262,'2025_07_08_162756_increase_license_code_column_size_in_ec_order_product_table',1),(263,'2025_07_09_000001_add_customer_address_fields_to_ec_invoices_table',1),(264,'2025_07_15_090809_create_ec_abandoned_carts_table',1),(265,'2025_07_24_120510_increase_barcode_column_length_in_ec_products_table',1),(266,'2025_07_31_021805_add_indexes_for_vendor_categories_optimization',1),(267,'2025_07_31_083459_add_indexes_for_location_search_performance',1),(268,'2025_07_31_133600_add_performance_indexes_to_ec_product_categories_table',1),(269,'2025_07_31_add_performance_indexes_to_slugs_table',1),(270,'2025_08_01_161205_optimize_product_variation_query_indexes',1),(271,'2025_08_07_073854_add_verification_fields_to_mp_stores_table',1),(272,'2025_08_08_145059_correct_tax_amount_in_order_and_invoice_tables',1),(273,'2025_09_05_025247_create_ec_product_specification_attribute_translations_table',1),(274,'2025_09_08_025516_add_variations_count_to_ec_products_table',1),(275,'2025_09_08_080248_add_slug_column_to_ec_product_categories_table',1),(276,'2025_09_08_080330_add_slug_column_to_ec_product_categories_translations_table',1),(277,'2025_09_08_080443_populate_slug_column_for_product_categories',1),(278,'2025_09_08_081216_add_slug_column_to_ec_products_table',1),(279,'2025_09_08_081237_add_slug_column_to_ec_products_translations_table',1),(280,'2025_09_08_081321_populate_slug_column_for_products',1),(281,'2025_09_10_073321_add_performance_indexes_to_ecommerce_tables',1),(282,'2025_09_18_093922_fix_tax_rounding_in_order_products_and_invoices',1),(283,'2025_09_21_030756_add_reviews_cache_to_ec_products_table',1),(284,'2025_09_30_090432_add_performance_indexes_to_ec_product_categories_table',1),(285,'2025_10_10_090331_add_number_format_style_to_ec_currencies_table',1),(286,'2025_10_10_092235_add_space_between_price_and_currency_to_ec_currencies_table',1),(287,'2025_10_11_074318_add_price_includes_tax_to_ec_products_table',1),(288,'2025_10_13_043527_generate_slugs_for_product_collections',1),(289,'2025_10_22_020518_add_verification_code_to_ec_customer_deletion_requests_table',1),(290,'2025_10_22_090000_remove_duplicate_order_addresses',1),(291,'2025_10_28_133220_add_unique_order_id_to_shipments_table',1),(292,'2025_10_28_134738_fix_order_payment_shipment_discount_data_issues',1),(293,'2025_11_05_000001_add_indexes_for_marketplace_performance_optimization',1),(294,'2025_11_05_032148_add_performance_indexes_to_ecommerce_tables',1),(295,'2025_11_07_000001_add_actor_type_to_audit_histories_table',1),(296,'2025_11_10_000000_cleanup_duplicate_widgets',1),(297,'2025_11_10_100000_create_ec_order_metadata_table',1),(298,'2025_11_12_100000_improve_ec_customer_recently_viewed_products_table',1),(299,'2025_11_18_214150_add_covering_indexes_to_product_relation_tables',1),(300,'2025_12_02_045049_add_index_to_product_labels_table',1),(301,'2025_12_12_150000_add_sequence_columns_to_abandoned_carts',1),(302,'2025_12_16_160000_add_is_new_until_to_ec_products_table',1),(303,'2025_12_28_000628_add_images_column_to_ec_order_returns_table',1),(304,'2026_01_05_162601_update_missing_slugs_for_ec_product_categories_table',1),(305,'2026_01_09_024811_add_currency_code_to_ec_products_table',1),(306,'2026_01_10_000001_add_status_to_simple_slider_items_table',1),(307,'2026_01_11_221755_add_price_columns_to_ec_product_up_sale_relations_table',1),(308,'2026_01_14_035001_add_customer_id_to_ec_cart_table',1),(309,'2026_01_26_084750_add_customer_id_to_ec_review_replies_table',1),(310,'2026_01_31_144854_add_zip_code_range_to_ec_shipping_rule_items_table',1),(311,'2026_02_02_090000_add_tax_location_to_mp_stores_table',1),(312,'2026_02_02_090000_create_ec_order_product_tax_components_table',1),(313,'2026_02_02_090001_create_ec_invoice_item_tax_components_table',1),(314,'2026_02_02_090002_add_tax_class_to_ec_customers_table',1),(315,'2026_02_02_090003_add_tax_class_to_ec_products_table',1),(316,'2026_02_02_090004_add_tax_breakdown_to_ec_order_product_table',1),(317,'2026_02_03_090000_drop_foreign_key_from_ec_order_product_tax_components_table',1),(318,'2026_02_07_090000_remove_duplicate_product_variation_records',1),(319,'2026_02_11_090000_add_price_per_product_to_options_tables',1),(320,'2026_02_11_090000_add_shipping_tax_amount_to_ec_orders_and_invoices_table',1),(321,'2026_02_11_160300_convert_specification_options_to_id_based_format',1),(322,'2026_03_03_150041_add_content_to_ec_product_tags_table',1),(323,'2026_03_04_000001_add_name_to_ec_shipping_rule_items_table',1),(324,'2026_03_04_000002_normalize_zip_codes_in_ec_shipping_rule_items_table',1),(325,'2026_03_06_020547_make_comment_nullable_in_ec_reviews_table',1),(326,'2026_03_06_020805_fix_empty_status_in_ec_invoices_table',1),(327,'2026_03_07_153100_add_index_to_meta_boxes_table',1),(328,'2026_03_10_105000_add_badge_type_to_ec_reviews_table',1),(329,'2026_03_23_000000_create_media_folder_permissions_table',1),(330,'2026_03_27_085220_add_folder_deleted_name_index_to_media_files_table',1),(331,'2026_04_20_000000_add_sessions_invalidated_at_to_users_table',1),(332,'2026_04_24_000001_reconcile_payment_amount_with_order_total',1),(333,'2026_04_25_000001_backfill_missing_order_shipping_addresses',1);

--
-- Table structure for table `mp_category_sale_commissions`
--

CREATE TABLE `mp_category_sale_commissions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `product_category_id` bigint unsigned NOT NULL,
  `commission_percentage` decimal(8,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `mp_category_sale_commissions_product_category_id_unique` (`product_category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mp_category_sale_commissions`
--


--
-- Table structure for table `mp_customer_revenues`
--

CREATE TABLE `mp_customer_revenues` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` bigint unsigned DEFAULT NULL,
  `order_id` bigint unsigned DEFAULT NULL,
  `sub_amount` decimal(15,2) DEFAULT '0.00',
  `fee` decimal(15,2) unsigned DEFAULT '0.00',
  `amount` decimal(15,2) DEFAULT '0.00',
  `current_balance` decimal(15,2) DEFAULT '0.00',
  `currency` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` bigint unsigned NOT NULL DEFAULT '0',
  `type` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mp_customer_revenues_customer_id_index` (`customer_id`),
  KEY `mp_customer_revenues_order_id_index` (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mp_customer_revenues`
--


--
-- Table structure for table `mp_customer_withdrawals`
--

CREATE TABLE `mp_customer_withdrawals` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` bigint unsigned DEFAULT NULL,
  `fee` decimal(15,2) unsigned DEFAULT '0.00',
  `amount` decimal(15,2) unsigned DEFAULT '0.00',
  `current_balance` decimal(15,2) unsigned DEFAULT '0.00',
  `currency` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `bank_info` text COLLATE utf8mb4_unicode_ci,
  `payment_channel` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` bigint unsigned NOT NULL DEFAULT '0',
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `images` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `transaction_id` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mp_customer_withdrawals_customer_id_index` (`customer_id`),
  KEY `mp_customer_withdrawals_status_index` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mp_customer_withdrawals`
--


--
-- Table structure for table `mp_messages`
--

CREATE TABLE `mp_messages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `store_id` bigint unsigned NOT NULL,
  `customer_id` bigint unsigned DEFAULT NULL,
  `name` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mp_messages`
--


--
-- Table structure for table `mp_stores`
--

CREATE TABLE `mp_stores` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_id` bigint unsigned DEFAULT NULL,
  `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo_square` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cover_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `is_verified` tinyint(1) NOT NULL DEFAULT '0',
  `verified_at` timestamp NULL DEFAULT NULL,
  `verified_by` bigint unsigned DEFAULT NULL,
  `verification_note` text COLLATE utf8mb4_unicode_ci,
  `vendor_verified_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `zip_code` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tax_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tax_country` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tax_state` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `certificate_file` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `government_id_file` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mp_stores_customer_id_index` (`customer_id`),
  KEY `mp_stores_status_index` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mp_stores`
--

INSERT INTO `mp_stores` VALUES (1,'Anthro Studio','hello@anthro.example.com','+1-415-555-0142','512 Valencia Street','US','California','San Francisco',NULL,NULL,NULL,NULL,'Eclectic apparel and home goods inspired by global craftsmanship traditions.','<p>Anthro Studio sources from independent artisans across four continents. Every piece is checked by hand before it ships from our San Francisco fulfilment center.</p>','published',1,NULL,NULL,NULL,NULL,'2026-05-07 01:57:53','2026-05-07 01:57:53','94110','Anthro Studio Inc.',NULL,NULL,NULL,NULL,NULL),(2,'Crate Furniture Co.','orders@crate.example.com','+1-503-555-0188','1840 NE Alberta Street','US','Oregon','Portland',NULL,NULL,NULL,NULL,'Mid-century-inspired furniture built to last generations.','<p>Every Crate piece is built one at a time in our Portland workshop using sustainably harvested American hardwoods.</p>','published',1,NULL,NULL,NULL,NULL,'2026-05-07 01:57:53','2026-05-07 01:57:53','97211','Crate Furniture Co.',NULL,NULL,NULL,NULL,NULL),(3,'Findr Audio','support@findr.example.com','+44-20-7946-0310','17 Hanbury Street','GB','Greater London','London',NULL,NULL,NULL,NULL,'Audio gear engineered for studio-grade clarity in everyday environments.','<p>Founded by ex-studio engineers, Findr brings reference-quality sound to wireless headphones and earbuds.</p>','published',1,NULL,NULL,NULL,NULL,'2026-05-07 01:57:53','2026-05-07 01:57:53','E1 6QR','Findr Audio Ltd.',NULL,NULL,NULL,NULL,NULL),(4,'Bohome Living','hello@bohome.example.com','+34-93-555-0122','Carrer de Sepulveda 102','ES','Catalonia','Barcelona',NULL,NULL,NULL,NULL,'Bohemian-inspired homewares and textiles for the relaxed modern home.','<p>Bohome partners with co-operatives in Morocco, Turkey, and India to bring you authentic, fair-traded textiles.</p>','published',1,NULL,NULL,NULL,NULL,'2026-05-07 01:57:53','2026-05-07 01:57:53','08015','Bohome Living S.L.',NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `mp_stores_translations`
--

CREATE TABLE `mp_stores_translations` (
  `lang_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mp_stores_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cover_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`mp_stores_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mp_stores_translations`
--


--
-- Table structure for table `mp_vendor_info`
--

CREATE TABLE `mp_vendor_info` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` bigint unsigned NOT NULL DEFAULT '0',
  `balance` decimal(15,2) NOT NULL DEFAULT '0.00',
  `total_fee` decimal(15,2) NOT NULL DEFAULT '0.00',
  `total_revenue` decimal(15,2) NOT NULL DEFAULT '0.00',
  `signature` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank_info` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `payout_payment_method` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT 'bank_transfer',
  `tax_info` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `mp_vendor_info_customer_id_index` (`customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mp_vendor_info`
--


--
-- Table structure for table `newsletters`
--

CREATE TABLE `newsletters` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'subscribed',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `newsletters`
--


--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `user_id` bigint unsigned DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `template` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `pages_user_id_index` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` VALUES (1,'About','[page-banner heading=\"About Us\" subtitle=\"With over 15 years of experience, we craft timeless collections that transcend<br class=\\\"d-none d-lg-block\\\">trends and inspire lasting elegance.\"][/page-banner]\n[stats-counter hero_image=\"section/s-contact-1.jpg\" heading=\"Design, attention to detail & efficiency to delight the world\" description=\"From the moment it is conceived to the moment it is worn, every one of our garments follows this path. We could do it at a fast pace. However, at Amerce, we choose to take care of all those who are walking this path with us.\" quantity=\"4\" value_1=\"8.2k\" animate_to_1=\"\" suffix_1=\"\" label_1=\"Products Available\" desc_1=\"We offer a wide selection of high-quality products to meet every need.\" value_2=\"\" animate_to_2=\"10\" suffix_2=\"k\" label_2=\"Happy Customers\" desc_2=\"Serving over 10,000 delighted customers who trust us for quality and service.\" value_3=\"\" animate_to_3=\"96\" suffix_3=\"\" label_3=\"Partner Brand\" desc_3=\"Our top-brand partnerships bring a trusted collection for your store and home.\" value_4=\"\" animate_to_4=\"16\" suffix_4=\"k\" label_4=\"Products For Sale\" desc_4=\"That\'s why we strive to offer a diverse range of products that cater to all styles.\"][/stats-counter]\n[image-accordion image=\"section/s-contact-2.jpg\" heading=\"Offering Rare And Beautiful Items Worldwide\" quantity=\"4\" title_1=\"Introduction\" body_1=\"Welcome to Amerce Store, your premier destination for fashion-forward clothing and accessories. We pride ourselves on offering a curated selection of rare and beautiful items sourced both locally and globally.\" title_2=\"Our Vision\" body_2=\"We envision a world where thoughtful design meets everyday life — pieces that age gracefully, partners we trust, and customers we treat as people, not transactions.\" title_3=\"What Sets Us Apart\" body_3=\"Independently audited suppliers, hand-checked products, and a 30-day no-questions return policy backed by a human customer support team.\" title_4=\"Our Commitment\" body_4=\"Quality goods, transparent supply chains, and fair labor — every order, every time.\"][/image-accordion]\n[about-testimonials heading=\"Customer Say!\" subtitle=\"Our customers adore our products, and we constantly aim to delight them.\" quantity=\"2\" image_1=\"testimonials/tes-1.jpg\" name_1=\"Emma Collins\" text_1=\"\\\"Totally obsessed with this outfit! The fit is perfect, the fabric feels premium, and I\'ve been getting compliments non-stop. It instantly lifts my confidence — such a great find!\\\"\" image_2=\"testimonials/tes-2.jpg\" name_2=\"Sophia Ramirez\" text_2=\"\\\"I\'m amazed by how comfortable yet stylish this piece is. It pairs effortlessly with everything, and the quality really stands out. Definitely becoming my go-to for everyday looks!\\\"\"][/about-testimonials]\n[about-team heading=\"Meet Our Teams\" subtitle=\"Experts committed to excellence in every detail.\" quantity=\"4\" image_1=\"member/member-1.jpg\" name_1=\"Annette Black\" role_1=\"Founder/CEO\" social_links_1=\"\" image_2=\"member/member-2.jpg\" name_2=\"Brooklyn Simmons\" role_2=\"Manager\" social_links_2=\"\" image_3=\"member/member-3.jpg\" name_3=\"Jane Cooper\" role_3=\"Sales Director\" social_links_3=\"\" image_4=\"member/member-4.jpg\" name_4=\"Lisa Bonet\" role_4=\"Sales Director\" social_links_4=\"\"][/about-team]',1,NULL,'landing','About Amerce — our story, sourcing standards, and the people behind every product.','published','2026-05-07 01:57:58','2026-05-07 01:57:58'),(2,'Contact','',1,NULL,'landing','Reach the Amerce customer support and partnerships teams.','published','2026-05-07 01:57:58','2026-05-07 01:57:58'),(3,'FAQ','[page-banner heading=\"FAQs\" subtitle=\"Got questions? We\'ve got answers! Browse our FAQs to find information on orders, shipping,<br class=\\\"d-none d-lg-block\\\">returns, and more. If you need further assistance, feel free to contact our team.\"][/page-banner]\n[faq-page sidebar_image=\"section/banner-12.jpg\" sidebar_title=\"Save 25% <br class=\\\"d-none d-sm-block\\\">Today\" sidebar_subtitle=\"T-Shirts, Hoodies & More\" sidebar_cta=\"View More\" sidebar_url=\"/products\" quantity=\"16\" category_1=\"My Account\" category_id_1=\"myAccount\" question_1=\"1. What can I do if I forgot my password?\" answer_1=\"Use the \\\"Forgot password\\\" link on the sign-in page. We will email you a one-time link to set a new password — it expires in 30 minutes for security.\" category_2=\"My Account\" category_id_2=\"myAccount\" question_2=\"2. How do I update my email address?\" answer_2=\"Sign in, open Account → Settings, and change the email field. We send a confirmation email to the new address; the change takes effect once you click that link.\" category_3=\"My Account\" category_id_3=\"myAccount\" question_3=\"3. Can I delete my account?\" answer_3=\"Yes. From Account → Settings, scroll to Delete account. We retain order history for tax/legal reasons but personal contact details are removed within 30 days.\" category_4=\"Orders & Purchases\" category_id_4=\"ordersPurchases\" question_4=\"1. How do I place an order?\" answer_4=\"Add items to your cart, click checkout, choose a shipping method, then enter your payment details. You will receive an order confirmation email immediately.\" category_5=\"Orders & Purchases\" category_id_5=\"ordersPurchases\" question_5=\"2. Can I edit or cancel an order?\" answer_5=\"Orders can be edited or cancelled from your account dashboard within 1 hour of placement. After that the warehouse has begun picking and we cannot intercept.\" category_6=\"Orders & Purchases\" category_id_6=\"ordersPurchases\" question_6=\"3. What payment methods are accepted?\" answer_6=\"We accept Visa, Mastercard, American Express, Apple Pay, Google Pay, and PayPal. All transactions use TLS 1.3 encryption.\" category_7=\"Returns & Refunds\" category_id_7=\"returnsRefunds\" question_7=\"1. What is the return window?\" answer_7=\"30 days from delivery for any unworn item in original condition. Sale items, intimate apparel, and final-sale flash sale purchases are excluded.\" category_8=\"Returns & Refunds\" category_id_8=\"returnsRefunds\" question_8=\"2. How do I start a return?\" answer_8=\"Open the order in your account dashboard and click \\\"Start return\\\". We email a prepaid label for domestic orders within one business day.\" category_9=\"Returns & Refunds\" category_id_9=\"returnsRefunds\" question_9=\"3. When will I see my refund?\" answer_9=\"Refunds are processed within 3-5 business days of us receiving the return. Bank posting times vary; allow up to 10 business days for the credit to appear.\" category_10=\"Shipping & Tracking\" category_id_10=\"shippingTracking\" question_10=\"1. How long does shipping take?\" answer_10=\"Domestic standard ships in 3-5 business days. Express in 1-2. International standard takes 7-12 business days; express options are available at checkout.\" category_11=\"Shipping & Tracking\" category_id_11=\"shippingTracking\" question_11=\"2. How do I track my order?\" answer_11=\"A tracking link is included in your shipment confirmation email. You can also see status from Account → Orders → Track.\" category_12=\"Shipping & Tracking\" category_id_12=\"shippingTracking\" question_12=\"3. Do you ship internationally?\" answer_12=\"Yes — to most countries. Duties and taxes are pre-paid at checkout for select destinations; otherwise the courier may collect them on delivery.\" category_13=\"Fees & Billing\" category_id_13=\"feesBilling\" question_13=\"1. Are duties and taxes included?\" answer_13=\"Domestic prices include sales tax shown at checkout. International orders to supported destinations include duties and taxes; otherwise the courier collects on delivery.\" category_14=\"Fees & Billing\" category_id_14=\"feesBilling\" question_14=\"2. Why was I charged twice?\" answer_14=\"You likely see a temporary authorization hold plus the actual charge. The authorization drops off in 3-5 business days. Email billing@amerce.test if you still see two charges after that.\" category_15=\"Other Topic\" category_id_15=\"otherTopic\" question_15=\"1. Do you have physical stores?\" answer_15=\"Yes — visit our Stores page for a list of flagship and partner locations.\" category_16=\"Other Topic\" category_id_16=\"otherTopic\" question_16=\"2. How can I contact customer support?\" answer_16=\"Email hello@amerce.test or use the contact form. We reply within one business day.\"][/faq-page]',1,NULL,'landing','Frequently asked questions about orders, shipping, returns, and account management.','published','2026-05-07 01:57:58','2026-05-07 01:57:58'),(4,'Privacy Policy','[page-banner heading=\"Privacy Policy\"][/page-banner]\n[term-content quantity=\"7\" title_1=\"1. Information We Collect\" body_1=\"<p class=\\\"term-text cl-text-2\\\">When you visit the Site, we automatically collect certain information about your device — web browser, IP address, time zone, and some of the cookies installed on your device. As you browse, we also collect data about the pages or products you view, what referred you to the Site, and how you interact with it. We refer to this as \\\"Device Information\\\".</p><p class=\\\"term-text cl-text-2\\\">When you make a purchase or attempt to purchase through the Site, we collect your name, billing address, shipping address, and payment information (including card number, email address, and phone number). We refer to this as \\\"Order Information\\\".</p>\" title_2=\"2. How We Use Your Information\" body_2=\"<p class=\\\"term-text cl-text-2\\\">We use Order Information to fulfil orders placed through the Site (process payment, arrange shipping, provide invoices and order confirmations). We use it to communicate with you, screen orders for fraud, and — in line with your preferences — share marketing about products you may like.</p><p class=\\\"term-text cl-text-2\\\">We use Device Information to screen for fraud and to improve the Site through analytics about how customers browse and interact with us.</p>\" title_3=\"3. Sharing Your Personal Information\" body_3=\"<p class=\\\"term-text cl-text-2\\\">We share Personal Information with third-party service providers who help us run the Site. We may also share information to comply with applicable laws, respond to a subpoena or lawful request, or otherwise protect our rights.</p>\" title_4=\"4. Data Retention\" body_4=\"<p class=\\\"term-text cl-text-2\\\">When you place an order, we maintain the Order Information for our records unless and until you ask us to delete it.</p>\" title_5=\"5. Your Rights\" body_5=\"<p class=\\\"term-text cl-text-2\\\">You can request access, correction, or deletion of any personal data we hold about you. Email privacy@amerce.test from the address on file and we will respond within 30 days.</p>\" title_6=\"6. Cookies\" body_6=\"<p class=\\\"term-text cl-text-2\\\">Cookies are used to keep your cart between visits, remember your preferences, and measure aggregate traffic. You can disable cookies in your browser, though some Site features may stop working.</p>\" title_7=\"7. Changes\" body_7=\"<p class=\\\"term-text cl-text-2\\\">We may update this policy from time to time to reflect changes to our practices or for operational, legal, or regulatory reasons. The latest version will always be on this page.</p>\"][/term-content]',1,NULL,'landing','How Amerce collects, uses, and protects your personal information.','published','2026-05-07 01:57:58','2026-05-07 01:57:58'),(5,'Terms &amp; Conditions','[page-banner heading=\"Terms & Conditions\"][/page-banner]\n[term-content quantity=\"7\" title_1=\"1. Acceptance of Terms\" body_1=\"<p class=\\\"term-text cl-text-2\\\">By accessing or using the Amerce store you agree to these terms. We reserve the right to update them with reasonable notice; the latest version is always available on this page.</p>\" title_2=\"2. Orders & Payment\" body_2=\"<p class=\\\"term-text cl-text-2\\\">All prices are in USD unless otherwise stated. We accept the payment methods displayed at checkout. An order becomes binding once you receive an order confirmation email.</p>\" title_3=\"3. Shipping\" body_3=\"<p class=\\\"term-text cl-text-2\\\">Shipping options, lead times, and rates are listed on our Shipping page. Risk passes to you on delivery.</p>\" title_4=\"4. Returns\" body_4=\"<p class=\\\"term-text cl-text-2\\\">You have 30 days from delivery to return any unworn item for a refund. See our Returns &amp; Refunds page for the full process.</p>\" title_5=\"5. Intellectual Property\" body_5=\"<p class=\\\"term-text cl-text-2\\\">All content on the Site — text, photography, logos, code — is owned by Amerce or its licensors and may not be reproduced without written permission.</p>\" title_6=\"6. Limitation of Liability\" body_6=\"<p class=\\\"term-text cl-text-2\\\">To the maximum extent permitted by law, Amerce is not liable for indirect or consequential damages arising from use of the Site or the products purchased through it.</p>\" title_7=\"7. Governing Law\" body_7=\"<p class=\\\"term-text cl-text-2\\\">These terms are governed by the laws of the State of New York. Any dispute will be resolved in the state or federal courts located in New York County.</p>\"][/term-content]',1,NULL,'landing','The legal terms governing your use of the Amerce store.','published','2026-05-07 01:57:58','2026-05-07 01:57:58'),(6,'Returns &amp; Refunds','[page-banner heading=\"Returns & Refunds\"][/page-banner]\n[term-content quantity=\"6\" title_1=\"1. Returns\" body_1=\"<p class=\\\"term-text cl-text-2\\\">We want you to be completely satisfied with your purchase. If for any reason you are not, you may return any unworn item within 30 days of receiving your order for a refund or exchange. Items must be in original packaging and the same condition as you received them.</p>\" title_2=\"2. How to Start a Return\" body_2=\"<p class=\\\"term-text cl-text-2\\\">Open the order in your account dashboard and click \\\"Start return\\\", or email returns@amerce.test with your order number. We will send a prepaid return label for domestic orders within one business day.</p>\" title_3=\"3. Refunds\" body_3=\"<p class=\\\"term-text cl-text-2\\\">Refunds are processed within 3-5 business days of us receiving the return and applied to the original payment method. Bank posting times vary; allow up to 10 business days for the credit to appear.</p>\" title_4=\"4. Exclusions\" body_4=\"<p class=\\\"term-text cl-text-2\\\">Sale items, intimate apparel, and final-sale flash sale purchases are excluded from returns. Personalised or made-to-order items are also non-returnable unless faulty.</p>\" title_5=\"5. Damaged or Faulty Items\" body_5=\"<p class=\\\"term-text cl-text-2\\\">If your order arrives damaged or faulty, email us within 7 days with photos. We will replace the item or issue a full refund — including any return shipping cost — at our expense.</p>\" title_6=\"6. International Returns\" body_6=\"<p class=\\\"term-text cl-text-2\\\">International customers are responsible for return shipping unless the item is faulty. We do not refund original shipping or duty charges on international returns.</p>\"][/term-content]',1,NULL,'landing','Our 30-day return policy and the step-by-step return process.','published','2026-05-07 01:57:58','2026-05-07 01:57:58'),(7,'Shipping','[page-banner heading=\"Shipping\"][/page-banner]\n[term-content quantity=\"6\" title_1=\"1. Shipping Methods\" body_1=\"<p class=\\\"term-text cl-text-2\\\">We offer the following shipping methods for domestic and international orders: standard ground, expedited 2-day, and priority overnight (where available).</p>\" title_2=\"2. Domestic Rates\" body_2=\"<p class=\\\"term-text cl-text-2\\\">Standard ground is free on orders over $99. Express 1-2 day shipping is $19.99 flat. Priority overnight is calculated by weight at checkout.</p>\" title_3=\"3. International\" body_3=\"<p class=\\\"term-text cl-text-2\\\">We ship to most countries. International standard shipping is $24.99 with 7-12 business day delivery. Express options appear at checkout. Duties and taxes are pre-paid for select destinations; otherwise the courier collects them on delivery.</p>\" title_4=\"4. Processing Time\" body_4=\"<p class=\\\"term-text cl-text-2\\\">Orders placed before 2pm EST on business days ship the same day. Orders placed after 2pm or on weekends/holidays ship the next business day.</p>\" title_5=\"5. Tracking\" body_5=\"<p class=\\\"term-text cl-text-2\\\">A tracking link is included in your shipment confirmation email. You can also see live status from Account → Orders → Track.</p>\" title_6=\"6. Lost or Stuck Shipments\" body_6=\"<p class=\\\"term-text cl-text-2\\\">If a tracking number has not updated for more than 7 business days, email shipping@amerce.test. We will open an investigation with the carrier and either refund or reship the order at our expense.</p>\"][/term-content]',1,NULL,'landing','Domestic and international shipping options, lead times, and rates.','published','2026-05-07 01:57:58','2026-05-07 01:57:58'),(8,'Our Stores','',1,NULL,'landing','Visit Amerce in person — flagship locations and partner boutiques worldwide.','published','2026-05-07 01:57:58','2026-05-07 01:57:58'),(9,'Blog','<div class=\"container py-5\"><h1>Journal</h1><p>Browse our latest stories — style guides, product spotlights, sustainability deep-dives, and more.</p></div>',1,NULL,'default','Style guides, product spotlights, and stories from the Amerce team.','published','2026-05-07 01:57:58','2026-05-07 01:57:58'),(10,'Careers','<div class=\"container py-5\"><h1>Careers at Amerce</h1><p>We are a small, distributed team building a more thoughtful kind of retail. We hire across product, engineering, supply chain, and customer experience.</p><p>Open roles are posted to our company LinkedIn page. To apply, send a short note and your resume to <a href=\"mailto:careers@amerce.test\">careers@amerce.test</a>.</p></div>',1,NULL,'default','Open roles and what it is like to work at Amerce.','published','2026-05-07 01:57:58','2026-05-07 01:57:58'),(11,'Sustainability','<div class=\"container py-5\"><h1>Sustainability at Amerce</h1><p>Every product carries a story. We work directly with mills and ateliers, prioritise recycled and traceable materials, and ship in plastic-free packaging.</p><p>Our 2026 goal: 90% of materials with a verified chain of custody, and a transparent annual impact report.</p></div>',1,NULL,'default','How Amerce sources responsibly and reduces its environmental footprint.','published','2026-05-07 01:57:58','2026-05-07 01:57:58'),(12,'Homepage','[simple-slider key=\"home-hero\" style=\"style-1\" is_autoplay=\"yes\" autoplay_speed=\"3000\" show_arrows=\"yes\" show_dots=\"yes\"][/simple-slider]\n[categories-grid style=\"style-grid-5\" title=\"Shop the Season\" subtitle=\"Curated activewear for every routine.\" limit=\"5\"][/categories-grid]\n[ecommerce-products style=\"style-slider\" title=\"Trending Now\" subtitle=\"Featured activewear flying off our shelves.\" source=\"featured\" limit=\"8\" items_per_row=\"4\"][/ecommerce-products]\n[ecommerce-products style=\"style-grid\" title=\"Best Sellers\" subtitle=\"Tried, tested, and loved by our community.\" source=\"best-seller\" limit=\"8\" items_per_row=\"4\"][/ecommerce-products]\n[newsletter-cta style=\"style-default\" heading=\"Subscribe for 10% off\" subheading=\"Plus first dibs on every new drop.\"][/newsletter-cta]',NULL,NULL,'homepage','Amerce — multi-purpose ecommerce homepage demo.','published','2026-05-07 01:57:58','2026-05-07 01:57:58');

--
-- Table structure for table `pages_translations`
--

CREATE TABLE `pages_translations` (
  `lang_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pages_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`lang_code`,`pages_id`),
  KEY `idx_pages_trans_pages_id` (`pages_id`),
  KEY `idx_pages_trans_page_lang` (`pages_id`,`lang_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pages_translations`
--

INSERT INTO `pages_translations` VALUES ('ar',1,'من نحن','تعرّف على Amerce — قصّة العلامة ومعايير المصادر والفريق الذي يقف خلف كل منتج.','[page-banner heading=\"About Us\" subtitle=\"With over 15 years of experience, we craft timeless collections that transcend<br class=\\\"d-none d-lg-block\\\">trends and inspire lasting elegance.\"][/page-banner]\n[stats-counter hero_image=\"section/s-contact-1.jpg\" heading=\"Design, attention to detail & efficiency to delight the world\" description=\"From the moment it is conceived to the moment it is worn, every one of our garments follows this path. We could do it at a fast pace. However, at Amerce, we choose to take care of all those who are walking this path with us.\" quantity=\"4\" value_1=\"8.2k\" animate_to_1=\"\" suffix_1=\"\" label_1=\"Products Available\" desc_1=\"We offer a wide selection of high-quality products to meet every need.\" value_2=\"\" animate_to_2=\"10\" suffix_2=\"k\" label_2=\"Happy Customers\" desc_2=\"Serving over 10,000 delighted customers who trust us for quality and service.\" value_3=\"\" animate_to_3=\"96\" suffix_3=\"\" label_3=\"Partner Brand\" desc_3=\"Our top-brand partnerships bring a trusted collection for your store and home.\" value_4=\"\" animate_to_4=\"16\" suffix_4=\"k\" label_4=\"Products For Sale\" desc_4=\"That\'s why we strive to offer a diverse range of products that cater to all styles.\"][/stats-counter]\n[image-accordion image=\"section/s-contact-2.jpg\" heading=\"Offering Rare And Beautiful Items Worldwide\" quantity=\"4\" title_1=\"Introduction\" body_1=\"Welcome to Amerce Store, your premier destination for fashion-forward clothing and accessories. We pride ourselves on offering a curated selection of rare and beautiful items sourced both locally and globally.\" title_2=\"Our Vision\" body_2=\"We envision a world where thoughtful design meets everyday life — pieces that age gracefully, partners we trust, and customers we treat as people, not transactions.\" title_3=\"What Sets Us Apart\" body_3=\"Independently audited suppliers, hand-checked products, and a 30-day no-questions return policy backed by a human customer support team.\" title_4=\"Our Commitment\" body_4=\"Quality goods, transparent supply chains, and fair labor — every order, every time.\"][/image-accordion]\n[about-testimonials heading=\"Customer Say!\" subtitle=\"Our customers adore our products, and we constantly aim to delight them.\" quantity=\"2\" image_1=\"testimonials/tes-1.jpg\" name_1=\"Emma Collins\" text_1=\"\\\"Totally obsessed with this outfit! The fit is perfect, the fabric feels premium, and I\'ve been getting compliments non-stop. It instantly lifts my confidence — such a great find!\\\"\" image_2=\"testimonials/tes-2.jpg\" name_2=\"Sophia Ramirez\" text_2=\"\\\"I\'m amazed by how comfortable yet stylish this piece is. It pairs effortlessly with everything, and the quality really stands out. Definitely becoming my go-to for everyday looks!\\\"\"][/about-testimonials]\n[about-team heading=\"Meet Our Teams\" subtitle=\"Experts committed to excellence in every detail.\" quantity=\"4\" image_1=\"member/member-1.jpg\" name_1=\"Annette Black\" role_1=\"Founder/CEO\" social_links_1=\"\" image_2=\"member/member-2.jpg\" name_2=\"Brooklyn Simmons\" role_2=\"Manager\" social_links_2=\"\" image_3=\"member/member-3.jpg\" name_3=\"Jane Cooper\" role_3=\"Sales Director\" social_links_3=\"\" image_4=\"member/member-4.jpg\" name_4=\"Lisa Bonet\" role_4=\"Sales Director\" social_links_4=\"\"][/about-team]'),('ar',2,'تواصل معنا','تواصل مع فريق خدمة العملاء والشراكات في Amerce.',''),('ar',3,'الأسئلة الشائعة','إجابات للأسئلة المتكرّرة حول الطلبات والشحن والإرجاع وإدارة الحساب.','[page-banner heading=\"FAQs\" subtitle=\"Got questions? We\'ve got answers! Browse our FAQs to find information on orders, shipping,<br class=\\\"d-none d-lg-block\\\">returns, and more. If you need further assistance, feel free to contact our team.\"][/page-banner]\n[faq-page sidebar_image=\"section/banner-12.jpg\" sidebar_title=\"Save 25% <br class=\\\"d-none d-sm-block\\\">Today\" sidebar_subtitle=\"T-Shirts, Hoodies & More\" sidebar_cta=\"View More\" sidebar_url=\"/products\" quantity=\"16\" category_1=\"My Account\" category_id_1=\"myAccount\" question_1=\"1. What can I do if I forgot my password?\" answer_1=\"Use the \\\"Forgot password\\\" link on the sign-in page. We will email you a one-time link to set a new password — it expires in 30 minutes for security.\" category_2=\"My Account\" category_id_2=\"myAccount\" question_2=\"2. How do I update my email address?\" answer_2=\"Sign in, open Account → Settings, and change the email field. We send a confirmation email to the new address; the change takes effect once you click that link.\" category_3=\"My Account\" category_id_3=\"myAccount\" question_3=\"3. Can I delete my account?\" answer_3=\"Yes. From Account → Settings, scroll to Delete account. We retain order history for tax/legal reasons but personal contact details are removed within 30 days.\" category_4=\"Orders & Purchases\" category_id_4=\"ordersPurchases\" question_4=\"1. How do I place an order?\" answer_4=\"Add items to your cart, click checkout, choose a shipping method, then enter your payment details. You will receive an order confirmation email immediately.\" category_5=\"Orders & Purchases\" category_id_5=\"ordersPurchases\" question_5=\"2. Can I edit or cancel an order?\" answer_5=\"Orders can be edited or cancelled from your account dashboard within 1 hour of placement. After that the warehouse has begun picking and we cannot intercept.\" category_6=\"Orders & Purchases\" category_id_6=\"ordersPurchases\" question_6=\"3. What payment methods are accepted?\" answer_6=\"We accept Visa, Mastercard, American Express, Apple Pay, Google Pay, and PayPal. All transactions use TLS 1.3 encryption.\" category_7=\"Returns & Refunds\" category_id_7=\"returnsRefunds\" question_7=\"1. What is the return window?\" answer_7=\"30 days from delivery for any unworn item in original condition. Sale items, intimate apparel, and final-sale flash sale purchases are excluded.\" category_8=\"Returns & Refunds\" category_id_8=\"returnsRefunds\" question_8=\"2. How do I start a return?\" answer_8=\"Open the order in your account dashboard and click \\\"Start return\\\". We email a prepaid label for domestic orders within one business day.\" category_9=\"Returns & Refunds\" category_id_9=\"returnsRefunds\" question_9=\"3. When will I see my refund?\" answer_9=\"Refunds are processed within 3-5 business days of us receiving the return. Bank posting times vary; allow up to 10 business days for the credit to appear.\" category_10=\"Shipping & Tracking\" category_id_10=\"shippingTracking\" question_10=\"1. How long does shipping take?\" answer_10=\"Domestic standard ships in 3-5 business days. Express in 1-2. International standard takes 7-12 business days; express options are available at checkout.\" category_11=\"Shipping & Tracking\" category_id_11=\"shippingTracking\" question_11=\"2. How do I track my order?\" answer_11=\"A tracking link is included in your shipment confirmation email. You can also see status from Account → Orders → Track.\" category_12=\"Shipping & Tracking\" category_id_12=\"shippingTracking\" question_12=\"3. Do you ship internationally?\" answer_12=\"Yes — to most countries. Duties and taxes are pre-paid at checkout for select destinations; otherwise the courier may collect them on delivery.\" category_13=\"Fees & Billing\" category_id_13=\"feesBilling\" question_13=\"1. Are duties and taxes included?\" answer_13=\"Domestic prices include sales tax shown at checkout. International orders to supported destinations include duties and taxes; otherwise the courier collects on delivery.\" category_14=\"Fees & Billing\" category_id_14=\"feesBilling\" question_14=\"2. Why was I charged twice?\" answer_14=\"You likely see a temporary authorization hold plus the actual charge. The authorization drops off in 3-5 business days. Email billing@amerce.test if you still see two charges after that.\" category_15=\"Other Topic\" category_id_15=\"otherTopic\" question_15=\"1. Do you have physical stores?\" answer_15=\"Yes — visit our Stores page for a list of flagship and partner locations.\" category_16=\"Other Topic\" category_id_16=\"otherTopic\" question_16=\"2. How can I contact customer support?\" answer_16=\"Email hello@amerce.test or use the contact form. We reply within one business day.\"][/faq-page]'),('ar',4,'سياسة الخصوصية','كيف تجمع Amerce بياناتك الشخصية وتستخدمها وتحميها.','[page-banner heading=\"Privacy Policy\"][/page-banner]\n[term-content quantity=\"7\" title_1=\"1. Information We Collect\" body_1=\"<p class=\\\"term-text cl-text-2\\\">When you visit the Site, we automatically collect certain information about your device — web browser, IP address, time zone, and some of the cookies installed on your device. As you browse, we also collect data about the pages or products you view, what referred you to the Site, and how you interact with it. We refer to this as \\\"Device Information\\\".</p><p class=\\\"term-text cl-text-2\\\">When you make a purchase or attempt to purchase through the Site, we collect your name, billing address, shipping address, and payment information (including card number, email address, and phone number). We refer to this as \\\"Order Information\\\".</p>\" title_2=\"2. How We Use Your Information\" body_2=\"<p class=\\\"term-text cl-text-2\\\">We use Order Information to fulfil orders placed through the Site (process payment, arrange shipping, provide invoices and order confirmations). We use it to communicate with you, screen orders for fraud, and — in line with your preferences — share marketing about products you may like.</p><p class=\\\"term-text cl-text-2\\\">We use Device Information to screen for fraud and to improve the Site through analytics about how customers browse and interact with us.</p>\" title_3=\"3. Sharing Your Personal Information\" body_3=\"<p class=\\\"term-text cl-text-2\\\">We share Personal Information with third-party service providers who help us run the Site. We may also share information to comply with applicable laws, respond to a subpoena or lawful request, or otherwise protect our rights.</p>\" title_4=\"4. Data Retention\" body_4=\"<p class=\\\"term-text cl-text-2\\\">When you place an order, we maintain the Order Information for our records unless and until you ask us to delete it.</p>\" title_5=\"5. Your Rights\" body_5=\"<p class=\\\"term-text cl-text-2\\\">You can request access, correction, or deletion of any personal data we hold about you. Email privacy@amerce.test from the address on file and we will respond within 30 days.</p>\" title_6=\"6. Cookies\" body_6=\"<p class=\\\"term-text cl-text-2\\\">Cookies are used to keep your cart between visits, remember your preferences, and measure aggregate traffic. You can disable cookies in your browser, though some Site features may stop working.</p>\" title_7=\"7. Changes\" body_7=\"<p class=\\\"term-text cl-text-2\\\">We may update this policy from time to time to reflect changes to our practices or for operational, legal, or regulatory reasons. The latest version will always be on this page.</p>\"][/term-content]'),('ar',5,'الشروط والأحكام','الشروط القانونية المنطبقة عند استخدامك متجر Amerce.','[page-banner heading=\"Terms & Conditions\"][/page-banner]\n[term-content quantity=\"7\" title_1=\"1. Acceptance of Terms\" body_1=\"<p class=\\\"term-text cl-text-2\\\">By accessing or using the Amerce store you agree to these terms. We reserve the right to update them with reasonable notice; the latest version is always available on this page.</p>\" title_2=\"2. Orders & Payment\" body_2=\"<p class=\\\"term-text cl-text-2\\\">All prices are in USD unless otherwise stated. We accept the payment methods displayed at checkout. An order becomes binding once you receive an order confirmation email.</p>\" title_3=\"3. Shipping\" body_3=\"<p class=\\\"term-text cl-text-2\\\">Shipping options, lead times, and rates are listed on our Shipping page. Risk passes to you on delivery.</p>\" title_4=\"4. Returns\" body_4=\"<p class=\\\"term-text cl-text-2\\\">You have 30 days from delivery to return any unworn item for a refund. See our Returns &amp; Refunds page for the full process.</p>\" title_5=\"5. Intellectual Property\" body_5=\"<p class=\\\"term-text cl-text-2\\\">All content on the Site — text, photography, logos, code — is owned by Amerce or its licensors and may not be reproduced without written permission.</p>\" title_6=\"6. Limitation of Liability\" body_6=\"<p class=\\\"term-text cl-text-2\\\">To the maximum extent permitted by law, Amerce is not liable for indirect or consequential damages arising from use of the Site or the products purchased through it.</p>\" title_7=\"7. Governing Law\" body_7=\"<p class=\\\"term-text cl-text-2\\\">These terms are governed by the laws of the State of New York. Any dispute will be resolved in the state or federal courts located in New York County.</p>\"][/term-content]'),('ar',6,'الإرجاع والاسترداد','سياسة إرجاع لمدة 30 يوماً وإجراءات الإرجاع خطوة بخطوة.','[page-banner heading=\"Returns & Refunds\"][/page-banner]\n[term-content quantity=\"6\" title_1=\"1. Returns\" body_1=\"<p class=\\\"term-text cl-text-2\\\">We want you to be completely satisfied with your purchase. If for any reason you are not, you may return any unworn item within 30 days of receiving your order for a refund or exchange. Items must be in original packaging and the same condition as you received them.</p>\" title_2=\"2. How to Start a Return\" body_2=\"<p class=\\\"term-text cl-text-2\\\">Open the order in your account dashboard and click \\\"Start return\\\", or email returns@amerce.test with your order number. We will send a prepaid return label for domestic orders within one business day.</p>\" title_3=\"3. Refunds\" body_3=\"<p class=\\\"term-text cl-text-2\\\">Refunds are processed within 3-5 business days of us receiving the return and applied to the original payment method. Bank posting times vary; allow up to 10 business days for the credit to appear.</p>\" title_4=\"4. Exclusions\" body_4=\"<p class=\\\"term-text cl-text-2\\\">Sale items, intimate apparel, and final-sale flash sale purchases are excluded from returns. Personalised or made-to-order items are also non-returnable unless faulty.</p>\" title_5=\"5. Damaged or Faulty Items\" body_5=\"<p class=\\\"term-text cl-text-2\\\">If your order arrives damaged or faulty, email us within 7 days with photos. We will replace the item or issue a full refund — including any return shipping cost — at our expense.</p>\" title_6=\"6. International Returns\" body_6=\"<p class=\\\"term-text cl-text-2\\\">International customers are responsible for return shipping unless the item is faulty. We do not refund original shipping or duty charges on international returns.</p>\"][/term-content]'),('ar',7,'الشحن','خيارات الشحن المحلية والدولية ومدد التسليم والرسوم.','[page-banner heading=\"Shipping\"][/page-banner]\n[term-content quantity=\"6\" title_1=\"1. Shipping Methods\" body_1=\"<p class=\\\"term-text cl-text-2\\\">We offer the following shipping methods for domestic and international orders: standard ground, expedited 2-day, and priority overnight (where available).</p>\" title_2=\"2. Domestic Rates\" body_2=\"<p class=\\\"term-text cl-text-2\\\">Standard ground is free on orders over $99. Express 1-2 day shipping is $19.99 flat. Priority overnight is calculated by weight at checkout.</p>\" title_3=\"3. International\" body_3=\"<p class=\\\"term-text cl-text-2\\\">We ship to most countries. International standard shipping is $24.99 with 7-12 business day delivery. Express options appear at checkout. Duties and taxes are pre-paid for select destinations; otherwise the courier collects them on delivery.</p>\" title_4=\"4. Processing Time\" body_4=\"<p class=\\\"term-text cl-text-2\\\">Orders placed before 2pm EST on business days ship the same day. Orders placed after 2pm or on weekends/holidays ship the next business day.</p>\" title_5=\"5. Tracking\" body_5=\"<p class=\\\"term-text cl-text-2\\\">A tracking link is included in your shipment confirmation email. You can also see live status from Account → Orders → Track.</p>\" title_6=\"6. Lost or Stuck Shipments\" body_6=\"<p class=\\\"term-text cl-text-2\\\">If a tracking number has not updated for more than 7 business days, email shipping@amerce.test. We will open an investigation with the carrier and either refund or reship the order at our expense.</p>\"][/term-content]'),('ar',8,'متاجرنا','زُر Amerce على أرض الواقع — متاجرنا الرئيسية وشركاؤنا حول العالم.',''),('ar',9,'Blog','Style guides, product spotlights, and stories from the Amerce team.','<div class=\"container py-5\"><h1>Journal</h1><p>Browse our latest stories — style guides, product spotlights, sustainability deep-dives, and more.</p></div>'),('ar',10,'Careers','Open roles and what it is like to work at Amerce.','<div class=\"container py-5\"><h1>Careers at Amerce</h1><p>We are a small, distributed team building a more thoughtful kind of retail. We hire across product, engineering, supply chain, and customer experience.</p><p>Open roles are posted to our company LinkedIn page. To apply, send a short note and your resume to <a href=\"mailto:careers@amerce.test\">careers@amerce.test</a>.</p></div>'),('ar',11,'Sustainability','How Amerce sources responsibly and reduces its environmental footprint.','<div class=\"container py-5\"><h1>Sustainability at Amerce</h1><p>Every product carries a story. We work directly with mills and ateliers, prioritise recycled and traceable materials, and ship in plastic-free packaging.</p><p>Our 2026 goal: 90% of materials with a verified chain of custody, and a transparent annual impact report.</p></div>'),('ar',12,'الصفحة الرئيسية','Amerce — الصفحة الرئيسية لتجربة تسوّق إلكتروني متعدّدة الاستخدامات.','[simple-slider key=\"home-hero\" style=\"style-1\" is_autoplay=\"yes\" autoplay_speed=\"3000\" show_arrows=\"yes\" show_dots=\"yes\"][/simple-slider]\n[categories-grid style=\"style-grid-5\" title=\"Shop the Season\" subtitle=\"Curated activewear for every routine.\" limit=\"5\"][/categories-grid]\n[ecommerce-products style=\"style-slider\" title=\"Trending Now\" subtitle=\"Featured activewear flying off our shelves.\" source=\"featured\" limit=\"8\" items_per_row=\"4\"][/ecommerce-products]\n[ecommerce-products style=\"style-grid\" title=\"Best Sellers\" subtitle=\"Tried, tested, and loved by our community.\" source=\"best-seller\" limit=\"8\" items_per_row=\"4\"][/ecommerce-products]\n[newsletter-cta style=\"style-default\" heading=\"Subscribe for 10% off\" subheading=\"Plus first dibs on every new drop.\"][/newsletter-cta]'),('fr',1,'À propos','Découvrez Amerce : l\'histoire de la marque, nos exigences d\'approvisionnement et l\'équipe derrière chaque produit.','[page-banner heading=\"About Us\" subtitle=\"With over 15 years of experience, we craft timeless collections that transcend<br class=\\\"d-none d-lg-block\\\">trends and inspire lasting elegance.\"][/page-banner]\n[stats-counter hero_image=\"section/s-contact-1.jpg\" heading=\"Design, attention to detail & efficiency to delight the world\" description=\"From the moment it is conceived to the moment it is worn, every one of our garments follows this path. We could do it at a fast pace. However, at Amerce, we choose to take care of all those who are walking this path with us.\" quantity=\"4\" value_1=\"8.2k\" animate_to_1=\"\" suffix_1=\"\" label_1=\"Products Available\" desc_1=\"We offer a wide selection of high-quality products to meet every need.\" value_2=\"\" animate_to_2=\"10\" suffix_2=\"k\" label_2=\"Happy Customers\" desc_2=\"Serving over 10,000 delighted customers who trust us for quality and service.\" value_3=\"\" animate_to_3=\"96\" suffix_3=\"\" label_3=\"Partner Brand\" desc_3=\"Our top-brand partnerships bring a trusted collection for your store and home.\" value_4=\"\" animate_to_4=\"16\" suffix_4=\"k\" label_4=\"Products For Sale\" desc_4=\"That\'s why we strive to offer a diverse range of products that cater to all styles.\"][/stats-counter]\n[image-accordion image=\"section/s-contact-2.jpg\" heading=\"Offering Rare And Beautiful Items Worldwide\" quantity=\"4\" title_1=\"Introduction\" body_1=\"Welcome to Amerce Store, your premier destination for fashion-forward clothing and accessories. We pride ourselves on offering a curated selection of rare and beautiful items sourced both locally and globally.\" title_2=\"Our Vision\" body_2=\"We envision a world where thoughtful design meets everyday life — pieces that age gracefully, partners we trust, and customers we treat as people, not transactions.\" title_3=\"What Sets Us Apart\" body_3=\"Independently audited suppliers, hand-checked products, and a 30-day no-questions return policy backed by a human customer support team.\" title_4=\"Our Commitment\" body_4=\"Quality goods, transparent supply chains, and fair labor — every order, every time.\"][/image-accordion]\n[about-testimonials heading=\"Customer Say!\" subtitle=\"Our customers adore our products, and we constantly aim to delight them.\" quantity=\"2\" image_1=\"testimonials/tes-1.jpg\" name_1=\"Emma Collins\" text_1=\"\\\"Totally obsessed with this outfit! The fit is perfect, the fabric feels premium, and I\'ve been getting compliments non-stop. It instantly lifts my confidence — such a great find!\\\"\" image_2=\"testimonials/tes-2.jpg\" name_2=\"Sophia Ramirez\" text_2=\"\\\"I\'m amazed by how comfortable yet stylish this piece is. It pairs effortlessly with everything, and the quality really stands out. Definitely becoming my go-to for everyday looks!\\\"\"][/about-testimonials]\n[about-team heading=\"Meet Our Teams\" subtitle=\"Experts committed to excellence in every detail.\" quantity=\"4\" image_1=\"member/member-1.jpg\" name_1=\"Annette Black\" role_1=\"Founder/CEO\" social_links_1=\"\" image_2=\"member/member-2.jpg\" name_2=\"Brooklyn Simmons\" role_2=\"Manager\" social_links_2=\"\" image_3=\"member/member-3.jpg\" name_3=\"Jane Cooper\" role_3=\"Sales Director\" social_links_3=\"\" image_4=\"member/member-4.jpg\" name_4=\"Lisa Bonet\" role_4=\"Sales Director\" social_links_4=\"\"][/about-team]'),('fr',2,'Contact','Contactez les équipes service client et partenariats d\'Amerce.',''),('fr',3,'FAQ','Réponses aux questions les plus fréquentes sur les commandes, la livraison, les retours et la gestion de votre compte.','[page-banner heading=\"FAQs\" subtitle=\"Got questions? We\'ve got answers! Browse our FAQs to find information on orders, shipping,<br class=\\\"d-none d-lg-block\\\">returns, and more. If you need further assistance, feel free to contact our team.\"][/page-banner]\n[faq-page sidebar_image=\"section/banner-12.jpg\" sidebar_title=\"Save 25% <br class=\\\"d-none d-sm-block\\\">Today\" sidebar_subtitle=\"T-Shirts, Hoodies & More\" sidebar_cta=\"View More\" sidebar_url=\"/products\" quantity=\"16\" category_1=\"My Account\" category_id_1=\"myAccount\" question_1=\"1. What can I do if I forgot my password?\" answer_1=\"Use the \\\"Forgot password\\\" link on the sign-in page. We will email you a one-time link to set a new password — it expires in 30 minutes for security.\" category_2=\"My Account\" category_id_2=\"myAccount\" question_2=\"2. How do I update my email address?\" answer_2=\"Sign in, open Account → Settings, and change the email field. We send a confirmation email to the new address; the change takes effect once you click that link.\" category_3=\"My Account\" category_id_3=\"myAccount\" question_3=\"3. Can I delete my account?\" answer_3=\"Yes. From Account → Settings, scroll to Delete account. We retain order history for tax/legal reasons but personal contact details are removed within 30 days.\" category_4=\"Orders & Purchases\" category_id_4=\"ordersPurchases\" question_4=\"1. How do I place an order?\" answer_4=\"Add items to your cart, click checkout, choose a shipping method, then enter your payment details. You will receive an order confirmation email immediately.\" category_5=\"Orders & Purchases\" category_id_5=\"ordersPurchases\" question_5=\"2. Can I edit or cancel an order?\" answer_5=\"Orders can be edited or cancelled from your account dashboard within 1 hour of placement. After that the warehouse has begun picking and we cannot intercept.\" category_6=\"Orders & Purchases\" category_id_6=\"ordersPurchases\" question_6=\"3. What payment methods are accepted?\" answer_6=\"We accept Visa, Mastercard, American Express, Apple Pay, Google Pay, and PayPal. All transactions use TLS 1.3 encryption.\" category_7=\"Returns & Refunds\" category_id_7=\"returnsRefunds\" question_7=\"1. What is the return window?\" answer_7=\"30 days from delivery for any unworn item in original condition. Sale items, intimate apparel, and final-sale flash sale purchases are excluded.\" category_8=\"Returns & Refunds\" category_id_8=\"returnsRefunds\" question_8=\"2. How do I start a return?\" answer_8=\"Open the order in your account dashboard and click \\\"Start return\\\". We email a prepaid label for domestic orders within one business day.\" category_9=\"Returns & Refunds\" category_id_9=\"returnsRefunds\" question_9=\"3. When will I see my refund?\" answer_9=\"Refunds are processed within 3-5 business days of us receiving the return. Bank posting times vary; allow up to 10 business days for the credit to appear.\" category_10=\"Shipping & Tracking\" category_id_10=\"shippingTracking\" question_10=\"1. How long does shipping take?\" answer_10=\"Domestic standard ships in 3-5 business days. Express in 1-2. International standard takes 7-12 business days; express options are available at checkout.\" category_11=\"Shipping & Tracking\" category_id_11=\"shippingTracking\" question_11=\"2. How do I track my order?\" answer_11=\"A tracking link is included in your shipment confirmation email. You can also see status from Account → Orders → Track.\" category_12=\"Shipping & Tracking\" category_id_12=\"shippingTracking\" question_12=\"3. Do you ship internationally?\" answer_12=\"Yes — to most countries. Duties and taxes are pre-paid at checkout for select destinations; otherwise the courier may collect them on delivery.\" category_13=\"Fees & Billing\" category_id_13=\"feesBilling\" question_13=\"1. Are duties and taxes included?\" answer_13=\"Domestic prices include sales tax shown at checkout. International orders to supported destinations include duties and taxes; otherwise the courier collects on delivery.\" category_14=\"Fees & Billing\" category_id_14=\"feesBilling\" question_14=\"2. Why was I charged twice?\" answer_14=\"You likely see a temporary authorization hold plus the actual charge. The authorization drops off in 3-5 business days. Email billing@amerce.test if you still see two charges after that.\" category_15=\"Other Topic\" category_id_15=\"otherTopic\" question_15=\"1. Do you have physical stores?\" answer_15=\"Yes — visit our Stores page for a list of flagship and partner locations.\" category_16=\"Other Topic\" category_id_16=\"otherTopic\" question_16=\"2. How can I contact customer support?\" answer_16=\"Email hello@amerce.test or use the contact form. We reply within one business day.\"][/faq-page]'),('fr',4,'Politique de confidentialité','Comment Amerce collecte, utilise et protège vos données personnelles.','[page-banner heading=\"Privacy Policy\"][/page-banner]\n[term-content quantity=\"7\" title_1=\"1. Information We Collect\" body_1=\"<p class=\\\"term-text cl-text-2\\\">When you visit the Site, we automatically collect certain information about your device — web browser, IP address, time zone, and some of the cookies installed on your device. As you browse, we also collect data about the pages or products you view, what referred you to the Site, and how you interact with it. We refer to this as \\\"Device Information\\\".</p><p class=\\\"term-text cl-text-2\\\">When you make a purchase or attempt to purchase through the Site, we collect your name, billing address, shipping address, and payment information (including card number, email address, and phone number). We refer to this as \\\"Order Information\\\".</p>\" title_2=\"2. How We Use Your Information\" body_2=\"<p class=\\\"term-text cl-text-2\\\">We use Order Information to fulfil orders placed through the Site (process payment, arrange shipping, provide invoices and order confirmations). We use it to communicate with you, screen orders for fraud, and — in line with your preferences — share marketing about products you may like.</p><p class=\\\"term-text cl-text-2\\\">We use Device Information to screen for fraud and to improve the Site through analytics about how customers browse and interact with us.</p>\" title_3=\"3. Sharing Your Personal Information\" body_3=\"<p class=\\\"term-text cl-text-2\\\">We share Personal Information with third-party service providers who help us run the Site. We may also share information to comply with applicable laws, respond to a subpoena or lawful request, or otherwise protect our rights.</p>\" title_4=\"4. Data Retention\" body_4=\"<p class=\\\"term-text cl-text-2\\\">When you place an order, we maintain the Order Information for our records unless and until you ask us to delete it.</p>\" title_5=\"5. Your Rights\" body_5=\"<p class=\\\"term-text cl-text-2\\\">You can request access, correction, or deletion of any personal data we hold about you. Email privacy@amerce.test from the address on file and we will respond within 30 days.</p>\" title_6=\"6. Cookies\" body_6=\"<p class=\\\"term-text cl-text-2\\\">Cookies are used to keep your cart between visits, remember your preferences, and measure aggregate traffic. You can disable cookies in your browser, though some Site features may stop working.</p>\" title_7=\"7. Changes\" body_7=\"<p class=\\\"term-text cl-text-2\\\">We may update this policy from time to time to reflect changes to our practices or for operational, legal, or regulatory reasons. The latest version will always be on this page.</p>\"][/term-content]'),('fr',5,'Conditions générales','Les conditions juridiques applicables à votre utilisation de la boutique Amerce.','[page-banner heading=\"Terms & Conditions\"][/page-banner]\n[term-content quantity=\"7\" title_1=\"1. Acceptance of Terms\" body_1=\"<p class=\\\"term-text cl-text-2\\\">By accessing or using the Amerce store you agree to these terms. We reserve the right to update them with reasonable notice; the latest version is always available on this page.</p>\" title_2=\"2. Orders & Payment\" body_2=\"<p class=\\\"term-text cl-text-2\\\">All prices are in USD unless otherwise stated. We accept the payment methods displayed at checkout. An order becomes binding once you receive an order confirmation email.</p>\" title_3=\"3. Shipping\" body_3=\"<p class=\\\"term-text cl-text-2\\\">Shipping options, lead times, and rates are listed on our Shipping page. Risk passes to you on delivery.</p>\" title_4=\"4. Returns\" body_4=\"<p class=\\\"term-text cl-text-2\\\">You have 30 days from delivery to return any unworn item for a refund. See our Returns &amp; Refunds page for the full process.</p>\" title_5=\"5. Intellectual Property\" body_5=\"<p class=\\\"term-text cl-text-2\\\">All content on the Site — text, photography, logos, code — is owned by Amerce or its licensors and may not be reproduced without written permission.</p>\" title_6=\"6. Limitation of Liability\" body_6=\"<p class=\\\"term-text cl-text-2\\\">To the maximum extent permitted by law, Amerce is not liable for indirect or consequential damages arising from use of the Site or the products purchased through it.</p>\" title_7=\"7. Governing Law\" body_7=\"<p class=\\\"term-text cl-text-2\\\">These terms are governed by the laws of the State of New York. Any dispute will be resolved in the state or federal courts located in New York County.</p>\"][/term-content]'),('fr',6,'Retours & remboursements','Notre politique de retour de 30 jours et la marche à suivre, étape par étape.','[page-banner heading=\"Returns & Refunds\"][/page-banner]\n[term-content quantity=\"6\" title_1=\"1. Returns\" body_1=\"<p class=\\\"term-text cl-text-2\\\">We want you to be completely satisfied with your purchase. If for any reason you are not, you may return any unworn item within 30 days of receiving your order for a refund or exchange. Items must be in original packaging and the same condition as you received them.</p>\" title_2=\"2. How to Start a Return\" body_2=\"<p class=\\\"term-text cl-text-2\\\">Open the order in your account dashboard and click \\\"Start return\\\", or email returns@amerce.test with your order number. We will send a prepaid return label for domestic orders within one business day.</p>\" title_3=\"3. Refunds\" body_3=\"<p class=\\\"term-text cl-text-2\\\">Refunds are processed within 3-5 business days of us receiving the return and applied to the original payment method. Bank posting times vary; allow up to 10 business days for the credit to appear.</p>\" title_4=\"4. Exclusions\" body_4=\"<p class=\\\"term-text cl-text-2\\\">Sale items, intimate apparel, and final-sale flash sale purchases are excluded from returns. Personalised or made-to-order items are also non-returnable unless faulty.</p>\" title_5=\"5. Damaged or Faulty Items\" body_5=\"<p class=\\\"term-text cl-text-2\\\">If your order arrives damaged or faulty, email us within 7 days with photos. We will replace the item or issue a full refund — including any return shipping cost — at our expense.</p>\" title_6=\"6. International Returns\" body_6=\"<p class=\\\"term-text cl-text-2\\\">International customers are responsible for return shipping unless the item is faulty. We do not refund original shipping or duty charges on international returns.</p>\"][/term-content]'),('fr',7,'Livraison','Modes de livraison nationaux et internationaux, délais et tarifs.','[page-banner heading=\"Shipping\"][/page-banner]\n[term-content quantity=\"6\" title_1=\"1. Shipping Methods\" body_1=\"<p class=\\\"term-text cl-text-2\\\">We offer the following shipping methods for domestic and international orders: standard ground, expedited 2-day, and priority overnight (where available).</p>\" title_2=\"2. Domestic Rates\" body_2=\"<p class=\\\"term-text cl-text-2\\\">Standard ground is free on orders over $99. Express 1-2 day shipping is $19.99 flat. Priority overnight is calculated by weight at checkout.</p>\" title_3=\"3. International\" body_3=\"<p class=\\\"term-text cl-text-2\\\">We ship to most countries. International standard shipping is $24.99 with 7-12 business day delivery. Express options appear at checkout. Duties and taxes are pre-paid for select destinations; otherwise the courier collects them on delivery.</p>\" title_4=\"4. Processing Time\" body_4=\"<p class=\\\"term-text cl-text-2\\\">Orders placed before 2pm EST on business days ship the same day. Orders placed after 2pm or on weekends/holidays ship the next business day.</p>\" title_5=\"5. Tracking\" body_5=\"<p class=\\\"term-text cl-text-2\\\">A tracking link is included in your shipment confirmation email. You can also see live status from Account → Orders → Track.</p>\" title_6=\"6. Lost or Stuck Shipments\" body_6=\"<p class=\\\"term-text cl-text-2\\\">If a tracking number has not updated for more than 7 business days, email shipping@amerce.test. We will open an investigation with the carrier and either refund or reship the order at our expense.</p>\"][/term-content]'),('fr',8,'Nos boutiques','Rendez visite à Amerce en personne : nos boutiques flagship et nos points de vente partenaires dans le monde entier.',''),('fr',9,'Blog','Style guides, product spotlights, and stories from the Amerce team.','<div class=\"container py-5\"><h1>Journal</h1><p>Browse our latest stories — style guides, product spotlights, sustainability deep-dives, and more.</p></div>'),('fr',10,'Careers','Open roles and what it is like to work at Amerce.','<div class=\"container py-5\"><h1>Careers at Amerce</h1><p>We are a small, distributed team building a more thoughtful kind of retail. We hire across product, engineering, supply chain, and customer experience.</p><p>Open roles are posted to our company LinkedIn page. To apply, send a short note and your resume to <a href=\"mailto:careers@amerce.test\">careers@amerce.test</a>.</p></div>'),('fr',11,'Sustainability','How Amerce sources responsibly and reduces its environmental footprint.','<div class=\"container py-5\"><h1>Sustainability at Amerce</h1><p>Every product carries a story. We work directly with mills and ateliers, prioritise recycled and traceable materials, and ship in plastic-free packaging.</p><p>Our 2026 goal: 90% of materials with a verified chain of custody, and a transparent annual impact report.</p></div>'),('fr',12,'Accueil','Amerce — la page d\'accueil d\'une expérience e-commerce polyvalente.','[simple-slider key=\"home-hero\" style=\"style-1\" is_autoplay=\"yes\" autoplay_speed=\"3000\" show_arrows=\"yes\" show_dots=\"yes\"][/simple-slider]\n[categories-grid style=\"style-grid-5\" title=\"Shop the Season\" subtitle=\"Curated activewear for every routine.\" limit=\"5\"][/categories-grid]\n[ecommerce-products style=\"style-slider\" title=\"Trending Now\" subtitle=\"Featured activewear flying off our shelves.\" source=\"featured\" limit=\"8\" items_per_row=\"4\"][/ecommerce-products]\n[ecommerce-products style=\"style-grid\" title=\"Best Sellers\" subtitle=\"Tried, tested, and loved by our community.\" source=\"best-seller\" limit=\"8\" items_per_row=\"4\"][/ecommerce-products]\n[newsletter-cta style=\"style-default\" heading=\"Subscribe for 10% off\" subheading=\"Plus first dibs on every new drop.\"][/newsletter-cta]'),('id',1,'Tentang Kami','Tentang Amerce — kisah merek, standar pengadaan, dan tim di balik setiap produk.','[page-banner heading=\"About Us\" subtitle=\"With over 15 years of experience, we craft timeless collections that transcend<br class=\\\"d-none d-lg-block\\\">trends and inspire lasting elegance.\"][/page-banner]\n[stats-counter hero_image=\"section/s-contact-1.jpg\" heading=\"Design, attention to detail & efficiency to delight the world\" description=\"From the moment it is conceived to the moment it is worn, every one of our garments follows this path. We could do it at a fast pace. However, at Amerce, we choose to take care of all those who are walking this path with us.\" quantity=\"4\" value_1=\"8.2k\" animate_to_1=\"\" suffix_1=\"\" label_1=\"Products Available\" desc_1=\"We offer a wide selection of high-quality products to meet every need.\" value_2=\"\" animate_to_2=\"10\" suffix_2=\"k\" label_2=\"Happy Customers\" desc_2=\"Serving over 10,000 delighted customers who trust us for quality and service.\" value_3=\"\" animate_to_3=\"96\" suffix_3=\"\" label_3=\"Partner Brand\" desc_3=\"Our top-brand partnerships bring a trusted collection for your store and home.\" value_4=\"\" animate_to_4=\"16\" suffix_4=\"k\" label_4=\"Products For Sale\" desc_4=\"That\'s why we strive to offer a diverse range of products that cater to all styles.\"][/stats-counter]\n[image-accordion image=\"section/s-contact-2.jpg\" heading=\"Offering Rare And Beautiful Items Worldwide\" quantity=\"4\" title_1=\"Introduction\" body_1=\"Welcome to Amerce Store, your premier destination for fashion-forward clothing and accessories. We pride ourselves on offering a curated selection of rare and beautiful items sourced both locally and globally.\" title_2=\"Our Vision\" body_2=\"We envision a world where thoughtful design meets everyday life — pieces that age gracefully, partners we trust, and customers we treat as people, not transactions.\" title_3=\"What Sets Us Apart\" body_3=\"Independently audited suppliers, hand-checked products, and a 30-day no-questions return policy backed by a human customer support team.\" title_4=\"Our Commitment\" body_4=\"Quality goods, transparent supply chains, and fair labor — every order, every time.\"][/image-accordion]\n[about-testimonials heading=\"Customer Say!\" subtitle=\"Our customers adore our products, and we constantly aim to delight them.\" quantity=\"2\" image_1=\"testimonials/tes-1.jpg\" name_1=\"Emma Collins\" text_1=\"\\\"Totally obsessed with this outfit! The fit is perfect, the fabric feels premium, and I\'ve been getting compliments non-stop. It instantly lifts my confidence — such a great find!\\\"\" image_2=\"testimonials/tes-2.jpg\" name_2=\"Sophia Ramirez\" text_2=\"\\\"I\'m amazed by how comfortable yet stylish this piece is. It pairs effortlessly with everything, and the quality really stands out. Definitely becoming my go-to for everyday looks!\\\"\"][/about-testimonials]\n[about-team heading=\"Meet Our Teams\" subtitle=\"Experts committed to excellence in every detail.\" quantity=\"4\" image_1=\"member/member-1.jpg\" name_1=\"Annette Black\" role_1=\"Founder/CEO\" social_links_1=\"\" image_2=\"member/member-2.jpg\" name_2=\"Brooklyn Simmons\" role_2=\"Manager\" social_links_2=\"\" image_3=\"member/member-3.jpg\" name_3=\"Jane Cooper\" role_3=\"Sales Director\" social_links_3=\"\" image_4=\"member/member-4.jpg\" name_4=\"Lisa Bonet\" role_4=\"Sales Director\" social_links_4=\"\"][/about-team]'),('id',2,'Kontak','Hubungi tim layanan pelanggan dan kemitraan Amerce.',''),('id',3,'Pertanyaan Umum','Pertanyaan yang sering diajukan tentang pesanan, pengiriman, pengembalian, dan pengelolaan akun.','[page-banner heading=\"FAQs\" subtitle=\"Got questions? We\'ve got answers! Browse our FAQs to find information on orders, shipping,<br class=\\\"d-none d-lg-block\\\">returns, and more. If you need further assistance, feel free to contact our team.\"][/page-banner]\n[faq-page sidebar_image=\"section/banner-12.jpg\" sidebar_title=\"Save 25% <br class=\\\"d-none d-sm-block\\\">Today\" sidebar_subtitle=\"T-Shirts, Hoodies & More\" sidebar_cta=\"View More\" sidebar_url=\"/products\" quantity=\"16\" category_1=\"My Account\" category_id_1=\"myAccount\" question_1=\"1. What can I do if I forgot my password?\" answer_1=\"Use the \\\"Forgot password\\\" link on the sign-in page. We will email you a one-time link to set a new password — it expires in 30 minutes for security.\" category_2=\"My Account\" category_id_2=\"myAccount\" question_2=\"2. How do I update my email address?\" answer_2=\"Sign in, open Account → Settings, and change the email field. We send a confirmation email to the new address; the change takes effect once you click that link.\" category_3=\"My Account\" category_id_3=\"myAccount\" question_3=\"3. Can I delete my account?\" answer_3=\"Yes. From Account → Settings, scroll to Delete account. We retain order history for tax/legal reasons but personal contact details are removed within 30 days.\" category_4=\"Orders & Purchases\" category_id_4=\"ordersPurchases\" question_4=\"1. How do I place an order?\" answer_4=\"Add items to your cart, click checkout, choose a shipping method, then enter your payment details. You will receive an order confirmation email immediately.\" category_5=\"Orders & Purchases\" category_id_5=\"ordersPurchases\" question_5=\"2. Can I edit or cancel an order?\" answer_5=\"Orders can be edited or cancelled from your account dashboard within 1 hour of placement. After that the warehouse has begun picking and we cannot intercept.\" category_6=\"Orders & Purchases\" category_id_6=\"ordersPurchases\" question_6=\"3. What payment methods are accepted?\" answer_6=\"We accept Visa, Mastercard, American Express, Apple Pay, Google Pay, and PayPal. All transactions use TLS 1.3 encryption.\" category_7=\"Returns & Refunds\" category_id_7=\"returnsRefunds\" question_7=\"1. What is the return window?\" answer_7=\"30 days from delivery for any unworn item in original condition. Sale items, intimate apparel, and final-sale flash sale purchases are excluded.\" category_8=\"Returns & Refunds\" category_id_8=\"returnsRefunds\" question_8=\"2. How do I start a return?\" answer_8=\"Open the order in your account dashboard and click \\\"Start return\\\". We email a prepaid label for domestic orders within one business day.\" category_9=\"Returns & Refunds\" category_id_9=\"returnsRefunds\" question_9=\"3. When will I see my refund?\" answer_9=\"Refunds are processed within 3-5 business days of us receiving the return. Bank posting times vary; allow up to 10 business days for the credit to appear.\" category_10=\"Shipping & Tracking\" category_id_10=\"shippingTracking\" question_10=\"1. How long does shipping take?\" answer_10=\"Domestic standard ships in 3-5 business days. Express in 1-2. International standard takes 7-12 business days; express options are available at checkout.\" category_11=\"Shipping & Tracking\" category_id_11=\"shippingTracking\" question_11=\"2. How do I track my order?\" answer_11=\"A tracking link is included in your shipment confirmation email. You can also see status from Account → Orders → Track.\" category_12=\"Shipping & Tracking\" category_id_12=\"shippingTracking\" question_12=\"3. Do you ship internationally?\" answer_12=\"Yes — to most countries. Duties and taxes are pre-paid at checkout for select destinations; otherwise the courier may collect them on delivery.\" category_13=\"Fees & Billing\" category_id_13=\"feesBilling\" question_13=\"1. Are duties and taxes included?\" answer_13=\"Domestic prices include sales tax shown at checkout. International orders to supported destinations include duties and taxes; otherwise the courier collects on delivery.\" category_14=\"Fees & Billing\" category_id_14=\"feesBilling\" question_14=\"2. Why was I charged twice?\" answer_14=\"You likely see a temporary authorization hold plus the actual charge. The authorization drops off in 3-5 business days. Email billing@amerce.test if you still see two charges after that.\" category_15=\"Other Topic\" category_id_15=\"otherTopic\" question_15=\"1. Do you have physical stores?\" answer_15=\"Yes — visit our Stores page for a list of flagship and partner locations.\" category_16=\"Other Topic\" category_id_16=\"otherTopic\" question_16=\"2. How can I contact customer support?\" answer_16=\"Email hello@amerce.test or use the contact form. We reply within one business day.\"][/faq-page]'),('id',4,'Kebijakan Privasi','Bagaimana Amerce mengumpulkan, menggunakan, dan melindungi informasi pribadi Anda.','[page-banner heading=\"Privacy Policy\"][/page-banner]\n[term-content quantity=\"7\" title_1=\"1. Information We Collect\" body_1=\"<p class=\\\"term-text cl-text-2\\\">When you visit the Site, we automatically collect certain information about your device — web browser, IP address, time zone, and some of the cookies installed on your device. As you browse, we also collect data about the pages or products you view, what referred you to the Site, and how you interact with it. We refer to this as \\\"Device Information\\\".</p><p class=\\\"term-text cl-text-2\\\">When you make a purchase or attempt to purchase through the Site, we collect your name, billing address, shipping address, and payment information (including card number, email address, and phone number). We refer to this as \\\"Order Information\\\".</p>\" title_2=\"2. How We Use Your Information\" body_2=\"<p class=\\\"term-text cl-text-2\\\">We use Order Information to fulfil orders placed through the Site (process payment, arrange shipping, provide invoices and order confirmations). We use it to communicate with you, screen orders for fraud, and — in line with your preferences — share marketing about products you may like.</p><p class=\\\"term-text cl-text-2\\\">We use Device Information to screen for fraud and to improve the Site through analytics about how customers browse and interact with us.</p>\" title_3=\"3. Sharing Your Personal Information\" body_3=\"<p class=\\\"term-text cl-text-2\\\">We share Personal Information with third-party service providers who help us run the Site. We may also share information to comply with applicable laws, respond to a subpoena or lawful request, or otherwise protect our rights.</p>\" title_4=\"4. Data Retention\" body_4=\"<p class=\\\"term-text cl-text-2\\\">When you place an order, we maintain the Order Information for our records unless and until you ask us to delete it.</p>\" title_5=\"5. Your Rights\" body_5=\"<p class=\\\"term-text cl-text-2\\\">You can request access, correction, or deletion of any personal data we hold about you. Email privacy@amerce.test from the address on file and we will respond within 30 days.</p>\" title_6=\"6. Cookies\" body_6=\"<p class=\\\"term-text cl-text-2\\\">Cookies are used to keep your cart between visits, remember your preferences, and measure aggregate traffic. You can disable cookies in your browser, though some Site features may stop working.</p>\" title_7=\"7. Changes\" body_7=\"<p class=\\\"term-text cl-text-2\\\">We may update this policy from time to time to reflect changes to our practices or for operational, legal, or regulatory reasons. The latest version will always be on this page.</p>\"][/term-content]'),('id',5,'Syarat & Ketentuan','Ketentuan hukum yang berlaku saat Anda menggunakan toko Amerce.','[page-banner heading=\"Terms & Conditions\"][/page-banner]\n[term-content quantity=\"7\" title_1=\"1. Acceptance of Terms\" body_1=\"<p class=\\\"term-text cl-text-2\\\">By accessing or using the Amerce store you agree to these terms. We reserve the right to update them with reasonable notice; the latest version is always available on this page.</p>\" title_2=\"2. Orders & Payment\" body_2=\"<p class=\\\"term-text cl-text-2\\\">All prices are in USD unless otherwise stated. We accept the payment methods displayed at checkout. An order becomes binding once you receive an order confirmation email.</p>\" title_3=\"3. Shipping\" body_3=\"<p class=\\\"term-text cl-text-2\\\">Shipping options, lead times, and rates are listed on our Shipping page. Risk passes to you on delivery.</p>\" title_4=\"4. Returns\" body_4=\"<p class=\\\"term-text cl-text-2\\\">You have 30 days from delivery to return any unworn item for a refund. See our Returns &amp; Refunds page for the full process.</p>\" title_5=\"5. Intellectual Property\" body_5=\"<p class=\\\"term-text cl-text-2\\\">All content on the Site — text, photography, logos, code — is owned by Amerce or its licensors and may not be reproduced without written permission.</p>\" title_6=\"6. Limitation of Liability\" body_6=\"<p class=\\\"term-text cl-text-2\\\">To the maximum extent permitted by law, Amerce is not liable for indirect or consequential damages arising from use of the Site or the products purchased through it.</p>\" title_7=\"7. Governing Law\" body_7=\"<p class=\\\"term-text cl-text-2\\\">These terms are governed by the laws of the State of New York. Any dispute will be resolved in the state or federal courts located in New York County.</p>\"][/term-content]'),('id',6,'Pengembalian & Refund','Kebijakan pengembalian 30 hari kami beserta proses pengembalian langkah demi langkah.','[page-banner heading=\"Returns & Refunds\"][/page-banner]\n[term-content quantity=\"6\" title_1=\"1. Returns\" body_1=\"<p class=\\\"term-text cl-text-2\\\">We want you to be completely satisfied with your purchase. If for any reason you are not, you may return any unworn item within 30 days of receiving your order for a refund or exchange. Items must be in original packaging and the same condition as you received them.</p>\" title_2=\"2. How to Start a Return\" body_2=\"<p class=\\\"term-text cl-text-2\\\">Open the order in your account dashboard and click \\\"Start return\\\", or email returns@amerce.test with your order number. We will send a prepaid return label for domestic orders within one business day.</p>\" title_3=\"3. Refunds\" body_3=\"<p class=\\\"term-text cl-text-2\\\">Refunds are processed within 3-5 business days of us receiving the return and applied to the original payment method. Bank posting times vary; allow up to 10 business days for the credit to appear.</p>\" title_4=\"4. Exclusions\" body_4=\"<p class=\\\"term-text cl-text-2\\\">Sale items, intimate apparel, and final-sale flash sale purchases are excluded from returns. Personalised or made-to-order items are also non-returnable unless faulty.</p>\" title_5=\"5. Damaged or Faulty Items\" body_5=\"<p class=\\\"term-text cl-text-2\\\">If your order arrives damaged or faulty, email us within 7 days with photos. We will replace the item or issue a full refund — including any return shipping cost — at our expense.</p>\" title_6=\"6. International Returns\" body_6=\"<p class=\\\"term-text cl-text-2\\\">International customers are responsible for return shipping unless the item is faulty. We do not refund original shipping or duty charges on international returns.</p>\"][/term-content]'),('id',7,'Pengiriman','Metode pengiriman domestik dan internasional, estimasi waktu, dan tarifnya.','[page-banner heading=\"Shipping\"][/page-banner]\n[term-content quantity=\"6\" title_1=\"1. Shipping Methods\" body_1=\"<p class=\\\"term-text cl-text-2\\\">We offer the following shipping methods for domestic and international orders: standard ground, expedited 2-day, and priority overnight (where available).</p>\" title_2=\"2. Domestic Rates\" body_2=\"<p class=\\\"term-text cl-text-2\\\">Standard ground is free on orders over $99. Express 1-2 day shipping is $19.99 flat. Priority overnight is calculated by weight at checkout.</p>\" title_3=\"3. International\" body_3=\"<p class=\\\"term-text cl-text-2\\\">We ship to most countries. International standard shipping is $24.99 with 7-12 business day delivery. Express options appear at checkout. Duties and taxes are pre-paid for select destinations; otherwise the courier collects them on delivery.</p>\" title_4=\"4. Processing Time\" body_4=\"<p class=\\\"term-text cl-text-2\\\">Orders placed before 2pm EST on business days ship the same day. Orders placed after 2pm or on weekends/holidays ship the next business day.</p>\" title_5=\"5. Tracking\" body_5=\"<p class=\\\"term-text cl-text-2\\\">A tracking link is included in your shipment confirmation email. You can also see live status from Account → Orders → Track.</p>\" title_6=\"6. Lost or Stuck Shipments\" body_6=\"<p class=\\\"term-text cl-text-2\\\">If a tracking number has not updated for more than 7 business days, email shipping@amerce.test. We will open an investigation with the carrier and either refund or reship the order at our expense.</p>\"][/term-content]'),('id',8,'Toko Kami','Kunjungi Amerce secara langsung — toko unggulan dan toko mitra di seluruh dunia.',''),('id',9,'Blog','Style guides, product spotlights, and stories from the Amerce team.','<div class=\"container py-5\"><h1>Journal</h1><p>Browse our latest stories — style guides, product spotlights, sustainability deep-dives, and more.</p></div>'),('id',10,'Careers','Open roles and what it is like to work at Amerce.','<div class=\"container py-5\"><h1>Careers at Amerce</h1><p>We are a small, distributed team building a more thoughtful kind of retail. We hire across product, engineering, supply chain, and customer experience.</p><p>Open roles are posted to our company LinkedIn page. To apply, send a short note and your resume to <a href=\"mailto:careers@amerce.test\">careers@amerce.test</a>.</p></div>'),('id',11,'Sustainability','How Amerce sources responsibly and reduces its environmental footprint.','<div class=\"container py-5\"><h1>Sustainability at Amerce</h1><p>Every product carries a story. We work directly with mills and ateliers, prioritise recycled and traceable materials, and ship in plastic-free packaging.</p><p>Our 2026 goal: 90% of materials with a verified chain of custody, and a transparent annual impact report.</p></div>'),('id',12,'Beranda','Amerce — beranda pengalaman e-commerce serbaguna.','[simple-slider key=\"home-hero\" style=\"style-1\" is_autoplay=\"yes\" autoplay_speed=\"3000\" show_arrows=\"yes\" show_dots=\"yes\"][/simple-slider]\n[categories-grid style=\"style-grid-5\" title=\"Shop the Season\" subtitle=\"Curated activewear for every routine.\" limit=\"5\"][/categories-grid]\n[ecommerce-products style=\"style-slider\" title=\"Trending Now\" subtitle=\"Featured activewear flying off our shelves.\" source=\"featured\" limit=\"8\" items_per_row=\"4\"][/ecommerce-products]\n[ecommerce-products style=\"style-grid\" title=\"Best Sellers\" subtitle=\"Tried, tested, and loved by our community.\" source=\"best-seller\" limit=\"8\" items_per_row=\"4\"][/ecommerce-products]\n[newsletter-cta style=\"style-default\" heading=\"Subscribe for 10% off\" subheading=\"Plus first dibs on every new drop.\"][/newsletter-cta]'),('vi',1,'Giới thiệu','Giới thiệu Amerce — câu chuyện thương hiệu, tiêu chuẩn nguồn cung và đội ngũ đứng sau từng sản phẩm.','[page-banner heading=\"About Us\" subtitle=\"With over 15 years of experience, we craft timeless collections that transcend<br class=\\\"d-none d-lg-block\\\">trends and inspire lasting elegance.\"][/page-banner]\n[stats-counter hero_image=\"section/s-contact-1.jpg\" heading=\"Design, attention to detail & efficiency to delight the world\" description=\"From the moment it is conceived to the moment it is worn, every one of our garments follows this path. We could do it at a fast pace. However, at Amerce, we choose to take care of all those who are walking this path with us.\" quantity=\"4\" value_1=\"8.2k\" animate_to_1=\"\" suffix_1=\"\" label_1=\"Products Available\" desc_1=\"We offer a wide selection of high-quality products to meet every need.\" value_2=\"\" animate_to_2=\"10\" suffix_2=\"k\" label_2=\"Happy Customers\" desc_2=\"Serving over 10,000 delighted customers who trust us for quality and service.\" value_3=\"\" animate_to_3=\"96\" suffix_3=\"\" label_3=\"Partner Brand\" desc_3=\"Our top-brand partnerships bring a trusted collection for your store and home.\" value_4=\"\" animate_to_4=\"16\" suffix_4=\"k\" label_4=\"Products For Sale\" desc_4=\"That\'s why we strive to offer a diverse range of products that cater to all styles.\"][/stats-counter]\n[image-accordion image=\"section/s-contact-2.jpg\" heading=\"Offering Rare And Beautiful Items Worldwide\" quantity=\"4\" title_1=\"Introduction\" body_1=\"Welcome to Amerce Store, your premier destination for fashion-forward clothing and accessories. We pride ourselves on offering a curated selection of rare and beautiful items sourced both locally and globally.\" title_2=\"Our Vision\" body_2=\"We envision a world where thoughtful design meets everyday life — pieces that age gracefully, partners we trust, and customers we treat as people, not transactions.\" title_3=\"What Sets Us Apart\" body_3=\"Independently audited suppliers, hand-checked products, and a 30-day no-questions return policy backed by a human customer support team.\" title_4=\"Our Commitment\" body_4=\"Quality goods, transparent supply chains, and fair labor — every order, every time.\"][/image-accordion]\n[about-testimonials heading=\"Customer Say!\" subtitle=\"Our customers adore our products, and we constantly aim to delight them.\" quantity=\"2\" image_1=\"testimonials/tes-1.jpg\" name_1=\"Emma Collins\" text_1=\"\\\"Totally obsessed with this outfit! The fit is perfect, the fabric feels premium, and I\'ve been getting compliments non-stop. It instantly lifts my confidence — such a great find!\\\"\" image_2=\"testimonials/tes-2.jpg\" name_2=\"Sophia Ramirez\" text_2=\"\\\"I\'m amazed by how comfortable yet stylish this piece is. It pairs effortlessly with everything, and the quality really stands out. Definitely becoming my go-to for everyday looks!\\\"\"][/about-testimonials]\n[about-team heading=\"Meet Our Teams\" subtitle=\"Experts committed to excellence in every detail.\" quantity=\"4\" image_1=\"member/member-1.jpg\" name_1=\"Annette Black\" role_1=\"Founder/CEO\" social_links_1=\"\" image_2=\"member/member-2.jpg\" name_2=\"Brooklyn Simmons\" role_2=\"Manager\" social_links_2=\"\" image_3=\"member/member-3.jpg\" name_3=\"Jane Cooper\" role_3=\"Sales Director\" social_links_3=\"\" image_4=\"member/member-4.jpg\" name_4=\"Lisa Bonet\" role_4=\"Sales Director\" social_links_4=\"\"][/about-team]'),('vi',2,'Liên hệ','Liên hệ với đội ngũ chăm sóc khách hàng và hợp tác của Amerce.',''),('vi',3,'Câu hỏi thường gặp','Câu hỏi thường gặp về đơn hàng, vận chuyển, đổi trả và quản lý tài khoản.','[page-banner heading=\"FAQs\" subtitle=\"Got questions? We\'ve got answers! Browse our FAQs to find information on orders, shipping,<br class=\\\"d-none d-lg-block\\\">returns, and more. If you need further assistance, feel free to contact our team.\"][/page-banner]\n[faq-page sidebar_image=\"section/banner-12.jpg\" sidebar_title=\"Save 25% <br class=\\\"d-none d-sm-block\\\">Today\" sidebar_subtitle=\"T-Shirts, Hoodies & More\" sidebar_cta=\"View More\" sidebar_url=\"/products\" quantity=\"16\" category_1=\"My Account\" category_id_1=\"myAccount\" question_1=\"1. What can I do if I forgot my password?\" answer_1=\"Use the \\\"Forgot password\\\" link on the sign-in page. We will email you a one-time link to set a new password — it expires in 30 minutes for security.\" category_2=\"My Account\" category_id_2=\"myAccount\" question_2=\"2. How do I update my email address?\" answer_2=\"Sign in, open Account → Settings, and change the email field. We send a confirmation email to the new address; the change takes effect once you click that link.\" category_3=\"My Account\" category_id_3=\"myAccount\" question_3=\"3. Can I delete my account?\" answer_3=\"Yes. From Account → Settings, scroll to Delete account. We retain order history for tax/legal reasons but personal contact details are removed within 30 days.\" category_4=\"Orders & Purchases\" category_id_4=\"ordersPurchases\" question_4=\"1. How do I place an order?\" answer_4=\"Add items to your cart, click checkout, choose a shipping method, then enter your payment details. You will receive an order confirmation email immediately.\" category_5=\"Orders & Purchases\" category_id_5=\"ordersPurchases\" question_5=\"2. Can I edit or cancel an order?\" answer_5=\"Orders can be edited or cancelled from your account dashboard within 1 hour of placement. After that the warehouse has begun picking and we cannot intercept.\" category_6=\"Orders & Purchases\" category_id_6=\"ordersPurchases\" question_6=\"3. What payment methods are accepted?\" answer_6=\"We accept Visa, Mastercard, American Express, Apple Pay, Google Pay, and PayPal. All transactions use TLS 1.3 encryption.\" category_7=\"Returns & Refunds\" category_id_7=\"returnsRefunds\" question_7=\"1. What is the return window?\" answer_7=\"30 days from delivery for any unworn item in original condition. Sale items, intimate apparel, and final-sale flash sale purchases are excluded.\" category_8=\"Returns & Refunds\" category_id_8=\"returnsRefunds\" question_8=\"2. How do I start a return?\" answer_8=\"Open the order in your account dashboard and click \\\"Start return\\\". We email a prepaid label for domestic orders within one business day.\" category_9=\"Returns & Refunds\" category_id_9=\"returnsRefunds\" question_9=\"3. When will I see my refund?\" answer_9=\"Refunds are processed within 3-5 business days of us receiving the return. Bank posting times vary; allow up to 10 business days for the credit to appear.\" category_10=\"Shipping & Tracking\" category_id_10=\"shippingTracking\" question_10=\"1. How long does shipping take?\" answer_10=\"Domestic standard ships in 3-5 business days. Express in 1-2. International standard takes 7-12 business days; express options are available at checkout.\" category_11=\"Shipping & Tracking\" category_id_11=\"shippingTracking\" question_11=\"2. How do I track my order?\" answer_11=\"A tracking link is included in your shipment confirmation email. You can also see status from Account → Orders → Track.\" category_12=\"Shipping & Tracking\" category_id_12=\"shippingTracking\" question_12=\"3. Do you ship internationally?\" answer_12=\"Yes — to most countries. Duties and taxes are pre-paid at checkout for select destinations; otherwise the courier may collect them on delivery.\" category_13=\"Fees & Billing\" category_id_13=\"feesBilling\" question_13=\"1. Are duties and taxes included?\" answer_13=\"Domestic prices include sales tax shown at checkout. International orders to supported destinations include duties and taxes; otherwise the courier collects on delivery.\" category_14=\"Fees & Billing\" category_id_14=\"feesBilling\" question_14=\"2. Why was I charged twice?\" answer_14=\"You likely see a temporary authorization hold plus the actual charge. The authorization drops off in 3-5 business days. Email billing@amerce.test if you still see two charges after that.\" category_15=\"Other Topic\" category_id_15=\"otherTopic\" question_15=\"1. Do you have physical stores?\" answer_15=\"Yes — visit our Stores page for a list of flagship and partner locations.\" category_16=\"Other Topic\" category_id_16=\"otherTopic\" question_16=\"2. How can I contact customer support?\" answer_16=\"Email hello@amerce.test or use the contact form. We reply within one business day.\"][/faq-page]'),('vi',4,'Chính sách bảo mật','Cách Amerce thu thập, sử dụng và bảo vệ thông tin cá nhân của bạn.','[page-banner heading=\"Privacy Policy\"][/page-banner]\n[term-content quantity=\"7\" title_1=\"1. Information We Collect\" body_1=\"<p class=\\\"term-text cl-text-2\\\">When you visit the Site, we automatically collect certain information about your device — web browser, IP address, time zone, and some of the cookies installed on your device. As you browse, we also collect data about the pages or products you view, what referred you to the Site, and how you interact with it. We refer to this as \\\"Device Information\\\".</p><p class=\\\"term-text cl-text-2\\\">When you make a purchase or attempt to purchase through the Site, we collect your name, billing address, shipping address, and payment information (including card number, email address, and phone number). We refer to this as \\\"Order Information\\\".</p>\" title_2=\"2. How We Use Your Information\" body_2=\"<p class=\\\"term-text cl-text-2\\\">We use Order Information to fulfil orders placed through the Site (process payment, arrange shipping, provide invoices and order confirmations). We use it to communicate with you, screen orders for fraud, and — in line with your preferences — share marketing about products you may like.</p><p class=\\\"term-text cl-text-2\\\">We use Device Information to screen for fraud and to improve the Site through analytics about how customers browse and interact with us.</p>\" title_3=\"3. Sharing Your Personal Information\" body_3=\"<p class=\\\"term-text cl-text-2\\\">We share Personal Information with third-party service providers who help us run the Site. We may also share information to comply with applicable laws, respond to a subpoena or lawful request, or otherwise protect our rights.</p>\" title_4=\"4. Data Retention\" body_4=\"<p class=\\\"term-text cl-text-2\\\">When you place an order, we maintain the Order Information for our records unless and until you ask us to delete it.</p>\" title_5=\"5. Your Rights\" body_5=\"<p class=\\\"term-text cl-text-2\\\">You can request access, correction, or deletion of any personal data we hold about you. Email privacy@amerce.test from the address on file and we will respond within 30 days.</p>\" title_6=\"6. Cookies\" body_6=\"<p class=\\\"term-text cl-text-2\\\">Cookies are used to keep your cart between visits, remember your preferences, and measure aggregate traffic. You can disable cookies in your browser, though some Site features may stop working.</p>\" title_7=\"7. Changes\" body_7=\"<p class=\\\"term-text cl-text-2\\\">We may update this policy from time to time to reflect changes to our practices or for operational, legal, or regulatory reasons. The latest version will always be on this page.</p>\"][/term-content]'),('vi',5,'Điều khoản & Điều kiện','Các điều khoản pháp lý áp dụng khi bạn sử dụng cửa hàng Amerce.','[page-banner heading=\"Terms & Conditions\"][/page-banner]\n[term-content quantity=\"7\" title_1=\"1. Acceptance of Terms\" body_1=\"<p class=\\\"term-text cl-text-2\\\">By accessing or using the Amerce store you agree to these terms. We reserve the right to update them with reasonable notice; the latest version is always available on this page.</p>\" title_2=\"2. Orders & Payment\" body_2=\"<p class=\\\"term-text cl-text-2\\\">All prices are in USD unless otherwise stated. We accept the payment methods displayed at checkout. An order becomes binding once you receive an order confirmation email.</p>\" title_3=\"3. Shipping\" body_3=\"<p class=\\\"term-text cl-text-2\\\">Shipping options, lead times, and rates are listed on our Shipping page. Risk passes to you on delivery.</p>\" title_4=\"4. Returns\" body_4=\"<p class=\\\"term-text cl-text-2\\\">You have 30 days from delivery to return any unworn item for a refund. See our Returns &amp; Refunds page for the full process.</p>\" title_5=\"5. Intellectual Property\" body_5=\"<p class=\\\"term-text cl-text-2\\\">All content on the Site — text, photography, logos, code — is owned by Amerce or its licensors and may not be reproduced without written permission.</p>\" title_6=\"6. Limitation of Liability\" body_6=\"<p class=\\\"term-text cl-text-2\\\">To the maximum extent permitted by law, Amerce is not liable for indirect or consequential damages arising from use of the Site or the products purchased through it.</p>\" title_7=\"7. Governing Law\" body_7=\"<p class=\\\"term-text cl-text-2\\\">These terms are governed by the laws of the State of New York. Any dispute will be resolved in the state or federal courts located in New York County.</p>\"][/term-content]'),('vi',6,'Đổi trả & Hoàn tiền','Chính sách đổi trả 30 ngày và quy trình đổi trả từng bước của chúng tôi.','[page-banner heading=\"Returns & Refunds\"][/page-banner]\n[term-content quantity=\"6\" title_1=\"1. Returns\" body_1=\"<p class=\\\"term-text cl-text-2\\\">We want you to be completely satisfied with your purchase. If for any reason you are not, you may return any unworn item within 30 days of receiving your order for a refund or exchange. Items must be in original packaging and the same condition as you received them.</p>\" title_2=\"2. How to Start a Return\" body_2=\"<p class=\\\"term-text cl-text-2\\\">Open the order in your account dashboard and click \\\"Start return\\\", or email returns@amerce.test with your order number. We will send a prepaid return label for domestic orders within one business day.</p>\" title_3=\"3. Refunds\" body_3=\"<p class=\\\"term-text cl-text-2\\\">Refunds are processed within 3-5 business days of us receiving the return and applied to the original payment method. Bank posting times vary; allow up to 10 business days for the credit to appear.</p>\" title_4=\"4. Exclusions\" body_4=\"<p class=\\\"term-text cl-text-2\\\">Sale items, intimate apparel, and final-sale flash sale purchases are excluded from returns. Personalised or made-to-order items are also non-returnable unless faulty.</p>\" title_5=\"5. Damaged or Faulty Items\" body_5=\"<p class=\\\"term-text cl-text-2\\\">If your order arrives damaged or faulty, email us within 7 days with photos. We will replace the item or issue a full refund — including any return shipping cost — at our expense.</p>\" title_6=\"6. International Returns\" body_6=\"<p class=\\\"term-text cl-text-2\\\">International customers are responsible for return shipping unless the item is faulty. We do not refund original shipping or duty charges on international returns.</p>\"][/term-content]'),('vi',7,'Vận chuyển','Các phương thức vận chuyển trong nước và quốc tế, thời gian và cước phí.','[page-banner heading=\"Shipping\"][/page-banner]\n[term-content quantity=\"6\" title_1=\"1. Shipping Methods\" body_1=\"<p class=\\\"term-text cl-text-2\\\">We offer the following shipping methods for domestic and international orders: standard ground, expedited 2-day, and priority overnight (where available).</p>\" title_2=\"2. Domestic Rates\" body_2=\"<p class=\\\"term-text cl-text-2\\\">Standard ground is free on orders over $99. Express 1-2 day shipping is $19.99 flat. Priority overnight is calculated by weight at checkout.</p>\" title_3=\"3. International\" body_3=\"<p class=\\\"term-text cl-text-2\\\">We ship to most countries. International standard shipping is $24.99 with 7-12 business day delivery. Express options appear at checkout. Duties and taxes are pre-paid for select destinations; otherwise the courier collects them on delivery.</p>\" title_4=\"4. Processing Time\" body_4=\"<p class=\\\"term-text cl-text-2\\\">Orders placed before 2pm EST on business days ship the same day. Orders placed after 2pm or on weekends/holidays ship the next business day.</p>\" title_5=\"5. Tracking\" body_5=\"<p class=\\\"term-text cl-text-2\\\">A tracking link is included in your shipment confirmation email. You can also see live status from Account → Orders → Track.</p>\" title_6=\"6. Lost or Stuck Shipments\" body_6=\"<p class=\\\"term-text cl-text-2\\\">If a tracking number has not updated for more than 7 business days, email shipping@amerce.test. We will open an investigation with the carrier and either refund or reship the order at our expense.</p>\"][/term-content]'),('vi',8,'Hệ thống cửa hàng','Ghé thăm Amerce trực tiếp — các cửa hàng chính và đối tác trên toàn thế giới.',''),('vi',9,'Blog','Style guides, product spotlights, and stories from the Amerce team.','<div class=\"container py-5\"><h1>Journal</h1><p>Browse our latest stories — style guides, product spotlights, sustainability deep-dives, and more.</p></div>'),('vi',10,'Careers','Open roles and what it is like to work at Amerce.','<div class=\"container py-5\"><h1>Careers at Amerce</h1><p>We are a small, distributed team building a more thoughtful kind of retail. We hire across product, engineering, supply chain, and customer experience.</p><p>Open roles are posted to our company LinkedIn page. To apply, send a short note and your resume to <a href=\"mailto:careers@amerce.test\">careers@amerce.test</a>.</p></div>'),('vi',11,'Sustainability','How Amerce sources responsibly and reduces its environmental footprint.','<div class=\"container py-5\"><h1>Sustainability at Amerce</h1><p>Every product carries a story. We work directly with mills and ateliers, prioritise recycled and traceable materials, and ship in plastic-free packaging.</p><p>Our 2026 goal: 90% of materials with a verified chain of custody, and a transparent annual impact report.</p></div>'),('vi',12,'Trang chủ','Amerce — trang chủ trải nghiệm thương mại điện tử đa năng.','[simple-slider key=\"home-hero\" style=\"style-1\" is_autoplay=\"yes\" autoplay_speed=\"3000\" show_arrows=\"yes\" show_dots=\"yes\"][/simple-slider]\n[categories-grid style=\"style-grid-5\" title=\"Shop the Season\" subtitle=\"Curated activewear for every routine.\" limit=\"5\"][/categories-grid]\n[ecommerce-products style=\"style-slider\" title=\"Trending Now\" subtitle=\"Featured activewear flying off our shelves.\" source=\"featured\" limit=\"8\" items_per_row=\"4\"][/ecommerce-products]\n[ecommerce-products style=\"style-grid\" title=\"Best Sellers\" subtitle=\"Tried, tested, and loved by our community.\" source=\"best-seller\" limit=\"8\" items_per_row=\"4\"][/ecommerce-products]\n[newsletter-cta style=\"style-default\" heading=\"Subscribe for 10% off\" subheading=\"Plus first dibs on every new drop.\"][/newsletter-cta]');

--
-- Table structure for table `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `password_reset_tokens`
--


--
-- Table structure for table `payment_logs`
--

CREATE TABLE `payment_logs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `payment_method` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `request` longtext COLLATE utf8mb4_unicode_ci,
  `response` longtext COLLATE utf8mb4_unicode_ci,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_logs`
--


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

CREATE TABLE `payments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `currency` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` bigint unsigned NOT NULL DEFAULT '0',
  `charge_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_channel` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount` decimal(15,2) unsigned NOT NULL,
  `payment_fee` decimal(15,2) DEFAULT '0.00',
  `order_id` bigint unsigned DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT 'pending',
  `payment_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'confirm',
  `customer_id` bigint unsigned DEFAULT NULL,
  `refunded_amount` decimal(15,2) unsigned DEFAULT NULL,
  `refund_note` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `customer_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `metadata` mediumtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payments`
--


--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `personal_access_tokens`
--


--
-- Table structure for table `post_categories`
--

CREATE TABLE `post_categories` (
  `category_id` bigint unsigned NOT NULL,
  `post_id` bigint unsigned NOT NULL,
  KEY `post_categories_category_id_index` (`category_id`),
  KEY `post_categories_post_id_index` (`post_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `post_categories`
--

INSERT INTO `post_categories` VALUES (5,1),(3,1),(5,2),(3,2),(5,3),(3,3),(4,4),(2,4),(5,5),(1,5),(5,6),(2,6);

--
-- Table structure for table `post_tags`
--

CREATE TABLE `post_tags` (
  `tag_id` bigint unsigned NOT NULL,
  `post_id` bigint unsigned NOT NULL,
  KEY `post_tags_tag_id_index` (`tag_id`),
  KEY `post_tags_post_id_index` (`post_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `post_tags`
--

INSERT INTO `post_tags` VALUES (10,1),(8,1),(3,1),(7,2),(6,2),(8,2),(8,3),(12,3),(2,3),(6,4),(1,4),(2,4),(3,5),(12,5),(5,5),(9,6),(6,6),(10,6);

--
-- Table structure for table `posts`
--

CREATE TABLE `posts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `author_id` bigint unsigned DEFAULT NULL,
  `author_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_featured` tinyint unsigned NOT NULL DEFAULT '0',
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `views` int unsigned NOT NULL DEFAULT '0',
  `format_type` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `posts_status_index` (`status`),
  KEY `posts_author_id_index` (`author_id`),
  KEY `posts_author_type_index` (`author_type`),
  KEY `posts_created_at_index` (`created_at`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `posts`
--

INSERT INTO `posts` VALUES (1,'The Activewear Edit: Studio Staples for Every Practice','Six pieces that move with you through vinyasa, recovery, and the walk to the studio.','<p>The right activewear should disappear during practice. We curated a six-piece capsule that moves through hot yoga, cool mornings, and the walk between. Look for four-way stretch, gusseted seams, and fabric that recovers after every wash.</p><p>Black is the foundation, soft neutrals expand the rotation, and a single bright color keeps the edit from feeling clinical.</p>','published',1,'Botble\\ACL\\Models\\User',1,'blog/recent-1.jpg',693,NULL,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(2,'Yoga Routine Basics: A 20-Minute Daily Flow','A short sequence that builds mobility, strength, and breath capacity without overwhelming the schedule.','<p>Twenty minutes is enough. Cat-cow into low lunge, sun salutations B for warmth, and a five-minute hold-and-breathe finish. Repeat five days a week before judging the effect.</p><p>The goal is not to optimize the flow — it is to make showing up feel automatic.</p>','published',1,'Botble\\ACL\\Models\\User',1,'blog/recent-2.jpg',1923,NULL,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(3,'How to Choose the Right Leggings for Your Practice','High-rise, mid-rise, compressive or buttery — a practical guide to picking your default pair.','<p>Compressive leggings hold shape under heavier movement and feel structured during runs. Buttery fabrics breathe better in heat and pair well with restorative yoga. High-rise stays put through inversions; mid-rise feels easier for daily wear.</p><p>Own one of each before you commit to a brand.</p>','published',1,'Botble\\ACL\\Models\\User',1,'blog/recent-1.jpg',2028,NULL,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(4,'Sweat-Wicking Fabrics: What Actually Works','Polyester blends, recycled nylons, and merino — what to wear in heat, cold, and everything between.','<p>Polyester wicks fastest but holds odor. Merino regulates temperature and resists smell but pills with abrasion. Recycled nylons split the difference and are now standard in mid-tier activewear.</p><p>Match the fabric to the workout, not the brand.</p>','published',1,'Botble\\ACL\\Models\\User',1,'blog/recent-2.jpg',2259,NULL,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(5,'Studio to Street: Activewear That Works All Day','Pieces that look intentional outside the gym — without the obvious workout-codes.','<p>Look for muted palettes, clean seams, and fabrics that pass the close-up test. A structured zip jacket, a longline tee, and matte black leggings will carry you from morning vinyasa to a coffee meeting without a wardrobe change.</p><p>The trick is fit. Anything baggy reads \"rest day.\"</p>','published',1,'Botble\\ACL\\Models\\User',1,'blog/recent-1.jpg',1706,NULL,'2026-05-07 01:57:53','2026-05-07 01:57:53'),(6,'Recovery Tips for the Day After a Hard Workout','Hydration, gentle movement, and the underrated effect of sleep on training adaptation.','<p>Recovery is where adaptation happens. Hydrate with electrolytes, walk twenty minutes, foam roll the antagonist muscle groups, and sleep eight hours. Skip the long stretch sessions if soreness is severe — gentle movement beats static holds for blood flow.</p><p>The fastest recoveries are the most boring.</p>','published',1,'Botble\\ACL\\Models\\User',0,'blog/recent-2.jpg',2374,NULL,'2026-05-07 01:57:53','2026-05-07 01:57:53');

--
-- Table structure for table `posts_translations`
--

CREATE TABLE `posts_translations` (
  `lang_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `posts_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`lang_code`,`posts_id`),
  KEY `idx_posts_trans_posts_id` (`posts_id`),
  KEY `idx_posts_trans_post_lang` (`posts_id`,`lang_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `posts_translations`
--

INSERT INTO `posts_translations` VALUES ('ar',1,'The Activewear Edit: Studio Staples for Every Practice','Six pieces that move with you through vinyasa, recovery, and the walk to the studio.','<p>The right activewear should disappear during practice. We curated a six-piece capsule that moves through hot yoga, cool mornings, and the walk between. Look for four-way stretch, gusseted seams, and fabric that recovers after every wash.</p><p>Black is the foundation, soft neutrals expand the rotation, and a single bright color keeps the edit from feeling clinical.</p>'),('ar',2,'Yoga Routine Basics: A 20-Minute Daily Flow','A short sequence that builds mobility, strength, and breath capacity without overwhelming the schedule.','<p>Twenty minutes is enough. Cat-cow into low lunge, sun salutations B for warmth, and a five-minute hold-and-breathe finish. Repeat five days a week before judging the effect.</p><p>The goal is not to optimize the flow — it is to make showing up feel automatic.</p>'),('ar',3,'How to Choose the Right Leggings for Your Practice','High-rise, mid-rise, compressive or buttery — a practical guide to picking your default pair.','<p>Compressive leggings hold shape under heavier movement and feel structured during runs. Buttery fabrics breathe better in heat and pair well with restorative yoga. High-rise stays put through inversions; mid-rise feels easier for daily wear.</p><p>Own one of each before you commit to a brand.</p>'),('ar',4,'Sweat-Wicking Fabrics: What Actually Works','Polyester blends, recycled nylons, and merino — what to wear in heat, cold, and everything between.','<p>Polyester wicks fastest but holds odor. Merino regulates temperature and resists smell but pills with abrasion. Recycled nylons split the difference and are now standard in mid-tier activewear.</p><p>Match the fabric to the workout, not the brand.</p>'),('ar',5,'Studio to Street: Activewear That Works All Day','Pieces that look intentional outside the gym — without the obvious workout-codes.','<p>Look for muted palettes, clean seams, and fabrics that pass the close-up test. A structured zip jacket, a longline tee, and matte black leggings will carry you from morning vinyasa to a coffee meeting without a wardrobe change.</p><p>The trick is fit. Anything baggy reads \"rest day.\"</p>'),('ar',6,'Recovery Tips for the Day After a Hard Workout','Hydration, gentle movement, and the underrated effect of sleep on training adaptation.','<p>Recovery is where adaptation happens. Hydrate with electrolytes, walk twenty minutes, foam roll the antagonist muscle groups, and sleep eight hours. Skip the long stretch sessions if soreness is severe — gentle movement beats static holds for blood flow.</p><p>The fastest recoveries are the most boring.</p>'),('fr',1,'The Activewear Edit: Studio Staples for Every Practice','Six pieces that move with you through vinyasa, recovery, and the walk to the studio.','<p>The right activewear should disappear during practice. We curated a six-piece capsule that moves through hot yoga, cool mornings, and the walk between. Look for four-way stretch, gusseted seams, and fabric that recovers after every wash.</p><p>Black is the foundation, soft neutrals expand the rotation, and a single bright color keeps the edit from feeling clinical.</p>'),('fr',2,'Yoga Routine Basics: A 20-Minute Daily Flow','A short sequence that builds mobility, strength, and breath capacity without overwhelming the schedule.','<p>Twenty minutes is enough. Cat-cow into low lunge, sun salutations B for warmth, and a five-minute hold-and-breathe finish. Repeat five days a week before judging the effect.</p><p>The goal is not to optimize the flow — it is to make showing up feel automatic.</p>'),('fr',3,'How to Choose the Right Leggings for Your Practice','High-rise, mid-rise, compressive or buttery — a practical guide to picking your default pair.','<p>Compressive leggings hold shape under heavier movement and feel structured during runs. Buttery fabrics breathe better in heat and pair well with restorative yoga. High-rise stays put through inversions; mid-rise feels easier for daily wear.</p><p>Own one of each before you commit to a brand.</p>'),('fr',4,'Sweat-Wicking Fabrics: What Actually Works','Polyester blends, recycled nylons, and merino — what to wear in heat, cold, and everything between.','<p>Polyester wicks fastest but holds odor. Merino regulates temperature and resists smell but pills with abrasion. Recycled nylons split the difference and are now standard in mid-tier activewear.</p><p>Match the fabric to the workout, not the brand.</p>'),('fr',5,'Studio to Street: Activewear That Works All Day','Pieces that look intentional outside the gym — without the obvious workout-codes.','<p>Look for muted palettes, clean seams, and fabrics that pass the close-up test. A structured zip jacket, a longline tee, and matte black leggings will carry you from morning vinyasa to a coffee meeting without a wardrobe change.</p><p>The trick is fit. Anything baggy reads \"rest day.\"</p>'),('fr',6,'Recovery Tips for the Day After a Hard Workout','Hydration, gentle movement, and the underrated effect of sleep on training adaptation.','<p>Recovery is where adaptation happens. Hydrate with electrolytes, walk twenty minutes, foam roll the antagonist muscle groups, and sleep eight hours. Skip the long stretch sessions if soreness is severe — gentle movement beats static holds for blood flow.</p><p>The fastest recoveries are the most boring.</p>'),('id',1,'The Activewear Edit: Studio Staples for Every Practice','Six pieces that move with you through vinyasa, recovery, and the walk to the studio.','<p>The right activewear should disappear during practice. We curated a six-piece capsule that moves through hot yoga, cool mornings, and the walk between. Look for four-way stretch, gusseted seams, and fabric that recovers after every wash.</p><p>Black is the foundation, soft neutrals expand the rotation, and a single bright color keeps the edit from feeling clinical.</p>'),('id',2,'Yoga Routine Basics: A 20-Minute Daily Flow','A short sequence that builds mobility, strength, and breath capacity without overwhelming the schedule.','<p>Twenty minutes is enough. Cat-cow into low lunge, sun salutations B for warmth, and a five-minute hold-and-breathe finish. Repeat five days a week before judging the effect.</p><p>The goal is not to optimize the flow — it is to make showing up feel automatic.</p>'),('id',3,'How to Choose the Right Leggings for Your Practice','High-rise, mid-rise, compressive or buttery — a practical guide to picking your default pair.','<p>Compressive leggings hold shape under heavier movement and feel structured during runs. Buttery fabrics breathe better in heat and pair well with restorative yoga. High-rise stays put through inversions; mid-rise feels easier for daily wear.</p><p>Own one of each before you commit to a brand.</p>'),('id',4,'Sweat-Wicking Fabrics: What Actually Works','Polyester blends, recycled nylons, and merino — what to wear in heat, cold, and everything between.','<p>Polyester wicks fastest but holds odor. Merino regulates temperature and resists smell but pills with abrasion. Recycled nylons split the difference and are now standard in mid-tier activewear.</p><p>Match the fabric to the workout, not the brand.</p>'),('id',5,'Studio to Street: Activewear That Works All Day','Pieces that look intentional outside the gym — without the obvious workout-codes.','<p>Look for muted palettes, clean seams, and fabrics that pass the close-up test. A structured zip jacket, a longline tee, and matte black leggings will carry you from morning vinyasa to a coffee meeting without a wardrobe change.</p><p>The trick is fit. Anything baggy reads \"rest day.\"</p>'),('id',6,'Recovery Tips for the Day After a Hard Workout','Hydration, gentle movement, and the underrated effect of sleep on training adaptation.','<p>Recovery is where adaptation happens. Hydrate with electrolytes, walk twenty minutes, foam roll the antagonist muscle groups, and sleep eight hours. Skip the long stretch sessions if soreness is severe — gentle movement beats static holds for blood flow.</p><p>The fastest recoveries are the most boring.</p>'),('vi',1,'The Activewear Edit: Studio Staples for Every Practice','Six pieces that move with you through vinyasa, recovery, and the walk to the studio.','<p>The right activewear should disappear during practice. We curated a six-piece capsule that moves through hot yoga, cool mornings, and the walk between. Look for four-way stretch, gusseted seams, and fabric that recovers after every wash.</p><p>Black is the foundation, soft neutrals expand the rotation, and a single bright color keeps the edit from feeling clinical.</p>'),('vi',2,'Yoga Routine Basics: A 20-Minute Daily Flow','A short sequence that builds mobility, strength, and breath capacity without overwhelming the schedule.','<p>Twenty minutes is enough. Cat-cow into low lunge, sun salutations B for warmth, and a five-minute hold-and-breathe finish. Repeat five days a week before judging the effect.</p><p>The goal is not to optimize the flow — it is to make showing up feel automatic.</p>'),('vi',3,'How to Choose the Right Leggings for Your Practice','High-rise, mid-rise, compressive or buttery — a practical guide to picking your default pair.','<p>Compressive leggings hold shape under heavier movement and feel structured during runs. Buttery fabrics breathe better in heat and pair well with restorative yoga. High-rise stays put through inversions; mid-rise feels easier for daily wear.</p><p>Own one of each before you commit to a brand.</p>'),('vi',4,'Sweat-Wicking Fabrics: What Actually Works','Polyester blends, recycled nylons, and merino — what to wear in heat, cold, and everything between.','<p>Polyester wicks fastest but holds odor. Merino regulates temperature and resists smell but pills with abrasion. Recycled nylons split the difference and are now standard in mid-tier activewear.</p><p>Match the fabric to the workout, not the brand.</p>'),('vi',5,'Studio to Street: Activewear That Works All Day','Pieces that look intentional outside the gym — without the obvious workout-codes.','<p>Look for muted palettes, clean seams, and fabrics that pass the close-up test. A structured zip jacket, a longline tee, and matte black leggings will carry you from morning vinyasa to a coffee meeting without a wardrobe change.</p><p>The trick is fit. Anything baggy reads \"rest day.\"</p>'),('vi',6,'Recovery Tips for the Day After a Hard Workout','Hydration, gentle movement, and the underrated effect of sleep on training adaptation.','<p>Recovery is where adaptation happens. Hydrate with electrolytes, walk twenty minutes, foam roll the antagonist muscle groups, and sleep eight hours. Skip the long stretch sessions if soreness is severe — gentle movement beats static holds for blood flow.</p><p>The fastest recoveries are the most boring.</p>');

--
-- Table structure for table `push_notification_recipients`
--

CREATE TABLE `push_notification_recipients` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `push_notification_id` bigint unsigned NOT NULL,
  `user_type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `device_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `platform` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'sent',
  `sent_at` timestamp NULL DEFAULT NULL,
  `delivered_at` timestamp NULL DEFAULT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `clicked_at` timestamp NULL DEFAULT NULL,
  `fcm_response` json DEFAULT NULL,
  `error_message` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `pnr_notification_user_index` (`push_notification_id`,`user_type`,`user_id`),
  KEY `pnr_user_status_index` (`user_type`,`user_id`,`status`),
  KEY `pnr_user_read_index` (`user_type`,`user_id`,`read_at`),
  KEY `pnr_status_index` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `push_notification_recipients`
--


--
-- Table structure for table `push_notifications`
--

CREATE TABLE `push_notifications` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'general',
  `target_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `target_value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `action_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `data` json DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'sent',
  `sent_count` int NOT NULL DEFAULT '0',
  `failed_count` int NOT NULL DEFAULT '0',
  `delivered_count` int NOT NULL DEFAULT '0',
  `read_count` int NOT NULL DEFAULT '0',
  `scheduled_at` timestamp NULL DEFAULT NULL,
  `sent_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `push_notifications_type_created_at_index` (`type`,`created_at`),
  KEY `push_notifications_status_scheduled_at_index` (`status`,`scheduled_at`),
  KEY `push_notifications_created_by_index` (`created_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `push_notifications`
--


--
-- Table structure for table `request_logs`
--

CREATE TABLE `request_logs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `status_code` int DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `count` int unsigned NOT NULL DEFAULT '0',
  `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `referrer` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `request_logs`
--


--
-- Table structure for table `revisions`
--

CREATE TABLE `revisions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `revisionable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `revisionable_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `key` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `old_value` text COLLATE utf8mb4_unicode_ci,
  `new_value` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `revisions_revisionable_id_revisionable_type_index` (`revisionable_id`,`revisionable_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `revisions`
--


--
-- Table structure for table `role_users`
--

CREATE TABLE `role_users` (
  `user_id` bigint unsigned NOT NULL,
  `role_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`user_id`,`role_id`),
  KEY `role_users_user_id_index` (`user_id`),
  KEY `role_users_role_id_index` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_users`
--


--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `permissions` text COLLATE utf8mb4_unicode_ci,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_default` tinyint unsigned NOT NULL DEFAULT '0',
  `created_by` bigint unsigned NOT NULL,
  `updated_by` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_slug_unique` (`slug`),
  KEY `roles_created_by_index` (`created_by`),
  KEY `roles_updated_by_index` (`updated_by`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (1,'admin','Admin','{\"users.index\":true,\"users.create\":true,\"users.edit\":true,\"users.destroy\":true,\"roles.index\":true,\"roles.create\":true,\"roles.edit\":true,\"roles.destroy\":true,\"core.system\":true,\"core.cms\":true,\"core.manage.license\":true,\"systems.cronjob\":true,\"core.tools\":true,\"tools.data-synchronize\":true,\"media.index\":true,\"files.index\":true,\"files.create\":true,\"files.edit\":true,\"files.trash\":true,\"files.destroy\":true,\"folders.index\":true,\"folders.create\":true,\"folders.edit\":true,\"folders.trash\":true,\"folders.destroy\":true,\"settings.index\":true,\"settings.common\":true,\"settings.options\":true,\"settings.email\":true,\"settings.media\":true,\"settings.admin-appearance\":true,\"settings.cache\":true,\"settings.datatables\":true,\"settings.email.rules\":true,\"settings.phone-number\":true,\"settings.others\":true,\"menus.index\":true,\"menus.create\":true,\"menus.edit\":true,\"menus.destroy\":true,\"optimize.settings\":true,\"pages.index\":true,\"pages.create\":true,\"pages.edit\":true,\"pages.destroy\":true,\"pages.export\":true,\"pages.import\":true,\"plugins.index\":true,\"plugins.edit\":true,\"plugins.remove\":true,\"plugins.marketplace\":true,\"sitemap.settings\":true,\"core.appearance\":true,\"theme.index\":true,\"theme.activate\":true,\"theme.remove\":true,\"theme.options\":true,\"theme.custom-css\":true,\"theme.custom-js\":true,\"theme.custom-html\":true,\"theme.robots-txt\":true,\"settings.website-tracking\":true,\"widgets.index\":true,\"ads.index\":true,\"ads.create\":true,\"ads.edit\":true,\"ads.destroy\":true,\"ads.settings\":true,\"analytics.general\":true,\"analytics.page\":true,\"analytics.browser\":true,\"analytics.referrer\":true,\"analytics.settings\":true,\"announcements.index\":true,\"announcements.create\":true,\"announcements.edit\":true,\"announcements.destroy\":true,\"announcements.settings\":true,\"audit-log.index\":true,\"audit-log.destroy\":true,\"backups.index\":true,\"backups.create\":true,\"backups.restore\":true,\"backups.destroy\":true,\"plugins.blog\":true,\"posts.index\":true,\"posts.create\":true,\"posts.edit\":true,\"posts.destroy\":true,\"categories.index\":true,\"categories.create\":true,\"categories.edit\":true,\"categories.destroy\":true,\"tags.index\":true,\"blog.reports\":true,\"tags.create\":true,\"tags.edit\":true,\"tags.destroy\":true,\"blog.settings\":true,\"posts.export\":true,\"posts.import\":true,\"captcha.settings\":true,\"contacts.index\":true,\"contacts.edit\":true,\"contacts.destroy\":true,\"contact.custom-fields\":true,\"contact.settings\":true,\"plugins.ecommerce\":true,\"ecommerce.report.index\":true,\"products.index\":true,\"products.create\":true,\"products.edit\":true,\"products.destroy\":true,\"products.duplicate\":true,\"ecommerce.product-prices.index\":true,\"ecommerce.product-prices.edit\":true,\"ecommerce.product-inventory.index\":true,\"ecommerce.product-inventory.edit\":true,\"product-categories.index\":true,\"product-categories.create\":true,\"product-categories.edit\":true,\"product-categories.destroy\":true,\"product-tag.index\":true,\"product-tag.create\":true,\"product-tag.edit\":true,\"product-tag.destroy\":true,\"brands.index\":true,\"brands.create\":true,\"brands.edit\":true,\"brands.destroy\":true,\"product-collections.index\":true,\"product-collections.create\":true,\"product-collections.edit\":true,\"product-collections.destroy\":true,\"product-attribute-sets.index\":true,\"product-attribute-sets.create\":true,\"product-attribute-sets.edit\":true,\"product-attribute-sets.destroy\":true,\"product-attributes.index\":true,\"product-attributes.create\":true,\"product-attributes.edit\":true,\"product-attributes.destroy\":true,\"tax.index\":true,\"tax.create\":true,\"tax.edit\":true,\"tax.destroy\":true,\"reviews.index\":true,\"reviews.create\":true,\"reviews.destroy\":true,\"reviews.publish\":true,\"reviews.reply\":true,\"ecommerce.shipments.index\":true,\"ecommerce.shipments.create\":true,\"ecommerce.shipments.edit\":true,\"ecommerce.shipments.destroy\":true,\"orders.index\":true,\"orders.create\":true,\"orders.edit\":true,\"orders.destroy\":true,\"discounts.index\":true,\"discounts.create\":true,\"discounts.edit\":true,\"discounts.destroy\":true,\"customers.index\":true,\"customers.create\":true,\"customers.edit\":true,\"customers.destroy\":true,\"ecommerce.customers.import\":true,\"ecommerce.customers.export\":true,\"ecommerce.customer-carts.index\":true,\"ecommerce.customer-carts.destroy\":true,\"flash-sale.index\":true,\"flash-sale.create\":true,\"flash-sale.edit\":true,\"flash-sale.destroy\":true,\"product-label.index\":true,\"product-label.create\":true,\"product-label.edit\":true,\"product-label.destroy\":true,\"ecommerce.import.products.index\":true,\"ecommerce.export.products.index\":true,\"order_returns.index\":true,\"order_returns.edit\":true,\"order_returns.destroy\":true,\"global-option.index\":true,\"global-option.create\":true,\"global-option.edit\":true,\"global-option.destroy\":true,\"ecommerce.invoice.index\":true,\"ecommerce.invoice.edit\":true,\"ecommerce.invoice.destroy\":true,\"ecommerce.settings\":true,\"ecommerce.settings.general\":true,\"ecommerce.invoice-template.index\":true,\"ecommerce.settings.currencies\":true,\"ecommerce.settings.products\":true,\"ecommerce.settings.product-search\":true,\"ecommerce.settings.digital-products\":true,\"ecommerce.settings.store-locators\":true,\"ecommerce.settings.invoices\":true,\"ecommerce.settings.product-reviews\":true,\"ecommerce.settings.customers\":true,\"ecommerce.settings.shopping\":true,\"ecommerce.settings.taxes\":true,\"ecommerce.settings.shipping\":true,\"ecommerce.shipping-rule-items.index\":true,\"ecommerce.shipping-rule-items.create\":true,\"ecommerce.shipping-rule-items.edit\":true,\"ecommerce.shipping-rule-items.destroy\":true,\"ecommerce.shipping-rule-items.bulk-import\":true,\"ecommerce.settings.tracking\":true,\"ecommerce.settings.standard-and-format\":true,\"ecommerce.settings.checkout\":true,\"ecommerce.settings.return\":true,\"ecommerce.settings.flash-sale\":true,\"ecommerce.settings.product-specification\":true,\"product-categories.export\":true,\"product-categories.import\":true,\"product-license-codes.import\":true,\"orders.export\":true,\"ecommerce.product-specification.index\":true,\"ecommerce.specification-groups.index\":true,\"ecommerce.specification-groups.create\":true,\"ecommerce.specification-groups.edit\":true,\"ecommerce.specification-groups.destroy\":true,\"ecommerce.specification-attributes.index\":true,\"ecommerce.specification-attributes.create\":true,\"ecommerce.specification-attributes.edit\":true,\"ecommerce.specification-attributes.destroy\":true,\"ecommerce.specification-tables.index\":true,\"ecommerce.specification-tables.create\":true,\"ecommerce.specification-tables.edit\":true,\"ecommerce.specification-tables.destroy\":true,\"ecommerce.product-specifications.import\":true,\"ecommerce.product-specifications.export\":true,\"plugin.faq\":true,\"faq.index\":true,\"faq.create\":true,\"faq.edit\":true,\"faq.destroy\":true,\"faq_category.index\":true,\"faq_category.create\":true,\"faq_category.edit\":true,\"faq_category.destroy\":true,\"faqs.settings\":true,\"product-size-guide.index\":true,\"product-size-guide.create\":true,\"product-size-guide.edit\":true,\"product-size-guide.destroy\":true,\"size-guide-headers.index\":true,\"size-guide-headers.create\":true,\"size-guide-headers.edit\":true,\"size-guide-headers.destroy\":true,\"product-size-guide.settings\":true,\"galleries.index\":true,\"galleries.create\":true,\"galleries.edit\":true,\"galleries.destroy\":true,\"languages.index\":true,\"languages.create\":true,\"languages.edit\":true,\"languages.destroy\":true,\"translations.import\":true,\"translations.export\":true,\"property-translations.import\":true,\"property-translations.export\":true,\"page-translations.export\":true,\"page-translations.import\":true,\"plugin.location\":true,\"country.index\":true,\"country.create\":true,\"country.edit\":true,\"country.destroy\":true,\"state.index\":true,\"state.create\":true,\"state.edit\":true,\"state.destroy\":true,\"city.index\":true,\"city.create\":true,\"city.edit\":true,\"city.destroy\":true,\"marketplace.index\":true,\"marketplace.store.index\":true,\"marketplace.store.create\":true,\"marketplace.store.edit\":true,\"marketplace.store.destroy\":true,\"marketplace.store.view\":true,\"marketplace.store.revenue.create\":true,\"marketplace.withdrawal.index\":true,\"marketplace.withdrawal.edit\":true,\"marketplace.withdrawal.destroy\":true,\"marketplace.withdrawal.invoice\":true,\"marketplace.vendors.index\":true,\"marketplace.unverified-vendors.index\":true,\"marketplace.vendors.control\":true,\"marketplace.unverified-vendors.edit\":true,\"marketplace.reports\":true,\"marketplace.settings\":true,\"marketplace.messages.index\":true,\"marketplace.messages.edit\":true,\"marketplace.messages.destroy\":true,\"newsletter.index\":true,\"newsletter.destroy\":true,\"newsletter.settings\":true,\"payment.index\":true,\"payments.settings\":true,\"payment.destroy\":true,\"payments.logs\":true,\"payments.logs.show\":true,\"payments.logs.destroy\":true,\"request-log.index\":true,\"request-log.destroy\":true,\"sale-popup.settings\":true,\"simple-slider.index\":true,\"simple-slider.create\":true,\"simple-slider.edit\":true,\"simple-slider.destroy\":true,\"simple-slider-item.index\":true,\"simple-slider-item.create\":true,\"simple-slider-item.edit\":true,\"simple-slider-item.destroy\":true,\"social-login.settings\":true,\"testimonial.index\":true,\"testimonial.create\":true,\"testimonial.edit\":true,\"testimonial.destroy\":true,\"plugins.translation\":true,\"translations.locales\":true,\"translations.theme-translations\":true,\"translations.index\":true,\"theme-translations.export\":true,\"other-translations.export\":true,\"theme-translations.import\":true,\"other-translations.import\":true,\"api.settings\":true,\"api.sanctum-token.index\":true,\"api.sanctum-token.create\":true,\"api.sanctum-token.destroy\":true}','Admin users role',1,1,1,'2026-05-07 01:57:52','2026-05-07 01:57:52');

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--


--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `settings_key_unique` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=156 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` VALUES (2,'api_enabled','0',NULL,'2026-05-07 01:57:58'),(3,'activated_plugins','[\"language\",\"language-advanced\",\"ads\",\"analytics\",\"announcement\",\"audit-log\",\"backup\",\"blog\",\"captcha\",\"contact\",\"cookie-consent\",\"ecommerce\",\"faq\",\"fob-product-size-guide\",\"gallery\",\"location\",\"marketplace\",\"mollie\",\"newsletter\",\"payment\",\"paypal\",\"paypal-payout\",\"paystack\",\"razorpay\",\"request-log\",\"sale-popup\",\"shippo\",\"simple-slider\",\"social-login\",\"sslcommerz\",\"stripe\",\"stripe-connect\",\"testimonial\",\"translation\"]',NULL,'2026-05-07 01:57:58'),(8,'media_random_hash','c38dfe150fec217a5c7a547606698556',NULL,'2026-05-07 01:57:58'),(9,'theme','amerce',NULL,'2026-05-07 01:57:58'),(10,'show_admin_bar','1',NULL,'2026-05-07 01:57:58'),(11,'admin_email.0','support@amerce.test',NULL,'2026-05-07 01:57:58'),(12,'admin_logo',NULL,NULL,'2026-05-07 01:57:58'),(13,'admin_favicon',NULL,NULL,'2026-05-07 01:57:58'),(14,'admin_title','Amerce',NULL,'2026-05-07 01:57:58'),(15,'enable_change_admin_theme','1',NULL,'2026-05-07 01:57:58'),(16,'language_hide_default','1',NULL,'2026-05-07 01:57:58'),(17,'language_switcher_display','dropdown',NULL,'2026-05-07 01:57:58'),(18,'language_display','all',NULL,'2026-05-07 01:57:58'),(19,'language_hide_languages','[]',NULL,'2026-05-07 01:57:58'),(20,'locale','en',NULL,'2026-05-07 01:57:58'),(21,'locale_direction','ltr',NULL,'2026-05-07 01:57:58'),(22,'enable_send_error_reporting_via_email','0',NULL,'2026-05-07 01:57:58'),(23,'enable_https','0',NULL,'2026-05-07 01:57:58'),(24,'enable_cache','0',NULL,'2026-05-07 01:57:58'),(25,'cache_admin_menu_enable','1',NULL,'2026-05-07 01:57:58'),(26,'cache_time_site_map','3600',NULL,'2026-05-07 01:57:58'),(27,'enable_send_mail_when_new_user_registered','0',NULL,'2026-05-07 01:57:58'),(28,'enable_send_mail_user_registered_to_admin','0',NULL,'2026-05-07 01:57:58'),(29,'enable_change_password','1',NULL,'2026-05-07 01:57:58'),(30,'enable_register','1',NULL,'2026-05-07 01:57:58'),(31,'enable_recaptcha','0',NULL,'2026-05-07 01:57:58'),(32,'enable_captcha','0',NULL,'2026-05-07 01:57:58'),(33,'show_site_name_when_logged_in','1',NULL,'2026-05-07 01:57:58'),(34,'time_zone','UTC',NULL,'2026-05-07 01:57:58'),(35,'enable_multi_language_in_admin','0',NULL,'2026-05-07 01:57:58'),(36,'media_chunk_enabled','0',NULL,'2026-05-07 01:57:58'),(37,'media_chunk_size','1048576',NULL,'2026-05-07 01:57:58'),(38,'media_max_upload_filesize',NULL,NULL,'2026-05-07 01:57:58'),(39,'media_aws_use_signed_urls','0',NULL,'2026-05-07 01:57:58'),(40,'media_aws_signed_url_expiry','60',NULL,'2026-05-07 01:57:58'),(41,'enable_geo_ip','0',NULL,'2026-05-07 01:57:58'),(42,'enable_audit_log','1',NULL,'2026-05-07 01:57:58'),(43,'payment_cod_status','1',NULL,'2026-05-07 01:57:58'),(44,'payment_bank_transfer_status','1',NULL,'2026-05-07 01:57:58'),(45,'payment_cod_description','Please pay money directly to the postman, if you choose cash on delivery method (COD).',NULL,'2026-05-07 01:57:58'),(46,'payment_bank_transfer_description','Please send money to our bank account: AMERCE - 0123 4567 8901.',NULL,'2026-05-07 01:57:58'),(47,'payment_stripe_payment_type','stripe_checkout',NULL,'2026-05-07 01:57:58'),(48,'plugins_ecommerce_customer_new_order_status','0',NULL,'2026-05-07 01:57:58'),(49,'plugins_ecommerce_admin_new_order_status','0',NULL,'2026-05-07 01:57:58'),(50,'ecommerce_is_enabled_support_digital_products','1',NULL,'2026-05-07 01:57:58'),(51,'ecommerce_enable_license_codes_for_digital_products','1',NULL,'2026-05-07 01:57:58'),(52,'ecommerce_auto_complete_digital_orders_after_payment','1',NULL,'2026-05-07 01:57:58'),(53,'ecommerce_load_countries_states_cities_from_location_plugin','0',NULL,'2026-05-07 01:57:58'),(54,'ecommerce_product_sku_format','AM-%s%s%s%s',NULL,'2026-05-07 01:57:58'),(55,'ecommerce_store_order_prefix','AM',NULL,'2026-05-07 01:57:58'),(56,'ecommerce_enable_product_specification','1',NULL,'2026-05-07 01:57:58'),(57,'payment_bank_transfer_display_bank_info_at_the_checkout_success_page','1',NULL,'2026-05-07 01:57:58'),(58,'payment_cod_logo','payments/cod.png',NULL,'2026-05-07 01:57:58'),(59,'payment_bank_transfer_logo','payments/bank-transfer.png',NULL,'2026-05-07 01:57:58'),(60,'payment_stripe_logo','payments/stripe.webp',NULL,'2026-05-07 01:57:58'),(61,'payment_paypal_logo','payments/paypal.png',NULL,'2026-05-07 01:57:58'),(62,'payment_mollie_logo','payments/mollie.png',NULL,'2026-05-07 01:57:58'),(63,'payment_paystack_logo','payments/paystack.png',NULL,'2026-05-07 01:57:58'),(64,'payment_razorpay_logo','payments/razorpay.png',NULL,'2026-05-07 01:57:58'),(65,'payment_sslcommerz_logo','payments/sslcommerz.png',NULL,'2026-05-07 01:57:58'),(66,'show_on_front','12',NULL,'2026-05-07 01:57:58'),(67,'blog_page_id','9',NULL,'2026-05-07 01:57:58'),(68,'theme-amerce-homepage_id','12',NULL,'2026-05-07 01:57:58'),(69,'theme-amerce-blog_page_id','9',NULL,'2026-05-07 01:57:58'),(70,'theme-amerce-logo','general/logo.png',NULL,'2026-05-07 01:57:58'),(71,'theme-amerce-logo_dark','general/logo-white.png',NULL,'2026-05-07 01:57:58'),(72,'theme-amerce-logo_text','Amerce',NULL,'2026-05-07 01:57:58'),(73,'theme-amerce-favicon','general/favicon.png',NULL,'2026-05-07 01:57:58'),(74,'theme-amerce-default_theme_mode','light',NULL,'2026-05-07 01:57:58'),(75,'theme-amerce-header_style','style-11',NULL,'2026-05-07 01:57:58'),(76,'theme-amerce-show_topbar','1',NULL,'2026-05-07 01:57:58'),(77,'theme-amerce-contact_phone','(+01) 1234 8888',NULL,'2026-05-07 01:57:58'),(78,'theme-amerce-topbar_slides','Midseason Sale: 20% Off - Auto Applied at Checkout - Limited Time Only\n20% Off - Auto Applied at Checkout - Limited Time Only',NULL,'2026-05-07 01:57:58'),(79,'theme-amerce-sticky_header','1',NULL,'2026-05-07 01:57:58'),(80,'theme-amerce-header_transparent_on_homepage','0',NULL,'2026-05-07 01:57:58'),(81,'theme-amerce-header_top_background_color','#010F1C',NULL,'2026-05-07 01:57:58'),(82,'theme-amerce-header_top_text_color','#FFFFFF',NULL,'2026-05-07 01:57:58'),(83,'theme-amerce-header_main_background_color','#FFFFFF',NULL,'2026-05-07 01:57:58'),(84,'theme-amerce-header_main_text_color','#1E1E1E',NULL,'2026-05-07 01:57:58'),(85,'theme-amerce-primary_color','#F0460E',NULL,'2026-05-07 01:57:58'),(86,'theme-amerce-secondary_color','#1E1E1E',NULL,'2026-05-07 01:57:58'),(87,'theme-amerce-heading_color','#101010',NULL,'2026-05-07 01:57:58'),(88,'theme-amerce-body_text_color','#696E73',NULL,'2026-05-07 01:57:58'),(89,'theme-amerce-link_color','#DC4646',NULL,'2026-05-07 01:57:58'),(90,'theme-amerce-link_hover_color','#B83838',NULL,'2026-05-07 01:57:58'),(91,'theme-amerce-border_color','#E9E9E9',NULL,'2026-05-07 01:57:58'),(92,'theme-amerce-success_color','#3DAB25',NULL,'2026-05-07 01:57:58'),(93,'theme-amerce-danger_color','#F03E3E',NULL,'2026-05-07 01:57:58'),(94,'theme-amerce-footer_style','style-9',NULL,'2026-05-07 01:57:58'),(95,'theme-amerce-footer_payment_icons','visa.png,master-card.png,amex.png,paypal.png,water.png,discover.png',NULL,'2026-05-07 01:57:58'),(96,'theme-amerce-footer_address','600 N Michigan Ave, Chicago, IL 60611, USA',NULL,'2026-05-07 01:57:58'),(97,'theme-amerce-footer_email','hi.amere@gmail.com',NULL,'2026-05-07 01:57:58'),(98,'theme-amerce-footer_phone','315-666-6688',NULL,'2026-05-07 01:57:58'),(99,'theme-amerce-facebook_url','https://facebook.com',NULL,'2026-05-07 01:57:58'),(100,'theme-amerce-twitter_url','https://x.com',NULL,'2026-05-07 01:57:58'),(101,'theme-amerce-instagram_url','https://instagram.com',NULL,'2026-05-07 01:57:58'),(102,'theme-amerce-tiktok_url','https://tiktok.com',NULL,'2026-05-07 01:57:58'),(103,'theme-amerce-snapchat_url','https://snapchat.com',NULL,'2026-05-07 01:57:58'),(104,'theme-amerce-product_card_default_style','style-1',NULL,'2026-05-07 01:57:58'),(105,'theme-amerce-product_card_hover_style','hover-01',NULL,'2026-05-07 01:57:58'),(106,'theme-amerce-product_card_show_color_swatches','1',NULL,'2026-05-07 01:57:58'),(107,'theme-amerce-default_filter_position','sidebar',NULL,'2026-05-07 01:57:58'),(108,'theme-amerce-default_pagination_style','numbered',NULL,'2026-05-07 01:57:58'),(109,'theme-amerce-enable_quick_view','1',NULL,'2026-05-07 01:57:58'),(110,'theme-amerce-enable_quick_shop','1',NULL,'2026-05-07 01:57:58'),(111,'theme-amerce-preloader_enabled','1',NULL,'2026-05-07 01:57:58'),(112,'theme-amerce-scroll_to_top_enabled','1',NULL,'2026-05-07 01:57:58'),(113,'theme-amerce-homepage_body_class','home-fashion-3',NULL,'2026-05-07 01:57:58'),(114,'theme-amerce-site_title','Amerce',NULL,'2026-05-07 01:57:58'),(115,'theme-amerce-seo_title','Amerce — Multi-Purpose eCommerce Theme',NULL,'2026-05-07 01:57:58'),(116,'theme-amerce-seo_description','Amerce is a multi-purpose eCommerce and marketplace theme for Botble CMS — 21 niche presets, sustainable shopping, and fast checkout.',NULL,'2026-05-07 01:57:58'),(117,'theme-amerce-copyright','©2026 Amerce. All Rights Reserved.',NULL,'2026-05-07 01:57:58'),(118,'theme-amerce-newsletter_popup_enable','1',NULL,'2026-05-07 01:57:58'),(119,'theme-amerce-newsletter_popup_image','section/banner-newsletter.jpg',NULL,'2026-05-07 01:57:58'),(120,'theme-amerce-newsletter_popup_subtitle','Subscribe & Enjoy',NULL,'2026-05-07 01:57:58'),(121,'theme-amerce-newsletter_popup_title','10% OFF',NULL,'2026-05-07 01:57:58'),(122,'theme-amerce-newsletter_popup_description','Join our email list & be first to Receive 10% OFF your next order, exclusive offers & more!',NULL,'2026-05-07 01:57:58'),(123,'theme-amerce-newsletter_popup_delay','5',NULL,'2026-05-07 01:57:58'),(124,'theme-amerce-newsletter_popup_display_pages','[\"public.index\"]',NULL,'2026-05-07 01:57:58'),(125,'theme-amerce-store_phone','+1 666 234 8888',NULL,'2026-05-07 01:57:58'),(126,'theme-amerce-store_email','hi.amere@gmail.com',NULL,'2026-05-07 01:57:58'),(127,'theme-amerce-store_address','2163 Phillips Gap Rd, West Jefferson, North Carolina, United States',NULL,'2026-05-07 01:57:58'),(128,'theme-amerce-store_business_hours_weekday','Mon - Sat: 7:30am - 8:00pm PST',NULL,'2026-05-07 01:57:58'),(129,'theme-amerce-store_business_hours_weekend','Sunday: 9:00am - 5:00pm PST',NULL,'2026-05-07 01:57:58'),(130,'theme-amerce-store_map_address','2163 Phillips Gap Rd, West Jefferson, NC',NULL,'2026-05-07 01:57:58'),(131,'theme-amerce-header_shadow_class','scr-box-shadow-2',NULL,'2026-05-07 01:57:58'),(132,'theme-amerce-topbar_bg_class','bg-primary',NULL,'2026-05-07 01:57:58'),(133,'theme-amerce-topbar_wrapper_override','bg-primary tf-btn-swiper-main',NULL,'2026-05-07 01:57:58'),(134,'theme-amerce-topbar_layout','slides-only',NULL,'2026-05-07 01:57:58'),(135,'theme-amerce-footer_wrapper_override','bg-main',NULL,'2026-05-07 01:57:58'),(136,'theme-amerce-vi-topbar_text','Miễn phí vận chuyển cho đơn hàng trên 99$',NULL,NULL),(137,'theme-amerce-vi-site_title','Amerce',NULL,NULL),(138,'theme-amerce-vi-seo_title','Amerce — Theme Thương mại điện tử Đa năng',NULL,NULL),(139,'theme-amerce-vi-seo_description','Amerce là theme thương mại điện tử và marketplace đa năng dành cho Botble CMS — 21 preset theo từng ngách, mua sắm bền vững và thanh toán nhanh.',NULL,NULL),(140,'theme-amerce-vi-copyright','© 2026 Amerce. Bảo lưu mọi quyền.',NULL,NULL),(141,'theme-amerce-ar-topbar_text','شحن مجاني للطلبات التي تتجاوز 99$',NULL,NULL),(142,'theme-amerce-ar-site_title','Amerce',NULL,NULL),(143,'theme-amerce-ar-seo_title','Amerce — قالب تجارة إلكترونية متعدّد الاستخدامات',NULL,NULL),(144,'theme-amerce-ar-seo_description','Amerce قالب تجارة إلكترونية ومنصّة سوق متعدّد الاستخدامات لـ Botble CMS — 21 إعداداً مسبقاً متخصصاً، تسوّق مستدام ودفع سريع.',NULL,NULL),(145,'theme-amerce-ar-copyright','© 2026 Amerce. جميع الحقوق محفوظة.',NULL,NULL),(146,'theme-amerce-fr-topbar_text','Livraison gratuite dès 99 $ d\'achat',NULL,NULL),(147,'theme-amerce-fr-site_title','Amerce',NULL,NULL),(148,'theme-amerce-fr-seo_title','Amerce — Thème e-commerce polyvalent',NULL,NULL),(149,'theme-amerce-fr-seo_description','Amerce est un thème e-commerce et marketplace polyvalent pour Botble CMS : 21 préréglages sectoriels, shopping responsable et paiement express.',NULL,NULL),(150,'theme-amerce-fr-copyright','© 2026 Amerce. Tous droits réservés.',NULL,NULL),(151,'theme-amerce-id-topbar_text','Pengiriman gratis untuk pesanan di atas $99',NULL,NULL),(152,'theme-amerce-id-site_title','Amerce',NULL,NULL),(153,'theme-amerce-id-seo_title','Amerce — Tema E-commerce Serbaguna',NULL,NULL),(154,'theme-amerce-id-seo_description','Amerce adalah tema e-commerce dan marketplace serbaguna untuk Botble CMS — 21 preset spesifik niche, belanja berkelanjutan, dan checkout cepat.',NULL,NULL),(155,'theme-amerce-id-copyright','© 2026 Amerce. Semua hak dilindungi.',NULL,NULL);

--
-- Table structure for table `simple_slider_items`
--

CREATE TABLE `simple_slider_items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `simple_slider_id` bigint unsigned NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `order` int unsigned NOT NULL DEFAULT '0',
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `simple_slider_items`
--

INSERT INTO `simple_slider_items` VALUES (1,1,'Find Your\nSignature Style','slider/fashion-3/slider-1.jpg','/products','',0,'published','2026-05-07 01:57:53','2026-05-07 01:57:53'),(2,1,'Your Ultimate\nStyle Destination','slider/fashion-3/slider-2.jpg','/products','',1,'published','2026-05-07 01:57:53','2026-05-07 01:57:53'),(3,1,'Activewear that\nsupports every move.','slider/fashion-3/slider-3.jpg','/products','',2,'published','2026-05-07 01:57:53','2026-05-07 01:57:53');

--
-- Table structure for table `simple_sliders`
--

CREATE TABLE `simple_sliders` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `key` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `simple_sliders`
--

INSERT INTO `simple_sliders` VALUES (1,'Homepage Hero','home-hero','Hero slider for the home-fashion-3 (activewear-fashion) preset.','published','2026-05-07 01:57:53','2026-05-07 01:57:53');

--
-- Table structure for table `slugs`
--

CREATE TABLE `slugs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reference_id` bigint unsigned NOT NULL,
  `reference_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `prefix` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `slugs_reference_id_index` (`reference_id`),
  KEY `slugs_key_index` (`key`),
  KEY `slugs_prefix_index` (`prefix`),
  KEY `slugs_reference_index` (`reference_id`,`reference_type`),
  KEY `idx_key_prefix` (`key`,`prefix`),
  KEY `idx_slugs_reference` (`reference_type`,`reference_id`)
) ENGINE=InnoDB AUTO_INCREMENT=94 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `slugs`
--

INSERT INTO `slugs` VALUES (1,'trends',1,'Botble\\Blog\\Models\\Tag','tag','2026-05-07 01:57:52','2026-05-07 01:57:52'),(2,'styling-tips',2,'Botble\\Blog\\Models\\Tag','tag','2026-05-07 01:57:52','2026-05-07 01:57:52'),(3,'sustainable',3,'Botble\\Blog\\Models\\Tag','tag','2026-05-07 01:57:52','2026-05-07 01:57:52'),(4,'new-arrivals',4,'Botble\\Blog\\Models\\Tag','tag','2026-05-07 01:57:52','2026-05-07 01:57:52'),(5,'limited-edition',5,'Botble\\Blog\\Models\\Tag','tag','2026-05-07 01:57:52','2026-05-07 01:57:52'),(6,'behind-the-scenes',6,'Botble\\Blog\\Models\\Tag','tag','2026-05-07 01:57:52','2026-05-07 01:57:52'),(7,'buyer-guide',7,'Botble\\Blog\\Models\\Tag','tag','2026-05-07 01:57:52','2026-05-07 01:57:52'),(8,'care-tips',8,'Botble\\Blog\\Models\\Tag','tag','2026-05-07 01:57:52','2026-05-07 01:57:52'),(9,'capsule-wardrobe',9,'Botble\\Blog\\Models\\Tag','tag','2026-05-07 01:57:52','2026-05-07 01:57:52'),(10,'material-stories',10,'Botble\\Blog\\Models\\Tag','tag','2026-05-07 01:57:52','2026-05-07 01:57:52'),(11,'holiday-gifting',11,'Botble\\Blog\\Models\\Tag','tag','2026-05-07 01:57:52','2026-05-07 01:57:52'),(12,'editor-picks',12,'Botble\\Blog\\Models\\Tag','tag','2026-05-07 01:57:52','2026-05-07 01:57:52'),(13,'yoga-mindfulness',1,'Botble\\Blog\\Models\\Category','','2026-05-07 01:57:53','2026-05-07 01:57:53'),(14,'running',2,'Botble\\Blog\\Models\\Category','','2026-05-07 01:57:53','2026-05-07 01:57:53'),(15,'strength-training',3,'Botble\\Blog\\Models\\Category','','2026-05-07 01:57:53','2026-05-07 01:57:53'),(16,'recovery',4,'Botble\\Blog\\Models\\Category','','2026-05-07 01:57:53','2026-05-07 01:57:53'),(17,'activewear-trends',5,'Botble\\Blog\\Models\\Category','','2026-05-07 01:57:53','2026-05-07 01:57:53'),(18,'the-activewear-edit-studio-staples-for-every-practice',1,'Botble\\Blog\\Models\\Post','','2026-05-07 01:57:53','2026-05-07 01:57:53'),(19,'yoga-routine-basics-a-20-minute-daily-flow',2,'Botble\\Blog\\Models\\Post','','2026-05-07 01:57:53','2026-05-07 01:57:53'),(20,'how-to-choose-the-right-leggings-for-your-practice',3,'Botble\\Blog\\Models\\Post','','2026-05-07 01:57:53','2026-05-07 01:57:53'),(21,'sweat-wicking-fabrics-what-actually-works',4,'Botble\\Blog\\Models\\Post','','2026-05-07 01:57:53','2026-05-07 01:57:53'),(22,'studio-to-street-activewear-that-works-all-day',5,'Botble\\Blog\\Models\\Post','','2026-05-07 01:57:53','2026-05-07 01:57:53'),(23,'recovery-tips-for-the-day-after-a-hard-workout',6,'Botble\\Blog\\Models\\Post','','2026-05-07 01:57:53','2026-05-07 01:57:53'),(24,'yoga',1,'Botble\\Ecommerce\\Models\\ProductCategory','product-categories','2026-05-07 01:57:53','2026-05-07 01:57:53'),(25,'leggings',2,'Botble\\Ecommerce\\Models\\ProductCategory','product-categories','2026-05-07 01:57:53','2026-05-07 01:57:53'),(26,'tennis',3,'Botble\\Ecommerce\\Models\\ProductCategory','product-categories','2026-05-07 01:57:53','2026-05-07 01:57:53'),(27,'gym-wear',4,'Botble\\Ecommerce\\Models\\ProductCategory','product-categories','2026-05-07 01:57:53','2026-05-07 01:57:53'),(28,'running',5,'Botble\\Ecommerce\\Models\\ProductCategory','product-categories','2026-05-07 01:57:53','2026-05-07 01:57:53'),(29,'lyocell-wrap-top',1,'Botble\\Ecommerce\\Models\\Product','products','2026-05-07 01:57:54','2026-05-07 01:57:54'),(30,'sports-bra-pro',2,'Botble\\Ecommerce\\Models\\Product','products','2026-05-07 01:57:54','2026-05-07 01:57:54'),(31,'cotton-buttons-top',3,'Botble\\Ecommerce\\Models\\Product','products','2026-05-07 01:57:54','2026-05-07 01:57:54'),(32,'wool-midi-coat',4,'Botble\\Ecommerce\\Models\\Product','products','2026-05-07 01:57:54','2026-05-07 01:57:54'),(33,'high-performance-leggings',5,'Botble\\Ecommerce\\Models\\Product','products','2026-05-07 01:57:54','2026-05-07 01:57:54'),(34,'tennis-polo',6,'Botble\\Ecommerce\\Models\\Product','products','2026-05-07 01:57:54','2026-05-07 01:57:54'),(35,'running-shorts',7,'Botble\\Ecommerce\\Models\\Product','products','2026-05-07 01:57:54','2026-05-07 01:57:54'),(36,'about',1,'Botble\\Page\\Models\\Page','','2026-05-07 01:57:58','2026-05-07 01:57:58'),(37,'contact',2,'Botble\\Page\\Models\\Page','','2026-05-07 01:57:58','2026-05-07 01:57:58'),(38,'faq',3,'Botble\\Page\\Models\\Page','','2026-05-07 01:57:58','2026-05-07 01:57:58'),(39,'privacy-policy',4,'Botble\\Page\\Models\\Page','','2026-05-07 01:57:58','2026-05-07 01:57:58'),(40,'terms-conditions',5,'Botble\\Page\\Models\\Page','','2026-05-07 01:57:58','2026-05-07 01:57:58'),(41,'returns-refunds',6,'Botble\\Page\\Models\\Page','','2026-05-07 01:57:58','2026-05-07 01:57:58'),(42,'shipping',7,'Botble\\Page\\Models\\Page','','2026-05-07 01:57:58','2026-05-07 01:57:58'),(43,'our-stores',8,'Botble\\Page\\Models\\Page','','2026-05-07 01:57:58','2026-05-07 01:57:58'),(44,'blog',9,'Botble\\Page\\Models\\Page','','2026-05-07 01:57:58','2026-05-07 01:57:58'),(45,'careers',10,'Botble\\Page\\Models\\Page','','2026-05-07 01:57:58','2026-05-07 01:57:58'),(46,'sustainability',11,'Botble\\Page\\Models\\Page','','2026-05-07 01:57:58','2026-05-07 01:57:58'),(47,'homepage',12,'Botble\\Page\\Models\\Page','','2026-05-07 01:57:58','2026-05-07 01:57:58'),(48,'wool-midi-coat',8,'Botble\\Ecommerce\\Models\\Product','products','2026-05-07 01:58:02','2026-05-07 01:58:02'),(49,'wool-midi-coat',9,'Botble\\Ecommerce\\Models\\Product','products','2026-05-07 01:58:02','2026-05-07 01:58:02'),(50,'wool-midi-coat',10,'Botble\\Ecommerce\\Models\\Product','products','2026-05-07 01:58:02','2026-05-07 01:58:02'),(51,'high-performance-leggings',11,'Botble\\Ecommerce\\Models\\Product','products','2026-05-07 01:58:02','2026-05-07 01:58:02'),(52,'running-shorts',12,'Botble\\Ecommerce\\Models\\Product','products','2026-05-07 01:58:02','2026-05-07 01:58:02'),(53,'running-shorts',13,'Botble\\Ecommerce\\Models\\Product','products','2026-05-07 01:58:02','2026-05-07 01:58:02'),(54,'anthro',1,'Botble\\Ecommerce\\Models\\Brand','brands','2026-05-07 01:58:02','2026-05-07 01:58:02'),(55,'anvouge',2,'Botble\\Ecommerce\\Models\\Brand','brands','2026-05-07 01:58:02','2026-05-07 01:58:02'),(56,'bohome',3,'Botble\\Ecommerce\\Models\\Brand','brands','2026-05-07 01:58:02','2026-05-07 01:58:02'),(57,'carolin',4,'Botble\\Ecommerce\\Models\\Brand','brands','2026-05-07 01:58:02','2026-05-07 01:58:02'),(58,'cheryl',5,'Botble\\Ecommerce\\Models\\Brand','brands','2026-05-07 01:58:02','2026-05-07 01:58:02'),(59,'crate',6,'Botble\\Ecommerce\\Models\\Brand','brands','2026-05-07 01:58:02','2026-05-07 01:58:02'),(60,'findr',7,'Botble\\Ecommerce\\Models\\Brand','brands','2026-05-07 01:58:02','2026-05-07 01:58:02'),(61,'intdeco',8,'Botble\\Ecommerce\\Models\\Brand','brands','2026-05-07 01:58:02','2026-05-07 01:58:02'),(62,'modave',9,'Botble\\Ecommerce\\Models\\Brand','brands','2026-05-07 01:58:02','2026-05-07 01:58:02'),(63,'panadoxn',10,'Botble\\Ecommerce\\Models\\Brand','brands','2026-05-07 01:58:02','2026-05-07 01:58:02'),(64,'shangxi',11,'Botble\\Ecommerce\\Models\\Brand','brands','2026-05-07 01:58:02','2026-05-07 01:58:02'),(65,'sopify',12,'Botble\\Ecommerce\\Models\\Brand','brands','2026-05-07 01:58:02','2026-05-07 01:58:02'),(66,'cotton',1,'Botble\\Ecommerce\\Models\\ProductTag','product-tags','2026-05-07 01:58:02','2026-05-07 01:58:02'),(67,'linen',2,'Botble\\Ecommerce\\Models\\ProductTag','product-tags','2026-05-07 01:58:02','2026-05-07 01:58:02'),(68,'wool',3,'Botble\\Ecommerce\\Models\\ProductTag','product-tags','2026-05-07 01:58:02','2026-05-07 01:58:02'),(69,'leather',4,'Botble\\Ecommerce\\Models\\ProductTag','product-tags','2026-05-07 01:58:02','2026-05-07 01:58:02'),(70,'tencel',5,'Botble\\Ecommerce\\Models\\ProductTag','product-tags','2026-05-07 01:58:02','2026-05-07 01:58:02'),(71,'recycled',6,'Botble\\Ecommerce\\Models\\ProductTag','product-tags','2026-05-07 01:58:02','2026-05-07 01:58:02'),(72,'made-in-portugal',7,'Botble\\Ecommerce\\Models\\ProductTag','product-tags','2026-05-07 01:58:02','2026-05-07 01:58:02'),(73,'made-in-italy',8,'Botble\\Ecommerce\\Models\\ProductTag','product-tags','2026-05-07 01:58:02','2026-05-07 01:58:02'),(74,'hand-crafted',9,'Botble\\Ecommerce\\Models\\ProductTag','product-tags','2026-05-07 01:58:02','2026-05-07 01:58:02'),(75,'vegan',10,'Botble\\Ecommerce\\Models\\ProductTag','product-tags','2026-05-07 01:58:02','2026-05-07 01:58:02'),(76,'limited-run',11,'Botble\\Ecommerce\\Models\\ProductTag','product-tags','2026-05-07 01:58:02','2026-05-07 01:58:02'),(77,'best-seller',12,'Botble\\Ecommerce\\Models\\ProductTag','product-tags','2026-05-07 01:58:02','2026-05-07 01:58:02'),(78,'new-arrival',13,'Botble\\Ecommerce\\Models\\ProductTag','product-tags','2026-05-07 01:58:02','2026-05-07 01:58:02'),(79,'editor-pick',14,'Botble\\Ecommerce\\Models\\ProductTag','product-tags','2026-05-07 01:58:02','2026-05-07 01:58:02'),(80,'eco-friendly',15,'Botble\\Ecommerce\\Models\\ProductTag','product-tags','2026-05-07 01:58:02','2026-05-07 01:58:02'),(81,'streetwear',1,'Botble\\Ecommerce\\Models\\ProductCollection','collections','2026-05-07 01:58:02','2026-05-07 01:58:02'),(82,'statement-drops',2,'Botble\\Ecommerce\\Models\\ProductCollection','collections','2026-05-07 01:58:02','2026-05-07 01:58:02'),(83,'best-sellers',3,'Botble\\Ecommerce\\Models\\ProductCollection','collections','2026-05-07 01:58:02','2026-05-07 01:58:02'),(84,'outerwear',4,'Botble\\Ecommerce\\Models\\ProductCollection','collections','2026-05-07 01:58:02','2026-05-07 01:58:02'),(85,'tees-hoodies',5,'Botble\\Ecommerce\\Models\\ProductCollection','collections','2026-05-07 01:58:02','2026-05-07 01:58:02'),(86,'bottoms',6,'Botble\\Ecommerce\\Models\\ProductCollection','collections','2026-05-07 01:58:02','2026-05-07 01:58:02'),(87,'sneakers',7,'Botble\\Ecommerce\\Models\\ProductCollection','collections','2026-05-07 01:58:02','2026-05-07 01:58:02'),(88,'accessories',8,'Botble\\Ecommerce\\Models\\ProductCollection','collections','2026-05-07 01:58:02','2026-05-07 01:58:02'),(89,'sale',9,'Botble\\Ecommerce\\Models\\ProductCollection','collections','2026-05-07 01:58:02','2026-05-07 01:58:02'),(90,'anthro-studio',1,'Botble\\Marketplace\\Models\\Store','stores','2026-05-07 01:58:02','2026-05-07 01:58:02'),(91,'crate-furniture-co',2,'Botble\\Marketplace\\Models\\Store','stores','2026-05-07 01:58:02','2026-05-07 01:58:02'),(92,'findr-audio',3,'Botble\\Marketplace\\Models\\Store','stores','2026-05-07 01:58:02','2026-05-07 01:58:02'),(93,'bohome-living',4,'Botble\\Marketplace\\Models\\Store','stores','2026-05-07 01:58:02','2026-05-07 01:58:02');

--
-- Table structure for table `slugs_translations`
--

CREATE TABLE `slugs_translations` (
  `lang_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slugs_id` bigint unsigned NOT NULL,
  `key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `prefix` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT '',
  PRIMARY KEY (`lang_code`,`slugs_id`),
  KEY `idx_slugid_key_prefix` (`slugs_id`,`key`,`prefix`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `slugs_translations`
--

INSERT INTO `slugs_translations` VALUES ('ar',1,'alatgahat','tag'),('fr',1,'tendances','tag'),('id',1,'tren','tag'),('vi',1,'xu-huong','tag'),('fr',2,'conseils-de-style','tag'),('vi',2,'meo-phoi-do','tag'),('ar',2,'nsayh-altnsyk','tag'),('id',2,'tips-gaya','tag'),('vi',3,'ben-vung','tag'),('id',3,'berkelanjutan','tag'),('fr',3,'durable','tag'),('ar',3,'mstdam','tag'),('id',4,'baru-datang','tag'),('vi',4,'hang-moi-ve','tag'),('fr',4,'nouveautes','tag'),('ar',4,'osl-hdytha','tag'),('ar',5,'asdar-mhdod','tag'),('id',5,'edisi-terbatas','tag'),('fr',5,'edition-limitee','tag'),('vi',5,'phien-ban-gioi-han','tag'),('fr',6,'coulisses','tag'),('id',6,'di-balik-layar','tag'),('vi',6,'hau-truong','tag'),('ar',6,'mn-alkoalys','tag'),('vi',7,'cam-nang-mua-sam','tag'),('ar',7,'dlyl-almshtry','tag'),('fr',7,'guide-dachat','tag'),('id',7,'panduan-pembeli','tag'),('fr',8,'conseils-dentretien','tag'),('vi',8,'meo-bao-quan','tag'),('ar',8,'nsayh-alaanay','tag'),('id',8,'tips-perawatan','tag'),('id',9,'capsule-wardrobe','tag'),('fr',9,'garde-robe-capsule','tag'),('ar',9,'khzan-alkbsol','tag'),('vi',9,'tu-do-capsule','tag'),('vi',10,'chuyen-vat-lieu','tag'),('fr',10,'histoires-de-matieres','tag'),('id',10,'kisah-material','tag'),('ar',10,'kss-alkhamat','tag'),('fr',11,'cadeaux-des-fetes','tag'),('id',11,'hadiah-liburan','tag'),('ar',11,'hdaya-alaaayad','tag'),('vi',11,'qua-tang-dip-le','tag'),('ar',12,'akhtyarat-almhrr','tag'),('vi',12,'bien-tap-vien-chon','tag'),('fr',12,'choix-de-la-redaction','tag'),('id',12,'pilihan-editor','tag'),('ar',13,'yoga-amp-mindfulness',''),('fr',13,'yoga-amp-mindfulness',''),('id',13,'yoga-amp-mindfulness',''),('vi',13,'yoga-amp-mindfulness',''),('ar',14,'running',''),('fr',14,'running',''),('id',14,'running',''),('vi',14,'running',''),('ar',15,'strength-training',''),('fr',15,'strength-training',''),('id',15,'strength-training',''),('vi',15,'strength-training',''),('ar',16,'recovery',''),('fr',16,'recovery',''),('id',16,'recovery',''),('vi',16,'recovery',''),('ar',17,'activewear-trends',''),('fr',17,'activewear-trends',''),('id',17,'activewear-trends',''),('vi',17,'activewear-trends',''),('ar',18,'the-activewear-edit-studio-staples-for-every-practice',''),('fr',18,'the-activewear-edit-studio-staples-for-every-practice',''),('id',18,'the-activewear-edit-studio-staples-for-every-practice',''),('vi',18,'the-activewear-edit-studio-staples-for-every-practice',''),('ar',19,'yoga-routine-basics-a-20-minute-daily-flow',''),('fr',19,'yoga-routine-basics-a-20-minute-daily-flow',''),('id',19,'yoga-routine-basics-a-20-minute-daily-flow',''),('vi',19,'yoga-routine-basics-a-20-minute-daily-flow',''),('ar',20,'how-to-choose-the-right-leggings-for-your-practice',''),('fr',20,'how-to-choose-the-right-leggings-for-your-practice',''),('id',20,'how-to-choose-the-right-leggings-for-your-practice',''),('vi',20,'how-to-choose-the-right-leggings-for-your-practice',''),('ar',21,'sweat-wicking-fabrics-what-actually-works',''),('fr',21,'sweat-wicking-fabrics-what-actually-works',''),('id',21,'sweat-wicking-fabrics-what-actually-works',''),('vi',21,'sweat-wicking-fabrics-what-actually-works',''),('ar',22,'studio-to-street-activewear-that-works-all-day',''),('fr',22,'studio-to-street-activewear-that-works-all-day',''),('id',22,'studio-to-street-activewear-that-works-all-day',''),('vi',22,'studio-to-street-activewear-that-works-all-day',''),('ar',23,'recovery-tips-for-the-day-after-a-hard-workout',''),('fr',23,'recovery-tips-for-the-day-after-a-hard-workout',''),('id',23,'recovery-tips-for-the-day-after-a-hard-workout',''),('vi',23,'recovery-tips-for-the-day-after-a-hard-workout',''),('ar',24,'yoga','product-categories'),('fr',24,'yoga','product-categories'),('id',24,'yoga','product-categories'),('vi',24,'yoga','product-categories'),('ar',25,'leggings','product-categories'),('fr',25,'leggings','product-categories'),('id',25,'leggings','product-categories'),('vi',25,'leggings','product-categories'),('ar',26,'tennis','product-categories'),('fr',26,'tennis','product-categories'),('id',26,'tennis','product-categories'),('vi',26,'tennis','product-categories'),('ar',27,'gym-wear','product-categories'),('fr',27,'gym-wear','product-categories'),('id',27,'gym-wear','product-categories'),('vi',27,'gym-wear','product-categories'),('ar',28,'running','product-categories'),('fr',28,'running','product-categories'),('id',28,'running','product-categories'),('vi',28,'running','product-categories'),('ar',29,'lyocell-wrap-top','products'),('fr',29,'lyocell-wrap-top','products'),('id',29,'lyocell-wrap-top','products'),('vi',29,'lyocell-wrap-top','products'),('ar',30,'sports-bra-pro','products'),('fr',30,'sports-bra-pro','products'),('id',30,'sports-bra-pro','products'),('vi',30,'sports-bra-pro','products'),('ar',31,'cotton-buttons-top','products'),('fr',31,'cotton-buttons-top','products'),('id',31,'cotton-buttons-top','products'),('vi',31,'cotton-buttons-top','products'),('vi',32,'ao-khoac-len-dang-midi','products'),('ar',32,'maatf-sofy-mtost-altol','products'),('fr',32,'manteau-midi-en-laine','products'),('id',32,'mantel-wol-midi','products'),('ar',33,'high-performance-leggings','products'),('fr',33,'high-performance-leggings','products'),('id',33,'high-performance-leggings','products'),('vi',33,'high-performance-leggings','products'),('ar',34,'tennis-polo','products'),('fr',34,'tennis-polo','products'),('id',34,'tennis-polo','products'),('vi',34,'tennis-polo','products'),('ar',35,'running-shorts','products'),('fr',35,'running-shorts','products'),('id',35,'running-shorts','products'),('vi',35,'running-shorts','products'),('fr',36,'a-propos',''),('vi',36,'gioi-thieu',''),('ar',36,'mn-nhn',''),('id',36,'tentang-kami',''),('fr',37,'contact',''),('id',37,'kontak',''),('vi',37,'lien-he',''),('ar',37,'toasl-maana',''),('ar',38,'alasyl-alshayaa',''),('vi',38,'cau-hoi-thuong-gap',''),('fr',38,'faq',''),('id',38,'pertanyaan-umum',''),('vi',39,'chinh-sach-bao-mat',''),('id',39,'kebijakan-privasi',''),('fr',39,'politique-de-confidentialite',''),('ar',39,'syas-alkhsosy',''),('ar',40,'alshrot-oalahkam',''),('fr',40,'conditions-generales',''),('vi',40,'dieu-khoan-dieu-kien',''),('id',40,'syarat-ketentuan',''),('ar',41,'alargaaa-oalastrdad',''),('vi',41,'doi-tra-hoan-tien',''),('id',41,'pengembalian-refund',''),('fr',41,'retours-remboursements',''),('ar',42,'alshhn',''),('fr',42,'livraison',''),('id',42,'pengiriman',''),('vi',42,'van-chuyen',''),('vi',43,'he-thong-cua-hang',''),('ar',43,'mtagrna',''),('fr',43,'nos-boutiques',''),('id',43,'toko-kami',''),('ar',44,'blog',''),('fr',44,'blog',''),('id',44,'blog',''),('vi',44,'blog',''),('ar',45,'careers',''),('fr',45,'careers',''),('id',45,'careers',''),('vi',45,'careers',''),('ar',46,'sustainability',''),('fr',46,'sustainability',''),('id',46,'sustainability',''),('vi',46,'sustainability',''),('fr',47,'accueil',''),('ar',47,'alsfh-alryysy',''),('id',47,'beranda',''),('vi',47,'trang-chu','');

--
-- Table structure for table `social_logins`
--

CREATE TABLE `social_logins` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `provider` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `provider_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` text COLLATE utf8mb4_unicode_ci,
  `refresh_token` text COLLATE utf8mb4_unicode_ci,
  `token_expires_at` timestamp NULL DEFAULT NULL,
  `provider_data` json DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `social_logins_provider_provider_id_unique` (`provider`,`provider_id`),
  KEY `social_logins_user_type_user_id_index` (`user_type`,`user_id`),
  KEY `social_logins_user_id_user_type_index` (`user_id`,`user_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `social_logins`
--


--
-- Table structure for table `states`
--

CREATE TABLE `states` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `abbreviation` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_id` bigint unsigned DEFAULT NULL,
  `order` tinyint NOT NULL DEFAULT '0',
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_default` tinyint unsigned NOT NULL DEFAULT '0',
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `states_slug_unique` (`slug`),
  KEY `idx_states_name` (`name`),
  KEY `idx_states_status` (`status`),
  KEY `idx_states_country_id` (`country_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `states`
--


--
-- Table structure for table `states_translations`
--

CREATE TABLE `states_translations` (
  `lang_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `states_id` bigint unsigned NOT NULL,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `abbreviation` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`states_id`),
  KEY `idx_states_trans_state_lang` (`states_id`,`lang_code`),
  KEY `idx_states_trans_name` (`name`),
  KEY `idx_states_trans_states_id` (`states_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `states_translations`
--


--
-- Table structure for table `tags`
--

CREATE TABLE `tags` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `author_id` bigint unsigned DEFAULT NULL,
  `author_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tags`
--

INSERT INTO `tags` VALUES (1,'Trends',1,'Botble\\ACL\\Models\\User','Articles tagged with Trends.','published','2026-05-07 01:57:52','2026-05-07 01:57:52'),(2,'Styling Tips',1,'Botble\\ACL\\Models\\User','Articles tagged with Styling Tips.','published','2026-05-07 01:57:52','2026-05-07 01:57:52'),(3,'Sustainable',1,'Botble\\ACL\\Models\\User','Articles tagged with Sustainable.','published','2026-05-07 01:57:52','2026-05-07 01:57:52'),(4,'New Arrivals',1,'Botble\\ACL\\Models\\User','Articles tagged with New Arrivals.','published','2026-05-07 01:57:52','2026-05-07 01:57:52'),(5,'Limited Edition',1,'Botble\\ACL\\Models\\User','Articles tagged with Limited Edition.','published','2026-05-07 01:57:52','2026-05-07 01:57:52'),(6,'Behind the Scenes',1,'Botble\\ACL\\Models\\User','Articles tagged with Behind the Scenes.','published','2026-05-07 01:57:52','2026-05-07 01:57:52'),(7,'Buyer Guide',1,'Botble\\ACL\\Models\\User','Articles tagged with Buyer Guide.','published','2026-05-07 01:57:52','2026-05-07 01:57:52'),(8,'Care Tips',1,'Botble\\ACL\\Models\\User','Articles tagged with Care Tips.','published','2026-05-07 01:57:52','2026-05-07 01:57:52'),(9,'Capsule Wardrobe',1,'Botble\\ACL\\Models\\User','Articles tagged with Capsule Wardrobe.','published','2026-05-07 01:57:52','2026-05-07 01:57:52'),(10,'Material Stories',1,'Botble\\ACL\\Models\\User','Articles tagged with Material Stories.','published','2026-05-07 01:57:52','2026-05-07 01:57:52'),(11,'Holiday Gifting',1,'Botble\\ACL\\Models\\User','Articles tagged with Holiday Gifting.','published','2026-05-07 01:57:52','2026-05-07 01:57:52'),(12,'Editor Picks',1,'Botble\\ACL\\Models\\User','Articles tagged with Editor Picks.','published','2026-05-07 01:57:52','2026-05-07 01:57:52');

--
-- Table structure for table `tags_translations`
--

CREATE TABLE `tags_translations` (
  `lang_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tags_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`tags_id`),
  KEY `idx_tags_trans_tags_id` (`tags_id`),
  KEY `idx_tags_trans_tag_lang` (`tags_id`,`lang_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tags_translations`
--

INSERT INTO `tags_translations` VALUES ('ar',1,'الاتجاهات','مقالات موسومة بالاتجاهات.'),('ar',2,'نصائح التنسيق','مقالات موسومة بنصائح التنسيق.'),('ar',3,'مستدام','مقالات موسومة بمستدام.'),('ar',4,'وصل حديثاً','مقالات موسومة بوصل حديثاً.'),('ar',5,'إصدار محدود','مقالات موسومة بإصدار محدود.'),('ar',6,'من الكواليس','مقالات موسومة بمن الكواليس.'),('ar',7,'دليل المشتري','مقالات موسومة بدليل المشتري.'),('ar',8,'نصائح العناية','مقالات موسومة بنصائح العناية.'),('ar',9,'خزانة الكبسولة','مقالات موسومة بخزانة الكبسولة.'),('ar',10,'قصص الخامات','مقالات موسومة بقصص الخامات.'),('ar',11,'هدايا الأعياد','مقالات موسومة بهدايا الأعياد.'),('ar',12,'اختيارات المحرر','مقالات موسومة باختيارات المحرر.'),('fr',1,'Tendances','Articles taggés Tendances.'),('fr',2,'Conseils de style','Articles taggés Conseils de style.'),('fr',3,'Durable','Articles taggés Durable.'),('fr',4,'Nouveautés','Articles taggés Nouveautés.'),('fr',5,'Édition limitée','Articles taggés Édition limitée.'),('fr',6,'Coulisses','Articles taggés Coulisses.'),('fr',7,'Guide d\'achat','Articles taggés Guide d\'achat.'),('fr',8,'Conseils d\'entretien','Articles taggés Conseils d\'entretien.'),('fr',9,'Garde-robe capsule','Articles taggés Garde-robe capsule.'),('fr',10,'Histoires de matières','Articles taggés Histoires de matières.'),('fr',11,'Cadeaux des fêtes','Articles taggés Cadeaux des fêtes.'),('fr',12,'Choix de la rédaction','Articles taggés Choix de la rédaction.'),('id',1,'Tren','Artikel dengan tag Tren.'),('id',2,'Tips Gaya','Artikel dengan tag Tips Gaya.'),('id',3,'Berkelanjutan','Artikel dengan tag Berkelanjutan.'),('id',4,'Baru Datang','Artikel dengan tag Baru Datang.'),('id',5,'Edisi Terbatas','Artikel dengan tag Edisi Terbatas.'),('id',6,'Di Balik Layar','Artikel dengan tag Di Balik Layar.'),('id',7,'Panduan Pembeli','Artikel dengan tag Panduan Pembeli.'),('id',8,'Tips Perawatan','Artikel dengan tag Tips Perawatan.'),('id',9,'Capsule Wardrobe','Artikel dengan tag Capsule Wardrobe.'),('id',10,'Kisah Material','Artikel dengan tag Kisah Material.'),('id',11,'Hadiah Liburan','Artikel dengan tag Hadiah Liburan.'),('id',12,'Pilihan Editor','Artikel dengan tag Pilihan Editor.'),('vi',1,'Xu hướng','Bài viết gắn thẻ Xu hướng.'),('vi',2,'Mẹo phối đồ','Bài viết gắn thẻ Mẹo phối đồ.'),('vi',3,'Bền vững','Bài viết gắn thẻ Bền vững.'),('vi',4,'Hàng mới về','Bài viết gắn thẻ Hàng mới về.'),('vi',5,'Phiên bản giới hạn','Bài viết gắn thẻ Phiên bản giới hạn.'),('vi',6,'Hậu trường','Bài viết gắn thẻ Hậu trường.'),('vi',7,'Cẩm nang mua sắm','Bài viết gắn thẻ Cẩm nang mua sắm.'),('vi',8,'Mẹo bảo quản','Bài viết gắn thẻ Mẹo bảo quản.'),('vi',9,'Tủ đồ capsule','Bài viết gắn thẻ Tủ đồ capsule.'),('vi',10,'Chuyện vật liệu','Bài viết gắn thẻ Chuyện vật liệu.'),('vi',11,'Quà tặng dịp lễ','Bài viết gắn thẻ Quà tặng dịp lễ.'),('vi',12,'Biên tập viên chọn','Bài viết gắn thẻ Biên tập viên chọn.');

--
-- Table structure for table `testimonials`
--

CREATE TABLE `testimonials` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `testimonials`
--

INSERT INTO `testimonials` VALUES (1,'Olivia Carter','The walnut side table has lived in my apartment for three years and looks better than the day it arrived. The construction quality is genuinely heirloom level.','testimonials/avatar-1.jpg','Editor — Modern Living Magazine','published','2026-05-07 01:57:52','2026-05-07 01:57:52'),(2,'James Whitfield','I have ordered three pairs of the linen trousers across two seasons. The fit is consistent, the fabric breathes beautifully, and the customer service is unmatched.','testimonials/avatar-2.jpg','Founder — Fieldnotes Studio','published','2026-05-07 01:57:52','2026-05-07 01:57:52'),(3,'Priya Khurana','Amerce is my first stop for thoughtful gifting. The packaging makes every order feel like an occasion and the curation never disappoints.','testimonials/avatar-3.jpg','Lead Designer — Studio Eight','published','2026-05-07 01:57:52','2026-05-07 01:57:52'),(4,'Daniel Reyes','Quick shipping, immaculate packaging, and the headphones are easily the best I have owned. Their support team helped me pair them with my mixer in under five minutes.','testimonials/avatar-4.jpg','Photographer','published','2026-05-07 01:57:52','2026-05-07 01:57:52'),(5,'Hannah Lindstrom','The activewear pieces hold up to every class without losing shape. I have washed them seventy times and the fabric still looks brand new.','testimonials/avatar-5.jpg','Yoga Instructor','published','2026-05-07 01:57:52','2026-05-07 01:57:52'),(6,'Kenji Sato','I shipped a coffee table to Tokyo and it arrived perfectly packed with full insurance documentation. International logistics handled flawlessly.','testimonials/avatar-6.jpg','Architect — Tokyo','published','2026-05-07 01:57:52','2026-05-07 01:57:52');

--
-- Table structure for table `testimonials_translations`
--

CREATE TABLE `testimonials_translations` (
  `lang_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `testimonials_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8mb4_unicode_ci,
  `company` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lang_code`,`testimonials_id`),
  KEY `idx_testimonials_trans_testimonials_id` (`testimonials_id`),
  KEY `idx_testimonials_trans_testimonial_lang` (`testimonials_id`,`lang_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `testimonials_translations`
--

INSERT INTO `testimonials_translations` VALUES ('ar',1,'Olivia Carter','الطاولة الجانبية من خشب الجوز معي في شقّتي منذ ثلاث سنوات وقد ازدادت جمالاً عمّا كانت يوم استلامها. حرفية التصنيع بحقّ من مستوى يُورَّث.','محرّرة — مجلة Modern Living'),('ar',2,'James Whitfield','اقتنيت ثلاثة بناطيل كتّان على مدى موسمين. القصّة ثابتة، والقماش متنفّس بشكل رائع، وخدمة العملاء لا تُضاهى.','مؤسّس — Fieldnotes Studio'),('ar',3,'Priya Khurana','Amerce وجهتي الأولى للهدايا المدروسة. التغليف يجعل كل طلب يبدو وكأنه مناسبة خاصة، والاختيار لا يخيب أبداً.','رئيسة قسم التصميم — Studio Eight'),('ar',4,'Daniel Reyes','شحن سريع، تغليف لا تشوبه شائبة، والسمّاعات بلا شك أفضل ما اقتنيت. ساعدني فريق الدعم على الاقتران بميكسر الصوت في أقل من خمس دقائق.','مصوّر فوتوغرافي'),('ar',5,'Hannah Lindstrom','ملابس الرياضة تتحمّل كل حصصي دون أن تفقد شكلها. غسلتها سبعين مرة ولا يزال القماش كأنه جديد.','مدرّبة يوغا'),('ar',6,'Kenji Sato','أرسلت طاولة قهوة إلى طوكيو فوصلت بتغليف مثالي ومعها كامل وثائق التأمين. الشحن الدولي مُدار باحتراف تام.','مهندس معماري — طوكيو'),('fr',1,'Olivia Carter','La table d\'appoint en noyer trône dans mon appartement depuis trois ans et elle est encore plus belle qu\'au premier jour. Une qualité de fabrication digne d\'un héritage familial.','Rédactrice — Magazine Modern Living'),('fr',2,'James Whitfield','J\'ai commandé trois pantalons en lin sur deux saisons. La coupe est toujours nickel, le tissu d\'une fraîcheur incomparable et le service client n\'a aucun équivalent.','Fondateur — Fieldnotes Studio'),('fr',3,'Priya Khurana','Amerce est ma première adresse pour les cadeaux qui ont du sens. L\'emballage donne à chaque commande des airs d\'occasion spéciale et la sélection ne me déçoit jamais.','Directrice du design — Studio Eight'),('fr',4,'Daniel Reyes','Livraison rapide, emballage impeccable, et ces écouteurs sont sans aucun doute les meilleurs que j\'aie jamais possédés. Le support m\'a aidé à les appairer avec ma table de mixage en moins de cinq minutes.','Photographe'),('fr',5,'Hannah Lindstrom','Cette tenue tient sur tous mes cours sans jamais perdre sa forme. Je l\'ai lavée soixante-dix fois et le tissu est comme neuf.','Professeure de yoga'),('fr',6,'Kenji Sato','J\'ai fait expédier une table basse jusqu\'à Tokyo : elle est arrivée parfaitement emballée, avec tous les documents d\'assurance. Une livraison internationale gérée à la perfection.','Architecte — Tokyo'),('id',1,'Olivia Carter','Side table walnut sudah tiga tahun di apartemen saya dan tampak lebih indah dibanding hari saya menerimanya. Kualitas pengerjaannya sungguh setara dengan barang pusaka.','Editor — Majalah Modern Living'),('id',2,'James Whitfield','Saya sudah memesan tiga pasang celana linen selama dua musim. Potongannya konsisten, kainnya sangat sejuk, dan layanan pelanggannya tak tertandingi.','Pendiri — Fieldnotes Studio'),('id',3,'Priya Khurana','Amerce adalah pilihan utama saya untuk hadiah-hadiah yang bermakna. Pengemasannya membuat setiap pesanan terasa seperti momen istimewa, dan kurasinya tidak pernah mengecewakan.','Lead Designer — Studio Eight'),('id',4,'Daniel Reyes','Pengiriman cepat, pengemasan sempurna, dan headphone-nya benar-benar yang terbaik yang pernah saya miliki. Tim support membantu saya memasangkannya dengan mixer dalam waktu kurang dari lima menit.','Fotografer'),('id',5,'Hannah Lindstrom','Pakaian olahraganya tahan setiap sesi tanpa kehilangan bentuk. Saya sudah mencucinya tujuh puluh kali dan kainnya masih seperti baru.','Instruktur Yoga'),('id',6,'Kenji Sato','Saya mengirim sebuah meja kopi ke Tokyo dan barang sampai dengan kemasan sempurna lengkap dengan dokumen asuransi. Pengiriman internasionalnya ditangani dengan sempurna.','Arsitek — Tokyo'),('vi',1,'Olivia Carter','Chiếc bàn phụ gỗ óc chó đã ở trong căn hộ của tôi ba năm và còn đẹp hơn cả ngày mới nhận. Chất lượng chế tác thực sự ở đẳng cấp gia truyền.','Biên tập viên — Tạp chí Modern Living'),('vi',2,'James Whitfield','Tôi đã đặt ba chiếc quần linen qua hai mùa. Form đều đặn, vải thoáng mát tuyệt vời và dịch vụ khách hàng không nơi nào sánh được.','Người sáng lập — Fieldnotes Studio'),('vi',3,'Priya Khurana','Amerce là điểm đến đầu tiên của tôi cho những món quà tinh tế. Cách đóng gói khiến mỗi đơn hàng cảm giác như một dịp đặc biệt và sự tuyển chọn không bao giờ làm tôi thất vọng.','Trưởng nhóm thiết kế — Studio Eight'),('vi',4,'Daniel Reyes','Vận chuyển nhanh, đóng gói hoàn hảo và đôi tai nghe chắc chắn là tốt nhất tôi từng sở hữu. Đội hỗ trợ giúp tôi ghép nối với mixer trong chưa đến năm phút.','Nhiếp ảnh gia'),('vi',5,'Hannah Lindstrom','Đồ tập chịu được mọi buổi học mà không mất form. Tôi đã giặt bảy mươi lần và vải vẫn như mới.','Huấn luyện viên Yoga'),('vi',6,'Kenji Sato','Tôi gửi một chiếc bàn cà phê đến Tokyo và nó đến nơi được đóng gói hoàn hảo cùng đầy đủ giấy tờ bảo hiểm. Vận chuyển quốc tế xử lý hoàn hảo.','Kiến trúc sư — Tokyo');

--
-- Table structure for table `user_meta`
--

CREATE TABLE `user_meta` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` text COLLATE utf8mb4_unicode_ci,
  `user_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_meta_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_meta`
--


--
-- Table structure for table `user_settings`
--

CREATE TABLE `user_settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `key` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` json NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_settings_user_type_user_id_key_unique` (`user_type`,`user_id`,`key`),
  KEY `user_settings_user_type_user_id_index` (`user_type`,`user_id`),
  KEY `user_settings_key_index` (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_settings`
--


--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `first_name` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `username` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `avatar_id` bigint unsigned DEFAULT NULL,
  `super_user` tinyint(1) NOT NULL DEFAULT '0',
  `manage_supers` tinyint(1) NOT NULL DEFAULT '0',
  `permissions` text COLLATE utf8mb4_unicode_ci,
  `last_login` timestamp NULL DEFAULT NULL,
  `sessions_invalidated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`),
  UNIQUE KEY `users_username_unique` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1,'admin@company.com',NULL,NULL,'$2y$12$ik3jVhIqNe1uM3dVzZOoZemW9I8fK4jp/bt1zfMoEB/9kU/.1UCmi',NULL,'2026-05-07 01:57:52','2026-05-07 01:57:52','System','Admin','admin',NULL,1,1,NULL,NULL,NULL);

--
-- Table structure for table `widgets`
--

CREATE TABLE `widgets` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `widget_id` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sidebar_id` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `theme` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `position` tinyint unsigned NOT NULL DEFAULT '0',
  `data` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `widgets_unique_index` (`theme`,`sidebar_id`,`widget_id`,`position`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `widgets`
--

INSERT INTO `widgets` VALUES (1,'Theme\\Amerce\\Widgets\\FooterMenuWidget','footer_company_sidebar','amerce',0,'{\"name\":\"Company\",\"menu_id\":\"footer-menu-2\"}','2026-05-07 01:57:53','2026-05-07 01:57:53'),(2,'Theme\\Amerce\\Widgets\\FooterMenuWidget','footer_customer_sidebar','amerce',0,'{\"name\":\"Customer\",\"menu_id\":\"footer-menu-1\"}','2026-05-07 01:57:53','2026-05-07 01:57:53'),(3,'Theme\\Amerce\\Widgets\\BlogAboutMeWidget','blog_sidebar','amerce',0,'{\"name\":\"Amerce Editorial\",\"title\":\"About Me\",\"image\":null,\"bio\":\"Style notes, product spotlights, and how we curate the catalog \\u2014 written by the Amerce team.\",\"social_links\":[{\"platform\":\"facebook\",\"url\":\"https:\\/\\/facebook.com\"},{\"platform\":\"instagram\",\"url\":\"https:\\/\\/instagram.com\"},{\"platform\":\"tiktok\",\"url\":\"https:\\/\\/tiktok.com\"}]}','2026-05-07 01:57:53','2026-05-07 01:57:53'),(4,'Theme\\Amerce\\Widgets\\BlogSearchWidget','blog_sidebar','amerce',1,'{\"name\":\"Search\",\"placeholder\":\"Search...\"}','2026-05-07 01:57:53','2026-05-07 01:57:53'),(5,'Theme\\Amerce\\Widgets\\BlogCategoriesWidget','blog_sidebar','amerce',2,'{\"name\":\"Categories\",\"title\":\"Categories\",\"display_posts_count\":\"yes\",\"category_ids\":[]}','2026-05-07 01:57:53','2026-05-07 01:57:53'),(6,'Theme\\Amerce\\Widgets\\RecentPostsWidget','blog_sidebar','amerce',3,'{\"name\":\"Recent Posts\",\"title\":\"Recent Posts\",\"type\":\"recent\",\"number_display\":4}','2026-05-07 01:57:53','2026-05-07 01:57:53'),(7,'Theme\\Amerce\\Widgets\\BlogTagsWidget','blog_sidebar','amerce',4,'{\"name\":\"Tags\",\"title\":\"Popular Tags\",\"number_display\":11}','2026-05-07 01:57:53','2026-05-07 01:57:53'),(8,'Theme\\Amerce\\Widgets\\ProductCategoriesWidget','product_details_sidebar','amerce',0,'{\"name\":\"Product Categories\",\"title\":\"Categories\",\"show_count\":true,\"max_depth\":2,\"category_ids\":[]}','2026-05-07 01:57:53','2026-05-07 01:57:53'),(9,'Theme\\Amerce\\Widgets\\BlogAboutMeWidget','blog_sidebar','amerce-vi',0,'{\"name\":\"Amerce Editorial\",\"title\":\"About Me\",\"image\":null,\"bio\":\"Style notes, product spotlights, and how we curate the catalog — written by the Amerce team.\",\"social_links\":[{\"platform\":\"facebook\",\"url\":\"https://facebook.com\"},{\"platform\":\"instagram\",\"url\":\"https://instagram.com\"},{\"platform\":\"tiktok\",\"url\":\"https://tiktok.com\"}]}','2026-05-07 01:57:58','2026-05-07 01:57:58'),(10,'Theme\\Amerce\\Widgets\\BlogCategoriesWidget','blog_sidebar','amerce-vi',2,'{\"name\":\"Danh m\\u1ee5c\",\"title\":\"Danh m\\u1ee5c\",\"display_posts_count\":\"yes\",\"category_ids\":[]}','2026-05-07 01:57:58','2026-05-07 01:57:58'),(11,'Theme\\Amerce\\Widgets\\BlogSearchWidget','blog_sidebar','amerce-vi',1,'{\"name\":\"T\\u00ecm ki\\u1ebfm\",\"placeholder\":\"Search...\"}','2026-05-07 01:57:58','2026-05-07 01:57:58'),(12,'Theme\\Amerce\\Widgets\\BlogTagsWidget','blog_sidebar','amerce-vi',4,'{\"name\":\"Th\\u1ebb\",\"title\":\"Th\\u1ebb ph\\u1ed5 bi\\u1ebfn\",\"number_display\":11}','2026-05-07 01:57:58','2026-05-07 01:57:58'),(13,'Theme\\Amerce\\Widgets\\RecentPostsWidget','blog_sidebar','amerce-vi',3,'{\"name\":\"B\\u00e0i vi\\u1ebft m\\u1edbi\",\"title\":\"B\\u00e0i vi\\u1ebft m\\u1edbi\",\"type\":\"recent\",\"number_display\":4}','2026-05-07 01:57:58','2026-05-07 01:57:58'),(14,'Theme\\Amerce\\Widgets\\FooterMenuWidget','footer_company_sidebar','amerce-vi',0,'{\"name\":\"C\\u00f4ng ty\",\"menu_id\":\"footer-menu-2-vi\"}','2026-05-07 01:57:58','2026-05-07 01:57:58'),(15,'Theme\\Amerce\\Widgets\\FooterMenuWidget','footer_customer_sidebar','amerce-vi',0,'{\"name\":\"Customer\",\"menu_id\":\"footer-menu-1-vi\"}','2026-05-07 01:57:58','2026-05-07 01:57:58'),(16,'Theme\\Amerce\\Widgets\\ProductCategoriesWidget','product_details_sidebar','amerce-vi',0,'{\"name\":\"Product Categories\",\"title\":\"Danh m\\u1ee5c\",\"show_count\":true,\"max_depth\":2,\"category_ids\":[]}','2026-05-07 01:57:58','2026-05-07 01:57:58'),(17,'Theme\\Amerce\\Widgets\\BlogAboutMeWidget','blog_sidebar','amerce-ar',0,'{\"name\":\"Amerce Editorial\",\"title\":\"About Me\",\"image\":null,\"bio\":\"Style notes, product spotlights, and how we curate the catalog — written by the Amerce team.\",\"social_links\":[{\"platform\":\"facebook\",\"url\":\"https://facebook.com\"},{\"platform\":\"instagram\",\"url\":\"https://instagram.com\"},{\"platform\":\"tiktok\",\"url\":\"https://tiktok.com\"}]}','2026-05-07 01:57:58','2026-05-07 01:57:58'),(18,'Theme\\Amerce\\Widgets\\BlogCategoriesWidget','blog_sidebar','amerce-ar',2,'{\"name\":\"\\u0627\\u0644\\u062a\\u0635\\u0646\\u064a\\u0641\\u0627\\u062a\",\"title\":\"\\u0627\\u0644\\u062a\\u0635\\u0646\\u064a\\u0641\\u0627\\u062a\",\"display_posts_count\":\"yes\",\"category_ids\":[]}','2026-05-07 01:57:58','2026-05-07 01:57:58'),(19,'Theme\\Amerce\\Widgets\\BlogSearchWidget','blog_sidebar','amerce-ar',1,'{\"name\":\"\\u0628\\u062d\\u062b\",\"placeholder\":\"Search...\"}','2026-05-07 01:57:58','2026-05-07 01:57:58'),(20,'Theme\\Amerce\\Widgets\\BlogTagsWidget','blog_sidebar','amerce-ar',4,'{\"name\":\"\\u0627\\u0644\\u0648\\u0633\\u0648\\u0645\",\"title\":\"\\u0627\\u0644\\u0648\\u0633\\u0648\\u0645 \\u0627\\u0644\\u0634\\u0627\\u0626\\u0639\\u0629\",\"number_display\":11}','2026-05-07 01:57:58','2026-05-07 01:57:58'),(21,'Theme\\Amerce\\Widgets\\RecentPostsWidget','blog_sidebar','amerce-ar',3,'{\"name\":\"\\u0623\\u062d\\u062f\\u062b \\u0627\\u0644\\u0645\\u0642\\u0627\\u0644\\u0627\\u062a\",\"title\":\"\\u0623\\u062d\\u062f\\u062b \\u0627\\u0644\\u0645\\u0642\\u0627\\u0644\\u0627\\u062a\",\"type\":\"recent\",\"number_display\":4}','2026-05-07 01:57:58','2026-05-07 01:57:58'),(22,'Theme\\Amerce\\Widgets\\FooterMenuWidget','footer_company_sidebar','amerce-ar',0,'{\"name\":\"\\u0627\\u0644\\u0634\\u0631\\u0643\\u0629\",\"menu_id\":\"footer-menu-2-ar\"}','2026-05-07 01:57:58','2026-05-07 01:57:58'),(23,'Theme\\Amerce\\Widgets\\FooterMenuWidget','footer_customer_sidebar','amerce-ar',0,'{\"name\":\"Customer\",\"menu_id\":\"footer-menu-1-ar\"}','2026-05-07 01:57:58','2026-05-07 01:57:58'),(24,'Theme\\Amerce\\Widgets\\ProductCategoriesWidget','product_details_sidebar','amerce-ar',0,'{\"name\":\"Product Categories\",\"title\":\"\\u0627\\u0644\\u062a\\u0635\\u0646\\u064a\\u0641\\u0627\\u062a\",\"show_count\":true,\"max_depth\":2,\"category_ids\":[]}','2026-05-07 01:57:58','2026-05-07 01:57:58'),(25,'Theme\\Amerce\\Widgets\\BlogAboutMeWidget','blog_sidebar','amerce-fr',0,'{\"name\":\"Amerce Editorial\",\"title\":\"About Me\",\"image\":null,\"bio\":\"Style notes, product spotlights, and how we curate the catalog — written by the Amerce team.\",\"social_links\":[{\"platform\":\"facebook\",\"url\":\"https://facebook.com\"},{\"platform\":\"instagram\",\"url\":\"https://instagram.com\"},{\"platform\":\"tiktok\",\"url\":\"https://tiktok.com\"}]}','2026-05-07 01:57:58','2026-05-07 01:57:58'),(26,'Theme\\Amerce\\Widgets\\BlogCategoriesWidget','blog_sidebar','amerce-fr',2,'{\"name\":\"Cat\\u00e9gories\",\"title\":\"Cat\\u00e9gories\",\"display_posts_count\":\"yes\",\"category_ids\":[]}','2026-05-07 01:57:58','2026-05-07 01:57:58'),(27,'Theme\\Amerce\\Widgets\\BlogSearchWidget','blog_sidebar','amerce-fr',1,'{\"name\":\"Rechercher\",\"placeholder\":\"Search...\"}','2026-05-07 01:57:58','2026-05-07 01:57:58'),(28,'Theme\\Amerce\\Widgets\\BlogTagsWidget','blog_sidebar','amerce-fr',4,'{\"name\":\"Tags\",\"title\":\"Tags populaires\",\"number_display\":11}','2026-05-07 01:57:58','2026-05-07 01:57:58'),(29,'Theme\\Amerce\\Widgets\\RecentPostsWidget','blog_sidebar','amerce-fr',3,'{\"name\":\"Articles r\\u00e9cents\",\"title\":\"Articles r\\u00e9cents\",\"type\":\"recent\",\"number_display\":4}','2026-05-07 01:57:58','2026-05-07 01:57:58'),(30,'Theme\\Amerce\\Widgets\\FooterMenuWidget','footer_company_sidebar','amerce-fr',0,'{\"name\":\"Soci\\u00e9t\\u00e9\",\"menu_id\":\"footer-menu-2-fr\"}','2026-05-07 01:57:58','2026-05-07 01:57:58'),(31,'Theme\\Amerce\\Widgets\\FooterMenuWidget','footer_customer_sidebar','amerce-fr',0,'{\"name\":\"Customer\",\"menu_id\":\"footer-menu-1-fr\"}','2026-05-07 01:57:58','2026-05-07 01:57:58'),(32,'Theme\\Amerce\\Widgets\\ProductCategoriesWidget','product_details_sidebar','amerce-fr',0,'{\"name\":\"Product Categories\",\"title\":\"Cat\\u00e9gories\",\"show_count\":true,\"max_depth\":2,\"category_ids\":[]}','2026-05-07 01:57:58','2026-05-07 01:57:58'),(33,'Theme\\Amerce\\Widgets\\BlogAboutMeWidget','blog_sidebar','amerce-id',0,'{\"name\":\"Amerce Editorial\",\"title\":\"About Me\",\"image\":null,\"bio\":\"Style notes, product spotlights, and how we curate the catalog — written by the Amerce team.\",\"social_links\":[{\"platform\":\"facebook\",\"url\":\"https://facebook.com\"},{\"platform\":\"instagram\",\"url\":\"https://instagram.com\"},{\"platform\":\"tiktok\",\"url\":\"https://tiktok.com\"}]}','2026-05-07 01:57:58','2026-05-07 01:57:58'),(34,'Theme\\Amerce\\Widgets\\BlogCategoriesWidget','blog_sidebar','amerce-id',2,'{\"name\":\"Kategori\",\"title\":\"Kategori\",\"display_posts_count\":\"yes\",\"category_ids\":[]}','2026-05-07 01:57:58','2026-05-07 01:57:58'),(35,'Theme\\Amerce\\Widgets\\BlogSearchWidget','blog_sidebar','amerce-id',1,'{\"name\":\"Cari\",\"placeholder\":\"Search...\"}','2026-05-07 01:57:58','2026-05-07 01:57:58'),(36,'Theme\\Amerce\\Widgets\\BlogTagsWidget','blog_sidebar','amerce-id',4,'{\"name\":\"Tag\",\"title\":\"Tag Populer\",\"number_display\":11}','2026-05-07 01:57:58','2026-05-07 01:57:58'),(37,'Theme\\Amerce\\Widgets\\RecentPostsWidget','blog_sidebar','amerce-id',3,'{\"name\":\"Postingan Terbaru\",\"title\":\"Postingan Terbaru\",\"type\":\"recent\",\"number_display\":4}','2026-05-07 01:57:58','2026-05-07 01:57:58'),(38,'Theme\\Amerce\\Widgets\\FooterMenuWidget','footer_company_sidebar','amerce-id',0,'{\"name\":\"Perusahaan\",\"menu_id\":\"footer-menu-2-id\"}','2026-05-07 01:57:58','2026-05-07 01:57:58'),(39,'Theme\\Amerce\\Widgets\\FooterMenuWidget','footer_customer_sidebar','amerce-id',0,'{\"name\":\"Customer\",\"menu_id\":\"footer-menu-1-id\"}','2026-05-07 01:57:58','2026-05-07 01:57:58'),(40,'Theme\\Amerce\\Widgets\\ProductCategoriesWidget','product_details_sidebar','amerce-id',0,'{\"name\":\"Product Categories\",\"title\":\"Kategori\",\"show_count\":true,\"max_depth\":2,\"category_ids\":[]}','2026-05-07 01:57:58','2026-05-07 01:57:58');


