When updating the note in an accountline, both accountlines.timestamp and accountlines.date get updated to the current date and time. Accountlines.date is meant to remain constant as the time of creation for this entry. Updating it has a serious impact on the data.
Created attachment 192397 [details] [review] Bug 41761: Do not update accountlines.date when editing a note To test: 0. APPLY PATCH, restart_all 1. Create an accountline and make note of the accountline.date 2. On that accoutnline edit the note. 3. Confirm that the accountline.date does NOT update.
We shouldn't need to set timestamp here because on the accountlines table timestamp column we have: `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
Created attachment 192398 [details] [review] Bug 41761: Do not update accountlines.date when editing a note To test: 0. APPLY PATCH, restart_all 1. Create an accountline and make note of the accountline.date 2. On that accoutnline edit the note. 3. Confirm that the accountline.date does NOT update. Signed-off-by: Juliet Heltibridle <jheltibridle@rcplib.org>