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

[Emin Kocan]

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

@AntonKhorev, just to clarify—are you referring to sorting notes by their latest updates or reconstructing the full note history for discussions (e.g., from note, note_versions, and note_comments)?

If we set an updated_at attribute whenever a new version is created, why would sorting by that be problematic? Wouldn't it be sufficient for ordering by the latest updates instead of relying on a surrogate id from note_comments?

I'm not sure I understood the real problem here.. Thank you in advance for clarifications.

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

Message ID: <openstreetmap/openstreetmap-website/pull/5815/c2752092703 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20250325/6aa99a24/attachment.htm>