• last updated 34 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Add missing semicolon

    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.10.0d6-5.10.0d7.sql
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

    • -0
    • +8
    ./postgresql/upgrade/upgrade-5.10.0d6-5.10.0d7.sql
  1. … 3 more files in changeset.
file upgrade-5.10.0d6-5.10.0d7.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.0d6-5.10.0d7.sql
Added index on foreign key columns

    • -2
    • +3
    ./oracle/notifications-core-create.sql
    • -1
    • +3
    ./postgresql/notifications-core-create.sql
    • -0
    • +5
    ./postgresql/upgrade/upgrade-5.10.0d4-5.10.0d5.sql
  1. … 1 more file in changeset.
file upgrade-5.10.0d4-5.10.0d5.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./oracle/upgrade/upgrade-5.10.0d4-5.10.0d5.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.0d4-5.10.0d5.sql
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