· 8 years ago · Apr 17, 2018, 12:22 AM
1CREATE TABLE IF NOT EXISTS `mydb`.`gamemodes` (
2 `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
3 `name` VARCHAR(16) NOT NULL,
4 `abbreviation` VARCHAR(8) NULL,
5 `image` VARCHAR(32) NULL,
6 `description` VARCHAR(256) NULL,
7 `server_ids` INT UNSIGNED NULL,
8 PRIMARY KEY (`id`),
9 UNIQUE INDEX `gamemode_UNIQUE` (`name` ASC),
10 UNIQUE INDEX `gamemode_id_UNIQUE` (`id` ASC),
11 INDEX `fk_gamemodes_servers_idx` (`server_ids` ASC),
12 CONSTRAINT `gamemode_servers`
13 FOREIGN KEY (`server_ids`)
14 REFERENCES `mydb`.`servers` (`id`)
15 ON DELETE NO ACTION
16 ON UPDATE CASCADE)
17ENGINE = InnoDB;