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');