OpenACS / openacs-4 / packages / calendar / sql

postgresql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 15
Last Commit: 28 Dec 24
Commits this week: 0
Total Lines of Code (LoC): 1,349
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
Monday 08 Sep 2014
8:44 am

gustafn

- modernize SQL (dollar quoting, function definition)

- complete function args

- bump version number

Options
    • -73
    • +76
    ./cal-item-create.sql
  2. … 1 more file in changeset.
Monday 12 Aug 2013
11:34 am

gustafn

- update postgres function to modern style plpgsql definitions, avoid backslash escaping

- add missing function_args

Options
    • -25
    • +33
    ./calendar-notifications-init.sql
  2. … 23 more files in changeset.
Tuesday 08 Aug 2006
11:26 pm

donb

First shot at merging oacs-5-2 apps used in .LRN to HEAD.

Options
    • -1
    • +2
    ./cal-item-create.sql
    • -1
    • +3
    ./cal-item-drop.sql
    • -0
    • +1
    ./upgrade/upgrade-2.1.0b4-2.1.0b5.sql
  4. … 2476 more files in changeset.
Thursday 01 Dec 2005
11:37 pm

rocaelh

adding index cal_items_on_which_calendar_idx for performance improvements

Options
    • -1
    • +2
    ./cal-item-create.sql
    • -1
    • +3
    ./cal-item-drop.sql
    • -0
    • +1
    ./upgrade/upgrade-2.1.0b4-2.1.0b5.sql
  4. … 4 more files in changeset.
11:37 pm

rocaelh

file upgrade-2.1.0b4-2.1.0b5.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./upgrade/upgrade-2.1.0b4-2.1.0b5.sql
  2. … 1 more file in changeset.
Sunday 01 Feb 2004
5:51 pm

dirkg

Removed unused functions

Options
    • -53
    • +1
    ./cal-item-create.sql
  2. … 1 more file in changeset.
Tuesday 20 Jan 2004
3:19 pm

dirkg

Added a newline

Options
    • -2
    • +2
    ./calendar-create.sql
Saturday 10 Jan 2004
7:59 pm

dirkg

Added notifications to calendar. Currently works only for PostgreSQL, will do the port to Oracle in the next 4 weeks.

Options
    • -0
    • +64
    ./calendar-notifications-init.sql
  2. … 11 more files in changeset.
7:57 pm

dirkg

Removed large chunks of commented-out Oracle code.

Removed unused pgplsql procs - that looked very broken and haven't been used in over two years.

Options
    • -27
    • +1
    ./cal-item-drop.sql
    • -613
    • +5
    ./calendar-create.sql
    • -37
    • +2
    ./calendar-drop.sql
Thursday 11 Dec 2003
10:39 pm

jeffd

merge of changes on oacs-5-0 branch to oacs-5-0-0b4 tag

Options
    • -12
    • +7
    ./calendar-create.sql
    • -0
    • +11
    ./upgrade/upgrade-2.0d1-2.0b2.sql
  3. … 597 more files in changeset.
Tuesday 25 Nov 2003
1:07 am

lars

file upgrade-2.0d1-2.0b2.sql was initially added on branch oacs-5-0.

Options
    • -0
    • +0
    ./upgrade/upgrade-2.0d1-2.0b2.sql
  2. … 1 more file in changeset.
1:07 am

lars

- Rewrote calendar admin pages

- Rewrote calendar permission checking

- Fixed bug #261: Day summary doesn't show events before 7 am

- Fixed bug #1139: Times added between 8 and 10 am not shown in day view

- Calendars inherits permissions from the package to which they belong

Options
    • -11
    • +6
    ./calendar-create.sql
    • -0
    • +11
    ./upgrade/upgrade-2.0d1-2.0b2.sql
  3. … 50 more files in changeset.
Monday 24 Nov 2003
3:33 pm

lars

Typo in constraint name

Options
    • -2
    • +2
    ./calendar-create.sql
  2. … 1 more file in changeset.
