z6gE1tCd

1        CREATE TABLE IF NOT EXISTS `mydb`.`UserRole` (
2          `user_ID` INT NOT NULL,
3          `id` INT NOT NULL AUTO_INCREMENT,
4          `createDate` DATETIME NOT NULL,
5          `creatBy` VARCHAR(45) NOT NULL,
6          `UserRole` INT NOT NULL,
7          `personID` INT NOT NULL,
8          `orderNumberl` INT NOT NULL,
9          UNIQUE INDEX `id_UNIQUE` (`id` ASC),
10          PRIMARY KEY (`UserRole`),
11          UNIQUE INDEX `personID_UNIQUE` (`personID` ASC),
12          UNIQUE INDEX `user_ID_UNIQUE` (`user_ID` ASC),
13          UNIQUE INDEX `orderNumberl_UNIQUE` (`orderNumberl` ASC),
14          CONSTRAINT `personID`
15            FOREIGN KEY (`personID`)
16            REFERENCES `mydb`.`Person` (`user_id`)
17            ON DELETE NO ACTION
18            ON UPDATE NO ACTION,
19          CONSTRAINT `userID`
20            FOREIGN KEY (`user_ID`)
21            REFERENCES `mydb`.`User` (`user_id`)
22            ON DELETE NO ACTION
23            ON UPDATE NO ACTION)
24        ENGINE = InnoDB