-- phpMyAdmin SQL Dump -- version 2.11.11.1 -- http://www.phpmyadmin.net -- -- Host: mysqlweb.ethz.ch -- Generation Time: May 11, 2015 at 03:31 PM -- Server version: 4.1.18 -- PHP Version: 5.2.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `felixf` -- -- -------------------------------------------------------- -- -- Table structure for table `assistenten` -- CREATE TABLE IF NOT EXISTS `assistenten` ( `PersNr` int(11) NOT NULL default '0', `Name` varchar(30) collate utf8_unicode_ci NOT NULL default '', `Fachgebiet` varchar(30) collate utf8_unicode_ci default NULL, `Boss` int(11) default NULL, PRIMARY KEY (`PersNr`), KEY `Boss` (`Boss`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `assistenten` -- INSERT INTO `assistenten` (`PersNr`, `Name`, `Fachgebiet`, `Boss`) VALUES (3002, 'Platon', 'Ideenlehre', 2125), (3003, 'Aristoteles', 'Syllogistik', 2125), (3004, 'Wittgenstein', 'Sprachtheorie', 2126), (3005, 'Rhetikus', 'Planetenbewegung', 2127), (3006, 'Newton', 'Keplersche Gesetze', 2127), (3007, 'Spinoza', 'Gott und Natur', 2134); -- -------------------------------------------------------- -- -- Table structure for table `hören` -- CREATE TABLE IF NOT EXISTS `hören` ( `Legi` int(11) NOT NULL default '0', `VorlNr` int(11) NOT NULL default '0', PRIMARY KEY (`Legi`,`VorlNr`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `hören` -- INSERT INTO `hören` (`Legi`, `VorlNr`) VALUES (25403, 5022), (26120, 5001), (27550, 4052), (27550, 5001), (28106, 5041), (28106, 5052), (28106, 5216), (28106, 5259), (29120, 5001), (29120, 5041), (29120, 5049), (29555, 5001), (29555, 5022); -- -------------------------------------------------------- -- -- Table structure for table `prüfen` -- CREATE TABLE IF NOT EXISTS `prüfen` ( `Legi` int(11) NOT NULL default '0', `VorlNr` int(11) NOT NULL default '0', `PersNr` int(11) default NULL, `Note` decimal(2,1) default NULL, PRIMARY KEY (`Legi`,`VorlNr`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `prüfen` -- INSERT INTO `prüfen` (`Legi`, `VorlNr`, `PersNr`, `Note`) VALUES (28106, 5001, 2126, 1.0), (25403, 5041, 2125, 2.0), (27550, 4630, 2137, 2.0); -- -------------------------------------------------------- -- -- Table structure for table `professoren` -- CREATE TABLE IF NOT EXISTS `professoren` ( `PersNr` int(11) NOT NULL default '0', `Name` varchar(30) collate utf8_unicode_ci NOT NULL default '', `Rang` varchar(2) collate utf8_unicode_ci default NULL, `Raum` int(11) default NULL, PRIMARY KEY (`PersNr`), UNIQUE KEY `Raum` (`Raum`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `professoren` -- INSERT INTO `professoren` (`PersNr`, `Name`, `Rang`, `Raum`) VALUES (2125, 'Sokrates', 'FP', 226), (2126, 'Russel', 'FP', 232), (2127, 'Kopernikus', 'AP', 310), (2133, 'Popper', 'AP', 52), (2134, 'Augustinus', 'AP', 309), (2136, 'Curie', 'FP', 36), (2137, 'Kant', 'FP', 7); -- -------------------------------------------------------- -- -- Table structure for table `studenten` -- CREATE TABLE IF NOT EXISTS `studenten` ( `Legi` int(11) NOT NULL default '0', `Name` varchar(30) collate utf8_unicode_ci NOT NULL default '', `Semester` int(11) default NULL, PRIMARY KEY (`Legi`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `studenten` -- INSERT INTO `studenten` (`Legi`, `Name`, `Semester`) VALUES (24002, 'Xenokrates', 18), (25403, 'Jonas', 12), (26120, 'Fichte', 10), (26830, 'Aristoxenos', 8), (27550, 'Schopenhauer', 6), (28106, 'Carnap', 3), (29120, 'Theophrastos', 2), (29555, 'Feuerbach', 2), (4711, 'Unbekannter', NULL); -- -------------------------------------------------------- -- -- Table structure for table `voraussetzen` -- CREATE TABLE IF NOT EXISTS `voraussetzen` ( `Vorgänger` int(11) NOT NULL default '0', `Nachfolger` int(11) NOT NULL default '0', PRIMARY KEY (`Vorgänger`,`Nachfolger`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `voraussetzen` -- INSERT INTO `voraussetzen` (`Vorgänger`, `Nachfolger`) VALUES (5001, 5041), (5001, 5043), (5001, 5049), (5041, 5052), (5041, 5216), (5043, 5052), (5052, 5259); -- -------------------------------------------------------- -- -- Table structure for table `vorlesungen` -- CREATE TABLE IF NOT EXISTS `vorlesungen` ( `VorlNr` int(11) NOT NULL default '0', `Titel` varchar(30) collate utf8_unicode_ci default NULL, `KP` int(11) default NULL, `gelesenVon` int(11) default NULL, PRIMARY KEY (`VorlNr`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `vorlesungen` -- INSERT INTO `vorlesungen` (`VorlNr`, `Titel`, `KP`, `gelesenVon`) VALUES (5001, 'Grundzuege', 4, 2137), (5041, 'Ethik', 4, 2125), (5043, 'Erkenntnistheorie', 3, 2126), (5049, 'Maeeutik', 2, 2125), (4052, 'Logik', 4, 2125), (5052, 'Wissenschaftstheorie', 3, 2126), (5216, 'Bioethik', 2, 2126), (5259, 'Der Wiener Kreis', 2, 2133), (5022, 'Glaube und Wissen', 2, 2134), (4630, 'Die 3 Kritiken', 4, 2137);