CREATE TABLE `cities`( `id` INT NOT NULL, `name` VARCHAR(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=INNODB CHARSET=utf8 COLLATE=utf8_general_ci; 
ALTER TABLE `cities` CHANGE `id` `id` INT(11) NOT NULL AUTO_INCREMENT; 

ALTER TABLE `companies` ADD COLUMN `city` VARCHAR(100) DEFAULT "Kraków" NOT NULL AFTER `imageFolder`, ADD COLUMN `zip_code` VARCHAR(7) NULL AFTER `city`, ADD COLUMN `street` VARCHAR(255) NULL AFTER `zip_code`;
ALTER TABLE `companies` ADD COLUMN `date` DATETIME NULL AFTER `street`; 
ALTER TABLE `companies` CHANGE `date` `date` TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL; 

INSERT INTO cities (`name`)
VALUES ('Kraków'), ('Warszawa'), ('Wrocław'), ('Poznań'), ('Kraków'), ('Gdańsk'), ('Szczecin'), ('Łódź'), ('Lublin'), ('Katowice')