1 | |
---|
2 | -- Adding lock support |
---|
3 | |
---|
4 | BEGIN; |
---|
5 | SELECT check_db_revision(1,1,6); |
---|
6 | |
---|
7 | ALTER TABLE relationship_type DROP COLUMN rt_inverse; |
---|
8 | ALTER TABLE relationship_type DROP COLUMN prefix_match; |
---|
9 | ALTER TABLE relationship_type DROP COLUMN rt_isgroup; |
---|
10 | |
---|
11 | UPDATE relationship_type SET rt_name ='Administers', confers = 'A' WHERE rt_id = 1; |
---|
12 | UPDATE relationship_type SET rt_name ='is Assistant to', confers = 'RW' WHERE rt_id = 2; |
---|
13 | UPDATE relationship_type SET rt_name ='Can read from', confers = 'R' WHERE rt_id = 3; |
---|
14 | UPDATE relationship_type SET rt_name ='Can see free/busy time of', confers = 'F' WHERE rt_id = 4; |
---|
15 | |
---|
16 | UPDATE relationship SET rt_id=1 WHERE rt_id=4; |
---|
17 | UPDATE relationship SET rt_id=4 WHERE rt_id=5; |
---|
18 | |
---|
19 | DELETE 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 |
---|
22 | ALTER TABLE calendar_item ADD COLUMN status TEXT; |
---|
23 | UPDATE calendar_item SET status = 'CONFIRMED'; |
---|
24 | UPDATE calendar_item SET status = 'CANCELLED' WHERE calendar_item.dav_name IN (SELECT dav_name FROM caldav_data WHERE caldav_data.caldav_data ~ 'STATUS.*:.*CANCELLED'); |
---|
25 | UPDATE calendar_item SET status = 'TENTATIVE' WHERE calendar_item.dav_name IN (SELECT dav_name FROM caldav_data WHERE caldav_data.caldav_data ~ 'STATUS.*:.*TENTATIVE'); |
---|
26 | UPDATE 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'); |
---|
27 | UPDATE 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'); |
---|
28 | UPDATE calendar_item SET status = 'DRAFT' WHERE calendar_item.dav_name IN (SELECT dav_name FROM caldav_data WHERE caldav_data.caldav_data ~ 'STATUS.*:.*DRAFT'); |
---|
29 | UPDATE 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 | |
---|
31 | SELECT new_db_revision(1,1,7, 'July' ); |
---|
32 | COMMIT; |
---|
33 | ROLLBACK; |
---|
34 | |
---|