[WG: Sakai QA] SAK-16463
Seth Theriault
slt at columbia.edu
Thu Jun 4 07:28:39 PDT 2009
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
More information about the sakai-qa
mailing list