edu.sql

在线教育平台： 从小学

# Host: 127.0.0.1    Database: edu
# ------------------------------------------------------
# Server version 5.0.24a-community-nt

DROP DATABASE IF EXISTS `edu`;
CREATE DATABASE `edu` /*!40100 DEFAULT CHARACTER SET gb2312 */;
USE `edu`;

#
# Table structure for table admin
#

CREATE TABLE `admin` (
  `id` int(10) NOT NULL auto_increment COMMENT '管理员编号',
  `admin` varchar(50) collate gbk_bin default NULL COMMENT '名字',
  `psw` varchar(50) collate gbk_bin default NULL COMMENT '密码',
  `a_photo` varchar(50) collate gbk_bin default NULL COMMENT '照片地址',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk COLLATE=gbk_bin ROW_FORMAT=DYNAMIC;

#
# Dumping data for table admin
#

INSERT INTO `admin` (`id`,`admin`,`psw`,`a_photo`) VALUES (1,'admin','1AB5EFB86F0F82515A57B839A7650DBA',NULL);
INSERT INTO `admin` (`id`,`admin`,`psw`,`a_photo`) VALUES (3,'xdf','1AB5EFB86F0F82515A57B839A7650DBA',NULL);

#
# Table structure for table answer
#

CREATE TABLE `answer` (
  `answer_id` int(10) NOT NULL auto_increment COMMENT '回答编码',
  `ask_id` int(10) default NULL COMMENT '问题编码',
  `ans_content` text collate gbk_bin COMMENT '回答内容',
  `ans_time` varchar(50) collate gbk_bin default NULL COMMENT '回答时间',
  `ans_id` int(10) default NULL COMMENT '回答人编号',
  `ans_sort` varchar(10) collate gbk_bin default NULL COMMENT '回答人种类',
  PRIMARY KEY  (`answer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk COLLATE=gbk_bin ROW_FORMAT=DYNAMIC;

#
# Dumping data for table answer
#

INSERT INTO `answer` (`answer_id`,`ask_id`,`ans_content`,`ans_time`,`ans_id`,`ans_sort`) VALUES (1,3,'而他问题','2007-5-14 22:10:50',9,'user');
INSERT INTO `answer` (`answer_id`,`ask_id`,`ans_content`,`ans_time`,`ans_id`,`ans_sort`) VALUES (2,3,'艾薇儿与她哇 ','2007-5-18 0:22:16',1,'teacher');

#
# Table structure for table ask
#

CREATE TABLE `ask` (
  `ask_id` int(10) NOT NULL auto_increment COMMENT '提问编号',
  `a_title` varchar(50) collate gbk_bin default NULL COMMENT '问题标题',
  `a_content` text collate gbk_bin COMMENT '问题内容',
  `a_time` datetime default NULL COMMENT '时间',
  `u_id` int(10) default NULL COMMENT '提问人编号',
  `answer_id` int(10) default NULL COMMENT '是否回答/回答时为答题编号否则为null',
  `class_id` int(10) default NULL COMMENT '高中/初中/小学',
  `grade_id` int(10) default NULL COMMENT '高一/初一',
  `subject_id` int(10) default NULL COMMENT '数学/语文...',
  `ask_sort` varchar(10) collate gbk_bin default NULL COMMENT '回答人种类',
  PRIMARY KEY  (`ask_id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk COLLATE=gbk_bin ROW_FORMAT=DYNAMIC;

#
# Dumping data for table ask
#

INSERT INTO `ask` (`ask_id`,`a_title`,`a_content`,`a_time`,`u_id`,`answer_id`,`class_id`,`grade_id`,`subject_id`,`ask_sort`) VALUES (1,'高二代数证明(不等式）','求证:（1）1/√k＞2（√k+1-√k)(k∈N?)；<BR>（2）1+1/√2+1/√3+……+1/√n＞2[√(n+1)-1](n∈N?)','2007-03-19 16:47:27',1,0,2,1,6,'admin');
INSERT INTO `ask` (`ask_id`,`a_title`,`a_content`,`a_time`,`u_id`,`answer_id`,`class_id`,`grade_id`,`subject_id`,`ask_sort`) VALUES (2,'高二英语选择','---- _______ can I do with such a problem ? ---- Take _______ measures you consider best． <BR><BR>选项 <BR>A.How；whichever <BR>B.What；whichever <BR>C.How；whatever <BR>D.What；whatever <BR>答案为D,我选了A<BR><BR>A lot of water from the Changjiang River is carried into the lake _____ the water in the lake much cleaner than before． <BR><BR>选项 <BR>A.to make <BR>B.make <BR>C.making <BR>D.made <BR>答案为C,我选A<BR><BR>The poor girl had been expecting her lover back from abroad _____, so she becomes thinner and thinner ________． <BR><BR>选项 <BR>A.day after day；day by day <BR>B.day by day；day after day <BR>C.day by day；day by day <BR>D.day after day；day after day <BR>答案为A,我选了B<BR>','2007-03-19 16:50:16',9,0,2,1,4,'user');
INSERT INTO `ask` (`ask_id`,`a_title`,`a_content`,`a_time`,`u_id`,`answer_id`,`class_id`,`grade_id`,`subject_id`,`ask_sort`) VALUES (3,'aaaa','阿达二二万人温柔','2007-05-14 22:10:20',9,2,2,1,5,'user');

#
# Table structure for table card
#

CREATE TABLE `card` (
  `c_id` int(10) NOT NULL auto_increment COMMENT '卡的编号',
  `c_no` varchar(50) collate gbk_bin default NULL COMMENT '卡号',
  `c_psw` varchar(50) collate gbk_bin default NULL COMMENT '卡的密码',
  `c_day` int(10) default NULL COMMENT '可用天数',
  `c_allow` tinyint(1) NOT NULL default '0' COMMENT '是否有效',
  PRIMARY KEY  (`c_id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk COLLATE=gbk_bin ROW_FORMAT=DYNAMIC;

#
# Dumping data for table card
#

INSERT INTO `card` (`c_id`,`c_no`,`c_psw`,`c_day`,`c_allow`) VALUES (1,'A0B923820DCC509A','7xhx020cop',100,1);

#
# Table structure for table carduser
#

CREATE TABLE `carduser` (
  `card_user` int(10) NOT NULL auto_increment COMMENT '编号',
  `c_id` int(10) default NULL COMMENT '卡的编号',
  `u_id` int(10) default NULL COMMENT '用户编号',
  PRIMARY KEY  (`card_user`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk COLLATE=gbk_bin ROW_FORMAT=DYNAMIC;

#
# Dumping data for table carduser
#

INSERT INTO `carduser` (`card_user`,`c_id`,`u_id`) VALUES (1,1,9);

#
# Table structure for table class
#

CREATE TABLE `class` (
  `class_id` int(10) NOT NULL auto_increment COMMENT '年级编号',
  `grade_id` int(11) default NULL COMMENT '学历编号',
  `class` varchar(20) collate gbk_bin default NULL COMMENT '年级',
  PRIMARY KEY  (`class_id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk COLLATE=gbk_bin;

#
# Dumping data for table class
#

INSERT INTO `class` (`class_id`,`grade_id`,`class`) VALUES (1,1,'高一');
INSERT INTO `class` (`class_id`,`grade_id`,`class`) VALUES (2,1,'高二');
INSERT INTO `class` (`class_id`,`grade_id`,`class`) VALUES (3,1,'高三');
INSERT INTO `class` (`class_id`,`grade_id`,`class`) VALUES (4,2,'初一');
INSERT INTO `class` (`class_id`,`grade_id`,`class`) VALUES (5,2,'初二');
INSERT INTO `class` (`class_id`,`grade_id`,`class`) VALUES (6,2,'初三');
INSERT INTO `class` (`class_id`,`grade_id`,`class`) VALUES (7,3,'一年级');
INSERT INTO `class` (`class_id`,`grade_id`,`class`) VALUES (8,3,'二年级');
INSERT INTO `class` (`class_id`,`grade_id`,`class`) VALUES (9,3,'三年级');
INSERT INTO `class` (`class_id`,`grade_id`,`class`) VALUES (10,3,'四年级');
INSERT INTO `class` (`class_id`,`grade_id`,`class`) VALUES (11,3,'五年级');
INSERT INTO `class` (`class_id`,`grade_id`,`class`) VALUES (12,3,'六年级');

#
# Table structure for table control
#

CREATE TABLE `control` (
  `id` int(11) NOT NULL auto_increment,
  `card_number` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk COMMENT='控制';

#
# Dumping data for table control
#

INSERT INTO `control` (`id`,`card_number`) VALUES (1,1);

#
# Table structure for table courseware
#

CREATE TABLE `courseware` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(50) character set gb2312 default NULL,
  `content` mediumtext character set gb2312,
  `filename` varchar(50) character set gb2312 default NULL,
  `filesize` int(11) default NULL,
  `fileext` varchar(10) character set gb2312 default NULL,
  `grade_id` int(11) default NULL,
  `class_id` int(11) default NULL,
  `subject_id` int(11) default NULL,
  `uploadtime` varchar(50) character set gb2312 default NULL,
  `u_id` int(11) default NULL,
  `sort` varchar(11) character set gb2312 default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk COLLATE=gbk_bin;

#
# Dumping data for table courseware
#

INSERT INTO `courseware` (`id`,`title`,`content`,`filename`,`filesize`,`fileext`,`grade_id`,`class_id`,`subject_id`,`uploadtime`,`u_id`,`sort`) VALUES (12,'ceshi','tutto7toy','upload/20070517113622860.doc',107520,'doc',1,2,4,'2007-5-17 11:35:57',0,'');
INSERT INTO `courseware` (`id`,`title`,`content`,`filename`,`filesize`,`fileext`,`grade_id`,`class_id`,`subject_id`,`uploadtime`,`u_id`,`sort`) VALUES (13,'数学1','维尔按他','upload/20070517121240511.doc',107520,'doc',1,1,1,'2007-5-17 12:12:26',0,'');
INSERT INTO `courseware` (`id`,`title`,`content`,`filename`,`filesize`,`fileext`,`grade_id`,`class_id`,`subject_id`,`uploadtime`,`u_id`,`sort`) VALUES (14,'化学课件','而是 ','upload/20070517185408829.doc',23552,'doc',1,1,2,'2007-5-17 18:53:56',1,'teacher');
INSERT INTO `courseware` (`id`,`title`,`content`,`filename`,`filesize`,`fileext`,`grade_id`,`class_id`,`subject_id`,`uploadtime`,`u_id`,`sort`) VALUES (15,'课件课件课件课件','课件课件课件de','upload/20070518001830443.doc',23552,'doc',1,1,2,'2007-5-18 0:18:11',1,'teacher');
INSERT INTO `courseware` (`id`,`title`,`content`,`filename`,`filesize`,`fileext`,`grade_id`,`class_id`,`subject_id`,`uploadtime`,`u_id`,`sort`) VALUES (16,'英语测试','艾薇儿啊','upload/20070518144114174.doc',23552,'doc',1,1,2,'2007-5-18 14:40:54',1,'teacher');

#
# Table structure for table grade