DROP TABLE IF EXISTS `test`.`test`; CREATE TABLE `test`.`test` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `nl_bez` varchar(255) NOT NULL, `nl_url` varchar(255) NOT NULL DEFAULT '0', `en_bez` varchar(255) NOT NULL, `en_url` varchar(255) NOT NULL, `fr_bez` varchar(255) NOT NULL, `fr_url` varchar(255) NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COMMENT='Testdatensätze'; INSERT INTO `test` (`id`,`nl_bez`,`nl_url`,`en_bez`,`en_url`,`fr_bez`,`fr_url`) VALUES (1,'spruiten','/spruiten','syringes','/en/syringes','seringues','/fr/seringues'), (2,'injektie','/nl/inject','injection','/en/inject','Injection','/injection');