15:41:06 [ERR][ Workbench]: Console redirection failed. 15:41:06 [INF][ WBContext]: Parsing application arguments. 15:41:06 [INF][ WBContext]: C:\Program Files\MySQL\MySQL Workbench 6.3 CE\MySQLWorkbench.exe 15:41:06 [INF][ Workbench]: Starting up Workbench 15:41:06 [INF][ Workbench]: Current environment: Command line: "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\MySQLWorkbench.exe" CurrentDirectory: C:\Program Files\MySQL\MySQL Workbench 6.3 CE HasShutdownStarted: False OSVersion: Microsoft Windows NT 6.1.7601 Service Pack 1 SystemDirectory: C:\Windows\system32 TickCount: 1187213894 UserInteractive: True Version: 4.0.30319.34209 WorkingSet: 31567872 15:41:06 [INF][ Workbench]: Environment variables: SESSIONNAME = Console ProgramFiles(x86) = C:\Program Files (x86) Path = C:\Python27\;C:\Python27\Scripts;C:\ProgramData\Oracle\Java\javapath;C:\Program Files\R\Rtools\bin;C:\Program Files\R\Rtools\gcc-4.6.3\bin;C:\Program Files\ImageMagick-6.8.0-Q16;C:\Program Files (x86)\ImageMagick-6.8.0-Q16;C:\Program Files\MiKTeX 2.9\miktex\bin\x64;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Lenovo\Access Connections\;C:\SWTOOLS\ReadyApps;C:\Program Files\MATLAB\R2011b\runtime\win64;C:\Program Files\MATLAB\R2011b\bin;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;c:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;c:\Program Files\Microsoft SQL Server\100\Tools\Binn\;c:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files (x86)\xampp-win32-1.8.0-VC9\xampp\php\;C:\Program Files (x86)\Common Files\lenovo\easyplussdk\bin;C:\Program Files (x86)\Skype\Phone\;C:\Program Files (x86)\QuickTime\QTSystem\;D:\Program Files\SQL Anywhere 11\bin64;D:\Program Files\SQL Anywhere 11\bin32;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\ ProgramW6432 = C:\Program Files windir = C:\Windows PROCESSOR_IDENTIFIER = Intel64 Family 6 Model 23 Stepping 6, GenuineIntel easyplussdk = "C:\Program Files (x86)\Common Files\lenovo\easyplussdk\bin" TMP = C:\Users\af\AppData\Local\Temp PROCESSOR_ARCHITECTURE = AMD64 ACPath = C:\Program Files (x86)\Lenovo\Access Connections\ LANG = DE TFS_DIR = C:\Program Files\ThinkVantage Fingerprint Software\ PROCESSOR_REVISION = 1706 TEMP = C:\Users\af\AppData\Local\Temp USERPROFILE = C:\Users\af LOGONSERVER = \\OXIA USERNAME = af SystemRoot = C:\Windows VS100COMNTOOLS = C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\Tools\ READYAPPS = C:\SWTOOLS\ReadyApps SQLANY11 = D:\Program Files\SQL Anywhere 11 FP_NO_HOST_CHECK = NO CommonProgramFiles = C:\Program Files\Common Files ProgramData = C:\ProgramData HOMEPATH = \Users\af COMPUTERNAME = OXIA USERID = af-192.168.30.55 ALLUSERSPROFILE = C:\ProgramData CommonProgramW6432 = C:\Program Files\Common Files MOZ_PLUGIN_PATH = C:\Program Files (x86)\Hummingbird\Connectivity\14.00\Exceed\Plugins\ CommonProgramFiles(x86) = C:\Program Files (x86)\Common Files HOMEDRIVE = C: SMA = C:\Program Files (x86)\ThinkVantage\SMA\ SystemDrive = C: NUMBER_OF_PROCESSORS = 2 OS = Windows_NT ProgramFiles = C:\Program Files ComSpec = C:\Windows\system32\cmd.exe PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC PSModulePath = C:\Windows\system32\WindowsPowerShell\v1.0\Modules\ APPDATA = C:\Users\af\AppData\Roaming USERDOMAIN = OXIA PROCESSOR_LEVEL = 6 asl.log = Destination=file LOCALAPPDATA = C:\Users\af\AppData\Local SQLANYSAMP11 = C:\Users\Public\Documents\SQL Anywhere 11\Samples TVT = C:\Program Files (x86)\Lenovo PUBLIC = C:\Users\Public TSMPATH = C:\Program Files\ThinkPad\UltraNav Utility 15:41:06 [INF][ Workbench]: Current version given by meta info is: 6.3.5 15:41:06 [INF][ Workbench]: Setting PATH to: C:\Windows\system32;C:\ProgramData\Oracle\Java\javapath;C:\Program Files\R\Rtools\bin;C:\Program Files\R\Rtools\gcc-4.6.3\bin;C:\Program Files\ImageMagick-6.8.0-Q16;C:\Program Files (x86)\ImageMagick-6.8.0-Q16;C:\Program Files\MiKTeX 2.9\miktex\bin\x64;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Lenovo\Access Connections\;C:\SWTOOLS\ReadyApps;C:\Program Files\MATLAB\R2011b\runtime\win64;C:\Program Files\MATLAB\R2011b\bin;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;c:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;c:\Program Files\Microsoft SQL Server\100\Tools\Binn\;c:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files (x86)\xampp-win32-1.8.0-VC9\xampp\php\;C:\Program Files (x86)\Common Files\lenovo\easyplussdk\bin;C:\Program Files (x86)\Skype\Phone\;C:\Program Files (x86)\QuickTime\QTSystem\;D:\Program Files\SQL Anywhere 11\bin64;D:\Program Files\SQL Anywhere 11\bin32;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\ 15:41:06 [INF][ mforms managed]: Initializing mforms wrapper 15:41:07 [INF][ WBContext UI]: Initializing workbench context UI with these values: base dir: C:\Program Files\MySQL\MySQL Workbench 6.3 CE plugin path: C:\Program Files\MySQL\MySQL Workbench 6.3 CE struct path: module path: C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules library path: C:\Program Files\MySQL\MySQL Workbench 6.3 CE user data dir: C:\Users\af\AppData\Roaming\MySQL\Workbench open at start: open type: run at startup: run type: Force SW rendering: No Force OpenGL: No quit when done: No 15:41:07 [INF][ WBContext]: WbContext::init 15:41:07 [INF][ grt]: Scanning module directory C:\Users\af\AppData\Roaming\MySQL\Workbench\modules. 15:41:07 [INF][ grt]: Scanning module directory .. 15:41:07 [INF][ grt]: Scanning module directory C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules. 15:41:08 [INF][ WBA]: Looking for extension modules for WBA... 15:41:08 [INF][ WBA]: 0 extension modules found 15:41:08 [WRN][ grt]: C:\Program Files\MySQL\MySQL Workbench 6.3 CE\data/table_templates.xml:21: link 'com.mysql.rdbms.mysql.datatype.timestamp' key=simpleType could not be resolved 15:41:08 [WRN][ grt]: C:\Program Files\MySQL\MySQL Workbench 6.3 CE\data/table_templates.xml:106: link 'com.mysql.rdbms.mysql.datatype.varchar' key=simpleType could not be resolved 15:41:08 [WRN][ grt]: C:\Program Files\MySQL\MySQL Workbench 6.3 CE\data/table_templates.xml:229: link 'com.mysql.rdbms.mysql.datatype.int' key=simpleType could not be resolved 15:41:08 [INF][ grt]: Scanning module directory C:\Program Files\MySQL\MySQL Workbench 6.3 CE. 15:41:08 [WRN][ grt]: C:\Users\af\AppData\Roaming\MySQL\Workbench\connections.xml:28: link '{0F60C251-A66A-4547-B706-EA21B7EE8D89}' key=owner could not be resolved 15:41:09 [INF][ WBContext]: System info: MySQL Workbench Community (GPL) for Windows version 6.3.5 CE build 201 (64 bit) Configuration Directory: C:\Users\af\AppData\Roaming\MySQL\Workbench Data Directory: C:\Program Files\MySQL\MySQL Workbench 6.3 CE Cairo Version: 1.10.2 OS: Microsoft Windows 7 Enterprise Service Pack 1 CPU: 2x Intel(R) Core(TM)2 Duo CPU T9300 @ 2.50GHz, 3.9 GiB RAM Active video adapter NVIDIA Quadro NVS 140M Installed video RAM: 128 MB Current video mode: 1680 x 1050 x 4294967296 colors Used bit depth: 32 Driver version: 9.18.13.2702 Installed display drivers: nvd3dumx.dll,nvwgf2umx.dll,nvwgf2umx.dll,nvd3dum,nvwgf2um,nvwgf2um Current user language: German (Germany) 15:41:09 [INF][ Workbench]: UI is up 15:41:09 [INF][ Workbench]: Running the application 15:41:14 [WRN][ grt]: C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules/data\msaccess_rdbms_info.xml:8: link 'com.mysql.rdbms.msaccess.driver.odbc' key=defaultDriver could not be resolved 15:41:14 [INF][ WBContext]: Loaded 0/0 new non-MySQL connections 15:42:20 [INF][ grt]: Connecting to ... 15:42:20 [INF][ grt]: Opening ODBC connection to DSN=bustours... 15:42:23 [INF][ grt]: Connected 15:42:23 [INF][ SQLAnywhere RE]: Connected to , 16.0.0.2043 15:42:36 [INF][ grt]: Connecting to Mysql@localhost:3306... 15:42:36 [INF][ grt]: Connecting to Mysql@localhost:3306... 15:42:36 [INF][ grt]: Connected 15:42:39 [INF][ Wizard]: Execute 'Connect to source DBMS' 15:42:39 [INF][ grt]: Connecting to ... 15:42:39 [INF][ grt]: Opening ODBC connection to DSN=bustours... 15:42:41 [INF][ grt]: Connected 15:42:41 [INF][ SQLAnywhere RE]: Connected to , 16.0.0.2043 15:42:42 [INF][ Wizard]: Execute 'Check target DBMS connection' 15:42:42 [INF][ grt]: Connecting to Mysql@localhost:3306... 15:42:42 [INF][ grt]: Connecting to Mysql@localhost:3306... 15:42:42 [INF][ grt]: Connected 15:42:42 [INF][ Wizard]: Starting thread for 'Retrieve schema list from source' 15:42:42 [INF][ SQLAnywhere RE]: Connected to , 16.0.0.2043 15:42:49 [INF][ Wizard]: Execute 'Connect to source DBMS' 15:42:49 [INF][ grt]: Connecting to ... 15:42:49 [INF][ grt]: Opening ODBC connection to DSN=bustours... 15:42:51 [INF][ grt]: Connected 15:42:51 [INF][ SQLAnywhere RE]: Connected to , 16.0.0.2043 15:42:51 [INF][ Wizard]: Starting thread for 'Reverse engineer selected schemas' 15:42:51 [INF][ SQLAnywhere RE]: Connected to , 16.0.0.2043 15:42:51 [INF][ grt]: Reverse engineering DBA from bustours 15:42:51 [INF][ grt]: Reverse engineering tables from DBA 15:42:53 [INF][ grt]: Reverse engineering views from DBA 15:42:53 [INF][ grt]: Reverse engineering routines from DBA 15:42:53 [INF][ grt]: Reverse engineering triggers from DBA 15:42:53 [INF][ grt]: Reverse engineering foreign keys for tables in schema DBA 15:42:54 [INF][ Wizard]: Execute 'Post-processing of reverse engineered schemas' 15:42:54 [INF][ grt]: Merging reverse engineered schema objects into a single schema... 15:43:01 [INF][ Wizard]: Starting thread for 'Migrate Selected Objects' 15:43:09 [INF][ Wizard]: Starting thread for 'Generate SQL CREATE Statements' 15:43:40 [INF][ Migration]: User renamed target object 'Buchung_1' to 'Reservierung__Buchung' 15:43:58 [INF][ Migration]: User renamed target object 'Konto_Beleg_1' to 'Konto_Buchung__Konto_Beleg' 15:44:17 [INF][ Migration]: User renamed target object 'Anbieter_1' to 'Leistung_Fremd__Anbieter' 15:44:32 [INF][ Migration]: User renamed target object 'Konto_Buchung_Art_1' to 'Archiv_Konto_Beleg__Konto_Buchung_Art' 15:44:43 [INF][ Migration]: User renamed target object 'Archiv_Konto_1' to 'Archiv_Konto_KT_Kopplung__Archiv_Konto' 15:44:59 [INF][ Migration]: User renamed target object 'Teilnehmergruppe' to 'Teilnehmer__Teilnehmergruppe' 15:45:14 [INF][ Migration]: User renamed target object 'Reise_1' to 'Buchung__Reise' 15:45:19 [INF][ Migration]: User renamed target object 'Bus_Daten_1' to 'Buchung__Bus_Daten' 15:45:39 [INF][ Migration]: User renamed target object 'Agentur_1' to 'Personal__Agentur' 15:45:49 [INF][ Migration]: User renamed target object 'Reise_2' to 'Leistung__Reise' 15:46:06 [INF][ Migration]: User renamed target object 'Preis_1' to 'Zahlung__Preis' 15:46:12 [INF][ Migration]: User renamed target object 'Teilnehmergruppe_1' to 'Zahlung__Teilnehmergruppe' 15:46:27 [INF][ Migration]: User renamed target object 'Konto_Kategorie_1' to 'Konto__Konto_Kategorie' 15:47:10 [INF][ Migration]: User renamed target object 'Bus_Daten_2' to 'Bus_Schema__Bus_Daten' 15:47:25 [INF][ Migration]: User renamed target object 'Preis_2' to 'Haltepunkt__Preis' 15:48:00 [INF][ Migration]: User renamed target object 'Konto_1' to 'Konto_KT_Kopplung__Konto' 15:48:04 [INF][ Migration]: User renamed target object 'Konto_KT_1' to 'Konto_KT_Kopplung__Konto_KT' 15:48:20 [INF][ Migration]: User renamed target object 'Reise_3' to 'Termin__Reise' 15:48:49 [INF][ Wizard]: Execute 'Create Script File' 15:48:50 [INF][ Wizard]: Execute 'Connect to Target Database' 15:48:50 [INF][ Wizard]: Execute 'Perform Checks in Target' 15:48:50 [INF][ Wizard]: Starting thread for 'Create Schemas and Objects' 15:48:50 [INF][ grt]: Execute statement SET FOREIGN_KEY_CHECKS = 0 15:48:50 [INF][ grt]: Execute statement CREATE SCHEMA IF NOT EXISTS `bustours` 15:48:50 [INF][ grt]: Execute statement 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`)) 15:48:50 [INF][ grt]: Execute statement 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)) 15:48:50 [INF][ grt]: Execute statement 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`)) 15:48:50 [INF][ grt]: Execute statement 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`)) 15:48:50 [INF][ grt]: Execute statement 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)) 15:48:50 [INF][ grt]: Execute statement 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)) 15:48:51 [INF][ grt]: Execute statement 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)) 15:48:51 [INF][ grt]: Execute statement 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)) 15:48:51 [INF][ grt]: Execute statement 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`)) 15:48:51 [INF][ grt]: Execute statement 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)) 15:48:51 [INF][ grt]: Execute statement 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`)) 15:48:51 [INF][ grt]: Execute statement 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`)) 15:48:51 [INF][ grt]: Execute statement 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`)) 15:48:51 [INF][ grt]: Execute statement 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`)) 15:48:51 [INF][ grt]: Execute statement 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)) 15:48:51 [INF][ grt]: Execute statement 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`)) 15:48:51 [INF][ grt]: Execute statement 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`)) 15:48:51 [INF][ grt]: Execute statement 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`)) 15:48:52 [INF][ grt]: Execute statement 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`)) 15:48:52 [INF][ grt]: Execute statement 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`)) 15:48:52 [INF][ grt]: Execute statement 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`)) 15:48:52 [INF][ grt]: Execute statement 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`)) 15:48:52 [INF][ grt]: Execute statement 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`)) 15:48:52 [INF][ grt]: Execute statement 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`)) 15:48:52 [INF][ grt]: Execute statement 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)) 15:48:52 [INF][ grt]: Execute statement 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`)) 15:48:52 [INF][ grt]: Execute statement 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)) 15:48:52 [INF][ grt]: Execute statement 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`)) 15:48:52 [INF][ grt]: Execute statement 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)) 15:48:52 [INF][ grt]: Execute statement 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)) 15:48:52 [INF][ grt]: Execute statement 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`)) 15:48:52 [INF][ grt]: Execute statement 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`)) 15:48:52 [INF][ grt]: Execute statement 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`)) 15:48:53 [INF][ grt]: Execute statement 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`)) 15:48:53 [INF][ grt]: Execute statement 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`)) 15:48:53 [INF][ grt]: Execute statement 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`)) 15:48:53 [INF][ grt]: Execute statement 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)) 15:48:53 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `bustours`.`permmgr_groups` ( `Gr_Name` VARCHAR(128) NOT NULL, UNIQUE INDEX `permmgr_groups UNIQUE (Gr_Name)` (`Gr_Name` ASC)) 15:48:54 [INF][ grt]: Execute statement 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)) 15:48:54 [INF][ grt]: Execute statement 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)) 15:48:54 [INF][ grt]: Execute statement 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`)) 15:48:54 [INF][ grt]: Execute statement 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)) 15:48:54 [INF][ grt]: Execute statement 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`)) 15:48:54 [INF][ grt]: Execute statement 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)) 15:48:54 [INF][ grt]: Execute statement 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`)) 15:48:54 [INF][ grt]: Execute statement 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`)) 15:48:54 [INF][ grt]: Execute statement 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)) 15:48:54 [INF][ grt]: Execute statement 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)) 15:48:55 [INF][ grt]: Execute statement 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)) 15:48:55 [INF][ grt]: Execute statement 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`)) 15:48:55 [INF][ grt]: Execute statement 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`)) 15:48:55 [INF][ grt]: Execute statement 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`)) 15:48:55 [INF][ grt]: Execute statement 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`)) 15:48:55 [INF][ grt]: Execute statement 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)) 15:48:55 [INF][ grt]: Execute statement 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)) 15:48:55 [INF][ grt]: Execute statement 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)) 15:48:55 [INF][ grt]: Execute statement 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`)) 15:48:56 [INF][ grt]: Execute statement 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)) 15:48:56 [INF][ grt]: Execute statement 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`)) 15:48:57 [INF][ grt]: Execute statement 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`)) 15:48:57 [INF][ grt]: Execute statement 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)) 15:48:57 [INF][ grt]: Execute statement 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)) 15:48:57 [INF][ grt]: Execute statement 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`)) 15:48:58 [INF][ grt]: Execute statement 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`)) 15:48:58 [INF][ grt]: Execute statement 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`)) 15:48:58 [INF][ grt]: Execute statement 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`)) 15:48:59 [INF][ grt]: Execute statement 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) 15:48:59 [INF][ grt]: Execute statement 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)) 15:48:59 [INF][ grt]: Execute statement 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`)) 15:48:59 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `bustours`.`permmgr_tabs` ( `Gr_Name` VARCHAR(128) NOT NULL, `Tab_Name` VARCHAR(128) NOT NULL) 15:48:59 [INF][ grt]: Execute statement 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)) 15:49:00 [INF][ grt]: Execute statement 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`)) 15:49:00 [INF][ grt]: Scripts for 72 tables, 0 views and 0 routines were executed for schema bustours 15:49:00 [INF][ grt]: Execute statement SET FOREIGN_KEY_CHECKS = 1 15:49:51 [ERR][ pymforms]: Unhandled exception in Python code: DbSQLAnywhereRE.getOS(): expected list 15:51:50 [ERR][ pymforms]: Unhandled exception in Python code: list index out of range 15:55:19 [ERR][ pymforms]: Unhandled exception in Python code: list index out of range 15:55:31 [ERR][ python]: Error forwarding notification to PythonTraceback (most recent call last): 15:55:31 [ERR][ python]: File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\workbench\notifications.py", line 31, in _the_observer 15:55:31 [ERR][ python]: for obs, nam, obj in self.observers: 15:55:31 [ERR][ python]: File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\workbench\wizard_page_widget.py", line 87, in go_back 15:55:31 [ERR][ python]: self.main.go_previous_page() 15:55:31 [ERR][ python]: File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_main.py", line 296, in go_previous_page 15:55:31 [ERR][ python]: next = self._page_trail[-1] 15:55:31 [ERR][ python]: IndexError: list index out of range 16:01:02 [INF][ grt]: Connecting to ... 16:01:02 [INF][ grt]: Opening ODBC connection to DSN=bustours... 16:01:02 [INF][ grt]: Connected 16:01:02 [INF][ SQLAnywhere RE]: Connected to , 16.0.0.2043 16:01:10 [INF][ Wizard]: Execute 'Connect to source DBMS' 16:01:10 [INF][ grt]: Connecting to ... 16:01:10 [INF][ grt]: Opening ODBC connection to DSN=bustours... 16:01:10 [INF][ grt]: Connected 16:01:10 [INF][ SQLAnywhere RE]: Connected to , 16.0.0.2043 16:01:10 [INF][ Wizard]: Execute 'Check target DBMS connection' 16:01:10 [INF][ grt]: Connecting to Mysql@localhost:3306... 16:01:10 [INF][ grt]: Connecting to Mysql@localhost:3306... 16:01:10 [INF][ grt]: Connected 16:01:11 [INF][ Wizard]: Starting thread for 'Retrieve schema list from source' 16:01:11 [INF][ SQLAnywhere RE]: Connected to , 16.0.0.2043 16:01:19 [INF][ Wizard]: Execute 'Connect to source DBMS' 16:01:19 [INF][ grt]: Connecting to ... 16:01:19 [INF][ grt]: Opening ODBC connection to DSN=bustours... 16:01:19 [INF][ grt]: Connected 16:01:19 [INF][ SQLAnywhere RE]: Connected to , 16.0.0.2043 16:01:19 [INF][ Wizard]: Starting thread for 'Reverse engineer selected schemas' 16:01:19 [INF][ SQLAnywhere RE]: Connected to , 16.0.0.2043 16:01:19 [INF][ grt]: Reverse engineering DBA from bustours 16:01:19 [INF][ grt]: Reverse engineering tables from DBA 16:01:22 [INF][ grt]: Reverse engineering views from DBA 16:01:22 [INF][ grt]: Reverse engineering routines from DBA 16:01:22 [INF][ grt]: Reverse engineering triggers from DBA 16:01:22 [INF][ grt]: Reverse engineering foreign keys for tables in schema DBA 16:01:23 [INF][ Wizard]: Execute 'Post-processing of reverse engineered schemas' 16:01:23 [INF][ grt]: Merging reverse engineered schema objects into a single schema... 16:01:29 [INF][ Wizard]: Starting thread for 'Migrate Selected Objects' 16:01:35 [INF][ Wizard]: Starting thread for 'Generate SQL CREATE Statements' 16:02:02 [INF][ Migration]: User renamed target object 'bustours' to 'TEMPRSS' 16:02:09 [INF][ Wizard]: Execute 'Connect to Target Database' 16:02:09 [INF][ Wizard]: Execute 'Perform Checks in Target' 16:02:09 [INF][ Wizard]: Starting thread for 'Create Schemas and Objects' 16:02:09 [INF][ grt]: Execute statement SET FOREIGN_KEY_CHECKS = 0 16:02:09 [INF][ grt]: Execute statement CREATE SCHEMA IF NOT EXISTS `TEMPRSS` 16:02:09 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Buchung` (`Buchung_Nr`)) 16:02:10 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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)) 16:02:10 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Agentur` (`Agentur_Nr`), CONSTRAINT `Konto_Beleg` FOREIGN KEY (`Beleg_Nr`) REFERENCES `TEMPRSS`.`Konto_Beleg` (`Beleg_Nr`), CONSTRAINT `teilnehmergruppe` FOREIGN KEY (`Teilnehmergruppe_Nr`) REFERENCES `TEMPRSS`.`Teilnehmergruppe` (`Teilnehmergruppe_Nr`), CONSTRAINT `XFK_Kunde_Auftrag` FOREIGN KEY (`Kunde_Nr`) REFERENCES `TEMPRSS`.`Kunde` (`Kunde_Nr`)) 16:02:10 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Archiv_Termin` (`Termin_Nr`), CONSTRAINT `XFK_Kunde_Archiv_TN` FOREIGN KEY (`Kunde_Nr`) REFERENCES `TEMPRSS`.`Kunde` (`Kunde_Nr`)) 16:02:10 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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)) 16:02:11 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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)) 16:02:11 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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)) 16:02:11 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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)) 16:02:11 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Archiv_Reise` (`Reise_Nr`)) 16:02:11 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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)) 16:02:11 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `Buchung_1` FOREIGN KEY (`Buchung_Nr`) REFERENCES `TEMPRSS`.`Buchung` (`Buchung_Nr`), CONSTRAINT `XFK_Reserv_Kabine` FOREIGN KEY (`Kabine_Nr`) REFERENCES `TEMPRSS`.`Kabine` (`Kabine_Nr`), CONSTRAINT `XFK_Reserv_Zimmer` FOREIGN KEY (`Zimmer_Nr`) REFERENCES `TEMPRSS`.`Zimmer` (`Zimmer_Nr`)) 16:02:12 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Anbieter` (`Anbieter_Nr`), CONSTRAINT `FK_ROUTE_TE_START_END_HALTEPUN` FOREIGN KEY (`Start_Ende_Haltepunkt_Nr`) REFERENCES `TEMPRSS`.`Haltepunkt_template` (`Haltepunkt_Nr`)) 16:02:12 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Reise` (`Reise_Nr`)) 16:02:12 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Land` (`Land_Nr`), CONSTRAINT `Anbieter` FOREIGN KEY (`Anbieter_Nr`) REFERENCES `TEMPRSS`.`Anbieter` (`Anbieter_Nr`)) 16:02:12 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`Anrede` ( `Anrede_Nr` INT(4) NOT NULL, `Anrede` CHAR(15) NULL, PRIMARY KEY (`Anrede_Nr`), UNIQUE INDEX `Anrede_Nr` (`Anrede_Nr` ASC)) 16:02:13 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`adresse` (`adresse_nr`), CONSTRAINT `XFK_Komm_Komm_Art` FOREIGN KEY (`Kommunikation_Art_Nr`) REFERENCES `TEMPRSS`.`Kommunikation_Art` (`Kommunikation_Art_Nr`)) 16:02:13 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Konto_Kategorie` (`Kategorie_Nr`)) 16:02:13 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Kabine` (`Kabine_Nr`), CONSTRAINT `XFK_KK_Buchung` FOREIGN KEY (`Buchung_Nr`) REFERENCES `TEMPRSS`.`Buchung` (`Buchung_Nr`)) 16:02:13 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Konto` (`Konto_Nr`), CONSTRAINT `Konto_Beleg_1` FOREIGN KEY (`Beleg_Nr`) REFERENCES `TEMPRSS`.`Konto_Beleg` (`Beleg_Nr`)) 16:02:14 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Konto_Buchung_Art` (`Buchung_Art_Nr`)) 16:02:14 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Archiv_Konto` (`Konto_Nr`), CONSTRAINT `Archiv_Konto_Beleg` FOREIGN KEY (`Beleg_Nr`) REFERENCES `TEMPRSS`.`Archiv_Konto_Beleg` (`Beleg_Nr`)) 16:02:14 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Agentur` (`Agentur_Nr`), CONSTRAINT `FK_Anbieter_Agentur` FOREIGN KEY (`Anbieter_Nr`) REFERENCES `TEMPRSS`.`Anbieter` (`Anbieter_Nr`)) 16:02:14 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Bus_Daten` (`Bus_Nr`)) 16:02:14 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Preis` (`Preis_Nr`), CONSTRAINT `Anbieter_1` FOREIGN KEY (`Anbieter_Nr`) REFERENCES `TEMPRSS`.`Anbieter` (`Anbieter_Nr`)) 16:02:14 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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)) 16:02:15 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `Konto_Buchung_Art_1` FOREIGN KEY (`Buchung_Art_Nr`) REFERENCES `TEMPRSS`.`Konto_Buchung_Art` (`Buchung_Art_Nr`)) 16:02:15 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`Briefanrede` ( `Briefanrede_Nr` SMALLINT NOT NULL, `Briefanrede` CHAR(50) NULL, PRIMARY KEY (`Briefanrede_Nr`), UNIQUE INDEX `XPKBriefanrede` (`Briefanrede_Nr` ASC)) 16:02:15 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Buchung` (`Buchung_Nr`)) 16:02:15 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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)) 16:02:15 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`Titel` ( `Titel_Nr` INT(4) NOT NULL, `Titel` CHAR(50) NULL, PRIMARY KEY (`Titel_Nr`), UNIQUE INDEX `XPKTitel` (`Titel_Nr` ASC)) 16:02:15 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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_1` FOREIGN KEY (`Konto_Nr`) REFERENCES `TEMPRSS`.`Archiv_Konto` (`Konto_Nr`), CONSTRAINT `Archiv_Konto_KT` FOREIGN KEY (`Konto_KT_Nr`) REFERENCES `TEMPRSS`.`Archiv_Konto_KT` (`Konto_KT_Nr`)) 16:02:16 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Haltepunkt` (`Haltepunkt_Nr`), CONSTRAINT `XFK_Kunde_TN` FOREIGN KEY (`Kunde_Nr`) REFERENCES `TEMPRSS`.`Kunde` (`Kunde_Nr`), CONSTRAINT `XFK_TN_Kabine` FOREIGN KEY (`Kabine_Nr`) REFERENCES `TEMPRSS`.`Kabine` (`Kabine_Nr`), CONSTRAINT `XFK_TN_Zimmer` FOREIGN KEY (`Zimmer_Nr`) REFERENCES `TEMPRSS`.`Zimmer` (`Zimmer_Nr`), CONSTRAINT `Teilnehmergruppe` FOREIGN KEY (`Teilnehmergruppe_Nr`) REFERENCES `TEMPRSS`.`Teilnehmergruppe` (`Teilnehmergruppe_Nr`)) 16:02:16 [WRN][ grt]: Error executing 'CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Haltepunkt` (`Haltepunkt_Nr`), CONSTRAINT `XFK_Kunde_TN` FOREIGN KEY (`Kunde_Nr`) REFERENCES `TEMPRSS`.`Kunde` (`Kunde_Nr`), CONSTRAINT `XFK_TN_Kabine` FOREIGN KEY (`Kabine_Nr`) REFERENCES `TEMPRSS`.`Kabine` (`Kabine_Nr`), CONSTRAINT `XFK_TN_Zimmer` FOREIGN KEY (`Zimmer_Nr`) REFERENCES `TEMPRSS`.`Zimmer` (`Zimmer_Nr`), CONSTRAINT `Teilnehmergruppe` FOREIGN KEY (`Teilnehmergruppe_Nr`) REFERENCES `TEMPRSS`.`Teilnehmergruppe` (`Teilnehmergruppe_Nr`))' Can't write; duplicate key in table 'teilnehmer'. SQL Error: 1022 16:02:16 [ERR][ DbMySQLFE]: Exception executing 'CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Haltepunkt` (`Haltepunkt_Nr`), CONSTRAINT `XFK_Kunde_TN` FOREIGN KEY (`Kunde_Nr`) REFERENCES `TEMPRSS`.`Kunde` (`Kunde_Nr`), CONSTRAINT `XFK_TN_Kabine` FOREIGN KEY (`Kabine_Nr`) REFERENCES `TEMPRSS`.`Kabine` (`Kabine_Nr`), CONSTRAINT `XFK_TN_Zimmer` FOREIGN KEY (`Zimmer_Nr`) REFERENCES `TEMPRSS`.`Zimmer` (`Zimmer_Nr`), CONSTRAINT `Teilnehmergruppe` FOREIGN KEY (`Teilnehmergruppe_Nr`) REFERENCES `TEMPRSS`.`Teilnehmergruppe` (`Teilnehmergruppe_Nr`))': Error executing 'CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Haltepunkt` (`Haltepunkt_Nr`), CONSTRAINT `XFK_Kunde_TN` FOREIGN KEY (`Kunde_Nr`) REFERENCES `TEMPRSS`.`Kunde` (`Kunde_Nr`), CONSTRAINT `XFK_TN_Kabine` FOREIGN KEY (`Kabine_Nr`) REFERENCES `TEMPRSS`.`Kabine` (`Kabine_Nr`), CONSTRAINT `XFK_TN_Zimmer` FOREIGN KEY (`Zimmer_Nr`) REFERENCES `TEMPRSS`.`Zimmer` (`Zimmer_Nr`), CONSTRAINT `Teilnehmergruppe` FOREIGN KEY (`Teilnehmergruppe_Nr`) REFERENCES `TEMPRSS`.`Teilnehmergruppe` (`Teilnehmergruppe_Nr`))' Can't write; duplicate key in table 'teilnehmer'. SQL Error: 1022 16:02:16 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Konto_KT` (`Konto_KT_Nr`), CONSTRAINT `FK_Konto_FL_Agentur` FOREIGN KEY (`Konto_FL_Nr`) REFERENCES `TEMPRSS`.`Konto` (`Konto_Nr`), CONSTRAINT `FK_Konto_FL_KT_Agentur` FOREIGN KEY (`Konto_KT_FL_Nr`) REFERENCES `TEMPRSS`.`Konto_KT` (`Konto_KT_Nr`)) 16:02:16 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Preis` (`Preis_Nr`)) 16:02:16 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `Reise_1` FOREIGN KEY (`Reise_Nr`) REFERENCES `TEMPRSS`.`Reise` (`Reise_Nr`), CONSTRAINT `Termin` FOREIGN KEY (`Termin_Nr` , `Reise_Nr`) REFERENCES `TEMPRSS`.`Termin` (`Termin_Nr` , `Reise_Nr`), CONSTRAINT `Konto_KT` FOREIGN KEY (`Konto_KT_Nr`) REFERENCES `TEMPRSS`.`Konto_KT` (`Konto_KT_Nr`), CONSTRAINT `Bus_Daten_1` FOREIGN KEY (`Bus_Nr`) REFERENCES `TEMPRSS`.`Bus_Daten` (`Bus_Nr`)) 16:02:17 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Teilnehmergruppe` (`Teilnehmergruppe_Nr`), CONSTRAINT `XFL_Preis_Z_F` FOREIGN KEY (`Preis_Nr`) REFERENCES `TEMPRSS`.`Preis` (`Preis_Nr`), CONSTRAINT `XFK_Kunde_Zahlung_F` FOREIGN KEY (`Kunde_Nr`) REFERENCES `TEMPRSS`.`Kunde` (`Kunde_Nr`)) 16:02:17 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`Drucker` ( `Drucker_Nr` INT(4) NOT NULL, `Bezeichnung` VARCHAR(255) NULL, PRIMARY KEY (`Drucker_Nr`), UNIQUE INDEX `XPKDrucker` (`Drucker_Nr` ASC)) 16:02:17 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`permmgr_groups` ( `Gr_Name` VARCHAR(128) NOT NULL, UNIQUE INDEX `permmgr_groups UNIQUE (Gr_Name)` (`Gr_Name` ASC)) 16:02:17 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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)) 16:02:17 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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)) 16:02:18 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`adresse` (`adresse_nr`)) 16:02:18 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`Konto_Kategorie` ( `Kategorie_Nr` INT(4) NOT NULL, `Kategorie` CHAR(50) NULL, PRIMARY KEY (`Kategorie_Nr`), UNIQUE INDEX `Kategorie_Nr` (`Kategorie_Nr` ASC)) 16:02:18 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `Agentur_1` FOREIGN KEY (`Agentur_Nr`) REFERENCES `TEMPRSS`.`Agentur` (`Agentur_Nr`)) 16:02:18 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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)) 16:02:19 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`adresse` (`adresse_nr`)) 16:02:19 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `Reise_2` FOREIGN KEY (`Reise_Nr`) REFERENCES `TEMPRSS`.`Reise` (`Reise_Nr`)) 16:02:19 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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)) 16:02:19 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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)) 16:02:19 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`Archiv_Reise` ( `Reise_Nr` INT(4) NOT NULL, `Titel` CHAR(30) NULL, PRIMARY KEY (`Reise_Nr`), UNIQUE INDEX `XPKE_35` (`Reise_Nr` ASC)) 16:02:19 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `Preis_1` FOREIGN KEY (`Preis_Nr`) REFERENCES `TEMPRSS`.`Preis` (`Preis_Nr`), CONSTRAINT `Teilnehmergruppe_1` FOREIGN KEY (`Teilnehmergruppe_Nr`) REFERENCES `TEMPRSS`.`Teilnehmergruppe` (`Teilnehmergruppe_Nr`), CONSTRAINT `XFK_Kunde_Zahlung` FOREIGN KEY (`Kunde_Nr`) REFERENCES `TEMPRSS`.`Kunde` (`Kunde_Nr`)) 16:02:20 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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_Kategorie_1` FOREIGN KEY (`Kategorie_Nr`) REFERENCES `TEMPRSS`.`Konto_Kategorie` (`Kategorie_Nr`)) 16:02:20 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Zimmer` (`Zimmer_Nr`), CONSTRAINT `XFK_KZ_Buchung` FOREIGN KEY (`Buchung_Nr`) REFERENCES `TEMPRSS`.`Buchung` (`Buchung_Nr`)) 16:02:20 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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_Daten_2` FOREIGN KEY (`Bus_Nr`) REFERENCES `TEMPRSS`.`Bus_Daten` (`Bus_Nr`)) 16:02:20 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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)) 16:02:20 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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)) 16:02:21 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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)) 16:02:21 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `Preis_2` FOREIGN KEY (`Preis_Nr`) REFERENCES `TEMPRSS`.`Preis` (`Preis_Nr`), CONSTRAINT `FK_Preis` FOREIGN KEY (`Preis_Nr`) REFERENCES `TEMPRSS`.`Preis` (`Preis_Nr`), CONSTRAINT `FK_HALTEPUN_ROUTE_ROUTE` FOREIGN KEY (`Route_Nr`) REFERENCES `TEMPRSS`.`Route` (`Route_Nr`)) 16:02:21 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`Kategorie` ( `Kategorie_Nr` INT(4) NOT NULL, `Kategorie` CHAR(50) NULL, PRIMARY KEY (`Kategorie_Nr`), UNIQUE INDEX `XPKKategorie` (`Kategorie_Nr` ASC)) 16:02:21 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Report` (`Report_Nr`)) 16:02:21 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Anrede` (`Anrede_Nr`), CONSTRAINT `XFK_Adresse_Land` FOREIGN KEY (`Land_Nr`) REFERENCES `TEMPRSS`.`Land` (`Land_Nr`), CONSTRAINT `XFK_Adresse_Titel` FOREIGN KEY (`Titel_Nr`) REFERENCES `TEMPRSS`.`Titel` (`Titel_Nr`), CONSTRAINT `XFK_Adresse_Briefanrede` FOREIGN KEY (`Briefanrede_Nr`) REFERENCES `TEMPRSS`.`Briefanrede` (`Briefanrede_Nr`)) 16:02:22 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`Drucker_Kommando` ( `Kommando_Nr` INT(4) NOT NULL, `Bezeichnung` VARCHAR(255) NULL, PRIMARY KEY (`Kommando_Nr`), UNIQUE INDEX `XPKDrucker_Kommando` (`Kommando_Nr` ASC)) 16:02:22 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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)) 16:02:22 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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_1` FOREIGN KEY (`Konto_Nr`) REFERENCES `TEMPRSS`.`Konto` (`Konto_Nr`), CONSTRAINT `Konto_KT_1` FOREIGN KEY (`Konto_KT_Nr`) REFERENCES `TEMPRSS`.`Konto_KT` (`Konto_KT_Nr`)) 16:02:22 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Route_template` (`Route_Nr`), CONSTRAINT `FK_ROUTE_HA_HALTEPUNK_HALTEPUN` FOREIGN KEY (`Haltepunkt_Nr`) REFERENCES `TEMPRSS`.`Haltepunkt_template` (`Haltepunkt_Nr`)) 16:02:23 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Konto_Beleg` (`Beleg_Nr`), CONSTRAINT `XFK_TG_AF` FOREIGN KEY (`Teilnehmergruppe_Nr`) REFERENCES `TEMPRSS`.`Teilnehmergruppe` (`Teilnehmergruppe_Nr`), CONSTRAINT `XFK_ZF_AF` FOREIGN KEY (`Zahlung_Fremd_Nr`) REFERENCES `TEMPRSS`.`Zahlung_Fremd` (`Zahlung_Fremd_Nr`), CONSTRAINT `XFK_Agentur_AF` FOREIGN KEY (`Agentur_Nr`) REFERENCES `TEMPRSS`.`Agentur` (`Agentur_Nr`), CONSTRAINT `XFK_Kunde_Auftrag_F` FOREIGN KEY (`Kunde_Nr`) REFERENCES `TEMPRSS`.`Kunde` (`Kunde_Nr`)) 16:02:23 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Drucker` (`Drucker_Nr`), CONSTRAINT `Drucker_Kommando` FOREIGN KEY (`Kommando_Nr`) REFERENCES `TEMPRSS`.`Drucker_Kommando` (`Kommando_Nr`)) 16:02:23 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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) 16:02:23 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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)) 16:02:23 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `Reise_3` FOREIGN KEY (`Reise_Nr`) REFERENCES `TEMPRSS`.`Reise` (`Reise_Nr`)) 16:02:23 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`permmgr_tabs` ( `Gr_Name` VARCHAR(128) NOT NULL, `Tab_Name` VARCHAR(128) NOT NULL) 16:02:24 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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)) 16:02:24 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Kategorie` (`Kategorie_Nr`), CONSTRAINT `XFK_Adresse_Kat_Adr` FOREIGN KEY (`Adresse_Nr`) REFERENCES `TEMPRSS`.`adresse` (`adresse_nr`)) 16:02:24 [INF][ grt]: Scripts for 71 tables, 0 views and 0 routines were executed for schema TEMPRSS 16:02:24 [INF][ grt]: Execute statement SET FOREIGN_KEY_CHECKS = 1 16:03:16 [INF][ Wizard]: Execute 'Connect to Target Database' 16:03:16 [INF][ grt]: Connecting to Mysql@localhost:3306... 16:03:16 [INF][ grt]: Connected 16:03:17 [INF][ Wizard]: Execute 'Perform Checks in Target' 16:03:20 [INF][ Wizard]: Starting thread for 'Create Schemas and Objects' 16:03:20 [INF][ grt]: Execute statement SET FOREIGN_KEY_CHECKS = 0 16:03:20 [INF][ grt]: Execute statement CREATE SCHEMA IF NOT EXISTS `TEMPRSS` 16:03:20 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Buchung` (`Buchung_Nr`)) 16:03:20 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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)) 16:03:20 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Agentur` (`Agentur_Nr`), CONSTRAINT `Konto_Beleg` FOREIGN KEY (`Beleg_Nr`) REFERENCES `TEMPRSS`.`Konto_Beleg` (`Beleg_Nr`), CONSTRAINT `teilnehmergruppe` FOREIGN KEY (`Teilnehmergruppe_Nr`) REFERENCES `TEMPRSS`.`Teilnehmergruppe` (`Teilnehmergruppe_Nr`), CONSTRAINT `XFK_Kunde_Auftrag` FOREIGN KEY (`Kunde_Nr`) REFERENCES `TEMPRSS`.`Kunde` (`Kunde_Nr`)) 16:03:20 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Archiv_Termin` (`Termin_Nr`), CONSTRAINT `XFK_Kunde_Archiv_TN` FOREIGN KEY (`Kunde_Nr`) REFERENCES `TEMPRSS`.`Kunde` (`Kunde_Nr`)) 16:03:20 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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)) 16:03:21 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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)) 16:03:22 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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)) 16:03:22 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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)) 16:03:22 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Archiv_Reise` (`Reise_Nr`)) 16:03:22 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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)) 16:03:22 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `Buchung_1` FOREIGN KEY (`Buchung_Nr`) REFERENCES `TEMPRSS`.`Buchung` (`Buchung_Nr`), CONSTRAINT `XFK_Reserv_Kabine` FOREIGN KEY (`Kabine_Nr`) REFERENCES `TEMPRSS`.`Kabine` (`Kabine_Nr`), CONSTRAINT `XFK_Reserv_Zimmer` FOREIGN KEY (`Zimmer_Nr`) REFERENCES `TEMPRSS`.`Zimmer` (`Zimmer_Nr`)) 16:03:22 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Anbieter` (`Anbieter_Nr`), CONSTRAINT `FK_ROUTE_TE_START_END_HALTEPUN` FOREIGN KEY (`Start_Ende_Haltepunkt_Nr`) REFERENCES `TEMPRSS`.`Haltepunkt_template` (`Haltepunkt_Nr`)) 16:03:22 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Reise` (`Reise_Nr`)) 16:03:22 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Land` (`Land_Nr`), CONSTRAINT `Anbieter` FOREIGN KEY (`Anbieter_Nr`) REFERENCES `TEMPRSS`.`Anbieter` (`Anbieter_Nr`)) 16:03:22 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`Anrede` ( `Anrede_Nr` INT(4) NOT NULL, `Anrede` CHAR(15) NULL, PRIMARY KEY (`Anrede_Nr`), UNIQUE INDEX `Anrede_Nr` (`Anrede_Nr` ASC)) 16:03:22 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`adresse` (`adresse_nr`), CONSTRAINT `XFK_Komm_Komm_Art` FOREIGN KEY (`Kommunikation_Art_Nr`) REFERENCES `TEMPRSS`.`Kommunikation_Art` (`Kommunikation_Art_Nr`)) 16:03:22 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Konto_Kategorie` (`Kategorie_Nr`)) 16:03:22 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Kabine` (`Kabine_Nr`), CONSTRAINT `XFK_KK_Buchung` FOREIGN KEY (`Buchung_Nr`) REFERENCES `TEMPRSS`.`Buchung` (`Buchung_Nr`)) 16:03:22 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Konto` (`Konto_Nr`), CONSTRAINT `Konto_Beleg_1` FOREIGN KEY (`Beleg_Nr`) REFERENCES `TEMPRSS`.`Konto_Beleg` (`Beleg_Nr`)) 16:03:22 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Konto_Buchung_Art` (`Buchung_Art_Nr`)) 16:03:22 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Archiv_Konto` (`Konto_Nr`), CONSTRAINT `Archiv_Konto_Beleg` FOREIGN KEY (`Beleg_Nr`) REFERENCES `TEMPRSS`.`Archiv_Konto_Beleg` (`Beleg_Nr`)) 16:03:22 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Agentur` (`Agentur_Nr`), CONSTRAINT `FK_Anbieter_Agentur` FOREIGN KEY (`Anbieter_Nr`) REFERENCES `TEMPRSS`.`Anbieter` (`Anbieter_Nr`)) 16:03:22 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Bus_Daten` (`Bus_Nr`)) 16:03:22 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Preis` (`Preis_Nr`), CONSTRAINT `Anbieter_1` FOREIGN KEY (`Anbieter_Nr`) REFERENCES `TEMPRSS`.`Anbieter` (`Anbieter_Nr`)) 16:03:22 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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)) 16:03:22 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `Konto_Buchung_Art_1` FOREIGN KEY (`Buchung_Art_Nr`) REFERENCES `TEMPRSS`.`Konto_Buchung_Art` (`Buchung_Art_Nr`)) 16:03:22 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`Briefanrede` ( `Briefanrede_Nr` SMALLINT NOT NULL, `Briefanrede` CHAR(50) NULL, PRIMARY KEY (`Briefanrede_Nr`), UNIQUE INDEX `XPKBriefanrede` (`Briefanrede_Nr` ASC)) 16:03:22 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Buchung` (`Buchung_Nr`)) 16:03:22 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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)) 16:03:22 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`Titel` ( `Titel_Nr` INT(4) NOT NULL, `Titel` CHAR(50) NULL, PRIMARY KEY (`Titel_Nr`), UNIQUE INDEX `XPKTitel` (`Titel_Nr` ASC)) 16:03:22 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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_1` FOREIGN KEY (`Konto_Nr`) REFERENCES `TEMPRSS`.`Archiv_Konto` (`Konto_Nr`), CONSTRAINT `Archiv_Konto_KT` FOREIGN KEY (`Konto_KT_Nr`) REFERENCES `TEMPRSS`.`Archiv_Konto_KT` (`Konto_KT_Nr`)) 16:03:22 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Haltepunkt` (`Haltepunkt_Nr`), CONSTRAINT `XFK_Kunde_TN` FOREIGN KEY (`Kunde_Nr`) REFERENCES `TEMPRSS`.`Kunde` (`Kunde_Nr`), CONSTRAINT `XFK_TN_Kabine` FOREIGN KEY (`Kabine_Nr`) REFERENCES `TEMPRSS`.`Kabine` (`Kabine_Nr`), CONSTRAINT `XFK_TN_Zimmer` FOREIGN KEY (`Zimmer_Nr`) REFERENCES `TEMPRSS`.`Zimmer` (`Zimmer_Nr`), CONSTRAINT `Teilnehmergruppe` FOREIGN KEY (`Teilnehmergruppe_Nr`) REFERENCES `TEMPRSS`.`Teilnehmergruppe` (`Teilnehmergruppe_Nr`)) 16:03:23 [WRN][ grt]: Error executing 'CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Haltepunkt` (`Haltepunkt_Nr`), CONSTRAINT `XFK_Kunde_TN` FOREIGN KEY (`Kunde_Nr`) REFERENCES `TEMPRSS`.`Kunde` (`Kunde_Nr`), CONSTRAINT `XFK_TN_Kabine` FOREIGN KEY (`Kabine_Nr`) REFERENCES `TEMPRSS`.`Kabine` (`Kabine_Nr`), CONSTRAINT `XFK_TN_Zimmer` FOREIGN KEY (`Zimmer_Nr`) REFERENCES `TEMPRSS`.`Zimmer` (`Zimmer_Nr`), CONSTRAINT `Teilnehmergruppe` FOREIGN KEY (`Teilnehmergruppe_Nr`) REFERENCES `TEMPRSS`.`Teilnehmergruppe` (`Teilnehmergruppe_Nr`))' Can't write; duplicate key in table 'teilnehmer'. SQL Error: 1022 16:03:23 [ERR][ DbMySQLFE]: Exception executing 'CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Haltepunkt` (`Haltepunkt_Nr`), CONSTRAINT `XFK_Kunde_TN` FOREIGN KEY (`Kunde_Nr`) REFERENCES `TEMPRSS`.`Kunde` (`Kunde_Nr`), CONSTRAINT `XFK_TN_Kabine` FOREIGN KEY (`Kabine_Nr`) REFERENCES `TEMPRSS`.`Kabine` (`Kabine_Nr`), CONSTRAINT `XFK_TN_Zimmer` FOREIGN KEY (`Zimmer_Nr`) REFERENCES `TEMPRSS`.`Zimmer` (`Zimmer_Nr`), CONSTRAINT `Teilnehmergruppe` FOREIGN KEY (`Teilnehmergruppe_Nr`) REFERENCES `TEMPRSS`.`Teilnehmergruppe` (`Teilnehmergruppe_Nr`))': Error executing 'CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Haltepunkt` (`Haltepunkt_Nr`), CONSTRAINT `XFK_Kunde_TN` FOREIGN KEY (`Kunde_Nr`) REFERENCES `TEMPRSS`.`Kunde` (`Kunde_Nr`), CONSTRAINT `XFK_TN_Kabine` FOREIGN KEY (`Kabine_Nr`) REFERENCES `TEMPRSS`.`Kabine` (`Kabine_Nr`), CONSTRAINT `XFK_TN_Zimmer` FOREIGN KEY (`Zimmer_Nr`) REFERENCES `TEMPRSS`.`Zimmer` (`Zimmer_Nr`), CONSTRAINT `Teilnehmergruppe` FOREIGN KEY (`Teilnehmergruppe_Nr`) REFERENCES `TEMPRSS`.`Teilnehmergruppe` (`Teilnehmergruppe_Nr`))' Can't write; duplicate key in table 'teilnehmer'. SQL Error: 1022 16:03:23 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Konto_KT` (`Konto_KT_Nr`), CONSTRAINT `FK_Konto_FL_Agentur` FOREIGN KEY (`Konto_FL_Nr`) REFERENCES `TEMPRSS`.`Konto` (`Konto_Nr`), CONSTRAINT `FK_Konto_FL_KT_Agentur` FOREIGN KEY (`Konto_KT_FL_Nr`) REFERENCES `TEMPRSS`.`Konto_KT` (`Konto_KT_Nr`)) 16:03:23 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Preis` (`Preis_Nr`)) 16:03:23 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `Reise_1` FOREIGN KEY (`Reise_Nr`) REFERENCES `TEMPRSS`.`Reise` (`Reise_Nr`), CONSTRAINT `Termin` FOREIGN KEY (`Termin_Nr` , `Reise_Nr`) REFERENCES `TEMPRSS`.`Termin` (`Termin_Nr` , `Reise_Nr`), CONSTRAINT `Konto_KT` FOREIGN KEY (`Konto_KT_Nr`) REFERENCES `TEMPRSS`.`Konto_KT` (`Konto_KT_Nr`), CONSTRAINT `Bus_Daten_1` FOREIGN KEY (`Bus_Nr`) REFERENCES `TEMPRSS`.`Bus_Daten` (`Bus_Nr`)) 16:03:23 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Teilnehmergruppe` (`Teilnehmergruppe_Nr`), CONSTRAINT `XFL_Preis_Z_F` FOREIGN KEY (`Preis_Nr`) REFERENCES `TEMPRSS`.`Preis` (`Preis_Nr`), CONSTRAINT `XFK_Kunde_Zahlung_F` FOREIGN KEY (`Kunde_Nr`) REFERENCES `TEMPRSS`.`Kunde` (`Kunde_Nr`)) 16:03:23 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`Drucker` ( `Drucker_Nr` INT(4) NOT NULL, `Bezeichnung` VARCHAR(255) NULL, PRIMARY KEY (`Drucker_Nr`), UNIQUE INDEX `XPKDrucker` (`Drucker_Nr` ASC)) 16:03:23 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`permmgr_groups` ( `Gr_Name` VARCHAR(128) NOT NULL, UNIQUE INDEX `permmgr_groups UNIQUE (Gr_Name)` (`Gr_Name` ASC)) 16:03:24 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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)) 16:03:24 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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)) 16:03:24 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`adresse` (`adresse_nr`)) 16:03:24 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`Konto_Kategorie` ( `Kategorie_Nr` INT(4) NOT NULL, `Kategorie` CHAR(50) NULL, PRIMARY KEY (`Kategorie_Nr`), UNIQUE INDEX `Kategorie_Nr` (`Kategorie_Nr` ASC)) 16:03:24 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `Agentur_1` FOREIGN KEY (`Agentur_Nr`) REFERENCES `TEMPRSS`.`Agentur` (`Agentur_Nr`)) 16:03:24 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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)) 16:03:24 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`adresse` (`adresse_nr`)) 16:03:24 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `Reise_2` FOREIGN KEY (`Reise_Nr`) REFERENCES `TEMPRSS`.`Reise` (`Reise_Nr`)) 16:03:24 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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)) 16:03:24 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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)) 16:03:24 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`Archiv_Reise` ( `Reise_Nr` INT(4) NOT NULL, `Titel` CHAR(30) NULL, PRIMARY KEY (`Reise_Nr`), UNIQUE INDEX `XPKE_35` (`Reise_Nr` ASC)) 16:03:24 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `Preis_1` FOREIGN KEY (`Preis_Nr`) REFERENCES `TEMPRSS`.`Preis` (`Preis_Nr`), CONSTRAINT `Teilnehmergruppe_1` FOREIGN KEY (`Teilnehmergruppe_Nr`) REFERENCES `TEMPRSS`.`Teilnehmergruppe` (`Teilnehmergruppe_Nr`), CONSTRAINT `XFK_Kunde_Zahlung` FOREIGN KEY (`Kunde_Nr`) REFERENCES `TEMPRSS`.`Kunde` (`Kunde_Nr`)) 16:03:24 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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_Kategorie_1` FOREIGN KEY (`Kategorie_Nr`) REFERENCES `TEMPRSS`.`Konto_Kategorie` (`Kategorie_Nr`)) 16:03:24 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Zimmer` (`Zimmer_Nr`), CONSTRAINT `XFK_KZ_Buchung` FOREIGN KEY (`Buchung_Nr`) REFERENCES `TEMPRSS`.`Buchung` (`Buchung_Nr`)) 16:03:24 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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_Daten_2` FOREIGN KEY (`Bus_Nr`) REFERENCES `TEMPRSS`.`Bus_Daten` (`Bus_Nr`)) 16:03:24 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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)) 16:03:24 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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)) 16:03:24 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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)) 16:03:24 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `Preis_2` FOREIGN KEY (`Preis_Nr`) REFERENCES `TEMPRSS`.`Preis` (`Preis_Nr`), CONSTRAINT `FK_Preis` FOREIGN KEY (`Preis_Nr`) REFERENCES `TEMPRSS`.`Preis` (`Preis_Nr`), CONSTRAINT `FK_HALTEPUN_ROUTE_ROUTE` FOREIGN KEY (`Route_Nr`) REFERENCES `TEMPRSS`.`Route` (`Route_Nr`)) 16:03:24 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`Kategorie` ( `Kategorie_Nr` INT(4) NOT NULL, `Kategorie` CHAR(50) NULL, PRIMARY KEY (`Kategorie_Nr`), UNIQUE INDEX `XPKKategorie` (`Kategorie_Nr` ASC)) 16:03:24 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Report` (`Report_Nr`)) 16:03:24 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Anrede` (`Anrede_Nr`), CONSTRAINT `XFK_Adresse_Land` FOREIGN KEY (`Land_Nr`) REFERENCES `TEMPRSS`.`Land` (`Land_Nr`), CONSTRAINT `XFK_Adresse_Titel` FOREIGN KEY (`Titel_Nr`) REFERENCES `TEMPRSS`.`Titel` (`Titel_Nr`), CONSTRAINT `XFK_Adresse_Briefanrede` FOREIGN KEY (`Briefanrede_Nr`) REFERENCES `TEMPRSS`.`Briefanrede` (`Briefanrede_Nr`)) 16:03:24 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`Drucker_Kommando` ( `Kommando_Nr` INT(4) NOT NULL, `Bezeichnung` VARCHAR(255) NULL, PRIMARY KEY (`Kommando_Nr`), UNIQUE INDEX `XPKDrucker_Kommando` (`Kommando_Nr` ASC)) 16:03:24 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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)) 16:03:24 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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_1` FOREIGN KEY (`Konto_Nr`) REFERENCES `TEMPRSS`.`Konto` (`Konto_Nr`), CONSTRAINT `Konto_KT_1` FOREIGN KEY (`Konto_KT_Nr`) REFERENCES `TEMPRSS`.`Konto_KT` (`Konto_KT_Nr`)) 16:03:25 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Route_template` (`Route_Nr`), CONSTRAINT `FK_ROUTE_HA_HALTEPUNK_HALTEPUN` FOREIGN KEY (`Haltepunkt_Nr`) REFERENCES `TEMPRSS`.`Haltepunkt_template` (`Haltepunkt_Nr`)) 16:03:25 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Konto_Beleg` (`Beleg_Nr`), CONSTRAINT `XFK_TG_AF` FOREIGN KEY (`Teilnehmergruppe_Nr`) REFERENCES `TEMPRSS`.`Teilnehmergruppe` (`Teilnehmergruppe_Nr`), CONSTRAINT `XFK_ZF_AF` FOREIGN KEY (`Zahlung_Fremd_Nr`) REFERENCES `TEMPRSS`.`Zahlung_Fremd` (`Zahlung_Fremd_Nr`), CONSTRAINT `XFK_Agentur_AF` FOREIGN KEY (`Agentur_Nr`) REFERENCES `TEMPRSS`.`Agentur` (`Agentur_Nr`), CONSTRAINT `XFK_Kunde_Auftrag_F` FOREIGN KEY (`Kunde_Nr`) REFERENCES `TEMPRSS`.`Kunde` (`Kunde_Nr`)) 16:03:25 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Drucker` (`Drucker_Nr`), CONSTRAINT `Drucker_Kommando` FOREIGN KEY (`Kommando_Nr`) REFERENCES `TEMPRSS`.`Drucker_Kommando` (`Kommando_Nr`)) 16:03:25 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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) 16:03:25 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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)) 16:03:25 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `Reise_3` FOREIGN KEY (`Reise_Nr`) REFERENCES `TEMPRSS`.`Reise` (`Reise_Nr`)) 16:03:25 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`permmgr_tabs` ( `Gr_Name` VARCHAR(128) NOT NULL, `Tab_Name` VARCHAR(128) NOT NULL) 16:03:25 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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)) 16:03:25 [INF][ grt]: Execute statement CREATE TABLE IF NOT EXISTS `TEMPRSS`.`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 `TEMPRSS`.`Kategorie` (`Kategorie_Nr`), CONSTRAINT `XFK_Adresse_Kat_Adr` FOREIGN KEY (`Adresse_Nr`) REFERENCES `TEMPRSS`.`adresse` (`adresse_nr`)) 16:03:27 [INF][ grt]: Scripts for 71 tables, 0 views and 0 routines were executed for schema TEMPRSS 16:03:27 [INF][ grt]: Execute statement SET FOREIGN_KEY_CHECKS = 1 16:03:59 [ERR][ pymforms]: Unhandled exception in Python code: DbSQLAnywhereRE.getOS(): expected list 16:04:08 [ERR][ python]: Error forwarding notification to PythonTraceback (most recent call last): 16:04:08 [ERR][ python]: File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\workbench\notifications.py", line 31, in _the_observer 16:04:08 [ERR][ python]: for obs, nam, obj in self.observers: 16:04:08 [ERR][ python]: File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_schema_creation.py", line 313, in go_next 16:04:08 [ERR][ python]: WizardPage.go_next(self) 16:04:08 [ERR][ python]: File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\workbench\wizard_page_widget.py", line 90, in go_next 16:04:08 [ERR][ python]: self.main.go_next_page() 16:04:08 [ERR][ python]: File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_main.py", line 286, in go_next_page 16:04:08 [ERR][ python]: self.section_clicked(next.identifier()) 16:04:08 [ERR][ python]: File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_main.py", line 207, in section_clicked 16:04:08 [ERR][ python]: self.tab_changed() 16:04:08 [ERR][ python]: File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_main.py", line 218, in tab_changed 16:04:08 [ERR][ python]: self.active_tab.page_activated(self._advancing) 16:04:08 [ERR][ python]: File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_data_transfer.py", line 265, in page_activated 16:04:08 [ERR][ python]: source_os = self.main.plan.migrationSource.get_os() 16:04:08 [ERR][ python]: File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.py", line 381, in get_os 16:04:08 [ERR][ python]: return self.module_re().getOS(self.connection) 16:04:08 [ERR][ python]: SystemError: DbSQLAnywhereRE.getOS(): expected list