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 7 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Monday 05 Jul 2004
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
Saturday 01 May 2004
10:36 am

jeffd

second occurance of bug 1738 version match on OS X problem

Options
    • -2
    • +2
    ./content-type.sql
10:32 am

jeffd

content_type__drop_type doesn't work on OS X (7.2 was matching sp[uriously) bug 1738 patch 498 Jarkko Laine

Options
    • -3
    • +3
    ./content-type.sql
Thursday 29 Apr 2004
5:41 pm

jeffd

cascade deletes for table cr_folder_type_map when folder or content_type are deleted

Options
    • -3
    • +3
    ./content-create.sql
    • -0
    • +3
    ./upgrade/upgrade-5.2.0d2-5.2.0d3.sql
  3. … 2 more files in changeset.
5:37 pm

jeffd

missed the pg upgrade script for cascade delete on root folder map table

Options
    • -0
    • +8
    ./upgrade/upgrade-5.2.0d2-5.2.0d3.sql
Monday 26 Apr 2004
4:30 pm

olah

Fixed a couple of search trigger functions which either didn't work so well or not at all. Static Pages can now be deleted or updated and will be un-indexed or re-indexed respectively.

Options
    • -11
    • +4
    ./content-search.sql
Sunday 25 Apr 2004
10:50 am

donb

Appled Jarrko's patch 498 for bug 1738: check for PG 7.2 failed on Mac OS X

because the check string was just '%7.2%' and Mac OS X ships with darwin 7.2

Options
    • -2
    • +2
    ./content-type.sql
Tuesday 20 Apr 2004
11:12 pm

jeffd

merge all the changes on the oacs-5-1 and dotlrn-2-0 branches up to tag jcd-merge-20040420

Options
    • -2
    • +108
    ./upgrade/upgrade-5.0.0-5.1.0d1.sql
  2. … 647 more files in changeset.
Monday 19 Apr 2004
11:55 am

lars

Added MIME types for Open Office documents

Options
    • -0
    • +23
    ./upgrade/upgrade-5.0.0-5.1.0d1.sql
  2. … 2 more files in changeset.
Thursday 08 Apr 2004
4:42 am

daveb

Fix typos in content_item__move, add missing content_folder__move function with

name parameter, and cr_items_tree_update_tr along with upgrade script.

Options
    • -2
    • +85
    ./upgrade/upgrade-5.0.0-5.1.0d1.sql
Monday 29 Mar 2004
10:06 pm

jeffd

add package_id to content_folder__new define_function_args, upgrade script

Options
    • -1
    • +1
    ./content-folder.sql
    • -0
    • +5
    ./upgrade/upgrade-5.2.0d1-5.2.0d2.sql
Saturday 27 Mar 2004
4:58 pm

jeffd

fix typo in content_folder__rename, bump to 5.2.0d2, upgrade script, postgres only

Options
    • -1
    • +1
    ./content-folder.sql
    • -0
    • +39
    ./upgrade/upgrade-5.2.0d1-5.2.0d2.sql
  3. … 1 more file in changeset.
Friday 12 Mar 2004
8:19 pm

jeffd

various bug fixes for package_id, title addition to acs_objects

Options
    • -6
    • +7
    ./content-folder.sql
    • -9
    • +9
    ./content-image.sql
    • -4
    • +4
    ./content-item.sql
    • -2
    • +2
    ./content-revision.sql
    • -1
    • +1
    ./content-template.sql
    • -3
    • +29
    ./content-type.sql
  7. … 7 more files in changeset.
7:48 pm

jeffd

Remerge Timo's changes for tip 42,43, cf tip 53

Options
    • -4
    • +45
    ./content-extlink.sql
    • -11
    • +130
    ./content-folder.sql
    • -9
    • +149
    ./content-image.sql
    • -49
    • +295
    ./content-item.sql
    • -2
    • +41
    ./content-keyword.sql
    • -6
    • +123
    ./content-revision.sql
    • -5
    • +44
    ./content-symlink.sql
    • -5
    • +93
    ./content-template.sql
    • -0
    • +440
    ./upgrade/upgrade-5.1.0d2-5.1.0d3.sql
  10. … 89 more files in changeset.