学生信息管理系统数据库代码

?/*
SQLyog Enterprise - MySQL GUI v6.03
Host - 5.0.18-nt : Database - shujuku
*********************************************************************
Server version : 5.0.18-nt
*/

/*!40101 SET NAMES utf8 */;

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

create database if not exists `shujuku`;

USE `shujuku`;

/*!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` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(20) default NULL,
`password` varchar(14) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `admin` */

insert into `admin`(`id`,`name`,`password`) values (1,'2','2');

/*Table structure for table `message` */

DROP TABLE IF EXISTS `message`;

CREATE TABLE `message` (
`id` int(11) NOT NULL auto_increment,
`toid` varchar(20) default NULL,
`fromid` varchar(100) default NULL,
`title` varchar(100) default NULL,
`content` varchar(1000) default NULL,
`time` varchar(20) default NULL,
`ifread` int(11) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `message` */

/*Table structure for table `student` */

DROP TABLE IF EXISTS `student`;

CREATE TABLE `student` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(20) default NULL,
`password` varchar(20) default NULL,
`sex` varchar(20) default NULL,
`nation` varchar(20) default NULL,
`political` varchar(20) default NULL,
`birthday` varchar(20) default NULL,
`major` varchar(20) default NULL,
`grade` varchar(20) default NULL,
`college` varchar(20) default NULL,
`department` varchar(20) default NULL,
`post` varchar(20) default NULL,
`home` varchar(20) default NULL,
`qq` varchar(20) default NULL,
`phone` varchar(20) default NULL,
`mail` varchar(20) default NULL,
`suit` varchar(20) default NULL,
`ifmodify` int(11) default NULL,
`picname` varchar(11) default NULL,
`ifread` varchar(10) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `student` */

insert into `student`(`id`,`name`,`password`,`sex`,`nation`,`political`,`birthday`,`major`,`grade`,`college`,`department`,`post`,`home`,`qq`,`phone`,`mail`,`suit`,`ifmodify`,`picname`,`ifread`) values (1,'1','1','4','4','4','4','4','4','4','4','4','4','4','4','4','4',4,NULL,NULL);

/*Table structure for table `time` */

DROP TABLE IF EXISTS `time`;

CREATE TABLE `time` (
`id` int(11) NOT NULL auto_increment,
`timeid` int(11) default NULL,
`content` varchar(1000) default NULL,
`time` varchar(20) default NULL,
`ontime` varchar(10) default NULL,
`setTimeId` varchar(20) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the

table `time` */

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