• last updated 6 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)

    • -15
    • +15
    ./oracle/simple-survey-package-create.sql
  1. … 275 more files in changeset.
merge of 4.6.3b1 to HEAD

  1. … 29 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 ...

  1. … 14 more files in changeset.
forgot about all of the trigger work-arounds for data-change violation problem that no longer exists. Fixed now.

    • -10
    • +1
    ./postgresql/simple-survey-create.sql
  1. … 7 more files in changeset.
fix the object attributes (table, column name)

  1. … 2 more files in changeset.
add package_id to survsimp_surveys and __new function

Trailing comma after the last column in a create table doesn't work ...

undo bad commit

    • -101
    • +4
    ./oracle/simple-survey-package-create.sql
  1. … 7 more files in changeset.
use 'scoped_p' instead of 'style' to determine which view to present

    • -4
    • +101
    ./oracle/simple-survey-package-create.sql
  1. … 7 more files in changeset.
splitting out package creation in preparation for adding functionality

    • -251
    • +2
    ./oracle/simple-survey-create.sql
    • -0
    • +232
    ./oracle/simple-survey-package-create.sql
    • -0
    • +3
    ./oracle/simple-survey-package-drop.sql
  1. … 2 more files in changeset.
fixing up survey

  1. … 11 more files in changeset.
fixing the package for better scoping

  1. … 3 more files in changeset.

renamed files to package-name-create/drop format so that the APM will recognize it during installation.

    • -0
    • +584
    ./postgresql/simple-survey-create.sql
    • -0
    • +73
    ./postgresql/simple-survey-drop.sql
    • -584
    • +0
    ./postgresql/survsimp-create.sql

renamed the files to package-name-create/drop.sql so the APM will recognize it

    • -0
    • +548
    ./oracle/simple-survey-create.sql
    • -0
    • +69
    ./oracle/simple-survey-drop.sql

removed logical_negation because it was already defined in utilities-create.sql in acs-kernel

removed definition of logical_negation because it is already defined in utilities-create.sql in acs-kernel

    • -16
    • +17
    ./postgresql/survsimp-create.sql

changed number to numeric

*** empty log message ***

    • -0
    • +583
    ./postgresql/survsimp-create.sql
    • -0
    • +72
    ./postgresql/survsimp-drop.sql
  1. … 54 more files in changeset.
ported simple survey to postgresql, tested for postgresql, not tested on Oracle

  1. … 12 more files in changeset.

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

  1. … 2478 more files in changeset.
Initial revision

    • -0
    • +524
    ./oracle/survsimp-create.sql
    • -0
    • +32
    ./oracle/survsimp-drop.sql
  1. … 2478 more files in changeset.