1 files changed, 9 insertions, 1 deletions
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)
+);
+