DROP TABLE IF EXISTS `registration`;
CREATE TABLE `registration` (
  `PK_registration_id` int NOT NULL,
  `FK_users_id` int NOT NULL DEFAULT '0',
  `participe` int NOT NULL DEFAULT '0',
  `date_registration` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


ALTER TABLE `registration`
  ADD PRIMARY KEY (`PK_registration_id`),
  ADD KEY `FK_users_id` (`FK_users_id`),
  ADD KEY `participe` (`participe`);


ALTER TABLE `registration`
  MODIFY `PK_registration_id` int NOT NULL AUTO_INCREMENT;
COMMIT;