admin/db/0810/www_media.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_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','image/jpeg',693720,NULL,NULL,'product','','',0,'2026-08-06 07:07:42',NULL),(33,'1786001460158-hm5pl5','/uploads/2026/08/1786001460158-hm5pl5.jpg','image','image/jpeg',51575,NULL,NULL,'product','','',0,'2026-08-06 07:31:00',NULL),(34,'1786003910986-mfujtg','/uploads/2026/08/1786003910986-mfujtg.jpg','image','image/jpeg',57190,NULL,NULL,'product','','',0,'2026-08-06 08:11:51',NULL),(35,'1786004230113-5t5xi1','/uploads/2026/08/1786004230113-5t5xi1.jpg','image','image/jpeg',96606,NULL,NULL,'product','','',0,'2026-08-06 08:17:10',NULL),(36,'1786004280122-k5cpwx','/uploads/2026/08/1786004280122-k5cpwx.jpg','image','image/jpeg',142579,NULL,NULL,'product','','',0,'2026-08-06 08:18:00',NULL),(37,'1786005075207-vu5f7p','/uploads/2026/08/1786005075207-vu5f7p.jpg','image','image/jpeg',265941,NULL,NULL,'other','','',0,'2026-08-06 08:31:15',NULL),(38,'1786095790004-1q3ue3','/uploads/2026/08/1786095790004-1q3ue3.jpg','image','image/jpeg',63950,NULL,NULL,'product','','',0,'2026-08-07 09:43:10',NULL),(39,'1786096077881-hgeey4','/uploads/2026/08/1786096077881-hgeey4.png','image','image/png',37351,NULL,NULL,'product','','',0,'2026-08-07 09:47:58',NULL),(40,'1786329167363-id3123','/uploads/2026/08/1786329167363-id3123.jpg','image','image/jpeg',87922,NULL,NULL,'product','','',0,'2026-08-10 02:32:47',NULL),(41,'1786341093803-8ogyx4','/uploads/2026/08/1786341093803-8ogyx4.mp4','video','video/mp4',1660354,NULL,NULL,'product','','',0,'2026-08-10 05:51:34',NULL),(42,'1786341106729-2qzs8j','/uploads/2026/08/1786341106729-2qzs8j.mp4','video','video/mp4',2818783,NULL,NULL,'product','','',0,'2026-08-10 05:51:47',NULL),(44,'1786341900765-v4skaa','/uploads/2026/08/1786341900765-v4skaa.jpg','image','image/jpeg',322529,NULL,NULL,'product','','',0,'2026-08-10 06:05:01',NULL),(45,'dsp-en','/uploads/2026/08/dsp-en.jpg','image','image/jpeg',173630,NULL,NULL,'product','','',0,'2026-08-10 06:09:18',NULL),(46,'dsp-zh','/uploads/2026/08/dsp-zh.jpg','image','image/jpeg',158501,NULL,NULL,'product','','',0,'2026-08-10 06:09:41',NULL),(47,'1786343228959-3qv5pa','/uploads/2026/08/1786343228959-3qv5pa.jpg','image','image/jpeg',69130,NULL,NULL,'product','','',0,'2026-08-10 06:27:09',NULL),(48,'1786343612412-ip1rgt','/uploads/2026/08/1786343612412-ip1rgt.mp4','video','video/mp4',389014,NULL,NULL,'product','','',0,'2026-08-10 06:33:32',NULL),(50,'1786344307138-gf6dpu','/uploads/2026/08/1786344307138-gf6dpu.jpg','image','image/jpeg',514173,NULL,NULL,'product','','',0,'2026-08-10 06:45:07',NULL),(51,'tlbc','/uploads/2026/08/tlbc.mp4','video','video/mp4',6695045,NULL,NULL,'product','','',0,'2026-08-10 08:28:16',NULL),(52,'1786354114510-gz5zze','/uploads/2026/08/1786354114510-gz5zze.jpg','image','image/jpeg',518654,NULL,NULL,'banner','','',0,'2026-08-10 09:28:34',NULL),(53,'1786355142479-7up2o7','/uploads/2026/08/1786355142479-7up2o7.jpg','image','image/jpeg',1382738,NULL,NULL,'banner','','',0,'2026-08-10 09:45:42',NULL);
/*!40000 ALTER TABLE `www_media` 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 */;