text: CREATE TABLE subdivision_IN (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_IN` (`id`, `name`, `level`) VALUES ('IN-AN', 'Андамани и Никобари', 'union territory');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-AP', 'Андра Прадеш', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-AR', 'Аруначал Прадеш', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-AS', 'Асам', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-BR', 'Бихар', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-CH', 'Чандигар', 'union territory');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-CT', 'Чатисгар', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-DN', 'Дадра и Нагар Хавели', 'union territory');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-DD', 'Даман и Диу', 'union territory');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-DL', 'Делхи', 'union territory');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-GA', 'Гоа', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-GJ', 'Гуџарат', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-HR', 'Харајана', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-HP', 'Химачал Прадеш', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-JH', 'Џарканд', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-KA', 'Карнатака', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-KL', 'Керала', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-LD', 'Лакадиви', 'union territory');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-MP', 'Мадја Прадеш', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-MH', 'Махараштра', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-MN', 'Манипур', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-ML', 'Мегхалаја', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-MZ', 'Мизорам', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-NL', 'Нагаланд', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-OR', 'Ориса', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-PY', 'Територија Пондишери', 'union territory');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-RJ', 'Раџастан', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-SK', 'Сиким', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-TN', 'Тамил Наду', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-TR', 'Трипура', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-UP', 'Утар Прадеш', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-UT', 'Утаранчал', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-WB', 'Западни Бенгал', 'state');
  