OpenACS / openacs-4 / packages / lars-blogger

sql

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 14
Last Commit: 11 Apr
Commits this week: 0
Total Lines of Code (LoC): 3,411
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 23 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Sunday 25 Oct 2020
7:57 pm

gustafn

make packages in principle installable under PG 13+

Options
    • -3
    • +3
    ./postgresql/lars-blogger-sc-create.sql
  2. … 19 more files in changeset.
Monday 21 Mar 2005
1:54 am

jeffd

create the search svc contract by default

Options
    • -1
    • +3
    ./postgresql/lars-blogger-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
    • -5
    • +5
    ./postgresql/upgrade/upgrade-2.0d2-2.0d3.sql
  2. … 2275 more files in changeset.
Monday 17 May 2004
5:14 pm

jeffd

merge changes on oacs-5-1 branch to head, changes between jcd-merge-20040420 and jcd-merge-5-1-20040517 were merged, head pre changes is jcd-merge-pre-20040517 and post is jcd-merge-post-20040517

Options
    • -0
    • +14
    ./postgresql/upgrade/upgrade-2.0d2-2.0d3.sql
  2. … 834 more files in changeset.
Sunday 25 Apr 2004
4:05 pm

lars

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

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-2.0d2-2.0d3.sql
Friday 02 Apr 2004
3:03 am

jeffd

upgrade file

Options
    • -0
    • +75
    ./postgresql/upgrade/upgrade-2.0d3-2.0d4.sql
3:01 am

jeffd

logic for updates setting draft were backwards in the search trigger, so publish instead deleted the indexed item rather than forcing an index

Options
    • -2
    • +4
    ./oracle/lars-blogger-package-create.sql
    • -1
    • +4
    ./postgresql/lars-blogger-pb.sql
    • -1
    • +1
    ./postgresql/lars-blogger-sc-create.sql
  4. … 1 more file in changeset.
Monday 08 Mar 2004
9:12 pm

andrewg

Fixed up the blogroll drop script and hooked it into the main drop script.

Options
    • -5
    • +18
    ./oracle/lars-blogger-blogroll-drop.sql
    • -1
    • +2
    ./oracle/lars-blogger-drop.sql
6:53 pm

andrewg

Added blogroll.

Options
    • -1
    • +2
    ./oracle/lars-blogger-create.sql
5:50 pm

andrewg

Ported from postgres.

Options
    • -0
    • +139
    ./oracle/lars-blogger-blogroll-create.sql
    • -0
    • +11
    ./oracle/lars-blogger-blogroll-drop.sql
  3. … 2 more files in changeset.
Friday 05 Mar 2004
10:01 pm

andrewg

The call to rss_gen_subscr.del was failing because it's a function and Oracle requires that we assign it's return value into a variable. So now we have a v_foo variable to accept the value. rss_gen_subscr.del should really be a procedure, not a function, but that's a much bigger fix and we may revamp RSS instead.

Options
    • -2
    • +3
    ./oracle/lars-blogger-package-create.sql
9:58 pm

andrewg

Shorter constraint names to make Oracle happy

Options
    • -3
    • +3
    ./oracle/lars-blogger-create.sql
Friday 27 Feb 2004
7:30 pm

lars

Merged in changes from openacs-5-0-0-final to jcd-merge-pre503

Options
    • -0
    • +132
    ./oracle/upgrade/upgrade-0.8.9-0.9.0.sql
    • -132
    • +0
    ./oracle/upgrade/upgrade-0.8.9-9.0.sql
    • -0
    • +184
    ./postgresql/upgrade/upgrade-0.8.9-0.9.0.sql
    • -177
    • +0
    ./postgresql/upgrade/upgrade-0.8.9-9.0.sql
  5. … 15 more files in changeset.
Friday 20 Feb 2004
6:19 am

bdolicki

It may sound insane that I'm *finishing* porting of legacy, obsolete,

blogger-specific categories to Oracle, but because of its brokeness

my new stuff was broken too, so I had to fix it ... oh never mind

Options
    • -1
    • +5
    ./oracle/lars-blogger-package-create.sql
Wednesday 11 Feb 2004
11:56 am

lars

Renamed upgrade script 1.0a3-1.0a4 to 1.1-2.0d1, so it reflects the actual version upgrade, and so it allows us to bump up the version number on 5.0 branch (no data model script there, though)

Options
    • -138
    • +0
    ./postgresql/upgrade/upgrade-1.0a3-1.0a4.sql
    • -0
    • +138
    ./postgresql/upgrade/upgrade-1.1-2.0d1.sql
Wednesday 04 Feb 2004
11:37 am

lars

file upgrade-0.8.9-0.9.0.sql was initially added on branch oacs-5-0.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-0.8.9-0.9.0.sql
Tuesday 03 Feb 2004
7:56 pm

lars

file upgrade-0.8.9-0.9.0.sql was initially added on branch oacs-5-0.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.8.9-0.9.0.sql
Tuesday 06 Jan 2004
5:15 am

vinodk

Upgrade script for changes which allow package uninstantiation

