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?>
|
Line | |
---|
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.