amichair commented on PR #2444: URL: https://github.com/apache/james-project/pull/2444#issuecomment-2403271666
The changes are: 1. Primary key changed from (DOMAIN_NAME, USER_NAME) to (DOMAIN_NAME, TARGET_ADDRESS, USER_NAME) (unfortunately, it is auto-generated in alphabetical order) 2. Added index USER_NAME_DOMAIN_NAME_TARGET_ADDRESS_INDEX (USER_NAME, DOMAIN_NAME, TARGET_ADDRESS) 3. Added index TARGET_ADDRESS_INDEX (TARGET_ADDRESS) 4. Columns have not changed. 5. Rows that had multiple semicolon delimited values in their TARGET_ADDRESS field need to be split into individual rows each with a single target address value. Rows with a single value remain unchanged. Afaik there is no standard SQL way of doing the last data migration step. I can write a method that does it, but is there any mechanism to invoke it? or just put it in a main method of the class? How have schema/data migrations been addressed in the past? -- 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-unsubscr...@james.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: notifications-unsubscr...@james.apache.org For additional commands, e-mail: notifications-h...@james.apache.org
