lab.sql

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

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

/*!40101 SET NAMES utf8 */;

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

create database if not exists `lab`;

USE `lab`;

/*!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 `admin` */

DROP TABLE IF EXISTS `admin`;

CREATE TABLE `admin` (
  `name` varchar(16) default NULL,
  `password` varchar(16) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `admin` */

insert  into `admin`(`name`,`password`) values ('dd','dd'),('admin','admin');

/*Table structure for table `enrol` */

DROP TABLE IF EXISTS `enrol`;

CREATE TABLE `enrol` (
  `class_id` varchar(32) default NULL,
  `stu_id` varchar(32) default NULL,
  `accept` varchar(32) default NULL,
  `score` varchar(32) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `enrol` */

/*Table structure for table `grade` */

DROP TABLE IF EXISTS `grade`;

CREATE TABLE `grade` (
  `id` int(8) NOT NULL,
  `grade` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `grade` */

insert  into `grade`(`id`,`grade`) values (1,'2005'),(2,'2006'),(3,'2007'),(4,'2008');

/*Table structure for table `news` */

DROP TABLE IF EXISTS `news`;

CREATE TABLE `news` (
  `id` int(8) NOT NULL auto_increment,
  `title` varchar(60) default NULL,
  `content` varchar(60) default NULL,
  `datetime` varchar(60) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `news` */

insert  into `news`(`id`,`title`,`content`,`datetime`) values (1,'平台试运行','进入开始平台试运行,欢迎大家访问!					','2007-7-2 21:45:38'),(2,'获奖通知','xx,获得	先进青年称号			','2007-7-2 21:43:57');

/*Table structure for table `note` */

DROP TABLE IF EXISTS `note`;

CREATE TABLE `note` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) default NULL,
  `author` varchar(255) default NULL,
  `content` varchar(255) default NULL,
  `datetime` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

/*Data for the table `note` */

insert  into `note`(`id`,`title`,`author`,`content`,`datetime`) values (1,'note1','fra','note1 is note 1','21:52');

/*Table structure for table `project` */

DROP TABLE IF EXISTS `project`;

CREATE TABLE `project` (
  `id` int(11) NOT NULL,
  `name` varchar(64) default NULL,
  `info` varchar(255) default NULL,
  `time` varchar(16) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `project` */

insert  into `project`(`id`,`name`,`info`,`time`) values (1,'关于开发教育项目','								关于开发一个关于基于J2ee平台的教育项目\r\n							\r\n							','2007-9-2'),(2,'企业黄页项目','								接交委通知,开发一个企业黄页项目\r\n							\r\n							','2007-111-1'),(3,'财政项目','								我们与省公司签定一了财政项目\r\n							\r\n							','2007-12-14');

/*Table structure for table `student` */

DROP TABLE IF EXISTS `student`;

CREATE TABLE `student` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(16) default NULL,
  `grade_id` int(11) default NULL,
  `image` varchar(50) default NULL,
  `sex` char(4) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

/*Data for the table `student` */

insert  into `student`(`id`,`name`,`grade_id`,`image`,`sex`) values (1,'dsdsd',3,'2-1.gif','女'),(2,'fdf',2,'pinfo.gif','男'),(3,'dsd',3,'xong7.gif','男'),(4,'张貉',3,'2-3.gif','女');

/*Table structure for table `teacher` */

DROP TABLE IF EXISTS `teacher`;

CREATE TABLE `teacher` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(32) default NULL,
  `sex` char(4) default NULL,
  `zhicheng` varchar(32) default NULL,
  `image` varchar(50) default NULL,
  `info` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

/*Data for the table `teacher` */

insert  into `teacher`(`id`,`name`,`sex`,`zhicheng`,`image`,`info`) values (2,'李老师','女','会计师','s10.gif','										她有光荣的历史	\r\n							\r\n							\r\n							\r\n							\r\n							'),(3,'李老师','男','教授','xong6.gif','来自广州\r\n							\r\n							\r\n							');

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