From 14821e28286d773ad5ff2c13510e39c5eb117daf Mon Sep 17 00:00:00 2001 From: kongzy <kongzy> Date: 星期五, 05 七月 2024 13:46:32 +0800 Subject: [PATCH] update --- exam-admin/src/main/resources/db/migration/V20240531008_resource.sql | 9 ++++++--- 1 files changed, 6 insertions(+), 3 deletions(-) diff --git a/exam-admin/src/main/resources/db/migration/V20240531008_resource.sql b/exam-admin/src/main/resources/db/migration/V20240531008_resource.sql index 129e1dc..6abfb7d 100644 --- a/exam-admin/src/main/resources/db/migration/V20240531008_resource.sql +++ b/exam-admin/src/main/resources/db/migration/V20240531008_resource.sql @@ -8,14 +8,16 @@ `sort` int NOT NULL DEFAULT 1 COMMENT '排序', `category_id` bigint(20) NULL DEFAULT 0 COMMENT '分类ID', `name` varchar(50) NOT NULL COMMENT '资源名称', +`origin_name` varchar(60) NOT NULL COMMENT '文件原始名称', `privatize` tinyint NOT NULL DEFAULT 0 COMMENT '课程公开私有属性(0私有,1公开 默认0)', `company_id` bigint(20) NULL COMMENT '提交公司id', `resource_type` tinyint NOT NULL DEFAULT 1 COMMENT '资源种类(1:视频2:音频;3:文档,默认1)', `media_type` varchar(100) NULL COMMENT '资源类型', `resource_size` bigint(20) NOT NULL COMMENT '资源大小', -`resource_uri` varchar(255) NULL DEFAULT NULL COMMENT '资源地址', +`resource_uri` varchar(200) NULL DEFAULT NULL COMMENT '资源地址(存放第三方地址)', `resource_length` bigint(20) NULL DEFAULT NULL COMMENT '资源时长(秒)', -`video_vid` varchar(50) NULL DEFAULT NULL COMMENT '资源vid', +`resource_path` varchar(120) NULL DEFAULT NULL COMMENT '资源路径', +`md5` varchar(50) NOT NULL COMMENT '文件md5', `doc_page` int NULL DEFAULT 0 COMMENT '资源页数，单位页', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `create_by` varchar(50) NULL DEFAULT NULL COMMENT '创建人', @@ -23,5 +25,6 @@ `update_by` varchar(50) NULL DEFAULT NULL COMMENT '更新人', `remark` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', `version` int NULL DEFAULT 0 COMMENT '乐观锁', -PRIMARY KEY (`id`) USING BTREE +PRIMARY KEY (`id`) USING BTREE, +INDEX `index_md5`(`md5`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '课程资源表' ROW_FORMAT = DYNAMIC; -- Gitblit v1.9.2