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 12 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Wednesday 11 Sep 2024
8:11 am

gustafn

merge with missing files

Options
    • -0
    • +0
    ./cal-item-create.sql
    • -0
    • +0
    ./calendar-create.sql
  3. … 1463 more files in changeset.
Tuesday 03 Sep 2024
5:37 pm

gustafn

merge from oacs-5-10

Options
    • -4
    • +4
    ./cal-item-create.sql
    • -3
    • +7
    ./calendar-create.sql
    • -1
    • +1
    ./upgrade/upgrade-2.10.0d0-2.10.0d1.sql
    • -0
    • +3
    ./upgrade/upgrade-2.10.0d6-2.10.0d7.sql
    • -0
    • +2
    ./upgrade/upgrade-2.10.0d7-2.10.0d8.sql
    • -0
    • +2
    ./upgrade/upgrade-2.10.1d6-2.10.1d7.sql
  7. … 8094 more files in changeset.
Monday 29 May 2023
11:45 am

gustafn

file upgrade-2.10.1d6-2.10.1d7.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./upgrade/upgrade-2.10.1d6-2.10.1d7.sql
Monday 14 Dec 2020
10:36 am

antoniop

file upgrade-2.10.0d7-2.10.0d8.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./upgrade/upgrade-2.10.0d7-2.10.0d8.sql
Friday 11 Dec 2020
8:40 pm

gustafn

file upgrade-2.10.0d6-2.10.0d7.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./upgrade/upgrade-2.10.0d6-2.10.0d7.sql
Wednesday 04 Jul 2018
7:31 pm

antoniop

Make acs_attribute boolean when the table type is boolean

Options
    • -2
    • +2
    ./calendar-create.sql
    • -0
    • +8
    ./upgrade/upgrade-2.10.0d4-2.10.0d5.sql
  3. … 1 more file in changeset.
Monday 07 May 2018
7:57 pm

gustafn

put the correct function into upgrade script

Options
    • -42
    • +46
    ./upgrade/upgrade-2.10.0d3-2.10.0d4.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
    • -0
    • +56
    ./upgrade/upgrade-2.10.0d3-2.10.0d4.sql
  3. … 13 more files in changeset.
Sunday 22 Apr 2018
8:05 pm

gustafn

whitespace cleanup

Options
    • -114
    • +114
    ./calendar-create.sql
  2. … 2 more files in changeset.
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
    • -0
    • +60
    ./upgrade/upgrade-2.10.0d0-2.10.0d1.sql
    • -0
    • +55
    ./upgrade/upgrade-2.10.0d1-2.10.0d2.sql
    • -0
    • +45
    ./upgrade/upgrade-2.10.0d2-2.10.0d3.sql
  5. … 9 more files in changeset.
Thursday 29 Mar 2018
10:23 pm

hectorr

Fix typos

Options
    • -2
    • +2
    ./cal-item-create.sql
    • -2
    • +2
    ./calendar-create.sql
  3. … 15 more files in changeset.
Monday 26 Mar 2018
12:13 am

hectorr

Fix typos

Options
    • -2
    • +2
    ./cal-table-create.sql
  2. … 28 more files in changeset.
Saturday 24 Mar 2018
12:53 am

hectorr

Fix more typos

Options
    • -2
    • +2
    ./cal-item-drop.sql
  2. … 84 more files in changeset.
Wednesday 31 Jan 2018
9:27 pm

gustafn

fix typos

Options
    • -2
    • +2
    ./cal-table-create.sql
    • -4
    • +4
    ./calendar-create.sql
  3. … 6 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
    • -77
    • +74
    ./calendar-create.sql
    • -12
    • +11
    ./calendar-drop.sql
    • -7
    • +6
    ./calendar-notifications-init.sql
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
    • +2
    ./calendar-create.sql
  3. … 7833 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
    • -0
    • +6
    ./upgrade/upgrade-2.6.1d2-2.6.1d3.sql
  3. … 2546 more files in changeset.
Tuesday 09 Sep 2014
10:30 am

gustafn

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

Options
    • -0
    • +0
    ./upgrade/upgrade-2.6.1d2-2.6.1d3.sql
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

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