DragonByte Tech
Well-known member
There was a short period of time where the lotteryticket table was missing from the installer. Try running this:
Fillip
Code:
CREATE TABLE `xf_dbtech_shop_lotteryticket` (
`lotteryticketid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`lotteryid` int(10) unsigned NOT NULL DEFAULT '0',
`userid` int(10) unsigned NOT NULL DEFAULT '0',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`lotterydraw` int(10) unsigned NOT NULL DEFAULT '0',
`numbers` mediumblob,
`prizeid` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`lotteryticketid`),
KEY `lotteryid` (`lotteryid`,`userid`),
KEY `lotteryid_2` (`lotteryid`,`lotterydraw`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Fillip