Testing showed that order matters for altering of rag_entry columns.
Project: http://git-wip-us.apache.org/repos/asf/roller/repo Commit: http://git-wip-us.apache.org/repos/asf/roller/commit/fd96ae4a Tree: http://git-wip-us.apache.org/repos/asf/roller/tree/fd96ae4a Diff: http://git-wip-us.apache.org/repos/asf/roller/diff/fd96ae4a Branch: refs/heads/master Commit: fd96ae4a101cb91b65959cfe8025f090f42b7b3d Parents: 4fd2e37 Author: Dave Johnson <[email protected]> Authored: Sun Jul 23 13:18:15 2017 -0400 Committer: Dave Johnson <[email protected]> Committed: Sun Jul 23 13:18:15 2017 -0400 ---------------------------------------------------------------------- app/src/main/resources/sql/510-to-520-migration.vm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/roller/blob/fd96ae4a/app/src/main/resources/sql/510-to-520-migration.vm ---------------------------------------------------------------------- diff --git a/app/src/main/resources/sql/510-to-520-migration.vm b/app/src/main/resources/sql/510-to-520-migration.vm index a06e998..42dcecb 100644 --- a/app/src/main/resources/sql/510-to-520-migration.vm +++ b/app/src/main/resources/sql/510-to-520-migration.vm @@ -32,8 +32,8 @@ #expandTimestampNotNull('pingqueueentry' 'entrytime') #expandTimestamp('pingtarget' 'lastsuccess') -#expandTimestampNotNull('rag_entry' 'published') #expandTimestamp('rag_entry' 'updated') +#expandTimestampNotNull('rag_entry' 'published') #expandTimestamp('rag_subscription' 'last_updated') #expandTimestamp('roller_audit_log' 'change_time') #expandTimestampNotNull('roller_comment' 'posttime')
