51 lines
3.1 KiB
SQL
51 lines
3.1 KiB
SQL
SET NAMES utf8mb4;
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
|
|
|
|
DROP TABLE IF EXISTS `edit_project_material`;
|
|
CREATE TABLE `edit_project_material` (
|
|
`id` int(8) NOT NULL AUTO_INCREMENT,
|
|
`project_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '项目id',
|
|
`material_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '素材id',
|
|
`create_date` date NULL DEFAULT NULL COMMENT '创建日期',
|
|
`create_user` int(4) NULL DEFAULT NULL COMMENT '创建人',
|
|
`is_delete` tinyint(1) NULL DEFAULT 0 COMMENT '是否删除',
|
|
`material_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '素材类型用于区分',
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
|
|
|
|
DROP TABLE IF EXISTS `edit_project_watermark`;
|
|
CREATE TABLE `edit_project_watermark` (
|
|
`id` int(8) NOT NULL AUTO_INCREMENT,
|
|
`project_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '项目id',
|
|
`material_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '素材id',
|
|
`create_date` date NULL DEFAULT NULL COMMENT '创建日期',
|
|
`create_user` int(4) NULL DEFAULT NULL COMMENT '创建人',
|
|
`is_delete` tinyint(1) NULL DEFAULT 0 COMMENT '是否删除',
|
|
`material_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '素材类型用于区分',
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
|
|
|
|
DROP TABLE IF EXISTS `edit_project`;
|
|
CREATE TABLE `edit_project` (
|
|
`id` int(8) NOT NULL AUTO_INCREMENT,
|
|
`project_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '项目id',
|
|
`create_date` date NULL DEFAULT NULL COMMENT '创建日期',
|
|
`create_user` int(4) NULL DEFAULT NULL COMMENT '创建人',
|
|
`is_delete` tinyint(1) NULL DEFAULT 0 COMMENT '是否删除',
|
|
`modified_time` date NULL DEFAULT NULL COMMENT '修改时间',
|
|
`project_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '素材类型用于区分',
|
|
`cover_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图片链接',
|
|
`timeline` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
|
|
`title` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题',
|
|
`division` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
|
`description` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
|
`material_id` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '完成后对应的素材ID',
|
|
`status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE = InnoDB AUTO_INCREMENT = 188 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1;
|
|
|
|
|