1.1 --- a/conf/postgresql/schema.sql Sat Jun 04 17:16:36 2016 +0200
1.2 +++ b/conf/postgresql/schema.sql Sat Jun 04 18:42:53 2016 +0200
1.3 @@ -74,7 +74,8 @@
1.4 transp varchar,
1.5 object_recurrenceid varchar,
1.6 summary varchar,
1.7 - organiser varchar
1.8 + organiser varchar,
1.9 + attendee varchar -- used by quotas
1.10 );
1.11
1.12 create index freebusy_other_start on freebusy_other(store_user, other, "start");
1.13 @@ -110,45 +111,12 @@
1.14
1.15 -- Journal store tables.
1.16
1.17 --- Journal free/busy details.
1.18 -
1.19 -create table quota_freebusy (
1.20 - quota varchar not null,
1.21 - user_group varchar not null,
1.22 - "start" varchar not null,
1.23 - "end" varchar not null,
1.24 - object_uid varchar,
1.25 - transp varchar,
1.26 - object_recurrenceid varchar,
1.27 - summary varchar,
1.28 - organiser varchar,
1.29 - attendee varchar
1.30 -);
1.31 -
1.32 -create index quota_freebusy_start on quota_freebusy(quota, user_group, "start");
1.33 -create index quota_freebusy_end on quota_freebusy(quota, user_group, "end");
1.34 -
1.35 create table quota_delegates (
1.36 quota varchar not null,
1.37 store_user varchar not null,
1.38 primary key(quota, store_user)
1.39 );
1.40
1.41 -create table user_freebusy (
1.42 - quota varchar not null,
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 -);
1.52 -
1.53 -create index user_freebusy_start on user_freebusy(quota, store_user, "start");
1.54 -create index user_freebusy_end on user_freebusy(quota, store_user, "end");
1.55 -
1.56 -- Journal user groups and limits.
1.57
1.58 create table quota_limits (