diff options
| author | Xe Iaso <me@xeiaso.net> | 2023-06-17 08:11:33 -0400 |
|---|---|---|
| committer | Xe Iaso <me@xeiaso.net> | 2023-06-17 08:11:33 -0400 |
| commit | 1e4998c429d2cf40f947d8bd8ce29691ec102ff1 (patch) | |
| tree | 9d9d2d7d9700a092f6d233efb3f0ada9f98b6bc6 /cmd/marabot/schema.sql | |
| parent | 0b4d9abb80af44b026bd5f0e46cd7d303f059d73 (diff) | |
| download | x-1e4998c429d2cf40f947d8bd8ce29691ec102ff1.tar.xz x-1e4998c429d2cf40f947d8bd8ce29691ec102ff1.zip | |
cmd/marabot: log user info for webhooks
Signed-off-by: Xe Iaso <me@xeiaso.net>
Diffstat (limited to 'cmd/marabot/schema.sql')
| -rw-r--r-- | cmd/marabot/schema.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/cmd/marabot/schema.sql b/cmd/marabot/schema.sql index b95c4c7..10a01fd 100644 --- a/cmd/marabot/schema.sql +++ b/cmd/marabot/schema.sql @@ -1,3 +1,5 @@ +PRAGMA journal_mode=WAL; + CREATE TABLE IF NOT EXISTS discord_roles ( id TEXT PRIMARY KEY, guild_id TEXT NOT NULL, @@ -25,6 +27,12 @@ CREATE TABLE IF NOT EXISTS discord_messages ( webhook_id TEXT ); +CREATE TABLE IF NOT EXISTS discord_webhook_message_info ( + id TEXT PRIMARY KEY, + name TEXT NOT NULL, + avatar_url TEXT NOT NULL +); + CREATE TABLE IF NOT EXISTS discord_attachments ( id TEXT PRIMARY KEY, message_id TEXT NOT NULL, |