Hadoop分布式云盘系统

/* Navicat MySQL Data Transfer Source Server : NetCloud Source Server Version : 50543 Source Host : 192.168.60.198:3306 Source Database : netcloud Target Server Type : MYSQL Target Server Version : 50543 File Encoding : 65001 Date: 2015-07-20 08:47:49 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `department` -- ---------------------------- DROP TABLE IF EXISTS `department`; CREATE TABLE `department` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=94 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of department -- ---------------------------- INSERT INTO `department` VALUES ('88', '技术1部'); INSERT INTO `department` VALUES ('89', '技术2部'); INSERT INTO `department` VALUES ('90', '市场部'); INSERT INTO `department` VALUES ('91', '生产部'); INSERT INTO `department` VALUES ('93', '@#$%^&*()_+|*/<>?\":{}'); -- ---------------------------- -- Table structure for `share` -- ---------------------------- DROP TABLE IF EXISTS `share`; CREATE TABLE `share` ( `id` int(11) NOT NULL AUTO_INCREMENT, `datetime` varchar(255) DEFAULT NULL, `department` int(11) NOT NULL, `filepath` varchar(255) DEFAULT NULL, `st_iv` varchar(255) DEFAULT NULL, `st_key` varchar(255) DEFAULT NULL, `username` varchar(255) DEFAULT NULL, `filesize` varchar(255) DEFAULT NULL, `type` varchar(255) DEFAULT NULL, `isdirectory` int(11) NOT NULL, `filename` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of share -- ---------------------------- INSERT INTO `share` VALUES ('6', '2015-06-23 17:52:58', '88', 'hdfs://192.168.60.190:9000/usr/ruanjianxueyuan/Amazing_Caves_720.mp4', 'hct5vw2h9065x9au', '1lfsaspy5an7fxdv', 'ruanjianxueyuan', '65.81M', 'video', '0', 'Amazing_Caves_720.mp4'); INSERT INTO `share` VALUES ('7', '2015-06-23 18:03:07', '88', 'hdfs://192.168.60.190:9000/usr/1001qitech/Amazing_Caves_720.mp4', 'nw14jr89dxxl243g', '1hwhcd280txa7tdf', '1001qitech', '65.81M', 'video', '0', 'Amazing_Caves_720.mp4'); INSERT INTO `share` VALUES ('8', '2015-06-23 18:03:12', '88', 'hdfs://192.168.60.190:9000/usr/1001qitech/FXSAPIDebugLogFile.txt', 'nw14jr89dxxl243g', '1hwhcd280txa7tdf', '1001qitech', '0.00 K', 'document', '0', 'FXSAPIDebugLogFile.txt'); INSERT INTO `share` VALUES ('9', '2015-06-23 18:03:16', '88', 'hdfs://192.168.60.190:9000/usr/1001qitech/Maid with the Flaxen Hair.mp3', 'nw14jr89dxxl243g', '1hwhcd280txa7tdf', '1001qitech', '3.94M', 'audio', '0', 'Maid with the Flaxen Hair.mp3'); INSERT INTO `share` VALUES ('18', '2015-06-23 18:07:37', '89', 'hdfs://192.168.60.190:9000/usr/2001qitech/Amazing_Caves_720.mp4', 'by5mgolqow3x6akp', 't6x0nyhu4xgnb2an', '2001qitech', '65.81M', 'video', '0', 'Amazing_Caves_720.mp4'); INSERT INTO `share` VALUES ('19', '2015-06-23 18:07:41', '89', 'hdfs://192.168.60.190:9000/usr/2001qitech/Desert.jpg', 'by5mgolqow3x6akp', 't6x0nyhu4xgnb2an', '2001qitech', '828.14 K', 'picture', '0', 'Desert.jpg'); INSERT INTO `share` VALUES ('20', '2015-06-23 18:07:45', '89', 'hdfs://192.168.60.190:9000/usr/2001qitech/FXSAPIDebugLogFile.txt', 'by5mgolqow3x6akp', 't6x0nyhu4xgnb2an', '2001qitech', '0.00 K', 'document', '0', 'FXSAPIDebugLogFile.txt'); INSERT INTO `share` VALUES ('21', '2015-06-23 18:07:49', '89', 'hdfs://192.168.60.190:9000/usr/2001qitech/Lighthouse.jpg', 'by5mgolqow3x6akp', 't6x0nyhu4xgnb2an', '2001qitech', '548.14 K', 'picture', '0', 'Lighthouse.jpg'); INSERT INTO `share` VALUES ('22', '2015-06-23 18:07:52', '89', 'hdfs://192.168.60.190:9000/usr/2001qitech/Maid with the Flaxen Hair.mp3', 'by5mgolqow3x6akp', 't6x0nyhu4xgnb2an', '2001qitech', '3.94M', 'audio', '0', 'Maid with the Flaxen Hair.mp3'); -- ---------------------------- -- Table structure for `user` -- ---------------------------- DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `st_access` varchar(255) DEFAULT NULL, `st_department` int(11) DEFAULT NULL, `st_iv` varchar(255) DEFAULT NULL, `st_key` varchar(255) DEFAULT NULL, `st_password` varchar(255) DEFAULT NULL, `st_userdir` varchar(255) DEFAULT NULL, `st_username` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=112 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of user -- ---------------------------- INSERT INTO `user` VALUES ('83', 'all', '0', 'cis7grbjezhvga4n', 'ar938vxonhezo3tf', '<G=RG$Nž2UaDª', 'chenwei', 'chenwei'); INSERT INTO `user` VALUES ('84', 'all', '0', 'hct5vw2h9065x9au', '1lfsaspy5an7fxdv', ' +k’^ƒ;N\ZRjN‹', 'ruanjianxueyuan', 'ruanjianxueyuan'); INSERT INTO `user` VALUES ('87', 'all', '88', 'a7x62p6v0hkkfhnm', 'dnv1hxmu4y166cbh', 'ý­oÐz\ZšóÁ[®ˆo„', 'huanhuan', 'chenwenhuan'); INSERT INTO `user` VALUES ('91', 'all', '0', 'ye2h25l2dgurorb1', 'dhot2anntfy3vr5h', '>ÔÜ«w8¼²üÓK‡', 'zhoutianhang', 'zhoutianhang'); INSERT INTO `user` VALUES ('92', null, '0', 'eq0fb64p8u1cjbqk', 'znovzrk54sl9meji', '?@*RŒÍXö-G‡w»à', 'abcdefg', 'abcdefg'); INSERT INTO `user` VALUES ('95', '技术1部:list技术1部:update技术1部:delete技术1部:add技术1部:filelist技术1部:downloadfile技术2部:list技术2部:update技术2部:delete技术2部:add技术2部:filelist技术2部:downloadfile市场部:list市场部:update市场部:delete市场部:add市场部:filelist市场部:downloadfile', '89', 'pz8kycua2zhict5k', 'les5hd4wymvdq5wq', 'DL—íOÑJ¤Åa«®1', 'abcdefghi', 'abcdefghi'); INSERT INTO `user` VALUES ('96', '技术1部:list技术1部:update技术1部:delete技术1部:add技术1部:filelist技术1部:downloadfile技术2部:list技术2部:update技术2部:delete技术2部:add技术2部:filelist技术2部:downloadfile', '88', '3fr7tpdljfcrk0fl', 'vtl75e348q73d9ut', '§G½(ËéÊ
±vÎ@R•Ì', 'wenhuan', 'wenhuan'); INSERT INTO `user` VALUES ('98', '技术1部:list技术1部:update技术1部:delete技术1部:add技术1部:filelist技术1部:downloadfile技术2部:list技术2部:update技术2部:delete技术2部:add技术2部:filelist技术2部:downloadfile市场部:list市场部:update市场部:delete市场部:add市场部:filelist市场部:downloadfile', '90', 'n3ye1ty88n302p3c', '2i9och4f4l8q7jxk', 'T§ôí0ŸsDp• Nl', 'zhouzhou', 'zhouzhou'); INSERT INTO `user` VALUES ('99', null, '0', 'a04tbxvnpjm5czp6', 'xq5v6p4umorl6lml', 'Žݘž!t\r—b%', '11111111', '11111111'); INSERT INTO `user` VALUES ('100', '技术1部:list技术1部:update', '89', 'by5mgolqow3x6akp', 't6x0nyhu4xgnb2an', 'u-ý-›èÂåؖSbÿ1', '2001qitech', '2001qitech'); INSERT INTO `user` VALUES ('101', null, '89', 'vddjxsgz4himlr3i', '8dtwehlq0sv17jnn', '•¢ttëFõ¦Ä]ñiã', '2002qitech', '2002qitech'); INSERT INTO `user` VALUES ('102', null, '88', 'nw14jr89dxxl243g', '1hwhcd280txa7tdf', 'lqÔÝïkQŸ¬KED Î', '1001qitech', '1001qitech'); INSERT INTO `user` VALUES ('103', null, '88', '093z24fhw0dw1yc7', 'cib8nxcwtc236x88', 'J@#‰àqœ\\ñ®€#Ûä', '1002qitech', '1002qitech'); INSERT INTO `user` VALUES ('104', null, '90', 'ku98ui6knpd10cqo', 'nrmmrzu9jepbmko9', '篰DI5¦¸Ëˆ4Õ@…W', '3001qitech', '3001qitech'); INSERT INTO `user` VALUES ('105', null, '91', 'ez4rxa00obphzutp', 'odoecx1f162o6u9v', '‡3æÂZÔ¦|3Ÿçΐ\Z—', '4001qitech', '4001qitech'); INSERT INTO `user` VALUES ('106', null, '0', '2oksl7pfm7klhz8g', 'fdq0e6kfr2nfsz5h', 'ۚª‘›§R£Ä!tpéëuˆ', 'aaaaaa', 'aaaaaa'); INSERT INTO `user` VALUES ('107', null, '88', '5miwnb2k4uxgrf93', 'j118me5fxo3s6q7o', 'G±ÎD+£ñÕZ–¶¤:%', 'bbbbbb', 'bbbbbb'); INSERT INTO `user` VALUES ('108', null, '88', 'vrno7qfvj7ova48t', '6cxwrjnjc0i3rltm', 'MÖkÿþ:g’×Î߄³', '123456', '123456'); INSERT INTO `user` VALUE