feat: authenticate users

1 files changed, 10 insertions, 0 deletions

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,