• last updated 17 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
add missing upgrade directory

as it seems, there was never one, therefore there were no sql upgrade scripts performed

    • -0
    • +163
    ./postgresql/upgrade/upgrade-5.10.0d1-5.10.0d2.sql
  1. … 1 more file in changeset.
file upgrade-5.10.0d1-5.10.0d2.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.0d1-5.10.0d2.sql
- update postgres function to modern style plpgsql definitions, avoid backslash escaping

- add missing function_args

    • -60
    • +90
    ./postgresql/acs-reference-create.sql
  1. … 6 more files in changeset.
adding missing variable declaration needed at least for pg 8.2

adding missing variable declaration needed at least for pg 8.2

Added variable declaration which resulted in an installation error on PG 8.2

Correction of name constraint

VS: ----------------------------------------------------------------------

Correction of name constraint

  1. … 2 more files in changeset.
Remerge Timo's changes for tip 42,43, cf tip 53

    • -0
    • +115
    ./oracle/upgrade/upgrade-5.0.2-5.0.2d1.sql
  1. … 95 more files in changeset.
rollback of Timo's name, package_id commit; see TIP 53

    • -115
    • +0
    ./oracle/upgrade/upgrade-5.0.2-5.0.2d1.sql
  1. … 94 more files in changeset.
TIP#42,43: adding package_id and title to acs_objects table

    • -0
    • +115
    ./oracle/upgrade/upgrade-5.0.2-5.0.2d1.sql
  1. … 94 more files in changeset.
Added upgrade to upgrade to changes made for Oracle 9i support

    • -0
    • +149
    ./oracle/upgrade/upgrade-0.2d-0.3d.sql
  1. … 3 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

    • -9
    • +10
    ./postgresql/acs-reference-create.sql
  1. … 42 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. … 52 more files in changeset.
Converted timestamp to timestamp with time zone.

mostly fixing reference data to work with PG ...

  1. … 16 more files in changeset.

More work on acs-references and address-book.

    • -104
    • +86
    ./postgresql/acs-reference-create.sql
    • -29
    • +30
    ./postgresql/acs-reference-drop.sql
  1. … 8 more files in changeset.
Deleted obsolete call to included file. All reference data is in seperate packages now.

Deleted this obsolete included file

    • -16
    • +0
    ./postgresql/acs-reference-data.sql
Got rid of included files as all data is in seperate packages now.

Moved to seperate packages

    • -3154
    • +0
    ./common/us-counties-data.sql
    • -42202
    • +0
    ./common/us-zipcodes-data.sql
  1. … 8 more files in changeset.
moving timezones to a seperate package

    • -40049
    • +0
    ./common/timezone-rules.sql
Initial OpenACS import

    • -0
    • +96
    ./postgresql/country.sql
    • -0
    • +87
    ./postgresql/currency.sql
    • -0
    • +44
    ./postgresql/language.sql
    • -0
    • +43
    ./postgresql/s-and-p.sql
    • -0
    • +91
    ./postgresql/us-counties.sql
    • -0
    • +40
    ./postgresql/us-states.sql
    • -0
    • +68
    ./postgresql/us-zipcodes.sql
Another PG type fix, and added overloaded new.

    • -3
    • +35
    ./postgresql/acs-reference-create.sql
Worked on permissions syntax

    • -14
    • +17
    ./postgresql/acs-reference-create.sql
Pulled inserts into own files.

Pulled inserts out of sql files for commonality.

    • -0
    • +259
    ./common/country-data.sql
    • -0
    • +205
    ./common/currency-data.sql
    • -0
    • +146
    ./common/language-data.sql
Moved sql to data dependent dirs

Renamed data to -data and moved sql to database dependent directories.