OpenACS / openacs-4 / packages / rss-support

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

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

gustafn

merge from oacs-5-10

Options
    • -0
    • +2
    ./postgresql/rss-generation-create.sql
    • -0
    • +2
    ./postgresql/upgrade/upgrade-0.5d1-0.5d2.sql
  3. … 8098 more files in changeset.
Monday 14 Dec 2020
10:50 am

antoniop

New index on on rss_gen_subscrs(lastbuild)

Options
    • -0
    • +2
    ./postgresql/rss-generation-create.sql
    • -0
    • +2
    ./postgresql/upgrade/upgrade-0.5d1-0.5d2.sql
  3. … 1 more file in changeset.
10:50 am

antoniop

file upgrade-0.5d1-0.5d2.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.5d1-0.5d2.sql
Wednesday 15 Aug 2018
6:49 pm

gustafn

Removed obsolete @arch-tag

Options
    • -2
    • +1
    ./postgresql/upgrade/upgrade-0.3d4-0.3d5.sql
    • -3
    • +2
    ./postgresql/upgrade/upgrade-0.3d5-0.3d6.sql
  3. … 25 more files in changeset.
Monday 09 Jul 2018
6:46 pm

antoniop

Fix acs_attribute type to match that of the database table (fixes test)

Options
    • -1
    • +1
    ./oracle/rss-generation-create.sql
    • -0
    • +9
    ./oracle/upgrade/upgrade-0.4-0.5d0.sql
    • -2
    • +2
    ./postgresql/rss-generation-create.sql
    • -0
    • +9
    ./postgresql/upgrade/upgrade-0.4-0.5d0.sql
  5. … 1 more file in changeset.
Wednesday 04 Apr 2018
10:11 am

hectorr

Fix typos

Options
    • -2
    • +2
    ./oracle/upgrade/upgrade-0.2d1-0.2d2.sql
  2. … 23 more files in changeset.
Saturday 30 Mar 2013
11:50 pm

gustafn

- update postgres function to modern style plpgsql definitions using dollar quoting

Options
    • -90
    • +116
    ./postgresql/rss-generation-create.sql
    • -5
    • +10
    ./postgresql/rss-generation-drop.sql
    • -25
    • +29
    ./postgresql/upgrade/upgrade-0.3d2-0.3d3.sql
    • -15
    • +34
    ./postgresql/upgrade/upgrade-0.3d4-0.3d5.sql
  5. … 38 more files in changeset.
Sunday 06 Dec 2009
9:43 pm

donb

Simple package drop now works for PG and probably Oracle, too. The drop

scripts had never been tested - they misspelled two service contract

operations (quite bad seeing as there are *only* two sc operations)

Options
    • -2
    • +2
    ./oracle/rss-generation-sc-drop.sql
    • -5
    • +4
    ./postgresql/rss-generation-sc-drop.sql
Sunday 11 Oct 2009
12:38 am

donb

Merged oacs-5-5 branch of .LRN packages to HEAD.

Options
    • -1
    • +0
    ./postgresql/upgrade/upgrade-0.3-0.4.sql
    • -0
    • +1
    ./postgresql/upgrade/upgrade-0.4d1-0.4d2.sql
  3. … 86 more files in changeset.
Monday 10 Aug 2009
9:19 pm

donb

Removed broken upgrade script

Options
    • -1
    • +0
    ./postgresql/upgrade/upgrade-0.3-0.4.sql
Friday 31 Jul 2009
5:21 pm

donb

Replacing this with a much simpler, smarter ALTER TABLE.

Options
    • -11
    • +1
    ./postgresql/upgrade/upgrade-0.4d1-0.4d2.sql
Thursday 30 Jul 2009
3:23 pm

donb

Fixed bone-headed mistake

Options
    • -1
    • +2
    ./postgresql/upgrade/upgrade-0.4d1-0.4d2.sql
Monday 27 Jul 2009
9:48 pm

donb

Added an upgrade file for the type change of a foreign key that should be

an integer rather than varchar. This should work even if someone's made

the change manually in their local install.

Options
    • -0
    • +10
    ./postgresql/upgrade/upgrade-0.4d1-0.4d2.sql
  2. … 1 more file in changeset.
9:48 pm

donb

file upgrade-0.4d1-0.4d2.sql was initially added on branch oacs-5-5.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.4d1-0.4d2.sql
Wednesday 13 Feb 2008
11:40 pm

donb

PG 8.3 catches a boneheaded foreign key reference of type varchar(100) to

object_id (integer).

Options
    • -1
    • +1
    ./postgresql/rss-generation-create.sql
    • -0
    • +1
    ./postgresql/upgrade/upgrade-0.3-0.4.sql
