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 4 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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
Wednesday 29 Dec 2004
4:29 pm

daveb

Fix default for creation date in cotnent_template__new

Options
    • -0
    • +11
    ./upgrade/upgrade-5.2.0d8-5.2.0d9.sql
  2. … 1 more file in changeset.
4:26 pm

daveb

Set default for creation_date in content_template__new

Options
    • -1
    • +4
    ./upgrade/upgrade-5.1.4d3-5.1.4d4.sql
4:19 pm

daveb

Return new folder_id from content_folder__new

Options
    • -0
    • +127
    ./upgrade/upgrade-5.1.4d3-5.1.4d4.sql
  2. … 1 more file in changeset.
4:19 pm

daveb

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

Options
    • -0
    • +0
    ./upgrade/upgrade-5.1.4d3-5.1.4d4.sql
Wednesday 22 Dec 2004
5:13 pm

daveb

Set package_id from content_folder__new

Options
    • -5
    • +40
    ./content-folder.sql
    • -0
    • +129
    ./upgrade/upgrade-5.1.4d2-5.1.4d3.sql
  3. … 1 more file in changeset.
5:13 pm

daveb

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

Options
    • -0
    • +0
    ./upgrade/upgrade-5.1.4d2-5.1.4d3.sql
Tuesday 21 Dec 2004
7:22 pm

daveb

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

Options
    • -0
    • +0
    ./upgrade/upgrade-5.1.4d1-5.1.4d2.sql
7:22 pm

daveb

Add CR Tcl API from HEAD.

Options
    • -2
    • +5
    ./content-extlink.sql
    • -2
    • +16
    ./content-folder.sql
    • -14
    • +36
    ./content-item.sql
    • -1
    • +10
    ./content-revision.sql
    • -1
    • +6
    ./content-symlink.sql
    • -1
    • +16
    ./content-type.sql
    • -0
    • +97
    ./upgrade/upgrade-5.1.4d1-5.1.4d2.sql
  8. … 11 more files in changeset.
Friday 15 Oct 2004
10:49 am

maltes

Change needed due to dependecies

Options
    • -0
    • +16
    ./upgrade/upgrade-4.5-4.6.sql
  2. … 1 more file in changeset.
Tuesday 21 Sep 2004
2:00 am

rocaelh

better performance for null parent cr query, by don

Options
    • -3
    • +3
    ./content-create.sql
    • -2
    • +117
    ./upgrade/upgrade-5.1.2d6-5.1.2d7.sql
Monday 06 Sep 2004
6:43 pm

rocaelh

adding cr_items(name) index on the creation of the pkg

Options
    • -1
    • +2
    ./content-create.sql
  2. … 1 more file in changeset.