Invalid Oracle DDL statements for Oracle 11g

Description

alter statements (at least in oracle 11g or earlier) do not allow the
COLUMN keyword after ADD in an ALTER statement

It looks like the update SQL for Oracle was copied from Postgresql? Or maybe
it works on Oracle 12c? Anyway this fixes the DDL for Oracle 11g and I
assume it would still work on Oracle 12c.

https://github.com/igniterealtime/Openfire/pull/623

Environment

None
Fixed
Your pinned fields
Click on the next to a field label to start pinning.

Assignee

Dave Cridland

Reporter

Daryl Herzmann