#!/usr/bin/env php
=== UUID MISMATCH ANALYSIS ===

SEAT       | TEMPLATE UUID                          | DB UUID                               | STATUS
------------------------------------------------------------------------------------------------------------------------
504-A1     | 55405f63-54e3-4cb0-be03-e4f514717d0c | d9d34043-56e0-4253-9852-1f1c0d3fa1c1 | MISMATCH
504-A2     | 4dba781b-2c2e-4644-bf46-beff443b1c62 | ac2355cf-888d-4b37-a37e-b62a524220bf | MISMATCH
504-A3     | c55d502d-b2e7-4ac0-9a4d-9e6d0b6ef586 | 2aad5480-9782-415a-9078-6d91b3d86029 | MISMATCH
504-A4     | fa65a351-4861-4e1a-859f-961778501838 | f7a87923-1d8f-4af7-acfc-67ceef698719 | MISMATCH
504-A5     | f36914db-c2a7-49d7-919f-1757a3bbfa51 | f2538a44-8c67-41fa-a692-ab5aee2de403 | MISMATCH
504-A6     | 762ccc89-8033-4288-afec-8361717292e7 | bec1d053-3dad-41f0-a266-57fd8e77bc50 | MISMATCH
504-B1     | 287731cf-0eec-44e8-8da3-79ff89f36a07 | 2353f891-d1b7-45a0-a34f-331453202c6f | MISMATCH
504-B2     | 0b585238-712b-4459-8d73-4808125c2f7d | d6979b9d-616d-4c25-9ba9-270db57e974f | MISMATCH
504-B3     | 6ad705c2-05f5-4239-9c00-5ba66f38592b | 411673ab-7d6d-4488-857e-d055940ed066 | MISMATCH
504-B4     | 28fa0732-7244-4bbf-8995-274d56a3e246 | 73f1359a-4d34-446a-80ee-f01eed0b8621 | MISMATCH
504-B5     | 63abc884-9d57-4581-ad53-e372d7b659be | 2b7b8026-dbbc-4aba-98da-3408f2c90b70 | MISMATCH
504-B6     | 08e0d373-6b25-4fdf-9ee2-244583179c12 | b0f58962-c373-45aa-bd80-b47e690e7e4a | MISMATCH
505-A1     | 44a27272-1f74-4fb2-8f22-0c3851395d46 | 34bda770-ec30-4421-ac82-8ca42e704bb6 | MISMATCH
505-A2     | ec89b18c-8857-410c-bf69-c3fb53f9f2f3 | 37212fe1-7b2d-47e1-9282-2360a4ef0565 | MISMATCH
505-A3     | 7666eddc-6d37-46eb-a358-c887923cde95 | d92b6f63-b7ee-47ab-a043-2bc49dd5528b | MISMATCH
505-A4     | 2ccee9ee-ac17-403c-88ab-385230d8da92 | 95c129b6-f1f2-4e19-99d9-20ed4f9bb405 | MISMATCH
505-A5     | 067e4375-6c17-4387-802c-fc747b6e1a11 | 876ad324-34e8-4f34-b811-4c3ab076ed78 | MISMATCH
505-A6     | 10fe20da-55ce-46d3-bedb-a3a05641661b | 7896288c-fc2c-4de8-8f40-c9cd5c254c17 | MISMATCH
505-B1     | a613f77b-90a3-4dcd-b118-46258f87f063 | 0fe5317f-6546-4e67-a785-3a5500fddc71 | MISMATCH
505-B2     | b90b28ad-6a58-4546-97e6-e461f0996683 | ddeafd69-4baa-4970-96b4-1a34b71c2e2a | MISMATCH
505-B3     | bda20586-9fb6-4cdf-9358-b5741884761a | 29224f05-fe58-4cf0-af46-43c7dfbc215e | MISMATCH
505-B4     | 0e5c061d-de0a-44cc-9578-802529257bc3 | 5b60269a-a5aa-4c96-8ab3-7081d0cb4623 | MISMATCH
505-B5     | 8324ba8a-daaf-4af9-8d79-9fa04006806c | 6b3de74c-4dfa-4f48-a68d-01f9ffaa5de1 | MISMATCH
505-B6     | ce49d0ef-3365-4794-8e92-6e1a0f7e4233 | bf7f61aa-5be9-4249-9660-7e7b9723a685 | MISMATCH
508-A1     | bfb29a7a-c173-44d8-a906-bc4e337a2b72 | 3254021d-7494-4403-82be-2021da7a5520 | MISMATCH
508-A2     | f63fee4c-bccd-4f7c-ae7c-d78bc5b5cd2a | 281e8832-d4f3-4471-86f9-61aa4c3b27cf | MISMATCH
508-A3     | a67cdc13-41dd-417d-bef1-7685c98842fa | 2c9ee4be-1305-4135-8c9d-986033ac2af9 | MISMATCH
508-A4     | 30932517-71cc-423a-b2b7-c971281ccede | 906a0802-f017-4ed4-a136-fcc4dd12fbbe | MISMATCH
508-A5     | 29a3d227-ab25-4701-b50f-dfc32da34642 | d94e696c-60c7-44fc-a181-aac29ab6053a | MISMATCH
508-A6     | 7d1497dc-b69a-4fec-99ab-7dc8af84b2d1 | f4b75252-f73f-4b45-b9d9-a46d2b1f071e | MISMATCH
508-B1     | 207727ca-4612-40d0-a615-3cc5aa904252 | f003e195-f12e-4072-9b0c-1d7f521d6f49 | MISMATCH
508-B2     | d37cbfcd-ae25-4366-bcce-f2f77226a02a | 6dd508ea-c411-4c34-a154-cf946eccfcf3 | MISMATCH
508-B3     | 2e6919da-5dc8-4645-9a56-9708605a2bd5 | 8d613db6-5abd-4d59-9a98-2c3cd0a0c135 | MISMATCH
508-B4     | d8be9a6b-78aa-4757-84d7-ecaa0f31a1fd | 1001f3bf-59d7-430e-b911-8f08f581744f | MISMATCH
508-B5     | 502ac429-c317-4064-b05b-2e4847cd1fd7 | 96222ff3-167f-4702-9b28-cadbcb63c69d | MISMATCH
508-B6     | cbb3f127-bd95-4e70-9f64-b92a92cf4e23 | c1cb782a-3e38-4932-b149-b12aada9376f | MISMATCH
504-A7     | NOT IN TEMPLATE                      | 23d1235d-404d-4fe8-a87f-8b3256687ccf | DB ONLY (ACTIVE)
504-B7     | NOT IN TEMPLATE                      | 3fa28231-6f19-46e7-96ca-59a448ceb7fa | DB ONLY (INACTIVE)
505-A7     | NOT IN TEMPLATE                      | 71473217-4d1e-410a-be98-b95330d0fc6c | DB ONLY (INACTIVE)
505-B7     | NOT IN TEMPLATE                      | db1eaa08-5f39-4d71-a4fc-8d8f2962231f | DB ONLY (INACTIVE)
508-A7     | NOT IN TEMPLATE                      | cde665fe-a36d-45d0-b0c1-096613e26ee2 | DB ONLY (INACTIVE)
508-B7     | NOT IN TEMPLATE                      | 587ff35a-cb42-409f-91b4-4c95298eedbf | DB ONLY (INACTIVE)

=== SUMMARY ===
UUIDs matching: 36
UUIDs mismatched: 36
Template-only seats: 0
DB-only seats: 6

=== RESERVATIONS ON MISMATCHED/DB-ONLY SEATS ===

No reservations found on mismatched/DB-only seats