summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2005-09-14 14:52:21 +0100
committerAndrew Dolgov <[email protected]>2005-09-14 14:52:21 +0100
commit49a0dd3d3fe107663f94d54cf9eb97e8251389be (patch)
treecd3622aa2c7a7a5c223fbd3e483562d2962bb713
parent9ad5b0de31b1b3400f12a66266a48dd321c315b6 (diff)
while we are at it, change ttrss_entries.{guid,link} to text too
-rw-r--r--schema/ttrss_schema_mysql.sql4
-rw-r--r--schema/ttrss_schema_pgsql.sql4
2 files changed, 4 insertions, 4 deletions
diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql
index e88bde876..b34f7070b 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 5ec3c375e..77e88a158 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,