· 6 years ago · Jun 28, 2019, 07:56 AM
1Executing SQL script in server
2ERROR: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '
3 INDEX `IdMagnitud_idx` (`IdMagnitud` ASC) VISIBLE,
4 CONSTRAINT `IdEmpleado`
5' at line 15
6
7SQL Code:
8 -- -----------------------------------------------------
9 -- Table `fromi`.`Actividad`
10 -- -----------------------------------------------------
11 CREATE TABLE IF NOT EXISTS `fromi`.`Actividad` (
12 `idActividad` INT NOT NULL AUTO_INCREMENT,
13 `dia` VARCHAR(45) NOT NULL,
14 `actividad` VARCHAR(45) NOT NULL,
15 `equipEntrante` VARCHAR(45) NOT NULL,
16 `equipSalida` VARCHAR(45) NOT NULL,
17 `equipEntregados` VARCHAR(45) NOT NULL,
18 `observaciones` VARCHAR(45) NOT NULL,
19 `IdEmpleados` INT NOT NULL,
20 `IdMagnitud` INT NOT NULL,
21 PRIMARY KEY (`idActividad`),
22 INDEX `IdEmpleado_idx` (`IdEmpleados` ASC) VISIBLE,
23 INDEX `IdMagnitud_idx` (`IdMagnitud` ASC) VISIBLE,
24 CONSTRAINT `IdEmpleado`
25 FOREIGN KEY (`IdEmpleados`)
26 REFERENCES `fromi`.`Empleados` (`IdEmpleado`)
27 ON DELETE NO ACTION
28 ON UPDATE NO ACTION,
29 CONSTRAINT `IdMagnitud`
30 FOREIGN KEY (`IdMagnitud`)
31 REFERENCES `fromi`.`Magnitud` (`IdMagnitud`)
32 ON DELETE NO ACTION
33 ON UPDATE NO ACTION)
34 ENGINE = InnoDB
35
36SQL script execution finished: statements: 9 succeeded, 1 failed
37
38Fetching back view definitions in final form.
39Nothing to fetch