-- nanoCart demo seed — tự động sinh bởi tools/export-seed.php
-- Ngày export: 2026-04-26 13:49:16
-- KHÔNG chỉnh tay — chạy lại: php tools/update-demo.php
--
-- REPLACE INTO: an toàn khi chạy lại nhiều lần
-- Thứ tự: structure.sql → data.sql → nanocart-0.1.0.sql → seed.sql

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET FOREIGN_KEY_CHECKS = 0;

-- Settings
REPLACE INTO `lc_settings` (`id`, `setting_group_key`, `type`, `key`, `value`, `title`, `description`, `function`, `priority`, `date_updated`, `date_created`) VALUES
  (88, '', 'global', 'store_template_catalog', 'nanocart-default', 'Catalog Template', '', 'template("catalog")', 0, NOW(), NOW()),
  (90, '', 'global', 'store_template_admin', 'nanocart-default', 'Admin Template', '', 'template("admin")', 0, NOW(), NOW()),
  (82, 'advanced', 'global', 'gzip_enabled', '0', 'GZIP Enabled', 'Compresses browser data. Increases the load on the server but decreases the bandwidth.', 'toggle()', 15, NOW(), NOW()),
  (36, 'customer_details', 'global', 'accounts_enabled', '1', 'Enable Customer Accounts', 'Allow customers to create an account and sign in.', 'toggle("e/d")', 11, NOW(), NOW()),
  (37, 'customer_details', 'local', 'customer_field_company', '1', 'Company Field', 'Display the field for the customer\'s company name.', 'toggle("y/n")', 21, NOW(), NOW()),
  (38, 'customer_details', 'local', 'customer_field_tax_id', '1', 'Tax ID Field', 'Display the field for the customer\'s tax ID.', 'toggle("y/n")', 22, NOW(), NOW()),
  (39, 'customer_details', 'local', 'customer_field_zone', '1', 'Zone/State/Province Field', 'Display the field for the customer\'s zone/state.', 'toggle("y/n")', 23, NOW(), NOW()),
  (87, 'security', 'local', 'captcha_enabled', '1', 'CAPTCHA', 'Prevent robots from posting form data by enabling CAPTCHA security.', 'toggle()', 16, NOW(), NOW()),
  (2, 'store_info', 'global', 'store_name', 'nanoCart Demo', 'Store Name', 'The name of your store.', 'text()', 10, NOW(), NOW()),
  (3, 'store_info', 'global', 'store_email', 'demo@nanocart.local', 'Store Email', 'The store\'s email address.', 'text()', 11, NOW(), NOW()),
  (5, 'store_info', 'local', 'store_postal_address', 'My Store
Street
Postcode City
Country', 'Store Postal Address', 'The store\'s postal address.', 'bigtext()', 13, NOW(), NOW()),
  (93, 'store_info', 'local', 'store_description', '', 'Store Description', 'Short tagline shown in footer.', 'text()', 14, NOW(), NOW()),
  (7, 'store_info', 'local', 'store_phone', '+84-xxx-xxx-xxxx', 'Store Phone Number', 'The store\'s phone number.', 'text()', 15, NOW(), NOW()),
  (94, 'store_info', 'local', 'store_facebook', '', 'Store Facebook', 'Full URL to Facebook page.', 'text()', 15, NOW(), NOW()),
  (8, 'store_info', 'local', 'store_zalo', '', 'Store Zalo', 'Zalo phone number or ID for Zalo contact button.', 'text()', 16, NOW(), NOW()),
  (10, 'store_info', 'global', 'store_country_code', 'VN', 'Store Country', 'The country of your store.', 'country()', 16, NOW(), NOW()),
  (9, 'store_info', 'local', 'store_hours', '', 'Store Hours', 'Opening hours displayed in footer (e.g. Thá»© 2â€“7 Â· 08:00â€“17:00).', 'text()', 17, NOW(), NOW()),
  (11, 'store_info', 'global', 'store_zone_code', '', 'Store Zone', 'The zone of your store.', 'zone("store_country_code")', 17, NOW(), NOW()),
  (12, 'store_info', 'global', 'store_postcode', '', 'Store Postcode', 'The postcode of your store.', 'text()', 18, NOW(), NOW()),
  (14, 'store_info', 'local', 'store_language_code', 'en', 'Store Language', 'The spoken language of your organization.', 'language()', 20, NOW(), NOW()),
  (15, 'store_info', 'global', 'store_currency_code', 'USD', 'Store Currency', 'The currency which all prices conform to.', 'currency()', 21, NOW(), NOW());