Saturday 17 May 2003
12:16 pm

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -2
    • +2
    ./cal-item-create.sql
    • -2
    • +2
    ./cal-item-drop.sql
    • -15
    • +15
    ./calendar-create.sql
    • -8
    • +8
    ./calendar-drop.sql
  5. … 73 more files in changeset.
Sunday 02 Mar 2003
11:32 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
    • -2
    • +2
    ./cal-item-create.sql
    • -2
    • +2
    ./cal-item-drop.sql
    • -15
    • +15
    ./calendar-create.sql
    • -8
    • +8
    ./calendar-drop.sql
  5. … 50 more files in changeset.
Wednesday 21 Aug 2002
5:28 pm

arjun

typo fix to calendar delete from deds castillo. fixes bug #9

Options
    • -2
    • +2
    ./calendar-create.sql
Monday 22 Jul 2002
11:46 pm

ben

fixed calendar for PG

Options
    • -5
    • +6
    ./cal-item-create.sql
  2. … 10 more files in changeset.
Tuesday 18 Jun 2002
10:09 pm

ben

added PG support for new calendar API, and fixed front page to create a personal calendar for a user if he/she doens't have any

Options
    • -1
    • +5
    ./calendar-create.sql
  2. … 1 more file in changeset.
9:56 pm

ben

fixed pg load of dm

Options
    • -2
    • +2
    ./cal-item-create.sql
Thursday 25 Apr 2002
6:42 pm

ben

fixed up view of calendar items and deletion of recurrences

Options
    • -1
    • +22
    ./cal-item-create.sql
  2. … 7 more files in changeset.
Tuesday 16 Apr 2002
7:16 am

ben

added URL callback

Options
    • -1
    • +5
    ./cal-item-create.sql
    • -1
    • +20
    ./calendar-create.sql
  3. … 1 more file in changeset.
Friday 08 Mar 2002
11:29 pm

donb

Added some hacks for dotLRN events that might be useful elsewhere. I'm not

*too* worried about hacking in this style since this package needs to be

entirely rewritten except for the graphics!

Options
    • -205
    • +15
    ./cal-item-create.sql
    • -1
    • +3
    ./cal-item-drop.sql
  3. … 2 more files in changeset.
Tuesday 12 Feb 2002
3:13 pm

neophytosd

applied patch 138

Options
    • -2
    • +2
    ./cal-item-create.sql
  2. … 4 more files in changeset.
Sunday 20 Jan 2002
12:45 am

yon

just a bit of work

Options
    • -4
    • +1
    ./calendar-create.sql
  2. … 11 more files in changeset.
Monday 15 Oct 2001
8:46 pm

donb

*** empty log message ***

Options
    • -3
    • +3
    ./cal-table-create.sql
  2. … 5 more files in changeset.
Thursday 27 Sep 2001
6:12 am

charlesm

fixed the drop files

Options
    • -2
    • +3
    ./cal-item-drop.sql
    • -2
    • +4
    ./calendar-drop.sql
Tuesday 18 Sep 2001
10:47 am

charlesm

*** empty log message ***

Options
    • -3
    • +3
    ./cal-item-create.sql
Monday 17 Sep 2001
3:38 pm

charlesm

*** empty log message ***

Options
    • -2
    • +2
    ./cal-table-create.sql
    • -2
    • +2
    ./cal-table-drop.sql
    • -1
    • +2
    ./calendar-create.sql
    • -2
    • +3
    ./calendar-drop.sql
  5. … 8 more files in changeset.
Sunday 09 Sep 2001
9:18 am

charlesm

*** empty log message ***

Options
    • -9
    • +10
    ./calendar-create.sql
    • -2
    • +2
    ./calendar-drop.sql
  3. … 3 more files in changeset.
Saturday 08 Sep 2001
2:36 am

charlesm

*** empty log message ***

Options
    • -2
    • +2
    ./cal-item-create.sql
    • -15
    • +15
    ./calendar-create.sql
  3. … 2 more files in changeset.