CREATE TABLE IF NOT EXISTS `player_wings` (
`player_id` int NOT NULL DEFAULT '0',
`wing_id` smallint unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`player_id`,`wing_id`),
FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8;
CREATE TABLE IF NOT EXISTS `player_effects` (
`player_id` int NOT NULL DEFAULT '0',
`effect_id` smallint unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`player_id`,`effect_id`),
FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8;
CREATE TABLE IF NOT EXISTS `player_auras` (
`player_id` int NOT NULL DEFAULT '0',
`aura_id` smallint unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`player_id`,`aura_id`),
FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8;
CREATE TABLE IF NOT EXISTS `player_shaders` (
`player_id` int(11) NOT NULL DEFAULT 0,
`shader_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (`player_id`, `shader_id`),
FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8;