Revision 3733,
517 bytes
checked in by gabriel.malheiros, 14 years ago
(diff) |
Ticket #1541 - <Davical customizado para o Expresso.Utiliza Caldav e CardDav?>
|
Line | |
---|
1 | |
---|
2 | -- Sort out accessing calendar entries. |
---|
3 | |
---|
4 | BEGIN; |
---|
5 | SELECT check_db_revision(1,1,10); |
---|
6 | |
---|
7 | ALTER TABLE caldav_data DROP CONSTRAINT "$1"; |
---|
8 | ALTER TABLE caldav_data ADD CONSTRAINT "$1" FOREIGN KEY (user_no) REFERENCES usr(user_no) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE; |
---|
9 | |
---|
10 | ALTER TABLE collection DROP CONSTRAINT "$1"; |
---|
11 | ALTER TABLE collection ADD CONSTRAINT "$1" FOREIGN KEY (user_no) REFERENCES usr(user_no) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE; |
---|
12 | |
---|
13 | SELECT new_db_revision(1,1,11, 'November' ); |
---|
14 | COMMIT; |
---|
15 | ROLLBACK; |
---|
16 | |
---|
Note: See
TracBrowser
for help on using the repository browser.