DROP TABLE IF EXISTS `tbl_art`;
CREATE TABLE `tbl_art` (
  `ArtID` int(11) NOT NULL default '0',
  `ArtText` char(50) default NULL,
  PRIMARY KEY  (`ArtID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*!40000 ALTER TABLE `tbl_art` DISABLE KEYS */;
LOCK TABLES `tbl_art` WRITE;
INSERT INTO `tbl_art` VALUES (1,'Zweibeiner'),(2,'Vierbeiner'),(3,'Keinbeiner'),(4,'Mehrbeiner');
UNLOCK TABLES;
/*!40000 ALTER TABLE `tbl_art` ENABLE KEYS */;

DROP TABLE IF EXISTS `tbl_bsp`;
CREATE TABLE `tbl_bsp` (
  `bsp_ID` int(11) NOT NULL auto_increment,
  `bsp_artID` int(11) default NULL,
  `bsp_text` char(50) default NULL,
  PRIMARY KEY  (`bsp_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*!40000 ALTER TABLE `tbl_bsp` DISABLE KEYS */;
LOCK TABLES `tbl_bsp` WRITE;
INSERT INTO `tbl_bsp` VALUES (1,1,'Mensch'),(2,1,'Spatz'),(3,1,'Känguruh'),(5,2,'Katze'),(6,2,'Maus'),(7,3,'Schlange (uaah)'),(8,4,'Tausendfüßler'),(9,2,'Kuh'),(12,1,'Affe'),(11,2,'Hirsch'),(13,2,'Fuchs'),(10,2,'Krokodil');
UNLOCK TABLES;
/*!40000 ALTER TABLE `tbl_bsp` ENABLE KEYS */;

