OpenACS / openacs-4 / packages / acs-content-repository / sql

postgresql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 40
Last Commit: 28 Dec 24
Commits this week: 0
Total Lines of Code (LoC): 32,399
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 6 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Thursday 12 Aug 2004
8:51 pm

josee

fixing bug with the copy_content function, moving the call to lob_copy before the update

Options
    • -2
    • +6
    ./content-revision.sql
Wednesday 11 Aug 2004
1:56 am

donb

file upgrade-5.1.2d4-5.1.2d5.sql was initially added on branch oacs-5-1.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.1.2d4-5.1.2d5.sql
1:56 am

donb

Fixed a typo in one of the cr_item__new procs

Options
    • -2
    • +2
    ./content-item.sql
    • -0
    • +195
    ./upgrade/upgrade-5.1.2d4-5.1.2d5.sql
Monday 02 Aug 2004
3:40 pm

daveb

Make sure all versions of content_item__new behave in the same way, creating

a new revision if content or title is specified. Patch#580 from

Dave Manginelli fixes bug#2040.

Options
    • -4
    • +19
    ./content-item.sql
Saturday 24 Jul 2004
4:52 pm

jeffd

exception misspelled in cr_dummy_ins_del_tr; bump version, upgrade

Options
    • -1
    • +1
    ./content-type.sql
    • -0
    • +11
    ./upgrade/upgrade-5.2.0d6-5.2.0d7.sql
  3. … 1 more file in changeset.
10:33 am

jeffd

merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040712 and jcd-merge-5-1-20040724 to HEAD

Options
    • -1
    • +1
    ./content-type.sql
    • -0
    • +57
    ./upgrade/upgrade-5.1.2d1-5.1.2d2.sql
    • -0
    • +80
    ./upgrade/upgrade-5.1.2d2-5.1.2d3.sql
  4. … 136 more files in changeset.
Tuesday 20 Jul 2004
5:19 pm

jvdongen

Fixed CR part of bug #1953

Options
    • -2
    • +2
    ./content-item.sql
    • -0
    • +42
    ./upgrade/upgrade-5.2.0d5-5.2.0d6.sql
  3. … 1 more file in changeset.
4:26 pm

jvdongen

Fixed the CR part of bug 1953.

Options
    • -3
    • +3
    ./content-item.sql
    • -0
    • +80
    ./upgrade/upgrade-5.1.2d2-5.1.2d3.sql
  3. … 1 more file in changeset.
4:26 pm

jvdongen

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

Options
    • -0
    • +0
    ./upgrade/upgrade-5.1.2d2-5.1.2d3.sql
Sunday 18 Jul 2004
7:28 pm

daveb

Fix syntax error in drop column statement in content_type__drop__attribute.

Fixes bug#2014. Added upgrade script and increased version in info file.

Options
    • -2
    • +2
    ./content-item.sql
    • -2
    • +2
    ./content-type.sql
    • -0
    • +57
    ./upgrade/upgrade-5.1.2d1-5.1.2d2.sql
  4. … 1 more file in changeset.
7:28 pm

daveb

file upgrade-5.1.2d1-5.1.2d2.sql was initially added on branch oacs-5-1.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.1.2d1-5.1.2d2.sql
Monday 12 Jul 2004
4:49 pm

jeffd

merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040628 and jcd-merge-5-1-20040712 to HEAD

Options
    • -67
    • +0
    ./upgrade/upgrade-5.1.1-5.1.2.sql
    • -0
    • +67
    ./upgrade/upgrade-5.1.1d2-5.1.1d3.sql
  3. … 115 more files in changeset.
Monday 05 Jul 2004
9:31 am

joela

moved the 5.1.1-5.1.2 upgrade script back to 5.1.1d2-5.1.1d3 and changed info file from 5.1.2 to 5.1.1d3, to maintain consistency with core release conventions.

Options
    • -67
    • +0
    ./upgrade/upgrade-5.1.1-5.1.2.sql
    • -0
    • +67
    ./upgrade/upgrade-5.1.1d2-5.1.1d3.sql
  3. … 3 more files in changeset.
9:31 am

joela

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

Options
    • -0
    • +0
    ./upgrade/upgrade-5.1.1d2-5.1.1d3.sql
  2. … 1 more file in changeset.
Friday 02 Jul 2004
4:10 pm

jeffd

bad quoting of string literal in plpgsql functions

Options
    • -2
    • +2
    ./content-folder.sql
