CREATE TABLE `login_attempts` (
  `ip` varchar(15) collate utf8_unicode_ci NOT NULL,
  `num` int(11) NOT NULL default '1',
  `expire` datetime NOT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY  (`ip`)
);