diff options
Diffstat (limited to 'schema')
-rw-r--r-- | schema/ttrss_schema_mysql.sql | 4 | ||||
-rw-r--r-- | 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 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, |