Last active
April 18, 2023 19:29
-
-
Save SilasRodrigues19/0f0009a345804becace064104645153e to your computer and use it in GitHub Desktop.
FindUrJob Database Backup
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE TABLE jobs ( | |
job_id INT(11) NOT NULL AUTO_INCREMENT, | |
job_title VARCHAR(255) NOT NULL, | |
job_requirements VARCHAR(255) NOT NULL, | |
job_link VARCHAR(255) NOT NULL, | |
job_level ENUM('Senior', 'Pleno', 'Junior', 'Trainee', 'Estágio', 'Não informado') NOT NULL DEFAULT 'Não informado', | |
job_salary VARCHAR(255) NOT NULL, | |
job_currency ENUM('Real', 'Dollar', 'Euro') NOT NULL DEFAULT 'Real', | |
job_mode ENUM('Remoto', 'Presencial', 'Híbrido', 'Não informado') NOT NULL DEFAULT 'Não informado', | |
job_contract ENUM('PJ', 'CLT', 'Não listado') NOT NULL DEFAULT 'Não listado', | |
job_email VARCHAR(255), | |
job_experience BOOLEAN NOT NULL DEFAULT FALSE, | |
job_is_archived BOOLEAN NOT NULL DEFAULT FALSE, | |
job_observation VARCHAR(255), | |
created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP(), | |
PRIMARY KEY (job_id) | |
) ENGINE = INNODB CHARSET = UTF8MB4 COMMENT = 'Tabela para guardar informações sobre as vagas'; | |
CREATE TABLE users ( | |
user_id INT(11) NOT NULL AUTO_INCREMENT, | |
user_name VARCHAR(255) NOT NULL, | |
user_password VARCHAR(255) NOT NULL, | |
user_email VARCHAR(255) NOT NULL, | |
user_level ENUM('User', 'Mod', 'Admin') NOT NULL DEFAULT 'User', | |
user_is_active BOOLEAN NOT NULL DEFAULT 1, | |
created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP(), | |
PRIMARY KEY (user_id) | |
) ENGINE = INNODB CHARSET = UTF8MB4 COMMENT = 'Tabela para guardar informações de usuários'; | |
CREATE TABLE validEmails ( | |
email_id INT(11) NOT NULL AUTO_INCREMENT, | |
email_domain VARCHAR(255) NOT NULL, | |
created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP(), | |
PRIMARY KEY (email_id) | |
) ENGINE = INNODB CHARSET = UTF8MB4 COMMENT = 'Tabela para guardar informações de e-mails confiáveis e não temporários'; | |
SELECT * FROM validEmails | |
INSERT INTO validEmails (email_domain) VALUES ('@gmail'), ('@hotmail'), ('@outlook'), ('@yahoo'), ('@protonmail'), ('@zoho'), ('@icloud'), ('@aol'), | |
('@uol'), ('@gmx'), ('@fastmail'), ('@mail'), ('@hustmail'), ('@yandex'), ('@tutanota'); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment