summaryrefslogtreecommitdiff
path: root/schema/versions
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2018-12-06 19:37:20 +0300
committerAndrew Dolgov <[email protected]>2018-12-06 19:37:20 +0300
commit3e4326e34dcb4a9eb922c6d212fd05a58a11b124 (patch)
treee6f8f52053e19cf9cc3f5fa46082276b6ee609c4 /schema/versions
parenta01c33d65409d8313221b981152ec627b8f8f3f1 (diff)
add ttrss_filters2.last_triggered (bump schema version)
Diffstat (limited to 'schema/versions')
-rw-r--r--schema/versions/mysql/135.sql8
-rw-r--r--schema/versions/pgsql/135.sql8
2 files changed, 16 insertions, 0 deletions
diff --git a/schema/versions/mysql/135.sql b/schema/versions/mysql/135.sql
new file mode 100644
index 000000000..6d9d41ba6
--- /dev/null
+++ b/schema/versions/mysql/135.sql
@@ -0,0 +1,8 @@
+begin;
+
+alter table ttrss_filters2 add column last_triggered datetime;
+alter table ttrss_filters2 alter column last_triggered set default null;
+
+update ttrss_version set schema_version = 135;
+
+commit;
diff --git a/schema/versions/pgsql/135.sql b/schema/versions/pgsql/135.sql
new file mode 100644
index 000000000..b1ec70505
--- /dev/null
+++ b/schema/versions/pgsql/135.sql
@@ -0,0 +1,8 @@
+begin;
+
+alter table ttrss_filters2 add column last_triggered timestamp;
+alter table ttrss_filters2 alter column last_triggered set default null;
+
+update ttrss_version set schema_version = 135;
+
+commit;