OpenACS / openacs-4 / packages / lars-blogger

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 14
Last Commit: 22 Oct
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 17 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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
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
    ./oracle/upgrade/upgrade-0.8.5-0.9.sql
    • -0
    • +132
    ./oracle/upgrade/upgrade-0.8.9-9.0.sql
    • -177
    • +0
    ./postgresql/upgrade/upgrade-0.8.5-0.9.sql
    • -0
    • +177
    ./postgresql/upgrade/upgrade-0.8.9-9.0.sql
Friday 17 Oct 2003
2:39 am

lars

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

Options
    • -0
    • +134
    ./oracle/lars-blogger-categories-create.sql
    • -0
    • +12
    ./oracle/lars-blogger-categories-drop.sql
    • -1
    • +6
    ./oracle/lars-blogger-create.sql
    • -1
    • +3
    ./oracle/lars-blogger-drop.sql
    • -0
    • +138
    ./oracle/upgrade/upgrade-0.9.3-1.0d1.sql
    • -5
    • +5
    ./postgresql/lars-blogger-categories-create.sql
    • -2
    • +4
    ./postgresql/lars-blogger-create.sql
    • -4
    • +99
    ./postgresql/upgrade/upgrade-0.9.3-1.0d1.sql
  9. … 9 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
    ./oracle/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
    ./oracle/lars-blogger-drop.sql
    • -11
    • +11
    ./oracle/lars-blogger-package-create.sql
    • -1
    • +1
    ./oracle/notifications-drop.sql
    • -0
    • +1
    ./oracle/notifications-init.sql
    • -1
    • +2
    ./oracle/rss-register.sql
    • -2
    • +2
    ./oracle/rss-unregister.sql
  7. … 270 more files in changeset.
Monday 29 Sep 2003
10:05 am

steffenc

Added support for categories

Options
    • -0
    • +106
    ./postgresql/lars-blogger-categories-create.sql
    • -0
    • +12
    ./postgresql/lars-blogger-categories-drop.sql
    • -7
    • +14
    ./postgresql/lars-blogger-create.sql
    • -1
    • +3
    ./postgresql/lars-blogger-drop.sql
    • -0
    • +85
    ./postgresql/upgrade/upgrade-0.9.3-1.0d1.sql
  6. … 25 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
    ./oracle/lars-blogger-create.sql
    • -5
    • +11
    ./oracle/lars-blogger-drop.sql
    • -1
    • +80
    ./oracle/lars-blogger-package-create.sql
    • -1
    • +5
    ./oracle/lars-blogger-package-drop.sql
    • -0
    • +2
    ./oracle/notifications-drop.sql
    • -2
    • +2
    ./oracle/rss-register.sql
    • -1
    • +1
    ./oracle/rss-unregister.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-0.7d-0.8.sql
    • -0
    • +134
    ./oracle/upgrade/upgrade-0.8.4-0.8.5.sql
    • -0
    • +132
    ./oracle/upgrade/upgrade-0.8.5-0.9.sql
    • -18
    • +108
    ./postgresql/lars-blogger-create.sql
    • -9
    • +23
    ./postgresql/lars-blogger-drop.sql
    • -43
    • +27
    ./postgresql/rss-register.sql
    • -1
    • +1
    ./postgresql/rss-unregister.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-0.6.4d-0.7d.sql
  16. … 802 more files in changeset.
Tuesday 08 Jul 2003
3:42 pm

lars

Remove name method from weblogger_channels, since the function isn't defined, and it's not needed

Options
    • -2
    • +2
    ./postgresql/lars-blogger-create.sql
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
    ./oracle/lars-blogger-create.sql
    • -2
    • +3
    ./oracle/lars-blogger-drop.sql
    • -1
    • +5
    ./oracle/lars-blogger-package-create.sql
    • -0
    • +2
    ./oracle/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
    ./oracle/lars-blogger-create.sql
    • -2
    • +4
    ./postgresql/lars-blogger-create.sql
  3. … 33 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
    ./oracle/upgrade/upgrade-0.8.5-0.9.sql
5:46 pm

peterm

