OpenACS / openacs-4 / packages / calendar

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 19
Last Commit: 05 Apr
Commits this week: 0
Total Lines of Code (LoC): 3,560
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 4 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 09 Sep 2014
10:30 am

gustafn

- add upgrade files

Options
    • -0
    • +6
    ./postgresql/upgrade/upgrade-2.6.1d2-2.6.1d3.sql
  2. … 1 more file in changeset.
10:30 am

gustafn

file upgrade-2.6.1d2-2.6.1d3.sql was initially added on branch oacs-5-8.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-2.6.1d2-2.6.1d3.sql
Monday 08 Sep 2014
8:44 am

gustafn

- modernize SQL (dollar quoting, function definition)

- complete function args

- bump version number

Options
    • -73
    • +76
    ./postgresql/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
    ./postgresql/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
    ./oracle/cal-item-create.sql
    • -1
    • +3
    ./oracle/cal-item-drop.sql
    • -5
    • +11
    ./oracle/upgrade/upgrade-2.0d1-2.0b2.sql
    • -0
    • +1
    ./oracle/upgrade/upgrade-2.1.0b4-2.1.0b5.sql
    • -1
    • +2
    ./postgresql/cal-item-create.sql
    • -1
    • +3
    ./postgresql/cal-item-drop.sql
    • -0
    • +1
    ./postgresql/upgrade/upgrade-2.1.0b4-2.1.0b5.sql
  8. … 2472 more files in changeset.
Wednesday 01 Feb 2006
10:59 am

emmar

Fix #2760. Make the index name shorter to fit 30 chars.

Options
    • -2
    • +2
    ./oracle/cal-item-create.sql
    • -2
    • +2
    ./oracle/cal-item-drop.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-2.1.0b4-2.1.0b5.sql
Thursday 01 Dec 2005
11:37 pm

rocaelh

adding index cal_items_on_which_calendar_idx for performance improvements

Options
    • -1
    • +2
    ./oracle/cal-item-create.sql
    • -1
    • +3
    ./oracle/cal-item-drop.sql
    • -0
    • +1
    ./oracle/upgrade/upgrade-2.1.0b4-2.1.0b5.sql
    • -1
    • +2
    ./postgresql/cal-item-create.sql
    • -1
    • +3
    ./postgresql/cal-item-drop.sql
    • -0
    • +1
    ./postgresql/upgrade/upgrade-2.1.0b4-2.1.0b5.sql
  7. … 1 more file 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
    ./oracle/upgrade/upgrade-2.1.0b4-2.1.0b5.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-2.1.0b4-2.1.0b5.sql
Wednesday 22 Jun 2005
7:46 pm

andrewg

The fancy update...from syntax in the PG version is not compatible with either ora8 or ora9.

Options
    • -5
    • +11
    ./oracle/upgrade/upgrade-2.0d1-2.0b2.sql
7:45 pm

andrewg

The fancy update...from syntax in the PG version is not compatible with either ora8 or ora9.

Options
    • -5
    • +11
    ./oracle/upgrade/upgrade-2.0d1-2.0b2.sql
Sunday 01 Feb 2004
5:51 pm

dirkg

Removed unused functions

Options
    • -56
    • +1
    ./oracle/cal-item-create.sql
    • -53
    • +1
    ./postgresql/cal-item-create.sql
Wednesday 21 Jan 2004
4:12 pm

dirkg

Removed crufty old code, fixed package creation

Options
    • -181
    • +1
    ./oracle/calendar-create.sql
Tuesday 20 Jan 2004
3:37 pm

dirkg

Added notifications to Oracle. It's currently broken because acs-mail-lite is broken, but my code works syntactically at least.

Options
    • -1
    • +2
    ./oracle/calendar-create.sql
    • -0
    • +56
    ./oracle/calendar-notifications-init.sql
3:19 pm

dirkg

Added a newline

Options
    • -2
    • +2
    ./postgresql/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
    • -73
    • +1
    ./oracle/calendar-create.sql
    • -0
    • +64
    ./postgresql/calendar-notifications-init.sql
  3. … 10 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
    ./postgresql/cal-item-drop.sql
    • -613
    • +5
    ./postgresql/calendar-create.sql
    • -37
    • +2
    ./postgresql/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
    • -2
    • +2
    ./oracle/calendar-create.sql
    • -0
    • +11
    ./oracle/upgrade/upgrade-2.0d1-2.0b2.sql
    • -12
    • +7
    ./postgresql/calendar-create.sql
    • -0
    • +11
    ./postgresql/upgrade/upgrade-2.0d1-2.0b2.sql
  5. … 595 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
    ./oracle/upgrade/upgrade-2.0d1-2.0b2.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-2.0d1-2.0b2.sql
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
    • -0
    • +11
    ./oracle/upgrade/upgrade-2.0d1-2.0b2.sql
    • -11
    • +6
    ./postgresql/calendar-create.sql
    • -0
    • +11
    ./postgresql/upgrade/upgrade-2.0d1-2.0b2.sql
  4. … 49 more files in changeset.
Monday 24 Nov 2003
3:33 pm

lars

Typo in constraint name

Options
    • -2
    • +2
    ./oracle/calendar-create.sql
    • -2
    • +2
    ./postgresql/calendar-create.sql
Wednesday 08 Oct 2003
6:53 pm

mohanp

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

Options
    • -0
    • +586
    ./oracle/upgrade/upgrade-1.0-2.0d1.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
    • -9
    • +9
    ./oracle/cal-item-create.sql
    • -8
    • +8
    ./oracle/calendar-create.sql
  3. … 274 more files in changeset.
Saturday 17 May 2003
12:16 pm

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -2
    • +2
    ./postgresql/cal-item-create.sql
    • -2
    • +2
    ./postgresql/cal-item-drop.sql
    • -15
    • +15
    ./postgresql/calendar-create.sql
    • -8
    • +8
    ./postgresql/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
    ./postgresql/cal-item-create.sql
    • -2
    • +2
    ./postgresql/cal-item-drop.sql
    • -15
    • +15
    ./postgresql/calendar-create.sql
    • -8
    • +8
    ./postgresql/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
    ./postgresql/calendar-create.sql
Saturday 17 Aug 2002
8:21 pm

vinodk

Manually added patches 332,333,334 for bugs 1628,1629,1630 by Brad Duell

Options
    • -2
    • +2
    ./oracle/calendar-drop.sql
  2. … 2 more files in changeset.
Monday 22 Jul 2002
11:46 pm

ben

fixed calendar for PG

Options
    • -5
    • +6
    ./postgresql/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
    ./postgresql/calendar-create.sql
  2. … 1 more file in changeset.
9:56 pm

ben

fixed pg load of dm

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

ben

fixed up view of calendar items and deletion of recurrences

Options
    • -1
    • +20
    ./oracle/cal-item-create.sql
    • -1
    • +22
    ./postgresql/cal-item-create.sql
  3. … 6 more files in changeset.