DROP TABLE IF EXISTS avanzamenti;
CREATE TABLE avanzamenti (
    entry               INT PRIMARY KEY AUTO_INCREMENT,
    ts                  TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    codice              VARCHAR(2),
    stato               enum('not_started','ongoing','finished') DEFAULT 'not_started',
    start               DATE DEFAULT NULL,
    end                 DATE DEFAULT NULL,  
    testo               TEXT
) ENGINE=INNODB;

