OpenACS / openacs-4 / packages / ref-us-zipcodes

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 5
Last Commit: 05 Apr
Commits this week: 0
Total Lines of Code (LoC): 108,897
Net change in LoC this week: 0

Commit Activity

Commits By Day In Week
52 week commits volume
Commits By Day In Week
Commits by day
Commits By Day In Week
Commits by hour
Commits By Hour In Day
Commit calendar
 

Most active committers (90 days)

loading
loading
  • last updated 9 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Thursday 28 Oct 2004
9:08 pm

torbenb

updated missing data file using old data in cvs and sourcing the postgres upgrade sql file according to bug 2142

Options
    • -0
    • +42192
    ./common/us-zipcodes.dat
Wednesday 05 Nov 2003
9:34 pm

jeffd

changed the \copy commands to use the 7.2 format for psql as it is supported in 7.2 and 7.3

Options
    • -1
    • +2
    ./postgresql/00-us-zipcodes.ctl
  2. … 7 more files in changeset.
Friday 31 Oct 2003
5:11 pm

jeffd

switch to using \\copy rather than copy since the backend typically

is not able to read the dat file because of permissions (or if it is

on a remote machine the file typically will not even exist).

bug #1033

Options
    • -3
    • +1
    ./postgresql/00-us-zipcodes.ctl
  2. … 8 more files in changeset.
Friday 03 Oct 2003
12:11 pm

jeffd

allow bulk loading with 7.2

Options
    • -1
    • +3
    ./postgresql/00-us-zipcodes.ctl
  2. … 6 more files in changeset.
Tuesday 30 Sep 2003
2:10 pm

mohanp

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)

Options
    • -2
    • +2
    ./oracle/ref-us-zipcodes-drop.sql
  2. … 275 more files in changeset.
Friday 26 Sep 2003
2:10 am

jong

added missing acs-reference update info

Options
    • -0
    • +11
    ./oracle/upgrade/ref-us-zipcodes-data-0.1d-2.0.sql
    • -0
    • +10
    ./postgresql/upgrade/ref-us-zipcodes-data-0.1d-2.0.sql
1:52 am

jong

updated lat/long

Options
    • -0
    • +66466
    ./common/upgrade/ref-us-zipcodes-data-0.1d-2.0.sql
    • -1
    • +7
    ./oracle/ref-us-zipcodes-create.sql
    • -0
    • +2
    ./oracle/upgrade/ref-us-zipcodes-data-0.1d-2.0.sql
    • -1
    • +6
    ./postgresql/ref-us-zipcodes-create.sql
    • -0
    • +5
    ./postgresql/upgrade/ref-us-zipcodes-data-0.1d-2.0.sql
1:51 am

jong

deleted obsolete file

Options
    • -42192
    • +0
    ./common/us-zipcodes.dat
Friday 18 Jul 2003
2:25 am

donb

Moved these packages over to the use of bulk data loading rather than

slow inserts

Options
    • -42201
    • +0
    ./common/ref-us-zipcodes-data.sql
    • -0
    • +42192
    ./common/us-zipcodes.dat
    • -0
    • +5
    ./oracle/00-us-zipcodes.ctl
    • -5
    • +1
    ./oracle/ref-us-zipcodes-create.sql
    • -0
    • +1
    ./postgresql/00-us-zipcodes.ctl
    • -5
    • +1
    ./postgresql/ref-us-zipcodes-create.sql
  7. … 12 more files in changeset.
Saturday 15 Sep 2001
3:11 am

donb

*** empty log message ***

Options
    • -0
    • +26
    ./postgresql/ref-us-zipcodes-drop.sql
  2. … 1 more file in changeset.
Sunday 02 Sep 2001
7:06 pm

donb

mostly fixing reference data to work with PG ...

Options
    • -42192
    • +42192
    ./common/ref-us-zipcodes-data.sql
    • -10
    • +11
    ./postgresql/ref-us-zipcodes-create.sql
  3. … 15 more files in changeset.
Tuesday 28 Aug 2001
1:21 am

jong

Initial Import

Options
    • -0
    • +42201
    ./common/ref-us-zipcodes-data.sql
    • -0
    • +74
    ./oracle/ref-us-zipcodes-create.sql
    • -0
    • +34
    ./oracle/ref-us-zipcodes-drop.sql
    • -0
    • +66
    ./postgresql/ref-us-zipcodes-create.sql
  5. … 1 more file in changeset.