{
    "app": "Gigora",
    "version": 1,
    "exported_at": "2026-05-09T14:47:01+01:00",
    "tables": {
        "admins": [
            {
                "id": 2,
                "name": "Gigora Demo Manager",
                "email": "demo@gigora.local",
                "password_hash": "$2y$10$u.38fBEifWC1cPyjCTY4ouSq9\/McJCC2CHIthnpMUCgsHUj4khLeS",
                "role": "agency_manager",
                "default_charge_rate_pence": 0,
                "default_pay_rate_pence": 0,
                "active": 1,
                "created_at": "2026-05-06 11:39:51"
            },
            {
                "id": 11,
                "name": "Maya Stone",
                "email": "maya.demo@gigora.local",
                "password_hash": "$2y$10$HkWFTBGE1VdvPr.8ynFPYuSROZg52nrozkxLYOKmtC6lJr1jmArY2",
                "role": "dj",
                "default_charge_rate_pence": 0,
                "default_pay_rate_pence": 0,
                "active": 1,
                "created_at": "2026-05-09 13:47:15"
            },
            {
                "id": 12,
                "name": "Leo Grant",
                "email": "leo.demo@gigora.local",
                "password_hash": "$2y$10$4cnmhNkpP59fhnPS8DChyOZSWMkYJG3GTiI6geuW4PcR2buit0YrC",
                "role": "dj",
                "default_charge_rate_pence": 0,
                "default_pay_rate_pence": 0,
                "active": 1,
                "created_at": "2026-05-09 13:47:16"
            }
        ],
        "venues": [
            {
                "id": 1,
                "name": "Willowmere Hall",
                "address": "12 Fictional Lane, Exampletown EX1 1AA",
                "map_url": "",
                "created_at": "2026-05-09 13:47:16"
            },
            {
                "id": 2,
                "name": "The Crescent Suite",
                "address": "8 Placeholder Avenue, Demo City DC2 2BB",
                "map_url": "",
                "created_at": "2026-05-09 13:47:16"
            },
            {
                "id": 3,
                "name": "Neon Loft",
                "address": "Unit 5, Sample Yard, Mockford MK3 3CC",
                "map_url": "",
                "created_at": "2026-05-09 13:47:16"
            },
            {
                "id": 4,
                "name": "Oakridge Barn",
                "address": "44 Test Valley Road, Fableton FB4 4DD",
                "map_url": "",
                "created_at": "2026-05-09 13:47:16"
            }
        ],
        "packages": [
            {
                "id": 1,
                "name": "Essential",
                "description": "Core evening DJ coverage with planning portal.",
                "price_pence": 95000,
                "is_agency_package": 0,
                "agency_commission_percent": "0.00",
                "active": 1
            },
            {
                "id": 2,
                "name": "Signature Wedding",
                "description": "Full wedding package with ceremony support and evening party.",
                "price_pence": 145000,
                "is_agency_package": 0,
                "agency_commission_percent": "0.00",
                "active": 1
            },
            {
                "id": 3,
                "name": "Agency Club Night",
                "description": "Agency booking with DJ commission tracking.",
                "price_pence": 80000,
                "is_agency_package": 1,
                "agency_commission_percent": "20.00",
                "active": 1
            }
        ],
        "upsells": [
            {
                "id": 1,
                "name": "Ceremony audio",
                "description": "Microphones and music playback for ceremony.",
                "price_pence": 15000,
                "active": 1
            },
            {
                "id": 2,
                "name": "Confetti cannon moment",
                "description": "Two cannons for a first dance or room reveal.",
                "price_pence": 8000,
                "active": 1
            },
            {
                "id": 3,
                "name": "Extra hour",
                "description": "Additional performance hour.",
                "price_pence": 12500,
                "active": 1
            },
            {
                "id": 4,
                "name": "Mood lighting",
                "description": "Wireless uplighters for the room.",
                "price_pence": 18000,
                "active": 1
            }
        ],
        "bookings": [
            {
                "id": 1,
                "client_name": "Alex and Jordan",
                "client_email": "alex.jordan@example.invalid",
                "client_phone": "+44 7000 000101",
                "client_address": null,
                "event_date": "2026-05-12",
                "start_time": "16:00:00",
                "finish_time": "00:00:00",
                "venue_id": 1,
                "package_id": 2,
                "assigned_admin_id": 11,
                "residency_id": null,
                "external_source_instance": null,
                "external_source_reference": null,
                "external_source_business": null,
                "external_role_label": null,
                "external_offer_payload": null,
                "external_accepted_at": null,
                "custom_price_pence": 0,
                "status": "final_balance_due",
                "notes": "Elegant wedding with ceremony support and a high-energy evening finish.",
                "first_dance": "",
                "meeting_url": "",
                "couple_notes": "Demo planning notes for Alex and Jordan.",
                "client_token": "e4e88ed4376de127b7b555e5eb0822d637c0ecf25b4eb387",
                "package_price_pence": 145000,
                "upsell_total_pence": 33000,
                "total_pence": 178000,
                "agency_fee_pence": 0,
                "net_pence": 178000,
                "deposit_pence": 25000,
                "balance_pence": 153000,
                "spotify_playlist_url_day": null,
                "spotify_playlist_url_evening": null,
                "spotify_playlist_url_general": "",
                "spotify_playlist_url_do_not_play": "",
                "spotify_playlist_url_essential": "",
                "spotify_error": null,
                "contract_body_snapshot": null,
                "contract_generated_at": null,
                "signed_name": null,
                "signed_signature_data": null,
                "signed_at": null,
                "signed_ip": null,
                "created_at": "2026-05-09 13:47:16",
                "updated_at": "2026-05-09 13:47:16"
            },
            {
                "id": 2,
                "client_name": "Casey and Morgan",
                "client_email": "casey.morgan@example.invalid",
                "client_phone": "+44 7000 000102",
                "client_address": null,
                "event_date": "2026-05-27",
                "start_time": "18:30:00",
                "finish_time": "01:00:00",
                "venue_id": 2,
                "package_id": 2,
                "assigned_admin_id": 12,
                "residency_id": null,
                "external_source_instance": null,
                "external_source_reference": null,
                "external_source_business": null,
                "external_role_label": null,
                "external_offer_payload": null,
                "external_accepted_at": null,
                "custom_price_pence": 0,
                "status": "deposit_paid",
                "notes": "Client loves indie, Motown, and modern pop. Avoid heavy dance early evening.",
                "first_dance": "",
                "meeting_url": "",
                "couple_notes": "Demo planning notes for Casey and Morgan.",
                "client_token": "186f77cd609586059c552a55591775b2790d4701bb1e0f68",
                "package_price_pence": 145000,
                "upsell_total_pence": 8000,
                "total_pence": 153000,
                "agency_fee_pence": 0,
                "net_pence": 153000,
                "deposit_pence": 25000,
                "balance_pence": 128000,
                "spotify_playlist_url_day": null,
                "spotify_playlist_url_evening": null,
                "spotify_playlist_url_general": "",
                "spotify_playlist_url_do_not_play": "",
                "spotify_playlist_url_essential": "",
                "spotify_error": null,
                "contract_body_snapshot": null,
                "contract_generated_at": null,
                "signed_name": null,
                "signed_signature_data": null,
                "signed_at": null,
                "signed_ip": null,
                "created_at": "2026-05-09 13:47:16",
                "updated_at": "2026-05-09 13:47:16"
            },
            {
                "id": 3,
                "client_name": "Northside Social Club",
                "client_email": "events@example.invalid",
                "client_phone": "+44 7000 000103",
                "client_address": null,
                "event_date": "2026-06-03",
                "start_time": "21:00:00",
                "finish_time": "02:00:00",
                "venue_id": 3,
                "package_id": 3,
                "assigned_admin_id": 11,
                "residency_id": null,
                "external_source_instance": null,
                "external_source_reference": null,
                "external_source_business": null,
                "external_role_label": null,
                "external_offer_payload": null,
                "external_accepted_at": null,
                "custom_price_pence": 0,
                "status": "confirmed",
                "notes": "Monthly club residency demo booking.",
                "first_dance": "",
                "meeting_url": "",
                "couple_notes": "Demo planning notes for Northside Social Club.",
                "client_token": "9e65b0fbcaceb2597b154f80c2d572b1f702b5087de5d000",
                "package_price_pence": 80000,
                "upsell_total_pence": 0,
                "total_pence": 80000,
                "agency_fee_pence": 16000,
                "net_pence": 64000,
                "deposit_pence": 25000,
                "balance_pence": 55000,
                "spotify_playlist_url_day": null,
                "spotify_playlist_url_evening": null,
                "spotify_playlist_url_general": "",
                "spotify_playlist_url_do_not_play": "",
                "spotify_playlist_url_essential": "",
                "spotify_error": null,
                "contract_body_snapshot": null,
                "contract_generated_at": null,
                "signed_name": null,
                "signed_signature_data": null,
                "signed_at": null,
                "signed_ip": null,
                "created_at": "2026-05-09 13:47:16",
                "updated_at": "2026-05-09 13:47:16"
            },
            {
                "id": 4,
                "client_name": "Taylor and Riley",
                "client_email": "taylor.riley@example.invalid",
                "client_phone": "+44 7000 000104",
                "client_address": null,
                "event_date": "2026-06-23",
                "start_time": "15:00:00",
                "finish_time": "00:30:00",
                "venue_id": 4,
                "package_id": 1,
                "assigned_admin_id": 12,
                "residency_id": null,
                "external_source_instance": null,
                "external_source_reference": null,
                "external_source_business": null,
                "external_role_label": null,
                "external_offer_payload": null,
                "external_accepted_at": null,
                "custom_price_pence": 0,
                "status": "lead",
                "notes": "Lead enquiry for a summer wedding. Quote sent, awaiting confirmation.",
                "first_dance": "",
                "meeting_url": "",
                "couple_notes": "Demo planning notes for Taylor and Riley.",
                "client_token": "1bba8ef6cf250d7968be9abb8a599287ad400c0c7e2d2b1e",
                "package_price_pence": 95000,
                "upsell_total_pence": 12500,
                "total_pence": 107500,
                "agency_fee_pence": 0,
                "net_pence": 107500,
                "deposit_pence": 25000,
                "balance_pence": 82500,
                "spotify_playlist_url_day": null,
                "spotify_playlist_url_evening": null,
                "spotify_playlist_url_general": "",
                "spotify_playlist_url_do_not_play": "",
                "spotify_playlist_url_essential": "",
                "spotify_error": null,
                "contract_body_snapshot": null,
                "contract_generated_at": null,
                "signed_name": null,
                "signed_signature_data": null,
                "signed_at": null,
                "signed_ip": null,
                "created_at": "2026-05-09 13:47:16",
                "updated_at": "2026-05-09 13:47:16"
            },
            {
                "id": 5,
                "client_name": "Example Awards Night",
                "client_email": "awards@example.invalid",
                "client_phone": "+44 7000 000105",
                "client_address": null,
                "event_date": "2026-05-02",
                "start_time": "19:00:00",
                "finish_time": "23:30:00",
                "venue_id": 2,
                "package_id": null,
                "assigned_admin_id": 2,
                "residency_id": null,
                "external_source_instance": null,
                "external_source_reference": null,
                "external_source_business": null,
                "external_role_label": null,
                "external_offer_payload": null,
                "external_accepted_at": null,
                "custom_price_pence": 120000,
                "status": "final_balance_paid",
                "notes": "Completed corporate event with custom amount.",
                "first_dance": "",
                "meeting_url": "",
                "couple_notes": "Demo planning notes for Example Awards Night.",
                "client_token": "1830b78f21d476f821aebbf85f469463e651fa08e677b3d7",
                "package_price_pence": 120000,
                "upsell_total_pence": 18000,
                "total_pence": 138000,
                "agency_fee_pence": 0,
                "net_pence": 138000,
                "deposit_pence": 25000,
                "balance_pence": 113000,
                "spotify_playlist_url_day": null,
                "spotify_playlist_url_evening": null,
                "spotify_playlist_url_general": "",
                "spotify_playlist_url_do_not_play": "",
                "spotify_playlist_url_essential": "",
                "spotify_error": null,
                "contract_body_snapshot": null,
                "contract_generated_at": null,
                "signed_name": null,
                "signed_signature_data": null,
                "signed_at": null,
                "signed_ip": null,
                "created_at": "2026-05-09 13:47:16",
                "updated_at": "2026-05-09 13:47:16"
            }
        ],
        "booking_upsells": [
            {
                "booking_id": 1,
                "upsell_id": 1
            },
            {
                "booking_id": 1,
                "upsell_id": 4
            },
            {
                "booking_id": 2,
                "upsell_id": 2
            },
            {
                "booking_id": 4,
                "upsell_id": 3
            },
            {
                "booking_id": 5,
                "upsell_id": 4
            }
        ],
        "residencies": [
            {
                "id": 1,
                "title": "Neon Fridays",
                "venue_id": 3,
                "assigned_admin_id": 11,
                "package_id": 3,
                "custom_price_pence": 0,
                "start_date": "2026-05-09",
                "end_date": "2026-08-01",
                "day_of_week": 5,
                "start_time": "21:00:00",
                "finish_time": "02:00:00",
                "status": "confirmed",
                "notes": "Demo recurring club residency.",
                "active": 1,
                "created_at": "2026-05-09 13:47:16"
            }
        ],
        "calendar_events": [
            {
                "id": 1,
                "booking_id": 1,
                "event_type": "playlisting_meeting",
                "title": "Playlisting call - Alex and Jordan",
                "starts_at": "2026-05-10 19:00:00",
                "ends_at": "2026-05-10 19:30:00",
                "assigned_admin_id": 11,
                "notify_24h": 1,
                "notify_minutes": 1440,
                "notes": "Confirm essentials and do-not-play list.",
                "created_at": "2026-05-09 13:47:16"
            },
            {
                "id": 2,
                "booking_id": 4,
                "event_type": "selling_meeting",
                "title": "Selling meeting - Taylor and Riley",
                "starts_at": "2026-05-11 18:30:00",
                "ends_at": "2026-05-11 19:00:00",
                "assigned_admin_id": 12,
                "notify_24h": 1,
                "notify_minutes": 60,
                "notes": "Talk through package options.",
                "created_at": "2026-05-09 13:47:16"
            }
        ],
        "calendar_shares": [],
        "external_collaborators": [],
        "booking_collaborators": [],
        "document_templates": [
            {
                "id": 1,
                "title": "Standard contract",
                "document_type": "contract",
                "body": "Booking Contract\n\nClient: {{client_name}}\nAddress: {{client_address}}\nEvent date: {{event_date}}\nStart time: {{start_time}}\nFinish time: {{finish_time}}\nVenue: {{venue}}\nTotal: {{total}}\nDeposit: {{deposit}}\nBalance: {{balance}}\n\nBy typing your name and drawing your signature in the client portal, you confirm acceptance of these terms.",
                "active": 1,
                "created_at": "2026-05-06 11:38:00",
                "updated_at": "2026-05-06 11:38:00"
            },
            {
                "id": 2,
                "title": "Quote",
                "document_type": "quote",
                "body": "Quote\n\nClient: {{client_name}}\nAddress: {{client_address}}\nEvent date: {{event_date}}\nPackage: {{package}}\nTotal: {{total}}\nDeposit: {{deposit}}\nBalance: {{balance}}",
                "active": 1,
                "created_at": "2026-05-06 11:38:00",
                "updated_at": "2026-05-06 11:38:00"
            },
            {
                "id": 3,
                "title": "Order of the Day",
                "document_type": "order_of_day",
                "body": "Order of the Day\n\n12:00 Supplier access \/ setup\n14:00 Guests arrive\n15:00 Ceremony \/ main event\n18:00 Evening room ready\n19:30 First dance \/ playlist\n00:00 Finish and pack down",
                "active": 1,
                "created_at": "2026-05-06 11:38:00",
                "updated_at": "2026-05-06 11:38:00"
            },
            {
                "id": 4,
                "title": "Invoice",
                "document_type": "invoice",
                "body": "Invoice\n\n{{business_name}}\n{{business_address}}\n\nBill to: {{client_name}}\n{{client_address}}\nEmail: {{client_email}}\nEvent date: {{event_date}}\nVenue: {{venue}}\n\nPackage: {{package}}\nTotal: {{total}}\nDeposit: {{deposit}}\nBalance due: {{balance}}\n\nPayment terms\n{{payment_terms}}\n\nBank details\n{{bank_details}}",
                "active": 1,
                "created_at": "2026-05-06 11:38:00",
                "updated_at": "2026-05-06 11:38:00"
            }
        ],
        "documents": [
            {
                "id": 1,
                "booking_id": 1,
                "template_id": 2,
                "title": "Quote for Alex and Jordan",
                "document_type": "quote",
                "body_snapshot": "Quote for Alex and Jordan\n\nThis is demo document content.",
                "file_path": null,
                "original_filename": null,
                "mime_type": null,
                "created_at": "2026-05-09 13:47:16"
            },
            {
                "id": 2,
                "booking_id": 1,
                "template_id": 4,
                "title": "Invoice for Alex and Jordan",
                "document_type": "invoice",
                "body_snapshot": "Invoice for Alex and Jordan\n\nThis is demo document content.",
                "file_path": null,
                "original_filename": null,
                "mime_type": null,
                "created_at": "2026-05-09 13:47:16"
            },
            {
                "id": 3,
                "booking_id": 2,
                "template_id": 1,
                "title": "Contract for Casey and Morgan",
                "document_type": "contract",
                "body_snapshot": "Contract for Casey and Morgan\n\nThis is demo document content.",
                "file_path": null,
                "original_filename": null,
                "mime_type": null,
                "created_at": "2026-05-09 13:47:16"
            },
            {
                "id": 4,
                "booking_id": 3,
                "template_id": 4,
                "title": "Invoice for Northside Social Club",
                "document_type": "invoice",
                "body_snapshot": "Invoice for Northside Social Club\n\nThis is demo document content.",
                "file_path": null,
                "original_filename": null,
                "mime_type": null,
                "created_at": "2026-05-09 13:47:16"
            }
        ],
        "emails": [],
        "push_subscriptions": [],
        "notification_deliveries": [],
        "settings": [
            {
                "name": "app_mode",
                "value": "agency"
            },
            {
                "name": "bank_account_name",
                "value": "Gigora Events Demo"
            },
            {
                "name": "bank_account_number",
                "value": "12345678"
            },
            {
                "name": "bank_details",
                "value": "Account name: Gigora Events Demo\nSort code: 12-34-56\nAccount number: 12345678"
            },
            {
                "name": "bank_iban",
                "value": ""
            },
            {
                "name": "bank_sort_code",
                "value": "12-34-56"
            },
            {
                "name": "business_address",
                "value": "42 Demo House\nSample Street\nPX1 1AA"
            },
            {
                "name": "business_logo_path",
                "value": ""
            },
            {
                "name": "business_name",
                "value": "Gigora Events Demo"
            },
            {
                "name": "calendar_full_feed_token",
                "value": "db65f7cda3a1c94c4b8e37efaaa6ae5bba0e73acb34dcb31"
            },
            {
                "name": "calendar_share_token",
                "value": "b1addf065507a8ec3b8572aff523fdad9865"
            },
            {
                "name": "collaboration_api_token",
                "value": "52200bd5cd2bf091d3e40fe6e4592be41997a6f870bc0d97"
            },
            {
                "name": "customer_install",
                "value": "0"
            },
            {
                "name": "demo_data_seeded",
                "value": "1"
            },
            {
                "name": "deposit_fixed_pence",
                "value": "25000"
            },
            {
                "name": "deposit_percent",
                "value": "25"
            },
            {
                "name": "deposit_type",
                "value": "fixed"
            },
            {
                "name": "email_body",
                "value": "Hi {{client_name}},\n\nYour planning portal is ready here: {{planning_link}}\n\nTotal: {{total}}\nDeposit: {{deposit}}\nBalance: {{balance}}"
            },
            {
                "name": "email_subject",
                "value": "Your Gigora planning portal"
            },
            {
                "name": "from_email",
                "value": "bookings@gigora-demo.co.uk"
            },
            {
                "name": "licence_checked_at",
                "value": "2026-05-06 10:38:00"
            },
            {
                "name": "licence_grace_until",
                "value": ""
            },
            {
                "name": "licence_key",
                "value": "gigora_live_9e2ae68dae6c8b63950400ab10dc345b4406"
            },
            {
                "name": "licence_message",
                "value": "Instance provisioned from the Gigora licence hub."
            },
            {
                "name": "licence_plan",
                "value": "pro"
            },
            {
                "name": "licence_server_url",
                "value": "https:\/\/licences.gigora.co.uk"
            },
            {
                "name": "licence_status",
                "value": "active"
            },
            {
                "name": "notification_cron_key",
                "value": "ccc3d483eb3994a9565ef5ae29ebb683ba67"
            },
            {
                "name": "onboarding_complete",
                "value": "1"
            },
            {
                "name": "payment_terms",
                "value": "Deposit due on booking. Final balance due 14 days before the event."
            },
            {
                "name": "push_vapid_private_pem",
                "value": "-----BEGIN PRIVATE KEY-----\nMIGHAgEAMBMGByqGSM49AgEGCCqGSM49AwEHBG0wawIBAQQgePxGoSkglE0k2PiE\nUUXglZCQFmE9yjTaCvQ2S+Z14J+hRANCAASXlZKDgBeR12Yo1vWv4ndsUe9Qgd9S\nBbljDYkl5vS3lTCkV\/QDbFtTuIfrw0vXxKRPPIkCUCs7ik8RTlDQSNZx\n-----END PRIVATE KEY-----\n"
            },
            {
                "name": "push_vapid_public_key",
                "value": "BJeVkoOAF5HXZijW9a_id2xR71CB31IFuWMNiSXm9LeVMKRX9ANsW1O4h-vDS9fEpE88iQJQKzuKTxFOUNBI1nE"
            },
            {
                "name": "spotify_client_id",
                "value": ""
            },
            {
                "name": "spotify_client_secret",
                "value": ""
            },
            {
                "name": "temporary_password_active",
                "value": "0"
            },
            {
                "name": "update_notice_ack_version",
                "value": "2026-05-dashboard-reports"
            }
        ]
    },
    "files": []
}