redunadant data when creating records

[tonyvince]

When a new friendship is created two records are inserted into friendships table. Can't we avoid that? Any particular reason for adopting this approach?

[bborn]

We need two records because we need to know who initiated the friendship request, and who received it (otherwise someone could initial and accept their own friendship request).