text: CREATE TABLE subdivision_HN (id VARCHAR(6) NOT NULL, name VARCHAR(255) NOT NULL, level VARCHAR(64) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
  
  INSERT INTO `subdivision_HN` (`id`, `name`, `level`) VALUES ('HN-AT', 'Atlántida', 'department');
  INSERT INTO `subdivision_HN` (`id`, `name`, `level`) VALUES ('HN-CH', 'Choluteca', 'department');
  INSERT INTO `subdivision_HN` (`id`, `name`, `level`) VALUES ('HN-CL', 'Colón', 'department');
  INSERT INTO `subdivision_HN` (`id`, `name`, `level`) VALUES ('HN-CM', 'Comayagua', 'department');
  INSERT INTO `subdivision_HN` (`id`, `name`, `level`) VALUES ('HN-CP', 'Copán', 'department');
  INSERT INTO `subdivision_HN` (`id`, `name`, `level`) VALUES ('HN-CR', 'Cortes', 'department');
  INSERT INTO `subdivision_HN` (`id`, `name`, `level`) VALUES ('HN-EP', 'El Paraíso', 'department');
  INSERT INTO `subdivision_HN` (`id`, `name`, `level`) VALUES ('HN-FM', 'Francisco Morazán', 'department');
  INSERT INTO `subdivision_HN` (`id`, `name`, `level`) VALUES ('HN-GD', 'Gracias a Dios', 'department');
  INSERT INTO `subdivision_HN` (`id`, `name`, `level`) VALUES ('HN-IN', 'La Esperanza', 'department');
  INSERT INTO `subdivision_HN` (`id`, `name`, `level`) VALUES ('HN-IB', 'Bay Islands Department', 'department');
  INSERT INTO `subdivision_HN` (`id`, `name`, `level`) VALUES ('HN-LP', 'La Paz', 'department');
  INSERT INTO `subdivision_HN` (`id`, `name`, `level`) VALUES ('HN-LE', 'Lempira', 'department');
  INSERT INTO `subdivision_HN` (`id`, `name`, `level`) VALUES ('HN-OC', 'Ocotepeque', 'department');
  INSERT INTO `subdivision_HN` (`id`, `name`, `level`) VALUES ('HN-OL', 'Olancho Department', 'department');
  INSERT INTO `subdivision_HN` (`id`, `name`, `level`) VALUES ('HN-SB', 'Santa Barbara', 'department');
  INSERT INTO `subdivision_HN` (`id`, `name`, `level`) VALUES ('HN-VA', 'Valle', 'department');
  INSERT INTO `subdivision_HN` (`id`, `name`, `level`) VALUES ('HN-YO', 'Yoro', 'department');
  