· 8 years ago · May 21, 2018, 03:34 PM
1CREATE TABLE IF NOT EXISTS `wait_faction` (
2 `perso_id` int(10) unsigned NOT NULL,
3 `faction_id` mediumint(8) unsigned NOT NULL,
4 `demandeur` bit(1) NOT NULL DEFAULT b'0' COMMENT 'Vaut 1 si l''utilisateur est le demandeur, 0 si c''est la faction',
5 `id` int(11) NOT NULL,
6 `utilisateur_id` int(11) NOT NULL,
7 PRIMARY KEY (`perso_id`,`faction_id`),
8 KEY `FK_WaitFaction_Persos` (`perso_id`),
9 KEY `FK_WaitFaction_Factions` (`faction_id`)
10) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;