-- MySQL dump 10.11
--
-- Host: localhost    Database: ga
-- ------------------------------------------------------
-- Server version	5.0.45

/*!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 utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!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' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `curriculum`
--

DROP TABLE IF EXISTS `curriculum`;
CREATE TABLE `curriculum` (
  `grade` varchar(11) default NULL,
  `subject` varchar(11) default NULL,
  `hoursPerWeek` varchar(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `curriculum`
--

LOCK TABLES `curriculum` WRITE;
/*!40000 ALTER TABLE `curriculum` DISABLE KEYS */;
INSERT INTO `curriculum` VALUES ('10','E','4'),('8','E','9'),('9','E','5'),('10','D','3'),('8','D','2'),('5','M','4'),('5','BK','2'),('5','D','4'),('10','M','5'),('10','PH','3'),('10','BK','1'),('10','B','2'),('8','B','2'),('5','B','2'),('8','M','3'),('8','PH','2'),('8','BK','2'),('9','M','4'),('9','BK','1'),('9','D','3'),('9','PH','3'),('9','B','2');
/*!40000 ALTER TABLE `curriculum` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `forms`
--

DROP TABLE IF EXISTS `forms`;
CREATE TABLE `forms` (
  `grade` varchar(11) NOT NULL default '',
  `letter` varchar(200) default NULL,
  `classteacher` varchar(500) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `forms`
--

LOCK TABLES `forms` WRITE;
/*!40000 ALTER TABLE `forms` DISABLE KEYS */;
INSERT INTO `forms` VALUES ('10','d','hn'),('9','c','ms '),('10','b','kf'),('8','f','js'),('5','b','bg');
/*!40000 ALTER TABLE `forms` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `schedule`
--

DROP TABLE IF EXISTS `schedule`;
CREATE TABLE `schedule` (
  `grade` int(10) NOT NULL default '0',
  `day` varchar(100) default NULL,
  `period` int(10) default NULL,
  `subject` int(10) default NULL,
  `teacher` int(11) default NULL,
  `letter` char(1) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `schedule`
--

LOCK TABLES `schedule` WRITE;
/*!40000 ALTER TABLE `schedule` DISABLE KEYS */;
/*!40000 ALTER TABLE `schedule` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `schedules`
--

DROP TABLE IF EXISTS `schedules`;
CREATE TABLE `schedules` (
  `grade` varchar(11) default NULL,
  `letter` varchar(11) default NULL,
  `weekday` varchar(20) default NULL,
  `lesson` varchar(11) default NULL,
  `subject` varchar(20) default NULL,
  `teacher` varchar(20) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `schedules`
--

LOCK TABLES `schedules` WRITE;
/*!40000 ALTER TABLE `schedules` DISABLE KEYS */;
/*!40000 ALTER TABLE `schedules` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `subjects`
--

DROP TABLE IF EXISTS `subjects`;
CREATE TABLE `subjects` (
  `shortname` varchar(11) default NULL,
  `name` varchar(500) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `subjects`
--

LOCK TABLES `subjects` WRITE;
/*!40000 ALTER TABLE `subjects` DISABLE KEYS */;
INSERT INTO `subjects` VALUES ('M','Mathematik'),('PH','Physik'),('E','Englisch'),('BK','Bildende Kunst'),('D','Deutsch'),('B','Biologie');
/*!40000 ALTER TABLE `subjects` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `teachergrades`
--

DROP TABLE IF EXISTS `teachergrades`;
CREATE TABLE `teachergrades` (
  `teacherShortname` varchar(11) default NULL,
  `grade` varchar(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `teachergrades`
--

LOCK TABLES `teachergrades` WRITE;
/*!40000 ALTER TABLE `teachergrades` DISABLE KEYS */;
INSERT INTO `teachergrades` VALUES ('am','8'),('am','5'),('am','10'),('ws','8'),('ms','9'),('js','8'),('hn','10'),('bg','9'),('ck','5'),('gwb','5'),('hk','10'),('hn','9'),('js','10'),('jst','5'),('kf','9'),('kf','8'),('sbs','8'),('lt','10'),('lt','8'),('ma','10'),('sbs','9'),('sj','10'),('bg','5'),('ws','5');
/*!40000 ALTER TABLE `teachergrades` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `teachers`
--

DROP TABLE IF EXISTS `teachers`;
CREATE TABLE `teachers` (
  `shortname` varchar(100) NOT NULL default '',
  `name` varchar(100) default NULL,
  `lastname` varchar(100) default NULL,
  PRIMARY KEY  (`shortname`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `teachers`
--

LOCK TABLES `teachers` WRITE;
/*!40000 ALTER TABLE `teachers` DISABLE KEYS */;
INSERT INTO `teachers` VALUES ('js','Jannis','Schnitzer'),('ms','Martin','Schend'),('hn','Wolfi','Harnarsch'),('am','Angela','Merkel'),('ws','Wolfgang','Schaeuble'),('gwb','George W.','Bush'),('kf','Kermit','The Frog'),('hk','Ulrich','Heckmann'),('sbs','SeBastian','Schuppel'),('jst','Jan','Stifter'),('ck','Christoph','Kneiszlig'),('lt','Linus','Torvalds'),('sj','Steve','Jobs'),('bg','Billy','Gates'),('ma','Mamma','Mia');
/*!40000 ALTER TABLE `teachers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `teaches`
--

DROP TABLE IF EXISTS `teaches`;
CREATE TABLE `teaches` (
  `teacherShortname` varchar(11) default NULL,
  `subjectId` varchar(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `teaches`
--

LOCK TABLES `teaches` WRITE;
/*!40000 ALTER TABLE `teaches` DISABLE KEYS */;
INSERT INTO `teaches` VALUES ('ws','D'),('am','D'),('am','B'),('ms','E'),('js','E'),('hn','D'),('ws','M'),('ms','PH'),('js','BK'),('gwb','D'),('kf','B'),('kf','M'),('hk','B'),('sbs','PH'),('sbs','BK'),('jst','D'),('ck','PH'),('lt','PH'),('lt','D'),('sj','D'),('sj','E'),('bg','BK'),('bg','M'),('ma','M');
/*!40000 ALTER TABLE `teaches` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2008-02-04 16:12:27