database.sql


1
2
3
4
5
6
7
8
9
10
11
12
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)
);