summaryrefslogtreecommitdiffstats
path: root/database
diff options
context:
space:
mode:
authorDries Buytaert2004-01-07 19:52:10 (GMT)
committerDries Buytaert2004-01-07 19:52:10 (GMT)
commit94f6e94ffdb72e0ac78c5d06ec95a9e6f9f6f47f (patch)
tree9456e655f26c86076bd97f4cdaae4c2cc76684fe /database
parent9352d6abf8cc4cbf78e6a92e6cfb18b1d9fc750f (diff)
- 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.
Diffstat (limited to 'database')
-rw-r--r--database/database.mssql6
-rw-r--r--database/database.mysql4
-rw-r--r--database/database.pgsql4
3 files changed, 10 insertions, 4 deletions
diff --git a/database/database.mssql b/database/database.mssql
index a3a7d92..079c6b0 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 12cc045..8a2762f 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 3c9f838..7885e19 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)