1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000
1.2 +++ b/conf/postgresql/schema.sql Wed Mar 09 00:08:49 2016 +0100
1.3 @@ -0,0 +1,140 @@
1.4 +-- Object store tables.
1.5 +
1.6 +create table objects (
1.7 + store_user varchar not null,
1.8 + object_uid varchar not null,
1.9 + object_text varchar not null,
1.10 + status varchar not null, -- 'active', 'cancelled'
1.11 + primary key(store_user, object_uid)
1.12 +);
1.13 +
1.14 +create table countered_objects (
1.15 + store_user varchar not null,
1.16 + other varchar not null,
1.17 + object_uid varchar not null,
1.18 + object_text varchar not null,
1.19 + primary key(store_user, object_uid)
1.20 +);
1.21 +
1.22 +create table recurrences (
1.23 + store_user varchar not null,
1.24 + object_uid varchar not null,
1.25 + object_recurrenceid varchar not null,
1.26 + object_text varchar not null,
1.27 + status varchar not null, -- 'active', 'cancelled'
1.28 + primary key(store_user, object_uid, object_recurrenceid)
1.29 +);
1.30 +
1.31 +create table countered_recurrences (
1.32 + store_user varchar not null,
1.33 + other varchar not null,
1.34 + object_uid varchar not null,
1.35 + object_recurrenceid varchar not null,
1.36 + object_text varchar not null,
1.37 + primary key(store_user, object_uid, object_recurrenceid)
1.38 +);
1.39 +
1.40 +-- Object store free/busy details.
1.41 +
1.42 +create table freebusy (
1.43 + store_user varchar not null,
1.44 + "start" varchar not null,
1.45 + "end" varchar not null,
1.46 + object_uid varchar,
1.47 + transp varchar,
1.48 + object_recurrenceid varchar,
1.49 + summary varchar,
1.50 + organiser varchar,
1.51 + expires varchar
1.52 +);
1.53 +
1.54 +create table freebusy_offers (
1.55 + store_user varchar not null,
1.56 + "start" varchar not null,
1.57 + "end" varchar not null,
1.58 + object_uid varchar,
1.59 + transp varchar,
1.60 + object_recurrenceid varchar,
1.61 + summary varchar,
1.62 + organiser varchar,
1.63 + expires varchar
1.64 +);
1.65 +
1.66 +create table freebusy_other (
1.67 + store_user varchar not null,
1.68 + other varchar not null,
1.69 + "start" varchar not null,
1.70 + "end" varchar not null,
1.71 + object_uid varchar,
1.72 + transp varchar,
1.73 + object_recurrenceid varchar,
1.74 + summary varchar,
1.75 + organiser varchar,
1.76 + expires varchar
1.77 +);
1.78 +
1.79 +create table freebusy_providers (
1.80 + store_user varchar not null,
1.81 + object_uid varchar not null,
1.82 + object_recurrenceid varchar
1.83 +);
1.84 +
1.85 +create table freebusy_provider_datetimes (
1.86 + store_user varchar not null,
1.87 + "start" varchar not null
1.88 +);
1.89 +
1.90 +-- Object store request details.
1.91 +
1.92 +create table requests (
1.93 + store_user varchar not null,
1.94 + object_uid varchar not null,
1.95 + object_recurrenceid varchar,
1.96 + request_type varchar
1.97 +);
1.98 +
1.99 +
1.100 +
1.101 +-- Journal store tables.
1.102 +
1.103 +-- Journal free/busy details.
1.104 +
1.105 +create table quota_freebusy (
1.106 + quota varchar not null,
1.107 + user_group varchar not null,
1.108 + "start" varchar not null,
1.109 + "end" varchar not null,
1.110 + object_uid varchar,
1.111 + transp varchar,
1.112 + object_recurrenceid varchar,
1.113 + summary varchar,
1.114 + organiser varchar,
1.115 + expires varchar
1.116 +);
1.117 +
1.118 +create table user_freebusy (
1.119 + quota varchar not null,
1.120 + store_user varchar not null,
1.121 + "start" varchar not null,
1.122 + "end" varchar not null,
1.123 + object_uid varchar,
1.124 + transp varchar,
1.125 + object_recurrenceid varchar,
1.126 + summary varchar,
1.127 + organiser varchar,
1.128 + expires varchar
1.129 +);
1.130 +
1.131 +-- Journal user groups and limits.
1.132 +
1.133 +create table quota_limits (
1.134 + user_group varchar not null,
1.135 + quota_limit varchar not null,
1.136 + primary key(user_group)
1.137 +);
1.138 +
1.139 +create table user_groups (
1.140 + store_user varchar not null,
1.141 + user_group varchar not null,
1.142 + primary key(store_user, user_group)
1.143 +);