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

[Nenad Vujicic]

nenad-vujicic left a comment (openstreetmap/openstreetmap-website#5815)

> I mean we still haven't finished implementing the previously agreed schema changes for notes have we? and now we want to start altering it again..
>

Do you mean removing `event` column?
 
> I understand the logic of matching how the geodata is versions, but notes are not the same and this seems to create quite a confusing schema to me. I can see each note version has a comment reference, so is a new version created every time there is a comment? So there is a one-one relationship between comments and versions? or maybe many-one because you can can have a version without a new comment?
> 

I'm sorry, perhaps I made a mistake in #5904 My idea is to have comments shared for all versions. New version is created only when user `closes`, `reopens` or `hides` a note.


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

Message ID: <openstreetmap/openstreetmap-website/pull/5815/c2807112202 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20250415/2b124f07/attachment.htm>