summaryrefslogtreecommitdiff
path: root/sql/pgsql/migrations
diff options
context:
space:
mode:
authorAndrew Dolgov <fox@fakecake.org>2025-04-08 10:54:24 +0000
committerAndrew Dolgov <fox@fakecake.org>2025-04-08 10:54:24 +0000
commit008c518d5d8e60c0168cd107dbfd1f23f9c4a701 (patch)
tree8f3d8afbbf73ae7d59791a3347a557c194f691d0 /sql/pgsql/migrations
parentbb2c4b380165731c3f8abf0596fffb2a0953265b (diff)
parent17b4e98249462a1feb71586d10cd5293d9487ab8 (diff)
Merge branch 'session-encryption' into 'master'
add optional encryption for stored session data using Sodium library See merge request tt-rss/tt-rss!117
Diffstat (limited to 'sql/pgsql/migrations')
-rw-r--r--sql/pgsql/migrations/148.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/pgsql/migrations/148.sql b/sql/pgsql/migrations/148.sql
new file mode 100644
index 000000000..68678e4f5
--- /dev/null
+++ b/sql/pgsql/migrations/148.sql
@@ -0,0 +1,5 @@
+alter table ttrss_feeds rename column auth_pass to auth_pass_old;
+alter table ttrss_feeds add column auth_pass text;
+update ttrss_feeds set auth_pass = auth_pass_old;
+alter table ttrss_feeds alter column auth_pass set not null;
+alter table ttrss_feeds drop column auth_pass_old;