From c0fb0a5ec04c064bb848534185b51c5d1b7bdaaf Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <noreply@fakecake.org>
Date: Thu, 4 Mar 2021 08:30:52 +0300
Subject: wip for db_migrations for core schema

---
 schema/versions/pgsql/95.sql | 39 ---------------------------------------
 1 file changed, 39 deletions(-)
 delete mode 100644 schema/versions/pgsql/95.sql

(limited to 'schema/versions/pgsql/95.sql')

diff --git a/schema/versions/pgsql/95.sql b/schema/versions/pgsql/95.sql
deleted file mode 100644
index 014463a85..000000000
--- a/schema/versions/pgsql/95.sql
+++ /dev/null
@@ -1,39 +0,0 @@
-begin;
-
-update ttrss_prefs set short_desc = 'Purge articles after this number of days (0 - disables)'
-where pref_name = 'PURGE_OLD_DAYS';
-
-update ttrss_prefs set section_id = 1 where pref_name = 'ENABLE_API_ACCESS';
-
-update ttrss_prefs set section_id = 2 where pref_name = 'CONFIRM_FEED_CATCHUP';
-update ttrss_prefs set section_id = 2 where pref_name = 'CDM_EXPANDED';
-update ttrss_prefs set section_id = 2 where pref_name = 'CDM_AUTO_CATCHUP';
-update ttrss_prefs set section_id = 2 where pref_name = 'SORT_HEADLINES_BY_FEED_DATE';
-update ttrss_prefs set section_id = 2 where pref_name = 'HIDE_READ_SHOWS_SPECIAL';
-
-insert into ttrss_prefs_sections (id, section_name) values (4, 'Digest');
-
-update ttrss_prefs set section_id = 4 where pref_name = 'DIGEST_ENABLE';
-update ttrss_prefs set section_id = 4 where pref_name = 'DIGEST_PREFERRED_TIME';
-update ttrss_prefs set section_id = 4 where pref_name = 'DIGEST_CATCHUP';
-
-alter table ttrss_prefs_sections add column order_id integer;
-update ttrss_prefs_sections set order_id = 0;
-alter table ttrss_prefs_sections alter column order_id set not null;
-
-update ttrss_prefs_sections set order_id = 0 where id = 1;
-update ttrss_prefs_sections set order_id = 1 where id = 2;
-update ttrss_prefs_sections set order_id = 2 where id = 4;
-update ttrss_prefs_sections set order_id = 3 where id = 3;
-
-update ttrss_prefs set access_level = 1 where pref_name in ('ON_CATCHUP_SHOW_NEXT_FEED',
-	'SORT_HEADLINES_BY_FEED_DATE',
-	'VFEED_GROUP_BY_FEED',
-	'FRESH_ARTICLE_MAX_AGE',
-	'CDM_EXPANDED',
-	'SHOW_CONTENT_PREVIEW',
-	'HIDE_READ_SHOWS_SPECIAL');
-
-update ttrss_version set schema_version = 95;
-
-commit;
-- 
cgit v1.2.3-54-g00ecf

