From 94f6e94ffdb72e0ac78c5d06ec95a9e6f9f6f47f Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Wed, 7 Jan 2004 19:52:10 +0000 Subject: - Many excellent news aggregator improvements by Kjartan: + Added drupal_http_request(). + Replaced rssfeeds with OPML feed subscription list. + Added support for pubDate. + Added support for conditional gets using ETag and Last-Modified. --- database/database.mssql | 6 ++++-- database/database.mysql | 4 +++- database/database.pgsql | 4 +++- 3 files changed, 10 insertions(+), 4 deletions(-) (limited to 'database') diff --git a/database/database.mssql b/database/database.mssql index a3a7d9257..079c6b0f3 100644 --- a/database/database.mssql +++ b/database/database.mssql @@ -104,10 +104,12 @@ CREATE TABLE [dbo].[feed] ( [title] [varchar] (255) NOT NULL , [url] [varchar] (255) NOT NULL , [refresh] [int] NOT NULL , - [timestamp] [int] NULL , + [checked] [int] MOT NULL , [attributes] [varchar] (255) NULL , [link] [varchar] (255) NULL , - [description] [varchar] (8000) NULL + [description] [varchar] (8000) NULL , + [etag] [varchar] (255) NULL , + [modified] [int] NOT NULL ) ON [PRIMARY] GO diff --git a/database/database.mysql b/database/database.mysql index 12cc04519..8a2762fcd 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -156,10 +156,12 @@ CREATE TABLE feed ( title varchar(255) NOT NULL default '', url varchar(255) NOT NULL default '', refresh int(10) NOT NULL default '0', - timestamp int(10) NOT NULL default '0', + checked int(10) NOT NULL default '0', attributes varchar(255) NOT NULL default '', link varchar(255) NOT NULL default '', description longtext NOT NULL, + etag varchar(255) NOT NULL default '', + modified int(10) NOT NULL default '0', PRIMARY KEY (fid), UNIQUE KEY link (url), UNIQUE KEY title (title) diff --git a/database/database.pgsql b/database/database.pgsql index 3c9f83897..7885e1947 100644 --- a/database/database.pgsql +++ b/database/database.pgsql @@ -154,10 +154,12 @@ CREATE TABLE feed ( title varchar(255) NOT NULL default '', url varchar(255) NOT NULL default '', refresh integer NOT NULL default '0', - timestamp integer NOT NULL default '0', + checked integer NOT NULL default '0', attributes varchar(255) NOT NULL default '', link varchar(255) NOT NULL default '', description text NOT NULL default '', + etag varchar(255) NOT NULL default '', + modified integer NOT NULL default '0', PRIMARY KEY (fid), UNIQUE (title), UNIQUE (url) -- cgit v1.2.3