eafonyang
45 lines
3.9 KiB
SQL
45 lines
3.9 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_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 */;
|
|
/*!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 */;
|
|
|