Opened 13 years ago

Closed 12 years ago

#675 closed defect (worksforme)

pastiche needs a better database scheme

Reported by: Mario Domenech Goulart Owned by: Christian Kellermann
Priority: not urgent at all Milestone:
Component: extensions Version: 4.7.x
Keywords: pastiche sqlite db scheme Cc:
Estimated difficulty:

Description

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

Change History (2)

comment:1 Changed 13 years ago by felix winkelmann

Milestone: 4.8.0

comment:2 Changed 12 years ago by Christian Kellermann

Resolution: worksforme
Status: newclosed
Note: See TracTickets for help on using tickets.