• last updated 7 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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)

    • -23
    • +23
    ./sql/oracle/address-book-create.sql
  1. … 266 more files in changeset.
Part of the fix for bug #814.

noquote changes (Dirk Gomez)

  1. … 122 more files in changeset.
merge of 4.6.3b1 to HEAD

    • -4
    • +4
    ./sql/postgresql/address-book-create.sql
    • -4
    • +4
    ./sql/postgresql/address-book-drop.sql
  1. … 181 more files in changeset.

1. Made it possible to upgrade from acs-kernel 4.6.1 to acs-kernel 4.6.2

by using the APM rather than running the upgrade script by hand from

PSQL or SQL*Plus.

2. Changed a bunch of package .info files to depend on acs-kernel 4.6.2

to force the APM to upgrade acs-kernel (and therefore the APM datamodel)

before anything else. No guarantee on this though since not all

packages properly define their dependence on the kernel, it appears.

3. Whacked the release notes to suggest people use the APM to upgrade

acs-kernel first, other package later, just for safety's sake.

4. Fixed goof-up in acs-subsite I accidently introduced.

  1. … 35 more files in changeset.
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 ...

    • -4
    • +4
    ./sql/postgresql/address-book-create.sql
    • -4
    • +4
    ./sql/postgresql/address-book-drop.sql
  1. … 52 more files in changeset.
merge from oacs-4-6

  1. … 129 more files in changeset.
cleanup on .xql files, add rdbms tags to db specific files, clean XML, etc

  1. … 28 more files in changeset.
cleanup javadoc tags (eg @cvs_id @cvs @cvs-id: instead if @cvs-id)

  1. … 688 more files in changeset.
remove superfluous package local masters and use sitewide master by default

  1. … 688 more files in changeset.
pass context_bar and title up to master template

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.

Minor fixes ...

mostly fixing reference data to work with PG ...

    • -1
    • +4
    ./sql/postgresql/address-book-create.sql
  1. … 16 more files in changeset.

More work on acs-references and address-book.

  1. … 6 more files in changeset.

Got drop and create to play together, finally!

    • -11
    • +11
    ./sql/postgresql/address-book-create.sql
    • -12
    • +21
    ./sql/postgresql/address-book-drop.sql

Started on address book, still a lot of work to do.

made minor improvements to "packages-install" in the APM.

    • -137
    • +69
    ./sql/postgresql/address-book-create.sql
    • -90
    • +11
    ./sql/postgresql/address-book-drop.sql
    • -24
    • +2
    ./www/address-delete-postgresql.xql
    • -16
    • +13
    ./www/contact-delete-postgresql.xql
  1. … 3 more files in changeset.
RAC: Added *xql missing from previous commit

    • -0
    • +69
    ./tcl/address-book-procs.xql
    • -0
    • +11
    ./www/address-ae-2.xql
    • -0
    • +42
    ./www/address-delete-oracle.xql
    • -0
    • +46
    ./www/address-delete-postgresql.xql
    • -0
    • +18
    ./www/address-delete.xql
    • -0
    • +25
    ./www/address-swap-oracle.xql
    • -0
    • +28
    ./www/address-swap-postgresql.xql
    • -0
    • +11
    ./www/address-swap.xql
    • -0
    • +30
    ./www/attr-ae-2-oracle.xql
    • -0
    • +34
    ./www/attr-ae-2-postgresql.xql
    • -0
    • +15
    ./www/attr-delete-oracle.xql
    • -0
    • +17
    ./www/attr-delete-postgresql.xql
    • -0
    • +15
    ./www/attr-delete.xql
  1. … 14 more files in changeset.
RAC (Nov 23, 2001): Unfinished port for address-book.

The places package needs to be replaced by acs-references. This makes the data model file crash. The *xql files were created but untouched.

    • -0
    • +932
    ./sql/postgresql/address-book-create.sql
    • -0
    • +141
    ./sql/postgresql/address-book-drop.sql

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

  1. … 2465 more files in changeset.
Initial revision

    • -0
    • +246
    ./doc/design.html
    • -0
    • +214
    ./doc/requirements.html
    • -0
    • +826
    ./sql/oracle/address-book-create.sql
    • -0
    • +99
    ./sql/oracle/address-book-drop.sql
    • -0
    • +169
    ./tcl/address-book-procs.tcl
    • -0
    • +37
    ./www/address-ae-2.tcl
    • -0
    • +13
    ./www/address-ae.adp
    • -0
    • +42
    ./www/address-ae.tcl
    • -0
    • +59
    ./www/address-delete.tcl
    • -0
    • +40
    ./www/address-swap.tcl
  1. … 2465 more files in changeset.