• last updated 14 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
merge from oacs-4-6

  1. … 129 more files in changeset.
Applied patch #500 for SDM # 1912 from Ken Kennedy: Can't change bookmark parent_id

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

    • -0
    • +0
    ./postgresql/upgrade/upgrade-4.1.1b-4.6.sql
- Upgrade scripts for acs-content-repository, acs-events, acs-kernel, acs-mail, acs-service-contract, bookmarks, faq, file-storage, news and search

- Bumped version of above packages to 4.6

- Fixed the view/sequence hack in apm-create so that APM package edit UI works in PG 7.2

  1. … 30 more files in changeset.
Applied patch #315 for SDM # 1595 from Peter Marklund: Can't delete bookmark in PG

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.

  1. … 74 more files in changeset.

Added code to make use of David Walker's wonderfully abusive hack on the

pg_proc table that showed me how to write recursive SQL functions. We now

have good use of the index on tree_sortkey when climbing the tree, woo-hoo!

  1. … 18 more files in changeset.

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

    • -81
    • +47
    ./postgresql/bookmarks-create.sql
  1. … 62 more files in changeset.

Some more speeding-up type activity...

  1. … 6 more files in changeset.
Fixed folder toggle to show/hide bookmarks under folders...

    • -31
    • +31
    ./postgresql/bookmarks-create.sql
Update to return type (integer to varchar) for bookmark__name

Hmmm. Methinks an index on bm_bookmarks.tree_sortkey might help with the performance issues...*grin*

Fixed error in bookmarks__new; context_id was not being set in acs_objects for all bookmarks -- added dead links checking

  1. … 7 more files in changeset.
Fixed error in sort order on index page. Added editing and viewing. Basic

functionality is working.

    • -44
    • +16
    ./postgresql/bookmarks-create.sql
  1. … 15 more files in changeset.
Fixed error in tree_sortkey insert trigger; hopefully tree_sortkey being created/updated properly now.

  1. … 4 more files in changeset.
Fixed error in bookmark__get_in_closed_p that was causing it to always return true...

Fix accidental edit to sql/oracle/bookmarks-create.sql...

Open/Close All Folders working...

    • -18
    • +10
    ./postgresql/bookmarks-create.sql
Updating proc file

  1. … 2 more files in changeset.
Fixing multiple functions without return values....oops!

    • -17
    • +15
    ./postgresql/bookmarks-create.sql
  1. … 3 more files in changeset.
'Create new folder' works.

    • -10
    • +12
    ./postgresql/bookmarks-create.sql
  1. … 9 more files in changeset.
Continuing to work on procs, index page now successfully loading...

    • -14
    • +17
    ./postgresql/bookmarks-create.sql
  1. … 4 more files in changeset.
Adding most-popular.xql queryfile

  1. … 1 more file in changeset.

Staring work with query porter and xql files. Done queries in tcl, and index files in www...

  1. … 10 more files in changeset.

Initial data model changes for OpenACS (Postgres added). bookmark.info

also updated. www files not yet touched

    • -0
    • +865
    ./postgresql/bookmarks-create.sql
    • -0
    • +162
    ./postgresql/bookmarks-drop.sql
  1. … 1 more file in changeset.

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

  1. … 2478 more files in changeset.
Initial revision

    • -0
    • +747
    ./oracle/bookmarks-create.sql
    • -0
    • +75
    ./oracle/bookmarks-drop.sql
  1. … 2478 more files in changeset.