• last updated 11 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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
    • +15
    ./sql/oracle/organizations-create.sql
    • -2
    • +12
    ./sql/postgresql/organizations-create.sql
    • -0
    • +41
    ./sql/postgresql/organizations-drop.sql
file status.txt was initially added on branch oacs-5-0.

file organizations-drop.sql was initially added on branch oacs-5-0.

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

    • -0
    • +104
    ./sql/oracle/upgrade/upgrade-0.1d-0.2d.sql
  1. … 6 more files in changeset.
Updated version numbers to upgrade to changes made for Oracle 9i support

  1. … 37 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)

  1. … 275 more files in changeset.
initial revision

    • -0
    • +34
    ./organizations.info
    • -0
    • +54
    ./sql/oracle/organizations-create.sql
    • -0
    • +117
    ./sql/oracle/organizations-plsql-create.sql
    • -0
    • +55
    ./sql/postgresql/organizations-create.sql
    • -0
    • +138
    ./sql/postgresql/organizations-plsql-create.sql