text: CREATE TABLE subdivision_FR (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_FR` (`id`, `name`, `level`) VALUES ('FR-01', 'Ain', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-02', 'Aisne', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-03', 'Allier', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-06', 'Alpes Marítimos', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-04', 'Alpes da Alta Provenza', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-A', 'Alsacia', 'metropolitan regions');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-B', 'Aquitania', 'metropolitan regions');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-07', 'Ardèche', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-09', 'Ariège', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-10', 'Aube', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-11', 'Aude', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-12', 'Aveyron', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-67', 'Baixo Rin', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-13', 'Bocas de Ródano', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-E', 'Bretaña', 'metropolitan regions');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-14', 'Calvados', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-15', 'Cantal', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-G', 'Champaña-Ardenas', 'metropolitan regions');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-16', 'Charente', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-17', 'Charente Marítimo', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-18', 'Cher', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-CP', 'Illa Clipperton', 'dependency');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-19', 'Corrèze', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-2A', 'Córsega do Sur', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-H', 'Córsega - Corse - Corsica', 'metropolitan regions');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-23', 'Creuse', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-79', 'Deux-Sèvres', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-24', 'Dordoña', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-25', 'Doubs', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-26', 'Drôme', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-91', 'Essonne', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-27', 'Eure', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-28', 'Eure e Loir', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-29', 'Finistère', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-I', 'Franco Condado', 'metropolitan regions');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-30', 'Gard', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-32', 'Gers', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-33', 'Xironda', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-GP', 'Guadalupe - Guadeloupe', 'overseas regions');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-68', 'Alto Rin', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-2B', 'Alta Córsega', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-31', 'Alta Garona', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-P', 'Baixa Normandía', 'metropolitan regions');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-GF', 'Güiana Francesa - Guyane française', 'overseas regions');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-43', 'Alto Loira', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-52', 'Alto Marne', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-74', 'Alta Savoia', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-70', 'Alto Saona', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-87', 'Alto Vienne', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-05', 'Alpes Altos', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-65', 'Altos Pireneos', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-92', 'Hauts-de-Seine', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-34', 'Hérault', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-35', 'Ille e Vilaine', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-36', 'Indre', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-37', 'Indre e Loira', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-38', 'Isère', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-39', 'Jura', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-K', 'Languedoc-Rosellón', 'metropolitan regions');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-L', 'Lemosín', 'metropolitan regions');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-41', 'Loir e Cher', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-42', 'Loira', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-44', 'Loira Atlántico', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-45', 'Loiret', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-47', 'Lot e Garona', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-48', 'Lozère', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-49', 'Maine e Loira', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-50', 'Mancha', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-51', 'Marne', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-MQ', 'Martinica - Martinique', 'overseas regions');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-53', 'Mayenne', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-YT', 'Mayotte', 'territorial collectivity');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-54', 'Meurthe e Mosela', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-55', 'Mosa', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-N', 'Mediodía-Pireneos', 'metropolitan regions');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-56', 'Morbihan', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-57', 'Mosela', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-58', 'Nièvre', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-O', 'Norte-Paso de Calais', 'metropolitan regions');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-60', 'Oise', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-61', 'Orne', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-75', 'París - Paris', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-62', 'Pas-de-Calais', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-R', 'País do Loira', 'metropolitan regions');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-S', 'Picardía', 'metropolitan regions');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-T', 'Poitou-Charentes', 'metropolitan regions');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-Q', 'Alta Normandía', 'metropolitan regions');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-PF', 'Polinesia Francesa - Polynésie française', 'overseas territory');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-NC', 'Nova Caledonia', 'overseas territory');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-RE', 'Reunión - Réunion', 'overseas regions');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-U', 'Provenza-Alpes-Costa Azul', 'metropolitan regions');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-63', 'Puy-de-Dôme', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-64', 'Pireneos Atlánticos', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-66', 'Pireneos Orientais', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-69', 'Río Ródano', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-V', 'Ródano-Alpes', 'metropolitan regions');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-72', 'Sarthe', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-73', 'Savoia', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-71', 'Saona e Loira', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-76', 'Seine-Maritime', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-93', 'Sena-San Denis', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-77', 'Sena e Marne', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-82', 'Tarn-et-Garonne', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-90', 'Territorio de Belfort', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-95', 'Val do Oise', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-94', 'Val do Marne', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-83', 'Var', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-84', 'Vaucluse', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-85', 'Vendée', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-86', 'Vienne', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-88', 'Vosgos', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-89', 'Yonne', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-78', 'Yvelines', 'metropolitan department');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-BL', 'San Bartolomé - Saint-Barthélemy', 'overseas territorial collectivity');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-PM', 'San Pedro e Miguelón - Saint Pierre et Miquelon', 'territorial collectivity');
  INSERT INTO `subdivision_FR` (`id`, `name`, `level`) VALUES ('FR-WF', 'Wallis e Futuna', 'overseas territory');
  