CREATE TABLE Company (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, streetaddress VARCHAR(25) DEFAULT NULL, postcode INT DEFAULT NULL, city VARCHAR(25) DEFAULT NULL, email VARCHAR(254) DEFAULT NULL, orgnr INT DEFAULT NULL, telephone VARCHAR(15) DEFAULT NULL, logofilename VARCHAR(100) DEFAULT NULL, PRIMARY KEY(id)) ENGINE = InnoDB;
CREATE TABLE Candidate (id INT AUTO_INCREMENT NOT NULL, firstname VARCHAR(255) NOT NULL, surname VARCHAR(255) NOT NULL, email VARCHAR(255) NOT NULL, streetname VARCHAR(255) NOT NULL, streetnr INT NOT NULL, birthyear INT NOT NULL, pul TINYINT(1) NOT NULL, ip VARCHAR(255) NOT NULL, PRIMARY KEY(id)) ENGINE = InnoDB;
CREATE TABLE Job (id INT AUTO_INCREMENT NOT NULL, position_id INT DEFAULT NULL, title VARCHAR(255) NOT NULL, description LONGTEXT NOT NULL, created DATETIME NOT NULL, start DATETIME NOT NULL, end DATETIME NOT NULL, publish DATETIME NOT NULL, unpublish DATETIME NOT NULL, image VARCHAR(100) DEFAULT NULL, INDEX IDX_C395A618DD842E46 (position_id), PRIMARY KEY(id)) ENGINE = InnoDB;
CREATE TABLE Position (id INT AUTO_INCREMENT NOT NULL, position VARCHAR(100) NOT NULL, PRIMARY KEY(id)) ENGINE = InnoDB;
ALTER TABLE Job ADD FOREIGN KEY (position_id) REFERENCES Position(id)