source: contrib/davical/dba/patches/1.1.10.sql @ 3733

-- Sort out accessing calendar entries.

BEGIN;
SELECT check_db_revision(1,1,9);

-- Make sure that class is set to something, by default PUBLIC.
-- According to RFC2445, 4.8.1.3.
UPDATE calendar_item SET class = 'PUBLIC' WHERE class IS NULL;

-- Allow forcing all events in a calendar to be public
ALTER TABLE collection ADD COLUMN public_events_only BOOLEAN;
UPDATE collection SET public_events_only = FALSE;
ALTER TABLE collection ALTER public_events_only SET NOT NULL;
ALTER TABLE collection ALTER public_events_only SET DEFAULT FALSE;

SELECT new_db_revision(1,1,10, 'October' );
COMMIT;
ROLLBACK;