Andrew Ruthven
15d01c8bed
Store DTSTART and DTEND from user in shadow columns
...
We want to store the calculated dtstart and dtend in the database so we can
use SQL to fetch records. However, we also need what the user sent us so we
can allow prop-filters to be used as well.
So we store what the user sends us in dtstart_orig and dtend_orig and only
use for relevant prop-filter reports.
2023-03-12 20:17:43 +01:00
Andrew Ruthven
e3b5c331be
Add a primary key to calendar_alarm table.
...
Also fixed a bug in scripts/refresh-alarms.php if there was an
alarm with a duplicate trigger.
This is part of the fix for #276 .
2023-02-15 07:42:34 +00:00
Andrew Ruthven
6819d6d7d1
Add a primary_key to the addressbook_addresses_* tables
...
This is part of the fix for #276 .
2023-02-15 07:42:34 +00:00
Jamie McClymont
0c006b5c7c
Make the recurrence range columns in the database tz-aware
2019-01-03 16:04:28 +13:00
Andrew McMillan
c5c0421caf
Add /metrics.php to be scraped by Prometheus for monitoring.
2016-06-22 23:53:22 +01:00
Andrew McMillan
1ab66a70b5
Some database changes for server-side attendee handling.
2016-06-22 23:44:10 +01:00
Mark Davies
0797e8233e
First batch of database indexes
...
Added in support of Issue #31 , Database Performance Improvements. Note
creation of 1.2.12 db patch script - may need renaming or other special
treatment when merging this branch.
2014-12-16 21:29:26 +01:00
“Paul
931651ca32
Remove quoted SQL language identifiers
2014-09-02 20:01:28 +02:00
Andrew McMillan
25c9fca4b8
Correct capitalisation of 'plpgsql' language for Postgres 9.2.
2013-03-06 20:22:55 +13:00
Andrew McMillan
cd7f8c35f2
Update to version 1.2.11
2011-09-24 12:56:11 +12:00
Andrew McMillan
05d42557d7
Update davical.sql to 1.2.10.
2011-09-12 09:49:32 +12:00
Rob Ostensen
b2ef0b0bf2
Add the required fields to dav_binding and clean up the SQL to better match the rest of the source.
...
Add a header/last-modified check to skip the import on calendars that haven't changed.
2011-08-25 14:17:28 +12:00
Andrew McMillan
1fbf1be670
Add a weak_etag field to the calendar_attendee table.
2010-05-30 11:31:14 +12:00
Andrew McMillan
06abe8bd2e
New patches for next upgrade.
2010-05-19 23:49:50 +12:00
Andrew McMillan
73219e4f57
A few minor database changes.
2010-05-12 22:15:44 +12:00
Andrew McMillan
bb2435eb34
Rename 'all' variable which appears to be a reserved word in PostgreSQL 9
2010-05-09 09:05:23 +12:00
Andrew McMillan
5311d3a68a
Remove the freebusy_set from the collection.
2010-03-20 00:31:06 +13:00
Andrew McMillan
58356fb3e3
Remove the mashup tables which we will do more sensibly.
2010-03-18 19:57:14 +13:00
Andrew McMillan
4d674c4f92
Getting bindings to work as seamlessly as possible.
2010-03-15 00:31:16 +13:00
Andrew McMillan
ed055722e9
Working BIND and PROPFIND of bound resources.
2010-03-14 00:22:43 +13:00
Andrew McMillan
1c9c77e412
Add initial support for BIND method.
2010-03-12 11:29:27 +13:00
Andrew McMillan
f4416f84e9
Add a primary key.
2010-03-06 23:32:59 +13:00
Andrew McMillan
b12bf600c1
Update to current 1.2.8 patch.
2010-03-05 12:25:56 +13:00
Andrew McMillan
0fffd0e417
First (untested) cut at MKTICKET implementation.
2010-03-05 00:02:26 +13:00
Andrew McMillan
4e86c56a14
Current plans for rev 1.2.8 data structure changes.
2010-03-03 14:36:35 +13:00
Andrew McMillan
555ed3bc4e
Add a weak_etag field for use with scheduling.
...
The weak_etag will be assigned from the etag only when
normal changes are made to an event. A subset of the
changes involved in automatic scheduling will not change it.
2010-03-02 14:16:13 +13:00
Andrew McMillan
16f70a9bdb
More work on database patch.
2010-02-28 22:39:42 +13:00
Andrew McMillan
242ebdcf31
Adding tables for holding addressbook data and split out alarms/attendees.
2010-02-28 20:12:40 +13:00
Andrew McMillan
899337a679
Database changes which actually work, for the moment.
2010-02-28 11:35:52 +13:00
Andrew McMillan
429940f4d9
The <allprop> can be at the top level, not within the <prop>.
2010-02-26 13:45:30 +13:00
Andrew McMillan
4f5badd549
Starting to think about tickets for granting permissions.
2010-02-26 13:30:55 +13:00
Andrew McMillan
19199d5f86
Replaced the old get_permissions() call with the new permissions model.
2009-12-21 13:04:25 +13:00
Andrew McMillan
1b1684e10f
Don't have an 'active' column on the principal.
2009-11-22 00:21:10 +13:00
Andrew McMillan
a100244106
Fix database patches so they work.
2009-11-05 17:16:00 +13:00
Andrew McMillan
8938b7d0fd
Add some more fields onto the collections table.
2009-11-05 17:07:55 +13:00
Andrew McMillan
3df6ccc4ba
Getting 'MOVE' working has proven surprisingly complex.
2009-11-04 00:17:10 +13:00
Andrew McMillan
0bd0fbca85
Bugfix database definitions / patches after last change.
2009-10-27 17:31:22 +13:00
Andrew McMillan
10bfc96016
Structure changes for grants on collections.
2009-10-27 09:15:42 +13:00
Andrew McMillan
2ca3ae7d44
Move to new privileges - started now.
2009-10-17 17:59:53 +13:00
Andrew McMillan
8ee00fb91c
Move patches into primary database definitions.
2009-10-16 14:06:56 +13:00
Andrew McMillan
7df7da3132
Fix constraints so DELETE FROM usr; will work.
2008-11-24 09:04:35 +13:00
Andrew McMillan
5f8a8ca4bc
Database changes for next release (unfinished).
2008-10-24 18:46:30 +13:00
Andrew McMillan
41db2b7050
Ensure these patches will work in more obscure situations.
2008-01-27 09:51:47 +13:00
Andrew McMillan
976438db4f
Apply the correct DB revision number.
2008-01-26 22:31:11 +13:00
Andrew McMillan
fe49f7cb9e
Update to 1.2.2 schema version.
2008-01-26 21:57:34 +13:00
Andrew McMillan
4fbb683af5
Move the appuser permission grants out of the database definition
...
so we can support alternative names for the application DB user.
2008-01-24 23:26:42 +13:00
Andrew McMillan
e12139c636
Move the inclusion of the AWL tables out of the database SQL.
2007-11-05 22:56:33 +13:00
Andrew McMillan
0b4e5b9cb5
Rename SQL definition of database.
2007-11-05 22:49:59 +13:00
