[3733] | 1 | |
---|
| 2 | -- Adding lock support |
---|
| 3 | |
---|
| 4 | BEGIN; |
---|
| 5 | SELECT check_db_revision(1,1,5); |
---|
| 6 | |
---|
| 7 | CREATE TABLE locks ( |
---|
| 8 | dav_name TEXT, |
---|
| 9 | opaquelocktoken TEXT UNIQUE NOT NULL, |
---|
| 10 | type TEXT, |
---|
| 11 | scope TEXT, |
---|
| 12 | depth INT, |
---|
| 13 | owner TEXT, |
---|
| 14 | timeout INTERVAL, |
---|
| 15 | start TIMESTAMP DEFAULT current_timestamp |
---|
| 16 | ); |
---|
| 17 | |
---|
| 18 | CREATE INDEX locks_dav_name_idx ON locks(dav_name); |
---|
| 19 | GRANT SELECT,INSERT,UPDATE,DELETE ON locks TO general; |
---|
| 20 | |
---|
| 21 | CREATE TABLE property ( |
---|
| 22 | dav_name TEXT, |
---|
| 23 | property_name TEXT, |
---|
| 24 | property_value TEXT, |
---|
| 25 | changed_on TIMESTAMP DEFAULT current_timestamp, |
---|
| 26 | changed_by INT REFERENCES usr ( user_no ), |
---|
| 27 | PRIMARY KEY ( dav_name, property_name ) |
---|
| 28 | ); |
---|
| 29 | |
---|
| 30 | CREATE INDEX properties_dav_name_idx ON property(dav_name); |
---|
| 31 | GRANT SELECT,INSERT,UPDATE,DELETE ON property TO general; |
---|
| 32 | |
---|
| 33 | UPDATE relationship_type SET confers = 'A' WHERE rt_id = 1; |
---|
| 34 | UPDATE relationship_type SET confers = 'RW' WHERE rt_id = 2; |
---|
| 35 | UPDATE relationship_type SET confers = 'R' WHERE rt_id = 3; |
---|
| 36 | UPDATE relationship_type SET confers = 'A' WHERE rt_id = 4; |
---|
| 37 | |
---|
| 38 | INSERT INTO relationship_type ( rt_id, rt_name, rt_isgroup, confers, prefix_match ) |
---|
| 39 | VALUES( 5, 'Can see free/busy time of', FALSE, 'F', '' ); |
---|
| 40 | |
---|
| 41 | SELECT new_db_revision(1,1,6, 'June' ); |
---|
| 42 | COMMIT; |
---|
| 43 | ROLLBACK; |
---|
| 44 | |
---|