Options
    • -95
    • +2
    ./oracle/upgrade/upgrade-1.0a3-1.0a4.sql
    • -70
    • +2
    ./postgresql/upgrade/upgrade-1.0a3-1.0a4.sql
Sunday 14 Dec 2003
5:41 pm

lars

Weird character in file

Options
    • -1
    • +1
    ./postgresql/upgrade/upgrade-1.0a3-1.0a4.sql
5:25 pm

gyang

Technorati and Blogroll support for lars-blogger

Options
    • -1
    • +13
    ./postgresql/lars-blogger-create.sql
    • -1
    • +2
    ./postgresql/lars-blogger-drop.sql
    • -0
    • +13
    ./postgresql/upgrade/upgrade-1.0a3-1.0a4.sql
  4. … 5 more files in changeset.
2:02 pm

gyang

Blogroll feature for lars-blogger. The patch includes datamodel

and admin UI pages for adding items to the blogroll, as well as an

includelet to display the blogroll. The includelet has been added

to the blogger front page.

Options
    • -0
    • +105
    ./postgresql/lars-blogger-blogroll-create.sql
    • -0
    • +11
    ./postgresql/lars-blogger-blogroll-drop.sql
    • -1
    • +2
    ./postgresql/lars-blogger-create.sql
    • -1
    • +4
    ./postgresql/lars-blogger-drop.sql
    • -0
    • +100
    ./postgresql/upgrade/upgrade-1.0a3-1.0a4.sql
  6. … 15 more files in changeset.
1:32 pm

lars

Recreate pinds_blog_entry.new to not insert into obsolete posted_date column

Options
    • -3
    • +1
    ./oracle/lars-blogger-package-create.sql
    • -0
    • +95
    ./oracle/upgrade/upgrade-1.0a3-1.0a4.sql
    • -3
    • +1
    ./postgresql/lars-blogger-pb.sql
    • -0
    • +70
    ./postgresql/upgrade/upgrade-1.0a3-1.0a4.sql
12:10 pm

lars

Merged posted_date and entry_date into entry_date, which is now a full timestamp

Options
    • -2
    • +14
    ./oracle/lars-blogger-create.sql
    • -0
    • +22
    ./oracle/upgrade/upgrade-1.0a3-1.0a4.sql
    • -2
    • +1
    ./postgresql/lars-blogger-create.sql
    • -0
    • +8
    ./postgresql/upgrade/upgrade-1.0a3-1.0a4.sql
  5. … 31 more files in changeset.
Saturday 13 Dec 2003
9:02 pm

gyang

Multiple ping URLs in lars-blogger. Currently lars-blogger can only

ping one server (typically weblogs.com) when an entry is posted. With

this change there is an admin user interface to add multiple ping URLs,

just like Movable Type, which will each be pinged when the blog is

updated.

Options
    • -1
    • +16
    ./postgresql/lars-blogger-create.sql
    • -1
    • +2
    ./postgresql/upgrade/upgrade-1.0a3-1.0a4.sql
  3. … 6 more files in changeset.
7:03 pm

gyang

Upgrade script for lars-blogger from 1.0a3 to 1.0a4

Options
    • -0
    • +14
    ./postgresql/upgrade/upgrade-1.0a3-1.0a4.sql
Thursday 11 Dec 2003
10:39 pm

jeffd

merge of changes on oacs-5-0 branch to oacs-5-0-0b4 tag

Options
    • -2
    • +2
    ./postgresql/lars-blogger-categories-pb.sql
    • -0
    • +14
    ./postgresql/upgrade/upgrade-1.0a2-1.0a3.sql
  3. … 597 more files in changeset.
Monday 08 Dec 2003
6:15 am

vinodk

Allow package uninstantiation

Options
    • -7
    • +1
    ./oracle/lars-blogger-drop.sql
    • -1
    • +11
    ./oracle/lars-blogger-package-create.sql
  3. … 4 more files in changeset.
6:10 am

vinodk

allow package to be dropped cleanly

split out pl from ddl

Options
    • -1
    • +1
    ./oracle/notifications-drop.sql
    • -1
    • +5
    ./oracle/rss-unregister.sql
    • -72
    • +2
    ./postgresql/lars-blogger-categories-create.sql
    • -0
    • +79
    ./postgresql/lars-blogger-categories-pb.sql
    • -152
    • +2
    ./postgresql/lars-blogger-create.sql
    • -20
    • +12
    ./postgresql/lars-blogger-drop.sql
    • -0
    • +174
    ./postgresql/lars-blogger-pb.sql
    • -1
    • +1
    ./postgresql/notifications-drop.sql
    • -1
    • +20
    ./postgresql/rss-unregister.sql
Wednesday 26 Nov 2003
2:34 pm

jeffd

file upgrade-1.0a2-1.0a3.sql was initially added on branch oacs-5-0.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-1.0a2-1.0a3.sql
Friday 31 Oct 2003
3:12 pm

lars

Fixed install on Oracle: Ordering of category package and pinds_blog_entries table was reversed

Options
    • -94
    • +1
    ./oracle/lars-blogger-categories-create.sql
    • -1
    • +100
    ./oracle/lars-blogger-package-create.sql