13 lines
303 B
SQL
13 lines
303 B
SQL
-- 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)
|
|
);
|