summaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2005-11-18 09:58:17 +0100
committerAndrew Dolgov <[email protected]>2005-11-18 09:58:17 +0100
commitcd42edf18dac1955a4046cc68a790aaf77cd6536 (patch)
treea9886f60a97666e7b0f5407adceb7e4d76f6a089 /schema
parent203b6d25e538093694c83dd6d9d6de6f2366d157 (diff)
removed some default feeds from schema
Diffstat (limited to 'schema')
-rw-r--r--schema/ttrss_schema_mysql.sql14
-rw-r--r--schema/ttrss_schema_pgsql.sql25
2 files changed, 8 insertions, 31 deletions
diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql
index 31d1ff01d..e8cf6e5eb 100644
--- a/schema/ttrss_schema_mysql.sql
+++ b/schema/ttrss_schema_mysql.sql
@@ -30,26 +30,14 @@ create table ttrss_feeds (id integer not null auto_increment primary key,
foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE) TYPE=InnoDB;
insert into ttrss_feeds (owner_uid,title,feed_url) values (1,'Footnotes', 'http://gnomedesktop.org/node/feed');
-insert into ttrss_feeds (owner_uid,title,feed_url) values (1,'Freedesktop.org', 'http://planet.freedesktop.org/rss20.xml');
-insert into ttrss_feeds (owner_uid,title,feed_url) values (1,'Planet Debian', 'http://planet.debian.org/rss20.xml');
-insert into ttrss_feeds (owner_uid,title,feed_url) values (1,'Planet GNOME', 'http://planet.gnome.org/rss20.xml');
-insert into ttrss_feeds (owner_uid,title,feed_url) values (1,'Planet Ubuntu', 'http://planet.ubuntulinux.org/rss20.xml');
-
-insert into ttrss_feeds (owner_uid,title,feed_url) values (1,'Monologue', 'http://www.go-mono.com/monologue/index.rss');
-
-insert into ttrss_feeds (owner_uid,title,feed_url) values (1,'Latest Linux Kernel Versions',
- 'http://kernel.org/kdist/rss.xml');
-
+insert into ttrss_feeds (owner_uid,title,feed_url) values (1,'Latest Linux Kernel Versions','http://kernel.org/kdist/rss.xml');
insert into ttrss_feeds (owner_uid,title,feed_url) values (1,'RPGDot Newsfeed',
'http://www.rpgdot.com/team/rss/rss0.xml');
-
insert into ttrss_feeds (owner_uid,title,feed_url) values (1,'Digg.com News',
'http://digg.com/rss/index.xml');
-
insert into ttrss_feeds (owner_uid,title,feed_url) values (1,'Technocrat.net',
'http://syndication.technocrat.net/rss');
-
create table ttrss_entries (id integer not null primary key auto_increment,
owner_uid integer not null,
feed_id integer not null,
diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql
index ab839ebf3..b6832040c 100644
--- a/schema/ttrss_schema_pgsql.sql
+++ b/schema/ttrss_schema_pgsql.sql
@@ -28,24 +28,13 @@ create table ttrss_feeds (id serial not null primary key,
site_url varchar(250) not null default '');
insert into ttrss_feeds (owner_uid,title,feed_url) values (1,'Footnotes', 'http://gnomedesktop.org/node/feed');
-insert into ttrss_feeds (owner_uid,title,feed_url) values (1,'Freedesktop.org', 'http://planet.freedesktop.org/rss20.xml');
-insert into ttrss_feeds (owner_uid,title,feed_url) values (1,'Planet Debian', 'http://planet.debian.org/rss20.xml');
-insert into ttrss_feeds (owner_uid,title,feed_url) values (1,'Planet GNOME', 'http://planet.gnome.org/rss20.xml');
-insert into ttrss_feeds (owner_uid,title,feed_url) values (1,'Planet Ubuntu', 'http://planet.ubuntulinux.org/rss20.xml');
-
-insert into ttrss_feeds (owner_uid,title,feed_url) values (1,'Monologue', 'http://www.go-mono.com/monologue/index.rss');
-
-insert into ttrss_feeds (owner_uid,title,feed_url) values (1,'Latest Linux Kernel Versions',
- 'http://kernel.org/kdist/rss.xml');
-
-insert into ttrss_feeds (owner_uid,title,feed_url) values (1,'RPGDot Newsfeed',
- 'http://www.rpgdot.com/team/rss/rss0.xml');
-
-insert into ttrss_feeds (owner_uid,title,feed_url) values (1,'Digg.com News',
- 'http://digg.com/rss/index.xml');
-
-insert into ttrss_feeds (owner_uid,title,feed_url) values (1,'Technocrat.net',
- 'http://syndication.technocrat.net/rss');
+insert into ttrss_feeds (owner_uid,title,feed_url) values (1,'Latest Linux Kernel Versions','http://kernel.org/kdist/rss.xml');
+insert into ttrss_feeds (owner_uid,title,feed_url) values (1,'RPGDot Newsfeed',
+ 'http://www.rpgdot.com/team/rss/rss0.xml');
+insert into ttrss_feeds (owner_uid,title,feed_url) values (1,'Digg.com News',
+ 'http://digg.com/rss/index.xml');
+insert into ttrss_feeds (owner_uid,title,feed_url) values (1,'Technocrat.net',
+ 'http://syndication.technocrat.net/rss');
create table ttrss_entries (id serial not null primary key,
owner_uid integer not null references ttrss_users(id) on delete cascade,