Store a list of guild-specific assets

Data

guild_assets

• guild (bigint)
• type (int, reference to guild_asset_types.id)
• location (text)

guild_asset_types

• name
• description

Commands

Upload asset

Create a regular message-based command that accepts an asset type and an attached image file.

Upload the image file to S3, and return the web URL, storing it in DB.

List asset names

Return the filenames of all assets uploaded for the guild, optionally accepting type.

Delete asset

Delete an asset from S3 and the DB given a filename.

Clear all assets

Remove all assets from S3 and the ID for the guild. Owner only.