3 DROP TABLE IF EXISTS `feedentries`;
4 CREATE TABLE `feedentries` (
5 `fe_id` int(11) NOT NULL AUTO_INCREMENT,
6 `fe_f_id` int(11) NOT NULL,
7 `fe_url` varchar(2048) CHARACTER SET utf8 NOT NULL,
8 `fe_updated` datetime NOT NULL,
9 `fe_needs_update` tinyint(1) NOT NULL,
10 PRIMARY KEY (`fe_id`),
11 UNIQUE KEY `fe_id` (`fe_id`)
12 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
15 DROP TABLE IF EXISTS `feedentryurls`;
16 CREATE TABLE `feedentryurls` (
17 `feu_id` int(11) NOT NULL AUTO_INCREMENT,
18 `feu_fe_id` int(11) NOT NULL,
19 `feu_url` varchar(2048) CHARACTER SET utf8 NOT NULL,
20 `feu_active` tinyint(1) NOT NULL COMMENT 'if the url still exists in the entry',
21 `feu_pinged` tinyint(1) NOT NULL,
22 `feu_updated` datetime NOT NULL,
23 `feu_error` tinyint(1) NOT NULL,
24 `feu_error_code` varchar(6) NOT NULL,
25 `feu_error_message` varchar(128) NOT NULL,
26 `feu_tries` tinyint(4) NOT NULL,
27 `feu_retry` tinyint(1) NOT NULL,
28 PRIMARY KEY (`feu_id`),
29 UNIQUE KEY `feu_id` (`feu_id`)
30 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
33 DROP TABLE IF EXISTS `feeds`;
34 CREATE TABLE `feeds` (
35 `f_id` int(11) NOT NULL AUTO_INCREMENT,
36 `f_url` varchar(2048) CHARACTER SET utf8 NOT NULL,
37 `f_updated` datetime NOT NULL,
38 `f_needs_update` tinyint(1) NOT NULL,
40 UNIQUE KEY `f_id` (`f_id`)
41 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
44 DROP TABLE IF EXISTS `pingbacks`;
45 CREATE TABLE `pingbacks` (
46 `p_id` int(11) NOT NULL AUTO_INCREMENT,
47 `p_source` varchar(1024) CHARACTER SET latin1 NOT NULL,
48 `p_target` varchar(1024) CHARACTER SET latin1 NOT NULL,
49 `p_time` datetime NOT NULL,
50 `p_client_ip` varchar(40) CHARACTER SET latin1 NOT NULL,
51 `p_client_agent` varchar(128) CHARACTER SET latin1 NOT NULL,
52 `p_client_referer` varchar(1024) CHARACTER SET latin1 NOT NULL,
54 UNIQUE KEY `p_id` (`p_id`)
55 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;