OpenACS / openacs-4 / packages / lars-blogger / sql

oracle

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 8
Last Commit: 16:34
Commits this week: 0
Total Lines of Code (LoC): 1,652
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 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Friday 02 Apr 2004
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
    ./lars-blogger-package-create.sql
  2. … 3 more files 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
    ./lars-blogger-blogroll-drop.sql
    • -1
    • +2
    ./lars-blogger-drop.sql
6:53 pm

andrewg

Added blogroll.

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

andrewg

Ported from postgres.

Options
    • -0
    • +139
    ./lars-blogger-blogroll-create.sql
    • -0
    • +11
    ./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
    ./lars-blogger-package-create.sql
9:58 pm

andrewg

Shorter constraint names to make Oracle happy

Options
    • -3
    • +3
    ./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
    ./upgrade/upgrade-0.8.9-0.9.0.sql
    • -132
    • +0
    ./upgrade/upgrade-0.8.9-9.0.sql
  3. … 17 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
    ./lars-blogger-package-create.sql
Wednesday 04 Feb 2004
11:37 am

lars

Fixed bug #1440 and other bugs already fixed in PG version

Options
    • -0
    • +132
    ./upgrade/upgrade-0.8.9-0.9.0.sql
    • -132
    • +0
    ./upgrade/upgrade-0.8.9-9.0.sql
11:37 am

lars

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

Options
    • -0
    • +0
    ./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
    ./upgrade/upgrade-1.0a3-1.0a4.sql
  2. … 1 more file in changeset.
Sunday 14 Dec 2003
1:32 pm

lars

Recreate pinds_blog_entry.new to not insert into obsolete posted_date column

Options
    • -3
    • +1
    ./lars-blogger-package-create.sql
    • -0
    • +95
    ./upgrade/upgrade-1.0a3-1.0a4.sql
  3. … 2 more files in changeset.
12:10 pm

lars

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

Options
    • -2
    • +14
    ./lars-blogger-create.sql
    • -0
    • +22
    ./upgrade/upgrade-1.0a3-1.0a4.sql
  3. … 33 more files in changeset.
Monday 08 Dec 2003
6:15 am

vinodk

Allow package uninstantiation

Options
    • -7
    • +1
    ./lars-blogger-drop.sql
    • -1
    • +11
    ./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
    ./notifications-drop.sql
    • -1
    • +5
    ./rss-unregister.sql
  3. … 7 more files in changeset.
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
    ./lars-blogger-categories-create.sql
    • -1
    • +100
    ./lars-blogger-package-create.sql
Friday 24 Oct 2003
6:59 pm

lars

Renamed upgrade-0.8.5-9.0 to upgrade-0.8.9-9.0

Options
    • -132
    • +0
    ./upgrade/upgrade-0.8.5-0.9.sql
    • -0
    • +132
    ./upgrade/upgrade-0.8.9-9.0.sql
  3. … 2 more files in changeset.
Friday 17 Oct 2003
2:39 am

lars

Added categories support in Oracle, changed 0 for no category to null

Options
    • -0
    • +134
    ./lars-blogger-categories-create.sql
    • -0
    • +12
    ./lars-blogger-categories-drop.sql
    • -1
    • +6
    ./lars-blogger-create.sql
    • -1
    • +3
    ./lars-blogger-drop.sql
    • -0
    • +138
    ./upgrade/upgrade-0.9.3-1.0d1.sql
  6. … 12 more files in changeset.
Wednesday 08 Oct 2003
6:53 pm

mohanp

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

Options
    • -0
    • +204
    ./upgrade/upgrade-1.0d1-1.0d2.sql
  2. … 23 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
    • -3
    • +3
    ./lars-blogger-drop.sql
    • -11
    • +11
    ./lars-blogger-package-create.sql
    • -1
    • +1
    ./notifications-drop.sql
    • -0
    • +1
    ./notifications-init.sql
    • -1
    • +2
    ./rss-register.sql
    • -2
    • +2
    ./rss-unregister.sql
  7. … 270 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
    • -1
    • +32
    ./lars-blogger-create.sql
    • -5
    • +11
    ./lars-blogger-drop.sql
    • -1
    • +80
    ./lars-blogger-package-create.sql
    • -1
    • +5
    ./lars-blogger-package-drop.sql
    • -0
    • +2
    ./notifications-drop.sql
    • -2
    • +2
    ./rss-register.sql
    • -1
    • +1
    ./rss-unregister.sql
    • -1
    • +1
    ./upgrade/upgrade-0.7d-0.8.sql
    • -0
    • +134
    ./upgrade/upgrade-0.8.4-0.8.5.sql
    • -0
    • +132
    ./upgrade/upgrade-0.8.5-0.9.sql
  11. … 807 more files in changeset.
Thursday 03 Jul 2003
8:37 pm

lars

Fixed a number of bugs found by Janine, and made the index page more helpful when starting out. Also made the entry-edit page require a screen name to be set if we're in DisplayUserP mode.

Options
    • -3
    • +4
    ./lars-blogger-create.sql
    • -2
    • +3
    ./lars-blogger-drop.sql
    • -1
    • +5
    ./lars-blogger-package-create.sql
    • -0
    • +2
    ./notifications-drop.sql
  5. … 7 more files in changeset.
Tuesday 01 Jul 2003
3:28 pm

simonc

fixed an embarrassing amount of bugs, now let us have fun! :)

Options
    • -2
    • +4
    ./lars-blogger-create.sql
  2. … 34 more files in changeset.
Monday 16 Jun 2003
5:56 pm

peterm

fix in updating of parameters, was deleting the old parameter instead of the new one

Options
    • -1
    • +1
    ./upgrade/upgrade-0.8.5-0.9.sql
5:46 pm

peterm

adding missing parameter update to upgrade script

Options
    • -0
    • +23
    ./upgrade/upgrade-0.8.5-0.9.sql
  2. … 1 more file in changeset.
Friday 13 Jun 2003
3:51 pm

simonc

finished upgrade scripts, not tested yet

Options
    • -1
    • +29
    ./lars-blogger-create.sql
    • -5
    • +10
    ./lars-blogger-drop.sql
    • -1
    • +76
    ./lars-blogger-package-create.sql
    • -1
    • +5
    ./lars-blogger-package-drop.sql
    • -0
    • +109
    ./upgrade/upgrade-0.8.5-0.9.sql
  6. … 2 more files in changeset.
3:51 pm

simonc

file upgrade-0.8.5-0.9.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./upgrade/upgrade-0.8.5-0.9.sql
  2. … 1 more file in changeset.
11:15 am

simonc

added support for multiple users

Options
    • -2
    • +1
    ./lars-blogger-create.sql
    • -1
    • +1
    ./lars-blogger-drop.sql
    • -5
    • +1
    ./lars-blogger-package-create.sql
    • -1
    • +1
    ./lars-blogger-package-drop.sql
    • -1
    • +1
    ./notifications-init.sql
    • -2
    • +3
    ./rss-register.sql
    • -1
    • +1
    ./rss-unregister.sql
    • -1
    • +1
    ./upgrade/upgrade-0.7d-0.8.sql
  9. … 62 more files in changeset.
Saturday 10 May 2003
12:42 am

lars

Fixed so RSS feeds works with Oracle, plus a few other mior fixes

Options
    • -1
    • +6
    ./rss-register.sql
  2. … 12 more files in changeset.
Thursday 13 Mar 2003
6:04 pm

lars

file upgrade-0.8.4-0.8.5.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./upgrade/upgrade-0.8.4-0.8.5.sql
  2. … 1 more file in changeset.