02-mysql

CREATE TABLE `minions` (
  `id` INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(45) NULL,
  `age` INT NULL
);

CREATE TABLE `towns` (
  `town_id` INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(45) NULL
);

ALTER TABLE `minions`
ADD COLUMN `town_id` INT NULL;
ADD CONSTRAINT `fk_minions_towns`
  FOREIGN KEY (`town_id`)
  REFERENCES `towns` (`id`);

INSERT INTO `minions` (`id`, `name`, `age`, `town_id`)
VALUES
('1', 'Kevin', '22', '1'),
('2', 'Bob', '15', '3'),
('3', 'Steward', null, '2');

INSERT INTO `towns` (`id`, `name`)
VALUES
('1', 'Sofia'),
('2', 'Plovdiv'),
('3', 'Varna');

TRUNCATE `minions`;

DROP TABLE `minions`, `towns`;
----------------------------------------
CREATE SCHEMA `people` ;