planetwars.dev/planetwars-server/migrations/2021-12-13-145111_users/up.sql

8 lines
213 B
MySQL
Raw Permalink Normal View History

CREATE TABLE users(
id SERIAL PRIMARY KEY,
username VARCHAR(52) NOT NULL,
password_salt BYTEA NOT NULL,
password_hash BYTEA NOT NULL
2021-12-14 20:23:07 +01:00
);
CREATE UNIQUE INDEX users_username_index ON users(username);