[GitHub] [james-project] chibenwa commented on a diff in pull request #1338: JAMES-3754 Storage layer support for IMAP save date extension

[GitBox <gi...@apache.org>]

chibenwa commented on code in PR #1338:
URL: https://github.com/apache/james-project/pull/1338#discussion_r1037184725


##########
upgrade-instructions.md:
##########
@@ -23,6 +23,23 @@ Change list:
 - [SortOrder addition in Identity](#sortorder-addition-in-identity)
 - [TLS host name verification is now enabled by default](#tls-host-name-verification-is-now-enabled-by-default)
 - [Blob Store AES upgraded to PBKDF2WithHmacSHA512](#blob-store-aes-upgraded-to-pbkdf2withhmacsha512)
+- [Adding saveDate column to messageIdTable and imapUidTable](#adding-savedate-column-to-messageidtable-and-imapuidtable)
+
+### Adding saveDate column to messageIdTable and imapUidTable
+
+Date 01/12/2022
+
+JIRA: https://issues.apache.org/jira/browse/JAMES-3754
+
+Concerned product: Distributed James, Cassandra James Server
+
+Add `saveDate` column to `messageIdTable` and `imapUidTable` tables in order to store saveDate data as part of IMAP SAVEDATE extension.
+
+In order to add this `messageIdTable` column you need to run the following CQL commands:
+```
+ALTER TABLE james_keyspace.messageIdTable ADD saveDate timestamp;
+ALTER TABLE james_keyspace.imapUidTable ADD saveDate timestamp;

Review Comment:
   capital case are a pain with Cassandra. `save_date` is better maybe?



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@james.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@james.apache.org
For additional commands, e-mail: notifications-help@james.apache.org