• last updated 20 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Delete from duplicated notification request entries before trying to add the unique constraint to deal with broken data

    • -0
    • +21
    ./postgresql/upgrade/upgrade-5.10.0d2-5.10.0d3.sql
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

    • -8
    • +10
    ./oracle/notifications-core-create.sql
    • -0
    • +4
    ./oracle/upgrade/upgrade-5.10.0d2-5.10.0d3.sql
    • -8
    • +10
    ./postgresql/notifications-core-create.sql
    • -0
    • +4
    ./postgresql/upgrade/upgrade-5.10.0d2-5.10.0d3.sql
  1. … 1 more file in changeset.
merged changes from the oacs-5-9 branch and resolved conflicts

    • -2
    • +2
    ./oracle/notifications-core-create.sql
  1. … 7832 more files in changeset.
Fix spelling errors

    • -2
    • +2
    ./oracle/notifications-core-create.sql
  1. … 6 more files in changeset.
Merging back to HEAD branch oacs-5-8 (using tag vg-merge-oacs-5-8-from-20141027).

    • -25
    • +28
    ./postgresql/notifications-package-create.sql
  1. … 2546 more files in changeset.
file upgrade-5.8.1d3-5.8.1d4.sql was initially added on branch oacs-5-8.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.8.1d3-5.8.1d4.sql
  1. … 1 more file in changeset.
- add missing function args

    • -25
    • +28
    ./postgresql/notifications-package-create.sql
  1. … 7 more files in changeset.
- fix $$ quoting in upgrade scripts

    • -28
    • +15
    ./postgresql/upgrade/upgrade-0.3d-0.4d.sql
    • -30
    • +15
    ./postgresql/upgrade/upgrade-4.6.1-4.6.2.sql
  1. … 1 more file in changeset.
- update postgres function to modern style plpgsql definitions using dollar quoting

    • -53
    • +29
    ./postgresql/notifications-package-create.sql
    • -18
    • +17
    ./postgresql/notifications-replies-package-create.sql
- update postgres function to modern style plpgsql definitions, avoid backslash escaping

- add missing function_args

    • -9
    • +9
    ./postgresql/notifications-core-drop.sql
    • -96
    • +153
    ./postgresql/notifications-package-create.sql
    • -5
    • +5
    ./postgresql/notifications-replies-drop.sql
    • -3
    • +5
    ./postgresql/notifications-replies-package-create.sql
    • -7
    • +16
    ./postgresql/upgrade/upgrade-0.1d-0.2d.sql
    • -1
    • +2
    ./postgresql/upgrade/upgrade-0.3d-0.4d.sql
    • -20
    • +26
    ./postgresql/upgrade/upgrade-4.6.2-4.6.4.sql
    • -8
    • +17
    ./postgresql/upgrade/upgrade-5.0.0a5-5.0.0a6.sql
    • -7
    • +13
    ./postgresql/upgrade/upgrade-5.0.0b4-5.1.0d2.sql
    • -9
    • +18
    ./postgresql/upgrade/upgrade-5.1.0d2-5.1.0d3.sql
    • -21
    • +27
    ./postgresql/upgrade/upgrade-5.4.0d2-5.4.0d3.sql
  1. … 7 more files in changeset.
Merged from 5.4.2

    • -1
    • +1
    ./oracle/notifications-replies-extra-create.sql
    • -40
    • +40
    ./postgresql/notifications-core-create.sql
    • -1
    • +1
    ./postgresql/notifications-replies-extra-create.sql
  1. … 281 more files in changeset.
Fixed public procs without documentation blocks which caused automated tests

to fail. I even tried to write meaningful documentation in some cases.

Fixed constraint names that also caused automated test failures FOR PG ONLY.

Someone who used Oracle can fix the Oracle ones if they want.

    • -1
    • +1
    ./oracle/notifications-replies-extra-create.sql
    • -40
    • +40
    ./postgresql/notifications-core-create.sql
    • -1
    • +1
    ./postgresql/notifications-replies-extra-create.sql
  1. … 3 more files in changeset.
It's "sysdate", not "sysdate()", folks :)

    • -0
    • +1
    ./oracle/notifications-package-create.sql
  1. … 1 more file in changeset.
