· 7 years ago · Nov 10, 2018, 12:26 PM
1Executing SQL script in server
2 ERROR: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE,
3 INDEX `fk_Order_User2_idx` (`Manager` ASC) VISIBLE,
4 CONSTRAINT `fk_' at line 12
5 SQL Code:
6 -- -----------------------------------------------------
7 -- Table `ws`.`Order`
8 -- -----------------------------------------------------
9 CREATE TABLE IF NOT EXISTS `ws`.`Order` (
10 `Number` INT NOT NULL,
11 `Date` DATE NOT NULL,
12 `Stage` VARCHAR(45) NOT NULL,
13 `Client` VARCHAR(45) NOT NULL,
14 `Manager` VARCHAR(45) NULL DEFAULT 'null',
15 `Price` INT NULL DEFAULT NULL,
16 PRIMARY KEY (`Number`, `Date`),
17 INDEX `fk_Order_User1_idx` (`Client` ASC) VISIBLE,
18 INDEX `fk_Order_User2_idx` (`Manager` ASC) VISIBLE,
19 CONSTRAINT `fk_Order_User1`
20 FOREIGN KEY (`Client`)
21 REFERENCES `ws`.`User` (`Login`)
22 ON DELETE NO ACTION
23 ON UPDATE NO ACTION,
24 CONSTRAINT `fk_Order_User2`
25 FOREIGN KEY (`Manager`)
26 REFERENCES `ws`.`User` (`Login`)
27 ON DELETE NO ACTION
28 ON UPDATE NO ACTION)
29 ENGINE = InnoDB
30
31 SQL script execution finished: statements: 7 succeeded, 1 failed
32
33 Fetching back view definitions in final form.
34 Nothing to fetch
35 Executing SQL script in server
36 ERROR: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE,
37 INDEX `fk_Order_User2_idx` (`Manager` ASC) VISIBLE,
38 CONSTRAINT `fk_' at line 12
39 SQL Code:
40 -- -----------------------------------------------------
41 -- Table `ws`.`Order`
42 -- -----------------------------------------------------
43 CREATE TABLE IF NOT EXISTS `ws`.`Order` (
44 `Number` INT NOT NULL,
45 `Date` DATE NOT NULL,
46 `Stage` VARCHAR(45) NOT NULL,
47 `Client` VARCHAR(45) NOT NULL,
48 `Manager` VARCHAR(45) NULL DEFAULT 'null',
49 `Price` INT NULL DEFAULT NULL,
50 PRIMARY KEY (`Number`, `Date`),
51 INDEX `fk_Order_User1_idx` (`Client` ASC) VISIBLE,
52 INDEX `fk_Order_User2_idx` (`Manager` ASC) VISIBLE,
53 CONSTRAINT `fk_Order_User1`
54 FOREIGN KEY (`Client`)
55 REFERENCES `ws`.`User` (`Login`)
56 ON DELETE NO ACTION
57 ON UPDATE NO ACTION,
58 CONSTRAINT `fk_Order_User2`
59 FOREIGN KEY (`Manager`)
60 REFERENCES `ws`.`User` (`Login`)
61 ON DELETE NO ACTION
62 ON UPDATE NO ACTION)
63 ENGINE = InnoDB
64
65 SQL script execution finished: statements: 7 succeeded, 1 failed
66
67 Fetching back view definitions in final form.
68 Nothing to fetch