Server/VB_DSM_V2.0/scripts/SQL/vbdsm_netdisk.sql

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `vbdsm_netdisk` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `vbdsm_netdisk`;
SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for t_short_url
-- ----------------------------
DROP TABLE IF EXISTS `t_short_url`;
CREATE TABLE `t_short_url` (
  `surl` varchar(255) NOT NULL,
  `url` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`surl`),
  UNIQUE KEY `surl_index` (`surl`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for t_ufile
-- ----------------------------
DROP TABLE IF EXISTS `t_ufile`;
CREATE TABLE `t_ufile` (
  `id` varchar(11) COLLATE utf8_unicode_ci NOT NULL,
  `pid` varchar(11) COLLATE utf8_unicode_ci DEFAULT NULL,
  `xpath` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `xcode` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `alias` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `objectId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `createTime` bigint(20) DEFAULT NULL,
  `uname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ftype` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ext` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ico` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lastModified` bigint(20) DEFAULT NULL,
  `fsize` bigint(20) DEFAULT NULL,
  `fgroup` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fsgroup` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `deleted` varchar(1) COLLATE utf8_unicode_ci DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `index_ftype` (`ftype`) USING BTREE,
  KEY `index_ext` (`ext`) USING BTREE,
  KEY `index_uname` (`uname`) USING BTREE,
  KEY `index_fname` (`fname`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;