Viewing File: /usr/local/cpanel/base/3rdparty/roundcube/plugins/calendar/SQL/sqlite.2023030100.migration.sql

/* CPANEL-42492 - needs OLD not NEW */
DROP TRIGGER IF EXISTS caldav_calendars_merged_delete;
CREATE TRIGGER caldav_calendars_merged_delete
  INSTEAD OF DELETE ON caldav_calendars_merged
  BEGIN
    DELETE FROM calendars WHERE calendar_id=OLD.calendar_id;
    DELETE FROM caldav_calendars WHERE calendar_id=OLD.calendar_id;
  END;
INSERT OR REPLACE INTO system (name, value) VALUES ('calendar-database-version', '2023030100');