text: CREATE TABLE subdivision_IT (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_IT` (`id`, `name`, `level`) VALUES ('IT-65', 'Abruzzy', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-AG', 'Agrigento', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-AL', 'Alessandria', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-AN', 'Ancona', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-AR', 'Arezzo', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-AP', 'Ascoli Piceno', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-BA', 'Bari', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-77', 'Basilicata', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-BL', 'Belluno', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-BN', 'Benevento', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-BG', 'Bergamo', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-BO', 'Bologna', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-BZ', 'Bolzano', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-BS', 'Brescia', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-BR', 'Brindisi', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-CA', 'Cagliari', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-78', 'Kalábria', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-72', 'Kampánia', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-CT', 'Catania', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-CZ', 'Catanzaro', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-CO', 'Como', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-CS', 'Cosenza', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-CR', 'Cremona', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-45', 'Emilia-Romagna', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-FE', 'Ferrara', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-FI', 'Florencia', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-FG', 'Foggia', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-FO', 'Forlì', '');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-36', 'Furlansko-Júlske Benátky', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-FR', 'Frosinone', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-GE', 'Janov', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-GO', 'Gorizia', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-GR', 'Grosseto', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-75', 'Apúlia', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-AQ', 'L’Aquila', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-SP', 'La Spezia', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-62', 'Lazio', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-LE', 'Lecce', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-LC', 'Lecco', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-42', 'Ligúria', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-LI', 'Livorno', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-25', 'Lombardsko', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-LU', 'Lucca', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-MN', 'Mantova', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-57', 'Marky', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-MT', 'Matera', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-ME', 'Messina', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-MI', 'Miláno', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-MO', 'Modena', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-67', 'Molise', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-NA', 'Neapol', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-NO', 'Novara', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-PD', 'Padova', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-PA', 'Palermo', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-PR', 'Parma', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-PV', 'Pavia', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-PG', 'Perugia', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-PE', 'Pescara', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-PC', 'Piacenza', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-21', 'Piemont', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-PI', 'Pisa', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-PT', 'Pistoia', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-PZ', 'Potenza', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-PO', 'Prato', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-RA', 'Ravenna', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-RE', 'Reggio Emilia', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-23', 'Valle d’Aosta', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-RN', 'Rimini', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-RM', 'Roma', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-RO', 'Rovigo', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-SA', 'Salerno', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-88', 'Sardínia', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-SS', 'Sassari', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-82', 'Sicília', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-SI', 'Siena', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-TA', 'Tarent', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-TR', 'Terni', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-TP', 'Trapani', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-32', 'Tridentsko-Horná Adiža', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-TN', 'Trident', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-TV', 'Treviso', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-TS', 'Terst', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-TO', 'Turín', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-52', 'Toskánsko', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-UD', 'Udine', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-55', 'Umbria', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-VA', 'Varese', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-34', 'Benátsko', 'region');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-VE', 'Benátky', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-VR', 'Verona', 'province');
  INSERT INTO `subdivision_IT` (`id`, `name`, `level`) VALUES ('IT-VI', 'Vicenza', 'province');
  