mirror of
https://gitlab.com/davical-project/davical.git
synced 2026-02-20 04:33:34 +00:00
21 lines
605 B
PL/PgSQL
21 lines
605 B
PL/PgSQL
|
|
-- 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;
|
|
|