diff options
| author | ilotterytea <iltsu@alright.party> | 2025-10-14 22:34:59 +0500 |
|---|---|---|
| committer | ilotterytea <iltsu@alright.party> | 2025-10-14 22:34:59 +0500 |
| commit | 8b9188b2c0ac192150201c511944d68862275f69 (patch) | |
| tree | 67dae6db7a2f54aa2afd45e92be802b35e2b236a /database.sql | |
| parent | e4c92920e627b7ad17f51637f52ca36e8468341f (diff) | |
feat: get bttv emotes
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 10 |
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) +); + |