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: 14 Nov
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 1 hour ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Thursday 09 Jun 2005
11:15 pm

michaels

a few install/instantiation tweaks and a first stab at a new index.vuh

Options
    • -2
    • +3
    ./oracle/cms-create.sql
    • -2
    • +3
    ./postgresql/cms-create.sql
  3. … 7 more files in changeset.
Tuesday 07 Jun 2005
10:54 pm

michaels

add 2 tables to (still deficient) drop scripts

Options
    • -1
    • +3
    ./oracle/cms-drop.sql
    • -1
    • +3
    ./postgresql/cms-drop.sql
10:53 pm

michaels

forgot ;

Options
    • -2
    • +2
    ./oracle/cms-create.sql
10:51 pm

michaels

forgot a ;

Options
    • -2
    • +2
    ./postgresql/cms-create.sql
Monday 06 Jun 2005
7:07 pm

michaels

map content/template roots to package id and look up those roots based on current subsite (using new subsite_package_map table)

Options
    • -2
    • +13
    ./oracle/cms-create.sql
    • -1
    • +9
    ./postgresql/cms-create.sql
  3. … 33 more files in changeset.
Wednesday 18 May 2005
7:13 pm

michaels

small typo

Options
    • -2
    • +2
    ./postgresql/cms-create.sql
Tuesday 10 May 2005
12:44 am

michaels

more UI tweaks and some data model changes; instatiating cms now creates a set of modules with appropriate permissions making it possible to mount more than one instance

Options
    • -26
    • +49
    ./oracle/cms-create.sql
    • -39
    • +71
    ./postgresql/cms-create.sql
  3. … 57 more files in changeset.
Monday 11 Apr 2005
7:14 pm

michaels

remove acs-workflow and custom permissions from create scripts, bump version to 5.0d and update dependencies

Options
    • -2
    • +2
    ./oracle/cms-create.sql
    • -22
    • +22
    ./oracle/cms-update.sql
    • -4
    • +4
    ./postgresql/cms-create.sql
    • -23
    • +23
    ./postgresql/cms-update.sql
  5. … 1 more file in changeset.
Thursday 07 Apr 2005
12:06 am

michaels

add richtext widget

Options
    • -0
    • +16
    ./oracle/cms-widgets.sql
    • -0
    • +16
    ./postgresql/cms-widgets.sql
  3. … 1 more file in changeset.
Tuesday 16 Nov 2004
11:32 pm

michaels

first pass at facelift. still much to do (see todo file in root of package for somewhat random collection of ideas). haven't touched data model so cms will likely still require acs-workflow v4.5 to work w/o error

Options
    • -1
    • +1
    ./oracle/cms-create.sql
    • -1
    • +1
    ./oracle/cms-fix.sql
    • -1
    • +1
    ./postgresql/cms-create.sql
    • -1
    • +1
    ./postgresql/cms-fix.sql
  5. … 124 more files in changeset.
Tuesday 30 Sep 2003
2:10 pm

mohanp

Oracle9i porting changes

- Changed procedure names from delete to del

- Changed view declaration to use actual column names

- Changed "rel_constraints_violated_one" and "rel_constraints_violated_two"

(http://openacs.org/forums/message-view?message_id=81045)

Options
    • -2
    • +2
    ./oracle/cms-fix.sql
  2. … 275 more files in changeset.
Saturday 17 May 2003
12:16 pm

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -7
    • +7
    ./postgresql/cms-content-methods.sql
    • -8
    • +8
    ./postgresql/cms-create.sql
    • -2
    • +2
    ./postgresql/cms-fix.sql
    • -99
    • +7
    ./postgresql/cms-forms.sql
    • -19
    • +19
    ./postgresql/cms-permissions.sql
    • -3
    • +3
    ./postgresql/cms-publishing-wf.sql
    • -3
    • +3
    ./postgresql/cms-update.sql
    • -5
    • +5
    ./postgresql/cms-widgets.sql
    • -25
    • +25
    ./postgresql/cms-workflow.sql
    • -2
    • +2
    ./postgresql/rel-test.sql
    • -0
    • +146
    ./postgresql/upgrade/upgrade-4.6-4.6.1.sql
  12. … 66 more files in changeset.
Sunday 02 Mar 2003
11:32 pm

donb

I've changed "timestamp" to "timestamptz" and have begun fixing some

code that used to be legal but as of PG 7.3 is not. You can no longer

subtract an integer from a timestamp but must cast to date, "timestamp"

disappeared (must use "interval" now), "datetime" disappeared ("timestamptz"),

and suchwhat.

Not done but closer than it was before ...

Options
    • -2
    • +2
    ./postgresql/cms-create.sql
    • -1
    • +1
    ./postgresql/cms-workflow.sql
  3. … 52 more files in changeset.
Sunday 23 Feb 2003
7:19 pm

danw

forgot about all of the trigger work-arounds for data-change violation problem that no longer exists. Fixed now.

Options
    • -7
    • +0
    ./postgresql/cms-permissions.sql
  2. … 7 more files in changeset.
Tuesday 11 Feb 2003
6:08 pm

donb

file upgrade-4.6-4.6.1.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-4.6-4.6.1.sql
6:03 pm

donb

1. Fixed a couple of typos in file storage

2. New fast permissions stuff (PG only thus far)

2. While poking around CMS code looking for things that needed recreating

due to the permissions upgrade, changed over to "create or replace function"

Options
    • -7
    • +7
    ./postgresql/cms-content-methods.sql
    • -8
    • +8
    ./postgresql/cms-create.sql
    • -2
    • +2
    ./postgresql/cms-fix.sql
    • -100
    • +6
    ./postgresql/cms-forms.sql
    • -19
    • +19
    ./postgresql/cms-permissions.sql
    • -3
    • +3
    ./postgresql/cms-publishing-wf.sql
    • -3
    • +3
    ./postgresql/cms-update.sql
    • -5
    • +5
    ./postgresql/cms-widgets.sql
    • -25
    • +25
    ./postgresql/cms-workflow.sql
    • -2
    • +2
    ./postgresql/rel-test.sql
    • -0
    • +146
    ./postgresql/upgrade/upgrade-4.6-4.6.1.sql
  12. … 13 more files in changeset.
Thursday 06 Feb 2003
4:56 pm

jeffd

merge barts removal of duped cm_form_widget__set_attribute_param_value declare

Options
    • -6
    • +1
    ./postgresql/cms-forms.sql
Friday 31 Jan 2003
9:26 pm

jeffd

merge Barts fix for duplicate content_module__new from head

Options
    • -7
    • +1
    ./postgresql/cms-create.sql
Tuesday 21 Jan 2003
2:45 pm

jeffd

merge bartt PG 7.3 fixes from HEAD

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.
Wednesday 08 Jan 2003
7:41 pm

bartt

Removed duplicate function declaration.

Options
    • -6
    • +1
    ./postgresql/cms-forms.sql
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