
Originally Posted by
gammer123
-- ----------------------------
-- Table structure for vouchers
-- ----------------------------
CREATE TABLE `vouchers` (
`voucher` varchar(20) collate latin1_general_ci NOT NULL default '',
`type` enum('item','credits') collate latin1_general_ci NOT NULL default 'credits',
`credits` int(5) default NULL,
PRIMARY KEY (`voucher`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
have any a FIX for Vouchers this dont work. ????
Ah, you didn't run upgrade.php I see.
Do this in PHPMyAdmin (it's a query):
Code:
ALTER TABLE `vouchers` CHANGE `voucher` `voucher` VARCHAR( 20 ) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL ,
CHANGE `type` `type` ENUM( 'item', 'credits' ) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'credits',
CHANGE `credits` `credits` VARCHAR( 255 ) NULL DEFAULT NULL;