Tuesday 08 Aug 2006
11:26 pm

donb

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

Options
    • -0
    • +29
    ./oracle/upgrade/upgrade-0.3d2-0.3d3.sql
  2. … 2478 more files in changeset.
Wednesday 22 Jun 2005
7:25 pm

andrewg

Added package definition to ensure propagation of the ora9i compatibility changes. Not relevant for PG.

Options
    • -0
    • +29
    ./oracle/upgrade/upgrade-0.3d2-0.3d3.sql
7:23 pm

andrewg

Added package definition to ensure propagation of the ora9i compatibility changes. Not relevant for PG.

Options
    • -0
    • +29
    ./oracle/upgrade/upgrade-0.3d2-0.3d3.sql
Thursday 24 Feb 2005
2:32 pm

jeffd

commit to HEAD of merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20050111 and jcd-merge-5-1-20050224

Options
    • -2
    • +12
    ./postgresql/rss-generation-create.sql
    • -0
    • +1
    ./postgresql/rss-generation-drop.sql
    • -0
    • +36
    ./postgresql/upgrade/upgrade-0.3d4-0.3d5.sql
    • -0
    • +10
    ./postgresql/upgrade/upgrade-0.3d5-0.3d6.sql
  5. … 318 more files in changeset.
Tuesday 15 Feb 2005
8:54 pm

daveb

Fix define function args to match oracle parameter names

Options
    • -1
    • +1
    ./postgresql/rss-generation-create.sql
    • -0
    • +10
    ./postgresql/upgrade/upgrade-0.3d5-0.3d6.sql
8:54 pm

daveb

file upgrade-0.3d5-0.3d6.sql was initially added on branch oacs-5-1.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.3d5-0.3d6.sql
Friday 04 Feb 2005
9:21 pm

daveb

Add define_function_args for rss_gen_subscr__new

Options
    • -1
    • +2
    ./postgresql/upgrade/upgrade-0.3d4-0.3d5.sql
Sunday 23 Jan 2005
10:05 pm

daveb

Add rss_gen_subscr__del function and define function args.

Add tcl procedure to del rss feed subscription.

Options
    • -2
    • +12
    ./postgresql/rss-generation-create.sql
    • -0
    • +1
    ./postgresql/rss-generation-drop.sql
    • -0
    • +35
    ./postgresql/upgrade/upgrade-0.3d4-0.3d5.sql
  4. … 3 more files in changeset.
10:05 pm

daveb

file upgrade-0.3d4-0.3d5.sql was initially added on branch oacs-5-1.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.3d4-0.3d5.sql
Friday 21 Jan 2005
6:27 pm

jeffd

fix the name_method name for oracle

Options
    • -1
    • +1
    ./oracle/rss-generation-create.sql
Thursday 13 Jan 2005
2:54 pm

jeffd

commit to HEAD of merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040724 and jcd-merge-5-1-20050111

Options
    • -2
    • +9
    ./oracle/rss-generation-create.sql
    • -0
    • +70
    ./oracle/upgrade/upgrade-0.3d2-0.3d3.sql
    • -1
    • +8
    ./postgresql/rss-generation-create.sql
    • -0
    • +67
    ./postgresql/upgrade/upgrade-0.3d2-0.3d3.sql
  5. … 2272 more files in changeset.
Monday 13 Dec 2004
5:13 pm

andrewg

file upgrade-0.3d2-0.3d3.sql was initially added on branch oacs-5-1.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-0.3d2-0.3d3.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.3d2-0.3d3.sql
5:13 pm

andrewg

Added RSS enclosure support and modified the plsql api to allow a null summary_context_id. Null summary_context_id will automatically be set to the newly created subscr_id.

Options
    • -2
    • +9
    ./oracle/rss-generation-create.sql
    • -0
    • +70
    ./oracle/upgrade/upgrade-0.3d2-0.3d3.sql
    • -1
    • +8
    ./postgresql/rss-generation-create.sql
    • -0
    • +67
    ./postgresql/upgrade/upgrade-0.3d2-0.3d3.sql
  5. … 2 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
    • -5
    • +5
    ./oracle/rss-generation-create.sql
    • -2
    • +2
    ./oracle/rss-generation-drop.sql
    • -8
    • +8
    ./oracle/rss-generation-sc-drop.sql
  4. … 273 more files in changeset.
Saturday 17 May 2003
1:12 pm

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -3
    • +3
    ./oracle/rss-generation-sc-create.sql
    • -0
    • +32
    ./oracle/upgrade/upgrade-0.2d1-0.2d2.sql
    • -3
    • +3
    ./postgresql/rss-generation-create.sql
    • -1
    • +1
    ./postgresql/rss-generation-drop.sql
  5. … 13 more files in changeset.