- Executing SQL script in server
- ERROR: 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 '
- CONSTRAINT `creatorid`
- FOREIGN KEY (`creatorid`)
- REFERENCES `azzie...' at line 9
- SQL Code:
- -- -----------------------------------------------------
- -- Table `azziedev_attendtudb`.`sessions`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `azziedev_attendtudb`.`sessions` (
- `idsessions` INT NOT NULL,
- `creatorid` VARCHAR(20) NOT NULL,
- `courseid` INT NULL,
- PRIMARY KEY (`idsessions`),
- INDEX `netid_idx` (`creatorid` ASC) INVISIBLE,
- CONSTRAINT `creatorid`
- FOREIGN KEY (`creatorid`)
- REFERENCES `azziedev_attendtudb`.`users` (`netid`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION)
- ENGINE = InnoDB
- SQL script execution finished: statements: 8 succeeded, 1 failed
- Fetching back view definitions in final form.
- Nothing to fetch