OpenACS / openacs-4 / packages / ref-timezones / sql

oracle

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 3
Last Commit: 01 Jul
Commits this week: 0
Total Lines of Code (LoC): 798
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 10 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Saturday 30 May 2009
10:40 pm

donb

Applied the 5.5.0a1 fix to the timezones control file, to match the new

data format.

Options
    • -4
    • +4
    ./01-timezone-rules.ctl
Sunday 17 May 2009
12:15 am

donb

U Wien changed the format of the common timezone-rules.dat file without

changing the format specified in the corresponding Oracle sqlldr .ctl file.

Sigh, and some people think that making releases is a trivial task ...

Options
    • -4
    • +4
    ./01-timezone-rules.ctl
Wednesday 08 Oct 2003
6:53 pm

mohanp

Added upgrade to upgrade to changes made for Oracle 9i support

Options
    • -0
    • +341
    ./upgrade/upgrade-0.3-0.4d1.sql
  2. … 23 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
    • -3
    • +3
    ./ref-timezones-create.sql
    • -2
    • +2
    ./ref-timezones-drop.sql
  3. … 274 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
    • -1
    • +1
    ./00-timezones.ctl
    • -1
    • +1
    ./01-timezone-rules.ctl
  3. … 32 more files in changeset.
Wednesday 16 Jul 2003
2:47 am

donb

Removed references to the old INSERT data initialization files in the

oracle version.

Options
    • -7
    • +1
    ./ref-timezones-create.sql
2:06 am

donb

Switching to the use of PostgreSQL's COPY command and Oracle's SQL*Loader

to load the data for this package. Much, much faster than a bazillion

INSERT statements.

Options
    • -0
    • +5
    ./00-timezones.ctl
    • -0
    • +11
    ./01-timezone-rules.ctl
  3. … 7 more files in changeset.
Tuesday 16 Oct 2001
3:36 am

donb

A variety of minor fixes ...

Options
    • -125
    • +20
    ./ref-timezones-create.sql
  2. … 3 more files in changeset.
Monday 15 Oct 2001
9:33 pm

donb

Made ref-timezones work with PostgreSQL, made names of reference packages

be consistent.

Options
    • -10
    • +24
    ./ref-timezones-create.sql
    • -1
    • +2
    ./ref-timezones-drop.sql
  3. … 9 more files in changeset.
Tuesday 04 Sep 2001
4:49 am

jong

initial revision

Options
    • -0
    • +512
    ./ref-timezones-create.sql
    • -0
    • +25
    ./ref-timezones-drop.sql
  3. … 2 more files in changeset.