95 Commits

Author SHA1 Message Date
Florian Schlichting
0a6d34a929 make db upgrade work
to use this branch:
===================

- git co master
- ./run_regression -> abort during tests
- git co multiple_email
- ./dba/update-davical-database --dbname=regression
2021-02-05 16:20:00 +08:00
Andrew Ruthven
ee8a751add WIP: Multiple emails for principles 2021-02-05 14:52:00 +08: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
Andrew McMillan
0cda2cb469 [Unfinished] Starting to change permissions. 2009-10-11 14:58:35 -07:00
Andrew McMillan
7df7da3132 Fix constraints so DELETE FROM usr; will work. 2008-11-24 09:04:35 +13:00
Andrew McMillan
0616796ae9 I screwed up. DAViCal 0.9.6, .1 & .2 all went out with db version 1.2.2
when they were in fact 1.2.4.  This patch figures out the difference.
2008-11-22 22:11:44 +13:00