Criar um schema para o usuário
Onde
Na pasta src/db/schema.ts
.
O que deve ter?
O schema deve bater com esse (em SQL)
CREATE TABLE users (
id SERIAL PRIMARY KEY UNIQUE NOT NULL,
name VARCHAR(255) NOT NULL,
password VARCHAR(255) NOT NULL,
email VARCHAR(255) UNIQUE NOT NULL,
birthday TIMESTAMP NOT NULL,
cpf VARCHAR(11) UNIQUE NOT NULL,
money NUMERIC NOT NULL DEFAULT 0,
cyberpsychosis NUMERIC NOT NULL DEFAULT 0,
cyberLimit NUMERIC NOT NULL DEFAULT 100,
created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);