From afcc61d3e035e9343a16abf58eb8bcfc5b563925 Mon Sep 17 00:00:00 2001 From: ilotterytea 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