OpenACS / openacs-4 / packages / categories

sql

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 17
Last Commit: 12 Mar
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 9 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Saturday 30 Mar 2013
11:50 pm

gustafn

- update postgres function to modern style plpgsql definitions using dollar quoting

Options
    • -11
    • +11
    ./postgresql/categories-init.sql
    • -23
    • +23
    ./postgresql/categories-relation.sql
    • -17
    • +32
    ./postgresql/category-link-package.sql
    • -123
    • +156
    ./postgresql/category-package.sql
    • -77
    • +154
    ./postgresql/category-synonym-package.sql
    • -150
    • +183
    ./postgresql/category-tree-package.sql
    • -17
    • +20
    ./postgresql/upgrade/upgrade-1.0d1-1.0d2.sql
    • -6
    • +13
    ./postgresql/upgrade/upgrade-1.0d3-1.0d4.sql
    • -41
    • +63
    ./postgresql/upgrade/upgrade-1.0d6-1.0d7.sql
    • -19
    • +21
    ./postgresql/upgrade/upgrade-1.1.2d1-1.1.2d2.sql
    • -10
    • +17
    ./postgresql/upgrade/upgrade-1.1.2d2-1.1.2d3.sql
    • -16
    • +18
    ./postgresql/upgrade/upgrade-1.1.2d3-1.1.2d4.sql
    • -16
    • +20
    ./postgresql/upgrade/upgrade-1.1d1-1.1d2.sql
    • -58
    • +55
    ./postgresql/upgrade/upgrade-1.1d2-1.1d3.sql
    • -27
    • +27
    ./postgresql/upgrade/upgrade-1.1d3-1.1d4.sql
  16. … 27 more files in changeset.
Tuesday 30 Nov 2010
7:58 pm

jeffd

dont give table and id columns for tables that do not exist; maybe there should be an upgrade to fix this as well

Options
    • -4
    • +4
    ./postgresql/categories-relation.sql
Sunday 06 Dec 2009
9:11 pm

donb

Basic package drop works now for PostgreSQL (Oracle will come later)

Options
    • -16
    • +10
    ./postgresql/categories-drop.sql
Sunday 01 Feb 2009
7:38 pm

gustafn

- fix incorrect reference to table in category_tree__copy

- revert a change of don to make categories admin interface working again.

Options
    • -1
    • +1
    ./postgresql/category-tree-package.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-1.1.2d3-1.1.2d4.sql
  3. … 1 more file in changeset.
Friday 30 Jan 2009
3:59 am

donb

Fixed apparently untested fix by gustafn that tried to update a table

using the syntax "update categories c set ...", which is not SQL.

Options
    • -1
    • +1
    ./postgresql/category-tree-package.sql
    • -2
    • +2
    ./postgresql/upgrade/upgrade-1.1.2d3-1.1.2d4.sql
Thursday 06 Nov 2008
4:39 pm

gustafn

fix 2 bugs

- call to a non-existing acs_object__new with 5 args

- 2 table references were incorrect in category_tree__copy

Options
    • -2
    • +3
    ./postgresql/category-tree-package.sql
    • -0
    • +63
    ./postgresql/upgrade/upgrade-1.1.2d3-1.1.2d4.sql
  3. … 1 more file in changeset.
Thursday 24 Apr 2008
8:52 pm

daveb

Fix typo, require_category_p duplicated. Should be widget instead.

Options
    • -1
    • +1
    ./oracle/category-tree-package.sql
Wednesday 23 Apr 2008
11:44 am

gustafn

Fix missing column "widget" in category_tree_map in Oracle; strangely enough, the upgrade script was available.

Options
    • -0
    • +4
    ./oracle/categories-create.sql
    • -0
    • +4
    ./postgresql/categories-create.sql
Tuesday 22 Apr 2008
6:04 pm

gustafn

Fix missing column "widget" in category_tree_map in Oracle

Options
    • -0
    • +4
    ./oracle/categories-create.sql
    • -0
    • +4
    ./postgresql/categories-create.sql
Wednesday 09 Apr 2008
10:30 am

marioa

Fixed problem with repeat parameter on category_tree.map procedure

Options
    • -1
    • +1
    ./oracle/category-tree-package.sql
Monday 01 Oct 2007
12:15 pm

gustafn

add update script

Options
    • -0
    • +18
    ./postgresql/upgrade/upgrade-1.1.2d2-1.1.2d3.sql
  2. … 1 more file in changeset.
11:46 am

gustafn

add missing alias for function category__name

Options
    • -0
    • +2
    ./postgresql/category-package.sql
  2. … 1 more file in changeset.
Sunday 16 Sep 2007
12:35 pm

maltes

Fixing problem with missing widget

Options
    • -4
    • +6
    ./oracle/category-tree-package.sql
    • -0
    • +9
    ./oracle/upgrade/upgrade-1.1.2d1-1.1.2d2.sql
    • -0
    • +1
    ./postgresql/categories-create.sql
    • -3
    • +5
    ./postgresql/category-tree-package.sql
    • -0
    • +39
    ./postgresql/upgrade/upgrade-1.1.2d1-1.1.2d2.sql
  6. … 1 more file in changeset.
Wednesday 09 Aug 2006
2:25 am

donb

CVS merge dup'd a \i line causing the datamodel to fail

Options
    • -1
    • +0
    ./postgresql/categories-create.sql
Monday 31 Jul 2006
10:31 pm

gustafn

merged version from cvs 5-2, conflicts resolved (2x white space, 1x .info file)

Options
    • -0
    • +2
    ./postgresql/categories-create.sql
    • -0
    • +9
    ./postgresql/categories-drop.sql
    • -0
    • +60
    ./postgresql/categories-relation.sql
    • -1
    • +1
    ./postgresql/category-tree-package.sql
    • -0
    • +60
    ./postgresql/upgrade/upgrade-1.1d3-1.1d4.sql
  6. … 16 more files in changeset.
Thursday 08 Jun 2006
3:46 am

michaels

fix typo; thanks again to ricardo

Options
    • -1
    • +1
    ./postgresql/category-tree-package.sql
Wednesday 14 Dec 2005
6:21 pm

timoh

bugfix: source categores-relation script

Options
    • -0
    • +2
    ./postgresql/categories-create.sql
Wednesday 24 Aug 2005
12:08 pm

timoh

fixing installation of meta category relations

Options
    • -4
    • +2
    ./postgresql/categories-relation.sql
    • -0
    • +1
    ./postgresql/upgrade/upgrade-1.1d3-1.1d4.sql
Tuesday 23 Aug 2005
5:49 pm

timoh

fixing category relations

Options
    • -2
    • +2
    ./postgresql/categories-relation.sql
    • -26
    • +26
    ./postgresql/upgrade/upgrade-1.1d3-1.1d4.sql
  3. … 1 more file in changeset.
5:49 pm

timoh

fixing category relations

Options
    • -0
    • +1
    ./postgresql/categories-create.sql
  2. … 2 more files in changeset.
Wednesday 27 Jul 2005
12:58 am

miguelm

upgrade script to to create new types and roles for the meta category

Options
    • -0
    • +59
    ./postgresql/upgrade/upgrade-1.1d3-1.1d4.sql
12:58 am

miguelm

file upgrade-1.1d3-1.1d4.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-1.1d3-1.1d4.sql
12:57 am

miguelm

Creating rel_types and roles to support meta categories

Options
    • -0
    • +9
    ./postgresql/categories-drop.sql
    • -0
    • +62
    ./postgresql/categories-relation.sql
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.