• last updated 4 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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

Forgot to define binary files before importing, so .gifs were messed up.

  1. … 2477 more files in changeset.
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.