Keep track of claimed images

[catzoo]

Keep track of which images belongs to which users. Allow users to:

• [ ] Give images to other users
• [ ] Give images back

Change the images database to: [ ] [img_id] [url] [name] [claim_user]

• see next comment

This should allow users to see which images they have and allow them to give their claimed images to other users / back.

[catzoo]

Decided to go with:

New table

• Adoptions:
  • adopt_id integer (primary key)
  • owner integer (foreign key, references users(user_id))
  • image integer (foreign key, references images(img_id))

    Changed table

• Images added own -
  • img_id integer (primary key)
  • url text
  • name text
  • own integer (used as Boolean, 1 = true, 0 = false)