Revision 3733,
605 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,9); |
---|
| 6 | |
---|
| 7 | -- Make sure that class is set to something, by default PUBLIC. |
---|
| 8 | -- According to RFC2445, 4.8.1.3. |
---|
| 9 | UPDATE calendar_item SET class = 'PUBLIC' WHERE class IS NULL; |
---|
| 10 | |
---|
| 11 | -- Allow forcing all events in a calendar to be public |
---|
| 12 | ALTER TABLE collection ADD COLUMN public_events_only BOOLEAN; |
---|
| 13 | UPDATE collection SET public_events_only = FALSE; |
---|
| 14 | ALTER TABLE collection ALTER public_events_only SET NOT NULL; |
---|
| 15 | ALTER TABLE collection ALTER public_events_only SET DEFAULT FALSE; |
---|
| 16 | |
---|
| 17 | SELECT new_db_revision(1,1,10, 'October' ); |
---|
| 18 | COMMIT; |
---|
| 19 | ROLLBACK; |
---|
| 20 | |
---|
Note: See
TracBrowser
for help on using the repository browser.