OpenACS / openacs-4 / packages / notifications / sql / postgresql

upgrade

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 12
Last Commit: 16:32
Commits this week: 0
Total Lines of Code (LoC): 508
Net change in LoC this week: 0

Commit Activity

Commits By Day In Week
52 week commits volume
Commits By Day In Week
Commits by day
Commits By Day In Week
Commits by hour
Commits By Hour In Day
Commit calendar
 

Most active committers (90 days)

loading
loading
  • last updated 6 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Friday 06 Nov 2020
4:52 pm

antoniop

Add missing semicolon

Options
    • -1
    • +1
    ./upgrade-5.10.0d6-5.10.0d7.sql
4:51 pm

antoniop

Solve a potential issue when one would cleanup "dynamic" notification requests: this was done directly on the table and could therefore leave dangling acs_objects around

- cleanup all acs_objects of type 'notification_request' that do not have a corresponding entry in the table (~35000 downstream)

- embed logic of delete_dynamic_requests query inside select_invalid_request_ids query, as there the deletion is done properly

Options
    • -0
    • +8
    ./upgrade-5.10.0d6-5.10.0d7.sql
  2. … 3 more files in changeset.
4:51 pm

antoniop

file upgrade-5.10.0d6-5.10.0d7.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./upgrade-5.10.0d6-5.10.0d7.sql
Sunday 12 Apr 2020
10:57 am

gustafn

Added index on foreign key columns

Options
    • -0
    • +5
    ./upgrade-5.10.0d4-5.10.0d5.sql
  2. … 4 more files in changeset.
10:57 am

gustafn

file upgrade-5.10.0d4-5.10.0d5.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./upgrade-5.10.0d4-5.10.0d5.sql
  2. … 1 more file in changeset.
Friday 02 Nov 2018
10:37 am

gustafn

Delete from duplicated notification request entries before trying to add the unique constraint to deal with broken data

Options
    • -0
    • +21
    ./upgrade-5.10.0d2-5.10.0d3.sql
Wednesday 03 Oct 2018
11:11 am

gustafn

Address issue #3358: avoid duplicate entries in notification_requests via data model, in case the check in notification::request::new for existing requests with the same type_id, object_id and user_id is somehow bypassed

Options
    • -0
    • +4
    ./upgrade-5.10.0d2-5.10.0d3.sql
  2. … 4 more files in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

merged changes from the oacs-5-9 branch and resolved conflicts

Options
    • -2
    • +2
    ./upgrade-5.0.0a5-5.0.0a6.sql
  2. … 7834 more files in changeset.
Saturday 22 Apr 2017
1:58 pm

gustafn

Fix spelling errors

Options
    • -2
    • +2
    ./upgrade-5.0.0a5-5.0.0a6.sql
  2. … 8 more files in changeset.
Monday 27 Oct 2014
5:38 pm

victorg

Merging back to HEAD branch oacs-5-8 (using tag vg-merge-oacs-5-8-from-20141027).

Options
    • -0
    • +1
    ./upgrade-5.8.1d3-5.8.1d4.sql
  2. … 2547 more files in changeset.
Saturday 30 Aug 2014
6:47 pm

gustafn

file upgrade-5.8.1d3-5.8.1d4.sql was initially added on branch oacs-5-8.

Options
    • -0
    • +0
    ./upgrade-5.8.1d3-5.8.1d4.sql
  2. … 1 more file in changeset.
6:43 pm

gustafn

- add missing function args

Options
    • -0
    • +1
    ./upgrade-5.8.1d3-5.8.1d4.sql
  2. … 8 more files in changeset.
Sunday 31 Mar 2013
6:31 pm

gustafn

- fix $$ quoting in upgrade scripts

Options
    • -28
    • +15
    ./upgrade-0.3d-0.4d.sql
    • -30
    • +15
    ./upgrade-4.6.1-4.6.2.sql
  3. … 1 more file in changeset.
Saturday 30 Mar 2013
7:50 pm

gustafn

- update postgres function to modern style plpgsql definitions, avoid backslash escaping

- add missing function_args

Options
    • -7
    • +16
    ./upgrade-0.1d-0.2d.sql
    • -1
    • +2
    ./upgrade-0.3d-0.4d.sql
    • -7
    • +16
    ./upgrade-0.4d-4.6.1.sql
    • -1
    • +2
    ./upgrade-4.6.1-4.6.2.sql
    • -20
    • +26
    ./upgrade-4.6.2-4.6.4.sql
    • -8
    • +17
    ./upgrade-5.0.0a5-5.0.0a6.sql
    • -7
    • +13
    ./upgrade-5.0.0b4-5.1.0d2.sql
    • -9
    • +18
    ./upgrade-5.1.0d2-5.1.0d3.sql
    • -21
    • +27
    ./upgrade-5.4.0d2-5.4.0d3.sql
  10. … 11 more files in changeset.
