summaryrefslogtreecommitdiff
path: root/schema/versions
diff options
context:
space:
mode:
Diffstat (limited to 'schema/versions')
-rw-r--r--schema/versions/mysql/92.sql8
-rw-r--r--schema/versions/pgsql/92.sql8
2 files changed, 16 insertions, 0 deletions
diff --git a/schema/versions/mysql/92.sql b/schema/versions/mysql/92.sql
new file mode 100644
index 000000000..8ebe81fe0
--- /dev/null
+++ b/schema/versions/mysql/92.sql
@@ -0,0 +1,8 @@
+begin;
+
+alter table ttrss_feeds add column favicon_last_checked datetime;
+alter table ttrss_feeds alter column favicon_last_checked set default null;
+
+update ttrss_version set schema_version = 92;
+
+commit;
diff --git a/schema/versions/pgsql/92.sql b/schema/versions/pgsql/92.sql
new file mode 100644
index 000000000..b683d514d
--- /dev/null
+++ b/schema/versions/pgsql/92.sql
@@ -0,0 +1,8 @@
+begin;
+
+alter table ttrss_feeds add column favicon_last_checked timestamp;
+alter table ttrss_feeds alter column favicon_last_checked set default null;
+
+update ttrss_version set schema_version = 92;
+
+commit;