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', 'Andamanerna och Nikobarerna', 'union territory');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-AP', 'Andhra Pradesh', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-AR', 'Arunachal Pradesh', '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-CH', 'Chandigarh', 'union territory');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-CT', 'Chhattisgarh', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-DN', 'Dadra och Nagar Haveli', 'union territory');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-DD', 'Daman och Diu', '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-GJ', 'Gujarat', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-HR', 'Haryana', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-HP', 'Himachal Pradesh', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-JK', 'Jammu och Kashmir', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-JH', 'Jharkhand', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-KA', 'Karnataka', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-KL', 'Kerala', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-LD', 'Lakshadweep', 'union territory');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-MP', 'Madhya Pradesh', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-MH', 'Maharashtra', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-MN', 'Manipur', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-ML', 'Meghalaya', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-MZ', 'Mizoram', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-NL', 'Nagaland', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-OR', 'Orissa', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-PY', 'Pondicherry', 'union territory');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-PB', 'Punjab', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-RJ', 'Rajasthan', '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-TR', 'Tripura', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-UP', 'Uttar Pradesh', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-UT', 'Uttarakhand', 'state');
  INSERT INTO `subdivision_IN` (`id`, `name`, `level`) VALUES ('IN-WB', 'Västbengalen', 'state');
  