• last updated 4 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
- drop unused sequence

- use plain sequence for db_nextval

    • -0
    • +32
    ./postgresql/upgrade/upgrade-5.2d6-5.2d7.sql
  1. … 1 more file in changeset.
- drop view explicitly and create it in a separate step

- Remove dependencies from acs_objects.tree_sortkey and

acs_objects.max_child_sortkey, which are not needed (just part of

the PostgreSql datamodel and not in Oracle) and which will be gone

in OpenACS 5.9

    • -0
    • +28
    ./postgresql/upgrade/upgrade-5.2d3-5.2d4.sql
  1. … 1 more file in changeset.
Adding missing and.

- lifting length contraints that were necessary at openacs.org

    • -0
    • +8
    ./postgresql/upgrade/upgrade-5.2d1-5.2d2.sql
merging all changes from oacs-5-2 back to HEAD.

  1. … 50 more files in changeset.
New datamodel which resulted from fixing bug #2673 with a 5.1 upgrade

Argh ... forgot to edit this file for 5.1 to fix bug #2673

Upgrade fix for bug #2673

    • -0
    • +138
    ./postgresql/upgrade/upgrade-5.1d1-5.1d2.sql
file upgrade-5.1d1-5.1d2.sql was initially added on branch oacs-5-1.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.1d1-5.1d2.sql
Fixing bug #2673, by rewriting views to not use the cr-generated input view.

  1. … 1 more file in changeset.
Minor whacks to make this work with Timo's changes to core - untested under

Oracle at the moment ...

  1. … 2 more files in changeset.
various bug fixes for package_id, title addition to acs_objects

  1. … 12 more files in changeset.
Added upgrade to upgrade to changes made for Oracle 9i support

    • -0
    • +152
    ./oracle/upgrade/upgrade-4.1-5.0d1.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)

  1. … 274 more files in changeset.
merge of 4.6.3b1 to HEAD

  1. … 33 more files in changeset.
I've changed "timestamp" to "timestamptz" and have begun fixing some

code that used to be legal but as of PG 7.3 is not. You can no longer

subtract an integer from a timestamp but must cast to date, "timestamp"

disappeared (must use "interval" now), "datetime" disappeared ("timestamptz"),

and suchwhat.

Not done but closer than it was before ...

  1. … 37 more files in changeset.
merge bartt PG 7.3 fixes from HEAD

  1. … 54 more files in changeset.
Patches to make OpenACS PG 7.3 compatible.

  1. … 54 more files in changeset.

1) Cleaned old oracle cruft from postgresql files

2) Fixed bugs in metadata presentation

    • -131
    • +44
    ./postgresql/download-create.sql
    • -123
    • +9
    ./postgresql/download-packages.sql
  1. … 3 more files in changeset.
Cleaned datamodel (number->numeric)

temporarily removed dependencies on acs-messaging

  1. … 3 more files in changeset.
fixed oracle datamodel scripts

minor cleanup

  1. … 3 more files in changeset.
added file_size to pg datamodel, pg queries. Moved calc (size = bytes/1024) from tcl to sql

  1. … 14 more files in changeset.
fixed sequences. Updated functions. Improved drop script

changed to consistent sequence names

more porting to postgres

ported the datamodel

    • -0
    • +418
    ./postgresql/download-create.sql
    • -0
    • +166
    ./postgresql/download-drop.sql
    • -0
    • +255
    ./postgresql/download-packages.sql
Initial revision

    • -0
    • +280
    ./oracle/download-create.sql
    • -0
    • +97
    ./oracle/download-drop.sql
    • -0
    • +152
    ./oracle/download-packages.sql
  1. … 2477 more files in changeset.