The table required to save/retrieve data from submitted score results. MySQL

games_leaderboard.sql

delimiter $$

CREATE TABLE `games_leaderboard` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `game` varchar(45) DEFAULT NULL,
  `name` varchar(45) DEFAULT NULL,
  `score` int(3) DEFAULT NULL,
  `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `user` int(11) DEFAULT NULL,
  `session` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `session_UNIQUE` (`session`)
) ENGINE=MyISAM AUTO_INCREMENT=223 DEFAULT CHARSET=utf8$$