# MySQL-Front Dump 2.5
#
# Host: eis.bru.lan   Database: hobr
# --------------------------------------------------------
# Server version 3.23.47


#
# Table structure for table 'konten'
#

CREATE TABLE konten (
  KtNr_ID smallint(6) unsigned NOT NULL default '0',
  Kontonummer varchar(20) NOT NULL default '0',
  Kontobezeichnung varchar(30) NOT NULL default '0',
  Datum date default '2001-01-01',
  PRIMARY KEY  (KtNr_ID)
) TYPE=MyISAM;



#
# Dumping data for table 'konten'
#

INSERT INTO konten VALUES("20", "45678", "minus", "2001-01-01");
INSERT INTO konten VALUES("35", "268901", "plus", "2001-01-01");
INSERT INTO konten VALUES("40", "9887456AD", "plusminus", "2001-01-01");


#
# Table structure for table 'kumsatz'
#

CREATE TABLE kumsatz (
  KtNr_ID smallint(6) unsigned NOT NULL default '0',
  Datum date NOT NULL default '2001-01-01',
  LfNr_ID smallint(6) unsigned NOT NULL auto_increment,
  Text char(30) default NULL,
  Soll decimal(17,4) default NULL,
  Haben decimal(17,4) default NULL,
  Saldo decimal(17,4) default NULL,
  PRIMARY KEY  (KtNr_ID,Datum,LfNr_ID),
  KEY LfNr (LfNr_ID),
  KEY Datum (Datum)
) TYPE=MyISAM;



#
# Dumping data for table 'kumsatz'
#

INSERT INTO kumsatz VALUES("20", "2001-01-01", "1", "heute", "20.0000", NULL, NULL);
INSERT INTO kumsatz VALUES("35", "2001-01-01", "2", "heute", "26.0000", NULL, NULL);
INSERT INTO kumsatz VALUES("40", "2001-01-01", "3", "morgen", NULL, "3460.0000", NULL);
INSERT INTO kumsatz VALUES("20", "2003-06-14", "4", "machen wir neu", NULL, "30.0000", NULL);
INSERT INTO kumsatz VALUES("20", "2003-06-14", "5", "machen wir neu", NULL, "30.0000", NULL);
INSERT INTO kumsatz VALUES("20", "2003-06-14", "6", "machen wir neu", NULL, "30.0000", NULL);
INSERT INTO kumsatz VALUES("20", "2003-06-14", "7", "machen wir neu", NULL, "30.0000", NULL);
INSERT INTO kumsatz VALUES("20", "2003-06-14", "8", "machen wir neu", NULL, "30.0000", NULL);
INSERT INTO kumsatz VALUES("20", "2003-06-14", "9", "machen wir neu", NULL, "30.0000", NULL);
INSERT INTO kumsatz VALUES("20", "2003-06-14", "10", "machen wir neu", NULL, "30.0000", NULL);
INSERT INTO kumsatz VALUES("20", "2003-06-14", "11", "machen wir neu", NULL, "30.0000", NULL);
INSERT INTO kumsatz VALUES("20", "2003-06-14", "12", "machen wir neu", NULL, "30.0000", NULL);