• last updated 9 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Add SQL query for oracle

Remove 'exit' lines that caused datamodel to be incompletely installed. Comment out creation of triggers for forums, static-portal, acs-events, faq, survey and photobook (should go in their own package)

Remove refereces to "images" in the attach file dialog.

remove remaining comma added by mistake during my last commit

Show times on edit.

SHow attachment link all the time, if its enabled, not just if another

attachment exists.

Use a similar dialog for attaching links to files (and uploading the files).

The logic was too complex to support both in one file, this is alot easier to understand and debug.

Fix #2981: table_name and id_column must be null for acs_message_revision object type

Add page to show image properties

Add proc to find the thumbnail for a particular image.

Estract SQL code to xql files

file lors-test-procs-oracle.xql was initially added on branch lors-oracle-port.

    • -0
    • +0
    /openacs-4/packages/lors/tcl/test/lors-test-procs-oracle.xql
file lors-test-procs.xql was initially added on branch lors-oracle-port.

    • -0
    • +0
    /openacs-4/packages/lors/tcl/test/lors-test-procs.xql
file lors-test-procs-postgresql.xql was initially added on branch lors-oracle-port.

Extract SQL code to: generic xql, postgres xql and oracle xql

Modify datamodel names to Oracle compatibility

    • -6
    • +6
    /openacs-4/packages/lors/tcl/lors-cr-procs.tcl
    • -0
    • +7
    /openacs-4/packages/lors/tcl/lors-cr-procs.xql
    • -162
    • +26
    /openacs-4/packages/lors/tcl/lors-imscp-procs.tcl
    • -0
    • +105
    /openacs-4/packages/lors/tcl/lors-imscp-procs.xql
    • -130
    • +35
    /openacs-4/packages/lors/tcl/lors-imsmd-procs.tcl
    • -0
    • +204
    /openacs-4/packages/lors/tcl/lors-imsmd-procs.xql
file lors-assessment-procs.xql was initially added on branch lors-oracle-port.

    • -0
    • +0
    /openacs-4/packages/lors/tcl/lors-assessment-procs.xql
file lors-imsmd-sc-procs.xql was initially added on branch lors-oracle-port.

    • -0
    • +0
    /openacs-4/packages/lors/tcl/lors-imsmd-sc-procs.xql
file lors-imsmd-procs.xql was initially added on branch lors-oracle-port.

    • -0
    • +0
    /openacs-4/packages/lors/tcl/lors-imsmd-procs.xql
file lors-imscp-procs.xql was initially added on branch lors-oracle-port.

    • -0
    • +0
    /openacs-4/packages/lors/tcl/lors-imscp-procs.xql
file lors-imscp-procs-oracle.xql was initially added on branch lors-oracle-port.

file lors-cr-procs.xql was initially added on branch lors-oracle-port.

    • -0
    • +0
    /openacs-4/packages/lors/tcl/lors-cr-procs.xql
file lors-cr-procs-postgresql.xql was initially added on branch lors-oracle-port.

file lors-cr-procs-oracle.xql was initially added on branch lors-oracle-port.

    • -0
    • +0
    /openacs-4/packages/lors/tcl/lors-cr-procs-oracle.xql
Oracle datamodel for package lors

file lors-imsmd-sc-create.sql was initially added on branch lors-oracle-port.

    • -0
    • +0
    /openacs-4/packages/lors/sql/oracle/lors-imsmd-sc-create.sql
file lors-imsmd-drop.sql was initially added on branch lors-oracle-port.

    • -0
    • +0
    /openacs-4/packages/lors/sql/oracle/lors-imsmd-drop.sql
file lors-imsmd-create.sql was initially added on branch lors-oracle-port.

file lors-imscp-package-create.sql was initially added on branch lors-oracle-port.

file lors-imscp-drop.sql was initially added on branch lors-oracle-port.

    • -0
    • +0
    /openacs-4/packages/lors/sql/oracle/lors-imscp-drop.sql
file lors-imscp-create.sql was initially added on branch lors-oracle-port.

file lors-drop.sql was initially added on branch lors-oracle-port.

    • -0
    • +0
    /openacs-4/packages/lors/sql/oracle/lors-drop.sql