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

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
    ./oracle/s-and-p.sql
updated to reflect removal of timezone data temporarily

Initial Postgres port. Rough only.

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

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

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

    • -0
    • +218
    ./oracle/acs-reference-create.sql
    • -0
    • +16
    ./oracle/acs-reference-data.sql
    • -0
    • +36
    ./oracle/acs-reference-drop.sql
    • -0
    • +335
    ./oracle/country.sql
    • -0
    • +284
    ./oracle/currency.sql
    • -0
    • +189
    ./oracle/language.sql
    • -0
    • +124
    ./oracle/s-and-p-data.sql
    • -0
    • +535
    ./oracle/timezone-data.sql
    • -0
    • +25
    ./oracle/timezone-drop.sql
    • -0
    • +40049
    ./oracle/timezone-rules.sql
    • -0
    • +512
    ./oracle/timezones.sql
    • -0
    • +3154
    ./oracle/us-counties-data.sql
    • -0
    • +99
    ./oracle/us-counties.sql
    • -0
    • +123
    ./oracle/us-states.sql
    • -0
    • +42205
    ./oracle/us-zipcodes-data.sql
  1. … 4 more files in changeset.