source: contrib/davical/dba/patches/1.1.7.sql @ 3733

Revision 3733, 2.0 KB checked in by gabriel.malheiros, 13 years ago (diff)

Ticket #1541 - <Davical customizado para o Expresso.Utiliza Caldav e CardDav?>

Line 
1
2-- Adding lock support
3
4BEGIN;
5SELECT check_db_revision(1,1,6);
6
7ALTER TABLE relationship_type DROP COLUMN rt_inverse;
8ALTER TABLE relationship_type DROP COLUMN prefix_match;
9ALTER TABLE relationship_type DROP COLUMN rt_isgroup;
10
11UPDATE relationship_type SET rt_name ='Administers', confers = 'A' WHERE rt_id = 1;
12UPDATE relationship_type SET rt_name ='is Assistant to', confers = 'RW' WHERE rt_id = 2;
13UPDATE relationship_type SET rt_name ='Can read from', confers = 'R' WHERE rt_id = 3;
14UPDATE relationship_type SET rt_name ='Can see free/busy time of', confers = 'F' WHERE rt_id = 4;
15
16UPDATE relationship SET rt_id=1 WHERE rt_id=4;
17UPDATE relationship SET rt_id=4 WHERE rt_id=5;
18
19DELETE FROM relationship_type WHERE rt_id = 5;
20
21-- Add a 'status' column to calendar_item which will contain the parsed value of the STATUS property
22ALTER TABLE calendar_item ADD COLUMN status TEXT;
23UPDATE calendar_item SET status = 'CONFIRMED';
24UPDATE calendar_item SET status = 'CANCELLED'    WHERE calendar_item.dav_name IN (SELECT dav_name FROM caldav_data WHERE caldav_data.caldav_data ~ 'STATUS.*:.*CANCELLED');
25UPDATE calendar_item SET status = 'TENTATIVE'    WHERE calendar_item.dav_name IN (SELECT dav_name FROM caldav_data WHERE caldav_data.caldav_data ~ 'STATUS.*:.*TENTATIVE');
26UPDATE calendar_item SET status = 'NEEDS-ACTION' WHERE calendar_item.dav_name IN (SELECT dav_name FROM caldav_data WHERE caldav_data.caldav_data ~ 'STATUS.*:.*NEEDS-ACTION');
27UPDATE calendar_item SET status = 'IN-PROCESS'   WHERE calendar_item.dav_name IN (SELECT dav_name FROM caldav_data WHERE caldav_data.caldav_data ~ 'STATUS.*:.*IN-PROCESS');
28UPDATE calendar_item SET status = 'DRAFT'        WHERE calendar_item.dav_name IN (SELECT dav_name FROM caldav_data WHERE caldav_data.caldav_data ~ 'STATUS.*:.*DRAFT');
29UPDATE calendar_item SET status = 'FINAL'        WHERE calendar_item.dav_name IN (SELECT dav_name FROM caldav_data WHERE caldav_data.caldav_data ~ 'STATUS.*:.*FINAL');
30
31SELECT new_db_revision(1,1,7, 'July' );
32COMMIT;
33ROLLBACK;
34
Note: See TracBrowser for help on using the repository browser.