1.1 --- a/conf/postgresql/schema.sql Sun Apr 03 23:21:31 2016 +0200
1.2 +++ b/conf/postgresql/schema.sql Sun Apr 10 02:32:47 2016 +0200
1.3 @@ -48,6 +48,9 @@
1.4 expires varchar
1.5 );
1.6
1.7 +create index freebusy_start on freebusy(store_user, "start");
1.8 +create index freebusy_end on freebusy(store_user, "end");
1.9 +
1.10 create table freebusy_offers (
1.11 store_user varchar not null,
1.12 "start" varchar not null,
1.13 @@ -60,6 +63,9 @@
1.14 expires varchar
1.15 );
1.16
1.17 +create index freebusy_offers_start on freebusy_offers(store_user, "start");
1.18 +create index freebusy_offers_end on freebusy_offers(store_user, "end");
1.19 +
1.20 create table freebusy_other (
1.21 store_user varchar not null,
1.22 other varchar not null,
1.23 @@ -73,17 +79,24 @@
1.24 expires varchar
1.25 );
1.26
1.27 +create index freebusy_other_start on freebusy_other(store_user, other, "start");
1.28 +create index freebusy_other_end on freebusy_other(store_user, other, "end");
1.29 +
1.30 create table freebusy_providers (
1.31 store_user varchar not null,
1.32 object_uid varchar not null,
1.33 object_recurrenceid varchar
1.34 );
1.35
1.36 +create index freebusy_providers_store_user on freebusy_providers(store_user);
1.37 +
1.38 create table freebusy_provider_datetimes (
1.39 store_user varchar not null,
1.40 "start" varchar
1.41 );
1.42
1.43 +create index freebusy_provider_datetimes_store_user on freebusy_provider_datetimes(store_user);
1.44 +
1.45 -- Object store request details.
1.46
1.47 create table requests (
1.48 @@ -93,6 +106,8 @@
1.49 request_type varchar
1.50 );
1.51
1.52 +create index requests_object_uid on requests(store_user, object_uid);
1.53 +
1.54
1.55
1.56 -- Journal store tables.
1.57 @@ -112,6 +127,9 @@
1.58 expires varchar
1.59 );
1.60
1.61 +create index quota_freebusy_start on quota_freebusy(quota, user_group, "start");
1.62 +create index quota_freebusy_end on quota_freebusy(quota, user_group, "end");
1.63 +
1.64 create table user_freebusy (
1.65 quota varchar not null,
1.66 store_user varchar not null,
1.67 @@ -125,6 +143,9 @@
1.68 expires varchar
1.69 );
1.70
1.71 +create index user_freebusy_start on user_freebusy(quota, store_user, "start");
1.72 +create index user_freebusy_end on user_freebusy(quota, store_user, "end");
1.73 +
1.74 -- Journal user groups and limits.
1.75
1.76 create table quota_limits (