Ich habe im FOR-Live-System in der Buchung 456081 eine leere Hotel-Leistung gelöscht. Folegnde Daten wurden gelöscht: [ { "hotel_id": 233554, "booking_id": 456081, "hotel_matching_id": 0, "sort_key": 1, "service_id": 0, "vorgang": "XX", "booking_reference": "", "provider": "MTS", "source_market": null, "name": "Liberty Fabay", "location": "Fethiye", "country_code": "TR", "external_code": "", "roomtype_code": "", "boardtype_code": "", "roomtype_description": "DZ Prestige", "boardtype_description": "All Inclusive", "roomtype_code_original": "", "boardtype_code_original": "", "checkin": null, "checkout": null, "price_netto": 0.00, "price_brutto": 0.00, "price_original": 0.00, "currency_original": "EUR", "season": null, "offer": null, "info": "", "handling_fee_netto": null, "count": 0, "calculation": "", "from_contingent": 0, "is_non_refundable": 0, "eb_payment_date": null, "eb_currency_code": null, "eb_initial_deposit_price": null } ] und zum wiederherstellen: INSERT INTO xres_for_bookings.hotel (hotel_id, booking_id, hotel_matching_id, sort_key, service_id, vorgang, booking_reference, provider, source_market, name, location, country_code, external_code, roomtype_code, boardtype_code, roomtype_description, boardtype_description, roomtype_code_original, boardtype_code_original, checkin, checkout, price_netto, price_brutto, price_original, currency_original, season, offer, info, handling_fee_netto, count, calculation, from_contingent, is_non_refundable, eb_payment_date, eb_currency_code, eb_initial_deposit_price) VALUES (233554, 456081, 0, 1, 0, 'XX', '', 'MTS', null, 'Liberty Fabay', 'Fethiye', 'TR', '', '', '', 'DZ Prestige', 'All Inclusive', '', '', null, null, 0.00, 0.00, 0.00, 'EUR', null, null, '', null, 0, '', 0, 0, null, null, null); -- Mit freundlichen Grüßen / Kind regards Rene Kühle - Entwickler - ___________________________________________________________________________ TraSo GmbH Nonnenstraße 42 D-04229 Leipzig Tel.: +49 341 355 740 20 Internet: http://traso.de E-Mail: r.kuehle@traso.de ___________________________________________________________________________ Geschäftsführer: Haiko Gerdes Handelsregister: Amtsgericht Leipzig, HRB 21850