From afcc61d3e035e9343a16abf58eb8bcfc5b563925 Mon Sep 17 00:00:00 2001
From: ilotterytea <iltsu@alright.party>
Date: Sat, 25 Oct 2025 21:05:55 +0500
Subject: feat: save sounds in the database

---
 database.sql | 13 +++++++++++++
 1 file changed, 13 insertions(+)
 create mode 100644 database.sql

(limited to 'database.sql')

diff --git a/database.sql b/database.sql
new file mode 100644
index 0000000..4ca7639
--- /dev/null
+++ b/database.sql
@@ -0,0 +1,13 @@
+CREATE TABLE IF NOT EXISTS users (
+    id BIGINT PRIMARY KEY AUTO_INCREMENT,
+    username TEXT NOT NULL,
+    token TEXT NOT NULL,
+    joined_at TIMESTAMP NOT NULL DEFAULT UTC_TIMESTAMP
+);
+
+CREATE TABLE IF NOT EXISTS sounds (
+    id BIGINT PRIMARY KEY AUTO_INCREMENT,
+    code TEXT NOT NULL,
+    uploaded_at TIMESTAMP NOT NULL DEFAULT UTC_TIMESTAMP,
+    uploaded_by BIGINT REFERENCES users(id)
+);
\ No newline at end of file
-- 
cgit v1.2.3

