view plugins/calendar/drivers/database/SQL/postgres/2015022700.sql @ 41:d2414df68d78

Updated by Alex S Grebenschikov (www.poralix.com) to make it compatible with RoundCube 1.3.0
author Charlie Root
date Fri, 24 Jan 2025 14:20:15 -0500
parents f6fe4b6ae66a
children
line wrap: on
line source

-- add identifier for recurring instances and exceptions

ALTER TABLE events ADD instance character varying(16) NOT NULL;
ALTER TABLE events ADD isexception smallint NOT NULL DEFAULT '0';

-- extend alarms columns for multiple values

ALTER TABLE events ALTER COLUMN alarms TYPE text;