paul@1083 | 1 | -- Object store tables. |
paul@1083 | 2 | |
paul@1083 | 3 | create table objects ( |
paul@1083 | 4 | store_user varchar not null, |
paul@1083 | 5 | object_uid varchar not null, |
paul@1083 | 6 | object_text varchar not null, |
paul@1083 | 7 | status varchar not null, -- 'active', 'cancelled' |
paul@1083 | 8 | primary key(store_user, object_uid) |
paul@1083 | 9 | ); |
paul@1083 | 10 | |
paul@1083 | 11 | create table countered_objects ( |
paul@1083 | 12 | store_user varchar not null, |
paul@1083 | 13 | other varchar not null, |
paul@1083 | 14 | object_uid varchar not null, |
paul@1083 | 15 | object_text varchar not null, |
paul@1083 | 16 | primary key(store_user, object_uid) |
paul@1083 | 17 | ); |
paul@1083 | 18 | |
paul@1083 | 19 | create table recurrences ( |
paul@1083 | 20 | store_user varchar not null, |
paul@1083 | 21 | object_uid varchar not null, |
paul@1083 | 22 | object_recurrenceid varchar not null, |
paul@1083 | 23 | object_text varchar not null, |
paul@1083 | 24 | status varchar not null, -- 'active', 'cancelled' |
paul@1083 | 25 | primary key(store_user, object_uid, object_recurrenceid) |
paul@1083 | 26 | ); |
paul@1083 | 27 | |
paul@1083 | 28 | create table countered_recurrences ( |
paul@1083 | 29 | store_user varchar not null, |
paul@1083 | 30 | other varchar not null, |
paul@1083 | 31 | object_uid varchar not null, |
paul@1083 | 32 | object_recurrenceid varchar not null, |
paul@1083 | 33 | object_text varchar not null, |
paul@1083 | 34 | primary key(store_user, object_uid, object_recurrenceid) |
paul@1083 | 35 | ); |
paul@1083 | 36 | |
paul@1083 | 37 | -- Object store free/busy details. |
paul@1083 | 38 | |
paul@1083 | 39 | create table freebusy ( |
paul@1083 | 40 | store_user varchar not null, |
paul@1083 | 41 | "start" varchar not null, |
paul@1083 | 42 | "end" varchar not null, |
paul@1083 | 43 | object_uid varchar, |
paul@1083 | 44 | transp varchar, |
paul@1083 | 45 | object_recurrenceid varchar, |
paul@1083 | 46 | summary varchar, |
paul@1083 | 47 | organiser varchar, |
paul@1083 | 48 | expires varchar |
paul@1083 | 49 | ); |
paul@1083 | 50 | |
paul@1083 | 51 | create table freebusy_offers ( |
paul@1083 | 52 | store_user varchar not null, |
paul@1083 | 53 | "start" varchar not null, |
paul@1083 | 54 | "end" varchar not null, |
paul@1083 | 55 | object_uid varchar, |
paul@1083 | 56 | transp varchar, |
paul@1083 | 57 | object_recurrenceid varchar, |
paul@1083 | 58 | summary varchar, |
paul@1083 | 59 | organiser varchar, |
paul@1083 | 60 | expires varchar |
paul@1083 | 61 | ); |
paul@1083 | 62 | |
paul@1083 | 63 | create table freebusy_other ( |
paul@1083 | 64 | store_user varchar not null, |
paul@1083 | 65 | other varchar not null, |
paul@1083 | 66 | "start" varchar not null, |
paul@1083 | 67 | "end" varchar not null, |
paul@1083 | 68 | object_uid varchar, |
paul@1083 | 69 | transp varchar, |
paul@1083 | 70 | object_recurrenceid varchar, |
paul@1083 | 71 | summary varchar, |
paul@1083 | 72 | organiser varchar, |
paul@1083 | 73 | expires varchar |
paul@1083 | 74 | ); |
paul@1083 | 75 | |
paul@1083 | 76 | create table freebusy_providers ( |
paul@1083 | 77 | store_user varchar not null, |
paul@1083 | 78 | object_uid varchar not null, |
paul@1083 | 79 | object_recurrenceid varchar |
paul@1083 | 80 | ); |
paul@1083 | 81 | |
paul@1083 | 82 | create table freebusy_provider_datetimes ( |
paul@1083 | 83 | store_user varchar not null, |
paul@1083 | 84 | "start" varchar not null |
paul@1083 | 85 | ); |
paul@1083 | 86 | |
paul@1083 | 87 | -- Object store request details. |
paul@1083 | 88 | |
paul@1083 | 89 | create table requests ( |
paul@1083 | 90 | store_user varchar not null, |
paul@1083 | 91 | object_uid varchar not null, |
paul@1083 | 92 | object_recurrenceid varchar, |
paul@1083 | 93 | request_type varchar |
paul@1083 | 94 | ); |
paul@1083 | 95 | |
paul@1083 | 96 | |
paul@1083 | 97 | |
paul@1083 | 98 | -- Journal store tables. |
paul@1083 | 99 | |
paul@1083 | 100 | -- Journal free/busy details. |
paul@1083 | 101 | |
paul@1083 | 102 | create table quota_freebusy ( |
paul@1083 | 103 | quota varchar not null, |
paul@1083 | 104 | user_group varchar not null, |
paul@1083 | 105 | "start" varchar not null, |
paul@1083 | 106 | "end" varchar not null, |
paul@1083 | 107 | object_uid varchar, |
paul@1083 | 108 | transp varchar, |
paul@1083 | 109 | object_recurrenceid varchar, |
paul@1083 | 110 | summary varchar, |
paul@1083 | 111 | organiser varchar, |
paul@1083 | 112 | expires varchar |
paul@1083 | 113 | ); |
paul@1083 | 114 | |
paul@1083 | 115 | create table user_freebusy ( |
paul@1083 | 116 | quota varchar not null, |
paul@1083 | 117 | store_user varchar not null, |
paul@1083 | 118 | "start" varchar not null, |
paul@1083 | 119 | "end" varchar not null, |
paul@1083 | 120 | object_uid varchar, |
paul@1083 | 121 | transp varchar, |
paul@1083 | 122 | object_recurrenceid varchar, |
paul@1083 | 123 | summary varchar, |
paul@1083 | 124 | organiser varchar, |
paul@1083 | 125 | expires varchar |
paul@1083 | 126 | ); |
paul@1083 | 127 | |
paul@1083 | 128 | -- Journal user groups and limits. |
paul@1083 | 129 | |
paul@1083 | 130 | create table quota_limits ( |
paul@1083 | 131 | user_group varchar not null, |
paul@1083 | 132 | quota_limit varchar not null, |
paul@1083 | 133 | primary key(user_group) |
paul@1083 | 134 | ); |
paul@1083 | 135 | |
paul@1083 | 136 | create table user_groups ( |
paul@1083 | 137 | store_user varchar not null, |
paul@1083 | 138 | user_group varchar not null, |
paul@1083 | 139 | primary key(store_user, user_group) |
paul@1083 | 140 | ); |