OpenACS / openacs-4 / packages / calendar / sql / postgresql

cal-item-create.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 12
Last Commit: 14 Nov
Commits this week: 0
Total Lines of Code (LoC): 317
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 11 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 03 Sep
5:37 pm

gustafn

merge from oacs-5-10

Options
    • -4
    • +4
    ./cal-item-create.sql
  2. … 8099 more files in changeset.
Monday 29 May 2023
11:45 am

gustafn

Fix for define_function_args for cal_item__new

- Define always SQL function with the longest argument list

- Bumped version number to 2.10.1d7

Options
    • -2
    • +2
    ./cal-item-create.sql
  2. … 2 more files in changeset.
Monday 14 Dec 2020
10:36 am

antoniop

New index on cal_items(on_which_calendar, item_type_id)

Options
    • -2
    • +2
    ./cal-item-create.sql
  2. … 2 more files in changeset.
Thursday 28 Mar 2019
10:10 pm

gustafn

fix wrong comment

Options
    • -2
    • +2
    ./cal-item-create.sql
Monday 30 Apr 2018
3:54 pm

gustafn

calendar reform (part 2):

- make "forgotten" fields "related_link_url", "related_link_text",

"redirect_to_rel_link_p" of acs-events usable from the calendar.

- add web interface for "location" field as well

- bump version to 2.10.0d4

Options
    • -3
    • +10
    ./cal-item-create.sql
  2. … 14 more files in changeset.
Sunday 22 Apr 2018
8:02 pm

gustafn

calendar reform:

2.10.0d1: add table cal_uids and upsert operation for it

Add table cal_uids for CalDAV handling p o

New Function: cal_uid__upsert() p o

calendar::item::edit.cal_uid_upsert p o

calendar::item::new.insert_cal_uid p o

calendar.info

sql/oracle/cal-item-create.sql

sql/oracle/upgrade/upgrade-2.10.0d0-2.10.0d1.sql

sql/postgresql/cal-item-create.sql

sql/postgresql/upgrade/upgrade-2.10.0d0-2.10.0d1.sql

tcl/cal-item-procs-oracle.xql

tcl/cal-item-procs-postgresql.xql

2.10.0d2:

Add location as optional last parameter to cal_item__new (14/15)

Oracle: code was already out of sync with postgres, parameter

package_id was missing

Requires acs_event__new with location support acs-events 0.6.2d1

calendar.info

sql/oracle/cal-item-create.sql

sql/oracle/upgrade/upgrade-2.10.0d1-2.10.0d2.sql

sql/postgresql/cal-item-create.sql

sql/postgresql/upgrade/upgrade-2.10.0d1-2.10.0d2.sql

2.10.0d3:

Fix bug #3340: Delete acs_activity and recurrence,

when last cal_item referring to it is deleted.

calendar.info

sql/postgresql/cal-item-create.sql

sql/oracle/cal-item-create.sql

Options
    • -35
    • +131
    ./cal-item-create.sql
  2. … 12 more files in changeset.
Thursday 29 Mar 2018
10:23 pm

hectorr

Fix typos

Options
    • -2
    • +2
    ./cal-item-create.sql
  2. … 16 more files in changeset.
Monday 04 Sep 2017
10:10 am

gustafn

Modernize SQL (use $$ quoting and named function arguments)

Options
    • -22
    • +22
    ./cal-item-create.sql
  2. … 3 more files in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

merged changes from the oacs-5-9 branch and resolved conflicts

Options
    • -2
    • +2
    ./cal-item-create.sql
  2. … 7834 more files in changeset.
Saturday 22 Apr 2017
2:25 pm

gustafn

Fix spelling errors

Options
    • -2
    • +2
    ./cal-item-create.sql
  2. … 22 more files in changeset.
Monday 27 Oct 2014
5:38 pm

victorg

Merging back to HEAD branch oacs-5-8 (using tag vg-merge-oacs-5-8-from-20141027).

Options
    • -73
    • +76
    ./cal-item-create.sql
  2. … 2547 more files in changeset.
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.
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
  2. … 2478 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
  2. … 6 more files 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.
Saturday 17 May 2003
12:16 pm

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -2
    • +2
    ./cal-item-create.sql
  2. … 76 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. … 53 more files in changeset.
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
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
  2. … 2 more files 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
  2. … 3 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.
Tuesday 18 Sep 2001
10:47 am

charlesm

*** empty log message ***

Options
    • -3
    • +3
    ./cal-item-create.sql
Saturday 08 Sep 2001
2:36 am

charlesm

*** empty log message ***

Options
    • -2
    • +2
    ./cal-item-create.sql
  2. … 3 more files in changeset.
Wednesday 05 Sep 2001
11:44 am

charlesm

Datamodel should be working

Options
    • -0
    • +0
    ./cal-item-create.sql
  2. … 5 more files in changeset.
Friday 24 Aug 2001
3:10 am

liliant

ported calendar data model

Options
    • -0
    • +426
    ./cal-item-create.sql
  2. … 5 more files in changeset.