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 2 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Friday 18 Mar 2005
2:50 pm

jeffd

minor fix: move_name should have been move__name

Options
    • -2
    • +2
    ./content-folder.sql
    • -1
    • +1
    ./upgrade/upgrade-5.2.0d12-5.2.0d13.sql
2:44 pm

jeffd

upgrade to fix bug in content_folder__move and add the integer,integer version used in content_item__move; bump to 5.2.0d13. thanks daveb

Options
    • -0
    • +86
    ./upgrade/upgrade-5.2.0d12-5.2.0d13.sql
  2. … 1 more file in changeset.
4:21 am

daveb

Add content_folder__move function that allows rename on move. Already existed on Oracle.

Options
    • -5
    • +21
    ./content-folder.sql
Thursday 03 Mar 2005
7:11 pm

daveb

*** empty log message ***

Options
    • -2
    • +2
    ./upgrade/upgrade-5.1.4d4-5.1.4d5.sql
6:56 pm

daveb

Add content_revision__del

Options
    • -2
    • +2
    ./content-revision.sql
Sunday 27 Feb 2005
6:41 pm

daveb

Fix bug#2298. Create content_revision__del

Options
    • -1
    • +1
    ./upgrade/upgrade-5.1.5d3-5.1.5d4.sql
  2. … 1 more file in changeset.
6:38 pm

daveb

Move file to correct name for upgrade.

Options
    • -70
    • +0
    ./upgrade/upgrade-5.1.5d2-5.1.5d3.sql
    • -0
    • +70
    ./upgrade/upgrade-5.1.5d3-5.1.5d4.sql
6:32 pm

daveb

Fix bug#2298 correctly create content_revision__del

Options
    • -0
    • +70
    ./upgrade/upgrade-5.1.5d2-5.1.5d3.sql
Thursday 24 Feb 2005
8:34 pm

jeffd

set live and latest to null so delete does not violate fk constraints

Options
    • -1
    • +4
    ./content-item.sql
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
    • -8
    • +20
    ./content-folder.sql
    • -2
    • +2
    ./upgrade/upgrade-5.1.2d6-5.1.2d7.sql
    • -1
    • +38
    ./upgrade/upgrade-5.1.4d4-5.1.4d5.sql
    • -0
    • +53
    ./upgrade/upgrade-5.1.5d1-5.1.5d2.sql
  5. … 318 more files in changeset.
Wednesday 23 Feb 2005
12:52 pm

leed

Page root and template root registered as magic objects.

Options
    • -1
    • +11
    ./content-create.sql
  2. … 1 more file in changeset.
Wednesday 16 Feb 2005
1:14 am

victorg

Commented the creation of the index cr_items_name, already existed

Options
    • -2
    • +2
    ./upgrade/upgrade-5.1.2d6-5.1.2d7.sql
  2. … 1 more file in changeset.
Thursday 03 Feb 2005
1:16 am

jeffd

bind the fts contract when creating the datamodel

Options
    • -1
    • +5
    ./content-search.sql
  2. … 1 more file in changeset.
Monday 24 Jan 2005
12:16 am

jeffd

add index on cr_revisions(publish_date), upgrade bump to 5.2.0d12

Options
    • -1
    • +4
    ./content-create.sql
    • -0
    • +1
    ./upgrade/upgrade-5.2.0d11-5.2.0d12.sql
  3. … 3 more files in changeset.
Friday 14 Jan 2005
4:14 am

daveb

Fix content_folder__is_subfolder pl/sql. Also fix tcl proc which was

passing in the wrong list format to package_exec_plsql. Add upgrade

script and tests.

Options
    • -6
    • +19
    ./content-folder.sql
    • -1
    • +38
    ./upgrade/upgrade-5.1.4d4-5.1.4d5.sql
    • -0
    • +53
    ./upgrade/upgrade-5.1.5d1-5.1.5d2.sql
  4. … 3 more files in changeset.
4:14 am

daveb

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

Options
    • -0
    • +0
    ./upgrade/upgrade-5.1.5d1-5.1.5d2.sql
Thursday 13 Jan 2005
2:54 pm

jeffd

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

