OpenACS / openacs-4 / packages / news-aggregator / sql

postgresql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 9
Last Commit: 21 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 3 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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
    ./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
    ./upgrade/upgrade-0.9.4d-0.9.5b.sql
9:39 pm

michaels

duh... bad comment in upgrade script

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

michaels

add a few indexes

Options
    • -1
    • +4
    ./news-aggregator-tables-create.sql
    • -0
    • +4
    ./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
    ./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
    ./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
    ./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
    ./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
    ./news-aggregator-tables-create.sql
    • -0
    • +3
    ./upgrade/upgrade-0.9.4d-0.9.5b.sql
    • -0
    • +2
    ./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
    ./upgrade/upgrade-0.6-0.7d.sql
2:17 pm

maltes

The upgrade script was named incorrectly. Fixes #2710

Options
    • -210
    • +0
    ./upgrade/upgrade-0.5d-0.6d.sql
    • -0
    • +210
    ./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
    ./upgrade/upgrade-0.6-0.7d.sql
Saturday 26 Nov 2005
12:12 pm

maltes

Fixing upgrade

Options
    • -84
    • +0
    ./upgrade-0.7d-0.8d.sql
    • -0
    • +210
    ./upgrade/upgrade-0.5d-0.6d.sql
    • -0
    • +73
    ./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
    ./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
    ./upgrade/upgrade-0.7d-0.8d.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
    ./news-aggregator-packages-create.sql
    • -2
    • +4
    ./news-aggregator-packages-drop.sql
    • -1
    • +68
    ./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
    ./news-aggregator-tables-create.sql
    • -0
    • +17
    ./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
    • -191
    • +7
    ./news-aggregator-create.sql
    • -38
    • +7
    ./news-aggregator-drop.sql
  3. … 22 more files in changeset.
12:04 pm

gyang

Import of news-aggregator version 0.4d (from Guan's and Simon's CVS) by Guan Yang <guan@unicast.org>

Options
    • -0
    • +8
    ./news-aggregator-create.sql
    • -0
    • +8
    ./news-aggregator-drop.sql
    • -0
    • +0
    ./news-aggregator-packages-create.sql
    • -0
    • +0
    ./news-aggregator-packages-drop.sql
    • -0
    • +0
    ./news-aggregator-tables-create.sql
    • -0
    • +0
    ./news-aggregator-tables-drop.sql
  7. … 75 more files in changeset.
12:04 pm

gyang

Initial revision

Options
    • -0
    • +405
    ./news-aggregator-packages-create.sql
    • -0
    • +82
    ./news-aggregator-packages-drop.sql
    • -0
    • +277
    ./news-aggregator-tables-create.sql
    • -0
    • +54
    ./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
    ./news-aggregator-create.sql
    • -2
    • +2
    ./news-aggregator-drop.sql
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
    • +192
    ./news-aggregator-create.sql
    • -0
    • +39
    ./news-aggregator-drop.sql
  3. … 815 more files in changeset.
Thursday 17 Jul 2003
9:10 pm

rmello

- Fixed repeated use of na_sources_source_id_fk constraint name in datamodel.

Options
    • -2
    • +2
    ./news-aggregator-create.sql
Friday 13 Jun 2003
10:50 am

simonc

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

Options
    • -0
    • +0
    ./news-aggregator-create.sql
  2. … 1 more file in changeset.
10:50 am

simonc

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

Options
    • -0
    • +0
    ./news-aggregator-drop.sql
  2. … 1 more file in changeset.
10:50 am

simonc

added news aggregator package

Options
    • -0
    • +192
    ./news-aggregator-create.sql
    • -0
    • +39
    ./news-aggregator-drop.sql
  3. … 21 more files in changeset.