CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `hostmask` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `id` (`id`),
  KEY `hostmask` (`hostmask`),
  KEY `hostmask_2` (`hostmask`),
  CONSTRAINT `users_fk_hostmask` FOREIGN KEY (`hostmask`) REFERENCES `hostmasks` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1