audio/admin
2
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
admin/db/0810/all_www_tables.sql
T

568 lines
113 KiB
SQL
Raw Permalink Normal View History

数据库
2026-08-11 11:33:14 +08:00
-- ============================================================
-- www_* 全表合并导出（结构 + 数据）
-- 来源：db/0810 下 25 个 mysqldump 单表文件
-- 生成时间：2026-08-10 18:58:47
-- ============================================================
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS=0;
-- ------------------------------------------------------------
-- 表：www_about_settings
-- ------------------------------------------------------------
CREATE TABLE `www_about_settings` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`hero_title_zh` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '关于我们' COMMENT 'Hero 标题（中文）',
`hero_title_en` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'About Us' COMMENT 'Hero 标题（英文）',
`hero_subtitle_zh` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Hero 副标题（中文）',
`hero_subtitle_en` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Hero 副标题（英文）',
`hero_bg_url` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Hero 背景图',
`s1_title_zh` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Section 1 标题（中文）',
`s1_title_en` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Section 1 标题（英文）',
`s1_content_zh` text COLLATE utf8mb4_unicode_ci COMMENT 'Section 1 正文（中文，富文本）',
`s1_content_en` text COLLATE utf8mb4_unicode_ci COMMENT 'Section 1 正文（英文，富文本）',
`s1_image_url` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Section 1 配图',
`s1_cta_zh` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Section 1 CTA（中文）',
`s1_cta_en` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Section 1 CTA（英文）',
`s1_cta_url` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Section 1 CTA 链接',
`s2_title_zh` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Section 2 标题（中文）',
`s2_title_en` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Section 2 标题（英文）',
`s2_features` json DEFAULT NULL COMMENT '特性列表 JSON: [{icon, title_zh, title_en, desc_zh, desc_en}]',
`s3_title_zh` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Section 3 标题（中文）',
`s3_title_en` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Section 3 标题（英文）',
`s3_cta_zh` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Section 3 CTA（中文）',
`s3_cta_en` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Section 3 CTA（英文）',
`s3_cta_url` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Section 3 CTA 链接',
`updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='关于我们页面配置（单行）';
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40000 ALTER TABLE `www_about_settings` DISABLE KEYS */;
INSERT INTO `www_about_settings` (`id`, `hero_title_zh`, `hero_title_en`, `hero_subtitle_zh`, `hero_subtitle_en`, `hero_bg_url`, `s1_title_zh`, `s1_title_en`, `s1_content_zh`, `s1_content_en`, `s1_image_url`, `s1_cta_zh`, `s1_cta_en`, `s1_cta_url`, `s2_title_zh`, `s2_title_en`, `s2_features`, `s3_title_zh`, `s3_title_en`, `s3_cta_zh`, `s3_cta_en`, `s3_cta_url`, `updated_at`) VALUES (1,'关于我们','About Us','了解乐笙的品牌故事','Learn about the Luxsin story','/uploads/2026/08/1786355142479-7up2o7.jpg','我们的故事','Our Story','<p><span style=\"font-size: 16px;\"><strong>概览</strong></span></p><p><span style=\"font-size: 16px;\">Luxsin 与 Eversolo 是 Zidoo 集团旗下的高端音频品牌，致力于打造卓越的音频产品。Zidoo 集团在影音行业拥有深厚的创新积淀，具备领先的技术实力与前沿的研发成果。依托自主专利、先进技术及广泛的销售渠道，集团为 Luxsin 提供了无与伦比的研发能力。此外，其完善的售后服务体系确保了一站式支持与客户满意度。</span></p><p><span style=\"font-size: 16px;\"><strong>品牌来由</strong></span></p><p style=\"text-align: start;\">“Luxsin”之名源自“Luxury”（奢华）与“Sine”（正弦波）的结合，寓意“奢华正弦波”的优雅韵味。这一名称承载着我们对至臻音质的执着追求，以及对声音艺术的深切敬畏。在Luxsin，每一款产品都是这一理念的践行之作，将纯净之声与奢华之韵浑然融合，缔造非凡的听觉体验。Luxsin凝聚了高保真音频的精髓，我们深信，声音远不止于频率与波形，它更是一种直抵灵魂的深邃艺术。怀揣对创新的热忱，恪守至善至美的工艺承诺，Luxsin致力于打造非凡的聆听之境，让声音成为连接情感、激荡心灵、升华聆听艺术的桥梁。</p><p style=\"text-align: start;\"><strong>我们的愿景</strong></p><p style=\"text-align: start;\">在 Luxsin，我们的研发团队致力于声学算法的精细调校与人机交互技术的持续进阶。通过前沿的算法处理，我们不断突破声音性能的边界，将其提升至非凡高度。凭借硬件卓越与软件精专的深度整合，我们在数字声音还原中实现细致入微的精准把控。每一段旋律、每一个音符都经大师级调校，呈现出无与伦比的纵深层次、精妙细节与深沉情感共鸣。最终，声音如正弦波般纯净流畅，带来直抵心灵的沉浸式聆听体验。</p><p style=\"text-align: start;\">Luxsin 不仅致力于打造卓越的硬件设备，更追求超凡音质与精湛工艺的完美融合。我们的愿景不止于技术创新，更在于通过每一个音符建立深刻的情感联结。每款产品都凝聚着我们对声音艺术的热忱，精心雕琢，将音乐化为纯粹动人的听觉杰作，饱含情感与温度。通过不断树立行业新标杆，Luxsin 力求缔造影音之美与设计之雅交相辉映的聆听体验，让每一位听众沉醉于科技与艺术和谐共鸣的至臻之境。</p>','<p>Luxsin is dedicated to crafting high-fidelity audio gear for music lovers.</p>','','了解产品','View Products','/products','品牌理念','Our Values','[]','开启聆听之旅','Start Listening','联系我们','Contact Us','/contact','2026-08-10 09:46:07');
/*!40000 ALTER TABLE `www_about_settings` ENABLE KEYS */;
-- ------------------------------------------------------------
-- 表：www_footer_settings
-- ------------------------------------------------------------
CREATE TABLE `www_footer_settings` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`company_name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '公司名称',
`company_address` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '公司地址',
`contact_phone` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '联系电话',
`contact_email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '联系邮箱',
`copyright_text` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '版权信息',
`icp_number` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'ICP 备案号',
`police_number` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '公安备案号',
`updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='页脚配置（单行）';
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40000 ALTER TABLE `www_footer_settings` DISABLE KEYS */;
INSERT INTO `www_footer_settings` (`id`, `company_name`, `company_address`, `contact_phone`, `contact_email`, `copyright_text`, `icp_number`, `police_number`, `updated_at`) VALUES (1,'深圳市乐笙声学技术有限公司','','','admin@luxsinaudio.com','','粤ICP备2024224310号','','2026-08-10 07:41:44');
/*!40000 ALTER TABLE `www_footer_settings` ENABLE KEYS */;
-- ------------------------------------------------------------
-- 表：www_form_fields
-- ------------------------------------------------------------
CREATE TABLE `www_form_fields` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`name_zh` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '字段名称（中文）',
`name_en` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '字段名称（英文）',
`field_type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '字段类型: text / textarea / email / phone / select',
`is_required` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否必填',
`placeholder_zh` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '占位文本（中文）',
`placeholder_en` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '占位文本（英文）',
`options_json` json DEFAULT NULL COMMENT '下拉选项 JSON: [{label_zh, label_en, value}]（仅 select 类型）',
`sort_order` int NOT NULL DEFAULT '0' COMMENT '字段排序',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='表单字段配置';
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40000 ALTER TABLE `www_form_fields` DISABLE KEYS */;
INSERT INTO `www_form_fields` (`id`, `name_zh`, `name_en`, `field_type`, `is_required`, `placeholder_zh`, `placeholder_en`, `options_json`, `sort_order`) VALUES (1,'姓名','Name','text',1,'请输入您的姓名','Your name',NULL,1),(2,'邮箱','Email','email',1,'请输入您的邮箱','Your email',NULL,2),(3,'电话','Phone','phone',0,'请输入您的电话','Your phone',NULL,3),(4,'咨询内容','Message','textarea',1,'请输入您的咨询内容','Your message',NULL,4);
/*!40000 ALTER TABLE `www_form_fields` ENABLE KEYS */;
-- ------------------------------------------------------------
-- 表：www_form_settings
-- ------------------------------------------------------------
CREATE TABLE `www_form_settings` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`recipient_email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '通知接收邮箱',
`success_message_zh` varchar(300) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '感谢您的留言，我们会尽快回复！' COMMENT '提交成功提示（中文）',
`success_message_en` varchar(300) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Thank you for your message. We will get back to you soon!' COMMENT '提交成功提示（英文）',
`error_message_zh` varchar(300) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '提交失败，请稍后重试。' COMMENT '提交失败提示（中文）',
`error_message_en` varchar(300) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Submission failed. Please try again later.' COMMENT '提交失败提示（英文）',
`cooldown_seconds` int NOT NULL DEFAULT '60' COMMENT '防重复提交间隔（秒）',
`updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='表单全局配置（单行）';
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40000 ALTER TABLE `www_form_settings` DISABLE KEYS */;
INSERT INTO `www_form_settings` (`id`, `recipient_email`, `success_message_zh`, `success_message_en`, `error_message_zh`, `error_message_en`, `cooldown_seconds`, `updated_at`) VALUES (1,'','感谢您的留言，我们会尽快回复！','Thank you for your message!','提交失败，请稍后重试。','Submission failed.',60,'2026-08-03 08:59:30');
/*!40000 ALTER TABLE `www_form_settings` ENABLE KEYS */;
-- ------------------------------------------------------------
-- 表：www_form_submissions
-- ------------------------------------------------------------
CREATE TABLE `www_form_submissions` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`form_data` json NOT NULL COMMENT '提交数据 JSON: {field_name: value}',
`visitor_ip` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '访客 IP',
`user_agent` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '浏览器 UA',
`is_read` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否已读（admin 端标记）',
`created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `idx_created` (`created_at`),
KEY `idx_read` (`is_read`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='表单提交记录';
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40000 ALTER TABLE `www_form_submissions` DISABLE KEYS */;
/*!40000 ALTER TABLE `www_form_submissions` ENABLE KEYS */;
-- ------------------------------------------------------------
-- 表：www_i18n_entries
-- ------------------------------------------------------------
CREATE TABLE `www_i18n_entries` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`dict_key` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '词条 Key，如 nav.products',
`value_zh` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '中文值',
`value_en` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '英文值',
`description` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '词条说明（仅供 admin 参考）',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_key` (`dict_key`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='翻译词条（i18n key-value）';
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40000 ALTER TABLE `www_i18n_entries` DISABLE KEYS */;
INSERT INTO `www_i18n_entries` (`id`, `dict_key`, `value_zh`, `value_en`, `description`) VALUES (1,'nav.products','产品','Products','导航入口'),(2,'nav.news','新闻','News','导航入口'),(3,'nav.about','关于我们','About Us','导航入口'),(4,'nav.support','技术支持','Support','导航入口'),(5,'btn.learn_more','了解更多','Learn More','通用按钮'),(6,'btn.explore','探索产品','Explore','通用按钮'),(7,'btn.contact','联系我们','Contact Us','通用按钮'),(8,'btn.load_more','加载更多','Load More','列表页按钮'),(9,'btn.view_all','查看全部参数','View All Specs','参数规格展开'),(10,'btn.collapse','收起参数','Collapse','参数规格收起'),(11,'label.read_more','阅读更多','Read More','新闻卡片链接'),(12,'label.breadcrumb_home','首页','Home','面包屑'),(13,'label.breadcrumb_products','产品中心','Products','面包屑'),(14,'footer.copyright','© {year} 乐笙. 保留所有权利.','© {year} Luxsin. All rights reserved.','页脚版权');
/*!40000 ALTER TABLE `www_i18n_entries` ENABLE KEYS */;
-- ------------------------------------------------------------
-- 表：www_media
-- ------------------------------------------------------------
CREATE TABLE `www_media` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`filename` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '原始文件名',
`file_path` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '存储路径（相对 uploads/）',
`file_type` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '类型: image / video / file',
`mime_type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'MIME 类型',
`file_size` bigint unsigned NOT NULL DEFAULT '0' COMMENT '文件大小（字节）',
`width` int DEFAULT NULL COMMENT '图片/视频宽度（px）',
`height` int DEFAULT NULL COMMENT '图片/视频高度（px）',
`category` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'other' COMMENT '分类: product / banner / news / brand / video / document / other',
`thumbnail_url` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '缩略图路径（300px 宽）',
`webp_url` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'WebP 版本路径（图片自动生成）',
`ref_count` int NOT NULL DEFAULT '0' COMMENT '引用计数',
`created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`deleted_at` datetime DEFAULT NULL COMMENT '软删除时间',
PRIMARY KEY (`id`),
KEY `idx_category` (`category`),
KEY `idx_filename` (`filename`),
KEY `idx_created` (`created_at`),
KEY `idx_deleted` (`deleted_at`)
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='素材库';
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40000 ALTER TABLE `www_media` DISABLE KEYS */;
INSERT INTO `www_media` (`id`, `filename`, `file_path`, `file_type`, `mime_type`, `file_size`, `width`, `height`, `category`, `thumbnail_url`, `webp_url`, `ref_count`, `created_at`, `deleted_at`) VALUES (1,'k3_tech_report.pdf','/uploads/2026/07/1785407967831-duylsd.pdf','file','application/pdf',1795077,NULL,NULL,'other','','',0,'2026-07-30 18:39:28',NULL),(2,'92F4BEA0F2BBF96419314D34A6F44F8F.jpg','/uploads/2026/07/1785408018867-wivqq0.jpg','image','image/jpeg',515228,NULL,NULL,'other','','',0,'2026-07-30 18:40:19',NULL),(3,'x8-p2.jpg','/uploads/2026/07/1785409219838-9t8fgs.jpg','image','image/jpeg',601263,NULL,NULL,'other','','',0,'2026-07-30 19:00:20','2026-07-31 10:16:23'),(4,'home-1.mp4','/uploads/2026/07/1785409251393-80ro00.mp4','video','video/mp4',6617952,NULL,NULL,'other','','',0,'2026-07-30 19:00:51',NULL),(5,'home_logo_black.svg','/uploads/2026/07/1785480939443-x8vj9w.svg','image','image/svg+xml',10875,NULL,NULL,'other','','',0,'2026-07-31 14:55:39',NULL),(6,'1000002059.jpg','/uploads/2026/07/1785492437173-e08pwh.jpg','image','image/jpeg',284089,NULL,NULL,'other','','',0,'2026-07-31 18:07:17',NULL),(7,'x8-p2.jpg','/uploads/2026/07/1785492899133-bmyul9.jpg','image','image/jpeg',1485316,NULL,NULL,'other','','',0,'2026-07-31 18:14:59',NULL),(8,'x8-p2.jpg','/uploads/2026/07/1785493024261-m4appe.jpg','image','image/jpeg',1183599,NULL,NULL,'other','','',0,'2026-07-31 18:17:04',NULL),(9,'home-2.mp4','/uploads/2026/08/1785750535177-z1l7zh.mp4','video','video/mp4',4508159,NULL,NULL,'other','','',0,'2026-08-03 09:48:55',NULL),(10,'1785812209908-lcb23a','/uploads/2026/08/1785812209908-lcb23a.svg','image','image/svg+xml',1125891,NULL,NULL,'other','','',0,'2026-08-04 02:56:50','2026-08-04 02:57:16'),(15,'favicon','/uploads/icon/favicon.svg','image','image/svg+xml',1125891,NULL,NULL,'other','','',0,'2026-08-04 03:21:36',NULL),(17,'1785840935567-l70qaq','/uploads/2026/08/1785840935567-l70qaq.mp4','video','video/mp4',3479307,NULL,NULL,'product','','',0,'2026-08-04 10:55:36',NULL),(18,'1785908720802-r0y89v','/uploads/2026/08/1785908720802-r0y89v.jpg','image','image/jpeg',67040,NULL,NULL,'product','','',0,'2026-08-05 05:45:21',NULL),(19,'1785908748764-mj4a00','/uploads/2026/08/1785908748764-mj4a00.jpg','image','image/jpeg',82797,NULL,NULL,'product','','',0,'2026-08-05 05:45:49',NULL),(20,'1785908764804-zwjcgo','/uploads/2026/08/1785908764804-zwjcgo.jpg','image','image/jpeg',117767,NULL,NULL,'product','','',0,'2026-08-05 05:46:05',NULL),(21,'hp-eq-zh','/uploads/2026/08/hp-eq-zh.mp4','video','video/mp4',2826324,NULL,NULL,'video','','',0,'2026-08-05 06:24:36',NULL),(22,'1785912222484-3o5j86','/uploads/2026/08/1785912222484-3o5j86.jpg','image','image/jpeg',237194,NULL,NULL,'product','','',0,'2026-08-05 06:43:42',NULL),(23,'1785912258949-n315le','/uploads/2026/08/1785912258949-n315le.jpg','image','image/jpeg',160471,NULL,NULL,'product','','',0,'2026-08-05 06:44:19',NULL),(24,'x8-video-1','/uploads/2026/08/x8-video-1.mp4','video','video/mp4',1754742,NULL,NULL,'video','','',0,'2026-08-05 07:43:25',NULL),(25,'x8-video-2','/uploads/2026/08/x8-video-2.mp4','video','video/mp4',1968687,NULL,NULL,'video','','',0,'2026-08-05 07:43:54',NULL),(26,'x8-video-3','/uploads/2026/08/x8-video-3.mp4','video','video/mp4',4306715,NULL,NULL,'video','','',0,'2026-08-05 07:44:27',NULL),(27,'x8-video-4','/uploads/2026/08/x8-video-4.mp4','video','video/mp4',417928,NULL,NULL,'video','','',0,'2026-08-05 07:44:53',NULL),(28,'1785922316964-4a6bac','/uploads/2026/08/1785922316964-4a6bac.jpg','image','image/jpeg',227550,NULL,NULL,'product','','',0,'2026-08-05 09:31:57',NULL),(29,'1785922497129-k8y5rm','/uploads/2026/08/1785922497129-k8y5rm.jpg','image','image/jpeg',251823,NULL,NULL,'product','','',0,'2026-08-05 09:34:57',NULL),(30,'x8-check','/uploads/2026/08/x8-check.mp4','video','video/mp4',626520,NULL,NULL,'video','','',0,'2026-08-05 09:38:39',NULL),(31,'x8-autosave','/uploads/2026/08/x8-autosave.mp4','video','video/mp4',1317955,NULL,NULL,'video','','',0,'2026-08-05 09:45:06',NULL),(32,'1786000062055-73g7r3','/uploads/2026/08/1786000062055-73g7r3.jpg','image','i
/*!40000 ALTER TABLE `www_media` ENABLE KEYS */;
-- ------------------------------------------------------------
-- 表：www_media_tag_map
-- ------------------------------------------------------------
CREATE TABLE `www_media_tag_map` (
`media_id` bigint unsigned NOT NULL,
`tag_id` bigint unsigned NOT NULL,
PRIMARY KEY (`media_id`,`tag_id`),
KEY `idx_tag` (`tag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='素材-标签关联';
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40000 ALTER TABLE `www_media_tag_map` DISABLE KEYS */;
INSERT INTO `www_media_tag_map` (`media_id`, `tag_id`) VALUES (2,1),(18,1),(19,1),(20,1),(22,1),(23,1),(28,1),(29,1),(32,1),(33,1),(34,1),(35,1),(36,1),(38,1),(39,1),(40,1),(44,1),(45,1),(46,1),(47,1),(4,2),(4,3),(38,3),(39,3),(40,3),(41,3),(42,3),(47,3),(48,3),(50,3),(51,3),(17,4),(18,4),(19,4),(20,4),(21,4),(22,4),(23,4),(24,4),(25,4),(26,4),(27,4),(28,4),(29,4),(30,4),(31,4),(32,4),(33,4),(34,4),(35,4),(36,4),(17,5),(21,5),(24,5),(25,5),(26,5),(27,5),(30,5),(31,5),(41,5),(42,5),(48,5),(51,5),(52,6),(53,6);
/*!40000 ALTER TABLE `www_media_tag_map` ENABLE KEYS */;
-- ------------------------------------------------------------
-- 表：www_media_tags
-- ------------------------------------------------------------
CREATE TABLE `www_media_tags` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`tag_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '标签名',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_tag_name` (`tag_name`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='素材标签';
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40000 ALTER TABLE `www_media_tags` DISABLE KEYS */;
INSERT INTO `www_media_tags` (`id`, `tag_name`) VALUES (4,'x8'),(3,'x9'),(1,'产品图'),(6,'关于我们'),(5,'视频'),(2,'首页');
/*!40000 ALTER TABLE `www_media_tags` ENABLE KEYS */;
-- ------------------------------------------------------------
-- 表：www_nav_appearance
-- ------------------------------------------------------------
CREATE TABLE `www_nav_appearance` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`homepage_style` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'transparent' COMMENT '首页导航风格: transparent / glass',
`non_homepage_style` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'transparent' COMMENT '非首页导航风格: transparent / glass',
`updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='导航栏外观配置（单行）';
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40000 ALTER TABLE `www_nav_appearance` DISABLE KEYS */;
INSERT INTO `www_nav_appearance` (`id`, `homepage_style`, `non_homepage_style`, `updated_at`) VALUES (1,'blur','solid','2026-08-03 16:11:24');
/*!40000 ALTER TABLE `www_nav_appearance` ENABLE KEYS */;
-- ------------------------------------------------------------
-- 表：www_nav_items
-- ------------------------------------------------------------
CREATE TABLE `www_nav_items` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`name_zh` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '入口名称（中文）',
`name_en` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '入口名称（英文）',
`link` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '链接地址（站内路由或外部 URL）',
`is_visible` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否显示',
`sort_order` int NOT NULL DEFAULT '0' COMMENT '排列顺序',
`display_mode` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'text' COMMENT '显示形式: text / icon_text / image / image_text',
`icon_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '图标名（display_mode 含 icon 时）',
`image_url` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '图片路径（display_mode 含 image 时）',
`open_new_tab` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否新窗口打开',
`created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='导航栏入口';
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40000 ALTER TABLE `www_nav_items` DISABLE KEYS */;
INSERT INTO `www_nav_items` (`id`, `name_zh`, `name_en`, `link`, `is_visible`, `sort_order`, `display_mode`, `icon_name`, `image_url`, `open_new_tab`, `created_at`, `updated_at`) VALUES (1,'产品','Products','/products',1,1,'text','','',0,'2026-07-31 13:16:53','2026-07-31 13:16:53'),(2,'新闻','News','/news',1,2,'text','','',0,'2026-07-31 13:16:53','2026-07-31 13:16:53'),(3,'关于我们','About','/about',1,3,'text','','',0,'2026-07-31 13:16:53','2026-07-31 13:16:53'),(4,'技术支持','Support','/support',1,4,'text','','',0,'2026-07-31 13:16:53','2026-07-31 13:16:53');
/*!40000 ALTER TABLE `www_nav_items` ENABLE KEYS */;
-- ------------------------------------------------------------
-- 表：www_news_articles
-- ------------------------------------------------------------
CREATE TABLE `www_news_articles` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`title_zh` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '文章标题（中文）',
`title_en` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '文章标题（英文）',
`slug` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'URL 路径标识，如 new-product-launch',
`summary_zh` varchar(300) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '文章摘要（中文，≤100字）',
`summary_en` varchar(300) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '文章摘要（英文）',
`cover_url` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '封面图路径（16:9）',
`content_zh` mediumtext COLLATE utf8mb4_unicode_ci COMMENT '正文内容（中文，富文本）',
`content_en` mediumtext COLLATE utf8mb4_unicode_ci COMMENT '正文内容（英文，富文本）',
`status` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'draft' COMMENT '发布状态: draft / published / offline',
`published_at` datetime DEFAULT NULL COMMENT '发布时间（可为未来时间，定时发布）',
`created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `uk_slug` (`slug`),
KEY `idx_status` (`status`,`published_at`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='新闻文章';
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40000 ALTER TABLE `www_news_articles` DISABLE KEYS */;
INSERT INTO `www_news_articles` (`id`, `title_zh`, `title_en`, `slug`, `summary_zh`, `summary_en`, `cover_url`, `content_zh`, `content_en`, `status`, `published_at`, `created_at`, `updated_at`) VALUES (1,'乐笙 X9 测试固件 V2.0.0.8 已发布','Luxsin Launches New Flagship DAC','new-x9-betaversion','全新 DMP-A8 旗舰解码播放器正式发布','The all-new DMP-A8 flagship DAC player is officially released','/uploads/2026/08/1786329167363-id3123.jpg','<p>1、交叉馈送新增自定义参数功能:交叉馈送&gt;自定义。</p><p>2、听力补偿校准扩展至10个频段，提供更细致的个性化补偿。</p><p>3、修复进行听力补偿测试时，设备可能自动返回首页的问题。</p><p>4、遥控器自定义按键新增“切换至上一个输出”选项:通用设置&gt;按键设置&gt;遥控器。</p><p>5、修复遥控器自定义按键设置无法保存的问题。</p><p>6、异常日志保存，在支持USB 2.0且已格式化为FAT32的U盘根目录，新建名为luxsinLog的文 件夹(区分大小 &nbsp; &nbsp; &nbsp; 写)。将U盘插入X8/X9的USB-A接口;设备出现异常时，日志将保存至该文件夹。请将日志文件提供给support团队，以便我们更快定位问题。</p>','<p>The new DMP-A8 features a flagship DAC chip supporting 768kHz/32bit audio.</p>','published','2026-08-01 08:00:00','2026-08-03 08:59:30','2026-08-10 10:28:33'),(2,'乐笙 X8 测试固件 V1.0.0.29 已发布','DMP-X9 Firmware Update 2.0','new-x8-betaversion','固件 2.0 带来全新 EQ 界面与稳定性提升','Firmware 2.0 brings new EQ interface and stability improvements','/uploads/2026/08/1786004230113-5t5xi1.jpg','<ol><li>新增UAC1.0支持:音频设置&gt;UAC版本。</li><li>温度VU表新增华氏温度单位:通用设置&gt;温度单位。</li><li>PEQ配置文件支持重新排序。</li><li>修复重命名PEQ配置文件时，音乐可能停止播放的问题。</li><li>遥控器自定义按键新增“切换至上一个输出”选项:通用设置&gt;按键设置&gt;遥控器。</li><li>修复遥控器自定义按键设置无法保存的问题。</li><li>修复连接Trigger后，屏幕无法按设定自动熄灭的问题。</li><li>修复设备从休眠唤醒后氛围灯未点亮的问题。</li><li>异常日志保存，在支持USB2.0且已格式化为FAT32的U盘根目录，新建名为luxsinLog的文件夹(区分大小写)。将U盘插入X8/X9的USB-A接口;设备出现异常时，日志将保存至该文件夹。请将日志文件提供给support团队，以便我们更快定位问题。</li></ol>','<p>Firmware 2.0 is now available with a new EQ interface.</p>','published','2026-07-28 08:00:00','2026-08-03 08:59:30','2026-08-10 10:28:46');
/*!40000 ALTER TABLE `www_news_articles` ENABLE KEYS */;
-- ------------------------------------------------------------
-- 表：www_news_list_settings
-- ------------------------------------------------------------
CREATE TABLE `www_news_list_settings` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`hero_title_zh` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '新闻中心' COMMENT 'Page Hero 标题（中文）',
`hero_title_en` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'News' COMMENT 'Page Hero 标题（英文）',
`hero_subtitle_zh` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '获取乐笙最新资讯与行业动态' COMMENT '副标题（中文）',
`hero_subtitle_en` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Get the latest Luxsin news and industry insights' COMMENT '副标题（英文）',
`hero_bg_url` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Page Hero 背景图',
`page_size` int NOT NULL DEFAULT '9' COMMENT '每页显示数量',
`pagination_mode` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'paginator' COMMENT '分页方式: paginator / load_more',
`updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='新闻列表页配置（单行）';
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40000 ALTER TABLE `www_news_list_settings` DISABLE KEYS */;
INSERT INTO `www_news_list_settings` (`id`, `hero_title_zh`, `hero_title_en`, `hero_subtitle_zh`, `hero_subtitle_en`, `hero_bg_url`, `page_size`, `pagination_mode`, `updated_at`) VALUES (1,'新闻中心','News','获取乐笙最新资讯与行业动态','Get the latest Luxsin news and industry insights','/uploads/2026/08/1786355142479-7up2o7.jpg',9,'paginator','2026-08-10 09:46:18');
/*!40000 ALTER TABLE `www_news_list_settings` ENABLE KEYS */;
-- ------------------------------------------------------------
-- 表：www_news_recommendations
-- ------------------------------------------------------------
CREATE TABLE `www_news_recommendations` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`article_id` bigint unsigned NOT NULL COMMENT '文章 ID',
`recommended_id` bigint unsigned NOT NULL COMMENT '推荐文章 ID',
`sort_order` int NOT NULL DEFAULT '0' COMMENT '推荐排序',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_article_recommended` (`article_id`,`recommended_id`),
KEY `idx_article` (`article_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='文章手动推荐关联';
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40000 ALTER TABLE `www_news_recommendations` DISABLE KEYS */;
INSERT INTO `www_news_recommendations` (`id`, `article_id`, `recommended_id`, `sort_order`) VALUES (1,1,2,1),(2,1,3,2);
/*!40000 ALTER TABLE `www_news_recommendations` ENABLE KEYS */;
-- ------------------------------------------------------------
-- 表：www_page_seo
-- ------------------------------------------------------------
CREATE TABLE `www_page_seo` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`page_type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '页面类型: home / products / product_detail / news / news_detail / about / support',
`entity_id` bigint unsigned DEFAULT NULL COMMENT '关联实体 ID（产品 ID 或文章 ID，通用页面时为 NULL）',
`meta_title` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '自定义 <title>（空则自动生成）',
`meta_description` varchar(160) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Meta Description（空则继承全局默认）',
`meta_keywords` varchar(300) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Meta Keywords（空则继承全局默认）',
`og_image_url` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'OG 图片（空则继承全局默认）',
`updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `uk_page_entity` (`page_type`,`entity_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='页面级 SEO 配置';
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40000 ALTER TABLE `www_page_seo` DISABLE KEYS */;
INSERT INTO `www_page_seo` (`id`, `page_type`, `entity_id`, `meta_title`, `meta_description`, `meta_keywords`, `og_image_url`, `updated_at`) VALUES (1,'home',NULL,'乐笙 Luxsin - 高保真音频设备官网','乐笙官方首页：高保真音频设备，还原每一个声音细节','乐笙,Luxsin,高保真,音频','','2026-08-03 08:59:30'),(2,'products',NULL,'乐笙产品中心 - 高保真音频设备','探索乐笙全系高保真音频产品','乐笙,Luxsin,产品,DAC','','2026-08-03 08:59:30'),(3,'news',NULL,'乐笙新闻中心 - 最新资讯','获取乐笙最新资讯与行业动态','乐笙,Luxsin,新闻','','2026-08-03 08:59:30');
/*!40000 ALTER TABLE `www_page_seo` ENABLE KEYS */;
-- ------------------------------------------------------------
-- 表：www_product_list_settings
-- ------------------------------------------------------------
CREATE TABLE `www_product_list_settings` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`hero_title_zh` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '产品中心' COMMENT 'Page Hero 标题（中文）',
`hero_title_en` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Products' COMMENT 'Page Hero 标题（英文）',
`hero_subtitle_zh` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '探索高保真音频设备，寻找您的理想之声' COMMENT '副标题（中文）',
`hero_subtitle_en` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Explore Hi-Fi audio devices, find your ideal sound' COMMENT '副标题（英文）',
`hero_overline_zh` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'LUXSIN PRODUCTS' COMMENT 'Overline（中文）',
`hero_overline_en` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'LUXSIN PRODUCTS' COMMENT 'Overline（英文）',
`hero_bg_url` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Page Hero 背景图',
`max_columns` tinyint NOT NULL DEFAULT '3' COMMENT '每行最大产品数: 2 / 3 / 4',
`updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='产品列表页配置（单行）';
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40000 ALTER TABLE `www_product_list_settings` DISABLE KEYS */;
INSERT INTO `www_product_list_settings` (`id`, `hero_title_zh`, `hero_title_en`, `hero_subtitle_zh`, `hero_subtitle_en`, `hero_overline_zh`, `hero_overline_en`, `hero_bg_url`, `max_columns`, `updated_at`) VALUES (1,'产品中心','Products','探索高保真音频设备，寻找您的理想之声','Explore Hi-Fi audio devices, find your ideal sound','LUXSIN PRODUCTS','LUXSIN PRODUCTS','/uploads/2026/08/1785908720802-r0y89v.jpg',3,'2026-08-10 10:29:31');
/*!40000 ALTER TABLE `www_product_list_settings` ENABLE KEYS */;
-- ------------------------------------------------------------
-- 表：www_product_series
-- ------------------------------------------------------------
CREATE TABLE `www_product_series` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`name_zh` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '系列名称（中文）',
`name_en` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '系列名称（英文）',
`overline` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '系列英文名（Overline），如 DMP SERIES',
`subtitle_zh` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '系列副标题（中文）',
`subtitle_en` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '系列副标题（英文）',
`cover_url` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '系列封面图路径',
`sort_order` int NOT NULL DEFAULT '0' COMMENT '排列顺序',
`is_visible` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否显示',
`created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `idx_sort` (`sort_order`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='产品系列';
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40000 ALTER TABLE `www_product_series` DISABLE KEYS */;
INSERT INTO `www_product_series` (`id`, `name_zh`, `name_en`, `overline`, `subtitle_zh`, `subtitle_en`, `cover_url`, `sort_order`, `is_visible`, `created_at`, `updated_at`) VALUES (1,'智能解码耳放一体机','Smart DAC & Headphone Amplifier','','','Flagship desktop digital player','/uploads/2026/07/1785492437173-e08pwh.jpg',1,1,'2026-08-03 08:59:30','2026-08-04 07:34:14');
/*!40000 ALTER TABLE `www_product_series` ENABLE KEYS */;
-- ------------------------------------------------------------
-- 表：www_products
-- ------------------------------------------------------------
CREATE TABLE `www_products` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`series_id` bigint unsigned NOT NULL COMMENT '所属产品系列 ID',
`name_zh` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '产品名称（中文）',
`name_en` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '产品名称（英文）',
`slug` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'URL 路径标识，如 dmp-a8',
`intro_zh` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '产品简介（中文，≤50字）',
`intro_en` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '产品简介（英文）',
`cover_url` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '产品封面图路径（4:3）',
`sort_order` int NOT NULL DEFAULT '0' COMMENT '同系列内排序',
`is_visible` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否显示',
`created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `uk_slug` (`slug`),
KEY `idx_series` (`series_id`,`sort_order`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='产品';
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40000 ALTER TABLE `www_products` DISABLE KEYS */;
INSERT INTO `www_products` (`id`, `series_id`, `name_zh`, `name_en`, `slug`, `intro_zh`, `intro_en`, `cover_url`, `sort_order`, `is_visible`, `created_at`, `updated_at`) VALUES (1,1,'乐笙-X8','Luxsin-X8','luxsin-x8','','','/uploads/2026/07/1785492899133-bmyul9.jpg',1,1,'2026-08-03 08:59:30','2026-08-04 08:33:36'),(2,1,'乐笙-X9','Luxsin-X9','luxsin-x9','','','/uploads/2026/07/1785408018867-wivqq0.jpg',2,1,'2026-08-03 08:59:30','2026-08-04 08:33:25');
/*!40000 ALTER TABLE `www_products` ENABLE KEYS */;
-- ------------------------------------------------------------
-- 表：www_section_blocks
-- ------------------------------------------------------------
CREATE TABLE `www_section_blocks` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`page_type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '所属页面: homepage / product / about / support',
`product_id` bigint unsigned DEFAULT NULL COMMENT '关联产品 ID（page_type=product 时）',
`layout` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '布局类型: hero_split / hero_center / image_text / two_column / feature_grid / spec_showcase / video_showcase / scroll_narrative / cta_banner / spec_table',
`theme` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'light' COMMENT '主题: light / dark',
`overline_color` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Overline 自定义颜色（空=跟随主题默认色）',
`title_color` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '标题自定义颜色（空=跟随主题默认色）',
`body_color` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '副标题/正文自定义颜色（空=跟随主题默认色）',
`bg_type` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'color' COMMENT '背景类型: color / image / video',
`bg_value` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '背景值（颜色值 或 素材路径）',
`overlay_enabled` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否启用遮罩层',
`overlay_opacity` decimal(3,2) NOT NULL DEFAULT '0.00' COMMENT '遮罩透明度 0~1',
`overline_zh` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Overline 文本（中文）',
`overline_en` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Overline 文本（英文）',
`title_zh` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '标题（中文）',
`title_en` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '标题（英文）',
`subtitle_zh` varchar(300) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '副标题（中文）',
`subtitle_en` varchar(300) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '副标题（英文）',
`content_zh` text COLLATE utf8mb4_unicode_ci COMMENT '正文内容（中文，富文本）',
`content_en` text COLLATE utf8mb4_unicode_ci COMMENT '正文内容（英文，富文本）',
`cta_primary_zh` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '主 CTA 文案（中文）',
`cta_primary_en` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '主 CTA 文案（英文）',
`cta_primary_url` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '主 CTA 链接',
`cta_secondary_zh` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '次 CTA 文案（中文）',
`cta_secondary_en` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '次 CTA 文案（英文）',
`cta_secondary_url` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '次 CTA 链接',
`media_url_zh` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '图片/媒体路径（中文）',
`media_url_en` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '图片/媒体路径（英文）',
`video_url` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '视频地址（Video Showcase 专用）',
`config` json DEFAULT NULL COMMENT '布局扩展配置（JSON），Feature Grid / Steps / Data Metrics 等',
`is_visible` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否显示',
`sort_order` int NOT NULL DEFAULT '0' COMMENT '排序（同页面内）',
`created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `idx_page_type` (`page_type`,`sort_order`),
KEY `idx_product_id` (`product_id`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='页面 Section 区块';
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40000 ALTER TABLE `www_section_blocks` DISABLE KEYS */;
INSERT INTO `www_section_blocks` (`id`, `page_type`, `product_id`, `layout`, `theme`, `overline_color`, `title_color`, `body_color`, `bg_type`, `bg_value`, `overlay_enabled`, `overlay_opacity`, `overline_zh`, `overline_en`, `title_zh`, `title_en`, `subtitle_zh`, `subtitle_en`, `content_zh`, `content_en`, `cta_primary_zh`, `cta_primary_en`, `cta_primary_url`, `cta_secondary_zh`, `cta_secondary_en`, `cta_secondary_url`, `media_url_zh`, `media_url_en`, `video_url`, `config`, `is_visible`, `sort_order`, `created_at`, `updated_at`) VALUES (2,'home',NULL,'hero_split','dark','','','','video','/uploads/2026/07/1785409251393-80ro00.mp4',0,0.00,'乐笙 X9','Luxsin X9','聆听，本该如此','Listening, Reimagined','高保真音频设备，还原每一个声音细节','High-fidelity audio that reveals every detail','',NULL,'探索产品','Explore','/products/luxsin-x9','','','','','','http://localhost:9527/uploads/2026/07/1785409251393-80ro00.mp4','{\"bg_fit\": \"cover\", \"text_position\": \"top_center\", \"width_percent\": 100}',1,0,'2026-07-31 13:16:54','2026-08-04 10:43:02'),(3,'home',NULL,'stats','light','','','','color','',0,0.00,'实力数据','BY THE NUMBERS','用数字说话','Numbers That Speak','','',NULL,NULL,'','','','','','','','','','{\"stats\": [{\"unit\": \"dB\", \"value\": \"129.5\", \"label_en\": \"SNR\", \"label_zh\": \"信噪比\"}, {\"unit\": \"kHz\", \"value\": \"768\", \"label_en\": \"Max Sample Rate\", \"label_zh\": \"最高采样率\"}, {\"unit\": \"bit\", \"value\": \"32\", \"label_en\": \"Bit Depth\", \"label_zh\": \"位深\"}, {\"unit\": \"英寸\", \"value\": \"4\", \"label_en\": \"Touchscreen\", \"label_zh\": \"触控屏\"}]}',0,3,'2026-07-31 13:16:54','2026-08-04 09:26:08'),(4,'home',NULL,'feature_grid','light','','','','color','',0,0.00,'核心特性','KEY FEATURES','为极致听感而生','Born for Ultimate Sound','','',NULL,NULL,'','','','','','','','','','{\"features\": [{\"icon\": \"🎵\", \"desc_en\": \"Top-tier DAC chip for authentic sound\", \"desc_zh\": \"顶级解码芯片，还原真实声音\", \"title_en\": \"Flagship DAC\", \"title_zh\": \"旗舰解码\"}, {\"icon\": \"🔌\", \"desc_en\": \"USB / Coaxial / IIS inputs\", \"desc_zh\": \"USB / 同轴 / IIS 多种输入\", \"title_en\": \"Rich I/O\", \"title_zh\": \"丰富接口\"}, {\"icon\": \"📱\", \"desc_en\": \"4-inch touchscreen, intuitive control\", \"desc_zh\": \"4 英寸触控屏，操作直观便捷\", \"title_en\": \"Touch UI\", \"title_zh\": \"触控交互\"}]}',0,4,'2026-07-31 13:16:54','2026-08-04 09:26:08'),(5,'home',NULL,'hero_split','dark','#030303','#030303','#211E1E','video','/uploads/2026/08/1785750535177-z1l7zh.mp4',0,0.00,'乐笙 X8','Luxsin X8','智能解码耳放','Intelligent DAC & HP AMP','','',NULL,NULL,'探索更多','Explore','/products/luxsin-x8','','','','','','/uploads/2026/07/1785409251393-80ro00.mp4','{\"bg_fit\": \"cover\", \"padding_y\": null, \"min_height\": null, \"mosaic_items\": [{\"type\": \"image\", \"media_en\": \"\", \"media_zh\": \"\"}, {\"type\": \"image\", \"media_en\": \"\", \"media_zh\": \"\"}, {\"type\": \"image\", \"media_en\": \"\", \"media_zh\": \"\"}, {\"type\": \"image\", \"media_en\": \"\", \"media_zh\": \"\"}], \"border_radius\": 0, \"text_position\": \"top_center\", \"width_percent\": 100, \"media_position\": \"left\", \"mosaic_pattern\": \"big_3\", \"container_width\": \"1200\", \"title_font_size\": null}',1,1,'2026-07-31 17:20:38','2026-08-06 07:02:41'),(6,'product_detail',1,'hero_split','light','','#F7F3F3','','image','/uploads/2026/08/1786000062055-73g7r3.jpg',0,0.00,'','','乐笙X8 ｜ 智能解码耳放','Intelligent DAC & HP AMP','','',NULL,NULL,'','','','','','','','','','{\"bg_fit\": \"cover\", \"margin_y\": null, \"padding_y\": 0, \"min_height\": 720, \"split_ratio\": 50, \"mosaic_items\": [{\"type\": \"image\", \"media_en\": \"\", \"media_zh\": \"\"}, {\"type\": \"image\", \"media_en\": \"\", \"media_zh\": \"\"}, {\"type\": \"image\", \"media_en\": \"\", \"media_zh\": \"\"}, {\"type\": \"image\", \"media_en\": \"\", \"media_zh\": \"\"}], \"border_radius\": 30, \"text
/*!40000 ALTER TABLE `www_section_blocks` ENABLE KEYS */;
-- ------------------------------------------------------------
-- 表：www_seo_defaults
-- ------------------------------------------------------------
CREATE TABLE `www_seo_defaults` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`meta_description` varchar(160) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '默认 Meta Description',
`meta_keywords` varchar(300) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '默认 Meta Keywords（逗号分隔）',
`og_image_url` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '默认 OG 图片（1200×630px）',
`updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='全站 SEO 默认值（单行）';
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40000 ALTER TABLE `www_seo_defaults` DISABLE KEYS */;
/*!40000 ALTER TABLE `www_seo_defaults` ENABLE KEYS */;
-- ------------------------------------------------------------
-- 表：www_site_settings
-- ------------------------------------------------------------
CREATE TABLE `www_site_settings` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`site_title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '站点标题，全站 <title> 后缀',
`favicon_url` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Favicon 素材路径',
`logo_dark_url` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Logo 深色版（浅色区块上用）',
`logo_light_url` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Logo 浅色版（深色区块上用）',
`enabled_locales` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'zh,en' COMMENT '启用的语言（逗号分隔）：zh,en',
`updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='站点基础信息（单行）';
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40000 ALTER TABLE `www_site_settings` DISABLE KEYS */;
INSERT INTO `www_site_settings` (`id`, `site_title`, `favicon_url`, `logo_dark_url`, `logo_light_url`, `enabled_locales`, `updated_at`) VALUES (1,'乐笙 Luxsin','/uploads/icon/favicon.svg','/uploads/2026/07/1785480939443-x8vj9w.svg','','zh','2026-08-10 10:48:05');
/*!40000 ALTER TABLE `www_site_settings` ENABLE KEYS */;
-- ------------------------------------------------------------
-- 表：www_social_links
-- ------------------------------------------------------------
CREATE TABLE `www_social_links` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`platform` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '平台标识: wechat / weibo / bilibili / youtube / facebook / instagram',
`url` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '主页链接（微信公众号时为空）',
`qrcode_url` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '二维码图片路径（仅微信用）',
`sort_order` int NOT NULL DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_platform` (`platform`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='社交媒体链接';
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40000 ALTER TABLE `www_social_links` DISABLE KEYS */;
/*!40000 ALTER TABLE `www_social_links` ENABLE KEYS */;
-- ------------------------------------------------------------
-- 表：www_spec_groups
-- ------------------------------------------------------------
CREATE TABLE `www_spec_groups` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`section_block_id` bigint unsigned NOT NULL COMMENT '所属 Section 区块 ID',
`title_zh` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '分组标题（中文）',
`title_en` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '分组标题（英文）',
`sort_order` int NOT NULL DEFAULT '0' COMMENT '分组排序',
`default_visible` int NOT NULL DEFAULT '5' COMMENT '收起状态下默认显示项数',
PRIMARY KEY (`id`),
KEY `idx_section_block` (`section_block_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='产品参数规格分组';
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40000 ALTER TABLE `www_spec_groups` DISABLE KEYS */;
INSERT INTO `www_spec_groups` (`id`, `section_block_id`, `title_zh`, `title_en`, `sort_order`, `default_visible`) VALUES (1,28,'基本规格','Basic Parameters',0,5),(2,28,'输入 / 输出','I / O',1,5),(3,28,'XLR 输出音频特性','XLR Output Audio Characteristics',2,5),(4,28,'RCA 输出音频特性','RCA Output Audio Characteristics',3,5),(5,28,'平衡耳机输出性能参数（4.4mm/XLR4输出）','Performance and Parameters of Balanced Headphone Output（4.4mm/XLR4）',4,5),(6,28,'单端耳机输出性能参数 （6.35mm输出）','Performance and Parameters of Unbalanced Headphone Output（6.35mm）',5,5),(8,43,'基本规格','Basic Parameters',0,5),(9,43,'音频参数','Audio Parameters',0,5),(10,43,'输入','Input',0,5),(11,43,'输出','Output',0,5);
/*!40000 ALTER TABLE `www_spec_groups` ENABLE KEYS */;
-- ------------------------------------------------------------
-- 表：www_spec_items
-- ------------------------------------------------------------
CREATE TABLE `www_spec_items` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`spec_group_id` bigint unsigned NOT NULL COMMENT '所属参数分组 ID',
`name_zh` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '参数名称（中文）',
`name_en` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '参数名称（英文）',
`value_zh` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '参数值（中文）',
`value_en` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '参数值（英文）',
`sort_order` int NOT NULL DEFAULT '0' COMMENT '参数排序',
PRIMARY KEY (`id`),
KEY `idx_spec_group` (`spec_group_id`)
) ENGINE=InnoDB AUTO_INCREMENT=85 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='产品参数规格项';
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40000 ALTER TABLE `www_spec_items` DISABLE KEYS */;
INSERT INTO `www_spec_items` (`id`, `spec_group_id`, `name_zh`, `name_en`, `value_zh`, `value_en`, `sort_order`) VALUES (1,1,'型号','Model','Luxsin X8','Luxsin X8',0),(2,1,'尺寸','Dimensions','236mm (长) × 236.8mm (宽) × 64mm (高)','236mm (L) × 236.8mm (W) × 64mm (H)',1),(3,1,'重量','Weight','2750g','2750g',2),(4,1,'电源输入','Input Power','AC 100–120V/220–240V~50/60Hz','AC 100-120V/220-240V~50/60Hz',3),(5,1,'屏幕','Display','4英寸 LCD（480×960）触摸屏','4\" LCD (480*960) Touchscreen',4),(6,1,'解码','DAC','Cirrus Logic CS43198 × 8','Cirrus Logic CS43198 × 8',5),(7,1,'内部电源','Power Supply','超低底噪可调电压线性电源','Ultra-low-noise, voltage-adjustable Linear Power Supply',6),(8,1,'WiFi','WiFi','支持2.4G/5G双频WiFi','Wi-Fi 2.4GHz / 5GHz',7),(9,1,'蓝牙接收','Bluetooth','Qualcomm SXW5125 (BT 5.1)','Qualcomm SXW5125 (BT 5.1)',8),(10,1,'控制方式','Control Methods','触控屏, 移动设备 APP (Android/iOS), 电脑浏览器, 红外遥控器(选购配件)','Touchscreen, Mobile APP (Android/iOS), Web Browser, IR Remote(Optional)',9),(11,1,'额定功率','Rated Power','25W','25W',10),(12,1,'包装清单','Packing List','电源线×1，USB-B线×1, 3.5mm转6.35mm适配器×1','Power Cable ×1, USB-B cable ×1, 3.5mm to 6.35mm adapter ×1',11),(13,2,'USB-A 输入','USB-A Input','用于本地固件更新','For local firmware update',0),(14,2,'USB-B 输入','USB-B Input','最高支持 PCM 768kHz/32bit; DSD512(Native)','Up to PCM 768kHz/32bit; DSD512(Native)',1),(15,2,'USB-C 输入','USB-C Input','最高支持 PCM 768kHz/32bit; DSD512(Native)','Up to PCM 768kHz/32bit; DSD512(Native)',2),(16,2,'IIS 输入','IIS Input','最高支持 PCM 768kHz/32bit; DSD512(Native)','Up to PCM 768kHz/32bit; DSD512(Native)',3),(17,2,'同轴输入','Coaxial Input','最高支持 PCM 192kHz/24bit','Up to PCM 192kHz/24bit',4),(18,2,'光纤输入','Optical Input','最高支持 PCM 192kHz/24bit','Up to PCM 192kHz/24bit',5),(19,2,'TRIGGER IN','TRIGGER IN','标准3.5mm耳机插座','Standard 3.5mm headphone jack',6),(20,2,'TRIGGER OUT','TRIGGER OUT','标准3.5mm耳机插座','Standard 3.5mm headphone jack',7),(21,2,'模拟输出接口','Analog Output','RCA','RCA',8),(22,2,'数字输出接口','Balanced Output','XLR','XLR',9),(23,2,'耳机输出接口','Headphone Output','6.35mm（非平衡），4.4mm（平衡），4 pin XLR（平衡）','6.35mm (Unbalanced), 4.4mm (Balanced), 4 pin XLR (Balanced)',10),(24,3,'信噪比','SNR','≥129.5dB','≥129.5dB',0),(25,3,'总谐波失真','THD+N','＜−121.8dB @不加权','< -121.8dB @ unweighted',1),(26,3,'声道分离度','Crosstalk','≥133dB (1kHz@200kΩ)','≥133dB (1kHz@200kΩ)',2),(27,3,'底噪','Noise Floor','＜1.1uVrms','< 1.1uVrms',3),(28,3,'线路输出电平','Output Level','4.2Vrms (1kHz@200kΩ)','4.2Vrms (1kHz@200kΩ)',4),(29,4,'信噪比','SNR','≥124.5dB','≥124.5dB',0),(30,4,'总谐波失真','THD+N','＜−120dB @不加权','< -120dB @ unweighted',1),(31,4,'声道分离度','Crosstalk','≥125dB (1kHz@100kΩ)','≥125dB (1kHz@100kΩ)',2),(32,4,'底噪','Noise Floor','＜1.3uVrms','< 1.3uVrms',3),(33,4,'线路输出电平','Output Level','2.1Vrms (1kHz@100kΩ)','2.1Vrms (1kHz@100kΩ)',4),(34,5,'高增益','High Gain','L+R≥4840mW+4840mW（16Ω, THD+N＜1%）','L+R≥4840mW+4840mW (16Ω, THD+N < 1%)',0),(35,5,'输出阻抗','Output Impedance','＜1Ω','< 1Ω',1),(36,5,'总谐波失真','THD+N','＜−117dB (1kHz/0dB@32Ω)','< -117dB (1kHz / 0dB @ 32Ω)',2),(37,5,'信噪比','SNR','≥123dB','≥123dB',3),(38,5,'声道分离度','Crosstalk','≥119dB (1kHz@32Ω)','≥119dB (1kHz @ 32Ω)',4),(39,6,'高增益','High Gain','L+R≥2900mW+2900mW（16Ω，THD+N＜1%）','L+R≥2900mW+2900mW (16Ω, THD+N < 1%)',0),(40,6,'输出阻抗','Output Impedance','＜1Ω','< 1Ω',1),(41,6,'总谐波失真','THD+N','＜−115dB (1kHz/0dB@32Ω)','< -115dB (1kHz/0dB@32Ω)',2),(42,6,'信噪比','SNR','≥121dB','≥121dB',3),(43,8,'型号','Model','X9','X9',0),(44,8,'显示屏','Display','4 英寸 TFT 全贴合触摸屏（960×400）','4-inch TFT Fully Lamina
/*!40000 ALTER TABLE `www_spec_items` ENABLE KEYS */;
-- ------------------------------------------------------------
-- 表：www_support_settings
-- ------------------------------------------------------------
CREATE TABLE `www_support_settings` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`hero_title_zh` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '技术支持' COMMENT 'Hero 标题（中文）',
`hero_title_en` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Support' COMMENT 'Hero 标题（英文）',
`hero_subtitle_zh` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Hero 副标题（中文）',
`hero_subtitle_en` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Hero 副标题（英文）',
`hero_bg_url` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Hero 背景图',
`s1_faq_categories` json DEFAULT NULL COMMENT 'FAQ 分类 JSON: [{icon, name_zh, name_en, desc_zh, desc_en}]',
`s2_downloads` json DEFAULT NULL COMMENT '下载资源 JSON: [{name_zh, name_en, file_url, version}]',
`s3_contact` json DEFAULT NULL COMMENT '联系信息 JSON: [{title_zh, title_en, info_zh, info_en, image_url}]',
`s4_cta_zh` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'CTA 按钮（中文）',
`s4_cta_en` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'CTA 按钮（英文）',
`s4_cta_url` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'CTA 链接',
`updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='技术支持页面配置（单行）';
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40000 ALTER TABLE `www_support_settings` DISABLE KEYS */;
INSERT INTO `www_support_settings` (`id`, `hero_title_zh`, `hero_title_en`, `hero_subtitle_zh`, `hero_subtitle_en`, `hero_bg_url`, `s1_faq_categories`, `s2_downloads`, `s3_contact`, `s4_cta_zh`, `s4_cta_en`, `s4_cta_url`, `updated_at`) VALUES (1,'技术支持','Support','我们随时为您提供帮助','We are here to help','/uploads/2026/08/1786355142479-7up2o7.jpg','[{\"items\": [], \"title_en\": \"Usage\", \"title_zh\": \"产品使用\"}, {\"items\": [], \"title_en\": \"Firmware\", \"title_zh\": \"固件升级\"}]','[{\"name_en\": \"Luxsin X9-v2.0.0.8\", \"name_zh\": \"X9 固件 2.0.0.8\", \"file_url\": \"http://source.luxsin.net/ota/202607/x9/a98ac/LUXSIN.PKG\", \"file_size\": \"6.3MB\"}, {\"name_en\": \"Luxsin X8-v1.0.0.29\", \"name_zh\": \"X8 固件 1.0.0.29\", \"file_url\": \"http://am.luxsinaudio.com/ota/202607/x8/d8f1d/LUXSIN_X8.PKG\", \"file_size\": \"6.8MB\"}]','[{\"label_en\": \"Official Email\", \"label_zh\": \"官方邮箱\", \"value_en\": \"support@luxsinaudio.com\", \"value_zh\": \"support@luxsinaudio.com\"}]','联系我们','Contact Us','/contact','2026-08-10 09:45:55');
/*!40000 ALTER TABLE `www_support_settings` ENABLE KEYS */;
SET FOREIGN_KEY_CHECKS=1;
Reference in New Issue Copy Permalink