-- MySQL dump 10.11
--
-- Host: localhost    Database: p2
-- ------------------------------------------------------
-- Server version	5.0.51a-3ubuntu5.4-log

/*!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 `MDE_stoer`
--

DROP TABLE IF EXISTS `MDE_stoer`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `MDE_stoer` (
  `code` bigint(20) NOT NULL,
  `stoergrund` char(50) default NULL,
  `anmerkung` char(50) default NULL,
  `lid` char(15) NOT NULL,
  UNIQUE KEY `codelid` (`lid`,`code`),
  KEY `code` (`code`),
  KEY `lid` (`lid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `MDE_stoer`
--

LOCK TABLES `MDE_stoer` WRITE;
/*!40000 ALTER TABLE `MDE_stoer` DISABLE KEYS */;
INSERT INTO `MDE_stoer` VALUES (1110,'Kupplung','Ofen','460'),(1120,'Synchronisation','Ofen','460'),(1130,'Brenner','Ofen','460'),(1135,'Maschine','Reparatur','460'),(1137,'Ofen','Reparatur','460'),(1140,'Material Wbl.','Blechlauf','460'),(1142,'Material Alu.','Blechlauf','460'),(1150,'Maschine','Reinigen','460'),(1160,'Personal','Unterbesetzt','460'),(1170,'Diverses',NULL,'460'),(1190,'Rüsten','ungeplant','460'),(1210,'Ofen','allgemein','121'),(1220,'Material','Blechlauf','121'),(1230,'Wasser','Feuchtwerk','121'),(1240,'Farbe','Farbwerk','121'),(1250,'Platte','Druckplatte','121'),(1270,'Diverses',NULL,'121'),(1280,'Wartezeit','Material','121'),(1290,'Rüsten','ungeplant','121'),(2010,'Instandhaltung',NULL,'121');
/*!40000 ALTER TABLE `MDE_stoer` 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 2009-01-22 10:31:49