summaryrefslogtreecommitdiff
path: root/schema/ttrss_schema_pgsql.sql
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2006-02-26 07:39:09 +0100
committerAndrew Dolgov <[email protected]>2006-02-26 07:39:09 +0100
commit4bc760da51ebb36a13edf8b34d3efee0276abaf6 (patch)
treeee200659e16417b331a29a5d95e7bcc380b3d83c /schema/ttrss_schema_pgsql.sql
parent63147705ab24244d3cee607cdf4f2024d2acab2a (diff)
add author column to ttrss_entries, add upgrade script for 1.1.4, bump schema version
Diffstat (limited to 'schema/ttrss_schema_pgsql.sql')
-rw-r--r--schema/ttrss_schema_pgsql.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql
index b93984504..97434ce2a 100644
--- a/schema/ttrss_schema_pgsql.sql
+++ b/schema/ttrss_schema_pgsql.sql
@@ -75,7 +75,8 @@ create table ttrss_entries (id serial not null primary key,
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 '');
+ comments varchar(250) not null default '',
+ author varchar(250) not null default '');
create index ttrss_entries_guid_index on ttrss_entries(guid);
create index ttrss_entries_title_index on ttrss_entries(title);