0f4df23290
Some checks failed
kotlin / test (push) Has been skipped
python / test (push) Has been skipped
typescript / test (push) Has been skipped
go / build darwin/amd64 (push) Has been cancelled
go / build linux/amd64 (push) Has been cancelled
go / build windows/amd64 (push) Has been cancelled
go / build darwin/arm64 (push) Has been cancelled
go / build linux/arm64 (push) Has been cancelled
go / build windows/arm64 (push) Has been cancelled
go / test (push) Has been cancelled
go / vuln_check (push) Has been cancelled
13 lines
368 B
SQL
13 lines
368 B
SQL
CREATE EXTENSION pg_trgm;
|
|
CREATE EXTENSION pgcrypto;
|
|
|
|
CREATE TABLE users(
|
|
id INT GENERATED ALWAYS AS IDENTITY NOT NULL,
|
|
fname VARCHAR(100) NOT NULL,
|
|
lname VARCHAR(100) NOT NULL,
|
|
email VARCHAR(100) NOT NULL UNIQUE,
|
|
enc_passwd TEXT NOT NULL,
|
|
created_at TIMESTAMP WITH TIME ZONE NOT NULL default (NOW() AT TIME ZONE 'utc'),
|
|
PRIMARY KEY(id)
|
|
);
|