Thursday 01 Jul 2004
6:33 pm

jeffd

add define_function_args definitions for most functions, bump to 5.2.0d5, upgrade script

Options
    • -2
    • +6
    ./content-extlink.sql
    • -78
    • +30
    ./content-folder.sql
    • -4
    • +46
    ./content-item.sql
    • -0
    • +11
    ./content-revision.sql
    • -1
    • +6
    ./content-symlink.sql
    • -0
    • +4
    ./content-template.sql
    • -2
    • +22
    ./content-type.sql
    • -0
    • +89
    ./upgrade/upgrade-5.2.0d4-5.2.0d5.sql
  9. … 2 more files in changeset.
1:02 pm

jeffd

name the cr_revisions_lob_fk constraint in cr_revisions

Options
    • -1
    • +3
    ./content-create.sql
Tuesday 29 Jun 2004
12:17 pm

jeffd

merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040517 and jcd-merge-5-1-20040628 to HEAD

Options
    • -19
    • +19
    ./content-folder.sql
    • -1
    • +1
    ./content-item.sql
  3. … 686 more files in changeset.
Monday 28 Jun 2004
5:41 pm

juny

minor bug fixes: corrected list that is passed on package_exec_plsql -var_list, added definition of some plsql procs, added content::item::copy, bump up for version needed

Options
    • -0
    • +5
    ./upgrade/upgrade-5.2.0d3-5.2.0d4.sql
  2. … 3 more files in changeset.
Saturday 05 Jun 2004
4:12 pm

donb

Added this now because it seemed invisible to others for some reason even

though it existed on the 5.1 branch in my local checkout.

Options
    • -0
    • +67
    ./upgrade/upgrade-5.1.1-5.1.2.sql
Wednesday 02 Jun 2004
10:54 pm

jader

Fix for bug #1799. Bug in content_type__drop_attribute.

Options
    • -2
    • +2
    ./content-type.sql
1:24 am

donb

I'd accidently changed some old upgrade files to use edit_name rather than

rename (for Oracle 9.2) and had not added the needed upgrade files for 5.1.

Options
    • -0
    • +67
    ./upgrade/upgrade-5.1.1-5.1.2.sql
  2. … 11 more files in changeset.
1:24 am

donb

file upgrade-5.1.1-5.1.2.sql was initially added on branch oacs-5-1.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.1.1-5.1.2.sql
  2. … 1 more file in changeset.
12:54 am

donb

Changed CR "rename" procs to "edit_name" to avoid issues with Oracle 9.2 (and

changed PG for consistency)

Options
    • -3
    • +3
    ./content-folder.sql
    • -12
    • +12
    ./content-item.sql
    • -3
    • +3
    ./content-test.sql
  4. … 23 more files in changeset.
Wednesday 26 May 2004
9:10 pm

donb

Minor cosmetic change vs. 1858

Options
    • -16
    • +16
    ./content-folder.sql
    • -9
    • +9
    ./content-item.sql
8:12 pm

donb

Fixed Bug #1858: qualifying "rename" works in 8i bug chokes in 9i causing

the reported error on installation. Fixed by changing the name to "edit_name"

and implemented it for PG as well (to keep names similar)

Options
    • -3
    • +3
    ./content-folder.sql
    • -2
    • +2
    ./content-item.sql
    • -3
    • +3
    ./content-test.sql
  4. … 26 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
    • -2
    • +2
    ./content-create.sql
    • -2
    • +2
    ./content-item.sql
    • -10
    • +3
    ./content-search.sql
    • -0
    • +92
    ./upgrade/upgrade-5.1.1d1-5.1.1d2.sql
  5. … 831 more files in changeset.
Thursday 06 May 2004
2:35 am

daveb

Fix typo in parameter name, reference to non-existant parameter.

Fixes bug#1793

Options
    • -3
    • +3
    ./content-item.sql
    • -1
    • +17
    ./upgrade/upgrade-5.1.1d1-5.1.1d2.sql
2:12 am

daveb

file upgrade-5.1.1d1-5.1.1d2.sql was initially added on branch oacs-5-1.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.1.1d1-5.1.1d2.sql
2:12 am

daveb

Fix reference to chid instead of child in cr_items_update_tr. Upgrade script

included. Fixes bug#1791

Options
    • -2
    • +2
    ./content-create.sql
    • -0
    • +76
    ./upgrade/upgrade-5.1.1d1-5.1.1d2.sql