CREATE TABLE IF NOT EXISTS clickgame_scores ( id INT AUTO_INCREMENT PRIMARY KEY, username VARCHAR(100) NOT NULL, score INT NOT NULL DEFAULT 0, last_updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP );