All pastes #476029 Raw Edit

Mine

public text v1 · immutable
·published 2007-05-07 21:02 UTC
rendered paste body
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