-- Slides
TRUNCATE `lc_slides_info`;
TRUNCATE `lc_slides`;
REPLACE INTO `lc_slides` (`id`, `status`, `languages`, `name`, `image`, `priority`, `date_valid_from`, `date_valid_to`, `date_updated`, `date_created`) VALUES
  (1, 0, '', 'Rocket Cart', 'slides/1-rocket-cart.svg', 1, NULL, NULL, '2026-04-26 20:34:48', '2026-04-26 14:13:18');
REPLACE INTO `lc_slides_info` (`id`, `slide_id`, `language_code`, `caption`, `link`) VALUES
  (1, 1, 'en', '<p>hello</p>', '');

-- Attributes
TRUNCATE `lc_attribute_values_info`;
TRUNCATE `lc_attribute_values`;
TRUNCATE `lc_attribute_groups_info`;
TRUNCATE `lc_attribute_groups`;

-- Manufacturers
TRUNCATE `lc_manufacturers_info`;
TRUNCATE `lc_manufacturers`;

-- Categories
TRUNCATE `lc_categories_filters`;
TRUNCATE `lc_categories_info`;
TRUNCATE `lc_categories`;
REPLACE INTO `lc_categories` (`id`, `parent_id`, `google_taxonomy_id`, `status`, `code`, `list_style`, `keywords`, `image`, `priority`, `date_updated`, `date_created`) VALUES
  (13, 12, 0, 0, '', 'columns', '', '', 0, '2026-04-26 16:57:05', '2026-04-26 16:57:05'),
  (12, 0, 0, 1, 'thi-trang', '', '', '', 4, '2026-04-26 15:24:54', '2026-04-26 15:24:54'),
  (11, 0, 0, 1, 'phu-kien', '', '', '', 3, '2026-04-26 15:24:54', '2026-04-26 15:24:54'),
  (10, 0, 0, 1, 'laptop', '', '', '', 2, '2026-04-26 15:24:54', '2026-04-26 15:24:54'),
  (9, 0, 0, 1, 'dien-thoai', '', '', '', 1, '2026-04-26 15:24:54', '2026-04-26 15:24:54');
REPLACE INTO `lc_categories_info` (`id`, `category_id`, `language_code`, `name`, `short_description`, `description`, `head_title`, `h1_title`, `meta_description`) VALUES
  (14, 11, 'en', 'Accessories', 'Headphones, chargers, cases', '', '', '', ''),
  (13, 11, 'vi', 'Phụ Kiện', 'Tai nghe, sạc nhanh, ốp lưng', '', '', '', ''),
  (12, 10, 'en', 'Laptop', 'Laptop computers', '', '', '', ''),
  (11, 10, 'vi', 'Laptop', 'Máy tính xách tay mọi phân khúc', '', '', '', ''),
  (10, 9, 'en', 'Phones', 'Brand smartphones', '', '', '', ''),
  (9, 9, 'vi', 'Điện Thoại', 'Smartphone chính hãng giá tốt', '', '', '', ''),
  (15, 12, 'vi', 'Thời Trang', 'Quần áo, giày dép xu hướng', '', '', '', ''),
  (16, 12, 'en', 'Fashion', 'Trendy clothes and shoes', '', '', '', ''),
  (17, 13, 'en', 'Nokia', '', '', '', '', '');

