I keep getting error 1064 in mysql whenever I try to forward engineer the EER map that been made – November 4, 2022 at 03:21PM

Executing SQL script in server 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 ') VIRTUAL, `TOTAL_PRICE` INT NOT NULL, PRIMARY KEY (`ORDER_HEADER_ID`), UN' at line 8 SQL Code: -- ----------------------------------------------------- -- Table `mydb`.`` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `mydb`.`` ( `ORDER_HEADER_ID` INT NOT NULL, `USER_ID` INT NOT NULL, `ORDER_NUMBER` VARCHAR(45) NOT NULL, `ORDER_DATE` DATETIME GENERATED ALWAYS AS () VIRTUAL, `TOTAL_PRICE` INT NOT NULL, PRIMARY KEY (`ORDER_HEADER_ID`), UNIQUE INDEX `Order_number_UNIQUE` (`ORDER_NUMBER` ASC) VISIBLE, INDEX `USER_ID_idx` (`USER_ID` ASC) VISIBLE, CONSTRAINT `USER_ID` FOREIGN KEY (`USER_ID`) REFERENCES `mydb`.`CUSTOMER` (`USER_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB 

I have tried everything, like getting rid of VISIBLE from Order_number and USER_ID or deleting the comma in line INDEX USER_ID_idx
(USER_ID
ASC) VISIBLE, . Nothing seems to be working, how can I fix this and get my forward engineering working without any errors. I am aware that problem is visible as it says there, “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 ‘) VIRTUAL” but nothing i did seemed to work and get it fixed