From 38e01270d876cc7e43923629f038bbae629f307b Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <noreply@fakecake.org>
Date: Wed, 6 Mar 2019 19:06:05 +0300
Subject: archived feeds: expire old entries (schema bump)

---
 schema/versions/pgsql/136.sql | 9 +++++++++
 1 file changed, 9 insertions(+)
 create mode 100644 schema/versions/pgsql/136.sql

(limited to 'schema/versions/pgsql')

diff --git a/schema/versions/pgsql/136.sql b/schema/versions/pgsql/136.sql
new file mode 100644
index 000000000..d74136537
--- /dev/null
+++ b/schema/versions/pgsql/136.sql
@@ -0,0 +1,9 @@
+begin;
+
+alter table ttrss_archived_feeds add column created timestamp;
+update ttrss_archived_feeds set created = NOW();
+alter table ttrss_archived_feeds alter column created set not null;
+
+update ttrss_version set schema_version = 136;
+
+commit;
-- 
cgit v1.2.3-54-g00ecf