forked from Gitlink/microservices
65 lines
5.1 KiB
SQL
65 lines
5.1 KiB
SQL
SET FOREIGN_KEY_CHECKS = 0;
|
||
|
||
ALTER TABLE `ruoyi-gitlink`.`sys_file_info`
|
||
ADD COLUMN `download_count` int(11) NULL DEFAULT 0 COMMENT '下载次数' AFTER `update_time`;
|
||
|
||
CREATE TABLE `ruoyi-gitlink`.`zone_resource`
|
||
(
|
||
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '资源主键',
|
||
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '资源名称',
|
||
`introduction` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '资源介绍',
|
||
`file_ids` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '资源文件Id列表',
|
||
`domain_id` int(11) NOT NULL COMMENT '资源领域Id',
|
||
`type_id` int(11) NOT NULL COMMENT '资源类型Id',
|
||
`sort` int(4) NULL DEFAULT 1 COMMENT '排序',
|
||
`is_homepage` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '是否首页展示（0代表不展示 1代表展示）',
|
||
`zone_id` int(11) NOT NULL COMMENT '专区Id',
|
||
`dept_id` int(11) NOT NULL COMMENT '所属组织Id',
|
||
`del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
|
||
`create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
||
`update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
|
||
`update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB
|
||
CHARACTER SET = utf8mb4
|
||
COLLATE = utf8mb4_general_ci COMMENT = '特色专区资源聚合'
|
||
ROW_FORMAT = Dynamic;
|
||
|
||
CREATE TABLE `ruoyi-gitlink`.`zone_resource_domain`
|
||
(
|
||
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '资源领域主键',
|
||
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '资源领域名称',
|
||
`sort` int(4) NULL DEFAULT 1 COMMENT '排序',
|
||
`dept_id` int(11) NOT NULL COMMENT '所属组织Id',
|
||
`del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
|
||
`create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
||
`update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
|
||
`update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
||
`zone_id` int(11) NOT NULL COMMENT '专区标识',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB
|
||
CHARACTER SET = utf8mb4
|
||
COLLATE = utf8mb4_general_ci COMMENT = '特色专区资源领域'
|
||
ROW_FORMAT = Dynamic;
|
||
|
||
CREATE TABLE `ruoyi-gitlink`.`zone_resource_type`
|
||
(
|
||
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '资源类别主键',
|
||
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '资源类别名称',
|
||
`sort` int(4) NULL DEFAULT 1 COMMENT '排序',
|
||
`dept_id` int(11) NOT NULL COMMENT '所属组织Id',
|
||
`del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
|
||
`create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
|
||
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
||
`update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
|
||
`update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
||
`zone_id` int(11) NOT NULL COMMENT '专区标识',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB
|
||
CHARACTER SET = utf8mb4
|
||
COLLATE = utf8mb4_general_ci COMMENT = '特色专区资源类别'
|
||
ROW_FORMAT = Dynamic;
|
||
|
||
SET FOREIGN_KEY_CHECKS = 1; |