[WG: Sakai QA] SAK-16463

[Seth Theriault]

Hello,

For existing installations, the new columns are added by the 
mailarchive binary-conversion scripts. In particular, take a 
look at:

mailarchive/upgradeschema-2.6-oracle.config

This is NOT the general reference/doc/conversions script.

I will also note that the columns are present in a virgin 2.6 
Oracle database, such as qa2-us via the auto.ddl:

mailarchive/mailarchive-impl/impl/src/sql/oracle/sakai_mailarchive_2_6_0.sql 

acisora1#1> describe mailarchive_message;
describing table: 'MAILARCHIVE_MESSAGE' (corrected name)
Table: MAILARCHIVE_MESSAGE
---+--------------+---------------+------+---------+------------------+----+
 # |    column    |     type      | null | default |        pk        | fk |
---+--------------+---------------+------+---------+------------------+----+
 1 | CHANNEL_ID   | VARCHAR2(99)  | NO   | [NULL]  | SYS_C00369778    |    |
 2 | MESSAGE_ID   | VARCHAR2(36)  | NO   | [NULL]  | SYS_C00369778{2} |    |
 3 | DRAFT        | CHAR(1)       | YES  | [NULL]  |                  |    |
 4 | PUBVIEW      | CHAR(1)       | YES  | [NULL]  |                  |    |
 5 | OWNER        | VARCHAR2(99)  | YES  | [NULL]  |                  |    |
 6 | MESSAGE_DATE | DATE(7)       | NO   | [NULL]  |                  |    |
 7 | XML          | LONG          | YES  | [NULL]  |                  |    |
 8 | SUBJECT      | VARCHAR2(255) | YES  | null    |                  |    |
 9 | BODY         | CLOB(4000)    | YES  | null    |                  |    |
---+--------------+---------------+------+---------+------------------+----+

We may wish to recommend that people do the binary-conversion 
upgrade.

Seth