OpenACS / openacs-4 / packages / ref-countries

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 8
Last Commit: 21 Nov
Commits this week: 0
Total Lines of Code (LoC): 414
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 34 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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
    • +1
    ./postgresql/00-countries.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-countries.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-countries.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-countries-drop.sql
  2. … 275 more files in changeset.
Thursday 17 Jul 2003
3:10 am

donb

Decided that assuming SQL data files are CSV-formatted files is a bad idea

after running into a package that embeds comments in its data! Changed

from .csv to .dat and all that implies. Still more testing to do...

Options
    • -0
    • +239
    ./common/countries.dat
    • -259
    • +0
    ./common/ref-country-data.sql
    • -0
    • +5
    ./oracle/00-countries.ctl
    • -23
    • +5
    ./oracle/ref-countries-create.sql
    • -0
    • +1
    ./postgresql/00-countries.ctl
    • -23
    • +5
    ./postgresql/ref-countries-create.sql
  7. … 28 more files in changeset.
Saturday 15 Sep 2001
2:49 am

donb

Oops - forgot some add/remove monkey-motion in these packages ...

Options
    • -0
    • +95
    ./postgresql/ref-countries-create.sql
    • -0
    • +26
    ./postgresql/ref-countries-drop.sql
    • -96
    • +0
    ./postgresql/ref-country-create.sql
  4. … 1 more file in changeset.
Sunday 02 Sep 2001
7:06 pm

donb

mostly fixing reference data to work with PG ...

Options
    • -3
    • +3
    ./oracle/ref-countries-create.sql
  2. … 16 more files in changeset.
Tuesday 28 Aug 2001
12:35 am

jong

changed = to like

Options
    • -2
    • +2
    ./oracle/ref-countries-drop.sql
  2. … 1 more file in changeset.
12:26 am

jong

renamed for stupid APM name req

Options
    • -0
    • +104
    ./oracle/ref-countries-create.sql
    • -0
    • +35
    ./oracle/ref-countries-drop.sql
    • -104
    • +0
    ./oracle/ref-country-create.sql
    • -35
    • +0
    ./oracle/ref-country-drop.sql
12:14 am

jong

Initial import

Options
    • -0
    • +259
    ./common/ref-country-data.sql
    • -0
    • +104
    ./oracle/ref-country-create.sql
    • -0
    • +35
    ./oracle/ref-country-drop.sql
    • -0
    • +96
    ./postgresql/ref-country-create.sql
  5. … 2 more files in changeset.