database setup.sql

--@block
CREATE DATABASE IF NOT EXISTS rozgr;
USE rozgr;
CREATE TABLE IF NOT EXISTS user(
    username VARCHAR(255) NOT NULL,
    password VARCHAR(255) NOT NULL,
    email VARCHAR(255) NOT NULL,
    PRIMARY KEY(username)
);
CREATE TABLE IF NOT EXISTS job(
    id INT PRIMARY KEY AUTO_INCREMENT,
    logo VARCHAR(255) NOT NULL,
    company VARCHAR(255) NOT NULL,
    location VARCHAR(255) NOT NULL,
    jobRole VARCHAR(255) NOT NULL,
    jobType VARCHAR(255) NOT NULL,
    description VARCHAR(255) NOT NULL
);
CREATE TABLE IF NOT EXISTS cv(
    id INT PRIMARY KEY AUTO_INCREMENT,
    fname VARCHAR(255) NOT NULL,
    lname VARCHAR(255) NOT NULL,
    num INT NOT NULL,
    age INT NOT NULL,
    profession VARCHAR(255) NOT NULL,
    city VARCHAR(255) NOT NULL,
    region VARCHAR(255) NOT NULL,
    country VARCHAR(255) NOT NULL,
    zipcode INT,
    socialmedia VARCHAR(255),
    jobTitle VARCHAR(255),
    employer VARCHAR(255),
    jobStartDate VARCHAR(255),
    jobEndDate VARCHAR(255),
    schoolName VARCHAR(255),
    schoolLocation VARCHAR(255),
    schoolStartDate VARCHAR(255),
    schoolEndDate VARCHAR(255),
    degree VARCHAR(255),
    skill1 VARCHAR(255),
    level1 VARCHAR(255),
    skill2 VARCHAR(255),
    level2 VARCHAR(255),
    skill3 VARCHAR(255),
    level3 VARCHAR(255),
    firstLanguage VARCHAR(255),
    fLanguagelevel VARCHAR(255),
    secondLanguage VARCHAR(255),
    sLanguagelevel VARCHAR(255),
    fReferenceName VARCHAR(255),
    fReferencePhone VARCHAR(255),
    sReferenceName VARCHAR(255),
    sReferencePhone VARCHAR(255),
    tReferenceName VARCHAR(255),
    tReferencePhone VARCHAR(255)
);