[3733] | 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 | |
---|