Unnamed

CREATE TABLE `buildings`
(`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
`parent_id` INT NOT NULL,
`accommodation` INT NOT NULL,
`name` VARCHAR(100) NOT NULL)

INSERT INTO `buildings` (`id` , `parent_id` , `accommodation` , `name`)
  VALUES (1, '-1', '10', 'Main Building');
INSERT INTO `buildings` (`id` , `parent_id` , `accommodation` , `name`)
  VALUES (2, 1, '4', 'Auxiliary Building');