?/*
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 */;