CREATE TABLE minions
(
Id INT NOT NULL,
Name VARCHAR(255),
Age INT,
TownId INT NOT NULL,
PRIMARY KEY (Id)
);
CREATE TABLE Towns
(
Id INT NOT NULL,
Name VARCHAR(255),
PRIMARY KEY (Id)
);
ALTER TABLE minions MODIFY Id INT NOT NULL AUTO_INCREMENT;
INSERT INTO minions (Name,Age,TownId) Values ('Kevin',22,1);
INSERT INTO minions (Name,Age,TownId) Values ('Bob',15,3);
INSERT INTO minions (Name,Age,TownId) Values ('Steward',0,2);
ALTER TABLE Towns MODIFY Id INT NOT NULL AUTO_INCREMENT;
INSERT INTO Towns (Name) Values ('Sofia');
INSERT INTO Towns (Name) Values ('Plovdiv');
INSERT INTO Towns (Name) Values ('Varna');
DROP TABLE minions;
DROP TABLE towns;