-- Products
TRUNCATE `lc_products_campaigns`;
TRUNCATE `lc_products_options_stock`;
TRUNCATE `lc_products_options_values`;
TRUNCATE `lc_products_options`;
TRUNCATE `lc_products_prices`;
TRUNCATE `lc_products_images`;
TRUNCATE `lc_products_attributes`;
TRUNCATE `lc_products_to_categories`;
TRUNCATE `lc_products_info`;
TRUNCATE `lc_products`;
REPLACE INTO `lc_products` (`id`, `status`, `manufacturer_id`, `supplier_id`, `delivery_status_id`, `sold_out_status_id`, `default_category_id`, `keywords`, `code`, `sku`, `mpn`, `upc`, `gtin`, `taric`, `quantity`, `quantity_min`, `quantity_max`, `quantity_step`, `quantity_unit_id`, `weight`, `weight_class`, `dim_x`, `dim_y`, `dim_z`, `dim_class`, `purchase_price`, `purchase_price_currency_code`, `recommended_price`, `tax_class_id`, `image`, `views`, `purchases`, `date_valid_from`, `date_valid_to`, `date_updated`, `date_created`) VALUES
  (11, 1, 0, 0, 0, 0, 11, '', 'TWS-PRO', 'TWSPRO-BLK', '', '', '', '', 100, 0, 0, 0, 0, 0, '', 0, 0, 0, '', 0, 'USD', 0, 0, '', 2, 0, NULL, NULL, '2026-04-26 15:24:54', '2026-04-26 15:24:54'),
  (10, 1, 0, 0, 0, 0, 10, '', 'DELL-XPS13', 'XPS13-I7-16', '', '', '', '', 15, 0, 0, 0, 0, 0, '', 0, 0, 0, '', 0, 'USD', 0, 0, '', 0, 0, NULL, NULL, '2026-04-26 15:24:54', '2026-04-26 15:24:54'),
  (9, 1, 0, 0, 0, 0, 10, '', 'MBA-M3', 'MBA-M3-8-256', '', '', '', '', 20, 0, 0, 0, 0, 0, '', 0, 0, 0, '', 0, 'USD', 0, 0, '', 0, 0, NULL, NULL, '2026-04-26 15:24:54', '2026-04-26 15:24:54'),
  (8, 1, 0, 0, 0, 0, 9, '', 'SS-S24', 'SSS24-256', '', '', '', '', 30, 0, 0, 0, 0, 0, '', 0, 0, 0, '', 0, 'USD', 0, 0, '', 0, 0, NULL, NULL, '2026-04-26 15:24:54', '2026-04-26 15:24:54'),
  (7, 1, 0, 0, 0, 0, 9, '', 'IP15-PRO', 'IP15PRO-128', '', '', '', '', 50, 0, 0, 0, 0, 0, '', 0, 0, 0, '', 0, 'USD', 0, 0, '', 3, 0, NULL, NULL, '2026-04-26 15:24:54', '2026-04-26 15:24:54'),
  (12, 1, 0, 0, 0, 0, 12, '', 'TSHIRT-NC', 'TS-NC-M-WHT', '', '', '', '', 200, 0, 0, 0, 0, 0, '', 0, 0, 0, '', 0, 'USD', 0, 0, '', 0, 0, NULL, NULL, '2026-04-26 15:24:54', '2026-04-26 15:24:54');
REPLACE INTO `lc_products_info` (`id`, `product_id`, `language_code`, `name`, `short_description`, `description`, `technical_data`, `head_title`, `meta_description`) VALUES
  (22, 11, 'en', 'True Wireless Pro Earbuds', 'ANC, 30h battery, IPX5 water resistant', '', '', '', ''),
  (21, 11, 'vi', 'Tai Nghe True Wireless Pro', 'Chống ồn ANC, pin 30 giờ, kháng nước IPX5', '', '', '', ''),
  (20, 10, 'en', 'Dell XPS 13 Core i7 16GB', 'Intel i7-1360P, 13.4 inch FHD+ display', '', '', '', ''),
  (19, 10, 'vi', 'Dell XPS 13 Core i7 16GB', 'Intel i7-1360P, màn 13.4 inch FHD+', '', '', '', ''),
  (18, 9, 'en', 'MacBook Air M3 8GB/256GB', 'M3 chip, 13.6 inch display, 18h battery', '', '', '', ''),
  (17, 9, 'vi', 'MacBook Air M3 8GB/256GB', 'Chip M3, màn 13.6 inch, pin 18 giờ', '', '', '', ''),
  (16, 8, 'en', 'Samsung Galaxy S24 256GB', 'Snapdragon 8 Gen 3, 120Hz AMOLED', '', '', '', ''),
  (15, 8, 'vi', 'Samsung Galaxy S24 256GB', 'Snapdragon 8 Gen 3, màn AMOLED 120Hz', '', '', '', ''),
  (14, 7, 'en', 'iPhone 15 Pro 128GB', 'A17 Pro chip, titanium, 48MP camera', '', '', '', ''),
  (13, 7, 'vi', 'iPhone 15 Pro 128GB', 'Chip A17 Pro, titanium, camera 48MP', '', '', '', ''),
  (23, 12, 'vi', 'Áo Thun nanoCart Logo', 'Cotton 100%, form unisex, in logo nanoCart', '', '', '', ''),
  (24, 12, 'en', 'nanoCart Logo T-Shirt', '100% cotton, unisex fit, nanoCart logo', '', '', '', '');
REPLACE INTO `lc_products_to_categories` (`product_id`, `category_id`) VALUES
  (7, 9),
  (8, 9),
  (9, 10),
  (10, 10),
  (11, 11),
  (12, 12);
