0021733: Attachments should be linkable to notes in db

ID	Project	Category	View Status	Date Submitted	Last Update
0021733	mantisbt	attachments	public	2016-09-30 21:30	2024-09-16 06:39

Reporter	vboctor	Assigned To	vboctor
Priority	normal	Severity	feature	Reproducibility	N/A
Status	closed	Resolution	fixed
Product Version	1.3.1
Target Version	2.23.0	Fixed in Version	2.23.0

Summary	0021733: Attachments should be linkable to notes in db
Description	When a user adds a note and an attachment together they should be linked in the db. We can use heuristics to link existing attachments that are upload by users within small N seconds of time they posted a note.
Tags	schema

related to	0021727	closed	vboctor	Show attachments inline with notes
parent of	0009802	closed	vboctor	Support attachments associated with private notes
parent of	0024577	closed	vboctor	Deleting a note, should delete associated attachments
parent of	0025935	closed	vboctor	Warning for users when making public notes with attachments private
parent of	0022817	closed	vboctor	"private bugnotes" as default setting prevents uploading further attachments
parent of	0025960	closed	vboctor	Add files information to EVENT_BUGNOTE_ADD event
has duplicate	0022262	closed	atrol	Including more than two attachments to a note
has duplicate	0023026	closed	dregad	'Edit' button on bugnotes with only attachments
has duplicate	0023261	closed	atrol	Reference to a note containing a file
related to	0026098	closed	dregad	Update ERD diagram to reflect new field in bug_file table
related to	0026489	closed	dregad	Note gets separated from attachments
related to	0026835	closed	atrol	Database Server error while adding file to project
related to	0034597	feedback		Problem with order in atached files when migrate Version From 2.14.0 to Version 2.26.1

cproensa 2016-10-01 05:57 developer ~0054103	I strongly suggest to normalize mantis_bug_file_table into: file table file relations table The relation table should be able to link a file to a bug_id, a note_id, etc The point about heuristics should not be included in this task, as it's not relevant once the data is linked at db level. I mean, heuristic could be used as a tool to easily link a file to a note at upload time, but not later in time.

polzin 2017-01-05 05:00 reporter ~0054935	This is fixed, right?

atrol 2017-01-05 05:06 developer ~0054937 Last edited: 2017-06-16 07:37	This is fixed, right? Not fixed, there is no link in db. Maybe you got confused by 0021727

vboctor 2019-07-22 01:44 manager ~0062404	PR: https://github.com/mantisbt/mantisbt/pull/1529