k81RHhEX

1CREATE TABLE IF NOT EXISTS `testdatabase`.`friends` (
2 `Id` INT(11) NOT NULL AUTO_INCREMENT,
3 `CurrentUserId` INT(11) NOT NULL,
4 `PickedUserId` INT(11) NOT NULL,
5 PRIMARY KEY (`Id`),
6 INDEX `IX_Friends_CurrentUserId` (`CurrentUserId` ASC) INVISIBLE,
7 INDEX `IX_Friends_PickedUserId` (`PickedUserId` ASC) VISIBLE,
8 CONSTRAINT `FK_Friends_Users_CurrentUserId`
9    FOREIGN KEY (`CurrentUserId`)
10    REFERENCES `cyberdatabase`.`users` (`Id`)
11    ON DELETE CASCADE,
12 CONSTRAINT `FK_Friends_Users_PickedUserId`
13    FOREIGN KEY (`PickedUserId`)
14    REFERENCES `cyberdatabase`.`users` (`Id`)
15    ON DELETE CASCADE)
16ENGINE = InnoDB
17AUTO_INCREMENT = 8
18DEFAULT CHARACTER SET = utf8mb4
19COLLATE = utf8mb4_0900_ai_ci
20	
21ALTER TABLE `testdatabase`.`friends`
22  ADD UNIQUE KEY (CurrentUserId, PickedUserId)