From eedc1460e5dadb00a731c1974642a4db7ab30868 Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@fakecake.org>
Date: Tue, 8 Apr 2025 09:36:04 +0300
Subject: support transparent encryption for feed passwords, bump schema to
 drop length limit of ttrss_feeds.auth_pass

---
 sql/mysql/migrations/148.sql | 3 +++
 1 file changed, 3 insertions(+)
 create mode 100644 sql/mysql/migrations/148.sql

(limited to 'sql/mysql/migrations/148.sql')

diff --git a/sql/mysql/migrations/148.sql b/sql/mysql/migrations/148.sql
new file mode 100644
index 000000000..64eca0972
--- /dev/null
+++ b/sql/mysql/migrations/148.sql
@@ -0,0 +1,3 @@
+alter table ttrss_feeds change auth_pass auth_pass text not null;
+
+update ttrss_version set schema_version = 148;
-- 
cgit v1.2.3-54-g00ecf


From 597971f2382c273106b6205b35f7810a4ed78476 Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@fakecake.org>
Date: Tue, 8 Apr 2025 09:48:44 +0300
Subject: we no longer directly modify schema_version in migrations

---
 sql/mysql/migrations/148.sql | 1 -
 sql/pgsql/migrations/148.sql | 2 --
 2 files changed, 3 deletions(-)

(limited to 'sql/mysql/migrations/148.sql')

diff --git a/sql/mysql/migrations/148.sql b/sql/mysql/migrations/148.sql
index 64eca0972..b981cadeb 100644
--- a/sql/mysql/migrations/148.sql
+++ b/sql/mysql/migrations/148.sql
@@ -1,3 +1,2 @@
 alter table ttrss_feeds change auth_pass auth_pass text not null;
 
-update ttrss_version set schema_version = 148;
diff --git a/sql/pgsql/migrations/148.sql b/sql/pgsql/migrations/148.sql
index 98a04de3e..68678e4f5 100644
--- a/sql/pgsql/migrations/148.sql
+++ b/sql/pgsql/migrations/148.sql
@@ -3,5 +3,3 @@ 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;
-
-update ttrss_version set schema_version = 148;
-- 
cgit v1.2.3-54-g00ecf

