SQLize | PHPize | SQLtest

CREATE TABLE IF NOT EXISTS funcionario ( id_func 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'); CREATE TABLE IF NOT EXISTS cargo ( id_cargo INTEGER PRIMARY KEY AUTOINCREMENT, cargo_nome TEXT NOT NULL UNIQUE ); INSERT INTO cargo (cargo_nome) VALUES ('Analista'); INSERT INTO cargo (cargo_nome) VALUES ('Desenvolvedor'); INSERT INTO cargo (cargo_nome) VALUES ('Designer');