[El Forum]

[eluser]zimco[/eluser]
You might also want to consider looking at other open-source rss parsers and seeing how they did it. For instance here's a mysql db table from Tiny Tiny Rss that shows some of how they did it:

Code:

create table ttrss_user_entries (
int_id integer not null primary key auto_increment,
ref_id integer not null,
feed_id int not null,
owner_uid integer not null,
marked bool not null default 0,
published bool not null default 0,
last_read datetime,
score int not null default 0,
note text,
unread bool not null default 1,
index (ref_id),
foreign key (ref_id) references ttrss_entries(id) ON DELETE CASCADE,
index (feed_id),
foreign key (feed_id) references ttrss_feeds(id) ON DELETE CASCADE,
index (owner_uid),
foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE) TYPE=InnoDB;