1 CREATE TABLE IF NOT EXISTS `pingbacks` (
2 `p_id` int(11) NOT NULL AUTO_INCREMENT,
3 `p_source` varchar(1024) NOT NULL,
4 `p_target` varchar(1024) NOT NULL,
5 `p_time` datetime NOT NULL,
6 `p_client_ip` varchar(40) NOT NULL,
7 `p_client_agent` varchar(128) NOT NULL,
8 `p_client_referer` varchar(1024) NOT NULL,
10 UNIQUE KEY `p_id` (`p_id`)
11 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;