`when` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`configId` int(13) NOT NULL,
`state` enum('open', 'success', 'failed') NOT NULL,
- `challenge` varchar(16) NOT NULL,
+ `challenge` varchar(16),
`result` varchar(255)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
`id` int(11) NOT NULL AUTO_INCREMENT,
`from` int(11) NOT NULL DEFAULT '0',
`to` int(11) NOT NULL DEFAULT '0',
- `awarded` int(3) NOT NULL DEFAULT '0',
`points` int(3) NOT NULL DEFAULT '0',
`method` enum('Face to Face Meeting','Trusted Third Parties','Thawte Points Transfer','Administrative Increase','CT Magazine - Germany','Temporary Increase','Unknown','TOPUP','TTP-Assisted') NOT NULL DEFAULT 'Face to Face Meeting',
`location` varchar(255) NOT NULL DEFAULT '',