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', 'Andaman e Nicobar', 'union territory');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-AP', 'Andra Pradex', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-AS', 'Assam', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-BR', 'Bihar', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-DN', 'Dadra e Nagar Haveli', 'union territory');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-DL', 'Delhi - दिल्ली', 'union territory');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-GA', 'Goa - गोंय', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-HR', 'Haryana', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-OR', 'Orissa', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-SK', 'Sikkim', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-TN', 'Tamil Nadu', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-UP', 'Uttar Pradesh', 'state');
  