6JFKGwUE

1CREATE TABLE IF NOT EXISTS `usuarios` (
2  `nif` varchar(9) COLLATE utf8_spanish_ci NOT NULL,
3  `password` varchar(15) COLLATE utf8_spanish_ci NOT NULL,
4  `idCurso` varchar(15) COLLATE utf8_spanish_ci NOT NULL,
5  PRIMARY KEY (`nif`),
6  KEY `idCurso` (`idCurso`)
7) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
8
9
10CREATE TABLE IF NOT EXISTS `curso` (
11  `idCurso` varchar(15) COLLATE utf8_spanish_ci NOT NULL,
12  PRIMARY KEY (`idCurso`),
13  KEY `idCurso` (`idCurso`) USING BTREE
14) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci; 
15     
16ALTER TABLE `usuarios`
17  ADD CONSTRAINT `fk_curso` FOREIGN KEY (`idCurso`) REFERENCES `curso` (`idCurso`) ON DELETE CASCADE ON UPDATE CASCADE;
18COMMIT;