# MySQL-Front 3.2  (Build 14.8)

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES gb2312 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='SYSTEM' */;
/*!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' */;


# Host: localhost    Database: student
# ------------------------------------------------------
# Server version 5.0.18-nt

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

#
# Table structure for table t_course
#

CREATE TABLE `t_course` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table t_course
#

INSERT INTO `t_course` VALUES (1,'化學');
INSERT INTO `t_course` VALUES (2,'數學');
INSERT INTO `t_course` VALUES (3,'物理');
INSERT INTO `t_course` VALUES (4,'英語');
INSERT INTO `t_course` VALUES (5,'語文');
INSERT INTO `t_course` VALUES (6,'政治');

#
# Table structure for table t_marks
#

CREATE TABLE `t_marks` (
  `id` int(11) NOT NULL auto_increment,
  `student_id` int(11) default NULL,
  `course_id` int(11) default NULL,
  `marks` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table t_marks
#

INSERT INTO `t_marks` VALUES (1,20,1,69);
INSERT INTO `t_marks` VALUES (2,20,2,12);
INSERT INTO `t_marks` VALUES (3,20,3,17);
INSERT INTO `t_marks` VALUES (4,20,4,93);
INSERT INTO `t_marks` VALUES (5,20,5,85);
INSERT INTO `t_marks` VALUES (6,20,6,35);
INSERT INTO `t_marks` VALUES (8,21,1,46);
INSERT INTO `t_marks` VALUES (9,21,2,59);
INSERT INTO `t_marks` VALUES (10,21,3,91);
INSERT INTO `t_marks` VALUES (11,21,4,73);
INSERT INTO `t_marks` VALUES (12,21,5,71);
INSERT INTO `t_marks` VALUES (13,21,6,89);
INSERT INTO `t_marks` VALUES (14,22,1,63);
INSERT INTO `t_marks` VALUES (15,22,2,65);
INSERT INTO `t_marks` VALUES (16,22,3,69);
INSERT INTO `t_marks` VALUES (17,22,4,68);
INSERT INTO `t_marks` VALUES (18,22,5,67);
INSERT INTO `t_marks` VALUES (19,22,6,77);
INSERT INTO `t_marks` VALUES (20,23,1,88);
INSERT INTO `t_marks` VALUES (21,23,2,67);
INSERT INTO `t_marks` VALUES (22,23,3,55);
INSERT INTO `t_marks` VALUES (23,23,4,45);
INSERT INTO `t_marks` VALUES (24,23,5,33);
INSERT INTO `t_marks` VALUES (25,23,6,34);
INSERT INTO `t_marks` VALUES (26,24,1,55);
INSERT INTO `t_marks` VALUES (27,24,2,66);
INSERT INTO `t_marks` VALUES (28,24,3,77);
INSERT INTO `t_marks` VALUES (29,24,4,88);
INSERT INTO `t_marks` VALUES (30,24,5,99);
INSERT INTO `t_marks` VALUES (31,24,6,100);

#
# Table structure for table t_schoolmates
#

CREATE TABLE `t_schoolmates` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312 ROW_FORMAT=REDUNDANT;

#
# Dumping data for table t_schoolmates
#

INSERT INTO `t_schoolmates` VALUES (20,'小張');
INSERT INTO `t_schoolmates` VALUES (21,'小王');
INSERT INTO `t_schoolmates` VALUES (22,'小李');
INSERT INTO `t_schoolmates` VALUES (23,'張名');
INSERT INTO `t_schoolmates` VALUES (24,'name');

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;