CREATE TABLE IF NOT EXISTS `Missions` (
  `MissionName` varchar(50) NOT NULL,
  `Contact` varchar(50) NULL,
  `Rank` tinyint(3) NOT NULL,
  `CashPayout` int(10) NOT NULL,
  `RPPayout` int(10) NOT NULL,
  `MinPlayers` tinyint(2) NOT NULL,
  `MaxPlayers` tinyint(2) NOT NULL,
  `Desc` TEXT NOT NULL,
  `Tips` TEXT NOT NULL,
  PRIMARY KEY (`MissionName`)
) ;