YzXyh_v3/SERVER/YanZhongXYH/script/sql/File.sql

USE `YanZhongXYH`;

-- ----------------------------
-- Table structure for oss_file_short
-- ----------------------------
DROP TABLE IF EXISTS oss_file_short;
CREATE TABLE oss_file_short
(
    short_url VARCHAR(255) NOT NULL,
    url       VARCHAR(255) NULL DEFAULT NULL,
    PRIMARY KEY (short_url) USING BTREE,
    UNIQUE INDEX short_url_index (short_url) USING BTREE
) ENGINE = InnoDB
  CHARACTER SET = utf8
  COLLATE = utf8_general_ci
  ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for oss_file
-- ----------------------------
DROP TABLE IF EXISTS oss_file;
CREATE TABLE oss_file
(
    id          BIGINT(20)   NOT NULL AUTO_INCREMENT,
    pid         VARCHAR(11)  NULL DEFAULT NULL,
    x_path      VARCHAR(255) NULL DEFAULT NULL,
    x_code      VARCHAR(255) NULL DEFAULT NULL,
    alias       VARCHAR(255) NULL DEFAULT NULL,
    object_id   VARCHAR(255) NULL DEFAULT NULL,
    ico         VARCHAR(10)  NULL DEFAULT NULL,
    f_name      VARCHAR(255) NULL DEFAULT NULL,
    f_type      VARCHAR(10)  NULL DEFAULT NULL,
    f_ext       VARCHAR(10)  NULL DEFAULT NULL,
    f_size      BIGINT(20)   NULL DEFAULT NULL,
    f_group     VARCHAR(255) NULL DEFAULT NULL,
    fs_group    VARCHAR(255) NULL DEFAULT NULL,
    u_name      VARCHAR(255) NULL DEFAULT NULL,
    create_by   VARCHAR(64)       DEFAULT '' COMMENT '创建者',
    create_time DATETIME COMMENT '创建时间',
    update_by   VARCHAR(64)       DEFAULT '' COMMENT '更新者',
    update_time DATETIME COMMENT '更新时间',
    remark      VARCHAR(500)      DEFAULT NULL COMMENT '备注',
    PRIMARY KEY (id) USING BTREE,
    INDEX index_f_type (f_type) USING BTREE,
    INDEX index_f_ext (f_ext) USING BTREE,
    INDEX index_uname (u_name) USING BTREE,
    INDEX index_f_name (f_name) USING BTREE
) ENGINE = InnoDB
  CHARACTER SET = utf8
  COLLATE = utf8_unicode_ci
  ROW_FORMAT = DYNAMIC;