[openstreetmap/openstreetmap-website] Adds version to notes table and creates note_versions table (PR #5815)

[Anton Khorev]

AntonKhorev left a comment (openstreetmap/openstreetmap-website#5815)

Se also the last paragraph of https://github.com/openstreetmap/openstreetmap-website/issues/5294#issuecomment-2541604426, where I write about keeping `id` from api0.6-comments. Some of those api0.6-comments will become non-comments and will be deleted from the comments table. In this case their ids are lost. If we are to use them for sorting, we don't need exactly the same ids, anything that forms the same sequence will do.

Or maybe we don't need any of this and we need instead a global counter for note updates with its values stored in the maid notes table.

-- 
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/openstreetmap-website/pull/5815#issuecomment-2746276051
You are receiving this because you are subscribed to this thread.

Message ID: <openstreetmap/openstreetmap-website/pull/5815/c2746276051 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20250323/5b3cd623/attachment.htm>