• last updated 23 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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
initial OpenACS revision

    • -0
    • +335
    ./sql/common/country.sql
    • -0
    • +284
    ./sql/common/currency.sql
    • -0
    • +188
    ./sql/common/language.sql
    • -0
    • +123
    ./sql/common/s-and-p-data.sql
    • -0
    • +535
    ./sql/common/timezone-data.sql
    • -0
    • +25
    ./sql/common/timezone-drop.sql
    • -0
    • +40049
    ./sql/common/timezone-rules.sql
    • -0
    • +512
    ./sql/common/timezones.sql
    • -0
    • +3154
    ./sql/common/us-counties-data.sql
    • -0
    • +99
    ./sql/common/us-counties.sql
    • -0
    • +122
    ./sql/common/us-states.sql
    • -0
    • +42205
    ./sql/common/us-zipcodes-data.sql
    • -0
    • +76
    ./sql/common/us-zipcodes.sql
    • -0
    • +219
    ./sql/postgresql/acs-reference-create.sql
    • -0
    • +16
    ./sql/postgresql/acs-reference-data.sql
    • -0
    • +41
    ./sql/postgresql/acs-reference-drop.sql