We really need to revamp the SQL schema to make it more appropriate to how we use the application and also do ticket #21.
I've got a fair idea on how the schema will look.
This ain't going to happen now, too much effort for not enough gain.
Login to comment on this ticket.