bansync/theory.md

Discord Ban Sync Bot

Here's the plan, Ban Lists

• Allow anybody to install the bot to their user or guild.
• Anybody can create a "ban-list" with a unique ID, name, and list of users/guilds that can modify it.
  • Allow user to make list public/private? (tl;dr private mode only users allowed to modify can link the list to a guild and use it. Public ones all you'd need is the ID)

DB Struct

• lists
  • id: default uuid(); primary
  • name: varchar(24); do sanitizing, this will be user defined
  • owner_id: varchar(24); User Snowflake of person who currently owns list. Default is creator, might add transfer feature?
  • private: bool, default true
• guilds
  • id: int, autoinc, primary
  • guild_id: guild id
  • list_id: list id (ref to lists.id)
  • auto_add: Automatically sync new bans that are added to the db, otherwise require manual sync