summaryrefslogtreecommitdiff
path: root/schema/ttrss_schema_pgsql.sql
diff options
context:
space:
mode:
authorYoungMin Park <[email protected]>2014-11-04 11:49:43 +0900
committerYoungMin Park <[email protected]>2014-11-04 11:49:43 +0900
commita5bbb2bec133bdee08b361628f32430ae3884107 (patch)
treeb203105149ec234ebe155d5718d2cbb6390b4a45 /schema/ttrss_schema_pgsql.sql
parent12727ad17d125eb2f3f243231ccca1cb0a5a7b4b (diff)
parent2f43089de1ead3f164b8b31967d1abbb784319fa (diff)
Merge pull request #1 from gothfox/master
Update from original
Diffstat (limited to 'schema/ttrss_schema_pgsql.sql')
-rw-r--r--schema/ttrss_schema_pgsql.sql6
1 files changed, 5 insertions, 1 deletions
diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql
index 9d0337a07..c09f044fb 100644
--- a/schema/ttrss_schema_pgsql.sql
+++ b/schema/ttrss_schema_pgsql.sql
@@ -49,6 +49,7 @@ create table ttrss_users (id serial not null primary key,
salt varchar(250) not null default '',
twitter_oauth text default null,
otp_enabled boolean not null default false,
+ resetpass_token varchar(250) default null,
created timestamp default null);
insert into ttrss_users (login,pwd_hash,access_level) values ('admin',
@@ -144,6 +145,7 @@ create table ttrss_entries (id serial not null primary key,
num_comments integer not null default 0,
comments varchar(250) not null default '',
plugin_data text,
+ lang varchar(2),
author varchar(250) not null default '');
create index ttrss_entries_guid_index on ttrss_entries(guid);
@@ -259,13 +261,15 @@ create index ttrss_tags_post_int_id_idx on ttrss_tags(post_int_id);
create table ttrss_version (schema_version int not null);
-insert into ttrss_version values (121);
+insert into ttrss_version values (126);
create table ttrss_enclosures (id serial not null primary key,
content_url text not null,
content_type varchar(250) not null,
title text not null,
duration text not null,
+ width integer not null default 0,
+ height integer not null default 0,
post_id integer references ttrss_entries(id) ON DELETE cascade NOT NULL);
create index ttrss_enclosures_post_id_idx on ttrss_enclosures(post_id);