adasdcef

# MySQL-Front 5.1  (Build 1.9)

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40101 SET SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
/*!40103 SET SQL_NOTES='ON' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS */;
/*!40014 SET FOREIGN_KEY_CHECKS=0 */;

# Host: localhost    Database: mailmanager
# ------------------------------------------------------
# Server version 6.0.0-alpha-community-nt-debug

#
# Source for table classinfo
#

DROP TABLE IF EXISTS `classinfo`;
CREATE TABLE `classinfo` (
  `classId` int(11) NOT NULL AUTO_INCREMENT,
  `className` varchar(30) NOT NULL,
  `departmentId` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`classId`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table classinfo
#
LOCK TABLES `classinfo` WRITE;
/*!40000 ALTER TABLE `classinfo` DISABLE KEYS */;

/*!40000 ALTER TABLE `classinfo` ENABLE KEYS */;
UNLOCK TABLES;

#
# Source for table department
#

DROP TABLE IF EXISTS `department`;
CREATE TABLE `department` (
  `departmentId` int(11) NOT NULL AUTO_INCREMENT,
  `dname` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`departmentId`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table department
#
LOCK TABLES `department` WRITE;
/*!40000 ALTER TABLE `department` DISABLE KEYS */;

INSERT INTO `department` VALUES (1,'计算机系');
INSERT INTO `department` VALUES (2,'信息管理系');
INSERT INTO `department` VALUES (3,'数字艺术系');
INSERT INTO `department` VALUES (4,'英语系');
INSERT INTO `department` VALUES (5,'日语系');
/*!40000 ALTER TABLE `department` ENABLE KEYS */;
UNLOCK TABLES;

#
# Source for table emailinfo
#

DROP TABLE IF EXISTS `emailinfo`;
CREATE TABLE `emailinfo` (
  `emailId` int(11) NOT NULL AUTO_INCREMENT,
  `sentmailaddress` varchar(200) NOT NULL,
  `copymailaddress` varchar(300) DEFAULT NULL,
  `dbdate` date NOT NULL COMMENT '发送日期',
  `sentecode` varchar(25) DEFAULT NULL COMMENT '发送者编号',
  `title` varchar(100) DEFAULT NULL,
  `mailinfo` varchar(800) DEFAULT NULL,
  PRIMARY KEY (`emailId`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table emailinfo
#
LOCK TABLES `emailinfo` WRITE;
/*!40000 ALTER TABLE `emailinfo` DISABLE KEYS */;

INSERT INTO `emailinfo` VALUES (2,'yahoo@come','yahoo@come','2009-02-01','05110651423','论文','哈哈哈');
INSERT INTO `emailinfo` VALUES (4,'42','345','2993-12-13','05110651423','4534','345345');
INSERT INTO `emailinfo` VALUES (5,'大大','按时','2993-12-13','54545433445','234','234234');
INSERT INTO `emailinfo` VALUES (7,'23423','234234','2993-12-13','05110651423','234234','234234');
/*!40000 ALTER TABLE `emailinfo` ENABLE KEYS */;
UNLOCK TABLES;

#
# Source for table student
#

DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
  `studentId` varchar(20) NOT NULL,
  `ename_en` varchar(20) NOT NULL COMMENT '学生英文名',
  `ename_cn` varchar(20) NOT NULL COMMENT '学生英文名',
  `mailaddress` varchar(30) DEFAULT NULL COMMENT '学生邮箱地址',
  `password` varchar(30) DEFAULT NULL,
  `classId` int(11) DEFAULT NULL COMMENT '班级编号',
  `gd_name` varchar(50) NOT NULL COMMENT '毕设名称',
  `role_type` int(11) NOT NULL DEFAULT '0' COMMENT '角色',
  `tel` varchar(15) DEFAULT NULL COMMENT '电话',
  `sendaddress` varchar(255) DEFAULT NULL,
  `copyaddress` varchar(255) DEFAULT NULL,
  `departmentId` int(11) DEFAULT NULL COMMENT '系别',
  PRIMARY KEY (`studentId`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table student
#
LOCK TABLES `student` WRITE;
/*!40000 ALTER TABLE `student` DISABLE KEYS */;

INSERT INTO `student` VALUES ('05110651423','steven','钟声','zhong.sheng@furuno-dl.com','123',14,'毕业管理',1,'14432322888','zhongsheng@yahoo.com.cn;zhongsheng@yahoo.com.cn;zhongsheng@yahoo.com.cn;','zhongsheng@yahoo.com.cn;',3);
INSERT INTO `student` VALUES ('05110651453','zhongsheng','钟声','123123','123',1,'毕业设计管理系统',1,NULL,NULL,NULL,2);
INSERT INTO `student` VALUES ('09876767656','23','23','123','123',4,'123123',1,NULL,NULL,NULL,1);
/*!40000 ALTER TABLE `student` ENABLE KEYS */;
UNLOCK TABLES;

#
# Source for table teacher
#

DROP TABLE IF EXISTS `teacher`;
CREATE TABLE `teacher` (
  `teacherId` varchar(15) NOT NULL DEFAULT '',
  `ename_en` varchar(20) NOT NULL COMMENT '老师英文名',
  `ename_cn` varchar(23) NOT NULL COMMENT '老师中文名',
  `password` varchar(15) NOT NULL COMMENT '密码',
  `mailaddress` varchar(20) DEFAULT NULL COMMENT '邮箱地址',
  `role_type` int(11) DEFAULT NULL COMMENT '角色',
  `copyaddress` varchar(255) DEFAULT NULL,
  `sendaddress` varchar(255) DEFAULT NULL,
  `tel` varchar(16) DEFAULT NULL COMMENT '电话',
  `departmentId` int(11) DEFAULT NULL COMMENT '系的ID',
  PRIMARY KEY (`teacherId`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table teacher
#
LOCK TABLES `teacher` WRITE;
/*!40000 ALTER TABLE `teacher` DISABLE KEYS */;

INSERT INTO `teacher` VALUES ('00000000001','lixucheng','李绪诚','123','lxc@neusoft.com',2,NULL,NULL,'15577777777',2);
/*!40000 ALTER TABLE `teacher` ENABLE KEYS */;
UNLOCK TABLES;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;