
SELECT id INTO @siteId FROM site limit 1;

INSERT INTO `site_global` ( `site_id`, `label`, `json`, `data`)
VALUES
    ( @siteId, 'item_card_banner', 1, '{\n  \"start_date\": \"2022-01-01\",\n  \"end_date\": \"2022-01-31\",\n  \"show_for_types\": [\n    \"raceday\"\n  ]\n}');

SELECT data INTO @current_content
FROM site_global
WHERE label = 'event_custom_content';

SET @new_content = '<div class="arc-container event-ticket-options__buy-tickets-panel my-4">
        <div class="row no-gutters">
            <div class="col-12 text-center my-2">
                <h5>Mega January Sale! Save £10 per person!</h5>
            </div>
        </div>
        <div class="row no-gutters">
            <div class="col-12 text-center">
                <p class="mx-4">It\'s time to look forward to brighter days. Save £10 PER PERSON when you book a group of 6+ tickets – available at 2022 fixtures* – but only available to book until the  31st January. Simply select the Mega January Sale ticket package. *T&Cs apply.</p>
            </div>
        </div>
    </div>';

UPDATE site_global
SET data = CONCAT(@new_content, @current_content)
WHERE label = 'event_custom_content';

