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

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 47
Last Commit: 28 Dec 24
Commits this week: 0
Total Lines of Code (LoC): 77,885
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 8 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 28 Aug 2001
3:07 am

danw

modified content_item__get_path to match oracle version

Options
    • -87
    • +189
    ./postgresql/content-item.sql
Saturday 25 Aug 2001
4:22 pm

danw

removed circular dependency due to workflow

Options
    • -26
    • +38
    ./oracle/content-item.sql
    • -0
    • +2
    ./oracle/content-perms.sql
    • -4
    • +4
    ./oracle/content-test.sql
    • -0
    • +2
    ./oracle/doc-package.sql
    • -32
    • +38
    ./postgresql/content-item.sql
Friday 24 Aug 2001
6:07 am

danw

fixed a couple of typos in content_type__drop_attribute

Options
    • -3
    • +3
    ./postgresql/content-type.sql
12:50 am

danw

fixed get_path to match oracle version

Options
    • -84
    • +74
    ./postgresql/content-item.sql
Thursday 23 Aug 2001
4:26 am

danw

fixed exception message in content_type__drop_attribute

Options
    • -1
    • +3
    ./postgresql/content-item.sql
    • -5
    • +4
    ./postgresql/content-revision.sql
    • -2
    • +2
    ./postgresql/content-type.sql
Wednesday 22 Aug 2001
2:33 am

danw

reimplemented RI triggers for live_revision and latest_revision as user triggers

Options
    • -5
    • +147
    ./postgresql/content-create.sql
Tuesday 17 Jul 2001
1:46 am

danw

patch supplied by Dave Bauer to pass in security_inherit_p flag when creating new content_item. Work-around for data-change violation

Options
    • -1
    • +165
    ./postgresql/content-item.sql
Friday 06 Jul 2001
2:23 am

danw

workaround for content_item__delete problem related to pg RI problems

Options
    • -2
    • +2
    ./postgresql/content-item.sql
Tuesday 19 Jun 2001
6:36 am

danw

removed foreign key constraints on cr_item_publish_audit to work-aroudn a data-change violation bug in postgresql

Options
    • -10
    • +4
    ./postgresql/content-create.sql
Thursday 14 Jun 2001
2:52 pm

danw

minor change, content_revision__get_number should return a null if nothing is found

Options
    • -2
    • +2
    ./postgresql/content-revision.sql
2:11 pm

danw

work-around for pg referential integrity bug that causes content_revision__delete to fail

Options
    • -8
    • +8
    ./postgresql/content-revision.sql
2:23 am

danw

various bugfixes

Options
    • -0
    • +0
    ./postgresql/content-folder.sql
    • -17
    • +3
    ./postgresql/content-item.sql
    • -4
    • +3
    ./postgresql/content-revision.sql
    • -2
    • +1
    ./postgresql/content-type.sql
  5. … 1 more file in changeset.
Saturday 09 Jun 2001
9:26 pm

danw

fixed rule code for inserts on cr_revisionsi

Options
    • -2
    • +29
    ./postgresql/content-type.sql
3:06 am

danw

more cleanup

Options
    • -3
    • +3
    ./postgresql/content-item.sql
    • -9
    • +8
    ./postgresql/content-revision.sql
  3. … 6 more files in changeset.
Friday 08 Jun 2001
3:52 am

danw

fixed a few pl/sql procs

Options
    • -3
    • +3
    ./postgresql/content-folder.sql
    • -0
    • +0
    ./postgresql/content-item.sql
    • -3
    • +3
    ./postgresql/content-keyword.sql
Thursday 07 Jun 2001
2:04 am

danw

fixed tree query

Options
    • -2
    • +2
    ./postgresql/content-item.sql
Tuesday 05 Jun 2001
12:37 am

danw

fixed exception message in delete method

Options
    • -2
    • +4
    ./postgresql/content-folder.sql
Monday 04 Jun 2001
6:00 am

danw

fixed query in content_folder__unregister_content_type

Options
    • -2
    • +2
    ./postgresql/content-folder.sql
Wednesday 23 May 2001
12:46 am

danw

finished cleanup of data-model, it now loads without errors

Options
    • -2
    • +2
    ./postgresql/content-util.sql
  2. … 8 more files in changeset.
Thursday 17 May 2001
5:59 am

danw

fixed some bugs discovered by Vinod Kurup

Options
    • -3
    • +3
    ./postgresql/content-revision.sql
Sunday 13 May 2001
8:17 pm

danw

fixed up package display to work with postgresql

Options
    • -2
    • +5
    ./postgresql/doc-package.sql
  2. … 1 more file in changeset.
6:41 am

danw

catchall

Options
    • -2
    • +1
    ./postgresql/content-schedule.sql
    • -2
    • +2
    ./postgresql/content-type.sql
  3. … 1 more file in changeset.
3:55 am

danw

moved content repository job scheduling from oracle to aolsrver, that it is compatible with postgresql

Options
    • -33
    • +39
    ./oracle/content-schedule.sql
    • -2
    • +1
    ./postgresql/content-item.sql
    • -3
    • +3
    ./postgresql/content-revision.sql
    • -1
    • +8
    ./postgresql/content-schedule.sql
  5. … 1 more file in changeset.
Saturday 12 May 2001
7:09 am

danw

cleaned up content repository data-model and converted oracle apm to use file storage in the content repository

Options
    • -19
    • +1
    ./oracle/content-create.sql
    • -14
    • +6
    ./oracle/content-revision.sql
    • -0
    • +2
    ./oracle/packages-create.sql
    • -25
    • +2
    ./postgresql/content-create.sql
    • -19
    • +17
    ./postgresql/content-revision.sql
  6. … 7 more files in changeset.
Friday 11 May 2001
6:43 am

danw

added support for storing content repository items in the file system

Options
    • -3
    • +26
    ./oracle/content-create.sql
    • -7
    • +10
    ./oracle/content-item.sql
    • -8
    • +33
    ./oracle/content-revision.sql
    • -2
    • +12
    ./oracle/content-type.sql
    • -1
    • +2
    ./oracle/packages-create.sql
    • -6
    • +60
    ./postgresql/content-revision.sql
    • -8
    • +24
    ./postgresql/content-type.sql
  8. … 2 more files in changeset.
Wednesday 09 May 2001
7:15 am

danw

tested and fixed the template query db api

Options
    • -4
    • +1
    ./postgresql/doc-package.sql
  2. … 26 more files in changeset.
5:31 am

danw

fixed some errors in tree queries pointed out by Vinod Kurup

Options
    • -3
    • +3
    ./postgresql/content-revision.sql
    • -5
    • +5
    ./postgresql/content-type.sql
Friday 04 May 2001
8:04 am

danw

converted apm to store package tarballs in the content repository

Options
    • -1
    • +8
    ./postgresql/content-create.sql
  2. … 7 more files in changeset.
Thursday 03 May 2001
6:00 am

danw

tested lob support for content-repository. converted photo upload in acs-subsite to use lobs instead of files

Options
    • -6
    • +3
    ./postgresql/content-create.sql
  2. … 9 more files in changeset.
Tuesday 01 May 2001
6:37 am

danw

finished porting portrait upload to work with CR

Options
    • -1
    • +25
    ./postgresql/content-create.sql
  2. … 4 more files in changeset.