Options
    • -3
    • +4
    ./content-create.sql
    • -2
    • +1
    ./content-extlink.sql
    • -2
    • +40
    ./content-folder.sql
    • -17
    • +8
    ./content-item.sql
    • -2
    • +1
    ./content-revision.sql
    • -5
    • +5
    ./content-template.sql
    • -6
    • +2
    ./content-type.sql
    • -0
    • +16
    ./upgrade/upgrade-4.5-4.6.sql
    • -0
    • +195
    ./upgrade/upgrade-5.1.2d4-5.1.2d5.sql
    • -0
    • +125
    ./upgrade/upgrade-5.1.2d6-5.1.2d7.sql
    • -0
    • +97
    ./upgrade/upgrade-5.1.4d1-5.1.4d2.sql
    • -0
    • +129
    ./upgrade/upgrade-5.1.4d2-5.1.4d3.sql
    • -0
    • +130
    ./upgrade/upgrade-5.1.4d3-5.1.4d4.sql
    • -0
    • +310
    ./upgrade/upgrade-5.1.4d4-5.1.4d5.sql
    • -0
    • +11
    ./upgrade/upgrade-5.1.4d5-5.1.4d6.sql
  16. … 2261 more files in changeset.
Wednesday 12 Jan 2005
2:22 pm

dedsc

fix to return folder id present in upgrade. just putting it here as well

Options
    • -3
    • +2
    ./content-folder.sql
Tuesday 11 Jan 2005
7:51 pm

daveb

Properly create content_revision__del. Fixes bug#2251

Options
    • -2
    • +2
    ./content-revision.sql
Friday 07 Jan 2005
4:03 am

daveb

Fix define function args for content_item__set_live revision

Options
    • -2
    • +2
    ./content-item.sql
    • -0
    • +10
    ./upgrade/upgrade-5.1.4d6-5.1.4d7.sql
  3. … 1 more file in changeset.
4:03 am

daveb

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

Options
    • -0
    • +0
    ./upgrade/upgrade-5.1.4d6-5.1.4d7.sql
Thursday 06 Jan 2005
7:48 pm

daveb

Fix define function args for content_template__new

Options
    • -3
    • +2
    ./content-template.sql
    • -0
    • +10
    ./upgrade/upgrade-5.2.0d10-5.2.0d11.sql
  3. … 1 more file in changeset.
7:43 pm

daveb

Fix define function args for content_template__new to use the 8 parameter version.

Options
    • -4
    • +15
    ./content-template.sql
    • -0
    • +11
    ./upgrade/upgrade-5.1.4d5-5.1.4d6.sql
  3. … 1 more file in changeset.
7:43 pm

daveb

file upgrade-5.1.4d5-5.1.4d6.sql was initially added on branch oacs-5-1.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.1.4d5-5.1.4d6.sql
5:52 pm

daveb

Fix __delete functions to have __del variant.

Options
    • -5
    • +13
    ./content-item.sql
    • -2
    • +12
    ./content-revision.sql
    • -2
    • +14
    ./content-template.sql
    • -0
    • +347
    ./upgrade/upgrade-5.2.0d9-5.2.0d10.sql
  5. … 2 more files in changeset.
5:38 pm

daveb

Create __del functions to match oracle.

Options
    • -0
    • +310
    ./upgrade/upgrade-5.1.4d4-5.1.4d5.sql
  2. … 1 more file in changeset.
5:38 pm

daveb

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

Options
    • -0
    • +0
    ./upgrade/upgrade-5.1.4d4-5.1.4d5.sql
5:31 pm

daveb

Add __del function to match oracle so package_exec_plsql will work

Options
    • -3
    • +13
    ./content-item.sql
    • -2
    • +13
    ./content-revision.sql
    • -2
    • +2
    ./content-template.sql
3:58 pm

cesarh

Adding the define "define_function_args('content_template__new','name,parent_id,template_id,creation_date,creation_user,creation_ip,text,is_live')" in the function content_template__new

Options
    • -98
    • +6
    ./content-template.sql
Wednesday 05 Jan 2005
4:39 pm

cesarh

Fixing the params in the function content_item__set_live_revision() changing the param item_id by revision_id

Options
    • -2
    • +2
    ./content-item.sql