`regid` int(5) NOT NULL DEFAULT '0',
`locid` int(7) NOT NULL DEFAULT '0',
`listme` int(1) NOT NULL DEFAULT '0',
+ `contactinfo` varchar(255) NOT NULL DEFAULT '',
`admin` tinyint(1) NOT NULL DEFAULT '0',
`language` varchar(5) NOT NULL DEFAULT '',
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`when` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`configId` int(13) NOT NULL,
`state` enum('open', 'success', 'failed') NOT NULL,
- `result` varchar(255) NOT NULL
+ `challenge` varchar(16),
+ `result` varchar(255)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `baddomains`;
`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 '',