From 8b9188b2c0ac192150201c511944d68862275f69 Mon Sep 17 00:00:00 2001
From: ilotterytea <iltsu@alright.party>
Date: Tue, 14 Oct 2025 22:34:59 +0500
Subject: feat: get bttv emotes

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

(limited to 'database.sql')

diff --git a/database.sql b/database.sql
index e453239..023723a 100644
--- a/database.sql
+++ b/database.sql
@@ -29,4 +29,12 @@ CREATE TABLE IF NOT EXISTS channel_words (
     last_used_at TIMESTAMP NOT NULL DEFAULT UTC_TIMESTAMP,
 
     UNIQUE (channel_id, user_id, word_id)
-);
\ No newline at end of file
+);
+
+CREATE TABLE IF NOT EXISTS emotes (
+  id BIGINT PRIMARY KEY AUTO_INCREMENT,
+  platform VARCHAR(16) NOT NULL,
+  platform_id VARCHAR(64) NOT NULL,
+  UNIQUE (platform, platform_id)
+);
+
-- 
cgit v1.2.3

