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 | |
---|