Revision 3733,
711 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 | -- This alternative patch file is the same in/out revision as 1.1.11 but it works with newer databases (8.x) |
---|
| 4 | |
---|
| 5 | BEGIN; |
---|
| 6 | SELECT check_db_revision(1,1,10); |
---|
| 7 | |
---|
| 8 | ALTER TABLE caldav_data DROP CONSTRAINT "caldav_data_user_no_fkey"; |
---|
| 9 | ALTER TABLE caldav_data ADD CONSTRAINT "caldav_data_user_no_fkey" FOREIGN KEY (user_no) REFERENCES usr(user_no) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE; |
---|
| 10 | |
---|
| 11 | ALTER TABLE collection DROP CONSTRAINT "collection_user_no_fkey"; |
---|
| 12 | ALTER TABLE collection ADD CONSTRAINT "collection_user_no_fkey" FOREIGN KEY (user_no) REFERENCES usr(user_no) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE; |
---|
| 13 | |
---|
| 14 | SELECT new_db_revision(1,1,11, 'November' ); |
---|
| 15 | COMMIT; |
---|
| 16 | ROLLBACK; |
---|
| 17 | |
---|
Note: See
TracBrowser
for help on using the repository browser.