• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Rss app

#3
[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;


Messages In This Thread
Rss app - by El Forum - 07-03-2009, 09:43 AM
Rss app - by El Forum - 07-03-2009, 09:58 AM
Rss app - by El Forum - 07-03-2009, 11:02 AM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.