MAILBOX-356 Document JAMES_MAILBOX_ANNOTATION rename column KEY
Project: http://git-wip-us.apache.org/repos/asf/james-project/repo Commit: http://git-wip-us.apache.org/repos/asf/james-project/commit/3764ac48 Tree: http://git-wip-us.apache.org/repos/asf/james-project/tree/3764ac48 Diff: http://git-wip-us.apache.org/repos/asf/james-project/diff/3764ac48 Branch: refs/heads/master Commit: 3764ac48ea2298ae3292e022fedbd2dc7aa0aac5 Parents: de315ea Author: datph <[email protected]> Authored: Wed Dec 19 15:07:14 2018 +0700 Committer: Benoit Tellier <[email protected]> Committed: Fri Dec 21 09:11:37 2018 +0700 ---------------------------------------------------------------------- upgrade-instructions.md | 35 +++++++++++++++++++++++++++++++++++ 1 file changed, 35 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/james-project/blob/3764ac48/upgrade-instructions.md ---------------------------------------------------------------------- diff --git a/upgrade-instructions.md b/upgrade-instructions.md index 38c6fc2..89c10b4 100644 --- a/upgrade-instructions.md +++ b/upgrade-instructions.md @@ -172,3 +172,38 @@ $ nodetool stop $ nodetool upgradesstables apache_james ``` +## 3.3.0 version + +Changes to apply between 3.2.0 and 3.3.0 had been reported here. + +Changelist: + + - [Rename KEY column in JAMES_MAILBOX_ANNOTATION table](#james-mailbox-annotation) + +### Rename KEY column in JAMES_MAILBOX_ANNOTATION table + +Date: 19/12/2018 + +SHA-1: e25967664538be18ec29f47e73e661bdf29da41f + +JIRA: https://issues.apache.org/jira/projects/MAILBOX/issues/MAILBOX-356 + +Required: Yes + +Concerned products: all JPA related products + +#### Upgrade procedure + +Rename `KEY` column in `JAMES_MAILBOX_ANNOTATION` table. The syntax is: + +##### In MySQL +``` +ALTER TABLE JAMES_MAILBOX_ANNOTATION CHANGE KEY ANNOTATION_KEY varchar(200); +``` + +##### In MariaDB +``` +ALTER TABLE JAMES_MAILBOX_ANNOTATION CHANGE COLUMN KEY ANNOTATION_KEY varchar(200); +``` + +_or the syntax corresponding to your database._ --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
