CREATE TABLE `jos_lotto` (
  `LottoID` int(11) NOT NULL auto_increment,
  `LottoDate` text NOT NULL,
  `Jackpot` int(11) NOT NULL default '0',
  `Num1` smallint(2) NOT NULL default '0',
  `Num2` smallint(2) NOT NULL default '0',
  `Num3` smallint(2) NOT NULL default '0',
  `Num4` smallint(2) NOT NULL default '0',
  `NumWinners` smallint(2) NOT NULL default '0',
  `Num3Winners` smallint(2) NOT NULL default '0',
  PRIMARY KEY  (`LottoID`)