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;
14 CREATE TABLE IF NOT EXISTS `feeds` (
15 `f_id` int(11) NOT NULL AUTO_INCREMENT,
16 `f_url` varchar(2048) NOT NULL,
17 `f_updated` datetime NOT NULL,
18 `f_needs_update` tinyint(4) NOT NULL,
20 UNIQUE KEY `f_id` (`f_id`)
21 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;