CREATE TABLE `uberweisung` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `Uberweisungsnummer` int(10) NOT NULL,
  `Uberweisungsdatum` date DEFAULT NULL,
  `Uberweisungsbeschreibung` longtext,
  `GesamtbetragDM` decimal(10,2) DEFAULT NULL,
  `HabenDM` decimal(10,2) DEFAULT NULL,
  `SollDM` decimal(10,2) DEFAULT NULL,
  `GesamtbetragEUR` decimal(10,2) DEFAULT NULL,
  `HabenEUR` decimal(10,2) NOT NULL,
  `SollEUR` decimal(10,2) NOT NULL,
  `Kontenbezeichnung` int(10) DEFAULT NULL,
  `KntArt` int(10) DEFAULT NULL,
  `KontoauszugsNr` int(10) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

INSERT INTO `uberweisung` VALUES (0,1,'2008-01-01','Text 1','0.00','0.00','0.00','2.00','0.00','2.00',0,1,NULL),(1,2,'2008-01-02','Text 2','0.00','0.00','0.00','5.00','5.00','0.00',1,1,NULL),(2,3,'2008-01-03','Text3','0.00','0.00','0.00','4.00','0.00','4.00',0,0,NULL),(3,4,'2008-01-04','Text 4','0.00','0.00','0.00','1.00','1.00','0.00',1,0,NULL),(4,5,'2008-01-05','Test5','0.00','0.00','0.00','0.00','0.28','0.00',0,1,NULL),(5,6,'2008-01-06','Test6','0.00','0.00','0.00','0.00','0.00','0.00',2,1,NULL),(6,7,'2008-01-07','Test 7','0.00','0.00','0.00','0.00','0.00','0.00',1,0,NULL),(8,8,'2008-01-08','Test 8','0.00','0.00','0.00','0.00','0.00','0.00',0,0,NULL),(9,9,'2008-01-09','Test9','0.00','0.00','0.00','876.00','0.00','876.00',0,0,NULL);

CREATE TABLE `konten` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `Kontonummer` longtext NOT NULL,
  `Kontoname` longtext,
  `KontoartNr` int(10) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

INSERT INTO `konten` (`ID`, `Kontonummer`, `Kontoname`, `KontoartNr`) VALUES (0,'8000','Gebuehren',NULL),(1,'4000','Kosten',NULL),(2,'1878','abziehb.',NULL),(3,'5000','test',NULL),(4,'5010','test2',NULL),(5,'5020','test3',NULL),(6,'5030','test4',NULL),(7,'5030','test5',NULL);
