CREATE TABLE IF NOT EXISTS users (
id_user INTEGER PRIMARY KEY AUTOINCREMENT,
nome TEXT NOT NULL,
cpf TEXT NOT NULL UNIQUE,
email TEXT NOT NULL UNIQUE,
cep TEXT NOT NULL,
cargo TEXT NOT NULL,
salario REAL NOT NULL,
data_admissao DATE NOT NULL
)
INSERT INTO users
(nome, cpf, email,
cep, cargo, salario,
data_admissao)
VALUES
('Alana Santos Amaral', '551.689.897-54', 'alana@email.com',
45877648, 'Analista', 3000.00,
'2025/04/06')
INSERT INTO users
(nome, cpf, email,
cep, cargo, salario,
data_admissao)
VALUES
('Bruno Oliveira Costa', '218.456.123-99', 'bruno.costa@email.com',
12345678, 'Desenvolvedor', 4500.00,
'2025/03/15')
INSERT INTO users
(nome, cpf, email, cep, cargo, salario, data_admissao)
VALUES
('Camila Ferreira Lima', '345.789.654-22', 'camila.lima@email.com',
98765432, 'Designer', 3700.00,
'2025/02/28');