f3RdvRUC

1--
2-- Structure de la table `relation`
3--
4
5DROP TABLE IF EXISTS `relation`;
6    CREATE TABLE IF NOT EXISTS `relation` (
7  `applicantpseudo` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
8  `wishpseudo` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
9  `created_at` timestamp NULL DEFAULT NULL,
10  `updated_at` timestamp NULL DEFAULT NULL,
11  `incall` tinyint(1) NOT NULL DEFAULT '0',
12  CONSTRAINT pk_relation PRIMARY KEY (`applicantpseudo`,`wishpseudo`)
13) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
14
15--
16-- Structure de la table `match_applicant`
17--
18
19DROP TABLE IF EXISTS `match_applicant`;
20CREATE TABLE IF NOT EXISTS `match_applicant` (
21  `pseudo` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
22  `applicantpseudo` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
23  `wishpseudo` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
24  `match` tinyint(1) NOT NULL DEFAULT '0',
25  CONSTRAINT pk_relation PRIMARY KEY (`pseudo`,`applicantpseudo`,`wishpseudo`),
26  CONSTRAINT test FOREIGN KEY (applicantpseudo) REFERENCES relation (applicantpseudo),
27  CONSTRAINT test2 FOREIGN KEY (wishpseudo) REFERENCES relation (wishpseudo)
28) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;