| Revision 3733,
517 bytes
checked in by gabriel.malheiros, 13 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.
