From 49a0dd3d3fe107663f94d54cf9eb97e8251389be Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Wed, 14 Sep 2005 14:52:21 +0100 Subject: [PATCH] while we are at it, change ttrss_entries.{guid,link} to text too --- schema/ttrss_schema_mysql.sql | 4 ++-- schema/ttrss_schema_pgsql.sql | 4 ++-- 2 files changed, 4 insertions(+), 4 deletions(-) diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql index e88bde87..b34f7070 100644 --- a/schema/ttrss_schema_mysql.sql +++ b/schema/ttrss_schema_mysql.sql @@ -32,8 +32,8 @@ create table ttrss_entries (id integer not null primary key auto_increment, feed_id integer not null references ttrss_feeds(id) ON DELETE CASCADE, updated datetime not null, title text not null, - guid varchar(250) not null unique, - link varchar(250) not null, + guid text not null unique, + link text not null, content text not null, content_hash varchar(250) not null, last_read datetime, diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql index 5ec3c375..77e88a15 100644 --- a/schema/ttrss_schema_pgsql.sql +++ b/schema/ttrss_schema_pgsql.sql @@ -32,8 +32,8 @@ create table ttrss_entries (id serial not null primary key, feed_id int references ttrss_feeds(id) ON DELETE CASCADE not null, updated timestamp not null, title text not null, - guid varchar(300) not null unique, - link varchar(300) not null, + guid text not null unique, + link text not null, content text not null, content_hash varchar(250) not null, last_read timestamp, -- 2.39.5