OpenACS / openacs-4 / packages / cms / sql

postgresql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 11
Last Commit: 20 Dec
Commits this week: 0
Total Lines of Code (LoC): 4,551
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 18 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Friday 20 Sep 2002
5:54 am

danw

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

Options
    • -6
    • +9
    ./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
    ./cms-publishing-wf.sql
  2. … 74 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
    ./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
    ./cms-permissions.sql
Monday 19 Nov 2001
8:47 pm

neophytosd

initial revision of acs-workflow-4.3

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

neophytosd

initial revision of acs-workflow-4.3

Options
    • -215
    • +333
    ./cms-publishing-wf.sql
  2. … 20 more files in changeset.
Wednesday 29 Aug 2001
1:31 am

danw

more cleanup of cms - content upload and display

Options
    • -1
    • +1
    ./cms-workflow.sql
  2. … 9 more files in changeset.
Friday 24 Aug 2001
4:42 pm

vinodk

converted notification calls to acs_mail_nt calls

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

danw

more bugfixes

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

danw

more cleanup

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

danw

more cleanup of cms

Options
    • -1
    • +1
    ./cms-content-methods.sql
    • -3
    • +3
    ./cms-permissions.sql
    • -1
    • +1
    ./cms-widgets.sql
    • -2
    • +2
    ./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
    ./cms-create.sql
    • -13
    • +13
    ./cms-fix.sql
    • -6
    • +6
    ./cms-forms.sql
    • -35
    • +91
    ./cms-permissions.sql
    • -2
    • +2
    ./cms-publishing-wf.sql
    • -1
    • +1
    ./cms-update.sql
    • -1
    • +1
    ./cms-widgets.sql
    • -7
    • +7
    ./cms-workflow.sql
  9. … 1 more file in changeset.
Tuesday 22 May 2001
6:44 am

danw

more cleanup

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

danw

more cleanup

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

danw

more cleanup

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

danw

more cleanup

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

danw

more porting work

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

danw

started porting work

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

danw

created postgresql sql directory

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