Page 28 - Portafolio

DELETE FROM `url`;
/*!40000 ALTER TABLE `url` DISABLE KEYS */;
/*!40000 ALTER TABLE `url` ENABLE KEYS */;

-- Volcando estructura para tabla problema 1.usuario
CREATE TABLE IF NOT EXISTS `usuario` (
`codigo` char(50) NOT NULL,
`nombre` tinytext DEFAULT NULL,
`apellido` tinytext DEFAULT NULL,
`edad` char(50) DEFAULT NULL,
`direccion` tinytext DEFAULT NULL,
`IdLibro` char(50) NOT NULL,
PRIMARY KEY (`codigo`),
KEY `IdLibro` (`IdLibro`),
CONSTRAINT `FK_usuario_libro` FOREIGN KEY (`IdLibro`) REFERENCES
`libro` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Volcando datos para la tabla problema 1.usuario: ~0 rows
(aproximadamente)
DELETE FROM `usuario`;
/*!40000 ALTER TABLE `usuario` DISABLE KEYS */;
/*!40000 ALTER TABLE `usuario` ENABLE KEYS */;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;