REPLACE INTO `lc_products_prices` (`id`, `product_id`, `USD`, `EUR`) VALUES
  (18, 12, 19, 17),
  (17, 11, 49, 45),
  (16, 10, 899, 849),
  (15, 9, 1099, 1029),
  (14, 8, 799, 749),
  (13, 7, 999, 929);

-- Pages
TRUNCATE `lc_pages_info`;
TRUNCATE `lc_pages`;
REPLACE INTO `lc_pages` (`id`, `status`, `parent_id`, `dock`, `priority`, `date_updated`, `date_created`) VALUES
  (1, 1, 0, 'menu', 0, '2026-04-26 20:40:05', '2026-04-26 20:40:05');
REPLACE INTO `lc_pages_info` (`id`, `page_id`, `language_code`, `title`, `content`, `head_title`, `meta_description`) VALUES
  (1, 1, 'en', 'Trang chủ', '<p>xxxx</p>', '', '');

-- Modules
TRUNCATE `lc_modules`;
REPLACE INTO `lc_modules` (`id`, `module_id`, `type`, `status`, `priority`, `settings`, `last_log`, `date_pushed`, `date_processed`, `date_updated`, `date_created`) VALUES
  (1, 'ot_subtotal', 'order_total', 1, 1, '{"status":"1","priority":"1"}', '', NULL, NULL, '2026-04-26 14:13:18', '2026-04-26 14:13:18'),
  (2, 'ot_shipping_fee', 'order_total', 1, 20, '{"status":"1","free_shipping_amount":"0","priority":"20"}', '', NULL, NULL, '2026-04-26 14:13:18', '2026-04-26 14:13:18'),
  (3, 'ot_payment_fee', 'order_total', 1, 30, '{"status":"1","priority":"30"}', '', NULL, NULL, '2026-04-26 14:13:18', '2026-04-26 14:13:18'),
  (4, 'job_error_reporter', 'job', 1, 0, '{"status":"1","frequency":"Weekly","email_receipient":"","priority":"0"}', '', NULL, NULL, '2026-04-26 14:13:18', '2026-04-26 14:13:18'),
  (5, 'job_cache_cleaner', 'job', 1, 0, '{"status":"1","priority":"0"}', '', NULL, NULL, '2026-04-26 14:13:18', '2026-04-26 14:13:18'),
  (6, 'job_mysql_optimizer', 'job', 1, 0, '{"status":"1","frequency":"monthly","priority":"0"}', '', NULL, NULL, '2026-04-26 14:13:18', '2026-04-26 14:13:18');

-- Tax
TRUNCATE `lc_tax_rates`;
TRUNCATE `lc_tax_classes`;

-- Statuses
TRUNCATE `lc_sold_out_statuses_info`;
TRUNCATE `lc_sold_out_statuses`;
TRUNCATE `lc_order_statuses_info`;
TRUNCATE `lc_order_statuses`;
TRUNCATE `lc_delivery_statuses_info`;
TRUNCATE `lc_delivery_statuses`;
REPLACE INTO `lc_delivery_statuses` (`id`, `date_updated`, `date_created`) VALUES
  (1, '2026-04-26 14:13:18', '2026-04-26 14:13:18'),
  (2, '2026-04-26 14:13:18', '2026-04-26 14:13:18');
REPLACE INTO `lc_delivery_statuses_info` (`id`, `delivery_status_id`, `language_code`, `name`, `description`) VALUES
  (1, 1, 'en', '1-3 days', ''),
  (2, 2, 'en', '3-5 days', '');