Wednesday 27 Jun 2007
8:54 pm

matthewg

Adding support for file attachments via file_ids in the notifications table, includes sql upgrade scripts and bumps the version to 5.4.0d3

Options
    • -0
    • +49
    ./upgrade-5.4.0d2-5.4.0d3.sql
  2. … 10 more files in changeset.
Saturday 24 Jul 2004
10:33 am

jeffd

merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040712 and jcd-merge-5-1-20040724 to HEAD

Options
    • -0
    • +18
    ./upgrade-5.0.0b4-5.1.0d2.sql
    • -0
    • +53
    ./upgrade-5.1.0d2-5.1.0d3.sql
  3. … 137 more files in changeset.
Tuesday 20 Jul 2004
4:37 pm

janine

Forgot upgade scripts for previous commit, which added new function delete_all_for_user

Options
    • -0
    • +18
    ./upgrade-5.0.0b4-5.1.0d2.sql
  2. … 1 more file in changeset.
4:37 pm

janine

file upgrade-5.0.0b4-5.1.0d2.sql was initially added on branch oacs-5-1.

Options
    • -0
    • +0
    ./upgrade-5.0.0b4-5.1.0d2.sql
  2. … 1 more file in changeset.
Thursday 15 Jul 2004
3:00 am

skaufman

adds on delete cascade to fk constraints of notifications and notification_requests

Options
    • -0
    • +53
    ./upgrade-5.1.0d2-5.1.0d3.sql
3:00 am

skaufman

file upgrade-5.1.0d2-5.1.0d3.sql was initially added on branch oacs-5-1.

Options
    • -0
    • +0
    ./upgrade-5.1.0d2-5.1.0d3.sql
  2. … 1 more file in changeset.
Thursday 26 Feb 2004
4:28 pm

jeffd

merge of all changes on oacs-5-0 branch between tag openacs-5-0-0-final and jcd-merge-pre503 (except those in lars-blogger).

Options
    • -7
    • +7
    ./upgrade-4.6.4-5.0d1.sql
    • -2
    • +30
    ./upgrade-5.0.0a5-5.0.0a6.sql
  3. … 292 more files in changeset.
Wednesday 04 Feb 2004
11:57 am

lars

Implemented a safe way to delete constraints, as these constraints didn't exist. It's most likely got to do with the PG upgrade from 7.2 to 7.3 not recording constraints properly. This is a workaround, not a fix. See bug #1294.

Options
    • -2
    • +30
    ./upgrade-5.0.0a5-5.0.0a6.sql
11:53 am

lars

Untabify

Options
    • -7
    • +7
    ./upgrade-4.6.4-5.0d1.sql
Thursday 11 Dec 2003
10:39 pm

jeffd

merge of changes on oacs-5-0 branch to oacs-5-0-0b4 tag

Options
    • -3
    • +4
    ./upgrade-4.6.4-5.0d1.sql
    • -0
    • +15
    ./upgrade-5.0.0a5-5.0.0a6.sql
  3. … 597 more files in changeset.
Thursday 04 Dec 2003
8:44 am

jeffd

fix inconsistency between notifications-replies-extra-create and upgrade scripts, hopefully this finally fixed 1231

Options
    • -3
    • +4
    ./upgrade-4.6.4-5.0d1.sql
  2. … 2 more files in changeset.
Tuesday 02 Dec 2003
11:45 am

peterm

no need to drop table if you are just changing a constraint.

Options
    • -42
    • +11
    ./upgrade-5.0.0a5-5.0.0a6.sql
  2. … 1 more file in changeset.
Friday 28 Nov 2003
3:52 pm

jeffd

the upgrade failed because notification_user_map constraint notif_user_map_notif_id_fk needed the pk on notifications_bak, now drops it and recreates it after the table is reloaded

Options
    • -0
    • +4
    ./upgrade-5.0.0a5-5.0.0a6.sql
Monday 24 Nov 2003
7:51 pm

peterm

making notifications cascade when acs objects are deleted, see bug 260

Options
    • -0
    • +42
    ./upgrade-5.0.0a5-5.0.0a6.sql
  2. … 3 more files in changeset.
7:51 pm

peterm

file upgrade-5.0.0a5-5.0.0a6.sql was initially added on branch oacs-5-0.

Options
    • -0
    • +0
    ./upgrade-5.0.0a5-5.0.0a6.sql
  2. … 1 more file in changeset.
Thursday 06 Nov 2003
8:23 pm

matk

o notifications fixes have been completed.

o needed fixes in lt_format_time and html-email-procs.

o Oracle bits /should/ work but are untested at this time.

Options
    • -0
    • +8
    ./upgrade-4.6.4-5.0d1.sql
  2. … 5 more files in changeset.