3 CREATE TABLE `feedentries` (
4 `fe_id` int(11) NOT NULL AUTO_INCREMENT,
5 `fe_f_id` int(11) NOT NULL,
6 `fe_url` varchar(2048) CHARACTER SET utf8 NOT NULL,
7 `fe_updated` datetime NOT NULL,
8 `fe_needs_update` tinyint(1) NOT NULL,
10 UNIQUE KEY `fe_id` (`fe_id`)
11 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
14 CREATE TABLE `feedentryurls` (
15 `feu_id` int(11) NOT NULL AUTO_INCREMENT,
16 `feu_fe_id` int(11) NOT NULL,
17 `feu_url` varchar(2048) CHARACTER SET utf8 NOT NULL,
18 `feu_active` tinyint(1) NOT NULL COMMENT 'if the url still exists in the entry',
19 `feu_pinged` tinyint(1) NOT NULL,
20 `feu_updated` datetime NOT NULL,
21 `feu_error` tinyint(1) NOT NULL,
22 `feu_error_code` varchar(6) NOT NULL,
23 `feu_error_message` varchar(128) NOT NULL,
24 `feu_tries` tinyint(4) NOT NULL,
25 `feu_retry` tinyint(1) NOT NULL,
26 PRIMARY KEY (`feu_id`),
27 UNIQUE KEY `feu_id` (`feu_id`)
28 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
31 CREATE TABLE `feeds` (
32 `f_id` int(11) NOT NULL AUTO_INCREMENT,
33 `f_url` varchar(2048) CHARACTER SET utf8 NOT NULL,
34 `f_updated` datetime NOT NULL,
35 `f_needs_update` tinyint(1) NOT NULL,
37 UNIQUE KEY `f_id` (`f_id`)
38 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
41 CREATE TABLE `linkbackcontent` (
42 `lc_id` int(11) NOT NULL AUTO_INCREMENT,
43 `lc_l_id` int(11) NOT NULL,
44 `lc_mime_type` varchar(32) NOT NULL,
45 `lc_fulltext` text NOT NULL,
46 `lc_detected_type` varchar(16) NOT NULL,
47 PRIMARY KEY (`lc_id`),
48 UNIQUE KEY `lc_id` (`lc_id`)
49 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
52 CREATE TABLE `linkbacks` (
53 `l_id` int(11) NOT NULL AUTO_INCREMENT,
54 `l_source` varchar(1024) CHARACTER SET utf8 NOT NULL,
55 `l_target` varchar(1024) CHARACTER SET utf8 NOT NULL,
56 `l_time` datetime NOT NULL,
57 `l_client_ip` varchar(40) CHARACTER SET utf8 NOT NULL,
58 `l_client_agent` varchar(128) CHARACTER SET utf8 NOT NULL,
59 `l_client_referer` varchar(1024) CHARACTER SET utf8 NOT NULL,
60 `l_needs_review` tinyint(1) NOT NULL,
61 `l_use` tinyint(1) NOT NULL,
62 `l_needs_update` tinyint(1) NOT NULL,
64 UNIQUE KEY `l_id` (`l_id`)
65 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
68 CREATE TABLE `linkbacktargets` (
69 `lt_id` int(11) NOT NULL AUTO_INCREMENT,
70 `lt_url` varchar(2048) NOT NULL,
71 PRIMARY KEY (`lt_id`),
72 UNIQUE KEY `lt_id` (`lt_id`)
73 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='List of pages that may receive linkbacks';
76 CREATE TABLE `rbookmarks` (
77 `rb_id` int(11) NOT NULL AUTO_INCREMENT,
78 `rb_l_id` int(11) NOT NULL,
79 `rb_lc_id` int(11) NOT NULL,
80 `rb_target` varchar(2048) NOT NULL,
81 `rb_source` varchar(2048) NOT NULL,
82 `rb_source_title` varchar(256) NOT NULL,
83 `rb_count` int(11) NOT NULL,
84 PRIMARY KEY (`rb_id`),
85 UNIQUE KEY `rb_id` (`rb_id`)
86 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Bookmarks, extracted from linkbackcontent';
89 CREATE TABLE `rcomments` (
90 `rc_id` int(11) NOT NULL AUTO_INCREMENT,
91 `rc_l_id` int(11) NOT NULL,
92 `rc_lc_id` int(11) NOT NULL,
93 `rc_target` varchar(2048) NOT NULL,
94 `rc_source` varchar(2048) NOT NULL,
95 `rc_title` varchar(256) NOT NULL,
96 `rc_updated` datetime NOT NULL,
97 `rc_author_name` varchar(32) NOT NULL,
98 `rc_author_url` varchar(2048) NOT NULL,
99 `rc_author_image` varchar(2048) NOT NULL,
100 `rc_content` text NOT NULL,
101 PRIMARY KEY (`rc_id`),
102 UNIQUE KEY `rb_id` (`rc_id`)
103 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Bookmarks, extracted from linkbackcontent';
106 CREATE TABLE `rlinks` (
107 `rl_id` int(11) NOT NULL AUTO_INCREMENT,
108 `rl_l_id` int(11) NOT NULL,
109 `rl_lc_id` int(11) NOT NULL,
110 `rl_target` varchar(2048) NOT NULL,
111 `rl_source` varchar(2048) NOT NULL,
112 `rl_title` varchar(256) NOT NULL,
113 `rl_updated` datetime NOT NULL,
114 `rl_author_name` varchar(32) NOT NULL,
115 `rl_author_url` varchar(2048) NOT NULL,
116 `rl_author_image` varchar(2048) NOT NULL,
117 PRIMARY KEY (`rl_id`),
118 UNIQUE KEY `rb_id` (`rl_id`)
119 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Bookmarks, extracted from linkbackcontent';