Device/SERVER/VBDSM_DEVICE_V1.0/script/sql/File.sql

-- ----------------------------
-- 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;