CREATE TABLE subdivision_NL (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_NL` (`id`, `name`, `level`) VALUES ('NL-AW', 'Aruba', 'country');
INSERT INTO `subdivision_NL` (`id`, `name`, `level`) VALUES ('NL-BQ1', 'Bonaire', 'special municipality');
INSERT INTO `subdivision_NL` (`id`, `name`, `level`) VALUES ('NL-CW', 'Curaçao', 'country');
INSERT INTO `subdivision_NL` (`id`, `name`, `level`) VALUES ('NL-DR', 'Provënz Drenthe', 'province');
INSERT INTO `subdivision_NL` (`id`, `name`, `level`) VALUES ('NL-FL', 'Provënz Flevoland', 'province');
INSERT INTO `subdivision_NL` (`id`, `name`, `level`) VALUES ('NL-FR', 'Provënz Friesland', 'province');
INSERT INTO `subdivision_NL` (`id`, `name`, `level`) VALUES ('NL-GE', 'Provënz Gelderland', 'province');
INSERT INTO `subdivision_NL` (`id`, `name`, `level`) VALUES ('NL-LI', 'Limburg', 'province');
INSERT INTO `subdivision_NL` (`id`, `name`, `level`) VALUES ('NL-NB', 'Provënz Nordbrabant', 'province');
INSERT INTO `subdivision_NL` (`id`, `name`, `level`) VALUES ('NL-NH', 'Provënz Nordholland', 'province');
INSERT INTO `subdivision_NL` (`id`, `name`, `level`) VALUES ('NL-OV', 'Provënz Overijssel', 'province');
INSERT INTO `subdivision_NL` (`id`, `name`, `level`) VALUES ('NL-ZH', 'Provënz Südholland', 'province');
INSERT INTO `subdivision_NL` (`id`, `name`, `level`) VALUES ('NL-UT', 'Utrecht', 'province');
INSERT INTO `subdivision_NL` (`id`, `name`, `level`) VALUES ('NL-ZE', 'Provënz Zeeland', 'province');
