Aktywne Wpisy
TurkusowyRisso +37
Może jakaś kontrola nadgarstków w "nowym" czasie
#zegarki #zegarkiboners #watchboners #kontrolanadgarstkow
#zegarki #zegarkiboners #watchboners #kontrolanadgarstkow
mogadishu +15
Skopiuj link
Skopiuj linkWykop.pl
Executing SQL script in server
wypokERROR: Error 1215: Cannot add foreign key constraint
SQL Code:
-- -----------------------------------------------------
-- Table
.
userrole
wypok-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS
.
userrole(
rolenameVARCHAR(45) NOT NULL,
usernameVARCHAR(45) NOT NULL,
rolenamePRIMARY KEY (
,
username),
fkrolehasuserrole1idxINDEX
(
rolenameASC),
fkuserroleuserusernameidxINDEX
(
usernameASC),
fkrolehasuserrole1CONSTRAINT
rolenameFOREIGN KEY (
)
wypokREFERENCES
.
role(
rolename)
fkuserroleuser_usernameON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT
usernameFOREIGN KEY (
)
wypokREFERENCES
.
user(
username)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
SQL script execution finished: statements: 9 succeeded, 1 failed
Całe zapytanie :https://pastebin.com/UVLB2TSv
#naukaprogramowania #pytaniedoeksperta
Komentarz usunięty przez autora