OpenACS / openacs-4 / packages / categories

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 17
Last Commit: 29 Jul
Commits this week: 0
Total Lines of Code (LoC): 5,404
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 4 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Wednesday 27 Jul 2005
12:57 am

miguelm

file categories-relation.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./postgresql/categories-relation.sql
Wednesday 22 Jun 2005
6:12 pm

andrewg

sequence.nextval doesn't have trailing parentheses on Oracle

Options
    • -1
    • +1
    ./oracle/category-link-package.sql
    • -2
    • +2
    ./oracle/category-synonym-package.sql
Thursday 24 Feb 2005
2:32 pm

jeffd

commit to HEAD of merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20050111 and jcd-merge-5-1-20050224

Options
    • -2
    • +2
    ./oracle/category-synonym-package.sql
    • -9
    • +9
    ./postgresql/category-package.sql
    • -15
    • +15
    ./postgresql/category-synonym-package.sql
    • -0
    • +155
    ./postgresql/upgrade/upgrade-1.0d6-1.0d7.sql
  5. … 318 more files in changeset.
Tuesday 08 Feb 2005
5:00 pm

andrewg

Adding another 'or replace'.

Options
    • -1
    • +1
    ./oracle/category-synonym-package.sql
4:52 pm

andrewg

create -> create or replace for rolling the failed 1.0d3 -> 1.0d4 upgrade

Options
    • -1
    • +1
    ./oracle/category-synonym-package.sql
Sunday 06 Feb 2005
7:42 pm

jeffd

make the category tree acs_object.title the tree name

Options
    • -1
    • +2
    ./oracle/category-package.sql
    • -1
    • +2
    ./oracle/category-tree-package.sql
    • -0
    • +8
    ./oracle/upgrade/upgrade-1.1d2-1.1d3.sql
    • -1
    • +3
    ./postgresql/category-package.sql
    • -1
    • +3
    ./postgresql/category-tree-package.sql
    • -0
    • +158
    ./postgresql/upgrade/upgrade-1.1d2-1.1d3.sql
  7. … 1 more file in changeset.
Thursday 13 Jan 2005
10:31 am

dedsc

provide upgrade for bug #2262. bump up info

Options
    • -0
    • +155
    ./postgresql/upgrade/upgrade-1.0d6-1.0d7.sql
  2. … 1 more file in changeset.
10:31 am

dedsc

file upgrade-1.0d6-1.0d7.sql was initially added on branch oacs-5-1.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-1.0d6-1.0d7.sql
10:30 am

dedsc

fixes bug #2262 -- removed some embedded tabs in functions and return proper record on trigger return

Options
    • -15
    • +15
    ./postgresql/category-synonym-package.sql
10:27 am

dedsc

some embedded tags making one function barf. replacing with spaces

Options
    • -9
    • +9
    ./postgresql/category-package.sql
Monday 06 Dec 2004
1:05 pm

timoh

fixed small bug in usage of sequence

Options
    • -1
    • +1
    ./oracle/category-link-package.sql
    • -2
    • +2
    ./oracle/category-synonym-package.sql
Saturday 24 Jul 2004
5:14 pm

jeffd

source undeclared in category_tree__copy, bump version, upgrade

Options
    • -0
    • +1
    ./postgresql/category-tree-package.sql
    • -0
    • +65
    ./postgresql/upgrade/upgrade-1.1d1-1.1d2.sql
  3. … 1 more file in changeset.
Thursday 19 Feb 2004
8:11 pm

timoh

bugfix: get triggers to compile

Options
    • -5
    • +9
    ./oracle/category-synonym-package.sql
Wednesday 11 Feb 2004
2:25 pm

timoh

added category synonym feature

Options
    • -0
    • +164
    ./oracle/categories-create.sql
    • -0
    • +11
    ./oracle/categories-drop.sql
    • -0
    • +300
    ./oracle/category-synonym-package.sql
    • -0
    • +177
    ./oracle/upgrade/upgrade-1.0d3-1.0d4.sql
    • -0
    • +162
    ./postgresql/categories-create.sql
    • -0
    • +18
    ./postgresql/categories-drop.sql
    • -0
    • +273
    ./postgresql/category-synonym-package.sql
    • -0
    • +200
    ./postgresql/upgrade/upgrade-1.0d3-1.0d4.sql
  9. … 20 more files in changeset.
11:54 am

timoh

removed unused procs

Options
    • -65
    • +0
    ./oracle/category-tree-package.sql
    • -64
    • +0
    ./postgresql/category-tree-package.sql
Tuesday 10 Feb 2004
12:55 pm

lars

Moved to use normal select ... style for creating object-types, instead of an inline function.

Options
    • -34
    • +24
    ./postgresql/categories-create.sql
Sunday 08 Feb 2004
6:30 pm

timoh

added category-links feature

