-- ----------------------------------------------------------------------------
-- MySQL Workbench Migration
-- Migrated Schemata: bustours
-- Source Schemata: bustours
-- Created: Thu Nov 05 15:48:49 2015
-- Workbench Version: 6.3.5
-- ----------------------------------------------------------------------------

SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------------------------------------------------------
-- Schema bustours
-- ----------------------------------------------------------------------------
DROP SCHEMA IF EXISTS `bustours` ;
CREATE SCHEMA IF NOT EXISTS `bustours` ;

-- ----------------------------------------------------------------------------
-- Table bustours.Teilnehmergruppe
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Teilnehmergruppe` (
  `Teilnehmergruppe_Nr` INT(4) NOT NULL,
  `Buchung_Nr` INT(4) NULL,
  `Bezeichnung` CHAR(40) NULL,
  `Summe` DECIMAL(10,2) NULL,
  `Agentur_Nr` INT(4) NULL,
  `Historisch` SMALLINT NULL,
  PRIMARY KEY (`Teilnehmergruppe_Nr`),
  INDEX `XIF39Teilnehmergruppe` (`Buchung_Nr` ASC),
  UNIQUE INDEX `Teilnehmergruppe_Nr` (`Teilnehmergruppe_Nr` ASC),
  CONSTRAINT `Buchung`
    FOREIGN KEY (`Buchung_Nr`)
    REFERENCES `bustours`.`Buchung` (`Buchung_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.pbcatfmt
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`pbcatfmt` (
  `pbf_name` CHAR(30) NOT NULL,
  `pbf_frmt` CHAR(254) NULL,
  `pbf_type` SMALLINT NULL,
  `pbf_cntr` INT(4) NULL,
  UNIQUE INDEX `pbcatf_x` (`pbf_name` ASC));

-- ----------------------------------------------------------------------------
-- Table bustours.Auftrag
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Auftrag` (
  `Beleg_Nr` INT(4) NOT NULL,
  `Kunde_Nr` INT(4) NULL,
  `Buchung_Art` CHAR(1) NULL,
  `Agentur_Nr` INT(4) NULL,
  `Teilnehmergruppe_Nr` INT(4) NULL,
  PRIMARY KEY (`Beleg_Nr`),
  INDEX `XIF8Auftrag` (`Agentur_Nr` ASC),
  INDEX `XIF40Auftrag` (`Teilnehmergruppe_Nr` ASC),
  INDEX `XIF180Auftrag` (`Kunde_Nr` ASC),
  UNIQUE INDEX `Auftrag_Beleg_Nr` (`Beleg_Nr` ASC),
  CONSTRAINT `Agentur`
    FOREIGN KEY (`Agentur_Nr`)
    REFERENCES `bustours`.`Agentur` (`Agentur_Nr`),
  CONSTRAINT `Konto_Beleg`
    FOREIGN KEY (`Beleg_Nr`)
    REFERENCES `bustours`.`Konto_Beleg` (`Beleg_Nr`),
  CONSTRAINT `teilnehmergruppe`
    FOREIGN KEY (`Teilnehmergruppe_Nr`)
    REFERENCES `bustours`.`Teilnehmergruppe` (`Teilnehmergruppe_Nr`),
  CONSTRAINT `XFK_Kunde_Auftrag`
    FOREIGN KEY (`Kunde_Nr`)
    REFERENCES `bustours`.`Kunde` (`Kunde_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.Archiv_Teilnehmer
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Archiv_Teilnehmer` (
  `Teilnehmer_Nr` INT(4) NOT NULL,
  `Termin_Nr` INT(4) NOT NULL,
  `Kunde_Nr` INT(4) NULL,
  PRIMARY KEY (`Teilnehmer_Nr`),
  INDEX `XIF7Archiv_Teilnehmer` (`Termin_Nr` ASC),
  INDEX `XIF46Archiv_Teilnehmer` (`Termin_Nr` ASC),
  INDEX `XIF43Buchung_History` (`Kunde_Nr` ASC),
  INDEX `XIF184Archiv_Teilnehmer` (`Kunde_Nr` ASC),
  UNIQUE INDEX `XPKHistorie_Teilnehmer` (`Teilnehmer_Nr` ASC),
  CONSTRAINT `archiv_termin`
    FOREIGN KEY (`Termin_Nr`)
    REFERENCES `bustours`.`Archiv_Termin` (`Termin_Nr`),
  CONSTRAINT `XFK_Kunde_Archiv_TN`
    FOREIGN KEY (`Kunde_Nr`)
    REFERENCES `bustours`.`Kunde` (`Kunde_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.Temp_Adresse
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Temp_Adresse` (
  `Adresse_Nr` INT(4) NOT NULL,
  `User_Id` CHAR(20) NOT NULL,
  `Anrede_Nr` INT(4) NULL,
  `Name_2` CHAR(30) NULL,
  `Name_1` CHAR(30) NULL,
  `Name_3` CHAR(30) NULL,
  `Strasse` CHAR(30) NULL,
  `Ort` CHAR(30) NULL,
  `Plz` CHAR(10) NULL,
  `Datum_Aufnahme` DATE NULL,
  `Bemerkung` LONGTEXT NULL,
  `Teilnehmergruppe_Nr` INT(4) NULL,
  `Leerdatensatz` SMALLINT NULL,
  PRIMARY KEY (`Adresse_Nr`, `User_Id`),
  UNIQUE INDEX `XPKTemp_Adresse` (`User_Id` ASC, `Adresse_Nr` ASC));

-- ----------------------------------------------------------------------------
-- Table bustours.Bus_Daten
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Bus_Daten` (
  `Bus_Nr` INT(4) NOT NULL,
  `Bezeichnung` CHAR(30) NULL,
  `Kennzeichen` CHAR(10) NULL,
  `Standort` CHAR(25) NULL,
  `Platzanzahl` SMALLINT NULL,
  PRIMARY KEY (`Bus_Nr`),
  UNIQUE INDEX `Bus_Nr` (`Bus_Nr` ASC));

-- ----------------------------------------------------------------------------
-- Table bustours.Einstellung
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Einstellung` (
  `Einstellung_Nr` INT(4) NOT NULL,
  `Konto_Nr_Kasse` INT(4) NULL,
  `Konto_Nr_Bank_Kasse` INT(4) NULL,
  `Konto_Nr_Agentur` INT(4) NULL,
  `Konto_Nr_Provision` INT(4) NULL,
  `Konto_Nr_MWST` INT(4) NULL,
  `Konto_Nr_Bank_Kunde` INT(4) NULL,
  `Konto_Nr_Reise` INT(4) NULL,
  `Waehrung` CHAR(3) NULL,
  `MWSt` DECIMAL(5,2) NULL,
  `Umrech_Faktor` DECIMAL(8,5) NULL,
  `agentur_default` INT(4) NULL,
  `Druckkopie_Beleg` SMALLINT NULL,
  `Buchung_Waehrung` CHAR(3) NULL,
  `Provision_default` DECIMAL(5,2) NULL,
  PRIMARY KEY (`Einstellung_Nr`),
  UNIQUE INDEX `XPKEinstellung` (`Einstellung_Nr` ASC));

-- ----------------------------------------------------------------------------
-- Table bustours.Konto_KT
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Konto_KT` (
  `Konto_KT_Nr` INT(4) NOT NULL,
  `Bezeichnung` CHAR(50) NULL,
  PRIMARY KEY (`Konto_KT_Nr`),
  UNIQUE INDEX `Konto_KT_Nr` (`Konto_KT_Nr` ASC));

-- ----------------------------------------------------------------------------
-- Table bustours.Archiv_Termin
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Archiv_Termin` (
  `Termin_Nr` INT(4) NOT NULL,
  `Reise_Nr` INT(4) NOT NULL,
  `von` DATE NULL,
  `bis` DATE NULL,
  PRIMARY KEY (`Termin_Nr`),
  INDEX `XIF6Archiv_Termin` (`Reise_Nr` ASC),
  INDEX `XIF45Termin_History` (`Reise_Nr` ASC),
  UNIQUE INDEX `XPKTermin_History` (`Termin_Nr` ASC),
  CONSTRAINT `archiv_reise`
    FOREIGN KEY (`Reise_Nr`)
    REFERENCES `bustours`.`Archiv_Reise` (`Reise_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.pbcatvld
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`pbcatvld` (
  `pbv_name` CHAR(30) NOT NULL,
  `pbv_vald` CHAR(254) NULL,
  `pbv_type` SMALLINT NULL,
  `pbv_cntr` INT(4) NULL,
  `pbv_msg` CHAR(254) NULL,
  UNIQUE INDEX `pbcatv_x` (`pbv_name` ASC));

