647be4a946
* move sql files into its own folder. * move outdated updates out of the update folder, sorted by github tags * split up the db dump so my editor doesn't try to hang itself if i dare to touch that file
8 lines
428 B
SQL
8 lines
428 B
SQL
CREATE TABLE `aowow_account_favorites` (
|
|
`userId` INT(11) UNSIGNED NOT NULL,
|
|
`type` SMALLINT(5) UNSIGNED NOT NULL,
|
|
`typeId` MEDIUMINT(8) UNSIGNED NOT NULL,
|
|
UNIQUE INDEX `userId_type_typeId` (`userId`, `type`, `typeId`),
|
|
INDEX `userId` (`userId`),
|
|
CONSTRAINT `FK_acc_favorites` FOREIGN KEY (`userId`) REFERENCES `aowow_account` (`id`) ON UPDATE CASCADE ON DELETE CASCADE
|
|
) COLLATE='utf8mb4_general_ci' ENGINE=InnoDB;
|