10 lines
197 B
SQL
10 lines
197 B
SQL
CREATE TABLE accounts (
|
|
account_id SERIAL NOT NULL,
|
|
email TEXT NOT NULL,
|
|
verified BOOLEAN NOT NULL DEFAULT FALSE,
|
|
|
|
PRIMARY KEY (account_id)
|
|
);
|
|
|
|
CREATE UNIQUE INDEX ON accounts (email);
|