{21990CF8-D93E-450E-A976-9C9DB8FA9153} {C3B29E68-ED16-46A3-BAD3-5990FB4C7FEE} {43903B6E-F2D0-4529-9B67-E0717BF4EF9F} {3AC6FA9A-82A4-4F7A-98B9-1F12CFB202BF} {9D4131DD-68A4-40BC-9D3F-82B4F7FA17B1} {6ABFE754-D874-49FF-AC49-386F49B841AC} {E2E563B6-7240-4D2B-A665-CE22EBD29E9F} {AEFED982-F313-40D4-ABA9-11583190507F} {A4E5546A-E0F8-4601-9DC3-D39C7DE1FD72} {2F780E59-D0CF-4175-8473-C86D73B33ED6} {E986FF81-4A4E-4A5D-B792-8D70F05A1BDE} {41103BE4-2115-4129-A4F3-0EC70E1A7CA6} {9069C68C-56AA-40EA-9C14-1542D5226355} {A9BCA02E-A707-4832-A9A2-61F0A56F25C2} {091F9B2C-FC20-47D4-B7EC-E31EF07828FF} {FECE8C4D-B95C-4D06-B5E5-7C685B512607} {52DEA621-FBB4-4FC5-88C6-936CC3F53579} {FD0CE66F-4075-48FB-AF79-C75453274791} {AF1906F2-20B5-491C-8450-14F730DBECD8} {2BA9756D-C757-4770-B795-B1A4943359EC} {B5603A47-2936-4144-BA74-5D4B6959F47F} {A50D3C42-2BE0-49C7-A751-59ADDC334F01} {38416973-B84F-48DF-A766-01022A48B7CB} {FEDC8872-11CC-47CA-810A-6CCC2FAC6624} {B37E43B5-C83C-49A6-81FD-21424E22A0CC} {69774387-87EB-4929-95F7-666E7081C341} {EFA25F7E-F252-4083-A7E7-0E0B51D2C7A6} {82133B64-E91A-4EAB-96E7-5211E354E818} {3006DAE4-DDE9-4979-B982-8284D885ED2A} {6C8C05CC-8859-4974-B756-497697DB875F} {99441A25-E2A8-4B71-A311-AA46C216D6A9} {B670A3DE-8FD2-4508-A437-4EE82D3F184A} {EF353851-0BAE-450A-8751-D96E58402C08} {25D735B3-3DBA-4EF7-95C9-B94E5A480D40} {F312E41B-8ECF-4B2D-B084-B22186F114AE} {7A92AB4C-BB3F-47B9-BC98-4F55CF8690A3} {3EE67D94-4290-4A37-A0A3-73E2602C2971} {EF2A81A5-CB47-46E3-9FC5-203D7DA8EA10} default default {21990CF8-D93E-450E-A976-9C9DB8FA9153} {F7EBBC3C-09AF-41F5-BA74-1BF5D8190C42} 0 latin1 officedirekt officedirekt {C3B29E68-ED16-46A3-BAD3-5990FB4C7FEE} {6F8E14EB-0F22-4877-B87F-5547793959BE} {B79D83C3-BEB3-4B66-8606-E2A82E45B5B9} 0 utf8_general_ci VARCHAR '' 0 0 1 PLZ_Bezirk_ID PLZ_Bezirk_ID {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} {20494C14-06E0-48B4-B8AE-AE788A6123EF} 0 utf8_general_ci VARCHAR 1 1 50 PLZ_Bezirk PLZ_Bezirk {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} utf8 utf8_general_ci {0CC0A4B1-5E47-44A8-B83E-612EF151A6AE} {B2C57112-9A0F-49BB-9C45-07269A2422E4} 0 PLZ_Bezirk_ID {0CC0A4B1-5E47-44A8-B83E-612EF151A6AE} {B79D83C3-BEB3-4B66-8606-E2A82E45B5B9} PRIMARY BTREE 1 PRIMARY PRIMARY {6F8E14EB-0F22-4877-B87F-5547793959BE} 1 {5CC48673-575E-46EA-9680-0891DACF3357} {D48A9D5C-5DD8-422D-934C-A31157E0B147} 0 PLZ_Bezirk_ID {5CC48673-575E-46EA-9680-0891DACF3357} {B79D83C3-BEB3-4B66-8606-E2A82E45B5B9} BTREE PLZ_Bezirk_ID PLZ_Bezirk_ID {6F8E14EB-0F22-4877-B87F-5547793959BE} 0 0 al_plz_bezirke al_plz_bezirke {F7EBBC3C-09AF-41F5-BA74-1BF5D8190C42} {0CC0A4B1-5E47-44A8-B83E-612EF151A6AE} Dynamic CREATE TABLE `al_plz_bezirke` ( `PLZ_Bezirk_ID` varchar(1) NOT NULL, `PLZ_Bezirk` varchar(50) default NULL, PRIMARY KEY (`PLZ_Bezirk_ID`), KEY `PLZ_Bezirk_ID` (`PLZ_Bezirk_ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 MyISAM {13089361-DF84-4192-8BC4-FD1916B86808} {E4B71736-E5EE-40A9-B098-88AD8FEFE697} 1 INT 1 0 Angebotsindex Angebotsindex 10 0 {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} {3658CFB3-ED76-43C9-9616-77855D6E33FE} 0 INT 1 1 Kundenindex Kundenindex 10 0 {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} {60E906C2-464A-4943-A42D-47B3BC100CDD} 0 DATETIME 1 1 AngebotsDatum AngebotsDatum {9A2399C8-F3EA-4B6C-AAB1-830D3BFF164B} {E5921529-D1F1-40F5-9F6A-539E853FA2D0} 0 TINYINT '' 0 0 Bestellt Bestellt 1 0 {3C75C19F-FCA4-44DE-8881-F477FEA32E62} {0DC7811A-B513-4F06-A015-3E52ABE2569A} 0 DATETIME 1 1 Rechnungsdatum Rechnungsdatum {9A2399C8-F3EA-4B6C-AAB1-830D3BFF164B} utf8 utf8_general_ci {6FFAC7C9-698B-42FD-AE76-A392DA522E7B} {9C4048EC-2A25-4169-8CD6-1011F0393A20} 0 Angebotsindex {6FFAC7C9-698B-42FD-AE76-A392DA522E7B} {E4B71736-E5EE-40A9-B098-88AD8FEFE697} PRIMARY BTREE 1 PRIMARY PRIMARY {13089361-DF84-4192-8BC4-FD1916B86808} 1 0 angebote 1 angebote {F7EBBC3C-09AF-41F5-BA74-1BF5D8190C42} {6FFAC7C9-698B-42FD-AE76-A392DA522E7B} Fixed CREATE TABLE `angebote` ( `Angebotsindex` int(10) NOT NULL auto_increment, `Kundenindex` int(10) default NULL, `AngebotsDatum` datetime default NULL, `Bestellt` tinyint(1) NOT NULL, `Rechnungsdatum` datetime default NULL, PRIMARY KEY (`Angebotsindex`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 MyISAM {520332F3-919A-451B-ABB9-BD27C7E50E4D} {6875B8CA-9F38-487C-B11A-FF841DA4E5B8} 1 INT 1 0 Artikel_ID Artikel_ID 10 0 {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} {4C6721B7-884A-4B2E-B2D3-A27BD2154FFF} 0 utf8_general_ci VARCHAR 1 1 50 Artikelname Artikelname {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} {BFFCF330-EA3E-4C7C-9FAE-1533D55B95E1} 0 INT 1 1 Lieferanten_ID Lieferanten_ID 10 0 {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} {F8F61852-98B5-4EC3-8CC7-FB0A80C8646F} 0 INT 1 1 Kategorie_ID Kategorie_ID 10 0 {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} {F5A6CDF0-8261-49C7-A64A-7E3D59C4DDF7} 0 DECIMAL 1 1 Preis Preis 19 4 {8CB74E5F-921A-4F6E-95C6-3AD94F2BB36F} {55260D5C-B86D-4AFB-8EFF-30B44C9CF08D} 0 SMALLINT 1 1 Lagerbestand Lagerbestand 5 0 {B98335A2-603F-4042-9D59-88248D987309} {CE4B0785-CF93-4A88-82D0-90435D0C851D} 0 SMALLINT 1 1 BestellteEinheiten BestellteEinheiten 5 0 {B98335A2-603F-4042-9D59-88248D987309} {D7979410-5E33-4CFE-A97A-1A155DBE48BB} 0 SMALLINT 1 1 Mindestbestand Mindestbestand 5 0 {B98335A2-603F-4042-9D59-88248D987309} {8BCB4A77-68A3-4AEB-841A-DCB4E3F20919} 0 TINYINT '' 0 0 Auslaufartikel Auslaufartikel 1 0 {3C75C19F-FCA4-44DE-8881-F477FEA32E62} utf8 utf8_general_ci {2BAE57AC-E4C4-4689-8AA1-DB222CE2E9D8} {2E75EAAE-3398-4543-A2BA-D6B7EEA84ADC} 0 Artikel_ID {2BAE57AC-E4C4-4689-8AA1-DB222CE2E9D8} {6875B8CA-9F38-487C-B11A-FF841DA4E5B8} PRIMARY BTREE 1 PRIMARY PRIMARY {520332F3-919A-451B-ABB9-BD27C7E50E4D} 1 {53F2CFF3-51D5-4542-8514-54FFBA8F18D0} {15FD12EB-D82C-410A-9C60-7401DA09BE38} 0 Kategorie_ID {53F2CFF3-51D5-4542-8514-54FFBA8F18D0} {F8F61852-98B5-4EC3-8CC7-FB0A80C8646F} BTREE ArtikelKategorie-Nr ArtikelKategorie-Nr {520332F3-919A-451B-ABB9-BD27C7E50E4D} 0 {38F16361-E8A1-4E3B-B5AB-CB4EF71A225D} {03F7AEEE-FD17-4658-9135-7C703F472554} 0 Artikelname {38F16361-E8A1-4E3B-B5AB-CB4EF71A225D} {4C6721B7-884A-4B2E-B2D3-A27BD2154FFF} BTREE Artikelname Artikelname {520332F3-919A-451B-ABB9-BD27C7E50E4D} 0 {09206F68-803C-4B6E-9845-745CDB786049} {3DC96FFE-CC3E-4B6E-817D-59228ADAC6F3} 0 Kategorie_ID {09206F68-803C-4B6E-9845-745CDB786049} {F8F61852-98B5-4EC3-8CC7-FB0A80C8646F} BTREE KategorienArtikel KategorienArtikel {520332F3-919A-451B-ABB9-BD27C7E50E4D} 0 {8AEF8385-F8A8-4FDA-8EDD-9450079DBBA0} {6637CCBF-389B-4D26-B4FE-57B86D0A3625} 0 Kategorie_ID {8AEF8385-F8A8-4FDA-8EDD-9450079DBBA0} {F8F61852-98B5-4EC3-8CC7-FB0A80C8646F} BTREE Kategorie-Nr Kategorie-Nr {520332F3-919A-451B-ABB9-BD27C7E50E4D} 0 {EBE57049-353A-4826-A403-B578F58462EF} {5FB61AD3-2EB6-430A-83CF-FAF66597BA04} 0 Lieferanten_ID {EBE57049-353A-4826-A403-B578F58462EF} {BFFCF330-EA3E-4C7C-9FAE-1533D55B95E1} BTREE LieferantenArtikel1 LieferantenArtikel1 {520332F3-919A-451B-ABB9-BD27C7E50E4D} 0 {35939EE4-4558-439B-9241-C1F43CAF0EB3} {A44C8878-07D9-4789-BAA2-3BD7E9928BF8} 0 Lieferanten_ID {35939EE4-4558-439B-9241-C1F43CAF0EB3} {BFFCF330-EA3E-4C7C-9FAE-1533D55B95E1} BTREE Lieferanten-Nr Lieferanten-Nr {520332F3-919A-451B-ABB9-BD27C7E50E4D} 0 0 artikel 1 artikel {F7EBBC3C-09AF-41F5-BA74-1BF5D8190C42} {2BAE57AC-E4C4-4689-8AA1-DB222CE2E9D8} Dynamic CREATE TABLE `artikel` ( `Artikel_ID` int(10) NOT NULL auto_increment, `Artikelname` varchar(50) default NULL, `Lieferanten_ID` int(10) default NULL, `Kategorie_ID` int(10) default NULL, `Preis` decimal(19,4) default NULL, `Lagerbestand` smallint(5) default NULL, `BestellteEinheiten` smallint(5) default NULL, `Mindestbestand` smallint(5) default NULL, `Auslaufartikel` tinyint(1) NOT NULL, PRIMARY KEY (`Artikel_ID`), KEY `ArtikelKategorie-Nr` (`Kategorie_ID`), KEY `Artikelname` (`Artikelname`), KEY `KategorienArtikel` (`Kategorie_ID`), KEY `Kategorie-Nr` (`Kategorie_ID`), KEY `LieferantenArtikel1` (`Lieferanten_ID`), KEY `Lieferanten-Nr` (`Lieferanten_ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 MyISAM {160CAF70-B045-4E25-87F7-0A3EDB3A0416} {5915082D-7747-4477-9FBF-B3E6C7FC667C} 0 INT '' 0 0 ArtikelNr ArtikelNr 10 0 {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} {D74FA0A9-D261-433E-BB52-CA188871A706} 0 INT '' 0 0 LieferantenNr LieferantenNr 10 0 {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} {F65C3981-C9AF-4C2F-A7AD-7581BF93365E} 0 utf8_general_ci VARCHAR 1 1 20 LieferArtikelNr LieferArtikelNr {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} {9864D1A5-A939-47D3-AA97-52D8A66875A5} 0 DECIMAL 1 1 EKPreis EKPreis 19 4 {8CB74E5F-921A-4F6E-95C6-3AD94F2BB36F} {7FB7692A-C032-4FE5-92A0-3ED0E6AFBC6D} 0 TINYINT '' 0 0 Auslaufartikel Auslaufartikel 1 0 {3C75C19F-FCA4-44DE-8881-F477FEA32E62} utf8 utf8_general_ci {E92B0E74-E9EE-4911-AFB3-946B345332C6} {57664A98-3034-4342-894B-05AE914B1F8C} 0 ArtikelNr {E92B0E74-E9EE-4911-AFB3-946B345332C6} {5915082D-7747-4477-9FBF-B3E6C7FC667C} {8F158846-AA29-4586-AD26-4D94FCE09B48} 0 LieferantenNr {E92B0E74-E9EE-4911-AFB3-946B345332C6} {D74FA0A9-D261-433E-BB52-CA188871A706} PRIMARY BTREE 1 PRIMARY PRIMARY {160CAF70-B045-4E25-87F7-0A3EDB3A0416} 1 0 artikelundlieferanten artikelundlieferanten {F7EBBC3C-09AF-41F5-BA74-1BF5D8190C42} {E92B0E74-E9EE-4911-AFB3-946B345332C6} Dynamic CREATE TABLE `artikelundlieferanten` ( `ArtikelNr` int(10) NOT NULL, `LieferantenNr` int(10) NOT NULL, `LieferArtikelNr` varchar(20) default NULL, `EKPreis` decimal(19,4) default NULL, `Auslaufartikel` tinyint(1) NOT NULL, PRIMARY KEY (`ArtikelNr`,`LieferantenNr`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 MyISAM {4203B98C-AE79-4B80-AAA5-69239366B900} {4FA036EC-31BD-4B31-AEF8-02E4A75911C4} 0 INT '' 0 0 Bestell_ID Bestell_ID 10 0 {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} {0C03238B-AB93-4829-A312-86FEBC548AE9} 0 INT '' 0 0 Artikel_ID Artikel_ID 10 0 {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} {9E83C687-C5A5-41B9-9EE8-112E71375E05} 0 DECIMAL 1 1 Einzelpreis Einzelpreis 19 4 {8CB74E5F-921A-4F6E-95C6-3AD94F2BB36F} {BE1DA5FB-57FF-4936-AE6B-B292C13EEAD4} 0 SMALLINT 1 1 Anzahl Anzahl 5 0 {B98335A2-603F-4042-9D59-88248D987309} {E679D240-F692-4B90-B973-EF71E2C97F9B} 0 (7,2) DOUBLE 1 1 Rabatt Rabatt {3873BD96-9C60-4BB0-90B4-45F4C76485D9} utf8 utf8_general_ci {BBA98C6E-6AE5-4978-BA38-0F78DBBBAD5E} {6BEBC9F9-5770-45D9-9576-1FDCF775D6AC} 0 Bestell_ID {BBA98C6E-6AE5-4978-BA38-0F78DBBBAD5E} {4FA036EC-31BD-4B31-AEF8-02E4A75911C4} {DD78FE7A-2C04-4235-AF73-5807DE247A85} 0 Artikel_ID {BBA98C6E-6AE5-4978-BA38-0F78DBBBAD5E} {0C03238B-AB93-4829-A312-86FEBC548AE9} PRIMARY BTREE 1 PRIMARY PRIMARY {4203B98C-AE79-4B80-AAA5-69239366B900} 1 {079C14F3-B0F2-43FB-A907-A3948009FC46} {FD3F506E-11C3-49AA-97F7-0A2CEA0C3208} 0 Artikel_ID {079C14F3-B0F2-43FB-A907-A3948009FC46} {0C03238B-AB93-4829-A312-86FEBC548AE9} BTREE ArtikelAuftragspositionen ArtikelAuftragspositionen {4203B98C-AE79-4B80-AAA5-69239366B900} 0 {70EFAC43-C47F-458A-9ECB-AC14179C9DF6} {0F6A31B6-A497-4E6F-885E-39F40B1F30E8} 0 Artikel_ID {70EFAC43-C47F-458A-9ECB-AC14179C9DF6} {0C03238B-AB93-4829-A312-86FEBC548AE9} BTREE Artikel-Nr Artikel-Nr {4203B98C-AE79-4B80-AAA5-69239366B900} 0 {1F7D8932-AFBF-4362-A272-4F2EC73EACFE} {0A1D4EC1-879C-4825-A91E-C7EF0F429BEF} 0 Bestell_ID {1F7D8932-AFBF-4362-A272-4F2EC73EACFE} {4FA036EC-31BD-4B31-AEF8-02E4A75911C4} BTREE AufträgeAuftragspositionen1 AufträgeAuftragspositionen1 {4203B98C-AE79-4B80-AAA5-69239366B900} 0 {CC3AF4BB-CDDE-48C7-88B9-01D8E09968C7} {250C132D-EFB4-4A18-A246-98E4BD0FE7EE} 0 Bestell_ID {CC3AF4BB-CDDE-48C7-88B9-01D8E09968C7} {4FA036EC-31BD-4B31-AEF8-02E4A75911C4} BTREE Bestell-Nr Bestell-Nr {4203B98C-AE79-4B80-AAA5-69239366B900} 0 0 auftragspositionen auftragspositionen {F7EBBC3C-09AF-41F5-BA74-1BF5D8190C42} {BBA98C6E-6AE5-4978-BA38-0F78DBBBAD5E} Fixed CREATE TABLE `auftragspositionen` ( `Bestell_ID` int(10) NOT NULL, `Artikel_ID` int(10) NOT NULL, `Einzelpreis` decimal(19,4) default NULL, `Anzahl` smallint(5) default NULL, `Rabatt` double(7,2) default NULL, PRIMARY KEY (`Bestell_ID`,`Artikel_ID`), KEY `ArtikelAuftragspositionen` (`Artikel_ID`), KEY `Artikel-Nr` (`Artikel_ID`), KEY `AufträgeAuftragspositionen1` (`Bestell_ID`), KEY `Bestell-Nr` (`Bestell_ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 MyISAM {29A5FF45-F0C3-4443-AC28-C2283FC1986D} {1D0D9D06-B220-43DE-8074-D8EC40684030} 1 INT 1 0 Bestell_ID Bestell_ID 10 0 {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} {71E8D91A-0576-4A77-8B5A-E6D89C81F27E} 0 INT 1 1 Kunden_ID Kunden_ID 10 0 {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} {7D573A52-37C4-437F-814E-902D6579F055} 0 INT 1 1 Mitarbeiter_ID Mitarbeiter_ID 10 0 {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} {2F1FC324-BB4A-46BD-8848-1EA6C7E5D035} 0 DATETIME 1 1 Bestelldatum Bestelldatum {9A2399C8-F3EA-4B6C-AAB1-830D3BFF164B} {492D3030-DFD5-4547-9986-7B49A187C355} 0 DATETIME 1 1 Versanddatum Versanddatum {9A2399C8-F3EA-4B6C-AAB1-830D3BFF164B} {3A5F57A5-C094-4D54-8368-E6C1CA5524B3} 0 INT 1 1 Spediteur_ID Spediteur_ID 10 0 {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} {5ABCF177-5C0F-4315-8B0C-33C4EFDB8B71} 0 DECIMAL 1 1 Frachtkosten Frachtkosten 19 4 {8CB74E5F-921A-4F6E-95C6-3AD94F2BB36F} utf8 utf8_general_ci {53158C39-C36B-45B0-BF6B-351C512A3AB9} {9C3BABAA-49B9-4DCC-A129-46D651E70CE2} 0 Bestell_ID {53158C39-C36B-45B0-BF6B-351C512A3AB9} {1D0D9D06-B220-43DE-8074-D8EC40684030} PRIMARY BTREE 1 PRIMARY PRIMARY {29A5FF45-F0C3-4443-AC28-C2283FC1986D} 1 {C15B1BA4-99A7-4AD2-8149-154114773A9E} {0DA97C7C-FB32-48B1-B08A-59ED2F25EBD3} 0 Bestelldatum {C15B1BA4-99A7-4AD2-8149-154114773A9E} {2F1FC324-BB4A-46BD-8848-1EA6C7E5D035} BTREE Bestelldatum Bestelldatum {29A5FF45-F0C3-4443-AC28-C2283FC1986D} 0 {86D82E52-C4F3-4425-9613-EB406628FFE5} {B02F8A5D-9B75-4879-B5A9-7D31904A7D89} 0 Kunden_ID {86D82E52-C4F3-4425-9613-EB406628FFE5} {71E8D91A-0576-4A77-8B5A-E6D89C81F27E} BTREE KundenAufträge KundenAufträge {29A5FF45-F0C3-4443-AC28-C2283FC1986D} 0 {A2D00936-BBC9-4844-890E-A1F56B29F353} {6B78BBBE-A2F1-4F4D-A4BA-54D37AEC5B21} 0 Kunden_ID {A2D00936-BBC9-4844-890E-A1F56B29F353} {71E8D91A-0576-4A77-8B5A-E6D89C81F27E} BTREE KundenID KundenID {29A5FF45-F0C3-4443-AC28-C2283FC1986D} 0 {A69436D7-343A-469F-AA60-DA98E3948BD9} {F1712AD3-BD1F-40DF-826E-465C4D08E940} 0 Mitarbeiter_ID {A69436D7-343A-469F-AA60-DA98E3948BD9} {7D573A52-37C4-437F-814E-902D6579F055} BTREE MitarbeiterAufträge1 MitarbeiterAufträge1 {29A5FF45-F0C3-4443-AC28-C2283FC1986D} 0 {36EF0B41-C74B-4B24-BF0F-825D611D6DDB} {C45A4F9A-609F-4AED-AA97-06A611D56410} 0 Mitarbeiter_ID {36EF0B41-C74B-4B24-BF0F-825D611D6DDB} {7D573A52-37C4-437F-814E-902D6579F055} BTREE Personal-Nr Personal-Nr {29A5FF45-F0C3-4443-AC28-C2283FC1986D} 0 {2757843E-6632-48D1-B064-A00C1D5BFC19} {62827E5D-34BF-4D21-A6DA-6F3B3D12ABCA} 0 Spediteur_ID {2757843E-6632-48D1-B064-A00C1D5BFC19} {3A5F57A5-C094-4D54-8368-E6C1CA5524B3} BTREE SpediteureAufträge1 SpediteureAufträge1 {29A5FF45-F0C3-4443-AC28-C2283FC1986D} 0 {123C2683-5023-44BF-A873-1EB868429821} {9E4A7215-C7C8-46B0-BF0D-BBAF44B11A0D} 0 Versanddatum {123C2683-5023-44BF-A873-1EB868429821} {492D3030-DFD5-4547-9986-7B49A187C355} BTREE Versanddatum Versanddatum {29A5FF45-F0C3-4443-AC28-C2283FC1986D} 0 0 aufträge 1 aufträge {F7EBBC3C-09AF-41F5-BA74-1BF5D8190C42} {53158C39-C36B-45B0-BF6B-351C512A3AB9} Fixed CREATE TABLE `aufträge` ( `Bestell_ID` int(10) NOT NULL auto_increment, `Kunden_ID` int(10) default NULL, `Mitarbeiter_ID` int(10) default NULL, `Bestelldatum` datetime default NULL, `Versanddatum` datetime default NULL, `Spediteur_ID` int(10) default NULL, `Frachtkosten` decimal(19,4) default NULL, PRIMARY KEY (`Bestell_ID`), KEY `Bestelldatum` (`Bestelldatum`), KEY `KundenAufträge` (`Kunden_ID`), KEY `KundenID` (`Kunden_ID`), KEY `MitarbeiterAufträge1` (`Mitarbeiter_ID`), KEY `Personal-Nr` (`Mitarbeiter_ID`), KEY `SpediteureAufträge1` (`Spediteur_ID`), KEY `Versanddatum` (`Versanddatum`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 MyISAM {780EF277-E39C-4F2A-AFC7-44FD4A49C411} {646ECB88-8D26-4D84-9C5F-0414DD492EDC} 1 INT 1 0 Kategorie_ID Kategorie_ID 10 0 {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} {8FBAB0D6-1E0C-49D0-95CC-05E663B2BF4D} 0 utf8_general_ci VARCHAR 1 1 30 Kategoriename Kategoriename {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} {B2F9F91D-1FEC-4AE0-BEBC-934A980F9141} 0 utf8_general_ci VARCHAR 1 1 255 Beschreibung Beschreibung {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} {98239D23-D96B-42DB-A48D-ACA6D7762D7A} 0 utf8_general_ci VARCHAR 1 1 50 Seite Seite {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} utf8 utf8_general_ci {1A9AE8B4-7106-447F-9127-541090222731} {AB72C3B9-848A-4001-9A3D-6158620F7763} 0 Kategorie_ID {1A9AE8B4-7106-447F-9127-541090222731} {646ECB88-8D26-4D84-9C5F-0414DD492EDC} PRIMARY BTREE 1 PRIMARY PRIMARY {780EF277-E39C-4F2A-AFC7-44FD4A49C411} 1 {EF64410E-B747-4E1A-BC73-3ACF68E6CEEC} {BF46B60D-5D25-46F0-8CDF-085D34103218} 0 Kategoriename {EF64410E-B747-4E1A-BC73-3ACF68E6CEEC} {8FBAB0D6-1E0C-49D0-95CC-05E663B2BF4D} UNIQUE BTREE Kategoriename Kategoriename {780EF277-E39C-4F2A-AFC7-44FD4A49C411} 1 0 kategorien 1 kategorien {F7EBBC3C-09AF-41F5-BA74-1BF5D8190C42} {1A9AE8B4-7106-447F-9127-541090222731} Dynamic CREATE TABLE `kategorien` ( `Kategorie_ID` int(10) NOT NULL auto_increment, `Kategoriename` varchar(30) default NULL, `Beschreibung` varchar(255) default NULL, `Seite` varchar(50) default NULL, PRIMARY KEY (`Kategorie_ID`), UNIQUE KEY `Kategoriename` (`Kategoriename`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 MyISAM {3D3A5659-C234-4F04-8CF2-CCD856F3CD80} {A038F2FB-EE88-48E2-96F0-DE92EF8AAC9D} 0 (15,5) DOUBLE 1 1 MwStSatz MwStSatz {3873BD96-9C60-4BB0-90B4-45F4C76485D9} {BBEE590F-2F5C-42EF-803B-4775EC72A75B} 0 DECIMAL 1 1 Versandpauschale Versandpauschale 19 4 {8CB74E5F-921A-4F6E-95C6-3AD94F2BB36F} {FDD3E3B1-B741-41B1-9B99-E0C9BBAF1A8E} 0 DECIMAL 1 1 Installationsstundensatz Installationsstundensatz 19 4 {8CB74E5F-921A-4F6E-95C6-3AD94F2BB36F} {CE120511-A902-4716-AB86-06D35A32A1D6} 0 DECIMAL 1 1 Installationspauschale Installationspauschale 19 4 {8CB74E5F-921A-4F6E-95C6-3AD94F2BB36F} {638B5F8A-2409-4D8B-978A-B25D9C190834} 0 DECIMAL 1 1 SchulungsTagesSatz SchulungsTagesSatz 19 4 {8CB74E5F-921A-4F6E-95C6-3AD94F2BB36F} {E25CF2AC-7672-4270-992E-88D888B6C151} 0 DECIMAL 1 1 SchulungsFolgeSatz SchulungsFolgeSatz 19 4 {8CB74E5F-921A-4F6E-95C6-3AD94F2BB36F} {1F641E51-412E-4444-B27A-02836FD4F390} 0 utf8_general_ci VARCHAR 1 1 50 BrfKpfZeile1 BrfKpfZeile1 {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} {88317E23-3BDA-414C-BDE1-DE9AC83F4C8E} 0 utf8_general_ci VARCHAR 1 1 50 BrfKpfZeile2 BrfKpfZeile2 {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} {73479002-E280-415B-87C4-F89FB9C5883E} 0 utf8_general_ci VARCHAR 1 1 50 BrfKpfZeile3 BrfKpfZeile3 {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} {17E7FF89-9186-4681-8378-227147D6A4FA} 0 utf8_general_ci VARCHAR 1 1 50 BrfAbsender BrfAbsender {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} {19D14E29-0418-4E3D-9434-007DBC2EBF08} 0 utf8_general_ci VARCHAR 1 1 50 BrfStraße BrfStraße {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} {E9E50DF3-AF19-488E-B7D5-0CC68F16E9E9} 0 utf8_general_ci VARCHAR 1 1 50 BrfOrt BrfOrt {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} utf8 utf8_general_ci 0 konstanten konstanten {F7EBBC3C-09AF-41F5-BA74-1BF5D8190C42} Dynamic CREATE TABLE `konstanten` ( `MwStSatz` double(15,5) default NULL, `Versandpauschale` decimal(19,4) default NULL, `Installationsstundensatz` decimal(19,4) default NULL, `Installationspauschale` decimal(19,4) default NULL, `SchulungsTagesSatz` decimal(19,4) default NULL, `SchulungsFolgeSatz` decimal(19,4) default NULL, `BrfKpfZeile1` varchar(50) default NULL, `BrfKpfZeile2` varchar(50) default NULL, `BrfKpfZeile3` varchar(50) default NULL, `BrfAbsender` varchar(50) default NULL, `BrfStraße` varchar(50) default NULL, `BrfOrt` varchar(50) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 MyISAM {0E126356-9543-4707-869C-DFC39F24A9C0} {1C078A4A-72C5-491C-A008-59642885B399} 1 INT 1 0 Kunden_ID Kunden_ID 10 0 {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} {0E9C4BD2-879E-4870-8791-DC3BA5EA6854} 0 utf8_general_ci VARCHAR 1 1 100 Kunde Kunde {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} {0DC05042-9E5E-495D-AA80-05AD7B24E306} 0 utf8_general_ci VARCHAR 1 1 50 Kontaktperson_Name Kontaktperson_Name {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} {32C328A0-A63F-47ED-9158-CA861782B629} 0 utf8_general_ci VARCHAR 1 1 50 Kontaktperson_Vorname Kontaktperson_Vorname {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} {BAC56A9D-403F-45BB-9337-AAB8054719DD} 0 utf8_general_ci VARCHAR 1 1 60 Straße Straße {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} {748A8587-C0B5-42F7-B624-81C2672D5357} 0 utf8_general_ci VARCHAR 1 1 10 PLZ PLZ {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} {DE61E4C3-2715-441F-98D5-7F32C695EE2F} 0 utf8_general_ci VARCHAR 1 1 30 Ort Ort {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} {0B440D66-8670-4539-A6CE-3E3B3CE3CAF1} 0 utf8_general_ci VARCHAR 1 1 24 Telefon Telefon {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} utf8 utf8_general_ci {6ED990B5-38CE-4D44-B886-F8723F7ABB17} {EC1571A5-0714-4D3B-977D-9F2F618338D9} 0 Kunden_ID {6ED990B5-38CE-4D44-B886-F8723F7ABB17} {1C078A4A-72C5-491C-A008-59642885B399} PRIMARY BTREE 1 PRIMARY PRIMARY {0E126356-9543-4707-869C-DFC39F24A9C0} 1 {4A04827C-F3FA-4658-B1FA-D53099C8722C} {D9952065-7918-410E-8CA5-14FDFA48D829} 0 Kunde {4A04827C-F3FA-4658-B1FA-D53099C8722C} {0E9C4BD2-879E-4870-8791-DC3BA5EA6854} BTREE Firma Firma {0E126356-9543-4707-869C-DFC39F24A9C0} 0 {D146F85C-0140-4145-B6DE-6D65F32A5B7D} {C0FC7403-E635-46CB-BEB0-E61EF305D06E} 0 Kunden_ID {D146F85C-0140-4145-B6DE-6D65F32A5B7D} {1C078A4A-72C5-491C-A008-59642885B399} BTREE ID ID {0E126356-9543-4707-869C-DFC39F24A9C0} 0 {D12944A3-B942-40CA-AE73-D83187576F30} {3007E3B3-3199-4C0A-938B-16CA800276C0} 0 Ort {D12944A3-B942-40CA-AE73-D83187576F30} {DE61E4C3-2715-441F-98D5-7F32C695EE2F} BTREE Ort Ort {0E126356-9543-4707-869C-DFC39F24A9C0} 0 {0144D3BC-D40E-4122-A0FE-4F63CD3495E1} {3843F811-F426-44D7-B0A3-20A776FA6166} 0 PLZ {0144D3BC-D40E-4122-A0FE-4F63CD3495E1} {748A8587-C0B5-42F7-B624-81C2672D5357} BTREE PLZ PLZ {0E126356-9543-4707-869C-DFC39F24A9C0} 0 0 kunden 1 kunden {F7EBBC3C-09AF-41F5-BA74-1BF5D8190C42} {6ED990B5-38CE-4D44-B886-F8723F7ABB17} Dynamic CREATE TABLE `kunden` ( `Kunden_ID` int(10) NOT NULL auto_increment, `Kunde` varchar(100) default NULL, `Kontaktperson_Name` varchar(50) default NULL, `Kontaktperson_Vorname` varchar(50) default NULL, `Straße` varchar(60) default NULL, `PLZ` varchar(10) default NULL, `Ort` varchar(30) default NULL, `Telefon` varchar(24) default NULL, PRIMARY KEY (`Kunden_ID`), KEY `Firma` (`Kunde`), KEY `ID` (`Kunden_ID`), KEY `Ort` (`Ort`), KEY `PLZ` (`PLZ`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 MyISAM {CEB209ED-F1AA-4418-9DC2-3B736C69D1D7} {A07C0069-47A4-4BD2-A52B-E73EC0B12C18} 0 INT '' 0 0 Lieferanten_ID Lieferanten_ID 10 0 {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} {D7472593-6D1C-4DBE-B20B-1DAC7EAA6CD2} 0 utf8_general_ci VARCHAR 1 1 100 Firma Firma {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} {502F81D7-3B39-4965-93EE-C0488745A009} 0 utf8_general_ci VARCHAR 1 1 100 Kontaktperson Kontaktperson {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} {969D423A-8463-47A1-B5FD-649970159866} 0 utf8_general_ci VARCHAR 1 1 60 Straße Straße {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} {03459A7B-69DF-4AE9-8363-F25665CC73D2} 0 utf8_general_ci VARCHAR 1 1 10 PLZ PLZ {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} {8537EB1B-153D-4BD0-A448-45653934F84C} 0 utf8_general_ci VARCHAR 1 1 30 Ort Ort {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} {DEA02336-A588-469A-8855-B2AD545CFFA1} 0 utf8_general_ci VARCHAR 1 1 24 Telefon Telefon {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} utf8 utf8_general_ci {30E0C0FE-82D0-4B39-92E5-6F1B9DFA8D23} {4560808D-2A2A-44DF-BB0B-216ED0093C95} 0 Lieferanten_ID {30E0C0FE-82D0-4B39-92E5-6F1B9DFA8D23} {A07C0069-47A4-4BD2-A52B-E73EC0B12C18} PRIMARY BTREE 1 PRIMARY PRIMARY {CEB209ED-F1AA-4418-9DC2-3B736C69D1D7} 1 {D7B2963C-1D8B-45EE-B34A-1412F476E896} {F8B49856-86BF-48AE-9D88-A17A333FA5BF} 0 Lieferanten_ID {D7B2963C-1D8B-45EE-B34A-1412F476E896} {A07C0069-47A4-4BD2-A52B-E73EC0B12C18} BTREE Lieferanten_ID Lieferanten_ID {CEB209ED-F1AA-4418-9DC2-3B736C69D1D7} 0 0 lieferanten lieferanten {F7EBBC3C-09AF-41F5-BA74-1BF5D8190C42} {30E0C0FE-82D0-4B39-92E5-6F1B9DFA8D23} Dynamic CREATE TABLE `lieferanten` ( `Lieferanten_ID` int(10) NOT NULL, `Firma` varchar(100) default NULL, `Kontaktperson` varchar(100) default NULL, `Straße` varchar(60) default NULL, `PLZ` varchar(10) default NULL, `Ort` varchar(30) default NULL, `Telefon` varchar(24) default NULL, PRIMARY KEY (`Lieferanten_ID`), KEY `Lieferanten_ID` (`Lieferanten_ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 MyISAM {D3519E6E-570A-42B7-9667-E17EB047D531} {97903A6C-F3A2-42CF-A812-4E0A9BDF3306} 1 INT 1 0 Mitarbeiter_ID Mitarbeiter_ID 10 0 {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} {37D342AB-1690-4762-8E66-0CC7C2669E49} 0 utf8_general_ci VARCHAR 1 1 20 Nachname Nachname {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} {F5AAB2B4-2A16-4A28-88E0-3EB9CC8FC223} 0 utf8_general_ci VARCHAR 1 1 10 Vorname Vorname {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} {1B06C9BD-36F6-40C1-8FD1-662935D0CBCF} 0 utf8_general_ci VARCHAR 1 1 30 Position Position {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} {BD85BD9A-E087-4EB5-BDAB-2553A044B693} 0 utf8_general_ci VARCHAR 1 1 25 Anrede Anrede {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} {9080E4B4-1B96-4BC2-838F-F67FE146E368} 0 DATETIME 1 1 Geburtsdatum Geburtsdatum {9A2399C8-F3EA-4B6C-AAB1-830D3BFF164B} {B8753BD5-32CC-4D11-ADE9-D4FA824679DF} 0 DATETIME 1 1 Einstellungsdatum Einstellungsdatum {9A2399C8-F3EA-4B6C-AAB1-830D3BFF164B} {917D078F-683A-4FA9-9177-28E65249EE66} 0 utf8_general_ci VARCHAR 1 1 60 Straße Straße {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} {26EB3F12-6B41-4C7C-B0CD-81A726E08D9A} 0 utf8_general_ci VARCHAR 1 1 15 Ort Ort {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} {2E6F9567-43C8-462D-93EA-49F8BEDD7F7E} 0 utf8_general_ci VARCHAR 1 1 10 PLZ PLZ {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} {043FB559-0334-4D81-8A5D-C8D25CCA7BA2} 0 utf8_general_ci VARCHAR 1 1 24 Telefon privat Telefon privat {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} {EC7EAABC-828D-49BA-9CB3-88986828DEC5} 0 utf8_general_ci VARCHAR 1 1 4 Telefon Büro Telefon Büro {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} {FD7B1BA6-630B-4B93-8DB2-00F95858B68C} 0 LONGBLOB 1 1 Foto Foto {6C2E3841-EA8D-48E1-A727-B0B2E71857BF} {38C66707-F8CC-46C2-981C-E664399B1CBD} 0 utf8_general_ci LONGTEXT 1 1 Bemerkungen Bemerkungen {BFDB5048-852A-4985-8772-5123FB7C23FE} {AA33DB6A-BFC8-4DA7-9EE7-85769665A0EE} 0 INT 1 1 Vorgesetzte(r) Vorgesetzte(r) 10 0 {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} utf8 utf8_general_ci {D2D2FDB3-ABAF-422B-A6C5-CADECB1BB380} {04943A93-9527-43A6-9C62-1DA3FDD8C319} 0 Mitarbeiter_ID {D2D2FDB3-ABAF-422B-A6C5-CADECB1BB380} {97903A6C-F3A2-42CF-A812-4E0A9BDF3306} PRIMARY BTREE 1 PRIMARY PRIMARY {D3519E6E-570A-42B7-9667-E17EB047D531} 1 {6BA98538-D7C7-4D59-A682-9FDA6BDE24AC} {952B7D32-0E9A-4D68-827D-35BF60B61B8C} 0 Nachname {6BA98538-D7C7-4D59-A682-9FDA6BDE24AC} {37D342AB-1690-4762-8E66-0CC7C2669E49} BTREE LastName LastName {D3519E6E-570A-42B7-9667-E17EB047D531} 0 {0811BFC1-EBA4-4BA8-AF8F-72731BC4A161} {36093EAF-8E41-474A-9E08-2E5DEBEFA0EC} 0 PLZ {0811BFC1-EBA4-4BA8-AF8F-72731BC4A161} {2E6F9567-43C8-462D-93EA-49F8BEDD7F7E} BTREE PostalCode PostalCode {D3519E6E-570A-42B7-9667-E17EB047D531} 0 0 mitarbeiter 1 mitarbeiter {F7EBBC3C-09AF-41F5-BA74-1BF5D8190C42} {D2D2FDB3-ABAF-422B-A6C5-CADECB1BB380} Dynamic CREATE TABLE `mitarbeiter` ( `Mitarbeiter_ID` int(10) NOT NULL auto_increment, `Nachname` varchar(20) default NULL, `Vorname` varchar(10) default NULL, `Position` varchar(30) default NULL, `Anrede` varchar(25) default NULL, `Geburtsdatum` datetime default NULL, `Einstellungsdatum` datetime default NULL, `Straße` varchar(60) default NULL, `Ort` varchar(15) default NULL, `PLZ` varchar(10) default NULL, `Telefon privat` varchar(24) default NULL, `Telefon Büro` varchar(4) default NULL, `Foto` longblob, `Bemerkungen` longtext, `Vorgesetzte(r)` int(10) default NULL, PRIMARY KEY (`Mitarbeiter_ID`), KEY `LastName` (`Nachname`), KEY `PostalCode` (`PLZ`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 MyISAM {C2C49A49-042D-4FCA-8D96-B62FEDB12A2F} {5B336A02-4196-497B-A09C-F54DE0B69933} 1 INT 1 0 Spediteur_ID Spediteur_ID 10 0 {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} {E9B558C8-65BA-41D4-A0F2-230D4218A5C7} 0 utf8_general_ci VARCHAR 1 1 40 Firma Firma {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} {134DB603-40F3-4336-BB9F-300BF558B5F9} 0 utf8_general_ci VARCHAR 1 1 24 Telefon Telefon {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} utf8 utf8_general_ci {4B921AFB-F3AA-4FED-9475-26F82A3E8A5A} {7B07F37A-3994-42AE-B6E2-24541C08510F} 0 Spediteur_ID {4B921AFB-F3AA-4FED-9475-26F82A3E8A5A} {5B336A02-4196-497B-A09C-F54DE0B69933} PRIMARY BTREE 1 PRIMARY PRIMARY {C2C49A49-042D-4FCA-8D96-B62FEDB12A2F} 1 0 spediteure 1 spediteure {F7EBBC3C-09AF-41F5-BA74-1BF5D8190C42} {4B921AFB-F3AA-4FED-9475-26F82A3E8A5A} Dynamic CREATE TABLE `spediteure` ( `Spediteur_ID` int(10) NOT NULL auto_increment, `Firma` varchar(40) default NULL, `Telefon` varchar(24) default NULL, PRIMARY KEY (`Spediteur_ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 MyISAM {A5FC3FA4-B356-48CE-88D2-681E841ECB57} 0 0 latin1 latin1_swedish_ci 0 0 0 table_01 table_01 {F7EBBC3C-09AF-41F5-BA74-1BF5D8190C42} InnoDB {C25DF4B9-57BC-43AF-945A-7FBDC88FE07C} 0 0 latin1 latin1_swedish_ci 0 0 0 table_02 table_02 {F7EBBC3C-09AF-41F5-BA74-1BF5D8190C42} InnoDB {9D1EC1D9-5435-444B-BA5A-CE494A0D9B36} 0 0 latin1 latin1_swedish_ci 0 0 0 table_03 table_03 {F7EBBC3C-09AF-41F5-BA74-1BF5D8190C42} InnoDB {3C75C19F-FCA4-44DE-8881-F477FEA32E62} {B98335A2-603F-4042-9D59-88248D987309} {A5A2A320-DAAD-416E-862C-FAA9AD90DF8C} {014AB6FC-CA8A-4FA2-8BD9-E97D7F8D53AE} {B96B522A-48FE-431F-A0B4-D5E1B733FE3F} {BEA67203-20CC-4A53-A4EC-B2F31E84DE1E} {3873BD96-9C60-4BB0-90B4-45F4C76485D9} {8CB74E5F-921A-4F6E-95C6-3AD94F2BB36F} {4B160881-85B7-4C25-BBD1-36C9CA1A0E80} {7198A7BD-968D-4BD9-B85C-4DE7504F0D83} {4159AB8E-78E7-41E7-AAFD-0DE3766C2935} {CD41C6AA-4BAC-42E8-A4FC-655CAE3534D0} {B965148B-8E5B-46E9-999C-252D92B37B2C} {52734DB8-D81D-4593-A74C-891967DFAC63} {7874D9C1-0F91-487C-822C-3ABC407452BE} {BFDB5048-852A-4985-8772-5123FB7C23FE} {D2A508F3-9636-400D-816E-68E0A172204C} {6A28850F-C54C-4722-80A0-6187798B35C0} {EBCCD9D0-1497-4EEE-97FC-0C96DB3D2EBE} {6C2E3841-EA8D-48E1-A727-B0B2E71857BF} {9A2399C8-F3EA-4B6C-AAB1-830D3BFF164B} {E3ACD2FE-A26F-4BB8-ADA6-433F92B0570D} {65642303-376E-4C4A-B200-7E0DFAA47344} {868AC4F9-F4BB-44AD-8512-4EBAD5E5D661} {D8A1FD40-794F-464E-8E4A-E14C38D9C924} {DC0345B1-52D4-497C-AFA1-17A00BCAA7FE} {739D4BC4-0188-46BB-84AB-DB97CE01B67F} {50C760E2-97A4-4BB0-ABA5-E0A2D11E683D} {86A060EB-F367-4890-8FFA-00840F281791} {04006513-2EA3-4785-A541-8C25E68E5E0A} {1D1FE4C9-6A0B-423C-A048-8830C430A93E} {E1609E12-9B2A-4EF7-9265-00D6D3BE0026} {855F4FED-94F7-4E28-812C-6882B28571AF} {F496575F-5F75-4825-A059-7DFC75DB3DFD} {D442887A-6402-4873-ADC5-6F875085C0A6} {D8F350D8-9522-478F-9233-28C52E26A067} {F082234B-0870-49D8-9794-8EC1E505294D} 5 1 Version {C3B29E68-ED16-46A3-BAD3-5990FB4C7FEE} 6 {F9CC947C-BD1E-4434-B309-CB4BF9B05FB7} {D65C7567-0B84-4AC6-A1A4-0A4BB8C9F3F2} MigrationGeneric QueryMysql ReverseEngineeringMysql TransformationMysql 127.0.0.1 west 3306 0 0 0 root {4691F161-C0F7-447E-A460-3350B0A69792} {A807A4BE-F775-4F53-9219-8B7CD083CD3E} {0AD6EC13-EE7C-4623-B350-DAD67DA315C0} Marker10 {A807A4BE-F775-4F53-9219-8B7CD083CD3E} 0 0 0.750000 {0EF64888-5465-433F-9A91-07F9013F39C6} Dec 11, 2006 Dec 11, 2006 New Model Properties {4691F161-C0F7-447E-A460-3350B0A69792} Name of the project 1.0 {A807A4BE-F775-4F53-9219-8B7CD083CD3E} {9A3C242F-CF3D-45C2-90BD-02EBB604AD66} 1 0 0 0 50.000000 0 {E2FE6C06-24CE-437B-AE6F-FDAA9668BF1F} 0.000000 0 al_plz_bezirke {6F8E14EB-0F22-4877-B87F-5547793959BE} 20.000000 0 1 160.000000 {5835BBFF-2740-46E9-A5A7-2CB088CFDD8B} 1 0 0 0 50.000000 0 {E2FE6C06-24CE-437B-AE6F-FDAA9668BF1F} 180.000000 0 angebote {13089361-DF84-4192-8BC4-FD1916B86808} 20.000000 0 1 160.000000 {32A240AB-D606-473E-B2CB-2315A8AAA9E1} 1 0 0 0 50.000000 0 {E2FE6C06-24CE-437B-AE6F-FDAA9668BF1F} 360.000000 0 artikel {520332F3-919A-451B-ABB9-BD27C7E50E4D} 20.000000 0 1 160.000000 {E29B493C-7B17-4D4A-9013-6555F4ED8684} 1 0 0 0 50.000000 0 {E2FE6C06-24CE-437B-AE6F-FDAA9668BF1F} 540.000000 0 artikelundlieferanten {160CAF70-B045-4E25-87F7-0A3EDB3A0416} 20.000000 0 1 160.000000 {456E9D06-98F8-4D7E-A023-8CB28DAA8027} 1 0 0 0 50.000000 0 {E2FE6C06-24CE-437B-AE6F-FDAA9668BF1F} 720.000000 0 auftragspositionen {4203B98C-AE79-4B80-AAA5-69239366B900} 20.000000 0 1 160.000000 {CE377ACC-31E9-491A-AAE4-1CC272B035F4} 1 0 0 0 50.000000 0 {E2FE6C06-24CE-437B-AE6F-FDAA9668BF1F} 900.000000 0 aufträge {29A5FF45-F0C3-4443-AC28-C2283FC1986D} 20.000000 0 1 160.000000 {8B1664F9-4601-444A-B401-1930F9AEAA3B} 1 0 0 0 50.000000 0 {E2FE6C06-24CE-437B-AE6F-FDAA9668BF1F} 0.000000 0 kategorien {780EF277-E39C-4F2A-AFC7-44FD4A49C411} 40.000000 0 1 160.000000 {52CE4FA2-3BDD-46F0-99A9-1EB65E9FC822} 1 0 0 0 50.000000 0 {E2FE6C06-24CE-437B-AE6F-FDAA9668BF1F} 180.000000 0 konstanten {3D3A5659-C234-4F04-8CF2-CCD856F3CD80} 40.000000 0 1 160.000000 {90A778C1-3E4D-4A71-BE5E-6F13A0E0F414} 1 0 0 0 50.000000 0 {E2FE6C06-24CE-437B-AE6F-FDAA9668BF1F} 360.000000 0 kunden {0E126356-9543-4707-869C-DFC39F24A9C0} 40.000000 0 1 160.000000 {3A89D99E-7E0F-4A19-8923-B4BFA89344B7} 1 0 0 0 50.000000 0 {E2FE6C06-24CE-437B-AE6F-FDAA9668BF1F} 540.000000 0 lieferanten {CEB209ED-F1AA-4418-9DC2-3B736C69D1D7} 40.000000 0 1 160.000000 {F74FE8F4-D768-4559-82D1-078DEBC9A37B} 1 0 0 0 50.000000 0 {E2FE6C06-24CE-437B-AE6F-FDAA9668BF1F} 720.000000 0 mitarbeiter {D3519E6E-570A-42B7-9667-E17EB047D531} 40.000000 0 1 160.000000 {BF3D2418-8511-44DC-933E-3567AC90E3E0} 1 0 0 0 50.000000 0 {E2FE6C06-24CE-437B-AE6F-FDAA9668BF1F} 900.000000 0 spediteure {C2C49A49-042D-4FCA-8D96-B62FEDB12A2F} 40.000000 0 1 160.000000 {26D9B9BF-8C8C-4369-8F90-50FB44CBCD34} blue 1 0 1 0 126.000000 0 {E2FE6C06-24CE-437B-AE6F-FDAA9668BF1F} 88.000000 0 table_01 {A5FC3FA4-B356-48CE-88D2-681E841ECB57} 164.000000 0 1 160.000000 {51AFFCB2-F640-4F88-BE69-E1C96A329842} blue 1 0 1 0 126.000015 0 {E2FE6C06-24CE-437B-AE6F-FDAA9668BF1F} 300.000000 0 table_02 {C25DF4B9-57BC-43AF-945A-7FBDC88FE07C} 166.666672 0 1 160.000000 {1FE1EC60-887B-4F53-BCAA-DAAD9EF539AF} blue 1 0 1 0 125.999985 0 {E2FE6C06-24CE-437B-AE6F-FDAA9668BF1F} 498.666687 0 table_03 {9D1EC1D9-5435-444B-BA5A-CE494A0D9B36} 165.333328 0 1 160.000000 7000.000000 {E2FE6C06-24CE-437B-AE6F-FDAA9668BF1F} {9A3C242F-CF3D-45C2-90BD-02EBB604AD66} {5835BBFF-2740-46E9-A5A7-2CB088CFDD8B} {32A240AB-D606-473E-B2CB-2315A8AAA9E1} {E29B493C-7B17-4D4A-9013-6555F4ED8684} {456E9D06-98F8-4D7E-A023-8CB28DAA8027} {CE377ACC-31E9-491A-AAE4-1CC272B035F4} {8B1664F9-4601-444A-B401-1930F9AEAA3B} {52CE4FA2-3BDD-46F0-99A9-1EB65E9FC822} {90A778C1-3E4D-4A71-BE5E-6F13A0E0F414} {3A89D99E-7E0F-4A19-8923-B4BFA89344B7} {F74FE8F4-D768-4559-82D1-078DEBC9A37B} {BF3D2418-8511-44DC-933E-3567AC90E3E0} {26D9B9BF-8C8C-4369-8F90-50FB44CBCD34} {51AFFCB2-F640-4F88-BE69-E1C96A329842} {1FE1EC60-887B-4F53-BCAA-DAAD9EF539AF} 0 0.000000 0.000000 root {4691F161-C0F7-447E-A460-3350B0A69792} 0.000000 0 0.000000 Main View {4691F161-C0F7-447E-A460-3350B0A69792} {E2FE6C06-24CE-437B-AE6F-FDAA9668BF1F} 10000.000000 0.000000 0.000000 1.000000 Workbench {6D75781B-52CF-4252-9B3D-9F28B75C09F7} 2