diff options
Diffstat (limited to 'sql')
-rw-r--r-- | sql/mysql/migrations/146.sql | 7 | ||||
-rw-r--r-- | sql/mysql/schema.sql | 3 | ||||
-rw-r--r-- | sql/pgsql/migrations/146.sql | 7 | ||||
-rw-r--r-- | sql/pgsql/schema.sql | 3 |
4 files changed, 20 insertions, 0 deletions
diff --git a/sql/mysql/migrations/146.sql b/sql/mysql/migrations/146.sql new file mode 100644 index 000000000..0b8572b3c --- /dev/null +++ b/sql/mysql/migrations/146.sql @@ -0,0 +1,7 @@ +alter table ttrss_user_entries add column flavor_image text; +alter table ttrss_user_entries add column flavor_stream text; +alter table ttrss_user_entries add column flavor_kind int; + +alter table ttrss_user_entries alter column flavor_image set default null; +alter table ttrss_user_entries alter column flavor_stream set default null; +alter table ttrss_user_entries alter column flavor_kind set default null; diff --git a/sql/mysql/schema.sql b/sql/mysql/schema.sql index d8e6e270a..e6ab2a2a6 100644 --- a/sql/mysql/schema.sql +++ b/sql/mysql/schema.sql @@ -188,6 +188,9 @@ create table ttrss_user_entries ( note longtext, last_marked datetime, last_published datetime, + flavor_image text default null, + flavor_stream text default null, + flavor_kind int default null, unread bool not null default 1, foreign key (ref_id) references ttrss_entries(id) ON DELETE CASCADE, foreign key (feed_id) references ttrss_feeds(id) ON DELETE CASCADE, diff --git a/sql/pgsql/migrations/146.sql b/sql/pgsql/migrations/146.sql new file mode 100644 index 000000000..0b8572b3c --- /dev/null +++ b/sql/pgsql/migrations/146.sql @@ -0,0 +1,7 @@ +alter table ttrss_user_entries add column flavor_image text; +alter table ttrss_user_entries add column flavor_stream text; +alter table ttrss_user_entries add column flavor_kind int; + +alter table ttrss_user_entries alter column flavor_image set default null; +alter table ttrss_user_entries alter column flavor_stream set default null; +alter table ttrss_user_entries alter column flavor_kind set default null; diff --git a/sql/pgsql/schema.sql b/sql/pgsql/schema.sql index 50bf375f2..021ae05ed 100644 --- a/sql/pgsql/schema.sql +++ b/sql/pgsql/schema.sql @@ -185,6 +185,9 @@ create table ttrss_user_entries ( last_marked timestamp, last_published timestamp, note text, + flavor_image text default null, + flavor_stream text default null, + flavor_kind int default null, unread boolean not null default true); -- create index ttrss_user_entries_feed_id_index on ttrss_user_entries(feed_id); |