backend/migrations/2023-08-23-112227_users/up.sql

13 lines
303 B
MySQL
Raw Permalink Normal View History

2023-08-27 17:16:10 +02:00
-- Your SQL goes here
CREATE TABLE users (
id BIGINT AUTO_INCREMENT NOT NULL,
username VARCHAR(20) NOT NULL,
email VARCHAR(255) NOT NULL,
salt VARCHAR(255) NOT NULL,
pass VARCHAR(64) NOT NULL,
joined DATE NOT NULL,
PRIMARY KEY(id),
UNIQUE(username),
UNIQUE(email)
);