A liquibase comparison of a virgin 2.8.0-b04 db vs a converted 2.7.1->2.8.0 db revealed a missing announcements column (MESSAGE_ORDER) as well as missing indexes in the converted database associated with
SAK-8005 work. I added the following scripts to the 2.8.0 MySQL conversion scripts as part of my test/fix work:
alter table ANNOUNCEMENT_MESSAGE add column MESSAGE_ORDER int(11) default null;
drop index IE_ANNC_MSG_ATTRIB on ANNOUNCEMENT_MESSAGE;
create index IE_ANNC_MSG_ATTRIB on ANNOUNCEMENT_MESSAGE (DRAFT, PUBVIEW, OWNER, MESSAGE_ORDER);
drop index ANNOUNCEMENT_MESSAGE_CDD on ANNOUNCEMENT_MESSAGE;
create index ANNOUNCEMENT_MESSAGE_CDD on ANNOUNCEMENT_MESSAGE (CHANNEL_ID, MESSAGE_DATE, MESSAGE_ORDER, DRAFT);
We need the parallel scripts written in the Oracle dialect added to the 2.8.0 Oracle conversion scripts.