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 11 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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.
Thursday 04 Mar 2004
3:52 pm

jeffd

rollback of Timo's name, package_id commit; see TIP 53

Options
    • -44
    • +3
    ./content-extlink.sql
    • -129
    • +10
    ./content-folder.sql
    • -148
    • +8
    ./content-image.sql
    • -294
    • +48
    ./content-item.sql
    • -41
    • +2
    ./content-keyword.sql
    • -122
    • +5
    ./content-revision.sql
    • -43
    • +4
    ./content-symlink.sql
    • -92
    • +4
    ./content-template.sql
    • -440
    • +0
    ./upgrade/upgrade-5.1.0d2-5.1.0d3.sql
  10. … 88 more files in changeset.
Tuesday 02 Mar 2004
6:00 pm

timoh

TIP#42,43: adding package_id and title to acs_objects table

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. … 88 more files in changeset.
Monday 01 Mar 2004
12:55 pm

marka

modified content_item.get_title to return a useful label for extlinks (postgres and oracle)

Options
    • -2
    • +5
    ./content-item.sql
  2. … 1 more file in changeset.
Thursday 19 Feb 2004
10:37 am

lars

We still want security_inherit_p to default to 't', otherwise bcms::folder::create_folder breaks, because null is not a valid boolean value. This is also consistent with what the comments in the function says (default true)

Options
    • -2
    • +2
    ./content-folder.sql
Wednesday 18 Feb 2004
6:02 pm

lars

Fixed , typo and simple optimization per Jeff's proposal

Options
    • -4
    • +4
    ./content-create.sql
    • -3
    • +3
    ./upgrade/upgrade-5.0.0-5.1.0d1.sql
12:10 pm

lars

Fix for bug where tree_sortkey would start from zero for each parent that wasn't a cr_item (since parent_id's foreign key constraint is on acs_objects, not cr_items). Now all non-cr_item-parent-ids are treated as one big pool of 'null' parent_id's, allowing you to create as many logical roots as you darn well please. I would appreciate review from the OCT on this patch (and am going to solicit one by email).

Options
    • -25
    • +42
    ./content-create.sql
    • -0
    • +129
    ./upgrade/upgrade-5.0.0-5.1.0d1.sql
  3. … 1 more file in changeset.
Tuesday 17 Feb 2004
4:32 pm

donb

PG 7.3 doesn't support 'current_timestamp' as a literal any more (it still

is defined as a variable, of course). Also define_function_args assumes

NULL as the default value if none is specified, 'null' <> NULL ...

Options
    • -2
    • +2
    ./content-extlink.sql
    • -2
    • +2
    ./content-folder.sql
    • -2
    • +2
    ./content-item.sql
    • -1
    • +1
    ./content-keyword.sql
    • -2
    • +2
    ./content-symlink.sql
    • -2
    • +2
    ./content-template.sql
    • -14
    • +25
    ./content-type.sql
4:10 pm

lars

Fixed bug with default values for creating folders; default values in define_function_args are literal strings, not expressions, so security_inherit_p;null is treated as the literal string 'null', and so is creation_date;current_timestamp treated as the literal string 'current_timestamp', which is not a valid timestamp format. There are probably other similar bugs introduced, we just fixed the ones that were blocking us. Emailing OCT about this.

Options
    • -2
    • +2
    ./content-folder.sql
Thursday 12 Feb 2004
6:00 pm

daveb

Fix missing ; in content_type__is_content_type for postgresql.

Options
    • -2
    • +2
    ./content-type.sql
    • -0
    • +21
    ./upgrade/upgrade-5.0.0-5.1.0d1.sql
Monday 09 Feb 2004
9:39 pm

donb

No longer necessary, replaced by the 5.0.0 to 5.1.0d1 version

Options
    • -0
    • +134
    ./upgrade/upgrade-5.0.0-5.1.0d1.sql
    • -15
    • +0
    ./upgrade/upgrade-5.0.0b4-5.1.0d1.sql
Sunday 08 Feb 2004
10:55 pm

daveb

Add missing "then" to content_folder__copy. Already fixed in upgrade script.

Options
    • -2
    • +2
    ./content-folder.sql
Saturday 07 Feb 2004
5:19 am

daveb

Fix content_item_copy2 to use NULL for target name instead of empty string.

Fix syntax error in content_folder copy.

Options
    • -5
    • +5
    ./content-folder.sql
    • -10
    • +2
    ./content-item.sql
    • -87
    • +80
    ./upgrade/upgrade-5.0.0-5.1.0d1.sql