REPLACE INTO `lc_order_statuses` (`id`, `state`, `icon`, `color`, `is_sale`, `is_archived`, `is_trackable`, `stock_action`, `notify`, `priority`, `date_updated`, `date_created`) VALUES
  (1, 'created', 'fa-plus', '#c0c0c0', 0, 0, 0, 'none', 0, 0, '2026-04-26 14:13:18', '2026-04-26 14:13:18'),
  (2, 'on_hold', 'fa-money', '#c0c0c0', 0, 0, 0, 'none', 0, 0, '2026-04-26 14:13:18', '2026-04-26 14:13:18'),
  (3, 'on_hold', 'fa-pause', '#c0c0c0', 1, 0, 0, 'none', 0, 0, '2026-04-26 14:13:18', '2026-04-26 14:13:18'),
  (4, 'ready', 'fa-clock-o', '#bec11d', 1, 0, 0, 'reserve', 0, 0, '2026-04-26 14:13:18', '2026-04-26 14:13:18'),
  (5, 'delayed', 'fa-hourglass-half', '#e3ab44', 1, 0, 0, 'reserve', 0, 0, '2026-04-26 14:13:18', '2026-04-26 14:13:18'),
  (6, 'processing', 'fa-cog', '#e3ab44', 1, 0, 0, '', 0, 0, '2026-04-26 14:13:18', '2026-04-26 14:13:18'),
  (7, 'completed', 'fa-check', '#99cc66', 1, 0, 1, 'commit', 0, 0, '2026-04-26 14:13:18', '2026-04-26 14:13:18'),
  (8, 'dispatched', 'fa-truck', '#99cc66', 1, 0, 1, 'commit', 0, 0, '2026-04-26 14:13:18', '2026-04-26 14:13:18'),
  (9, 'in_transit', 'fa-truck', '#e3ab44', 1, 0, 1, 'commit', 0, 0, '2026-04-26 14:13:18', '2026-04-26 14:13:18'),
  (10, 'delivered', 'fa-home', '#99cc66', 1, 1, 0, 'commit', 0, 0, '2026-04-26 14:13:18', '2026-04-26 14:13:18'),
  (11, 'returning', 'fa-undo', '#e3ab44', 1, 0, 1, 'reserve', 0, 0, '2026-04-26 14:13:18', '2026-04-26 14:13:18'),
  (12, 'returned', 'fa-building', '#99cc66', 1, 1, 0, 'commit', 0, 0, '2026-04-26 14:13:18', '2026-04-26 14:13:18'),
  (13, 'cancelled', 'fa-times', '#ff6666', 0, 1, 0, 'none', 0, 0, '2026-04-26 14:13:18', '2026-04-26 14:13:18'),
  (14, 'cancelled', 'fa-exclamation', '#ff6666', 0, 1, 0, 'none', 0, 0, '2026-04-26 14:13:18', '2026-04-26 14:13:18');
REPLACE INTO `lc_order_statuses_info` (`id`, `order_status_id`, `language_code`, `name`, `description`, `email_subject`, `email_message`) VALUES
  (1, 1, 'en', 'Created', '', '', ''),
  (2, 2, 'en', 'Awaiting payment', '', '', ''),
  (3, 3, 'en', 'On hold', '', '', ''),
  (4, 4, 'en', 'Ready', '', '', ''),
  (5, 5, 'en', 'Delayed', '', '', ''),
  (6, 6, 'en', 'Processing', '', '', ''),
  (7, 7, 'en', 'Completed', '', '', ''),
  (8, 8, 'en', 'Dispatched', '', '', ''),
  (9, 9, 'en', 'In Transit', '', '', ''),
  (10, 10, 'en', 'Delivered', '', '', ''),
  (11, 11, 'en', 'Returning', '', '', ''),
  (12, 12, 'en', 'Returned', '', '', ''),
  (13, 13, 'en', 'Cancelled', '', '', ''),
  (14, 14, 'en', 'Fraud', '', '', '');
REPLACE INTO `lc_sold_out_statuses` (`id`, `hidden`, `orderable`, `date_updated`, `date_created`) VALUES
  (1, 0, 0, '2026-04-26 14:13:18', '2026-04-26 14:13:18'),
  (2, 0, 1, '2026-04-26 14:13:18', '2026-04-26 14:13:18'),
  (3, 0, 1, '2026-04-26 14:13:18', '2026-04-26 14:13:18');
REPLACE INTO `lc_sold_out_statuses_info` (`id`, `sold_out_status_id`, `language_code`, `name`, `description`) VALUES
  (1, 1, 'en', 'Sold Out', ''),
  (2, 2, 'en', 'Temporarily Sold Out', ''),
  (3, 3, 'en', 'Backorder Item', '');

-- Units
TRUNCATE `lc_quantity_units_info`;
TRUNCATE `lc_quantity_units`;
REPLACE INTO `lc_quantity_units` (`id`, `decimals`, `separate`, `priority`, `date_updated`, `date_created`) VALUES
  (1, 0, 0, 0, '2026-04-26 14:13:18', '2026-04-26 14:13:18');
REPLACE INTO `lc_quantity_units_info` (`id`, `quantity_unit_id`, `language_code`, `name`, `description`) VALUES
  (1, 1, 'en', 'pcs', '');

SET FOREIGN_KEY_CHECKS = 1;
