 -- --------------------------------------------------------
 
 --
--- Table structure for table `user_status`
+-- Struttura della tabella `user_status`
 --
 
 CREATE TABLE `user_status` (

-- --------------------------------------------------------

--
-- Table structure for table `moves`
--

CREATE TABLE `moves` (

  `completed` bit(1) NOT NULL DEFAULT b'0',
  `completed_on` datetime DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `certificate_id` char(36) DEFAULT NULL,
  `certificate_sent` bit(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Indici per le tabelle scaricate
--

--
-- Indici per le tabelle `certificates_list`
--
ALTER TABLE `certificates_list`
  ADD PRIMARY KEY (`certificate_id`);

--
-- Indici per le tabelle `moves`
--
ALTER TABLE `moves`
  ADD KEY `reached_on` (`reached_on`);

--
-- Indici per le tabelle `user_status`
--
ALTER TABLE `user_status`
  ADD PRIMARY KEY (`telegram_id`);
