filemanager.sql

质量越高得到的下载个数越多防卡死了几分鞍山市反反复复反反复复

/*
SQLyog Enterprise Trial - MySQL GUI v6.04
Host - 5.0.45-community-nt : Database - filemanager
*********************************************************************
Server version : 5.0.45-community-nt
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

create database if not exists `filemanager`;

USE `filemanager`;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*Table structure for table `file` */

DROP TABLE IF EXISTS `file`;

CREATE TABLE `file` (
  `owner` int(4) NOT NULL,
  `filename` varchar(200) NOT NULL,
  `filesize` float NOT NULL,
  `uploadtime` date NOT NULL,
  `location` varchar(300) NOT NULL,
  `fileId` int(11) NOT NULL auto_increment COMMENT '上传文件的id',
  `fileType` varchar(45) NOT NULL default '',
  PRIMARY KEY  (`fileId`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

/*Data for the table `file` */

insert  into `file`(`owner`,`filename`,`filesize`,`uploadtime`,`location`,`fileId`,`fileType`) values (2,'附录 一.doc',2076.5,'2007-07-28','file/2/附录 一.doc/',1,'application/msword'),(2,'ApplicationResources_zh_CN.properties',0.416016,'2007-07-28','file/2/ApplicationResources_zh_CN.properties/',2,'text/plain'),(2,'test.dll',0,'2007-07-28','file/2/test.dll/',3,'application/octet-stream');

/*Table structure for table `user` */

DROP TABLE IF EXISTS `user`;

CREATE TABLE `user` (
  `id` int(4) NOT NULL auto_increment,
  `username` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL,
  `diskquota` float NOT NULL,
  `ifpublic` tinyint(1) NOT NULL,
  `canupload` tinyint(1) default '0',
  `candownload` tinyint(1) default '0',
  `candelete` tinyint(1) default '0',
  `grade` varchar(10) default 'user',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

/*Data for the table `user` */

insert  into `user`(`id`,`username`,`password`,`diskquota`,`ifpublic`,`canupload`,`candownload`,`candelete`,`grade`) values (1,'aaa','aaa',1000,0,1,1,0,'user'),(2,'bbb','bbb',2000,0,1,1,0,'user'),(3,'ccc','ccc',4000,0,1,1,1,'admin'),(4,'ppp','ppp',1000,0,1,1,0,'admin');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;