DROP TABLE IF EXISTS `planethoster_tasks`;
CREATE TABLE `planethoster_tasks` (
  `PK_planethoster_tasks_id` int(11) NOT NULL,
  `libelle_planethoster_tasks` varchar(220) COLLATE utf8mb4_unicode_ci NOT NULL,
  `domain_planethoster_tasks` varchar(220) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_planethoster_tasks` varchar(220) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pass_planethoster_tasks` varchar(220) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_planethoster_tasks` datetime NOT NULL,
  `begin_planethoster_tasks` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `end_planethoster_tasks` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `done_planethoster_tasks` int(11) NOT NULL DEFAULT 0,
  `actif_planethoster_tasks` int(11) NOT NULL DEFAULT 1
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


ALTER TABLE `planethoster_tasks`
  ADD PRIMARY KEY (`PK_planethoster_tasks_id`),
  ADD KEY `actif_planethoster_tasks` (`actif_planethoster_tasks`),
  ADD KEY `done_planethoster_tasks` (`done_planethoster_tasks`),
  ADD KEY `end_planethoster_tasks` (`end_planethoster_tasks`),
  ADD KEY `begin_planethoster_tasks` (`begin_planethoster_tasks`),
  ADD KEY `created_planethoster_tasks` (`created_planethoster_tasks`),
  ADD KEY `libelle_planethoster_tasks` (`libelle_planethoster_tasks`);


ALTER TABLE `planethoster_tasks`
  MODIFY `PK_planethoster_tasks_id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;
