summaryrefslogtreecommitdiff
path: root/sql/mysql/migrations/4.sql
diff options
context:
space:
mode:
authorAndrew Dolgov <fox@fakecake.org>2025-04-28 04:48:01 +0000
committerAndrew Dolgov <fox@fakecake.org>2025-04-28 04:48:01 +0000
commit4cb8a84df46d46bc325b6638defbdc4dc34151ed (patch)
tree77acdf9b8271568a53e636fc4e84d4bda1404f82 /sql/mysql/migrations/4.sql
parent0e4b8bd6538f3062d34a3a06ab5531c70042de78 (diff)
parentf80187e05f12c2fe9c487bff13058b207833b227 (diff)
Merge branch 'rip-mysql' into 'master'
initial attempt to remove mysql-related stuff from tt-rss See merge request tt-rss/tt-rss!120
Diffstat (limited to 'sql/mysql/migrations/4.sql')
-rw-r--r--sql/mysql/migrations/4.sql17
1 files changed, 0 insertions, 17 deletions
diff --git a/sql/mysql/migrations/4.sql b/sql/mysql/migrations/4.sql
deleted file mode 100644
index 6dfc5f82f..000000000
--- a/sql/mysql/migrations/4.sql
+++ /dev/null
@@ -1,17 +0,0 @@
-begin;
-
-alter table ttrss_feeds add column parent_feed integer;
-alter table ttrss_feeds add foreign key (parent_feed) references ttrss_feeds(id) on delete set null;
-
-alter table ttrss_feeds add column private bool;
-
-update ttrss_feeds set private = false;
-
-alter table ttrss_feeds change private private bool not null;
-alter table ttrss_feeds alter column private set default 0;
-
-insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('HIDE_READ_FEEDS', 1, 'false', 'Hide feeds with no unread messages',2);
-
-update ttrss_version set schema_version = 4;
-
-commit;