mirror of
https://gitlab.com/davical-project/davical.git
synced 2026-02-20 04:33:34 +00:00
17 lines
517 B
PL/PgSQL
17 lines
517 B
PL/PgSQL
|
|
-- Sort out accessing calendar entries.
|
|
|
|
BEGIN;
|
|
SELECT check_db_revision(1,1,10);
|
|
|
|
ALTER TABLE caldav_data DROP CONSTRAINT "$1";
|
|
ALTER TABLE caldav_data ADD CONSTRAINT "$1" FOREIGN KEY (user_no) REFERENCES usr(user_no) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE;
|
|
|
|
ALTER TABLE collection DROP CONSTRAINT "$1";
|
|
ALTER TABLE collection ADD CONSTRAINT "$1" FOREIGN KEY (user_no) REFERENCES usr(user_no) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE;
|
|
|
|
SELECT new_db_revision(1,1,11, 'November' );
|
|
COMMIT;
|
|
ROLLBACK;
|
|
|