text: CREATE TABLE subdivision_CH (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_CH` (`id`, `name`, `level`) VALUES ('CH-AG', 'ארגאו', 'canton');
  INSERT INTO `subdivision_CH` (`id`, `name`, `level`) VALUES ('CH-BE', 'ברן', 'canton');
  INSERT INTO `subdivision_CH` (`id`, `name`, `level`) VALUES ('CH-FR', 'פריבור', 'canton');
  INSERT INTO `subdivision_CH` (`id`, `name`, `level`) VALUES ('CH-GR', 'גראובינדן', 'canton');
  INSERT INTO `subdivision_CH` (`id`, `name`, `level`) VALUES ('CH-NW', 'נידוולדן', 'canton');
  INSERT INTO `subdivision_CH` (`id`, `name`, `level`) VALUES ('CH-OW', 'אובוולדן', 'canton');
  INSERT INTO `subdivision_CH` (`id`, `name`, `level`) VALUES ('CH-SG', 'סנט גאלן', 'canton');
  INSERT INTO `subdivision_CH` (`id`, `name`, `level`) VALUES ('CH-SO', 'זולותורן', 'canton');
  INSERT INTO `subdivision_CH` (`id`, `name`, `level`) VALUES ('CH-TG', 'תורגאו', 'canton');
  INSERT INTO `subdivision_CH` (`id`, `name`, `level`) VALUES ('CH-VS', 'ואלה', 'canton');
  INSERT INTO `subdivision_CH` (`id`, `name`, `level`) VALUES ('CH-VD', 'וו', 'canton');
  INSERT INTO `subdivision_CH` (`id`, `name`, `level`) VALUES ('CH-LU', 'לוצרן', 'canton');
  INSERT INTO `subdivision_CH` (`id`, `name`, `level`) VALUES ('CH-ZH', 'ציריך', 'canton');
  