-CREATE TABLE `pingbacks` (
- `p_id` int(11) NOT NULL AUTO_INCREMENT,
- `p_source` varchar(1024) CHARACTER SET latin1 NOT NULL,
- `p_target` varchar(1024) CHARACTER SET latin1 NOT NULL,
- `p_time` datetime NOT NULL,
- `p_client_ip` varchar(40) CHARACTER SET latin1 NOT NULL,
- `p_client_agent` varchar(128) CHARACTER SET latin1 NOT NULL,
- `p_client_referer` varchar(1024) CHARACTER SET latin1 NOT NULL,
- `p_needs_review` tinyint(1) NOT NULL,
- `p_use` tinyint(1) NOT NULL,
- `p_needs_update` tinyint(1) NOT NULL,
- PRIMARY KEY (`p_id`),
- UNIQUE KEY `p_id` (`p_id`)
+CREATE TABLE `linkbacks` (
+ `l_id` int(11) NOT NULL AUTO_INCREMENT,
+ `l_source` varchar(1024) CHARACTER SET utf8 NOT NULL,
+ `l_target` varchar(1024) CHARACTER SET utf8 NOT NULL,
+ `l_time` datetime NOT NULL,
+ `l_client_ip` varchar(40) CHARACTER SET utf8 NOT NULL,
+ `l_client_agent` varchar(128) CHARACTER SET utf8 NOT NULL,
+ `l_client_referer` varchar(1024) CHARACTER SET utf8 NOT NULL,
+ `l_needs_review` tinyint(1) NOT NULL,
+ `l_use` tinyint(1) NOT NULL,
+ `l_needs_update` tinyint(1) NOT NULL,
+ PRIMARY KEY (`l_id`),
+ UNIQUE KEY `l_id` (`l_id`)