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: 13 Nov
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 9 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
Wednesday 07 Jun 2006
5:07 pm

michaels

fix type and move na_items_item_id sequence create statement up before na_items table create statement

Options
    • -1
    • +1
    ./postgresql/news-aggregator-packages-drop.sql
    • -1
    • +1
    ./postgresql/news-aggregator-tables-create.sql
Saturday 28 Jan 2006
5:17 am

michaels

straightened out grouping issue in display (ran into the old issue detailed here - http://openacs.org/bugtracker/openacs/bug?bug%5fnumber=428); backing out maltes upgrade script change as it doesn't break anything and will create inconsistent data model - portlet should really be updated to fix the issue; tagging for rel v0.9.9

Options
    • -4
    • +2
    ./postgresql/upgrade/upgrade-0.9.7-0.9.8.sql
  2. … 9 more files in changeset.
Monday 23 Jan 2006
4:39 pm

maltes

Removed deletion of package_id otherwise any upgrade is screwed

Options
    • -2
    • +5
    ./postgresql/upgrade/upgrade-0.9.7-0.9.8.sql
Wednesday 18 Jan 2006
4:25 pm

michaels

fixed display issue with group tag by separating the two cases (one source/multiple sources to display) into to includible chunks

Options
    • -4
    • +1
    ./postgresql/upgrade/upgrade-0.9.7-0.9.8.sql
  2. … 6 more files in changeset.
12:07 am

michaels

remove debugging for multiple group by; drop title column for na_sources (not used by UI plus part of acs_objects with 5.2) and made user_id optional for source::new; still need to deal with the group by issue on index page - now, the first grouping (pub date) is not applied when there is only one source (source_id being the second grouping

Options
    • -3
    • +5
    ./postgresql/upgrade/upgrade-0.9.7-0.9.8.sql
  2. … 3 more files in changeset.
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
12:27 am

michaels

lots of little tweaks for data cleanup on uninstantiate, some more UI work, bug fixes, etc.; added daveb's sweeper proc; not tagging v0.9.8 just yet though

Options
    • -11
    • +3
    ./postgresql/news-aggregator-packages-create.sql
    • -0
    • +1
    ./postgresql/news-aggregator-tables-create.sql
    • -0
    • +75
    ./postgresql/upgrade/upgrade-0.9.7-0.9.8.sql
  4. … 23 more files in changeset.
Wednesday 04 Jan 2006
11:46 pm

michaels

thought about puting off adding back the constraints a few version until we're pretty sure anyone out there with older versions has had a chance to get through earlier upgrades but then thought better of it

Options
    • -0
    • +3
    ./postgresql/upgrade/upgrade-0.9.4d-0.9.5b.sql
11:46 pm

michaels

thought about puting off adding back the constraints a few version until we're pretty sure anyone out there with older versions has had a chance to get through earlier upgrades but then thought better of it

Options
    • -3
    • +0
    ./postgresql/upgrade/upgrade-0.9.4d-0.9.5b.sql
9:39 pm

michaels

duh... bad comment in upgrade script

Options
    • -1
    • +1
    ./postgresql/upgrade/upgrade-0.9.6b-0.9.7.sql
5:48 pm

michaels

add a few indexes

Options
    • -1
    • +4
    ./postgresql/news-aggregator-tables-create.sql
    • -0
    • +4
    ./postgresql/upgrade/upgrade-0.9.6b-0.9.7.sql
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
7:40 pm

michaels

couple of errors/typos in the upgrade scripts

Options
    • -1
    • +1
    ./postgresql/upgrade/upgrade-0.9d-0.9.4d.sql
  2. … 1 more file in changeset.
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
6:55 pm

michaels

Minor tweaks to the UI and data model to better support instance awareness and manageability. The Oracle code is WAY out of date and, not having an Oracle install, I'm not going to worry about it now. Version bumped to 0.9.5b and I removed Simon from owner list as he's no longer active in the community. Release will be tagged oacs-5-1-compat but work will need to be done to get it going on oacs-5-2.

Options
    • -3
    • +7
    ./postgresql/news-aggregator-tables-create.sql
    • -0
    • +3
    ./postgresql/upgrade/upgrade-0.9.4d-0.9.5b.sql
    • -0
    • +2
    ./postgresql/upgrade/upgrade-0.9d-0.9.4d.sql
  4. … 24 more files in changeset.
Monday 12 Dec 2005
2:24 pm

maltes

setting the default on alter is not supported in PG7.4

Options
    • -3
    • +7
    ./postgresql/upgrade/upgrade-0.6-0.7d.sql
2:17 pm

maltes

The upgrade script was named incorrectly. Fixes #2710

Options
    • -210
    • +0
    ./postgresql/upgrade/upgrade-0.5d-0.6d.sql
    • -0
    • +210
    ./postgresql/upgrade/upgrade-0.6-0.7d.sql
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

Fixing upgrade

Options
    • -84
    • +0
    ./postgresql/upgrade-0.7d-0.8d.sql
    • -0
    • +210
    ./postgresql/upgrade/upgrade-0.5d-0.6d.sql
    • -0
    • +73
    ./postgresql/upgrade/upgrade-0.7d-0.8d.sql
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