[Chicken-janitors] #675: pastiche needs a better database scheme

[Chicken Trac]

#675: pastiche needs a better database scheme
---------------------------------------+------------------------------------
 Reporter:  mario                      |       Owner:  ckeen
     Type:  defect                     |      Status:  new  
 Priority:  not urgent at all          |   Milestone:  4.8.0
Component:  extensions                 |     Version:  4.7.x
 Keywords:  pastiche sqlite db scheme  |  
---------------------------------------+------------------------------------
 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

-- 
Ticket URL: <http://bugs.call-cc.org/ticket/675>
Chicken Scheme <http://www.call-with-current-continuation.org/>
Chicken Scheme is a compiler for the Scheme programming language.