Andrew Ruthven
1ca8284bdc
Add ROOM as a principal type
...
This hopefully resolves #282 .
2024-01-21 19:12:42 +13:00
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
8fbab49f0d
Create unique constraints for tmp_password and role_member.
2023-02-15 07:42:34 +00: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
8f3175248a
A corrected change to fix the case of the language name everywhere.
2013-03-06 23:56:40 +13:00
Andrew McMillan
5104ca25a4
Provide an alternative 1.2.10 with the check_db_revision() function fixed.
2011-09-20 08:55:26 +12:00
Andrew McMillan
cdc23ea732
Add etag to timezone table.
2011-09-19 08:42:28 +12:00
Andrew McMillan
f9ad324ba1
Adjustments to timezones representation in the database to support timezone protocol.
2011-09-17 23:40:04 +12:00
Andrew McMillan
05badd4d3a
New SQL patch file, and fix comment in the last one also.
2011-08-25 15:05:28 +12:00
Andrew McMillan
32a747da8e
Fix privilege_to_bits function to set 'all' correctly & work with recent postgres
2010-10-09 08:54:51 -04: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
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
081a47f7ee
Kill the schedule-in/out box on upgrade so they are recreated.
2009-12-21 22:32:27 +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
4786c5869e
Correct for active column removed from principal.
2009-12-04 22:55:03 +13:00
Andrew McMillan
9c4aeb2543
Fix conversion of Resource users.
2009-11-22 22:31:23 +13:00
Andrew McMillan
1b1684e10f
Don't have an 'active' column on the principal.
2009-11-22 00:21:10 +13:00
Andrew McMillan
c4a4ea5481
Better not to aggregate the privileges in this function.
2009-11-21 21:56:34 +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
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
Wolfgang Herget
ba4792e38d
fixed 1.2.6 patch not applying on pgsql 8.1
2009-10-22 20:25:09 +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
7926b85147
Additional columns on collection for CardDAV addressbook indication
...
and more general resource types.
2009-10-15 23:07:09 +13:00
Andrew McMillan
24a8971080
Initial support for draft-daboo-webdav-sync-01
2009-10-13 21:29:40 +13:00
Andrew McMillan
b66dda9922
Start of support for sync-collection report for webdav-sync extension.
2009-10-11 14:59:28 -07:00