-- ----------------------------------------------------------------------------
-- Table bustours.Reservierung
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Reservierung` (
  `Reservierung_Nr` INT(4) NOT NULL,
  `Buchung_Nr` INT(4) NULL,
  `Expedient` CHAR(3) NULL,
  `Datum` DATE NULL,
  `Name` CHAR(30) NULL,
  `Sitzplatz` CHAR(6) NULL,
  `Zimmer_Nr` INT(4) NULL,
  `Kabine_Nr` INT(4) NULL,
  PRIMARY KEY (`Reservierung_Nr`),
  INDEX `XIF53Reservierung` (`Kabine_Nr` ASC),
  INDEX `XIF52Reservierung` (`Zimmer_Nr` ASC),
  INDEX `XIF33Reservierung` (`Buchung_Nr` ASC),
  UNIQUE INDEX `XPKReservierung` (`Reservierung_Nr` ASC),
  CONSTRAINT `Reservierung__Buchung`
    FOREIGN KEY (`Buchung_Nr`)
    REFERENCES `bustours`.`Buchung` (`Buchung_Nr`),
  CONSTRAINT `XFK_Reserv_Kabine`
    FOREIGN KEY (`Kabine_Nr`)
    REFERENCES `bustours`.`Kabine` (`Kabine_Nr`),
  CONSTRAINT `XFK_Reserv_Zimmer`
    FOREIGN KEY (`Zimmer_Nr`)
    REFERENCES `bustours`.`Zimmer` (`Zimmer_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.Route_template
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Route_template` (
  `Route_Nr` INT(4) NOT NULL,
  `Anbieter_Nr` INT(4) NULL,
  `Start_Ende_Haltepunkt_Nr` INT(4) NULL,
  `Route` CHAR(50) NULL,
  `Route_Typ_Nr` INT(4) NULL,
  PRIMARY KEY (`Route_Nr`),
  INDEX `XIF213Route_template` (`Anbieter_Nr` ASC),
  INDEX `XIF212Route_template` (`Start_Ende_Haltepunkt_Nr` ASC),
  UNIQUE INDEX `PK_Route_Nr` (`Route_Nr` ASC),
  CONSTRAINT `FK_ROUTE_TE_ANBIETER_ANBIETER`
    FOREIGN KEY (`Anbieter_Nr`)
    REFERENCES `bustours`.`Anbieter` (`Anbieter_Nr`),
  CONSTRAINT `FK_ROUTE_TE_START_END_HALTEPUN`
    FOREIGN KEY (`Start_Ende_Haltepunkt_Nr`)
    REFERENCES `bustours`.`Haltepunkt_template` (`Haltepunkt_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.Preis
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Preis` (
  `Preis_Nr` INT(4) NOT NULL,
  `Reise_Nr` INT(4) NULL,
  `Preis` DECIMAL(10,2) NULL,
  `Bezeichnung` CHAR(50) NULL,
  `Personenbezug` SMALLINT NULL,
  `Preis_Typ` TINYINT(1) NULL,
  `Rabatt` TINYINT(1) NULL,
  `Provision` TINYINT(1) NULL,
  PRIMARY KEY (`Preis_Nr`),
  INDEX `XIF31Preis` (`Reise_Nr` ASC),
  UNIQUE INDEX `Preis_Nr` (`Preis_Nr` ASC),
  CONSTRAINT `Reise`
    FOREIGN KEY (`Reise_Nr`)
    REFERENCES `bustours`.`Reise` (`Reise_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.Reise
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Reise` (
  `Reise_Nr` INT(4) NOT NULL,
  `Anbieter_Nr` INT(4) NULL,
  `Land_Nr` INT(4) NULL,
  `Kurzform` CHAR(10) NULL,
  `Titel` CHAR(30) NULL,
  `Gebiet` CHAR(30) NULL,
  `Ort` CHAR(30) NULL,
  `Zimmervergabe` SMALLINT NULL,
  `Kabinenvergabe` SMALLINT NULL,
  PRIMARY KEY (`Reise_Nr`),
  INDEX `XIF29Reise` (`Land_Nr` ASC),
  INDEX `XIF28Reise` (`Anbieter_Nr` ASC),
  UNIQUE INDEX `Reise_Nr` (`Reise_Nr` ASC),
  UNIQUE INDEX `Kurzform` (`Kurzform` ASC),
  CONSTRAINT `Land`
    FOREIGN KEY (`Land_Nr`)
    REFERENCES `bustours`.`Land` (`Land_Nr`),
  CONSTRAINT `Anbieter`
    FOREIGN KEY (`Anbieter_Nr`)
    REFERENCES `bustours`.`Anbieter` (`Anbieter_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.Anrede
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Anrede` (
  `Anrede_Nr` INT(4) NOT NULL,
  `Anrede` CHAR(15) NULL,
  PRIMARY KEY (`Anrede_Nr`),
  UNIQUE INDEX `Anrede_Nr` (`Anrede_Nr` ASC));

-- ----------------------------------------------------------------------------
-- Table bustours.Kommunikation
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Kommunikation` (
  `Kommunikation_Nr` INT(4) NOT NULL,
  `Adresse_Nr` INT(4) NOT NULL,
  `Kommunikation_Art_Nr` INT(4) NULL,
  `Kommunikation` CHAR(30) NULL,
  PRIMARY KEY (`Kommunikation_Nr`, `Adresse_Nr`),
  INDEX `XIF178Kommunikation` (`Adresse_Nr` ASC),
  INDEX `XIF121Kommunikation` (`Kommunikation_Art_Nr` ASC),
  UNIQUE INDEX `XPKKommunikation` (`Adresse_Nr` ASC, `Kommunikation_Nr` ASC),
  CONSTRAINT `XFK_Adr_Kom`
    FOREIGN KEY (`Adresse_Nr`)
    REFERENCES `bustours`.`adresse` (`adresse_nr`),
  CONSTRAINT `XFK_Komm_Komm_Art`
    FOREIGN KEY (`Kommunikation_Art_Nr`)
    REFERENCES `bustours`.`Kommunikation_Art` (`Kommunikation_Art_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.Archiv_Konto
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Archiv_Konto` (
  `Konto_Nr` INT(4) NOT NULL,
  `Kategorie_Nr` INT(4) NULL,
  `Bezeichnung` CHAR(50) NULL,
  `abschluss` TINYINT(1) NULL,
  PRIMARY KEY (`Konto_Nr`),
  INDEX `XIF60Archiv_Konto` (`Kategorie_Nr` ASC),
  INDEX `XIF19Archiv_Konto` (`Kategorie_Nr` ASC),
  UNIQUE INDEX `XPKArchiv_Konto` (`Konto_Nr` ASC),
  CONSTRAINT `Konto_Kategorie`
    FOREIGN KEY (`Kategorie_Nr`)
    REFERENCES `bustours`.`Konto_Kategorie` (`Kategorie_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.Kontingent_Kabine
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Kontingent_Kabine` (
  `Buchung_Nr` INT(4) NOT NULL,
  `Kabine_Nr` INT(4) NOT NULL,
  `Kontingent` SMALLINT NOT NULL,
  `Expedient` CHAR(3) NULL,
  `Modifikation_Dat` DATE NULL,
  `Option_Ablauf_Dat` DATE NULL,
  `Bemerkung` VARCHAR(255) NULL,
  PRIMARY KEY (`Buchung_Nr`, `Kabine_Nr`),
  INDEX `XIF50Kontingent_Kabine` (`Kabine_Nr` ASC),
  INDEX `XIF48Kontingent_Kabine` (`Buchung_Nr` ASC),
  UNIQUE INDEX `XPKKontingent_Kabine` (`Kabine_Nr` ASC, `Buchung_Nr` ASC),
  CONSTRAINT `XFK_KK_Kabine`
    FOREIGN KEY (`Kabine_Nr`)
    REFERENCES `bustours`.`Kabine` (`Kabine_Nr`),
  CONSTRAINT `XFK_KK_Buchung`
    FOREIGN KEY (`Buchung_Nr`)
    REFERENCES `bustours`.`Buchung` (`Buchung_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.Konto_Buchung
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Konto_Buchung` (
  `Konto_Nr` INT(4) NOT NULL,
  `Beleg_Nr` INT(4) NOT NULL,
  `Konto_Nr_Gegen` INT(4) NULL,
  `Konto_KT_Nr_Gegen` INT(4) NULL,
  `Haben_DEM` DECIMAL(10,2) NULL,
  `Soll_DEM` DECIMAL(10,2) NULL,
  `Soll_EUR` DECIMAL(10,2) NULL,
  `Haben_EUR` DECIMAL(10,2) NULL,
  PRIMARY KEY (`Konto_Nr`, `Beleg_Nr`),
  INDEX `XIF15Konto_Buchung` (`Konto_Nr` ASC),
  INDEX `XIF14Konto_Buchung` (`Beleg_Nr` ASC),
  UNIQUE INDEX `XPKKonto_Buchung` (`Beleg_Nr` ASC, `Konto_Nr` ASC),
  CONSTRAINT `Konto`
    FOREIGN KEY (`Konto_Nr`)
    REFERENCES `bustours`.`Konto` (`Konto_Nr`),
  CONSTRAINT `Konto_Buchung__Konto_Beleg`
    FOREIGN KEY (`Beleg_Nr`)
    REFERENCES `bustours`.`Konto_Beleg` (`Beleg_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.Konto_Beleg
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Konto_Beleg` (
  `Beleg_Nr` INT(4) NOT NULL,
  `Buchung_Art_Nr` INT(4) NULL,
  `Expedient` CHAR(15) NOT NULL,
  `Datum` DATE NULL,
  `Name` CHAR(30) NULL,
  `Bezeichnung` CHAR(100) NULL,
  `Haben_DEM` DECIMAL(10,2) NULL,
  `Soll_DEM` DECIMAL(10,2) NULL,
  `Scheck` SMALLINT NULL,
  `Scheck_Nr` CHAR(20) NULL,
  `Soll_EUR` DECIMAL(10,2) NULL,
  `Haben_EUR` DECIMAL(10,2) NULL,
  `Einheit` CHAR(3) NULL,
  PRIMARY KEY (`Beleg_Nr`),
  UNIQUE INDEX `beleg_nr` (`Beleg_Nr` ASC),
  CONSTRAINT `Konto_Buchung_Art`
    FOREIGN KEY (`Buchung_Art_Nr`)
    REFERENCES `bustours`.`Konto_Buchung_Art` (`Buchung_Art_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.Archiv_Konto_Buchung
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Archiv_Konto_Buchung` (
  `Beleg_Nr` INT(4) NOT NULL,
  `Konto_Nr` INT(4) NOT NULL,
  `Konto_Nr_Gegen` INT(4) NULL,
  `Konto_KT_Nr_Gegen` INT(4) NULL,
  `Haben_DEM` DECIMAL(10,2) NULL,
  `Soll_DEM` DECIMAL(10,2) NULL,
  `Soll_EUR` DECIMAL(10,2) NULL,
  `Haben_EUR` DECIMAL(10,2) NULL,
  PRIMARY KEY (`Beleg_Nr`, `Konto_Nr`),
  INDEX `XIF59Archiv_Konto_Buchung` (`Konto_Nr` ASC),
  INDEX `XIF58Archiv_Konto_Buchung` (`Beleg_Nr` ASC),
  INDEX `XIF3Archiv_Konto_Buchung` (`Beleg_Nr` ASC),
  INDEX `XIF2Archiv_Konto_Buchung` (`Konto_Nr` ASC),
  UNIQUE INDEX `XPKArchiv_Konto_Buchung` (`Beleg_Nr` ASC, `Konto_Nr` ASC),
  CONSTRAINT `Archiv_Konto`
    FOREIGN KEY (`Konto_Nr`)
    REFERENCES `bustours`.`Archiv_Konto` (`Konto_Nr`),
  CONSTRAINT `Archiv_Konto_Beleg`
    FOREIGN KEY (`Beleg_Nr`)
    REFERENCES `bustours`.`Archiv_Konto_Beleg` (`Beleg_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.Anbieter_Agentur_Kopplung
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Anbieter_Agentur_Kopplung` (
  `Agentur_Nr` INT(4) NOT NULL,
  `Anbieter_Nr` INT(4) NOT NULL,
  `Provision` DECIMAL(5,2) NULL,
  PRIMARY KEY (`Agentur_Nr`, `Anbieter_Nr`),
  INDEX `XIF219Anbieter_Agentur_Kopplung` (`Anbieter_Nr` ASC),
  INDEX `XIF218Anbieter_Agentur_Kopplung` (`Agentur_Nr` ASC),
  UNIQUE INDEX `XPKAnbieter_Agentur_Kopplung` (`Agentur_Nr` ASC, `Anbieter_Nr` ASC),
  CONSTRAINT `FK_Agentur_Anbieter`
    FOREIGN KEY (`Agentur_Nr`)
    REFERENCES `bustours`.`Agentur` (`Agentur_Nr`),
  CONSTRAINT `FK_Anbieter_Agentur`
    FOREIGN KEY (`Anbieter_Nr`)
    REFERENCES `bustours`.`Anbieter` (`Anbieter_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.Bus_Platzzuordnung
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Bus_Platzzuordnung` (
  `Bus_Nr` INT(4) NOT NULL,
  `_1rf` SMALLINT NULL,
  `_1rg` SMALLINT NULL,
  `_1lg` SMALLINT NULL,
  `_1lf` SMALLINT NULL,
  `_2rf` SMALLINT NULL,
  `_2rg` SMALLINT NULL,
  `_2lf` SMALLINT NULL,
  `_3rf` SMALLINT NULL,
  `_3rg` SMALLINT NULL,
  `_3lg` SMALLINT NULL,
  `_3lf` SMALLINT NULL,
  `_4rf` SMALLINT NULL,
  `_4rg` SMALLINT NULL,
  `_4lg` SMALLINT NULL,
  `_4lf` SMALLINT NULL,
  `_5rf` SMALLINT NULL,
  `_5rg` SMALLINT NULL,
  `_5lg` SMALLINT NULL,
  `_5lf` SMALLINT NULL,
  `_6rf` SMALLINT NULL,
  `_6rg` SMALLINT NULL,
  `_6lg` SMALLINT NULL,
  `_6lf` SMALLINT NULL,
  `_7rf` SMALLINT NULL,
  `_7rg` SMALLINT NULL,
  `_7lg` SMALLINT NULL,
  `_7lf` SMALLINT NULL,
  `_8rf` SMALLINT NULL,
  `_8rg` SMALLINT NULL,
  `_8lg` SMALLINT NULL,
  `_8lf` SMALLINT NULL,
  `_9rf` SMALLINT NULL,
  `_9rg` SMALLINT NULL,
  `_9lg` SMALLINT NULL,
  `_9lf` SMALLINT NULL,
  `_10rf` SMALLINT NULL,
  `_10rg` SMALLINT NULL,
  `_10lg` SMALLINT NULL,
  `_10lf` SMALLINT NULL,
  `_11rf` SMALLINT NULL,
  `_11rg` SMALLINT NULL,
  `_11lg` SMALLINT NULL,
  `_11lf` SMALLINT NULL,
  `_12rf` SMALLINT NULL,
  `_12rg` SMALLINT NULL,
  `_12lg` SMALLINT NULL,
  `_12lf` SMALLINT NULL,
  `_13rf` SMALLINT NULL,
  `_13rg` SMALLINT NULL,
  `_13lg` SMALLINT NULL,
  `_13lf` SMALLINT NULL,
  `_13m` SMALLINT NULL,
  `_14rf` SMALLINT NULL,
  `_14rg` SMALLINT NULL,
  `_14lg` SMALLINT NULL,
  `_14lf` SMALLINT NULL,
  `_14m` SMALLINT NULL,
  `_2lg` SMALLINT NULL,
  `_15lf` SMALLINT NULL,
  `_15lg` SMALLINT NULL,
  `_15rf` SMALLINT NULL,
  `_15rg` SMALLINT NULL,
  `_15m` SMALLINT NULL,
  `_16lf` SMALLINT NULL,
  `_16lg` SMALLINT NULL,
  `_16rf` SMALLINT NULL,
  `_16rg` SMALLINT NULL,
  `_16m` SMALLINT NULL,
  `_17lf` SMALLINT NULL,
  `_17lg` SMALLINT NULL,
  `_17rf` SMALLINT NULL,
  `_17rg` SMALLINT NULL,
  `_17m` SMALLINT NULL,
  `_18lf` SMALLINT NULL,
  `_18lg` SMALLINT NULL,
  `_18rf` SMALLINT NULL,
  `_18rg` SMALLINT NULL,
  `_18m` SMALLINT NULL,
  PRIMARY KEY (`Bus_Nr`),
  UNIQUE INDEX `Bus_Platzzuordnung_Bus_Nr` (`Bus_Nr` ASC),
  CONSTRAINT `Bus_Daten`
    FOREIGN KEY (`Bus_Nr`)
    REFERENCES `bustours`.`Bus_Daten` (`Bus_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.Leistung_Fremd
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Leistung_Fremd` (
  `Fremdleistung_Nr` INT(4) NOT NULL,
  `Preis_Nr` INT(4) NULL,
  `Fremdleistung` VARCHAR(50) NULL,
  `Anbieter_FL_Nr` INT(4) NULL,
  `Anbieter_Nr` INT(4) NULL,
  `Tarifcode` VARCHAR(10) NULL,
  `Betrag_min` DECIMAL(10,2) NULL,
  `Betrag_max` DECIMAL(10,2) NULL,
  PRIMARY KEY (`Fremdleistung_Nr`),
  INDEX `XIF76Leistung_Fremd` (`Anbieter_Nr` ASC),
  INDEX `XIF71Leistung_Fremd` (`Preis_Nr` ASC),
  UNIQUE INDEX `XPKLeistung_Fremd` (`Fremdleistung_Nr` ASC),
  UNIQUE INDEX `XPKFremdleistung` (`Fremdleistung_Nr` ASC),
  CONSTRAINT `Preis`
    FOREIGN KEY (`Preis_Nr`)
    REFERENCES `bustours`.`Preis` (`Preis_Nr`),
  CONSTRAINT `Leistung_Fremd__Anbieter`
    FOREIGN KEY (`Anbieter_Nr`)
    REFERENCES `bustours`.`Anbieter` (`Anbieter_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.Archiv_Konto_KT
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Archiv_Konto_KT` (
  `Konto_KT_Nr` INT(4) NOT NULL,
  `Bezeichnung` CHAR(50) NULL,
  PRIMARY KEY (`Konto_KT_Nr`),
  UNIQUE INDEX `XPKArchiv_Konto_KT` (`Konto_KT_Nr` ASC));

-- ----------------------------------------------------------------------------
-- Table bustours.Archiv_Konto_Beleg
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Archiv_Konto_Beleg` (
  `Beleg_Nr` INT(4) NOT NULL,
  `Buchung_Art_Nr` INT(4) NULL,
  `Expedient` CHAR(15) NULL,
  `Datum` DATE NULL,
  `Name` CHAR(30) NULL,
  `Bezeichnung` CHAR(100) NULL,
  `Haben_DEM` DECIMAL(10,2) NULL,
  `Soll_DEM` DECIMAL(10,2) NULL,
  `Scheck` SMALLINT NULL,
  `Scheck_Nr` CHAR(20) NULL,
  `Einheit` CHAR(3) NULL,
  `Soll_EUR` DECIMAL(10,2) NULL,
  `Haben_EUR` DECIMAL(10,2) NULL,
  PRIMARY KEY (`Beleg_Nr`),
  INDEX `XIF57Archiv_Konto_Beleg` (`Buchung_Art_Nr` ASC),
  INDEX `XIF17Archiv_Konto_Beleg` (`Buchung_Art_Nr` ASC),
  UNIQUE INDEX `XPKArchiv_Konto_Beleg` (`Beleg_Nr` ASC),
  CONSTRAINT `Archiv_Konto_Beleg__Konto_Buchung_Art`
    FOREIGN KEY (`Buchung_Art_Nr`)
    REFERENCES `bustours`.`Konto_Buchung_Art` (`Buchung_Art_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.Briefanrede
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Briefanrede` (
  `Briefanrede_Nr` SMALLINT NOT NULL,
  `Briefanrede` CHAR(50) NULL,
  PRIMARY KEY (`Briefanrede_Nr`),
  UNIQUE INDEX `XPKBriefanrede` (`Briefanrede_Nr` ASC));

-- ----------------------------------------------------------------------------
-- Table bustours.Route
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Route` (
  `Route_Nr` INT(4) NOT NULL,
  `Anbieter_Nr` INT(4) NULL,
  `Buchung_Nr` INT(4) NULL,
  `Start_Ende_Haltepunkt_Nr` INT(4) NULL,
  `Route` CHAR(50) NULL,
  `Route_Typ_Nr` INT(4) NULL,
  PRIMARY KEY (`Route_Nr`),
  INDEX `XIF216Route` (`Buchung_Nr` ASC),
  UNIQUE INDEX `Haltepunkt_Nr` (`Route_Nr` ASC),
  CONSTRAINT `FK_ROUTE_BUCHUNG_BUCHUNG`
    FOREIGN KEY (`Buchung_Nr`)
    REFERENCES `bustours`.`Buchung` (`Buchung_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.Kommunikation_Art
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Kommunikation_Art` (
  `Kommunikation_Art_Nr` INT(4) NOT NULL,
  `Kommunikation_Bez` CHAR(30) NULL,
  PRIMARY KEY (`Kommunikation_Art_Nr`),
  UNIQUE INDEX `XPKKommunikation_Art` (`Kommunikation_Art_Nr` ASC));

-- ----------------------------------------------------------------------------
-- Table bustours.Titel
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Titel` (
  `Titel_Nr` INT(4) NOT NULL,
  `Titel` CHAR(50) NULL,
  PRIMARY KEY (`Titel_Nr`),
  UNIQUE INDEX `XPKTitel` (`Titel_Nr` ASC));

-- ----------------------------------------------------------------------------
-- Table bustours.Archiv_Konto_KT_Kopplung
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Archiv_Konto_KT_Kopplung` (
  `Konto_KT_Nr` INT(4) NOT NULL,
  `Konto_Nr` INT(4) NOT NULL,
  PRIMARY KEY (`Konto_KT_Nr`, `Konto_Nr`),
  INDEX `XIF5Archiv_Konto_KT_Kopplung` (`Konto_KT_Nr` ASC),
  INDEX `XIF54Archiv_Konto_KT_Kopplung` (`Konto_Nr` ASC),
  INDEX `XIF53Archiv_Konto_KT_Kopplung` (`Konto_KT_Nr` ASC),
  INDEX `XIF4Archiv_Konto_KT_Kopplung` (`Konto_Nr` ASC),
  UNIQUE INDEX `XPKArchiv_Konto_KT_Kopplung` (`Konto_Nr` ASC, `Konto_KT_Nr` ASC),
  CONSTRAINT `Archiv_Konto_KT_Kopplung__Archiv_Konto`
    FOREIGN KEY (`Konto_Nr`)
    REFERENCES `bustours`.`Archiv_Konto` (`Konto_Nr`),
  CONSTRAINT `Archiv_Konto_KT`
    FOREIGN KEY (`Konto_KT_Nr`)
    REFERENCES `bustours`.`Archiv_Konto_KT` (`Konto_KT_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.Teilnehmer
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Teilnehmer` (
  `Teilnehmer_Nr` INT(4) NOT NULL,
  `Teilnehmergruppe_Nr` INT(4) NOT NULL,
  `Kunde_Nr` INT(4) NULL,
  `Sitzplatz` CHAR(6) NULL,
  `Zimmer_Nr` INT(4) NULL,
  `Kabine_Nr` INT(4) NULL,
  `Haltepunkt_Nr` INT(4) NULL,
  `Abfahrt_Nr` INT(4) NULL,
  PRIMARY KEY (`Teilnehmer_Nr`),
  INDEX `XIF46Teilnehmer` (`Zimmer_Nr` ASC),
  INDEX `XIF41Teilnehmer` (`Teilnehmergruppe_Nr` ASC),
  INDEX `XIF34Teilnehmer` (`Kabine_Nr` ASC),
  INDEX `XIF214Teilnehmer` (`Haltepunkt_Nr` ASC),
  INDEX `XIF181Teilnehmer` (`Kunde_Nr` ASC),
  UNIQUE INDEX `Teilnehmer_Nr` (`Teilnehmer_Nr` ASC),
  CONSTRAINT `FK_TN_HP`
    FOREIGN KEY (`Haltepunkt_Nr`)
    REFERENCES `bustours`.`Haltepunkt` (`Haltepunkt_Nr`),
  CONSTRAINT `XFK_Kunde_TN`
    FOREIGN KEY (`Kunde_Nr`)
    REFERENCES `bustours`.`Kunde` (`Kunde_Nr`),
  CONSTRAINT `XFK_TN_Kabine`
    FOREIGN KEY (`Kabine_Nr`)
    REFERENCES `bustours`.`Kabine` (`Kabine_Nr`),
  CONSTRAINT `XFK_TN_Zimmer`
    FOREIGN KEY (`Zimmer_Nr`)
    REFERENCES `bustours`.`Zimmer` (`Zimmer_Nr`),
  CONSTRAINT `Teilnehmer__Teilnehmergruppe`
    FOREIGN KEY (`Teilnehmergruppe_Nr`)
    REFERENCES `bustours`.`Teilnehmergruppe` (`Teilnehmergruppe_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.Agentur
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Agentur` (
  `Agentur_Nr` INT(4) NOT NULL,
  `Kurzform` CHAR(5) NULL,
  `Agentur` CHAR(30) NULL,
  `Strasse` CHAR(30) NULL,
  `Ort` CHAR(30) NULL,
  `Plz` CHAR(10) NULL,
  `Telefon` CHAR(20) NULL,
  `Fax` CHAR(20) NULL,
  `Ansprechpartner_Nr` INT(4) NULL,
  `Bemerkung` LONGTEXT NULL,
  `Konto_Nr` INT(4) NULL,
  `Zweigstelle` SMALLINT NULL,
  `Konto_KT_Nr` INT(4) NULL,
  `Konto_FL_Nr` INT(4) NULL,
  `Konto_KT_FL_Nr` INT(4) NULL,
  PRIMARY KEY (`Agentur_Nr`),
  INDEX `XIF89Agentur` (`Konto_KT_Nr` ASC),
  INDEX `XIF69Agentur` (`Konto_Nr` ASC),
  INDEX `XIF222Agentur` (`Konto_KT_FL_Nr` ASC),
  INDEX `XIF221Agentur` (`Konto_FL_Nr` ASC),
  UNIQUE INDEX `Agentur_Nr` (`Agentur_Nr` ASC),
  CONSTRAINT `XFK_K_KT_Agentur`
    FOREIGN KEY (`Konto_KT_Nr`)
    REFERENCES `bustours`.`Konto_KT` (`Konto_KT_Nr`),
  CONSTRAINT `FK_Konto_FL_Agentur`
    FOREIGN KEY (`Konto_FL_Nr`)
    REFERENCES `bustours`.`Konto` (`Konto_Nr`),
  CONSTRAINT `FK_Konto_FL_KT_Agentur`
    FOREIGN KEY (`Konto_KT_FL_Nr`)
    REFERENCES `bustours`.`Konto_KT` (`Konto_KT_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.Haltepunkt_template
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Haltepunkt_template` (
  `Haltepunkt_Nr` INT(4) NOT NULL,
  `Haltepunkt` CHAR(50) NULL,
  `Preis_Nr` INT(4) NULL,
  `Abfahrt_Zuschlag` INT(4) NULL,
  PRIMARY KEY (`Haltepunkt_Nr`),
  INDEX `XIF217Haltepunkt_template` (`Preis_Nr` ASC),
  UNIQUE INDEX `Haltepunkt_Nr` (`Haltepunkt_Nr` ASC),
  CONSTRAINT `FK_HALTEPUN_PREIS_PREIS`
    FOREIGN KEY (`Preis_Nr`)
    REFERENCES `bustours`.`Preis` (`Preis_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.Buchung
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Buchung` (
  `Buchung_Nr` INT(4) NOT NULL,
  `Reise_Nr` INT(4) NULL,
  `Termin_Nr` INT(4) NULL,
  `Bus_Nr` INT(4) NULL,
  `Konto_Nr` INT(4) NULL,
  `Konto_KT_Nr` INT(4) NULL,
  PRIMARY KEY (`Buchung_Nr`),
  INDEX `XIF9Buchung` (`Bus_Nr` ASC),
  INDEX `XIF62Buchung` (`Konto_KT_Nr` ASC),
  INDEX `XIF43Buchung` (`Reise_Nr` ASC, `Termin_Nr` ASC),
  INDEX `XIF32Buchung` (`Reise_Nr` ASC),
  INDEX `XIF20Buchung` (`Konto_KT_Nr` ASC),
  UNIQUE INDEX `Buchung_Nr` (`Buchung_Nr` ASC),
  CONSTRAINT `Buchung__Reise`
    FOREIGN KEY (`Reise_Nr`)
    REFERENCES `bustours`.`Reise` (`Reise_Nr`),
  CONSTRAINT `Termin`
    FOREIGN KEY (`Termin_Nr` , `Reise_Nr`)
    REFERENCES `bustours`.`Termin` (`Termin_Nr` , `Reise_Nr`),
  CONSTRAINT `Konto_KT`
    FOREIGN KEY (`Konto_KT_Nr`)
    REFERENCES `bustours`.`Konto_KT` (`Konto_KT_Nr`),
  CONSTRAINT `Buchung__Bus_Daten`
    FOREIGN KEY (`Bus_Nr`)
    REFERENCES `bustours`.`Bus_Daten` (`Bus_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.Zahlung_Fremd
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Zahlung_Fremd` (
  `Zahlung_Fremd_Nr` INT(4) NOT NULL,
  `Kunde_Nr` INT(4) NULL,
  `Teilnehmergruppe_Nr` INT(4) NULL,
  `Preis_Nr` INT(4) NULL,
  `Faktor` SMALLINT NULL,
  `Preis_Betrag` DECIMAL(10,2) NULL,
  PRIMARY KEY (`Zahlung_Fremd_Nr`),
  INDEX `XIF79Zahlung_Fremd` (`Teilnehmergruppe_Nr` ASC),
  INDEX `XIF77Zahlung_Fremd` (`Preis_Nr` ASC),
  INDEX `XIF182Zahlung_Fremd` (`Kunde_Nr` ASC),
  UNIQUE INDEX `XPKZahlung_Fremd` (`Zahlung_Fremd_Nr` ASC),
  CONSTRAINT `XFK_TG_Z_F`
    FOREIGN KEY (`Teilnehmergruppe_Nr`)
    REFERENCES `bustours`.`Teilnehmergruppe` (`Teilnehmergruppe_Nr`),
  CONSTRAINT `XFL_Preis_Z_F`
    FOREIGN KEY (`Preis_Nr`)
    REFERENCES `bustours`.`Preis` (`Preis_Nr`),
  CONSTRAINT `XFK_Kunde_Zahlung_F`
    FOREIGN KEY (`Kunde_Nr`)
    REFERENCES `bustours`.`Kunde` (`Kunde_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.Drucker
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Drucker` (
  `Drucker_Nr` INT(4) NOT NULL,
  `Bezeichnung` VARCHAR(255) NULL,
  PRIMARY KEY (`Drucker_Nr`),
  UNIQUE INDEX `XPKDrucker` (`Drucker_Nr` ASC));

-- ----------------------------------------------------------------------------
-- Table bustours.permmgr_groups
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`permmgr_groups` (
  `Gr_Name` VARCHAR(128) NOT NULL,
  UNIQUE INDEX `permmgr_groups UNIQUE (Gr_Name)` (`Gr_Name` ASC));

-- ----------------------------------------------------------------------------
-- Table bustours.Kabine
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Kabine` (
  `Kabine_Nr` INT(4) NOT NULL,
  `Kurzform` CHAR(10) NULL,
  `Bezeichnung` CHAR(50) NULL,
  `anzahl_personen` SMALLINT NOT NULL,
  PRIMARY KEY (`Kabine_Nr`),
  UNIQUE INDEX `Kabine_Nr` (`Kabine_Nr` ASC));

-- ----------------------------------------------------------------------------
-- Table bustours.pbcatcol
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`pbcatcol` (
  `pbc_tnam` CHAR(129) NOT NULL,
  `pbc_tid` INT(4) NULL,
  `pbc_ownr` CHAR(129) NOT NULL,
  `pbc_cnam` CHAR(129) NOT NULL,
  `pbc_cid` SMALLINT NULL,
  `pbc_labl` CHAR(254) NULL,
  `pbc_lpos` SMALLINT NULL,
  `pbc_hdr` CHAR(254) NULL,
  `pbc_hpos` SMALLINT NULL,
  `pbc_jtfy` SMALLINT NULL,
  `pbc_mask` CHAR(31) NULL,
  `pbc_case` SMALLINT NULL,
  `pbc_hght` SMALLINT NULL,
  `pbc_wdth` SMALLINT NULL,
  `pbc_ptrn` CHAR(31) NULL,
  `pbc_bmap` CHAR(1) NULL,
  `pbc_init` CHAR(254) NULL,
  `pbc_cmnt` CHAR(254) NULL,
  `pbc_edit` CHAR(31) NULL,
  `pbc_tag` CHAR(254) NULL,
  UNIQUE INDEX `pbcatc_x` (`pbc_cnam` ASC, `pbc_ownr` ASC, `pbc_tnam` ASC));

-- ----------------------------------------------------------------------------
-- Table bustours.Kunde
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Kunde` (
  `Kunde_Nr` INT(4) NOT NULL,
  `Geburt_Dat` DATE NULL,
  PRIMARY KEY (`Kunde_Nr`),
  UNIQUE INDEX `XPKKunde` (`Kunde_Nr` ASC),
  CONSTRAINT `XFK_Adresse_Kunde`
    FOREIGN KEY (`Kunde_Nr`)
    REFERENCES `bustours`.`adresse` (`adresse_nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.Konto_Kategorie
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Konto_Kategorie` (
  `Kategorie_Nr` INT(4) NOT NULL,
  `Kategorie` CHAR(50) NULL,
  PRIMARY KEY (`Kategorie_Nr`),
  UNIQUE INDEX `Kategorie_Nr` (`Kategorie_Nr` ASC));

-- ----------------------------------------------------------------------------
-- Table bustours.Personal
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Personal` (
  `Personal_Nr` INT(4) NOT NULL,
  `Agentur_Nr` INT(4) NULL,
  `Kurzform` CHAR(5) NULL,
  `Anrede_Nr` INT(4) NULL,
  `Name` CHAR(30) NULL,
  `Vorname` CHAR(30) NULL,
  `Strasse` CHAR(30) NULL,
  `Ort` CHAR(30) NULL,
  `Plz` CHAR(10) NULL,
  `Telefon` CHAR(20) NULL,
  `Bemerkung` LONGTEXT NULL,
  PRIMARY KEY (`Personal_Nr`),
  INDEX `XIF26Personal` (`Agentur_Nr` ASC),
  UNIQUE INDEX `Personal_Nr` (`Personal_Nr` ASC),
  CONSTRAINT `Personal__Agentur`
    FOREIGN KEY (`Agentur_Nr`)
    REFERENCES `bustours`.`Agentur` (`Agentur_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.Temp_Kunde
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Temp_Kunde` (
  `Kunde_Nr` INT(4) NOT NULL,
  PRIMARY KEY (`Kunde_Nr`),
  UNIQUE INDEX `Temp_Kunde UNIQUE (Kunde_Nr)` (`Kunde_Nr` ASC),
  UNIQUE INDEX `Temp_Kunde_UNIQUE__Kunde_Nr_` (`Kunde_Nr` ASC));

-- ----------------------------------------------------------------------------
-- Table bustours.Ansprechpartner
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Ansprechpartner` (
  `lfd_Nr` INT(4) NOT NULL,
  `Adresse_Nr` INT(4) NOT NULL,
  `Name` CHAR(30) NULL,
  `Vorname` CHAR(30) NULL,
  `Apparat` CHAR(10) NULL,
  `Bemerkung` CHAR(128) NULL,
  PRIMARY KEY (`lfd_Nr`),
  INDEX `XIF176Ansprechpartner` (`Adresse_Nr` ASC),
  UNIQUE INDEX `XPKAnsprechpartner` (`lfd_Nr` ASC),
  CONSTRAINT `XFK_Adresse_Ansprechp`
    FOREIGN KEY (`Adresse_Nr`)
    REFERENCES `bustours`.`adresse` (`adresse_nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.Leistung
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Leistung` (
  `Reise_Nr` INT(4) NULL,
  `Leistung` CHAR(50) NULL,
  `Leistung_Nr` INT(4) NOT NULL,
  PRIMARY KEY (`Leistung_Nr`),
  INDEX `XIF30Leistung` (`Reise_Nr` ASC),
  UNIQUE INDEX `leistung_nr` (`Leistung_Nr` ASC),
  CONSTRAINT `Leistung__Reise`
    FOREIGN KEY (`Reise_Nr`)
    REFERENCES `bustours`.`Reise` (`Reise_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.pbcattbl
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`pbcattbl` (
  `pbt_tnam` CHAR(129) NOT NULL,
  `pbt_tid` INT(4) NULL,
  `pbt_ownr` CHAR(129) NOT NULL,
  `pbd_fhgt` SMALLINT NULL,
  `pbd_fwgt` SMALLINT NULL,
  `pbd_fitl` CHAR(1) NULL,
  `pbd_funl` CHAR(1) NULL,
  `pbd_fchr` SMALLINT NULL,
  `pbd_fptc` SMALLINT NULL,
  `pbd_ffce` CHAR(18) NULL,
  `pbh_fhgt` SMALLINT NULL,
  `pbh_fwgt` SMALLINT NULL,
  `pbh_fitl` CHAR(1) NULL,
  `pbh_funl` CHAR(1) NULL,
  `pbh_fchr` SMALLINT NULL,
  `pbh_fptc` SMALLINT NULL,
  `pbh_ffce` CHAR(18) NULL,
  `pbl_fhgt` SMALLINT NULL,
  `pbl_fwgt` SMALLINT NULL,
  `pbl_fitl` CHAR(1) NULL,
  `pbl_funl` CHAR(1) NULL,
  `pbl_fchr` SMALLINT NULL,
  `pbl_fptc` SMALLINT NULL,
  `pbl_ffce` CHAR(18) NULL,
  `pbt_cmnt` CHAR(254) NULL,
  UNIQUE INDEX `pbcatt_x` (`pbt_ownr` ASC, `pbt_tnam` ASC));

-- ----------------------------------------------------------------------------
-- Table bustours.Haltepunkt_Abfahrt
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Haltepunkt_Abfahrt` (
  `Abfahrt_Nr` INT(4) NOT NULL,
  `Haltepunkt_Nr` INT(4) NULL,
  `Abfahrt_Zuschlag` FLOAT(4,0) NULL,
  PRIMARY KEY (`Abfahrt_Nr`),
  UNIQUE INDEX `Abfahrt_Nr` (`Abfahrt_Nr` ASC));

-- ----------------------------------------------------------------------------
-- Table bustours.Archiv_Reise
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Archiv_Reise` (
  `Reise_Nr` INT(4) NOT NULL,
  `Titel` CHAR(30) NULL,
  PRIMARY KEY (`Reise_Nr`),
  UNIQUE INDEX `XPKE_35` (`Reise_Nr` ASC));

-- ----------------------------------------------------------------------------
-- Table bustours.Zahlung
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Zahlung` (
  `Zahlung_Nr` INT(4) NOT NULL,
  `Teilnehmergruppe_Nr` INT(4) NULL,
  `Preis_Nr` INT(4) NULL,
  `Faktor` SMALLINT NULL,
  `Kunde_Nr` INT(4) NULL,
  `Datum` DATE NULL,
  `Preis_Betrag` DECIMAL(10,2) NULL,
  PRIMARY KEY (`Zahlung_Nr`),
  INDEX `XIF45Zahlung` (`Teilnehmergruppe_Nr` ASC),
  INDEX `XIF44Zahlung` (`Preis_Nr` ASC),
  INDEX `XIF185Zahlung` (`Kunde_Nr` ASC),
  UNIQUE INDEX `Zahlung_Nr` (`Zahlung_Nr` ASC),
  CONSTRAINT `Zahlung__Preis`
    FOREIGN KEY (`Preis_Nr`)
    REFERENCES `bustours`.`Preis` (`Preis_Nr`),
  CONSTRAINT `Zahlung__Teilnehmergruppe`
    FOREIGN KEY (`Teilnehmergruppe_Nr`)
    REFERENCES `bustours`.`Teilnehmergruppe` (`Teilnehmergruppe_Nr`),
  CONSTRAINT `XFK_Kunde_Zahlung`
    FOREIGN KEY (`Kunde_Nr`)
    REFERENCES `bustours`.`Kunde` (`Kunde_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.Konto
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Konto` (
  `Konto_Nr` INT(4) NOT NULL,
  `Bezeichnung` CHAR(50) NULL,
  `Kategorie_Nr` INT(4) NULL,
  `abschluss` TINYINT(1) NULL,
  PRIMARY KEY (`Konto_Nr`),
  INDEX `XIF18Konto` (`Kategorie_Nr` ASC),
  UNIQUE INDEX `PrimaryKey` (`Konto_Nr` ASC),
  CONSTRAINT `Konto__Konto_Kategorie`
    FOREIGN KEY (`Kategorie_Nr`)
    REFERENCES `bustours`.`Konto_Kategorie` (`Kategorie_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.Kontingent_Zimmer
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Kontingent_Zimmer` (
  `Buchung_Nr` INT(4) NOT NULL,
  `Zimmer_Nr` INT(4) NOT NULL,
  `Kontingent` SMALLINT NOT NULL,
  `Expedient` CHAR(3) NULL,
  `Modifikation_Dat` DATE NULL,
  `Option_Ablauf_Dat` DATE NULL,
  `Bemerkung` VARCHAR(255) NULL,
  PRIMARY KEY (`Buchung_Nr`, `Zimmer_Nr`),
  INDEX `XIF51Kontingent_Zimmer` (`Zimmer_Nr` ASC),
  INDEX `XIF49Kontingent_Zimmer` (`Buchung_Nr` ASC),
  UNIQUE INDEX `XPKKontingent_Zimmer` (`Zimmer_Nr` ASC, `Buchung_Nr` ASC),
  CONSTRAINT `XFK_KZ_Zimmer`
    FOREIGN KEY (`Zimmer_Nr`)
    REFERENCES `bustours`.`Zimmer` (`Zimmer_Nr`),
  CONSTRAINT `XFK_KZ_Buchung`
    FOREIGN KEY (`Buchung_Nr`)
    REFERENCES `bustours`.`Buchung` (`Buchung_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.Bus_Schema
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Bus_Schema` (
  `Bus_Nr` INT(4) NOT NULL,
  `_1rf` SMALLINT NULL,
  `_1rg` SMALLINT NULL,
  `_1lg` SMALLINT NULL,
  `_1lf` SMALLINT NULL,
  `_2rf` SMALLINT NULL,
  `_2rg` SMALLINT NULL,
  `_2lg` SMALLINT NULL,
  `_2lf` SMALLINT NULL,
  `_3rf` SMALLINT NULL,
  `_3rg` SMALLINT NULL,
  `_3lg` SMALLINT NULL,
  `_3lf` SMALLINT NULL,
  `_4rf` SMALLINT NULL,
  `_4rg` SMALLINT NULL,
  `_4lg` SMALLINT NULL,
  `_4lf` SMALLINT NULL,
  `_5rf` SMALLINT NULL,
  `_5rg` SMALLINT NULL,
  `_5lg` SMALLINT NULL,
  `_5lf` SMALLINT NULL,
  `_6rf` SMALLINT NULL,
  `_6rg` SMALLINT NULL,
  `_6lg` SMALLINT NULL,
  `_6lf` SMALLINT NULL,
  `_7rf` SMALLINT NULL,
  `_7rg` SMALLINT NULL,
  `_7lg` SMALLINT NULL,
  `_7lf` SMALLINT NULL,
  `_8rf` SMALLINT NULL,
  `_8rg` SMALLINT NULL,
  `_8lg` SMALLINT NULL,
  `_8lf` SMALLINT NULL,
  `_9rf` SMALLINT NULL,
  `_9rg` SMALLINT NULL,
  `_9lg` SMALLINT NULL,
  `_9lf` SMALLINT NULL,
  `_10rf` SMALLINT NULL,
  `_10rg` SMALLINT NULL,
  `_10lg` SMALLINT NULL,
  `_10lf` SMALLINT NULL,
  `_11rf` SMALLINT NULL,
  `_11rg` SMALLINT NULL,
  `_11lg` SMALLINT NULL,
  `_11lf` SMALLINT NULL,
  `_12rf` SMALLINT NULL,
  `_12rg` SMALLINT NULL,
  `_12lg` SMALLINT NULL,
  `_12lf` SMALLINT NULL,
  `_13rf` SMALLINT NULL,
  `_13rg` SMALLINT NULL,
  `_13lg` SMALLINT NULL,
  `_13lf` SMALLINT NULL,
  `_13m` SMALLINT NULL,
  `_14rf` SMALLINT NULL,
  `_14rg` SMALLINT NULL,
  `_14lg` SMALLINT NULL,
  `_14lf` SMALLINT NULL,
  `_14m` SMALLINT NULL,
  `_15lf` SMALLINT NULL,
  `_15lg` SMALLINT NULL,
  `_15rf` SMALLINT NULL,
  `_15rg` SMALLINT NULL,
  `_15m` SMALLINT NULL,
  `_16lf` SMALLINT NULL,
  `_16lg` SMALLINT NULL,
  `_16rf` SMALLINT NULL,
  `_16rg` SMALLINT NULL,
  `_16m` SMALLINT NULL,
  `_17lf` SMALLINT NULL,
  `_17lg` SMALLINT NULL,
  `_17rf` SMALLINT NULL,
  `_17rg` SMALLINT NULL,
  `_17m` SMALLINT NULL,
  `_18lf` SMALLINT NULL,
  `_18lg` SMALLINT NULL,
  `_18rf` SMALLINT NULL,
  `_18rg` SMALLINT NULL,
  `_18m` SMALLINT NULL,
  PRIMARY KEY (`Bus_Nr`),
  UNIQUE INDEX `Bus_Schema_Nr` (`Bus_Nr` ASC),
  CONSTRAINT `Bus_Schema__Bus_Daten`
    FOREIGN KEY (`Bus_Nr`)
    REFERENCES `bustours`.`Bus_Daten` (`Bus_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.pbcatedt
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`pbcatedt` (
  `pbe_name` CHAR(30) NOT NULL,
  `pbe_edit` CHAR(254) NULL,
  `pbe_type` SMALLINT NULL,
  `pbe_cntr` INT(4) NULL,
  `pbe_seqn` SMALLINT NOT NULL,
  `pbe_flag` INT(4) NULL,
  `pbe_work` CHAR(32) NULL,
  UNIQUE INDEX `pbcate_x` (`pbe_name` ASC, `pbe_seqn` ASC));

-- ----------------------------------------------------------------------------
-- Table bustours.Report
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Report` (
  `Report_Nr` INT(4) NOT NULL,
  `Bezeichnung` VARCHAR(100) NULL,
  `Anzahl_Zeilen` INT(4) NULL,
  `Anzahl_Spalten` INT(4) NULL,
  `Linker_Rand` INT(4) NULL,
  `Format` SMALLINT NULL,
  `Header` LONGTEXT NULL,
  `Header_Page` LONGTEXT NULL,
  `Detail` LONGTEXT NULL,
  `Footer_Page` LONGTEXT NULL,
  `Footer` LONGTEXT NULL,
  `Datastore` VARCHAR(40) NULL,
  `Argument` VARCHAR(255) NULL,
  PRIMARY KEY (`Report_Nr`),
  UNIQUE INDEX `XPKReport` (`Report_Nr` ASC));

-- ----------------------------------------------------------------------------
-- Table bustours.Anbieter
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Anbieter` (
  `Anbieter_Nr` INT(4) NOT NULL,
  `Kurzform` CHAR(5) NULL,
  `Anbieter` CHAR(30) NULL,
  `Strasse` CHAR(30) NULL,
  `Ort` CHAR(30) NULL,
  `Plz` CHAR(10) NULL,
  `Telefon` CHAR(20) NULL,
  `Fax` CHAR(20) NULL,
  `Bemerkung` LONGTEXT NULL,
  `Ansprechpartner1` CHAR(20) NULL,
  `Durchwahl1` CHAR(20) NULL,
  `Ansprechpartner2` CHAR(20) NULL,
  `Durchwahl2` CHAR(20) NULL,
  PRIMARY KEY (`Anbieter_Nr`),
  UNIQUE INDEX `Anbieter_Nr` (`Anbieter_Nr` ASC));

-- ----------------------------------------------------------------------------
-- Table bustours.Haltepunkt
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Haltepunkt` (
  `Haltepunkt_Nr` INT(4) NOT NULL,
  `Haltepunkt` CHAR(40) NULL,
  `Preis_Nr` INT(4) NULL,
  `Route_Nr` INT(4) NULL,
  `Abfahrt_Zuschlag` INT(4) NULL,
  `Reihenfolge_Nr` INT(4) NULL,
  PRIMARY KEY (`Haltepunkt_Nr`),
  INDEX `XIF27Haltepunkt` (`Preis_Nr` ASC),
  INDEX `XIF220Haltepunkt` (`Preis_Nr` ASC),
  INDEX `XIF215Haltepunkt` (`Route_Nr` ASC),
  UNIQUE INDEX `Haltepunkt_Nr` (`Haltepunkt_Nr` ASC),
  CONSTRAINT `Haltepunkt__Preis`
    FOREIGN KEY (`Preis_Nr`)
    REFERENCES `bustours`.`Preis` (`Preis_Nr`),
  CONSTRAINT `FK_Preis`
    FOREIGN KEY (`Preis_Nr`)
    REFERENCES `bustours`.`Preis` (`Preis_Nr`),
  CONSTRAINT `FK_HALTEPUN_ROUTE_ROUTE`
    FOREIGN KEY (`Route_Nr`)
    REFERENCES `bustours`.`Route` (`Route_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.Kategorie
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Kategorie` (
  `Kategorie_Nr` INT(4) NOT NULL,
  `Kategorie` CHAR(50) NULL,
  PRIMARY KEY (`Kategorie_Nr`),
  UNIQUE INDEX `XPKKategorie` (`Kategorie_Nr` ASC));

-- ----------------------------------------------------------------------------
-- Table bustours.Feld
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Feld` (
  `Feld_Nr` INT(4) NOT NULL,
  `Report_Nr` INT(4) NOT NULL,
  `Bereich_Nr` SMALLINT NULL,
  `Zeile` INT(4) NULL,
  `Spalte` INT(4) NULL,
  `Name` VARCHAR(255) NULL,
  `Typ` SMALLINT NULL,
  `Text` LONGTEXT NULL,
  `Weite` SMALLINT NULL,
  `Justierung` SMALLINT NULL,
  `Schrift_Groesse` SMALLINT NULL,
  `Fett` SMALLINT NULL,
  `Kursiv` SMALLINT NULL,
  `Unterstrichen` SMALLINT NULL,
  `Format` VARCHAR(40) NULL,
  PRIMARY KEY (`Feld_Nr`),
  INDEX `XIF86Feld` (`Report_Nr` ASC),
  UNIQUE INDEX `XPKFeld` (`Feld_Nr` ASC),
  CONSTRAINT `Report`
    FOREIGN KEY (`Report_Nr`)
    REFERENCES `bustours`.`Report` (`Report_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.adresse
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`adresse` (
  `adresse_nr` INT(4) NOT NULL,
  `Anrede_Nr` INT(4) NULL,
  `name_1` CHAR(30) NULL,
  `name_2` CHAR(30) NULL,
  `Strasse` CHAR(30) NULL,
  `Ort` CHAR(30) NULL,
  `Plz` CHAR(10) NULL,
  `Datum_Aufnahme` DATE NULL,
  `Bemerkung` LONGTEXT NULL,
  `name_3` CHAR(30) NULL,
  `Land_Nr` INT(4) NULL,
  `Titel_Nr` INT(4) NULL,
  `Briefanrede_Nr` SMALLINT NULL,
  `adresse_typ` SMALLINT NULL,
  PRIMARY KEY (`adresse_nr`),
  INDEX `XIF23Kunde` (`Anrede_Nr` ASC),
  INDEX `XIF173Adresse` (`Land_Nr` ASC),
  INDEX `XIF168Adresse` (`Titel_Nr` ASC),
  INDEX `XIF167Adresse` (`Briefanrede_Nr` ASC),
  UNIQUE INDEX `Adresse_Nr` (`adresse_nr` ASC),
  CONSTRAINT `Anrede`
    FOREIGN KEY (`Anrede_Nr`)
    REFERENCES `bustours`.`Anrede` (`Anrede_Nr`),
  CONSTRAINT `XFK_Adresse_Land`
    FOREIGN KEY (`Land_Nr`)
    REFERENCES `bustours`.`Land` (`Land_Nr`),
  CONSTRAINT `XFK_Adresse_Titel`
    FOREIGN KEY (`Titel_Nr`)
    REFERENCES `bustours`.`Titel` (`Titel_Nr`),
  CONSTRAINT `XFK_Adresse_Briefanrede`
    FOREIGN KEY (`Briefanrede_Nr`)
    REFERENCES `bustours`.`Briefanrede` (`Briefanrede_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.Drucker_Kommando
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Drucker_Kommando` (
  `Kommando_Nr` INT(4) NOT NULL,
  `Bezeichnung` VARCHAR(255) NULL,
  PRIMARY KEY (`Kommando_Nr`),
  UNIQUE INDEX `XPKDrucker_Kommando` (`Kommando_Nr` ASC));

-- ----------------------------------------------------------------------------
-- Table bustours.Zimmer
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Zimmer` (
  `Zimmer_Nr` INT(4) NOT NULL,
  `Kurzform` CHAR(8) NULL,
  `Bezeichnung` CHAR(50) NULL,
  `anzahl_personen` SMALLINT NOT NULL,
  PRIMARY KEY (`Zimmer_Nr`),
  UNIQUE INDEX `Zimmer_Nr` (`Zimmer_Nr` ASC));

-- ----------------------------------------------------------------------------
-- Table bustours.Konto_KT_Kopplung
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Konto_KT_Kopplung` (
  `Konto_Nr` INT(4) NOT NULL,
  `Konto_KT_Nr` INT(4) NOT NULL,
  PRIMARY KEY (`Konto_Nr`, `Konto_KT_Nr`),
  INDEX `XIF22Konto_KT_Kopplung` (`Konto_Nr` ASC),
  INDEX `XIF21Konto_KT_Kopplung` (`Konto_KT_Nr` ASC),
  UNIQUE INDEX `XPKKonto_KT_Kopplung` (`Konto_Nr` ASC, `Konto_KT_Nr` ASC),
  UNIQUE INDEX `Konto_KT_Kopplung_Nr` (`Konto_Nr` ASC, `Konto_KT_Nr` ASC),
  CONSTRAINT `Konto_KT_Kopplung__Konto`
    FOREIGN KEY (`Konto_Nr`)
    REFERENCES `bustours`.`Konto` (`Konto_Nr`),
  CONSTRAINT `Konto_KT_Kopplung__Konto_KT`
    FOREIGN KEY (`Konto_KT_Nr`)
    REFERENCES `bustours`.`Konto_KT` (`Konto_KT_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.Route_Haltepunkt_template
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Route_Haltepunkt_template` (
  `Haltepunkt_Nr` INT(4) NOT NULL,
  `Route_Nr` INT(4) NOT NULL,
  `Reihenfolge_Nr` INT(4) NOT NULL,
  PRIMARY KEY (`Haltepunkt_Nr`, `Route_Nr`, `Reihenfolge_Nr`),
  INDEX `XIF208Route_Haltepunkt_template` (`Route_Nr` ASC),
  INDEX `XIF207Route_Haltepunkt_template` (`Haltepunkt_Nr` ASC),
  UNIQUE INDEX `Haltepunkt_Nr` (`Route_Nr` ASC, `Haltepunkt_Nr` ASC, `Reihenfolge_Nr` ASC),
  CONSTRAINT `FK_ROUTE_HA_ROUTE_ROUTE_TE`
    FOREIGN KEY (`Route_Nr`)
    REFERENCES `bustours`.`Route_template` (`Route_Nr`),
  CONSTRAINT `FK_ROUTE_HA_HALTEPUNK_HALTEPUN`
    FOREIGN KEY (`Haltepunkt_Nr`)
    REFERENCES `bustours`.`Haltepunkt_template` (`Haltepunkt_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.Auftrag_Fremd
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Auftrag_Fremd` (
  `Beleg_Nr` INT(4) NOT NULL,
  `Zahlung_Fremd_Nr` INT(4) NULL,
  `Teilnehmergruppe_Nr` INT(4) NULL,
  `Agentur_Nr` INT(4) NULL,
  `Kunde_Nr` INT(4) NULL,
  `Buchung_Art` CHAR(1) NULL,
  PRIMARY KEY (`Beleg_Nr`),
  INDEX `XIF88Auftrag_Fremd` (`Zahlung_Fremd_Nr` ASC),
  INDEX `XIF83Auftrag_Fremd` (`Teilnehmergruppe_Nr` ASC),
  INDEX `XIF82Auftrag_Fremd` (`Agentur_Nr` ASC),
  INDEX `XIF183Auftrag_Fremd` (`Kunde_Nr` ASC),
  UNIQUE INDEX `XPKAuftrag_Fremd` (`Beleg_Nr` ASC),
  CONSTRAINT `XFK_KB_AF`
    FOREIGN KEY (`Beleg_Nr`)
    REFERENCES `bustours`.`Konto_Beleg` (`Beleg_Nr`),
  CONSTRAINT `XFK_TG_AF`
    FOREIGN KEY (`Teilnehmergruppe_Nr`)
    REFERENCES `bustours`.`Teilnehmergruppe` (`Teilnehmergruppe_Nr`),
  CONSTRAINT `XFK_ZF_AF`
    FOREIGN KEY (`Zahlung_Fremd_Nr`)
    REFERENCES `bustours`.`Zahlung_Fremd` (`Zahlung_Fremd_Nr`),
  CONSTRAINT `XFK_Agentur_AF`
    FOREIGN KEY (`Agentur_Nr`)
    REFERENCES `bustours`.`Agentur` (`Agentur_Nr`),
  CONSTRAINT `XFK_Kunde_Auftrag_F`
    FOREIGN KEY (`Kunde_Nr`)
    REFERENCES `bustours`.`Kunde` (`Kunde_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.Drucker_Code
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Drucker_Code` (
  `Drucker_Nr` INT(4) NOT NULL,
  `Kommando_Nr` INT(4) NOT NULL,
  `Code` VARCHAR(255) NULL,
  PRIMARY KEY (`Drucker_Nr`, `Kommando_Nr`),
  INDEX `XIF66Drucker_Code` (`Drucker_Nr` ASC),
  INDEX `XIF65Drucker_Code` (`Kommando_Nr` ASC),
  UNIQUE INDEX `XPKDrucker_Code` (`Drucker_Nr` ASC, `Kommando_Nr` ASC),
  CONSTRAINT `Drucker`
    FOREIGN KEY (`Drucker_Nr`)
    REFERENCES `bustours`.`Drucker` (`Drucker_Nr`),
  CONSTRAINT `Drucker_Kommando`
    FOREIGN KEY (`Kommando_Nr`)
    REFERENCES `bustours`.`Drucker_Kommando` (`Kommando_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.permmgr_perms
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`permmgr_perms` (
  `Gr_Name` VARCHAR(128) NOT NULL,
  `User_Name` VARCHAR(128) NOT NULL,
  `S_Perm` CHAR(1) NULL,
  `I_Perm` CHAR(1) NULL,
  `D_Perm` CHAR(1) NULL,
  `U_Perm` CHAR(1) NULL,
  `A_Perm` CHAR(1) NULL,
  `R_Perm` CHAR(1) NULL,
  `S_Grant` CHAR(1) NULL,
  `I_Grant` CHAR(1) NULL,
  `D_Grant` CHAR(1) NULL,
  `U_Grant` CHAR(1) NULL,
  `A_Grant` CHAR(1) NULL,
  `R_Grant` CHAR(1) NULL);

-- ----------------------------------------------------------------------------
-- Table bustours.Konto_Buchung_Art
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Konto_Buchung_Art` (
  `Buchung_Art_Nr` INT(4) NOT NULL,
  `Buchung_Art` CHAR(50) NULL,
  PRIMARY KEY (`Buchung_Art_Nr`),
  UNIQUE INDEX `Buchung_Art_Nr` (`Buchung_Art_Nr` ASC));

-- ----------------------------------------------------------------------------
-- Table bustours.Termin
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Termin` (
  `Termin_Nr` INT(4) NOT NULL,
  `Reise_Nr` INT(4) NOT NULL,
  `Von` DATE NULL,
  `Bis` DATE NULL,
  `Abfahrt` DATETIME NULL,
  PRIMARY KEY (`Termin_Nr`, `Reise_Nr`),
  INDEX `XIF47Termin` (`Reise_Nr` ASC),
  UNIQUE INDEX `Termin_Nr` (`Termin_Nr` ASC),
  CONSTRAINT `Termin__Reise`
    FOREIGN KEY (`Reise_Nr`)
    REFERENCES `bustours`.`Reise` (`Reise_Nr`));

-- ----------------------------------------------------------------------------
-- Table bustours.permmgr_tabs
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`permmgr_tabs` (
  `Gr_Name` VARCHAR(128) NOT NULL,
  `Tab_Name` VARCHAR(128) NOT NULL);

-- ----------------------------------------------------------------------------
-- Table bustours.Land
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Land` (
  `Land_Nr` INT(4) NOT NULL,
  `Kurzform` CHAR(3) NULL,
  `Land` CHAR(30) NULL,
  PRIMARY KEY (`Land_Nr`),
  UNIQUE INDEX `Land_Nr` (`Land_Nr` ASC));

-- ----------------------------------------------------------------------------
-- Table bustours.Kategorie_Adresse
-- ----------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `bustours`.`Kategorie_Adresse` (
  `Kategorie_Nr` INT(4) NOT NULL,
  `Adresse_Nr` INT(4) NOT NULL,
  PRIMARY KEY (`Kategorie_Nr`, `Adresse_Nr`),
  INDEX `XIF172Kategorie_Adresse` (`Adresse_Nr` ASC),
  INDEX `XIF122Kategorie_Adresse` (`Kategorie_Nr` ASC),
  UNIQUE INDEX `XPKKategorie_Adresse` (`Adresse_Nr` ASC, `Kategorie_Nr` ASC),
  CONSTRAINT `XFK_Kat_Adr_Kat`
    FOREIGN KEY (`Kategorie_Nr`)
    REFERENCES `bustours`.`Kategorie` (`Kategorie_Nr`),
  CONSTRAINT `XFK_Adresse_Kat_Adr`
    FOREIGN KEY (`Adresse_Nr`)
    REFERENCES `bustours`.`adresse` (`adresse_nr`));
SET FOREIGN_KEY_CHECKS = 1;