OpenACS / openacs-4 / packages / news-aggregator

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 12
Last Commit: 29 Jul
Commits this week: 0
Total Lines of Code (LoC): 944
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 15 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Friday 31 Jul 2020
2:36 pm

hectorr

Whitespace changes

Options
    • -50
    • +49
    ./postgresql/news-aggregator-packages-create.sql
    • -1
    • +1
    ./postgresql/news-aggregator-packages-drop.sql
    • -87
    • +87
    ./postgresql/news-aggregator-tables-create.sql
2:07 pm

antoniop

Redefine foreign key constraints on the na_aggregators table so that there won't be need for package uninstantiation callbacks (as found downstream)

Options
    • -29
    • +6
    ./postgresql/news-aggregator-packages-create.sql
    • -2
    • +7
    ./postgresql/news-aggregator-tables-create.sql
    • -0
    • +33
    ./postgresql/upgrade/upgrade-0.10d-0.11d.sql
  4. … 1 more file in changeset.
2:05 pm

antoniop

No need to explicitly delete permissions

Options
    • -12
    • +0
    ./postgresql/news-aggregator-packages-drop.sql
2:02 pm

antoniop

Fix typo in drop script

Options
    • -1
    • +1
    ./postgresql/news-aggregator-packages-drop.sql
1:33 pm

antoniop

Move upgrade scripts in the proper directory

Options
    • -84
    • +0
    ./postgresql/upgrade-0.7d-0.8d.sql
    • -5
    • +0
    ./postgresql/upgrade-0.9d-0.10d.sql
    • -0
    • +84
    ./postgresql/upgrade/upgrade-0.7d-0.8d.sql
    • -0
    • +5
    ./postgresql/upgrade/upgrade-0.9d-0.10d.sql
Thursday 04 Apr 2019
10:56 am

antoniop

Add missing constraint at creation

Options
    • -0
    • +1
    ./postgresql/news-aggregator-tables-create.sql
Tuesday 02 Apr 2019
12:42 pm

antoniop

Make guid,source_id unique for na_items

Options
    • -0
    • +5
    ./postgresql/upgrade-0.9d-0.10d.sql
  2. … 3 more files in changeset.
Tuesday 07 Jun 2016
11:49 am

hectorr

na_items_item_id_seq created before na_items tables

Options
    • -1
    • +1
    ./postgresql/news-aggregator-tables-create.sql
Sunday 15 Jan 2006
12:27 am

michaels

file upgrade-0.9.7-0.9.8.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.9.7-0.9.8.sql
Wednesday 04 Jan 2006
5:48 pm

michaels

file upgrade-0.9.6b-0.9.7.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.9.6b-0.9.7.sql
Wednesday 28 Dec 2005
6:55 pm

michaels

file upgrade-0.9.4d-0.9.5b.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.9.4d-0.9.5b.sql
6:55 pm

michaels

file upgrade-0.9d-0.9.4d.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.9d-0.9.4d.sql
Monday 12 Dec 2005
2:17 pm

maltes

file upgrade-0.6-0.7d.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.6-0.7d.sql
Saturday 26 Nov 2005
12:12 pm

maltes

file upgrade-0.5d-0.6d.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.5d-0.6d.sql
12:12 pm

maltes

file upgrade-0.7d-0.8d.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.7d-0.8d.sql
Wednesday 17 Aug 2005
12:03 pm

emmar

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

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-0.5d2-0.5d3.sql
Tuesday 01 Jun 2004
12:59 pm

gyang

Data model changes: Added author and pub_date fields to na_item__new (news-aggregator)

Options
    • -3
    • +11
    ./postgresql/news-aggregator-packages-create.sql
    • -2
    • +4
    ./postgresql/news-aggregator-packages-drop.sql
    • -1
    • +68
    ./postgresql/upgrade-0.7d-0.8d.sql
Monday 31 May 2004
4:19 pm

gyang

Added the following fields to the news-aggregator data model:

- author, comment_page and pub_date to na_items

- source_title and show_description_p to na_subscriptions

Options
    • -1
    • +9
    ./postgresql/news-aggregator-tables-create.sql
    • -0
    • +17
    ./postgresql/upgrade-0.7d-0.8d.sql
Saturday 20 Mar 2004
12:12 pm

gyang

Checked through all the conflicts between news-aggregator-0-2d and news-aggregator-0-4d and bumped version to 0.5d

Options
    • -67
    • +0
    ./oracle/news-aggregator-create.sql
    • -28
    • +0
    ./oracle/news-aggregator-drop.sql
    • -121
    • +0
    ./oracle/news-aggregator-package-create.sql
    • -10
    • +0
    ./oracle/news-aggregator-package-drop.sql
    • -121
    • +0
    ./oracle/upgrade/upgrade-0.1d-0.2d.sql
    • -191
    • +7
    ./postgresql/news-aggregator-create.sql
    • -38
    • +7
    ./postgresql/news-aggregator-drop.sql
  8. … 17 more files in changeset.
12:04 pm

gyang

Initial revision

Options
    • -0
    • +405
    ./postgresql/news-aggregator-packages-create.sql
    • -0
    • +82
    ./postgresql/news-aggregator-packages-drop.sql
    • -0
    • +277
    ./postgresql/news-aggregator-tables-create.sql
    • -0
    • +54
    ./postgresql/news-aggregator-tables-drop.sql
  5. … 63 more files in changeset.
Sunday 09 Nov 2003
11:53 am

peterm

Hakan Andersson made functions use timestamptz instead of timestamp

Options
    • -4
    • +4
    ./postgresql/news-aggregator-create.sql
    • -2
    • +2
    ./postgresql/news-aggregator-drop.sql
Wednesday 08 Oct 2003
6:43 pm

mohanp

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

Options
    • -0
    • +121
    ./oracle/upgrade/upgrade-0.1d-0.2d.sql
  2. … 6 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
    • -1
    • +1
    ./oracle/news-aggregator-drop.sql
    • -5
    • +5
    ./oracle/news-aggregator-package-create.sql
  3. … 274 more files in changeset.
Thursday 28 Aug 2003
11:41 am

lars

Merged 4.6.4d1 (unreleased) to HEAD. This marks the end of the life of the oacs-4-6 branch.

Options
    • -0
    • +67
    ./oracle/news-aggregator-create.sql
    • -0
    • +28
    ./oracle/news-aggregator-drop.sql
    • -0
    • +121
    ./oracle/news-aggregator-package-create.sql
    • -0
    • +10
    ./oracle/news-aggregator-package-drop.sql
    • -0
    • +192
    ./postgresql/news-aggregator-create.sql
    • -0
    • +39
    ./postgresql/news-aggregator-drop.sql
  7. … 811 more files in changeset.
Friday 13 Jun 2003
10:50 am

simonc

file news-aggregator-create.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./oracle/news-aggregator-create.sql
    • -0
    • +0
    ./postgresql/news-aggregator-create.sql
10:50 am

simonc

file news-aggregator-package-drop.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./oracle/news-aggregator-package-drop.sql
10:50 am

simonc

file news-aggregator-package-create.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./oracle/news-aggregator-package-create.sql
10:50 am

simonc

file news-aggregator-drop.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./oracle/news-aggregator-drop.sql
    • -0
    • +0
    ./postgresql/news-aggregator-drop.sql