cmd/marabot: start importing discord data

Signed-off-by: Xe Iaso <me@xeiaso.net>

1 files changed, 59 insertions, 8 deletions

diff --git a/cmd/marabot/schema.sql b/cmd/marabot/schema.sql
index 7d4046f..b95c4c7 100644
--- a/cmd/marabot/schema.sql
+++ b/cmd/marabot/schema.sql
@@ -1,10 +1,61 @@
-CREATE TABLE IF NOT EXISTS roles (
-    id SERIAL PRIMARY KEY,
-    discord_server TEXT NOT NULL,
-    discord_id TEXT NOT NULL,
-    revolt_server TEXT NOT NULL,
-    revolt_id TEXT NOT NULL,
+CREATE TABLE IF NOT EXISTS discord_roles (
+    id TEXT PRIMARY KEY,
+    guild_id TEXT NOT NULL,
     name TEXT NOT NULL,
     color TEXT NOT NULL,
-    hoist BOOLEAN NOT NULL
-);
\ No newline at end of file
+    hoist BOOLEAN NOT NULL,
+    position INTEGER NOT NULL
+);
+
+CREATE TABLE IF NOT EXISTS discord_users (
+    id TEXT PRIMARY KEY,
+    username TEXT NOT NULL,
+    avatar_url TEXT NOT NULL,
+    accent_color INTEGER NOT NULL
+);
+
+CREATE TABLE IF NOT EXISTS discord_messages (
+    id TEXT PRIMARY KEY,
+    guild_id TEXT NOT NULL,
+    channel_id TEXT NOT NULL,
+    author_id TEXT NOT NULL,
+    content TEXT,
+    created_at TEXT NOT NULL,
+    edited_at TEXT,
+    webhook_id TEXT
+);
+
+CREATE TABLE IF NOT EXISTS discord_attachments (
+    id TEXT PRIMARY KEY,
+    message_id TEXT NOT NULL,
+    url TEXT NOT NULL,
+    proxy_url TEXT NOT NULL,
+    filename TEXT NOT NULL,
+    content_type TEXT NOT NULL,
+    width INTEGER NOT NULL,
+    height INTEGER NOT NULL,
+    "size" INTEGER NOT NULL
+);
+
+CREATE TABLE IF NOT EXISTS discord_channels (
+    id TEXT PRIMARY KEY,
+    guild_id TEXT NOT NULL,
+    name TEXT NOT NULL,
+    topic TEXT NOT NULL,
+    nsfw BOOLEAN NOT NULL
+);
+
+CREATE TABLE IF NOT EXISTS discord_guilds (
+    id TEXT PRIMARY KEY,
+    name TEXT NOT NULL,
+    description TEXT NOT NULL,
+    icon_url TEXT NOT NULL,
+    banner_url TEXT NOT NULL
+);
+
+CREATE TABLE IF NOT EXISTS discord_emoji (
+    id TEXT PRIMARY KEY,
+    guild_id TEXT NOT NULL,
+    name TEXT NOT NULL,
+    url TEXT NOT NULL
+);