adding missing parameter update to upgrade script

Options
    • -0
    • +23
    ./oracle/upgrade/upgrade-0.8.5-0.9.sql
    • -0
    • +26
    ./postgresql/upgrade/upgrade-0.8.5-0.9.sql
Friday 13 Jun 2003
3:51 pm

simonc

finished upgrade scripts, not tested yet

Options
    • -1
    • +29
    ./oracle/lars-blogger-create.sql
    • -5
    • +10
    ./oracle/lars-blogger-drop.sql
    • -1
    • +76
    ./oracle/lars-blogger-package-create.sql
    • -1
    • +5
    ./oracle/lars-blogger-package-drop.sql
    • -0
    • +109
    ./oracle/upgrade/upgrade-0.8.5-0.9.sql
    • -2
    • +2
    ./postgresql/lars-blogger-create.sql
    • -0
    • +151
    ./postgresql/upgrade/upgrade-0.8.5-0.9.sql
3:51 pm

simonc

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

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-0.8.5-0.9.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.8.5-0.9.sql
11:15 am

simonc

added support for multiple users

Options
    • -2
    • +1
    ./oracle/lars-blogger-create.sql
    • -1
    • +1
    ./oracle/lars-blogger-drop.sql
    • -5
    • +1
    ./oracle/lars-blogger-package-create.sql
    • -1
    • +1
    ./oracle/lars-blogger-package-drop.sql
    • -1
    • +1
    ./oracle/notifications-init.sql
    • -2
    • +3
    ./oracle/rss-register.sql
    • -1
    • +1
    ./oracle/rss-unregister.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-0.7d-0.8.sql
    • -1
    • +84
    ./postgresql/lars-blogger-create.sql
    • -1
    • +13
    ./postgresql/lars-blogger-drop.sql
    • -1
    • +1
    ./postgresql/notifications-init.sql
    • -1
    • +1
    ./postgresql/rss-register.sql
    • -1
    • +1
    ./postgresql/rss-unregister.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-0.6.4d-0.7d.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-0.7d-0.8.sql
  16. … 55 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
    ./oracle/rss-register.sql
    • -1
    • +6
    ./postgresql/rss-register.sql
  3. … 11 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
    ./oracle/upgrade/upgrade-0.8.4-0.8.5.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.8.4-0.8.5.sql
6:03 pm

lars

- Applied Joel Aufrect's patch to add title_url (with modifications)

- fixed bug #336 by adding a catch

- showing minimum 3 last postings

Options
    • -0
    • +1
    ./oracle/lars-blogger-create.sql
    • -0
    • +4
    ./oracle/lars-blogger-package-create.sql
    • -1
    • +1
    ./oracle/notifications-init.sql
    • -0
    • +134
    ./oracle/upgrade/upgrade-0.8.4-0.8.5.sql
    • -14
    • +19
    ./postgresql/lars-blogger-create.sql
    • -8
    • +10
    ./postgresql/lars-blogger-drop.sql
    • -1
    • +1
    ./postgresql/notifications-init.sql
    • -0
    • +74
    ./postgresql/upgrade/upgrade-0.8.4-0.8.5.sql
  9. … 22 more files in changeset.
3:24 pm

lars

Merged over changes from HEAD

Options
    • -1
    • +5
    ./oracle/lars-blogger-create.sql
    • -1
    • +5
    ./oracle/lars-blogger-package-create.sql
    • -0
    • +0
    ./oracle/upgrade/upgrade-0.8.2-0.8.3.sql
    • -0
    • +0
    ./oracle/upgrade/upgrade-0.8.3-0.8.4.sql
    • -11
    • +19
    ./postgresql/lars-blogger-create.sql
    • -1
    • +1
    ./postgresql/notifications-init.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.8.2-0.8.3.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.8.3-0.8.4.sql
  9. … 30 more files in changeset.
Sunday 02 Mar 2003
11:42 pm

donb

I've changed "timestamp" to "timestamptz" and have begun fixing some

code that used to be legal but as of PG 7.3 is not. You can no longer

subtract an integer from a timestamp but must cast to date, "timestamp"

