68 lines
51 KiB
SQL
68 lines
51 KiB
SQL
|
|
|||
|
|
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
|||
|
|
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
|||
|
|
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
|||
|
|
/*!50503 SET NAMES utf8mb4 */;
|
|||
|
|
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
|||
|
|
/*!40103 SET TIME_ZONE='+00:00' */;
|
|||
|
|
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
|||
|
|
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
|||
|
|
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
|||
|
|
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
|||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|||
|
|
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 */;
|
|||
|
|
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
|
|||
|
|
|
|||
|
|
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
|||
|
|
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
|||
|
|
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
|||
|
|
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
|||
|
|
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
|||
|
|
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
|||
|
|
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
|||
|
|
|