OpenACS / openacs-4 / packages / ref-timezones

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 9
Last Commit: 16:56
Commits this week: 0
Total Lines of Code (LoC): 227,992
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 2 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates

Changeset MAIN:donb:20030329025945:1 does not match your current filter (clear filter).

Saturday 29 Mar 2003
3:59 am

donb

file ref-timezones-data.csv was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./common/ref-timezones-data.csv
3:59 am

donb

file ref-timezones-rules.csv was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./common/ref-timezones-rules.csv
Thursday 27 Mar 2003
3:46 am

donb

A variety of changes that add up to making outlook synchronization work

with PostgreSQL (at all) and Oracle (better).

1. Changed calendar to read SystemTimezone rather than hardwire it to

US/Eastern.

2. Made calendar depend on acs-lang since that's where the param lives.

3. Fixed the query on the acs-lang page that lets you set the timezone

(used the Oracle-ism UNIQUE rather than the standard DISTINCT)

4. Saw that the test stuff doesn't work and got rid of the links on the

index page - people can live without testing it for this release (we

should fix it for 4.7)

5. Fixed timezone__local_to_utc so it works with calendar, though it's

very whacky (shifted so the timezone'd date part is the UTC date, would

be much much better to use timestamp without timezone but PG doesn't

accept that syntax for function returns and we're not ready to drop

PG 7.2 support yet so I can't take advantage of the timestamp/timestamptz

type names, sigh)

Options
    • -25
    • +16
    ./postgresql/ref-timezones-create.sql
  2. … 6 more files in changeset.
Sunday 02 Mar 2003
11:42 pm

donb

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 ...

Options
    • -26
    • +35
    ./postgresql/ref-timezones-create.sql
    • -7
    • +7
    ./postgresql/ref-timezones-drop.sql
  3. … 38 more files in changeset.
Tuesday 18 Feb 2003
11:02 am

jeffd

correctly quote interval and use extract(timezone_hour...) bug 253 patch 85 Matthew Walker and patch 88 me

Options
    • -8
    • +9
    ./postgresql/ref-timezones-create.sql
Thursday 23 Jan 2003
10:55 pm

peterm

rolling back bad commit. I committed installation timesaver changes to these files as part of my catalog file commit. Needless to say, Jeff the Gatekeeper Davis immediately spotted this mistake so that it could be corrected...

Options
    • -1
    • +520
    ./common/ref-timezones-data.sql
    • -1
    • +36016
    ./common/ref-timezones-rules.sql
Tuesday 21 Jan 2003
7:45 pm

peterm

I18N: committing all the message catalog files from the dotLRN translation server. Kudos to all our translators for this contribution.

Options
    • -520
    • +1
    ./common/ref-timezones-data.sql
    • -36016
    • +1
    ./common/ref-timezones-rules.sql
  3. … 333 more files in changeset.
Friday 10 May 2002
2:39 am

yon

undo bad commit

Options
    • -0
    • +36016
    ./common/ref-timezones-rules.sql
  2. … 7 more files in changeset.
2:33 am

yon

use 'scoped_p' instead of 'style' to determine which view to present

Options
    • -36017
    • +1
    ./common/ref-timezones-rules.sql
  2. … 7 more files in changeset.
Saturday 23 Feb 2002
9:15 pm

donb

A royal kludge to work around PG 7.2 brain damage

Options
    • -5
    • +5
    ./postgresql/ref-timezones-create.sql
Wednesday 20 Feb 2002
9:43 pm

donb

Changed timezone calls to CAST for PG 7.2 compatibility ...

Options
    • -5
    • +5
    ./postgresql/ref-timezones-create.sql
Sunday 20 Jan 2002
12:57 am

yon

this was correct, reverting back to version 1.2

Options
    • -515
    • +522
    ./common/ref-timezones-data.sql
12:53 am

yon

fixed back commit

Options
    • -521
    • +514
    ./common/ref-timezones-data.sql
    • -0
    • +36015
    ./common/ref-timezones-rules.sql
12:45 am

yon

just a bit of work

Options
    • -36016
    • +1
    ./common/ref-timezones-rules.sql
  2. … 11 more files in changeset.
Friday 26 Oct 2001
8:43 pm

donb

Cleaned this up ...

Options
    • -9
    • +3
    ./postgresql/ref-timezones-drop.sql
Tuesday 16 Oct 2001
3:36 am

donb

A variety of minor fixes ...

Options
    • -125
    • +20
    ./oracle/ref-timezones-create.sql
  2. … 3 more files in changeset.
3:35 am

donb

*** empty log message ***

Options
    • -56
    • +17
    ./postgresql/ref-timezones-create.sql
Monday 15 Oct 2001
9:33 pm

donb

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

be consistent.

Options
    • -35934
    • +35934
    ./common/ref-timezones-rules.sql
    • -10
    • +24
    ./oracle/ref-timezones-create.sql
    • -1
    • +2
    ./oracle/ref-timezones-drop.sql
    • -453
    • +282
    ./postgresql/ref-timezones-create.sql
    • -11
    • +29
    ./postgresql/ref-timezones-drop.sql
  6. … 6 more files in changeset.
Tuesday 04 Sep 2001
6:41 am

jong

initial import

Options
    • -0
    • +510
    ./postgresql/ref-timezones-create.sql
    • -0
    • +25
    ./postgresql/ref-timezones-drop.sql
  3. … 1 more file in changeset.
6:39 am

jong

updated timezones. I was missing all after 505

Options
    • -515
    • +522
    ./common/ref-timezones-data.sql
4:49 am

jong

initial revision

Options
    • -0
    • +520
    ./common/ref-timezones-data.sql
    • -0
    • +36045
    ./common/ref-timezones-rules.sql
    • -0
    • +512
    ./oracle/ref-timezones-create.sql
    • -0
    • +25
    ./oracle/ref-timezones-drop.sql