Options
    • -1
    • +41
    ./oracle/categories-create.sql
    • -1
    • +5
    ./oracle/categories-drop.sql
    • -0
    • +50
    ./oracle/category-link-package.sql
    • -0
    • +39
    ./oracle/upgrade/upgrade-1.0d2-1.0d3.sql
    • -1
    • +41
    ./postgresql/categories-create.sql
    • -1
    • +7
    ./postgresql/categories-drop.sql
    • -0
    • +38
    ./postgresql/category-link-package.sql
    • -0
    • +39
    ./postgresql/upgrade/upgrade-1.0d2-1.0d3.sql
  9. … 29 more files in changeset.
6:27 pm

timoh

changed email

Options
    • -1
    • +1
    ./oracle/categories-init.sql
    • -1
    • +1
    ./oracle/categories-permissions.sql
    • -1
    • +1
    ./oracle/category-package.sql
    • -1
    • +1
    ./oracle/category-tree-package.sql
    • -1
    • +1
    ./postgresql/categories-init.sql
    • -1
    • +1
    ./postgresql/categories-permissions.sql
    • -1
    • +1
    ./postgresql/category-package.sql
    • -1
    • +1
    ./postgresql/category-tree-package.sql
Sunday 01 Feb 2004
8:12 pm

timoh

added support for single/multiple categorizations / forcing users to map at least one category

Options
    • -0
    • +9
    ./oracle/categories-create.sql
    • -4
    • +10
    ./oracle/category-tree-package.sql
    • -0
    • +11
    ./oracle/upgrade/upgrade-1.0d1-1.0d2.sql
    • -0
    • +13
    ./postgresql/categories-create.sql
    • -1
    • +1
    ./postgresql/categories-drop.sql
    • -3
    • +9
    ./postgresql/category-tree-package.sql
    • -0
    • +54
    ./postgresql/upgrade/upgrade-1.0d1-1.0d2.sql
  8. … 42 more files in changeset.
Sunday 11 Jan 2004
6:37 pm

lars

Added helpful view for getting categories

Options
    • -0
    • +8
    ./oracle/categories-create.sql
    • -0
    • +12
    ./oracle/upgrade/upgrade-0.1d-1.0d1.sql
    • -0
    • +8
    ./postgresql/categories-create.sql
    • -0
    • +12
    ./postgresql/upgrade/upgrade-0.1d-1.0d1.sql
  5. … 1 more file in changeset.
Tuesday 11 Nov 2003
12:19 am

jeffd

some minor bugs with the postgresql port (check_nested_ind broken)

Options
    • -1
    • +1
    ./postgresql/category-package.sql
    • -2
    • +4
    ./postgresql/category-tree-package.sql
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
    • -1
    • +1
    ./oracle/category-package.sql
    • -1
    • +1
    ./oracle/category-tree-package.sql
  3. … 274 more files in changeset.
Monday 29 Sep 2003
6:21 am

marka

changed timestamp columns/variables to 'timestamp with time zone'

Options
    • -6
    • +6
    ./postgresql/categories-drop.sql
    • -3
    • +3
    ./postgresql/category-package.sql
    • -3
    • +3
    ./postgresql/category-tree-package.sql
Monday 19 May 2003
3:09 pm

peterm

committing the port of the categories package from Oracle to PostgreSQL by Michael Steigman

Options
    • -0
    • +240
    ./postgresql/categories-create.sql
    • -0
    • +87
    ./postgresql/categories-drop.sql
    • -0
    • +73
    ./postgresql/categories-init.sql
    • -0
    • +19
    ./postgresql/categories-permissions.sql
    • -0
    • +341
    ./postgresql/category-package.sql
    • -0
    • +399
    ./postgresql/category-tree-package.sql
  7. … 13 more files in changeset.
Friday 09 May 2003
8:08 am

timoh

renamed function index_childs to index_children (it's better english i guess)

Options
    • -2
    • +7
    ./oracle/categories-init.sql
    • -5
    • +5
    ./oracle/category-tree-package.sql
Wednesday 23 Apr 2003
2:29 pm

peterm

Importing the categories package developed by Timo Hentschel

Options
    • -0
    • +0
    ./oracle/categories-create.sql
    • -0
    • +0
    ./oracle/categories-drop.sql
    • -0
    • +0
    ./oracle/categories-init.sql
    • -0
    • +0
    ./oracle/categories-permissions.sql
    • -0
    • +0
    ./oracle/category-package.sql
    • -0
    • +0
    ./oracle/category-tree-package.sql
  7. … 87 more files in changeset.
2:29 pm

peterm

Initial revision

Options
    • -0
    • +189
    ./oracle/categories-create.sql
    • -0
    • +57
    ./oracle/categories-drop.sql
    • -0
    • +70
    ./oracle/categories-init.sql
    • -0
    • +22
    ./oracle/categories-permissions.sql
    • -0
    • +351
    ./oracle/category-package.sql
    • -0
    • +404
    ./oracle/category-tree-package.sql
  7. … 87 more files in changeset.