id	summary	reporter	owner	description	type	status	priority	milestone	component	version	resolution	keywords	cc	difficulty
675	pastiche needs a better database scheme	Mario Domenech Goulart	Christian Kellermann	"Currently it is not possible to hand out the correct links for annotation in the ""browse pastes"" tab.

This is because we do not mark a db entry as being an annotation but this is detected on the fly when displaying all pastes with a certain hash. Annotations are defined to have the same sha1-hash as the original paste but a different timestamp.

So this is easy to do when displaying all entries for one hash and sorting them by timestamp, but this fails when we say ""get me the last N additions to the database"".

A better db scheme is needed"	defect	closed	not urgent at all		extensions	4.7.x	worksforme	pastiche sqlite db scheme