Revision 3733,
517 bytes
checked in by gabriel.malheiros, 14 years ago
(diff) |
Ticket #1541 - <Davical customizado para o Expresso.Utiliza Caldav e CardDav?>
|
Rev | Line | |
---|
[3733] | 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.