feat: save sounds in the database

1 files changed, 13 insertions, 0 deletions

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