CREATE TABLE `test` (
  `id` bigint(20) NOT NULL auto_increment,
  `name` varchar(256) NOT NULL,
  `foreignId` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;