Adding support for oracle for the upgrade to 5.4.0d3 which allows for file attachments

    • -2
    • +3
    ./oracle/notifications-core-create.sql
    • -2
    • +3
    ./oracle/notifications-package-create.sql
    • -0
    • +56
    ./oracle/upgrade/upgrade-5.4.0d2-5.4.0d3.sql
Adding support for file attachments via file_ids in the notifications table, includes sql upgrade scripts and bumps the version to 5.4.0d3

    • -2
    • +3
    ./postgresql/notifications-core-create.sql
    • -8
    • +10
    ./postgresql/notifications-package-create.sql
    • -0
    • +49
    ./postgresql/upgrade/upgrade-5.4.0d2-5.4.0d3.sql
  1. … 8 more files in changeset.
First shot at merging oacs-5-2 apps used in .LRN to HEAD.

    • -11
    • +11
    ./postgresql/notifications-core-create.sql
    • -2
    • +2
    ./postgresql/notifications-replies-create.sql
  1. … 2477 more files in changeset.
reverting broken Malte's i18n patch (I think these strings should be translated)

I18N of notifications

    • -11
    • +11
    ./postgresql/notifications-core-create.sql
    • -2
    • +2
    ./postgresql/notifications-replies-create.sql
  1. … 2 more files in changeset.
commit to HEAD of merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040724 and jcd-merge-5-1-20050111

  1. … 2275 more files in changeset.
Applying patch 587 for bug 1973: on delete cascade for

notifications/notification_requests acs_objects

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

    • -0
    • +2
    ./oracle/notifications-core-create.sql
    • -0
    • +115
    ./oracle/upgrade/upgrade-5.0.0b4-5.1.0d2.sql
    • -0
    • +2
    ./postgresql/notifications-core-create.sql
    • -0
    • +18
    ./postgresql/upgrade/upgrade-5.0.0b4-5.1.0d2.sql
    • -0
    • +53
    ./postgresql/upgrade/upgrade-5.1.0d2-5.1.0d3.sql
  1. … 133 more files in changeset.
Forgot upgade scripts for previous commit, which added new function delete_all_for_user

    • -0
    • +115
    ./oracle/upgrade/upgrade-5.0.0b4-5.1.0d2.sql
    • -0
    • +18
    ./postgresql/upgrade/upgrade-5.0.0b4-5.1.0d2.sql
file upgrade-5.0.0b4-5.1.0d2.sql was initially added on branch oacs-5-1.

    • -0
    • +0
    ./oracle/upgrade/upgrade-5.0.0b4-5.1.0d2.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.0.0b4-5.1.0d2.sql
adds on delete cascade to fk constraints for notifications and notification_requests

    • -1
    • +3
    ./oracle/notifications-core-create.sql
    • -1
    • +3
    ./postgresql/notifications-core-create.sql
adds on delete cascade to fk constraints of notifications and notification_requests

    • -0
    • +53
    ./postgresql/upgrade/upgrade-5.1.0d2-5.1.0d3.sql
file upgrade-5.1.0d2-5.1.0d3.sql was initially added on branch oacs-5-1.

    • -0
    • +0
    ./oracle/upgrade/upgrade-5.1.0d2-5.1.0d3.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.1.0d2-5.1.0d3.sql
merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040517 and jcd-merge-5-1-20040628 to HEAD

    • -0
    • +19
    ./oracle/notifications-package-create.sql
    • -0
    • +19
    ./postgresql/notifications-package-create.sql
  1. … 686 more files in changeset.
fix from Sloan: proc to delete all notifications for a user, which will be used later when we have callbacks to call things like this when we delete a user from core

    • -0
    • +19
    ./oracle/notifications-package-create.sql
    • -0
    • +19
    ./postgresql/notifications-package-create.sql
  1. … 3 more files in changeset.
Notification Replies where not dropped.

    • -0
    • +16
    ./postgresql/notifications-replies-drop.sql
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).

    • -2
    • +30
    ./postgresql/upgrade/upgrade-5.0.0a5-5.0.0a6.sql
  1. … 292 more files in changeset.