-- Backup for clearing GRP2603130003
-- Generated at 2026-03-13 16:34:28 +0900
-- group_booking_id=162, reservation_ids=921

--
-- Host: localhost    Database: doto_yoyaku
-- ------------------------------------------------------


--
-- Dumping data for table `group_bookings`
--
-- WHERE:  id=162

INSERT INTO `group_bookings` VALUES
(162,NULL,'GRP2603130003',27,17,21,'１３８０H　知床・釧路湿原・富良野・納沙布岬を一度にめぐる５つ星の宿にご宿泊 ひがし北海道ひとめぐり５日','未設定','03-6745-1311','',3,0.00,'cancelled','bank_transfer',NULL,'cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] ',1,'2026-03-13 16:28:08','2026-03-13 16:29:31',0.00,'fixed',0.00,0.00,0.00);


--
-- Host: localhost    Database: doto_yoyaku
-- ------------------------------------------------------


--
-- Dumping data for table `group_reservations`
--
-- WHERE:  group_booking_id=162

INSERT INTO `group_reservations` VALUES
(516,'GRP-20260313162731-P283-3334',1841,'１３８０H　知床・釧路湿原・富良野・納沙布岬を一度にめぐる５つ星の宿にご宿泊 ひがし北海道ひとめぐり５日','未設定','03-6745-1311','',3,0.00,'cancelled','pending','',283,'2026-03-13 07:27:31','2026-03-13 07:29:31',162,27,17,21);


--
-- Host: localhost    Database: doto_yoyaku
-- ------------------------------------------------------


--
-- Dumping data for table `planning_drafts`
--
-- WHERE:  group_booking_id=162

INSERT INTO `planning_drafts` VALUES
(283,27,17,21,'１３８０H　知床・釧路湿原・富良野・納沙布岬を一度にめぐる５つ星の宿にご宿泊 ひがし北海道ひとめぐり５日','未設定','03-6745-1311',3,'','2026-03-01','2026-03-01',24,'cancelled',1,'2026-03-13 07:27:31','2026-03-13 07:29:31',162);


--
-- Host: localhost    Database: doto_yoyaku
-- ------------------------------------------------------


--
-- Dumping data for table `tickets`
--
-- WHERE:  group_booking_id=162

INSERT INTO `tickets` VALUES
(4726,NULL,NULL,1841,114,'adult','団体予約 (1/3)',NULL,NULL,NULL,NULL,'GRP2603130003-T1',NULL,NULL,NULL,'EwKy6I0NuUQF5GJbx93w5QTiZr8oBy7Z6McARSxJ2ww=',NULL,'cancelled',0.00,NULL,NULL,NULL,NULL,'2026-03-13 07:28:08',1,NULL,'2026-03-13 07:28:08','2026-03-13 07:29:31',162),
(4727,NULL,NULL,1841,114,'adult','団体予約 (2/3)',NULL,NULL,NULL,NULL,'GRP2603130003-T2',NULL,NULL,NULL,'73XLaA8TCLHmHpoLK7yUmS0eNBe4+p4y9W+yj8iXrXQ=',NULL,'cancelled',0.00,NULL,NULL,NULL,NULL,'2026-03-13 07:28:08',1,NULL,'2026-03-13 07:28:08','2026-03-13 07:29:31',162),
(4728,NULL,NULL,1841,114,'adult','団体予約 (3/3)',NULL,NULL,NULL,NULL,'GRP2603130003-T3',NULL,NULL,NULL,'tH5+Q2fgxtHe5atNBeTnuO2Z9cVzcBXXEFzQqsA8E80=',NULL,'cancelled',0.00,NULL,NULL,NULL,NULL,'2026-03-13 07:28:08',1,NULL,'2026-03-13 07:28:08','2026-03-13 07:29:31',162);


--
-- Host: localhost    Database: doto_yoyaku
-- ------------------------------------------------------


--
-- Dumping data for table `group_receipt_issues`
--
-- WHERE:  group_booking_id=162



--
-- Host: localhost    Database: doto_yoyaku
-- ------------------------------------------------------


--
-- Dumping data for table `invoice_items`
--
-- WHERE:  group_booking_id=162 OR reservation_id IN (921)



--
-- Host: localhost    Database: doto_yoyaku
-- ------------------------------------------------------


--
-- Dumping data for table `booking_code_change_history`
--
-- WHERE:  group_booking_id=162 OR reservation_id IN (921) OR old_booking_code='GRP2603130003' OR new_booking_code='GRP2603130003'



--
-- Host: localhost    Database: doto_yoyaku
-- ------------------------------------------------------


--
-- Dumping data for table `reservations`
--
-- WHERE:  id IN (921)

INSERT INTO `reservations` VALUES
(921,'GRP-20260313162731-P283-3334',NULL,NULL,'GRP2603130001',NULL,1841,'group','group','confirmed','unpaid','bank_transfer',3,30000.00,'１３８０H　知床・釧路湿原・富良野・納沙布岬を一度にめぐる５つ星の宿にご宿泊 ひがし北海道ひとめぐり５日',NULL,'',NULL,NULL,'','03-6745-1311',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'admin','web','',NULL,'2026-03-13 07:27:31','2026-03-13 07:28:08',0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,30000.00,30000.00,0,0.00,NULL,0.00,NULL,0,'pending',NULL,NULL,NULL);


--
-- Host: localhost    Database: doto_yoyaku
-- ------------------------------------------------------


--
-- Dumping data for table `passengers`
--
-- WHERE:  reservation_id IN (921)

INSERT INTO `passengers` VALUES
(9839,921,1841,114,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'JP',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'none',NULL,NULL,NULL,0,'not_boarded',NULL,NULL,NULL,1,'GRP2603130001-T1',NULL,NULL,'001','2026-03-13 07:27:31','2026-03-13 07:28:08'),
(9840,921,1841,114,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'JP',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'none',NULL,NULL,NULL,0,'not_boarded',NULL,NULL,NULL,2,'GRP2603130001-T2',NULL,NULL,'002','2026-03-13 07:27:31','2026-03-13 07:28:08'),
(9841,921,1841,114,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'JP',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'none',NULL,NULL,NULL,0,'not_boarded',NULL,NULL,NULL,3,'GRP2603130001-T3',NULL,NULL,'003','2026-03-13 07:27:31','2026-03-13 07:28:08');


--
-- Host: localhost    Database: doto_yoyaku
-- ------------------------------------------------------


--
-- Dumping data for table `reservation_details`
--
-- WHERE:  reservation_id IN (921)



--
-- Host: localhost    Database: doto_yoyaku
-- ------------------------------------------------------


--
-- Dumping data for table `cancellation_history`
--
-- WHERE:  reservation_id IN (921)



--
-- Host: localhost    Database: doto_yoyaku
-- ------------------------------------------------------


--
-- Dumping data for table `waitlists`
--
-- WHERE:  created_reservation_id IN (921)