disappeared (must use "interval" now), "datetime" disappeared ("timestamptz"),

and suchwhat.

Not done but closer than it was before ...

Options
    • -4
    • +4
    ./postgresql/lars-blogger-create.sql
    • -2
    • +2
    ./postgresql/lars-blogger-drop.sql
  3. … 38 more files in changeset.
Thursday 30 Jan 2003
5:54 pm

lars

Fixes in rss-support:

- bind the rss service contract implementation

- provide a link on admin page to setup/manage rss feed

- require rss-support package

Options
    • -2
    • +8
    ./oracle/rss-register.sql
    • -0
    • +28
    ./oracle/upgrade/upgrade-0.8.3-0.8.4.sql
    • -1
    • +1
    ./postgresql/notifications-init.sql
    • -22
    • +43
    ./postgresql/rss-register.sql
    • -0
    • +15
    ./postgresql/upgrade/upgrade-0.8.3-0.8.4.sql
  6. … 7 more files in changeset.
Monday 27 Jan 2003
5:17 pm

lars

- Upgraded lars-blogger to use the new richtext widget;

- fixed several bugs in the Oracle version

Options
    • -1
    • +5
    ./oracle/lars-blogger-create.sql
    • -1
    • +5
    ./oracle/lars-blogger-package-create.sql
    • -0
    • +129
    ./oracle/upgrade/upgrade-0.8.2-0.8.3.sql
    • -12
    • +20
    ./postgresql/lars-blogger-create.sql
    • -0
    • +71
    ./postgresql/upgrade/upgrade-0.8.2-0.8.3.sql
  6. … 16 more files in changeset.
Tuesday 21 Jan 2003
2:45 pm

jeffd

merge bartt PG 7.3 fixes from HEAD

Options
    • -4
    • +4
    ./postgresql/lars-blogger-create.sql
    • -2
    • +2
    ./postgresql/lars-blogger-drop.sql
  3. … 53 more files in changeset.
Saturday 21 Dec 2002
11:27 pm

bartt

Patches to make OpenACS PG 7.3 compatible.

Options
    • -4
    • +4
    ./postgresql/lars-blogger-create.sql
    • -2
    • +2
    ./postgresql/lars-blogger-drop.sql
  3. … 53 more files in changeset.
Saturday 30 Nov 2002
6:32 pm

jeffd

merge from oacs-4-6

Options
    • -4
    • +4
    ./postgresql/lars-blogger-create.sql
    • -0
    • +69
    ./postgresql/lars-blogger-sc-create.sql
    • -0
    • +35
    ./postgresql/lars-blogger-sc-drop.sql
    • -0
    • +20
    ./postgresql/upgrade/lars-blogger-sc-index.sql
    • -6
    • +10
    ./postgresql/upgrade/upgrade-0.6.4d-0.7d.sql
    • -1
    • +6
    ./postgresql/upgrade/upgrade-0.7d-0.8.sql
  7. … 98 more files in changeset.
Monday 18 Nov 2002
11:50 pm

bartt

file lars-blogger-sc-create.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./postgresql/lars-blogger-sc-create.sql
11:50 pm

bartt

file lars-blogger-sc-drop.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./postgresql/lars-blogger-sc-drop.sql
11:50 pm

bartt

file lars-blogger-sc-index.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./postgresql/upgrade/lars-blogger-sc-index.sql
11:50 pm

bartt

Added search.

Options
    • -0
    • +69
    ./postgresql/lars-blogger-sc-create.sql
    • -0
    • +35
    ./postgresql/lars-blogger-sc-drop.sql
    • -0
    • +20
    ./postgresql/upgrade/lars-blogger-sc-index.sql
    • -6
    • +10
    ./postgresql/upgrade/upgrade-0.6.4d-0.7d.sql
    • -1
    • +6
    ./postgresql/upgrade/upgrade-0.7d-0.8.sql
  6. … 2 more files in changeset.
Wednesday 30 Oct 2002
12:31 pm

jeffd

lowercase name_method

Options
    • -4
    • +4
    ./postgresql/lars-blogger-create.sql