# MySQL-Front 3.2 (Build 14.8)
/*!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: pkgl
# ------------------------------------------------------
# Server version 5.0.16-nt
CREATE DATABASE `pkgl` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `pkgl`;
/*!40101 SET NAMES utf8 */;
#
# Table structure for table class_info
#
CREATE TABLE `class_info` (
`class_id` char(10) NOT NULL default '0',
`class_name` varchar(255) default NULL,
PRIMARY KEY (`class_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#
# Dumping data for table class_info
#
INSERT INTO `class_info` VALUES ('0501','管信051');
INSERT INTO `class_info` VALUES ('0502','管信052');
#
# Table structure for table course_equip
#
CREATE TABLE `course_equip` (
`id` int(4) NOT NULL auto_increment,
`course_id` char(10) NOT NULL default '0',
`equip_id` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `新建索引` (`course_id`,`equip_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;
#
# Dumping data for table course_equip
#
INSERT INTO `course_equip` VALUES (63,'001','1');
INSERT INTO `course_equip` VALUES (64,'001','6');
INSERT INTO `course_equip` VALUES (65,'002','1');
INSERT INTO `course_equip` VALUES (66,'002','2');
INSERT INTO `course_equip` VALUES (67,'002','3');
INSERT INTO `course_equip` VALUES (68,'002','4');
INSERT INTO `course_equip` VALUES (69,'002','5');
INSERT INTO `course_equip` VALUES (70,'002','6');
INSERT INTO `course_equip` VALUES (71,'003','1');
INSERT INTO `course_equip` VALUES (72,'003','4');
INSERT INTO `course_equip` VALUES (73,'004','4');
INSERT INTO `course_equip` VALUES (74,'005','1');
INSERT INTO `course_equip` VALUES (75,'005','2');
INSERT INTO `course_equip` VALUES (76,'005','3');
INSERT INTO `course_equip` VALUES (77,'005','4');
INSERT INTO `course_equip` VALUES (78,'005','5');
INSERT INTO `course_equip` VALUES (79,'005','6');
INSERT INTO `course_equip` VALUES (80,'006','1');
INSERT INTO `course_equip` VALUES (81,'007','3');
INSERT INTO `course_equip` VALUES (82,'007','5');
#
# Table structure for table course_info
#
CREATE TABLE `course_info` (
`id` int(4) NOT NULL auto_increment,
`course_id` char(10) NOT NULL default '',
`course_name` char(20) default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `新建索引` (`course_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=REDUNDANT;
#
# Dumping data for table course_info
#
INSERT INTO `course_info` VALUES (1,'001','管理信息系统');
INSERT INTO `course_info` VALUES (2,'002','计算机组成原理');
INSERT INTO `course_info` VALUES (3,'003','数据库原理');
INSERT INTO `course_info` VALUES (4,'004','Java语言');
INSERT INTO `course_info` VALUES (5,'005','管信开发实践');
INSERT INTO `course_info` VALUES (6,'006','现代通讯概论');
INSERT INTO `course_info` VALUES (7,'007','电子商务');
#
# Table structure for table equip_info
#
CREATE TABLE `equip_info` (
`equip_id` char(10) NOT NULL default '',
`equip_name` varchar(255) default NULL,
PRIMARY KEY (`equip_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#
# Dumping data for table equip_info
#
#
# Table structure for table schedule
#
CREATE TABLE `schedule` (
`id` int(4) NOT NULL auto_increment,
`yearl` char(4) NOT NULL default '0',
`weekl` char(2) NOT NULL default '0',
`dayl` char(1) NOT NULL default '0',
`sectionl` char(1) NOT NULL default '0',
`course_id` char(10) NOT NULL default '0',
`teacher_id` char(10) NOT NULL default '0',
`class_id` char(10) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `新建索引` (`yearl`,`weekl`,`dayl`,`sectionl`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#
# Dumping data for table schedule
#
INSERT INTO `schedule` VALUES (304,'2008','1','1','1','001','001','051-052');
INSERT INTO `schedule` VALUES (305,'2008','1','3','1','001','001','051-052');
INSERT INTO `schedule` VALUES (306,'2008','2','1','1','001','001','051-052');
INSERT INTO `schedule` VALUES (307,'2008','2','3','1','001','001','051-052');
INSERT INTO `schedule` VALUES (308,'2008','3','1','1','001','001','051-052');
INSERT INTO `schedule` VALUES (309,'2008','3','3','1','001','001','051-052');
INSERT INTO `schedule` VALUES (310,'2008','4','1','1','001','001','051-052');
INSERT INTO `schedule` VALUES (311,'2008','4','3','1','001','001','051-052');
INSERT INTO `schedule` VALUES (312,'2008','5','1','1','001','001','051-052');
INSERT INTO `schedule` VALUES (313,'2008','5','3','1','001','001','051-052');
INSERT INTO `schedule` VALUES (314,'2008','6','1','1','001','001','051-052');
INSERT INTO `schedule` VALUES (315,'2008','6','3','1','001','001','051-052');
INSERT INTO `schedule` VALUES (316,'2008','7','1','1','001','001','051-052');
INSERT INTO `schedule` VALUES (317,'2008','7','3','1','001','001','051-052');
INSERT INTO `schedule` VALUES (318,'2008','8','1','1','001','001','051-052');
INSERT INTO `schedule` VALUES (319,'2008','8','3','1','001','001','051-052');
INSERT INTO `schedule` VALUES (320,'2008','9','1','1','001','001','051-052');
INSERT INTO `schedule` VALUES (321,'2008','9','3','1','001','001','051-052');
INSERT INTO `schedule` VALUES (322,'2008','10','1','1','001','001','051-052');
INSERT INTO `schedule` VALUES (323,'2008','10','3','1','001','001','051-052');
INSERT INTO `schedule` VALUES (324,'2008','1','1','2','002','004','051-052');
INSERT INTO `schedule` VALUES (325,'2008','1','3','2','002','004','051-052');
INSERT INTO `schedule` VALUES (326,'2008','1','5','2','002','004','051-052');
INSERT INTO `schedule` VALUES (327,'2008','2','1','2','002','004','051-052');
INSERT INTO `schedule` VALUES (328,'2008','2','3','2','002','004','051-052');
INSERT INTO `schedule` VALUES (329,'2008','2','5','2','002','004','051-052');
INSERT INTO `schedule` VALUES (330,'2008','3','1','2','002','004','051-052');
INSERT INTO `schedule` VALUES (331,'2008','3','3','2','002','004','051-052');
INSERT INTO `schedule` VALUES (332,'2008','3','5','2','002','004','051-052');
INSERT INTO `schedule` VALUES (333,'2008','4','1','2','002','004','051-052');
INSERT INTO `schedule` VALUES (334,'2008','4','3','2','002','004','051-052');
INSERT INTO `schedule` VALUES (335,'2008','4','5','2','002','004','051-052');
INSERT INTO `schedule` VALUES (336,'2008','5','1','2','002','004','051-052');
INSERT INTO `schedule` VALUES (337,'2008','5','3','2','002','004','051-052');
INSERT INTO `schedule` VALUES (338,'2008','5','5','2','002','004','051-052');
INSERT INTO `schedule` VALUES (339,'2008','6','1','2','002','004','051-052');
INSERT INTO `schedule` VALUES (340,'2008','6','3','2','002','004','051-052');
INSERT INTO `schedule` VALUES (341,'2008','6','5','2','002','004','051-052');
INSERT INTO `schedule` VALUES (342,'2008','7','1','2','002','004','051-052');
INSERT INTO `schedule` VALUES (343,'2008','7','3','2','002','004','051-052');
INSERT INTO `schedule` VALUES (344,'2008','7','5','2','002','004','051-052');
INSERT INTO `schedule` VALUES (345,'2008','8','1','2','002','004','051-052');
INSERT INTO `schedule` VALUES (346,'2008','8','3','2','002','004','051-052');
INSERT INTO `schedule` VALUES (347,'2008','8','5','2','002','004','051-052');
INSERT INTO `schedule` VALUES (348,'2008','9','1','2','002','004','051-052');
INSERT INTO `schedule` VALUES (349,'2008','9','3','2','002','004','051-052');
INSERT INTO `schedule` VALUES (350,'2008','9','5','2','002','004','051-052');
INSERT INTO `schedule` VALUES (351,'2008','10','1','2','002','004','051-052');
INSERT INTO `schedule` VALUES (352,'2008','10','3','2','002','004','051-052');
INSERT INTO `schedule` VALUES (353,'2008