text: CREATE TABLE subdivision_DE (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_DE` (`id`, `name`, `level`) VALUES ('DE-BW', 'Baden-Württemberg', 'state');
  INSERT INTO `subdivision_DE` (`id`, `name`, `level`) VALUES ('DE-BY', 'Bavaria', 'state');
  INSERT INTO `subdivision_DE` (`id`, `name`, `level`) VALUES ('DE-BE', 'Berlin', 'state');
  INSERT INTO `subdivision_DE` (`id`, `name`, `level`) VALUES ('DE-BB', 'Brandenburg', 'state');
  INSERT INTO `subdivision_DE` (`id`, `name`, `level`) VALUES ('DE-HH', 'Hamburg', 'state');
  INSERT INTO `subdivision_DE` (`id`, `name`, `level`) VALUES ('DE-HE', 'Hessa', 'state');
  INSERT INTO `subdivision_DE` (`id`, `name`, `level`) VALUES ('DE-NI', 'Saxonia Inferioară', 'state');
  INSERT INTO `subdivision_DE` (`id`, `name`, `level`) VALUES ('DE-MV', 'Mecklenburg - Pomerania Inferioară', 'state');
  INSERT INTO `subdivision_DE` (`id`, `name`, `level`) VALUES ('DE-NW', 'Renania de Nord-Westfalia', 'state');
  INSERT INTO `subdivision_DE` (`id`, `name`, `level`) VALUES ('DE-RP', 'Renania-Palatinat', 'state');
  INSERT INTO `subdivision_DE` (`id`, `name`, `level`) VALUES ('DE-SL', 'Saarland', 'state');
  INSERT INTO `subdivision_DE` (`id`, `name`, `level`) VALUES ('DE-SN', 'Saxonia', 'state');
  INSERT INTO `subdivision_DE` (`id`, `name`, `level`) VALUES ('DE-ST', 'Saxonia-Anhalt', 'state');
  INSERT INTO `subdivision_DE` (`id`, `name`, `level`) VALUES ('DE-SH', 'Schleswig-Holstein', 'state');
  INSERT INTO `subdivision_DE` (`id`, `name`, `level`) VALUES ('DE-TH', 'Turingia', 'state');
  