ALTER TABLE `users` DROP `course`, DROP `cdays`;

CREATE TABLE IF NOT EXISTS `users_courses` (
  `userid` int(11) unsigned NOT NULL COMMENT 'The user id',
  `course` int(3) unsigned NOT NULL COMMENT 'The course id',
  `cdays` int(3) unsigned NOT NULL COMMENT 'Amount of days left'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;