feat: users, account management, authentication system

1 files changed, 18 insertions, 0 deletions

diff --git a/database.sql b/database.sql
index 644345e..ccd4c7e 100644
--- a/database.sql
+++ b/database.sql
@@ -1,7 +1,25 @@
+CREATE TABLE IF NOT EXISTS "users" (
+    "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
+    "username" TEXT NOT NULL UNIQUE,
+    "password" TEXT,
+    "secret_key" TEXT NOT NULL,
+    "joined_at" TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
+);
+
+CREATE TABLE IF NOT EXISTS "connections" (
+    "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
+    "user_id" INTEGER NOT NULL,
+    "alias_id" TEXT NOT NULL,
+    "platform" TEXT NOT NULL,
+    "data" TEXT NOT NULL,
+    "connected_at" TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
+);
+
 CREATE TABLE IF NOT EXISTS "emotes" (
     "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
     "code" TEXT NOT NULL,
     "mime" TEXT NOT NULL,
     "ext" TEXT NOT NULL,
+    "uploaded_by" INTEGER,
     "created_at" TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
 );
\ No newline at end of file