Revision 3733,
1.3 KB
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 | -- This database update adds support for tickets to be handed out to grant |
---|
| 3 | -- specific access to a collection or individual resource, as read-only or |
---|
| 4 | -- read-write. A table is also added to manage WebDAV binding, in line |
---|
| 5 | -- with http://tools.ietf.org/html/draft-ietf-webdav-bind. |
---|
| 6 | |
---|
| 7 | BEGIN; |
---|
| 8 | SELECT check_db_revision(1,2,8); |
---|
| 9 | |
---|
| 10 | -- Kind of important to have these as first-class citizens |
---|
| 11 | ALTER TABLE addressbook_resource ADD COLUMN fburl TEXT DEFAULT NULL; |
---|
| 12 | ALTER TABLE addressbook_resource ADD COLUMN caluri TEXT DEFAULT NULL; |
---|
| 13 | ALTER TABLE addressbook_resource ADD COLUMN caladruri TEXT DEFAULT NULL; |
---|
| 14 | |
---|
| 15 | DROP TABLE addressbook_address_adr CASCADE; |
---|
| 16 | CREATE TABLE addressbook_address_adr ( |
---|
| 17 | dav_id INT8 NOT NULL REFERENCES caldav_data(dav_id) ON UPDATE CASCADE ON DELETE CASCADE, |
---|
| 18 | type TEXT, |
---|
| 19 | box_no TEXT, |
---|
| 20 | unit_no TEXT, |
---|
| 21 | street_address TEXT, |
---|
| 22 | locality TEXT, |
---|
| 23 | region TEXT, |
---|
| 24 | postcode TEXT, |
---|
| 25 | country TEXT, |
---|
| 26 | property TEXT -- The full text of the property |
---|
| 27 | ); |
---|
| 28 | |
---|
| 29 | -- 'N' => 'New/Needs setting', 'A' = 'Active', 'O' = 'Old' |
---|
| 30 | ALTER TABLE calendar_alarm ADD COLUMN trigger_state CHAR DEFAULT 'N'; |
---|
| 31 | |
---|
| 32 | -- Internal DAViCal calendar state |
---|
| 33 | ALTER TABLE calendar_attendee ADD COLUMN attendee_state TEXT; |
---|
| 34 | ALTER TABLE calendar_attendee ADD COLUMN weak_etag TEXT; |
---|
| 35 | |
---|
| 36 | SELECT new_db_revision(1,2,9, 'Septembre' ); |
---|
| 37 | |
---|
| 38 | COMMIT; |
---|
| 39 | ROLLBACK; |
---|
| 40 | |
---|
Note: See
TracBrowser
for help on using the repository browser.