OpenACS / openacs-4 / packages / cms

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 12
Last Commit: 13:14
Commits this week: 0
Total Lines of Code (LoC): 8,978
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 9 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Monday 06 Jan 2003
3:05 am

bartt

Removed dublicate declaration of content_module__new (varchar,varchar,integer,integer,integer)

Options
    • -7
    • +1
    ./postgresql/cms-create.sql
Saturday 21 Dec 2002
11:27 pm

bartt

Patches to make OpenACS PG 7.3 compatible.

Options
    • -2
    • +14
    ./postgresql/cms-create.sql
    • -0
    • +12
    ./postgresql/cms-forms.sql
    • -1
    • +1
    ./postgresql/cms-workflow.sql
  4. … 52 more files in changeset.
Saturday 30 Nov 2002
6:22 pm

jeffd

merge from oacs-4-6

Options
    • -1
    • +1
    ./postgresql/cms-publishing-wf.sql
  2. … 130 more files in changeset.
Tuesday 08 Oct 2002
7:03 pm

danw

fixed bug in publishing workflow

Options
    • -1
    • +1
    ./postgresql/cms-publishing-wf.sql
Wednesday 25 Sep 2002
6:11 am

danw

updating oracle workflow

Options
    • -45
    • +117
    ./oracle/cms-publishing-wf.sql
    • -7
    • +14
    ./postgresql/cms-publishing-wf.sql
  3. … 2 more files in changeset.
Tuesday 24 Sep 2002
10:47 pm

danw

hacking on publishing workflow to make it compatible with workflow 4.3 - pg version seems to work now, but I pity the fool that actually tries to use it

Options
    • -359
    • +292
    ./postgresql/cms-publishing-wf.sql
  2. … 5 more files in changeset.
Friday 20 Sep 2002
5:54 am

danw

fixed tree query in cms permissions - error left over from tree_sortkey change

Options
    • -6
    • +9
    ./postgresql/cms-permissions.sql
Saturday 09 Mar 2002
3:00 am

donb

1. Changed a lot of package info files to fix problems ...

2. Added Vinod's bboard patch

3. Rationalized party e-mail checking by putting a "before insert or update"

trigger on the table that lower-cases email (this was already done by the

party.new() func but at least one update missed this). Got rid of all

"lower(email) = " and "upper(email) = " checks and just made all use the

db email column directly and lower-cased Tcl vars. In this way the index

on the email column is always and consistently used without needing to

define functional indexes on the column (an EE feature for Oracle).

4. Rationalized naming of a couple of workflows and fixed a glossary PG bug

where apparently its workflow got overwritten by one from the CMS at some

point in time.

5. Made the .cmp/.dat/.frm filters in the template code usable though not

very beautiful nor exactly correct. But with practice you can use them

