307 Commits

Author SHA1 Message Date
Andrew McMillan
5d8f127285 Ensure database creation applies the right permissions. 2008-01-25 08:01:15 +13:00
Andrew McMillan
4d5f010a08 Add options to not apply any patches. 2008-01-25 08:00:47 +13:00
Andrew McMillan
1e319b60c7 Ensure expanded 'A' is unexpanded in the end. 2008-01-25 08:00:15 +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
091f6d5b41 An alternative patch 1.1.12 which will work without exact correspondence
between caldav_data & calendar_item
2008-01-23 20:06:23 +13:00
Andrew McMillan
30e0e47e71 Improve performance of get_permissions when groups are involved. 2008-01-23 10:48:33 +13:00
Andrew McMillan
3dd67ed0b0 Fix typo. 2008-01-21 17:31:26 +13:00
Andrew McMillan
e719a888ab Add a function to assist with renaming users. 2008-01-19 12:26:39 +13:00
Andrew McMillan
193ada1ef5 Remove that commented code now it's in Git. 2007-12-04 12:19:05 +13:00
Andrew McMillan
bbca4ba75f We'll need to let this settle for a version before we make it the
primary key.  Too many programming changes are needed to accept the
risk of rolling it straight out.
2007-12-04 12:17:59 +13:00
Andrew McMillan
bdb1e60cd1 Note that this is an alternate. 2007-12-04 12:16:52 +13:00
Andrew McMillan
186734fea9 Remove unnecessary newline. 2007-12-04 12:16:17 +13:00
Andrew McMillan
c2115a22d8 Minimise output on patch failure where alternatives exist. 2007-12-04 08:46:47 +13:00
Andrew McMillan
91f1d2324c Enhance the database patch script to allow for alternative patches. 2007-12-03 22:28:44 +13:00
Andrew McMillan
2031ba23a3 Patch to apply a numeric primary key to caldav_data / calendar_item
in order to attempt to resolve performance issues in non-POSIX collation.
2007-11-28 23:08:26 +13:00
Andrew McMillan
5b4071f8e4 Added a version of patch 1.1.11 which works for PostgreSQL 8.x 2007-11-27 18:07:18 +13:00
Andrew McMillan
357fcc5cee Fix thinko. 2007-11-05 23:39:29 +13:00
Andrew McMillan
5895e99d72 Attempt to autodiscover the AWL code from reasonable locations. 2007-11-05 23:34:00 +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
Andrew McMillan
b491ee17fd More careful construction of the database, using a DBA user to own it. 2007-11-05 18:25:40 +13:00
Andrew Ruthven
568bd47b9b Modify the correct table. 2007-11-03 21:17:43 +13:00
Andrew Ruthven
78465c2be1 Allow easily removing a user using SQL by adding some cascades.
I've tested the patch this time!
2007-11-03 20:25:19 +13:00
Andrew McMillan
04656674f7 Make puck's patches for PUBLIC events actually work. 2007-10-27 00:11:44 +13:00
Andrew Ruthven
e725590612 Rewrite force events to public logic to be PUBLIC only, not general. 2007-10-26 11:35:19 +13:00
Andrew Ruthven
e0746e058e Allow forcing all events in a collection to a specified class. 2007-10-26 11:05:32 +13:00
Andrew Ruthven
bbcd6a82ac Bugger, fix up the DB patches. 2007-10-26 09:50:45 +13:00
Andrew Ruthven
06431170c8 By default calendar items are PUBLIC. 2007-10-26 09:41:18 +13:00
Andrew McMillan
516daec7b0 Change the default database name. 2007-09-08 14:14:13 +12:00
Andrew McMillan
c175a97a94 Change the tr character match not to use character classes, since the
user might be operating in a non-UTF-8 character space and could
generate a password which can't be inserted.
2007-09-08 14:13:42 +12:00
Andrew McMillan
0d3005a72d Correct dutch name for "Dutch" 2007-08-05 22:50:13 +12:00
Andrew McMillan
78ee778b98 More users, with some more permission relationships. 2007-05-30 11:16:54 +12:00
Andrew McMillan
10716cd412 [performance] Add a primary key to the calendar_item table. 2007-05-28 15:54:00 +12:00
Andrew McMillan
d609d6bfeb Ensure that a perl is not connected when we apply a patch. 2007-05-28 15:53:14 +12:00
Andrew McMillan
4d628b1782 In general tables are named in the singular, so lets be consistent. 2007-05-21 22:14:09 +12:00
Andrew McMillan
3a8d84d3a3 Initial patches for database change to support freebusy tickets. 2007-05-21 19:26:14 +12:00
Dávid Takács
48853d4668 Windows support for database creation by Dávid Takács 2007-05-09 13:19:45 +12:00
Andrew McMillan
8f048389b3 Add hu_HU as a supported locale. 2007-05-08 23:50:47 +12:00
Andrew McMillan
73e7f73f2a Correct backslash replacement in pwgen generated password. 2007-04-17 01:17:55 +12:00
Andrew McMillan
c05a9e7312 Polish locale is now supported. 2007-04-13 18:14:45 +12:00
Andrew McMillan
67a2fc734a Functions under development for parsing RRULE directives directly within
the database.
2007-04-04 21:54:06 +12:00
Andrew McMillan
82fd372c0c Add a function to provide a textual list of relationships for display. 2007-03-19 14:12:37 +12:00
Andrew McMillan
0292764597 Change to work on PostgreSQL 7.4 and 8.0. 2007-03-09 09:25:41 +13:00
Andrew McMillan
76f64d863d Improved layout and comments. 2007-03-08 11:26:25 +13:00
Andrew McMillan
ac49c8c278 Ensure that _some_ password is set. dd /dev/urandom seems to work quite
well, actually.
2007-03-08 08:30:28 +13:00
Andrew McMillan
c89d724058 Add a 'status' column to the calendar_item table which gets the STATUS property. 2007-02-13 11:37:25 +13:00
Andrew McMillan
a972fc8439 Fixed upgrade patch. 2006-12-28 17:01:51 +13:00
Andrew McMillan
7003fe5658 A few tweaks to make things work with the fields we just got rid of. 2006-12-27 21:29:55 +13:00
Andrew McMillan
11f3455e27 Remove the fromgroup / togroup entirely from relationship types and go for
a much simpler model entirely.
2006-12-27 15:20:23 +13:00
Andrew McMillan
7a1b2a0dd0 The prefix_match field and rt_inverse field are removed from relationship_type
because that model was too complex to be useful.  We also explicitly indicate
whether the relationship source or destination are groups separately.
2006-12-27 14:29:19 +13:00