SQL Registro

CREATE TABLE `registro` (
  `id` int(11) NOT NULL PRIMARY KEY,
  `player_id` text CHARACTER SET utf8 NOT NULL,
  `player_name` text CHARACTER SET utf8 NOT NULL,
  `type` text CHARACTER SET utf8 NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `info` text CHARACTER SET utf8 NOT NULL,
  `location` text COLLATE utf8_unicode_ci NOT NULL,
  `equipo` text COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;