to debug pages in the packages/* hierarchy. I also turned these off by

default as there's no need to run these filters on a production site!

6. Performed minor surgery on templating, including adding a new

"ad_return_exception_template" that allows you to return a templated

error page and aborts the script.

7. ??? probably but I think this covers most stuff.

Options
    • -2
    • +2
    ./oracle/cms-publishing-wf.sql
    • -2
    • +2
    ./postgresql/cms-publishing-wf.sql
  3. … 73 more files in changeset.
Saturday 08 Dec 2001
2:17 am

donb

Changed the representation of tree_sortkeys from "text" to "bit varying".

Options
    • -14
    • +11
    ./postgresql/cms-permissions.sql
  2. … 62 more files in changeset.
Monday 26 Nov 2001
10:43 pm

donb

Ouch - an error in a trigger killed, among another things killing some

bboard posting stuff.

Options
    • -2
    • +2
    ./postgresql/cms-permissions.sql
Monday 19 Nov 2001
8:47 pm

neophytosd

initial revision of acs-workflow-4.3

Options
    • -1
    • +1
    ./postgresql/cms-workflow.sql
7:34 pm

neophytosd

initial revision of acs-workflow-4.3

Options
    • -206
    • +388
    ./oracle/cms-publishing-wf.sql
    • -215
    • +333
    ./postgresql/cms-publishing-wf.sql
  3. … 19 more files in changeset.
Tuesday 04 Sep 2001
6:50 am

danw

fixed closing of cursors after an exception

Options
    • -0
    • +6
    ./oracle/cms-workflow.sql
  2. … 4 more files in changeset.
Wednesday 29 Aug 2001
1:31 am

danw

more cleanup of cms - content upload and display

Options
    • -1
    • +1
    ./postgresql/cms-workflow.sql
  2. … 9 more files in changeset.
Monday 27 Aug 2001
5:59 am

danw

more cleanup of oracle cursors and cms porting work

Options
    • -1
    • +1
    ./oracle/cms-workflow.sql
  2. … 9 more files in changeset.
Sunday 26 Aug 2001
3:39 pm

danw

fixed cursors that were not being closed in the core

Options
    • -0
    • +1
    ./oracle/cms-permissions.sql
  2. … 3 more files in changeset.
Friday 24 Aug 2001
4:42 pm

vinodk

converted notification calls to acs_mail_nt calls

Options
    • -1
    • +1
    ./oracle/cms-workflow.sql
    • -11
    • +9
    ./postgresql/cms-workflow.sql
  3. … 8 more files in changeset.
Thursday 14 Jun 2001
2:28 am

danw

more bugfixes

Options
    • -7
    • +7
    ./postgresql/cms-publishing-wf.sql
    • -6
    • +6
    ./postgresql/cms-workflow.sql
  3. … 5 more files in changeset.
Tuesday 12 Jun 2001
6:13 am

danw

more cleanup

Options
    • -1
    • +0
    ./postgresql/cms-workflow.sql
  2. … 52 more files in changeset.
Friday 08 Jun 2001
3:44 am

danw

more cleanup of cms

Options
    • -1
    • +1
    ./postgresql/cms-content-methods.sql
    • -3
    • +3
    ./postgresql/cms-permissions.sql
    • -1
    • +1
    ./postgresql/cms-widgets.sql
    • -2
    • +2
    ./postgresql/cms-workflow.sql
  5. … 99 more files in changeset.
Wednesday 23 May 2001
12:46 am

danw

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

Options
    • -7
    • +8
    ./postgresql/cms-create.sql
    • -13
    • +13
    ./postgresql/cms-fix.sql
    • -6
    • +6
    ./postgresql/cms-forms.sql
    • -35
    • +91
    ./postgresql/cms-permissions.sql
    • -2
    • +2
    ./postgresql/cms-publishing-wf.sql
    • -1
    • +1
    ./postgresql/cms-update.sql
    • -1
    • +1
    ./postgresql/cms-widgets.sql
    • -7
    • +7
    ./postgresql/cms-workflow.sql
  9. … 1 more file in changeset.
Tuesday 22 May 2001
6:44 am

danw

more cleanup

Options
    • -72
    • +108
    ./postgresql/rel-test.sql
6:26 am

danw

more cleanup

Options
    • -37
    • +37
    ./postgresql/cms-content-methods.sql
    • -7
    • +7
    ./postgresql/cms-permissions.sql
    • -2
    • +2
    ./postgresql/cms-workflow.sql
5:58 am

danw

more cleanup

Options
    • -3
    • +3
    ./postgresql/cms-create.sql
    • -10
    • +10
    ./postgresql/cms-forms.sql
    • -5
    • +5
    ./postgresql/cms-permissions.sql
5:47 am

danw

more cleanup

Options
    • -39
    • +38
    ./postgresql/cms-workflow.sql
1:13 am

danw

more porting work

Options
    • -0
    • +0
    ./postgresql/cms-create.sql
    • -0
    • +0
    ./postgresql/cms-fix.sql
    • -630
    • +657
    ./postgresql/cms-permissions.sql
    • -68
    • +90
    ./postgresql/cms-publishing-wf.sql
    • -27
    • +52
    ./postgresql/cms-update.sql
    • -150
    • +192
    ./postgresql/cms-widgets.sql
    • -968
    • +876
    ./postgresql/cms-workflow.sql
Sunday 20 May 2001
6:49 am

danw

started porting work

Options
    • -141
    • +162
    ./postgresql/cms-content-methods.sql
    • -166
    • +224
    ./postgresql/cms-create.sql
    • -74
    • +91
    ./postgresql/cms-fix.sql
    • -228
    • +223
    ./postgresql/cms-forms.sql
Saturday 19 May 2001
3:20 am

danw

created postgresql sql directory

Options
    • -0
    • +298
    ./postgresql/cms-content-methods.sql
    • -0
    • +243
    ./postgresql/cms-create.sql
    • -0
    • +4
    ./postgresql/cms-drop.sql
    • -0
    • +115
    ./postgresql/cms-fix.sql
    • -0
    • +415
    ./postgresql/cms-forms.sql
    • -0
    • +859
    ./postgresql/cms-permissions.sql
    • -0
    • +243
    ./postgresql/cms-publishing-wf.sql
    • -0
    • +60
    ./postgresql/cms-update.sql
    • -0
    • +295
    ./postgresql/cms-widgets.sql
    • -0
    • +1464
    ./postgresql/cms-workflow.sql
    • -0
    • +131
    ./postgresql/rel-test.sql
Friday 20 Apr 2001
10:51 pm

donb

Forgot to define binary files before importing, so .gifs were messed up.

Options
    • -0
    • +0
    ./oracle/cms-content-methods.sql
    • -0
    • +0
    ./oracle/cms-create.sql
    • -0
    • +0
    ./oracle/cms-drop.sql
    • -0
    • +0
    ./oracle/cms-fix.sql
    • -0
    • +0
    ./oracle/cms-forms.sql
    • -0
    • +0
    ./oracle/cms-permissions.sql
    • -0
    • +0
    ./oracle/cms-publishing-wf.sql
    • -0
    • +0
    ./oracle/cms-update.sql
    • -0
    • +0
    ./oracle/cms-widgets.sql
    • -0
    • +0
    ./oracle/cms-workflow.sql
    • -0
    • +0
    ./oracle/rel-test.sql
  12. … 2469 more files in changeset.
10:51 pm

donb

Initial revision

Options
    • -0
    • +298
    ./oracle/cms-content-methods.sql
    • -0
    • +243
    ./oracle/cms-create.sql
    • -0
    • +4
    ./oracle/cms-drop.sql
    • -0
    • +115
    ./oracle/cms-fix.sql
    • -0
    • +415
    ./oracle/cms-forms.sql
    • -0
    • +859
    ./oracle/cms-permissions.sql
    • -0
    • +243
    ./oracle/cms-publishing-wf.sql
    • -0
    • +60
    ./oracle/cms-update.sql
    • -0
    • +295
    ./oracle/cms-widgets.sql
    • -0
    • +1464
    ./oracle/cms-workflow.sql
    • -0
    • +131
    ./oracle/rel-test.sql
  12. … 2469 more files in changeset.