• last updated 23 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates

1. Made it possible to upgrade from acs-kernel 4.6.1 to acs-kernel 4.6.2

by using the APM rather than running the upgrade script by hand from

PSQL or SQL*Plus.

2. Changed a bunch of package .info files to depend on acs-kernel 4.6.2

to force the APM to upgrade acs-kernel (and therefore the APM datamodel)

before anything else. No guarantee on this though since not all

packages properly define their dependence on the kernel, it appears.

3. Whacked the release notes to suggest people use the APM to upgrade

acs-kernel first, other package later, just for safety's sake.

4. Fixed goof-up in acs-subsite I accidently introduced.

  1. … 35 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 ...

    • -9
    • +9
    ./sql/postgresql/acs-reference-create.sql
    • -4
    • +4
    ./sql/postgresql/acs-reference-drop.sql
  1. … 52 more files in changeset.
Converted timestamp to timestamp with time zone.

    • -2
    • +3
    ./sql/postgresql/acs-reference-create.sql
Added new files to .info files

  1. … 38 more files in changeset.
fix some broken links

  1. … 23 more files in changeset.
changed some links and minor formatting

initial import

    • -0
    • +23
    ./www/table-detail.tcl
    • -0
    • +36
    ./www/view-one-reference.adp
    • -0
    • +37
    ./www/view-one-reference.tcl

mostly fixing reference data to work with PG ...

    • -8
    • +7
    ./sql/postgresql/acs-reference-create.sql
  1. … 16 more files in changeset.

More work on acs-references and address-book.

    • -104
    • +86
    ./sql/postgresql/acs-reference-create.sql
    • -29
    • +30
    ./sql/postgresql/acs-reference-drop.sql
    • -1
    • +1
    ./www/reference-data-list-postgresql.xql
  1. … 6 more files in changeset.
initial import

    • -0
    • +15
    ./tcl/acs-reference-procs.tcl
Initial import

    • -0
    • +25
    ./www/reference-data-list-oracle.xql
    • -0
    • +25
    ./www/reference-data-list-postgresql.xql
    • -0
    • +20
    ./www/reference-data-list.adp
    • -0
    • +25
    ./www/reference-data-list.tcl
Initial Import

updated files

Deleted obsolete call to included file. All reference data is in seperate packages now.

Deleted this obsolete included file

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

    • -4
    • +1
    ./sql/postgresql/acs-reference-create.sql
Moved to seperate packages

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

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

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

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

    • -14
    • +17
    ./sql/postgresql/acs-reference-create.sql
Initial revision for OpenACS.

    • -0
    • +62
    ./acs-reference.info
Pulled inserts into own files.

Pulled inserts out of sql files for commonality.

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

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

Major change.

I put all database dependent parts in their directories and kept the data only in common.

This is needed for the database independence and pl(pg)sql differences.

    • -0
    • +47
    ./sql/oracle/s-and-p.sql
updated to reflect removal of timezone data temporarily

Initial Postgres port. Rough only.

    • -150
    • +122
    ./sql/postgresql/acs-reference-create.sql
deleted for OpenACS. All files put in common

    • -40049
    • +0
    ./sql/oracle/timezone-rules.sql
    • -3154
    • +0
    ./sql/oracle/us-counties-data.sql
    • -42205
    • +0
    ./sql/oracle/us-zipcodes-data.sql