set pages 80
set lines 132
set long 10000
set define off
set echo on

--conn rss/rss

-- Insert sample feeds that are using different RSS formats

-- CNN.com
insert into rssfeeds values (1001, 'rss 2.0', 'CNN.com', 'Top Stories', 'http://rss.cnn.com/rss/cnn_topstories.rss');
insert into rssfeeds values (1002, 'rss 2.0', 'CNN.com', 'World', 'http://rss.cnn.com/rss/cnn_world.rss');
insert into rssfeeds values (1003, 'rss 2.0', 'CNN.com', 'US', 'http://rss.cnn.com/rss/cnn_us.rss');
insert into rssfeeds values (1004, 'rss 2.0', 'CNN.com', 'Politics', 'http://rss.cnn.com/rss/cnn_allpolitics.rss');
insert into rssfeeds values (1005, 'rss 2.0', 'CNN.com', 'Law', 'http://rss.cnn.com/rss/cnn_law.rss');
insert into rssfeeds values (1006, 'rss 2.0', 'CNN.com', 'Technology', 'http://rss.cnn.com/rss/cnn_tech.rss');
insert into rssfeeds values (1007, 'rss 2.0', 'CNN.com', 'Science & Space', 'http://rss.cnn.com/rss/cnn_space.rss');
insert into rssfeeds values (1008, 'rss 2.0', 'CNN.com', 'Health', 'http://rss.cnn.com/rss/cnn_health.rss');
insert into rssfeeds values (1009, 'rss 2.0', 'CNN.com', 'Entertainment', 'http://rss.cnn.com/rss/cnn_showbiz.rss');
insert into rssfeeds values (1010, 'rss 2.0', 'CNN.com', 'Travel', 'http://rss.cnn.com/rss/cnn_travel.rss');
insert into rssfeeds values (1006, 'rss 2.0', 'CNN.com', 'Education', 'http://rss.cnn.com/rss/cnn_education.rss');
insert into rssfeeds values (1008, 'rss 2.0', 'CNN.com', 'Offbeat', 'http://rss.cnn.com/rss/cnn_offbeat.rss');
insert into rssfeeds values (1009, 'rss 2.0', 'CNN.com', 'Most Popular', 'http://rss.cnn.com/rss/cnn_mostpopular.rss');
insert into rssfeeds values (1010, 'rss 2.0', 'CNN.com', 'Most Recent', 'http://rss.cnn.com/rss/cnn_latest.rss');
-- BBC News
insert into rssfeeds values (2001, 'rss 2.0', 'BBC News', 'News Front Page', 'http://newsrss.bbc.co.uk/rss/newsonline_world_edition/front_page/rss.xml');
insert into rssfeeds values (2002, 'rss 2.0', 'BBC News', 'Africa', 'http://newsrss.bbc.co.uk/rss/newsonline_world_edition/africa/rss.xml');
insert into rssfeeds values (2003, 'rss 2.0', 'BBC News', 'Americas', 'http://newsrss.bbc.co.uk/rss/newsonline_world_edition/americas/rss.xml');
insert into rssfeeds values (2004, 'rss 2.0', 'BBC News', 'Asia-Pacific', 'http://newsrss.bbc.co.uk/rss/newsonline_world_edition/asia-pacific/rss.xml');
insert into rssfeeds values (2005, 'rss 2.0', 'BBC News', 'Europe', 'http://newsrss.bbc.co.uk/rss/newsonline_world_edition/europe/rss.xml');
insert into rssfeeds values (2006, 'rss 2.0', 'BBC News', 'Middle East', 'http://newsrss.bbc.co.uk/rss/newsonline_world_edition/middle_east/rss.xml');
insert into rssfeeds values (2007, 'rss 2.0', 'BBC News', 'South Asia', 'http://newsrss.bbc.co.uk/rss/newsonline_world_edition/south_asia/rss.xml');
insert into rssfeeds values (2008, 'rss 2.0', 'BBC News', 'UK', 'http://newsrss.bbc.co.uk/rss/newsonline_world_edition/uk_news/rss.xml');
insert into rssfeeds values (2009, 'rss 2.0', 'BBC News', 'Business', 'http://newsrss.bbc.co.uk/rss/newsonline_world_edition/business/rss.xml');
insert into rssfeeds values (2010, 'rss 2.0', 'BBC News', 'Health', 'http://newsrss.bbc.co.uk/rss/newsonline_world_edition/health/rss.xml');
insert into rssfeeds values (2006, 'rss 2.0', 'BBC News', 'Science/Nature', 'http://newsrss.bbc.co.uk/rss/newsonline_world_edition/science/nature/rss.xml');
insert into rssfeeds values (2007, 'rss 2.0', 'BBC News', 'Technology', 'http://newsrss.bbc.co.uk/rss/newsonline_world_edition/technology/rss.xml');
insert into rssfeeds values (2008, 'rss 2.0', 'BBC News', 'Entertainment', 'http://newsrss.bbc.co.uk/rss/newsonline_world_edition/entertainment/rss.xml');
insert into rssfeeds values (2009, 'rss 2.0', 'BBC News', 'Latest Published Stories', 'http://newsrss.bbc.co.uk/rss/newsonline_world_edition/latest_published_stories/rss.xml');
-- Google News Atom 0.3 feeds
insert into rssfeeds values (3001, 'Atom 0.3', 'Google News', 'News Front Page', 'http://news.google.com/?output=atom');
insert into rssfeeds values (3002, 'Atom 0.3', 'Google News', 'World', 'http://news.google.com/?ned=us&topic=w&output=atom');
insert into rssfeeds values (3003, 'Atom 0.3', 'Google News', 'U.S.', 'http://news.google.com/?ned=us&topic=n&output=atom');
insert into rssfeeds values (3004, 'Atom 0.3', 'Google News', 'Business', 'http://news.google.com/?ned=us&topic=b&output=atom');
insert into rssfeeds values (3005, 'Atom 0.3', 'Google News', 'Science and Technology', 'http://news.google.com/?ned=us&topic=t&output=atom');
insert into rssfeeds values (3006, 'Atom 0.3', 'Google News', 'Sports', 'http://news.google.com/?ned=us&topic=s&output=atom');
insert into rssfeeds values (3007, 'Atom 0.3', 'Google News', 'Entertainment', 'http://news.google.com/?ned=us&topic=e&output=atom');
insert into rssfeeds values (3008, 'Atom 0.3', 'Google News', 'Health', 'http://news.google.com/?ned=us&topic=m&output=atom');
-- Google News RSS 2.0 Taiwan feeds
--insert into rssfeeds values (4001, 'rss 2.0', 'Google News', 'Taiwan', 'http://news.google.com/news?ned=tw&output=rss');
-- W3C RSS 1.0 feed
insert into rssfeeds values (5001, 'rss 1.0', 'W3C News', 'Press', 'http://www.w3.org/2000/08/w3c-synd/home.rss');