Friday 06 Feb 2004
9:02 pm

donb

Added define_function_arg calls to non-content-revision objects and to

create_type and create_attributes, so we can do these operations via

Tcl. Content revisions, due to LOB/non-LOB issues and the incompatibility

of LOB operations between DBs need their own "smart" Tcl API.

Options
    • -1
    • +3
    ./content-extlink.sql
    • -3
    • +3
    ./content-folder.sql
    • -1
    • +6
    ./content-image.sql
    • -1
    • +4
    ./content-item.sql
    • -0
    • +3
    ./content-keyword.sql
    • -1
    • +7
    ./content-revision.sql
    • -1
    • +4
    ./content-symlink.sql
    • -1
    • +3
    ./content-template.sql
    • -1
    • +5
    ./content-type.sql
    • -0
    • +15
    ./upgrade/upgrade-5.0.0b4-5.1.0d1.sql
  11. … 1 more file in changeset.
Monday 26 Jan 2004
4:39 pm

jeffd

merge of changes between oacs-5-0-0b4 and oacs-5-0-0-final to HEAD

Options
    • -4
    • +7
    ./content-keyword.sql
    • -4
    • +7
    ./upgrade/upgrade-5.0.0b3-5.0.0b4.sql
    • -0
    • +55
    ./upgrade/upgrade-5.0.0b4-5.0.0b5.sql
  4. … 284 more files in changeset.
Friday 23 Jan 2004
6:36 pm

daveb

Upgrade scripts for changes to copy and move. Bumped up version number.

Options
    • -0
    • +558
    ./upgrade/upgrade-5.0.0-5.1.0d1.sql
  2. … 2 more files in changeset.
6:45 am

daveb

Added optional name parameter for copy functions.

Options
    • -16
    • +49
    ./content-extlink.sql
    • -27
    • +89
    ./content-folder.sql
    • -22
    • +53
    ./content-symlink.sql
Thursday 22 Jan 2004
4:38 am

daveb

Added versions of content_item__copy and content_item__move to support

optional name parameter to copy/move and rename in one step.

Options
    • -46
    • +107
    ./content-item.sql
Saturday 13 Dec 2003
1:30 am

jeffd

fix assign to constant var, bump to 5.0.0b5, provide upgrade, bug 1281 patch 389 Walter McGinnis

Options
    • -4
    • +7
    ./content-keyword.sql
    • -4
    • +7
    ./upgrade/upgrade-5.0.0b3-5.0.0b4.sql
    • -0
    • +55
    ./upgrade/upgrade-5.0.0b4-5.0.0b5.sql
  4. … 1 more file in changeset.
1:30 am

jeffd

file upgrade-5.0.0b4-5.0.0b5.sql was initially added on branch oacs-5-0.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.0.0b4-5.0.0b5.sql
Thursday 11 Dec 2003
10:39 pm

jeffd

merge of changes on oacs-5-0 branch to oacs-5-0-0b4 tag

Options
    • -3
    • +3
    ./content-create.sql
    • -6
    • +6
    ./content-extlink.sql
    • -23
    • +23
    ./content-folder.sql
    • -310
    • +384
    ./content-item.sql
    • -15
    • +55
    ./content-keyword.sql
    • -47
    • +35
    ./content-revision.sql
    • -14
    • +11
    ./content-symlink.sql
    • -10
    • +10
    ./content-template.sql
    • -29
    • +28
    ./content-type.sql
    • -12
    • +12
    ./content-util.sql
    • -27
    • +4
    ./doc-package.sql
    • -0
    • +746
    ./upgrade/upgrade-5.0.0b3-5.0.0b4.sql
    • -0
    • +196
    ./upgrade/upgrade-5.0d2-5.0d3.sql
  14. … 586 more files in changeset.
Saturday 06 Dec 2003
3:48 am

daveb

Fixes bug#1255, correctly set context_id on revision copy.

Options
    • -2
    • +2
    ./content-revision.sql
    • -0
    • +102
    ./upgrade/upgrade-5.0d2-5.0d3.sql
  3. … 2 more files in changeset.
Wednesday 03 Dec 2003
7:45 pm

daveb

Added Jun's content_item__get_path plpgsql function.

Options
    • -199
    • +289
    ./content-item.sql
    • -0
    • +94
    ./upgrade/upgrade-5.0d2-5.0d3.sql