From a8a338599b3d891ee72a48a5f01f25c1ded31f21 Mon Sep 17 00:00:00 2001
From: ilotterytea <iltsu@alright.party>
Date: Sun, 26 Oct 2025 18:07:02 +0500
Subject: feat: authenticate users

---
 database.sql | 10 ++++++++++
 1 file changed, 10 insertions(+)

(limited to 'database.sql')

diff --git a/database.sql b/database.sql
index 4ca7639..42a6b50 100644
--- a/database.sql
+++ b/database.sql
@@ -5,6 +5,16 @@ CREATE TABLE IF NOT EXISTS users (
     joined_at TIMESTAMP NOT NULL DEFAULT UTC_TIMESTAMP
 );
 
+CREATE TABLE IF NOT EXISTS user_connections (
+    id BIGINT PRIMARY KEY AUTO_INCREMENT,
+    user_id BIGINT NOT NULL REFERENCES users(id),
+    user_alias_id TEXT NOT NULL,
+    user_alias_name TEXT NOT NULL,
+    platform TEXT NOT NULL,
+    connected_at TIMESTAMP NOT NULL DEFAULT UTC_TIMESTAMP,
+    UNIQUE (platform, user_id)
+);
+
 CREATE TABLE IF NOT EXISTS sounds (
     id BIGINT PRIMARY KEY AUTO_INCREMENT,
     code TEXT NOT NULL,
-- 
cgit v1.2.3

