/*
Navicat MySQL Data Transfer

Source Server         : 本地
Source Server Version : 50540
Source Host           : 127.0.0.1:3306
Source Database       : display

Target Server Type    : MYSQL
Target Server Version : 50540
File Encoding         : 65001

Date: 2017-12-21 15:49:51
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for common_tfs_map
-- ----------------------------
DROP TABLE IF EXISTS `common_tfs_map`;
CREATE TABLE `common_tfs_map` (
  `md5` varchar(128) NOT NULL COMMENT '文件的md5唯一编码',
  `file_hash_code` varchar(128) NOT NULL COMMENT 'tfs对应的hash值',
  PRIMARY KEY (`md5`),
  UNIQUE KEY `uinque_index_file_hash_code` (`file_hash_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of common_tfs_map
-- ----------------------------
INSERT INTO `common_tfs_map` VALUES ('47375cb03382346357214684e9010b41', 'T1ktJTByhT1RCvBVdK');

-- ----------------------------
-- Table structure for tab_file
-- ----------------------------
DROP TABLE IF EXISTS `tab_file`;
CREATE TABLE `tab_file` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `file_name` varchar(255) DEFAULT NULL COMMENT '文件名',
  `file_hash_code` varchar(128) NOT NULL COMMENT 'tfs对应的hash值',
  `file_path` varchar(255) DEFAULT NULL COMMENT '所在服务器的相对路径',
  `create_time` datetime NOT NULL COMMENT '文件上传时间',
  `remark` varchar(128) DEFAULT NULL COMMENT '备用',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tab_file
-- ----------------------------
INSERT INTO `tab_file` VALUES ('12', 'product2.jpg', 'T1ktJTByhT1RCvBVdK', null, '2017-05-04 16:01:37', null);
