This is an automated email from the ASF dual-hosted git repository. btellier pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/james-project.git
commit a4b47693f93de3ec037172b1ecc8830bb565a257 Author: Rene Cordier <[email protected]> AuthorDate: Mon Dec 1 17:19:11 2025 +0700 JAMES-3340 Add upgrade instructions for thread_id column --- upgrade-instructions.md | 52 +++++++++++++++++++++++++++++++++++++++++++++---- 1 file changed, 48 insertions(+), 4 deletions(-) diff --git a/upgrade-instructions.md b/upgrade-instructions.md index 5550a2bfc7..a7db95209d 100644 --- a/upgrade-instructions.md +++ b/upgrade-instructions.md @@ -10,12 +10,56 @@ software documentation. Do not follow this guide blindly! ## Unreleased -No specific operation to conduct from a 3.9.0 version. +Note: this section is in progress. It will be updated during all the development process until the release. -## 3.9.0 version (tagged but not yet released) +Changes to apply between 3.9.x and 3.10.0 will be reported here. -Note: this section is in progress. It will be updated during all the development process until the release. -No changes yet. +Change list: + - [Adding thread_id column to Cassandra email_query_view_sent_at and email_query_view_received_at tables](#adding-thread_id-column-to-cassandra-email_query_view_sent_at-and-email_query_view_received_at-tables) + - [Adding thread_id column to Postgresql email_query_view table](#adding-thread_id-column-to-postgresql-email_query_view-table) + +### Adding thread_id column to Cassandra email_query_view_sent_at and email_query_view_received_at tables + +Date: 01/12/2025 + +Concerned products: Distributed James + +JIRA: https://issues.apache.org/jira/browse/JAMES-3340 + +James supports now collapseThreads Email/query option for the email query views (not the search). + +For this, we need to add the following columns to `email_query_view_sent_at` and `email_query_view_received_at` tables: + +- thread_id (UUID) + +To add these columns, run the following CQL commands: + +```sql +ALTER TABLE james_keyspace.email_query_view_sent_at ADD thread_id UUID; +ALTER TABLE james_keyspace.email_query_view_received_at ADD thread_id UUID; +``` + +### Adding thread_id column to Postgresql email_query_view table + +Date: 01/12/2025 + +Concerned products: Postgresql James + +JIRA: https://issues.apache.org/jira/browse/JAMES-3340 + +James supports now collapseThreads Email/query option for the email query views (not the search). + +For this, we need to add the following columns to `email_query_view` table: + +- thread_id (UUID) + +To add that column, run the following CQL command: + +```sql +ALTER TABLE james_keyspace.email_query_view ADD COLUMN thread_id UUID; +``` + +## 3.9.0 version Changes to apply between 3.8.x and 3.9.0 will be reported here. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
