summaryrefslogtreecommitdiff
path: root/schema/ttrss_schema_pgsql.sql
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2005-12-10 08:14:29 +0100
committerAndrew Dolgov <[email protected]>2005-12-10 08:14:29 +0100
commiteb40e11b14b025f3603581977e2f6bbb032967e4 (patch)
tree87cb6fac00cb28f1b0f70049f57d379cea5cd79b /schema/ttrss_schema_pgsql.sql
parent75836f33860f26ca55ec8e8661cff4b0edc2fe5e (diff)
add column for slash:comments and alike in ttrss_entries (+ add upgrade scripts for 1.1.1)
Diffstat (limited to 'schema/ttrss_schema_pgsql.sql')
-rw-r--r--schema/ttrss_schema_pgsql.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql
index dc4fd5eb8..d58492919 100644
--- a/schema/ttrss_schema_pgsql.sql
+++ b/schema/ttrss_schema_pgsql.sql
@@ -65,6 +65,7 @@ create table ttrss_entries (id serial not null primary key,
content_hash varchar(250) not null,
no_orig_date boolean not null default false,
date_entered timestamp not null default NOW(),
+ num_comments integer not null default 0,
comments varchar(250) not null default '');
create index ttrss_entries_guid_index on ttrss_entries(guid);