-- System upgrade 010: optimise the public list of simultaneously bookable events.
-- Safe to run more than once on MySQL or MariaDB.
SET @event_index_exists = (
  SELECT COUNT(*)
  FROM information_schema.statistics
  WHERE table_schema = DATABASE()
    AND table_name = 'meetings'
    AND index_name = 'idx_meeting_public_booking'
);
SET @event_index_sql = IF(
  @event_index_exists = 0,
  'CREATE INDEX idx_meeting_public_booking ON meetings (archived,bookings_open,lifecycle_status,booking_deadline,meeting_date)',
  'SELECT ''idx_meeting_public_booking already exists'' AS upgrade_status'
);
PREPARE event_index_statement FROM @event_index_sql;
EXECUTE event_index_statement;
DEALLOCATE PREPARE event_index_statement;