CREATE TABLE IF NOT EXISTS `claves_1_uso` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `idusuario` INT(11) NOT NULL,
  `salt` CHAR(64) COLLATE utf8_unicode_ci NOT NULL,
  `pass` CHAR(64) COLLATE utf8_unicode_ci NOT NULL,
  `frase` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL,
  `usada` tinyint(4) NOT NULL DEFAULT '0',
  `fecha_uso` datetime NOT NULL,
  `ip_uso` CHAR(15) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idusuario` (`idusuario`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ;

ALTER TABLE `claves_1_uso`
  ADD CONSTRAINT `claves_1_uso_ibfk_1` FOREIGN KEY (`idusuario`) REFERENCES `usuarios` (`idusuarios`) ON DELETE CASCADE ON UPDATE CASCADE;