• last updated 3 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Fixes for Oracle 19c: quick port of missing tables in acs-mail-lite from PostgreSQL

This is q quick port of the table available from PostgreSQL, which

assures that a new instance of OpenACS on Oracle can run without

spitting out frequent error messages. In essence, the sequence

handling was adjusted, and datatype "text" was replaced by

"varchar(4000)" and in one case by "clob". Probably, some of the

lengths and the update operations have to be adjusted.

    • -1
    • +349
    ./oracle/acs-mail-lite-create.sql
Index acs_mail_lite_queue(package_id)

    • -0
    • +2
    ./postgresql/upgrade/upgrade-5.10.0d11-5.10.0d12.sql
  1. … 1 more file in changeset.
file upgrade-5.10.0d11-5.10.0d12.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.0d11-5.10.0d12.sql
make packages in principle installable under PG 13+

  1. … 19 more files in changeset.
Fix typo in description

    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.10.0d9-5.10.0d10.sql
Drop duplicate index 'acs_mail_lite_from_external_aml_email_id_idx'. Postgres creates automatically indexes for unique constraints and primary keys, this index duplicates 'acs_mail_lite_from_external_pkey'

    • -0
    • +8
    ./postgresql/upgrade/upgrade-5.10.0d10-5.10.0d11.sql
  1. … 1 more file in changeset.
file upgrade-5.10.0d10-5.10.0d11.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.0d10-5.10.0d11.sql
Whitespace changes

    • -64
    • +64
    ./postgresql/acs-mail-lite-create.sql
Drop duplicate index 'acs_mail_lite_send_msg_id_map_msg_id_idx'. Postgres creates automatically indexes for unique constraints and primary keys, this index duplicates 'acs_mail_lite_send_msg_id_map_pkey'

    • -0
    • +8
    ./postgresql/upgrade/upgrade-5.10.0d9-5.10.0d10.sql
  1. … 1 more file in changeset.
file upgrade-5.10.0d9-5.10.0d10.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.10.0d9-5.10.0d10.sql
improve spelling

    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.10.0d1-5.10.0d2.sql
  1. … 8 more files in changeset.
Speed up referential integrity by avoiding sequential scans

    • -0
    • +24
    ./postgresql/upgrade/upgrade-5.10.0d6-5.10.0d7.sql
  1. … 1 more file in changeset.
Fix typos

    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.10.0d1-5.10.0d2.sql
  1. … 27 more files in changeset.
Fix typos

    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.10.0d1-5.10.0d2.sql
  1. … 61 more files in changeset.
Fix typos

    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.10.0d1-5.10.0d2.sql
  1. … 41 more files in changeset.
Fix even more typos

    • -1
    • +1
    ./postgresql/upgrade/upgrade-5.10.0d1-5.10.0d2.sql
  1. … 28 more files in changeset.
*** empty log message ***

    • -0
    • +15
    ./postgresql/upgrade/upgrade-5.10.0d3-5.10.0d4.sql
  1. … 1 more file in changeset.
merge with changes from https://github.com/tekbasse/acs-mail-lite/tree/master/tcl

in essence, these changes provide support for handling email with attachments based on nsIMAP.

see https://openacs.org/forums/message-view?message_id=5378972 for more background

    • -1
    • +358
    ./postgresql/acs-mail-lite-create.sql
    • -2
    • +42
    ./postgresql/acs-mail-lite-drop.sql
    • -0
    • +356
    ./postgresql/upgrade/upgrade-5.10.0d1-5.10.0d2.sql
  1. … 69 more files in changeset.
merged changes from the oacs-5-9 branch and resolved conflicts

  1. … 7833 more files in changeset.
fix issiue #3304: oracle does not have Boolean datatype for tables

Merging back to HEAD branch oacs-5-8 (using tag vg-merge-oacs-5-8-from-20141027).

    • -26
    • +28
    ./oracle/acs-mail-lite-create.sql
    • -22
    • +24
    ./postgresql/acs-mail-lite-create.sql
  1. … 2544 more files in changeset.
New feature: now one can send plain filesystem files as email attachments, instead than only those into file-storage

    • -26
    • +28
    ./oracle/acs-mail-lite-create.sql
    • -22
    • +24
    ./postgresql/acs-mail-lite-create.sql
  1. … 5 more files in changeset.
file upgrade-5.8.1d3-5.8.1d4.sql was initially added on branch oacs-5-8.

    • -0
    • +0
    ./oracle/upgrade/upgrade-5.8.1d3-5.8.1d4.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.8.1d3-5.8.1d4.sql
Remove complex-send as agreed in TIP#127

    • -36
    • +0
    ./postgresql/upgrade/upgrade-5.4.0d1-5.4.0d2.sql
  1. … 11 more files in changeset.
Fixed oracle syntax - add doesn't allow "column", unlike PG

Forgot to rename a column in my previous commit

Upgrade scripts and fix datamodel consistency

    • -17
    • +27
    ./oracle/acs-mail-lite-create.sql
    • -0
    • +29
    ./oracle/upgrade/upgrade-5.4.0d2-5.4.0d3.sql
    • -15
    • +23
    ./postgresql/acs-mail-lite-create.sql
    • -0
    • +24
    ./postgresql/upgrade/upgrade-5.4.0d2-5.4.0d3.sql
  1. … 3 more files in changeset.
Join upgrade scripts into one with correct

version number.

    • -8
    • +0
    ./oracle/upgrade/upgrade-1.0b6-1.0b7.sql
    • -43
    • +0
    ./oracle/upgrade/upgrade-1.3b7-1.3b8.sql
    • -5
    • +0
    ./oracle/upgrade/upgrade-1.3b8-1.3b9.sql
    • -1
    • +0
    ./oracle/upgrade/upgrade-1.3b9-1.3b10.sql
    • -0
    • +59
    ./oracle/upgrade/upgrade-5.4.0d1-5.4.0d2.sql
    • -0
    • +51
    ./postgresql/upgrade/upgrade-5.4.0d1-5.4.0d2.sql
Move complex stuff to separated scripts

    • -0
    • +47
    ./oracle/complex-create.sql
    • -0
    • +9
    ./oracle/complex-drop.sql
    • -33
    • +2
    ./postgresql/acs-mail-lite-create.sql
    • -0
    • +39
    ./postgresql/complex-create.sql
    • -0
    • +9
    ./postgresql/complex-drop.sql
Fixing Oracle

    • -11
    • +11
    ./oracle/acs-mail-lite-create.sql
    • -2
    • +2
    ./oracle/upgrade/upgrade-1.0b6-1.0b7.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-1.3b8-1.3b9.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-1.3b9-1.3b10.sql