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 (NULL , '-1', '10', 'Main Building'),
	(NULL , LAST_INSERT_ID() , '4', 'Auxiliary Building');