From f0f00e9ba8a755e4317e029d73b69a92ad9f9df1 Mon Sep 17 00:00:00 2001 From: kongzy <kongzy> Date: 星期六, 14 九月 2024 17:02:41 +0800 Subject: [PATCH] update --- exam-admin/src/main/resources/db/migration/V20240531008_resource.sql | 5 ++--- 1 files changed, 2 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 6abfb7d..90e6c38 100644 --- a/exam-admin/src/main/resources/db/migration/V20240531008_resource.sql +++ b/exam-admin/src/main/resources/db/migration/V20240531008_resource.sql @@ -1,7 +1,6 @@ -- ---------------------------- -- 课程资源表 -- ---------------------------- -drop table if exists `train_exam`.`ex_resource`; CREATE TABLE `train_exam`.`ex_resource` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键' , `status` tinyint NOT NULL DEFAULT 0 COMMENT '账号状态(0正常，1停用，默认0)', @@ -13,9 +12,9 @@ `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_size` bigint(20) NOT NULL DEFAULT 0 COMMENT '资源大小', `resource_uri` varchar(200) NULL DEFAULT NULL COMMENT '资源地址(存放第三方地址)', -`resource_length` bigint(20) NULL DEFAULT NULL COMMENT '资源时长(秒)', +`resource_length` bigint(20) NULL DEFAULT 0 COMMENT '资源时长(秒)', `resource_path` varchar(120) NULL DEFAULT NULL COMMENT '资源路径', `md5` varchar(50) NOT NULL COMMENT '文件md5', `doc_page` int NULL DEFAULT 0 COMMENT '资源页数，单位页', -- Gitblit v1.9.2