Create New DB Tables

[osilkin98]

Database needs a new table to accommodate:

• Pinning comments api endpoint to track latest comments with claim_id or claim URLs #29
  • one-to-many relation PINS: CLAIM -> COMMENT
• Channel Blocking
  • one-to-many relation BLOCKS: CHANNEL -> CHANNEL
• Storing information about claims, including public keys, addresses, stake amounts, etc.
  • CLAIM
    • type
    • stake_amount
    • address
    • claim_id
    • name
    • signing_channel
• CHANNEL
  • public_key
  • signature
  • public_key_id
• Requires making a table CLAIM which stores claim_type, signing_channel, stake_amount
• Action history (e.g. channel x edits comment y at time z)
  • either loose relation on table CHANNEL or a many-to-many relation between CHANNEL & COMMENT
    • action (creates, deletes, updates, hides, pins, etc.)
    • timestamp (good for modification time, etc.)
    • signature (of the action)
    • comment_id (if there is one)
• Messages
  • dunno if this will either be a modified signed version of COMMENT or if this should be its own entity entirely