• last updated 16 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Fix typos

  1. … 21 more files in changeset.
Organization Name should not be unique. Does not make sense, as you can have multiple subsidies sharing the same name

Make the client_id unique and therefore a unique customer side identifier for an organization

Added client_id as a Human readable identifier for an organization. This is reused by contacts.

    • -1
    • +4
    ./postgresql/organizations-plsql-create.sql
    • -0
    • +1
    ./postgresql/upgrade/upgrade-0.5d4-0.5d5.sql
    • -0
    • +2
    ./postgresql/upgrade/upgrade-0.5d5-0.5d6.sql
dropped unique constraint on organization-name

    • -0
    • +1
    ./postgresql/upgrade/upgrade-0.5d3-0.5d4.sql
  1. … 1 more file in changeset.
Added relation procs

    • -1
    • +54
    ./postgresql/organizations-plsql-create.sql
  1. … 1 more file in changeset.
Merge all code to oacs-5-1 branch from HEAD. Further work will be done on

oacs-5-1 branch.

    • -3
    • +3
    ./postgresql/organizations-plsql-create.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-0.3d-0.4d.sql
  1. … 3 more files in changeset.
raise statement said organization rather than p_organization in organization__set

    • -2
    • +2
    ./postgresql/organizations-plsql-create.sql
    • -0
    • +28
    ./postgresql/upgrade/upgrade-0.5d1-0.5d2.sql
  1. … 1 more file in changeset.
Initial values were added in with the wrong sequence.

Minor change to the __name function. On my installation, this seems to

prevent a bug that occurs when accessing the __name function (which

happens most notably on the admin's user view page).

    • -2
    • +2
    ./postgresql/organizations-plsql-create.sql
    • -0
    • +22
    ./postgresql/upgrade/upgrade-0.3d-0.4d.sql
  1. … 1 more file in changeset.
fixed organization__name

    • -2
    • +2
    ./postgresql/organizations-plsql-create.sql
merge of changes on oacs-5-0 branch to oacs-5-0-0b4 tag

    • -1
    • +10
    ./oracle/organizations-plsql-create.sql
    • -2
    • +12
    ./postgresql/organizations-create.sql
    • -0
    • +41
    ./postgresql/organizations-drop.sql
    • -27
    • +83
    ./postgresql/organizations-plsql-create.sql
  1. … 593 more files in changeset.
Postgres: Adds drop scripts for Postgres, support for multiple

organization types, adds in __name function, fixes a few bugs. Oracle:

added in comments that it is now out of sync, skeleton for drop

script.

    • -1
    • +10
    ./oracle/organizations-plsql-create.sql
    • -2
    • +12
    ./postgresql/organizations-create.sql
    • -0
    • +41
    ./postgresql/organizations-drop.sql
    • -27
    • +83
    ./postgresql/organizations-plsql-create.sql
  1. … 1 more file in changeset.
file organizations-drop.sql was initially added on branch oacs-5-0.

    • -0
    • +0
    ./oracle/organizations-drop.sql
    • -0
    • +0
    ./postgresql/organizations-drop.sql
Added upgrade to upgrade to changes made for Oracle 9i support

    • -0
    • +104
    ./oracle/upgrade/upgrade-0.1d-0.2d.sql
  1. … 6 more files in changeset.
Oracle9i porting changes

- Changed procedure names from delete to del

- Changed view declaration to use actual column names

- Changed "rel_constraints_violated_one" and "rel_constraints_violated_two"

(http://openacs.org/forums/message-view?message_id=81045)

    • -2
    • +2
    ./oracle/organizations-plsql-create.sql
  1. … 275 more files in changeset.
initial revision

    • -0
    • +54
    ./oracle/organizations-create.sql
    • -0
    • +117
    ./oracle/organizations-plsql-create.sql
    • -0
    • +55
    ./postgresql/organizations-create.sql
    • -0
    • +138
    ./postgresql/organizations-plsql-create.sql
  1. … 1 more file in changeset.