CREATE DATABASE `saas_file` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
use `saas_file`;

create table `f_fileinfo` (
  id int unsigned primary key not null auto_increment,
  folder_id int comment '文件夹',
  name varchar(100) not null comment '名称',
  full_path varchar(300) comment '保存路径',
  mime varchar(100) comment 'mime',
  ext varchar(100) comment '扩展名',
  type varchar(10) comment '类型',
  size int comment '大小',
  company_id int,
  creator_id int,
  create_time datetime,
  updater_id int,
  update_time datetime,
  deleted boolean,
  deleter_id int,
  delete_time datetime
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文件';