summaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2007-02-24 17:45:27 +0100
committerAndrew Dolgov <[email protected]>2007-02-24 17:45:27 +0100
commit12124198493e6c71f02033aebf85838e4f862598 (patch)
tree0c9fc0905d73c102d82243562ea572c61d3be9bd /schema
parente30a61d4a809d818432d6b19981fad4be39e5b65 (diff)
remove old-style schema upgrade files
Diffstat (limited to 'schema')
-rw-r--r--schema/obsolete/upgrade-1.0.6-1.0.7-pgsql.sql24
-rw-r--r--schema/obsolete/upgrade-1.1-1.1.1-mysql.sql43
-rw-r--r--schema/obsolete/upgrade-1.1-1.1.1-pgsql.sql43
-rw-r--r--schema/obsolete/upgrade-1.1.1-1.1.2-mysql.sql17
-rw-r--r--schema/obsolete/upgrade-1.1.1-1.1.2-pgsql.sql17
-rw-r--r--schema/obsolete/upgrade-1.1.2-1.1.3-mysql.sql12
-rw-r--r--schema/obsolete/upgrade-1.1.2-1.1.3-pgsql.sql10
-rw-r--r--schema/obsolete/upgrade-1.1.3-1.1.4-mysql.sql20
-rw-r--r--schema/obsolete/upgrade-1.1.3-1.1.4-pgsql.sql24
-rw-r--r--schema/obsolete/upgrade-1.1.4-1.1.5-mysql.sql19
-rw-r--r--schema/obsolete/upgrade-1.1.4-1.1.5-pgsql.sql22
-rw-r--r--schema/obsolete/upgrade-1.1.5-1.1.7-mysql.sql14
-rw-r--r--schema/obsolete/upgrade-1.1.5-1.1.7-pgsql.sql17
-rw-r--r--schema/obsolete/upgrade-1.1.7-1.2.2-mysql.sql29
-rw-r--r--schema/obsolete/upgrade-1.1.7-1.2.2-pgsql.sql33
-rw-r--r--schema/obsolete/upgrade-1.2.2-1.2.3-mysql.sql12
-rw-r--r--schema/obsolete/upgrade-1.2.2-1.2.3-pgsql.sql12
-rw-r--r--schema/obsolete/upgrade-1.2.3-1.2.4-mysql.sql18
-rw-r--r--schema/obsolete/upgrade-1.2.3-1.2.4-pgsql.sql18
-rw-r--r--schema/obsolete/upgrade-1.2.4-1.2.6-mysql.sql12
-rw-r--r--schema/obsolete/upgrade-1.2.4-1.2.6-pgsql.sql15
-rw-r--r--schema/upgrade-1.2.6-1.2.8-mysql.sql6
-rw-r--r--schema/upgrade-1.2.6-1.2.8-pgsql.sql10
23 files changed, 0 insertions, 447 deletions
diff --git a/schema/obsolete/upgrade-1.0.6-1.0.7-pgsql.sql b/schema/obsolete/upgrade-1.0.6-1.0.7-pgsql.sql
deleted file mode 100644
index 7f0cfaacf..000000000
--- a/schema/obsolete/upgrade-1.0.6-1.0.7-pgsql.sql
+++ /dev/null
@@ -1,24 +0,0 @@
-begin;
-
-alter table ttrss_feeds add column last_error text;
-alter table ttrss_feeds add column site_url varchar(250);
-alter table ttrss_feeds add column update_interval integer;
-
-update ttrss_feeds set last_error = '';
-update ttrss_feeds set site_url = '';
-update ttrss_feeds set update_interval = 0;
-
-alter table ttrss_feeds alter column last_error set not null;
-alter table ttrss_feeds alter column last_error set default '';
-
-alter table ttrss_feeds alter column site_url set not null;
-alter table ttrss_feeds alter column site_url set default '';
-
-alter table ttrss_feeds alter column update_interval set not null;
-alter table ttrss_feeds alter column update_interval set default 0;
-
-create table ttrss_version (schema_version int not null);
-
-insert into ttrss_version values (1);
-
-commit;
diff --git a/schema/obsolete/upgrade-1.1-1.1.1-mysql.sql b/schema/obsolete/upgrade-1.1-1.1.1-mysql.sql
deleted file mode 100644
index 79860a29c..000000000
--- a/schema/obsolete/upgrade-1.1-1.1.1-mysql.sql
+++ /dev/null
@@ -1,43 +0,0 @@
-begin;
-
-alter table ttrss_entries add column num_comments integer;
-
-update ttrss_entries set num_comments = 0;
-
-alter table ttrss_entries change num_comments num_comments integer not null;
-alter table ttrss_entries alter column num_comments set default 0;
-
-insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('COMBINED_DISPLAY_MODE', 1, 'false', 'Combined feed display',2,
- 'Display expanded list of feed articles, instead of separate displays for headlines and article content');
-
-alter table ttrss_feed_categories add column collapsed bool;
-
-update ttrss_feed_categories set collapsed = false;
-
-alter table ttrss_feed_categories change collapsed collapsed bool not null;
-alter table ttrss_feed_categories alter column collapsed set default 0;
-
-alter table ttrss_feeds add column auth_login varchar(250);
-alter table ttrss_feeds add column auth_pass varchar(250);
-
-update ttrss_feeds set auth_login = '';
-update ttrss_feeds set auth_pass = '';
-
-alter table ttrss_feeds change auth_login auth_login varchar(250) not null;
-alter table ttrss_feeds alter column auth_login set default '';
-
-alter table ttrss_feeds change auth_pass auth_pass varchar(250) not null;
-alter table ttrss_feeds alter column auth_pass set default '';
-
-alter table ttrss_users add column email varchar(250);
-
-update ttrss_users set email = '';
-
-alter table ttrss_users change email email varchar(250) not null;
-alter table ttrss_users alter column email set default '';
-
-insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('ENABLE_SEARCH_TOOLBAR', 1, 'false', 'Enable search toolbar',2);
-
-update ttrss_version set schema_version = 3;
-
-commit;
diff --git a/schema/obsolete/upgrade-1.1-1.1.1-pgsql.sql b/schema/obsolete/upgrade-1.1-1.1.1-pgsql.sql
deleted file mode 100644
index 5b23f3366..000000000
--- a/schema/obsolete/upgrade-1.1-1.1.1-pgsql.sql
+++ /dev/null
@@ -1,43 +0,0 @@
-begin;
-
-alter table ttrss_entries add column num_comments integer;
-
-update ttrss_entries set num_comments = 0;
-
-alter table ttrss_entries alter column num_comments set not null;
-alter table ttrss_entries alter column num_comments set default 0;
-
-insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('COMBINED_DISPLAY_MODE', 1, 'false', 'Combined feed display',2,
- 'Display expanded list of feed articles, instead of separate displays for headlines and article content');
-
-alter table ttrss_feed_categories add column collapsed boolean;
-
-update ttrss_feed_categories set collapsed = false;
-
-alter table ttrss_feed_categories alter column collapsed set not null;
-alter table ttrss_feed_categories alter column collapsed set default false;
-
-alter table ttrss_feeds add column auth_login varchar(250);
-alter table ttrss_feeds add column auth_pass varchar(250);
-
-update ttrss_feeds set auth_login = '';
-update ttrss_feeds set auth_pass = '';
-
-alter table ttrss_feeds alter column auth_login set not null;
-alter table ttrss_feeds alter column auth_login set default '';
-
-alter table ttrss_feeds alter column auth_pass set not null;
-alter table ttrss_feeds alter column auth_pass set default '';
-
-alter table ttrss_users add column email varchar(250);
-
-update ttrss_users set email = '';
-
-alter table ttrss_users alter column email set not null;
-alter table ttrss_users alter column email set default '';
-
-insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('ENABLE_SEARCH_TOOLBAR', 1, 'false', 'Enable search toolbar',2);
-
-update ttrss_version set schema_version = 3;
-
-commit;
diff --git a/schema/obsolete/upgrade-1.1.1-1.1.2-mysql.sql b/schema/obsolete/upgrade-1.1.1-1.1.2-mysql.sql
deleted file mode 100644
index 6dfc5f82f..000000000
--- a/schema/obsolete/upgrade-1.1.1-1.1.2-mysql.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;
diff --git a/schema/obsolete/upgrade-1.1.1-1.1.2-pgsql.sql b/schema/obsolete/upgrade-1.1.1-1.1.2-pgsql.sql
deleted file mode 100644
index 1f926eaeb..000000000
--- a/schema/obsolete/upgrade-1.1.1-1.1.2-pgsql.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 boolean;
-
-update ttrss_feeds set private = false;
-
-alter table ttrss_feeds alter column private set not null;
-alter table ttrss_feeds alter column private set default false;
-
-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;
diff --git a/schema/obsolete/upgrade-1.1.2-1.1.3-mysql.sql b/schema/obsolete/upgrade-1.1.2-1.1.3-mysql.sql
deleted file mode 100644
index e3ddb0357..000000000
--- a/schema/obsolete/upgrade-1.1.2-1.1.3-mysql.sql
+++ /dev/null
@@ -1,12 +0,0 @@
-begin;
-
-create table ttrss_scheduled_updates (id integer not null primary key auto_increment,
- owner_uid integer not null,
- feed_id integer default null,
- entered datetime not null,
- foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE,
- foreign key (feed_id) references ttrss_feeds(id) ON DELETE CASCADE) TYPE=InnoDB;
-
-update ttrss_version set schema_version = 5;
-
-commit;
diff --git a/schema/obsolete/upgrade-1.1.2-1.1.3-pgsql.sql b/schema/obsolete/upgrade-1.1.2-1.1.3-pgsql.sql
deleted file mode 100644
index 1292daa3c..000000000
--- a/schema/obsolete/upgrade-1.1.2-1.1.3-pgsql.sql
+++ /dev/null
@@ -1,10 +0,0 @@
-begin;
-
-create table ttrss_scheduled_updates (id serial not null primary key,
- owner_uid integer not null references ttrss_users(id) ON DELETE CASCADE,
- feed_id integer default null references ttrss_feeds(id) ON DELETE CASCADE,
- entered timestamp not null default NOW());
-
-update ttrss_version set schema_version = 5;
-
-commit;
diff --git a/schema/obsolete/upgrade-1.1.3-1.1.4-mysql.sql b/schema/obsolete/upgrade-1.1.3-1.1.4-mysql.sql
deleted file mode 100644
index 1018bcf4d..000000000
--- a/schema/obsolete/upgrade-1.1.3-1.1.4-mysql.sql
+++ /dev/null
@@ -1,20 +0,0 @@
-alter table ttrss_entries add column author varchar(250);
-
-update ttrss_entries set author = '';
-
-alter table ttrss_entries change author author varchar(250) not null;
-alter table ttrss_entries alter column author set default '';
-
-create table ttrss_sessions (id varchar(250) not null primary key,
- data text,
- expire integer not null,
- ip_address varchar(15) not null default '',
- index (id),
- index (expire)) TYPE=InnoDB;
-
-delete from ttrss_prefs where pref_name = 'ENABLE_SPLASH';
-
-insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('OPEN_LINKS_IN_NEW_WINDOW', 1, 'true', 'Open article links in new browser window',2);
-
-update ttrss_version set schema_version = 6;
-
diff --git a/schema/obsolete/upgrade-1.1.3-1.1.4-pgsql.sql b/schema/obsolete/upgrade-1.1.3-1.1.4-pgsql.sql
deleted file mode 100644
index 6c406495d..000000000
--- a/schema/obsolete/upgrade-1.1.3-1.1.4-pgsql.sql
+++ /dev/null
@@ -1,24 +0,0 @@
-begin;
-
-alter table ttrss_entries add column author varchar(250);
-
-update ttrss_entries set author = '';
-
-alter table ttrss_entries alter column author set not null;
-alter table ttrss_entries alter column author set default '';
-
-create table ttrss_sessions (id varchar(250) unique not null primary key,
- data text,
- expire integer not null,
- ip_address varchar(15) not null default '');
-
-create index ttrss_sessions_id_index on ttrss_sessions(id);
-create index ttrss_sessions_expire_index on ttrss_sessions(expire);
-
-delete from ttrss_prefs where pref_name = 'ENABLE_SPLASH';
-
-insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('OPEN_LINKS_IN_NEW_WINDOW', 1, 'true', 'Open article links in new browser window',2);
-
-update ttrss_version set schema_version = 6;
-
-commit;
diff --git a/schema/obsolete/upgrade-1.1.4-1.1.5-mysql.sql b/schema/obsolete/upgrade-1.1.4-1.1.5-mysql.sql
deleted file mode 100644
index bee135989..000000000
--- a/schema/obsolete/upgrade-1.1.4-1.1.5-mysql.sql
+++ /dev/null
@@ -1,19 +0,0 @@
-alter table ttrss_feeds add column rtl_content bool;
-
-update ttrss_feeds set rtl_content = false;
-
-alter table ttrss_feeds change rtl_content rtl_content bool not null;
-alter table ttrss_feeds alter column rtl_content set default false;
-
-delete from ttrss_user_prefs where pref_name = 'DISPLAY_FEEDLIST_ACTIONS';
-delete from ttrss_prefs where pref_name = 'DISPLAY_FEEDLIST_ACTIONS';
-
-delete from ttrss_user_prefs where pref_name = 'ENABLE_PREFS_CATCHUP_UNCATCHUP';
-delete from ttrss_prefs where pref_name = 'ENABLE_PREFS_CATCHUP_UNCATCHUP';
-
-alter table ttrss_sessions drop column ip_address;
-
-alter table ttrss_filters drop column description;
-
-update ttrss_version set schema_version = 7;
-
diff --git a/schema/obsolete/upgrade-1.1.4-1.1.5-pgsql.sql b/schema/obsolete/upgrade-1.1.4-1.1.5-pgsql.sql
deleted file mode 100644
index 51437e4fa..000000000
--- a/schema/obsolete/upgrade-1.1.4-1.1.5-pgsql.sql
+++ /dev/null
@@ -1,22 +0,0 @@
-begin;
-
-alter table ttrss_feeds add column rtl_content boolean;
-
-update ttrss_feeds set rtl_content = false;
-
-alter table ttrss_feeds alter column rtl_content set not null;
-alter table ttrss_feeds alter column rtl_content set default false;
-
-alter table ttrss_sessions drop column ip_address;
-
-delete from ttrss_user_prefs where pref_name = 'DISPLAY_FEEDLIST_ACTIONS';
-delete from ttrss_prefs where pref_name = 'DISPLAY_FEEDLIST_ACTIONS';
-
-delete from ttrss_user_prefs where pref_name = 'ENABLE_PREFS_CATCHUP_UNCATCHUP';
-delete from ttrss_prefs where pref_name = 'ENABLE_PREFS_CATCHUP_UNCATCHUP';
-
-alter table ttrss_filters drop column description;
-
-update ttrss_version set schema_version = 7;
-
-commit;
diff --git a/schema/obsolete/upgrade-1.1.5-1.1.7-mysql.sql b/schema/obsolete/upgrade-1.1.5-1.1.7-mysql.sql
deleted file mode 100644
index 39100450b..000000000
--- a/schema/obsolete/upgrade-1.1.5-1.1.7-mysql.sql
+++ /dev/null
@@ -1,14 +0,0 @@
-insert into ttrss_themes (theme_name, theme_path) values ('Old-skool', 'compat');
-
-insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('ON_CATCHUP_SHOW_NEXT_FEED', 1, 'false', 'On catchup show next feed',2,
- 'When "Mark as read" button is clicked in toolbar, automatically open next feed with unread articles.');
-
-insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('FEEDS_SORT_BY_UNREAD', 1, 'false', 'Sort feeds by unread articles count',2);
-
-insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('EXTENDED_FEEDLIST', 1, 'false', 'Show additional information in feedlist',2);
-
-insert into ttrss_filter_actions (id,name,description) values (3, 'mark',
- 'Set starred');
-
-update ttrss_version set schema_version = 8;
-
diff --git a/schema/obsolete/upgrade-1.1.5-1.1.7-pgsql.sql b/schema/obsolete/upgrade-1.1.5-1.1.7-pgsql.sql
deleted file mode 100644
index ab7a7df33..000000000
--- a/schema/obsolete/upgrade-1.1.5-1.1.7-pgsql.sql
+++ /dev/null
@@ -1,17 +0,0 @@
-begin;
-
-insert into ttrss_themes (theme_name, theme_path) values ('Old-skool', 'compat');
-
-insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('ON_CATCHUP_SHOW_NEXT_FEED', 1, 'false', 'On catchup show next feed',2,
- 'When "Mark as read" button is clicked in toolbar, automatically open next feed with unread articles.');
-
-insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('FEEDS_SORT_BY_UNREAD', 1, 'false', 'Sort feeds by unread articles count',2);
-
-insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('EXTENDED_FEEDLIST', 1, 'false', 'Show additional information in feedlist',2);
-
-insert into ttrss_filter_actions (id,name,description) values (3, 'mark',
- 'Set starred');
-
-update ttrss_version set schema_version = 8;
-
-commit;
diff --git a/schema/obsolete/upgrade-1.1.7-1.2.2-mysql.sql b/schema/obsolete/upgrade-1.1.7-1.2.2-mysql.sql
deleted file mode 100644
index 546adc2d7..000000000
--- a/schema/obsolete/upgrade-1.1.7-1.2.2-mysql.sql
+++ /dev/null
@@ -1,29 +0,0 @@
-alter table ttrss_feeds add column hidden bool;
-update ttrss_feeds set hidden = false;
-alter table ttrss_feeds change hidden hidden bool not null;
-alter table ttrss_feeds alter column hidden set default false;
-
-alter table ttrss_users add column email_digest bool;
-update ttrss_users set email_digest = false;
-alter table ttrss_users change email_digest email_digest bool not null;
-alter table ttrss_users alter column email_digest set default false;
-
-alter table ttrss_users add column last_digest_sent datetime;
-update ttrss_users set last_digest_sent = false;
-alter table ttrss_users alter column last_digest_sent set default null;
-
-alter table ttrss_filters add column enabled bool;
-update ttrss_filters set enabled = true;
-alter table ttrss_filters change enabled enabled bool not null;
-alter table ttrss_filters alter column enabled set default true;
-
-insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('MARK_UNREAD_ON_UPDATE', 1, 'false', 'Set articles as unread on update',3);
-
-insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('REVERSE_HEADLINES', 1, 'false', 'Reverse headline order (oldest first)',2);
-
-update ttrss_prefs SET section_id = 3 WHERE pref_name = 'ENABLE_SEARCH_TOOLBAR';
-update ttrss_prefs SET section_id = 3 WHERE pref_name = 'ENABLE_FEED_ICONS';
-update ttrss_prefs SET section_id = 3 WHERE pref_name = 'EXTENDED_FEEDLIST';
-
-update ttrss_version set schema_version = 9;
-
diff --git a/schema/obsolete/upgrade-1.1.7-1.2.2-pgsql.sql b/schema/obsolete/upgrade-1.1.7-1.2.2-pgsql.sql
deleted file mode 100644
index 9624403aa..000000000
--- a/schema/obsolete/upgrade-1.1.7-1.2.2-pgsql.sql
+++ /dev/null
@@ -1,33 +0,0 @@
-begin;
-
-alter table ttrss_feeds add column hidden boolean;
-update ttrss_feeds set hidden = false;
-alter table ttrss_feeds alter column hidden set not null;
-alter table ttrss_feeds alter column hidden set default false;
-
-alter table ttrss_users add column email_digest boolean;
-update ttrss_users set email_digest = false;
-alter table ttrss_users alter column email_digest set not null;
-alter table ttrss_users alter column email_digest set default false;
-
-alter table ttrss_users add column last_digest_sent timestamp;
-update ttrss_users set last_digest_sent = NULL;
-alter table ttrss_users alter column last_digest_sent set default NULL;
-
-alter table ttrss_filters add column enabled boolean;
-update ttrss_filters set enabled = true;
-alter table ttrss_filters alter column enabled set not null;
-alter table ttrss_filters alter column enabled set default true;
-
-insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('MARK_UNREAD_ON_UPDATE', 1, 'false', 'Set articles as unread on update',3);
-
-insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('REVERSE_HEADLINES', 1, 'false', 'Reverse headline order (oldest first)',2);
-
-update ttrss_prefs SET section_id = 3 WHERE pref_name = 'ENABLE_SEARCH_TOOLBAR';
-update ttrss_prefs SET section_id = 3 WHERE pref_name = 'ENABLE_FEED_ICONS';
-update ttrss_prefs SET section_id = 3 WHERE pref_name = 'EXTENDED_FEEDLIST';
-
-update ttrss_version set schema_version = 9;
-
-commit;
-
diff --git a/schema/obsolete/upgrade-1.2.2-1.2.3-mysql.sql b/schema/obsolete/upgrade-1.2.2-1.2.3-mysql.sql
deleted file mode 100644
index e951f482f..000000000
--- a/schema/obsolete/upgrade-1.2.2-1.2.3-mysql.sql
+++ /dev/null
@@ -1,12 +0,0 @@
-insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('DIGEST_ENABLE', 1, 'false', 'Enable e-mail digest',1,
-'This option enables sending daily digest of new (and unread) headlines on your configured e-mail address');
-
-alter table ttrss_feeds add column include_in_digest bool;
-update ttrss_feeds set include_in_digest = true;
-alter table ttrss_feeds change include_in_digest include_in_digest bool not null;
-alter table ttrss_feeds alter column include_in_digest set default true;
-
-insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('CONFIRM_FEED_CATCHUP', 1, 'true', 'Confirm marking feed as read',3);
-
-update ttrss_version set schema_version = 10;
-
diff --git a/schema/obsolete/upgrade-1.2.2-1.2.3-pgsql.sql b/schema/obsolete/upgrade-1.2.2-1.2.3-pgsql.sql
deleted file mode 100644
index 764b4b763..000000000
--- a/schema/obsolete/upgrade-1.2.2-1.2.3-pgsql.sql
+++ /dev/null
@@ -1,12 +0,0 @@
-insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('DIGEST_ENABLE', 1, 'false', 'Enable e-mail digest',1,
-'This option enables sending daily digest of new (and unread) headlines on your configured e-mail address');
-
-alter table ttrss_feeds add column include_in_digest boolean;
-update ttrss_feeds set include_in_digest = true;
-alter table ttrss_feeds alter column include_in_digest set not null;
-alter table ttrss_feeds alter column include_in_digest set default true;
-
-insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('CONFIRM_FEED_CATCHUP', 1, 'true', 'Confirm marking feed as read',3);
-
-update ttrss_version set schema_version = 10;
-
diff --git a/schema/obsolete/upgrade-1.2.3-1.2.4-mysql.sql b/schema/obsolete/upgrade-1.2.3-1.2.4-mysql.sql
deleted file mode 100644
index 690b978eb..000000000
--- a/schema/obsolete/upgrade-1.2.3-1.2.4-mysql.sql
+++ /dev/null
@@ -1,18 +0,0 @@
-begin;
-
-delete FROM ttrss_user_prefs WHERE pref_name = 'DISPLAY_HEADER';
-delete FROM ttrss_user_prefs WHERE pref_name = 'DISPLAY_FOOTER';
-delete FROM ttrss_user_prefs WHERE pref_name = 'ENABLE_SEARCH_TOOLBAR';
-delete FROM ttrss_user_prefs WHERE pref_name = 'USE_COMPACT_STYLESHEET';
-
-delete FROM ttrss_prefs WHERE pref_name = 'DISPLAY_HEADER';
-delete FROM ttrss_prefs WHERE pref_name = 'DISPLAY_FOOTER';
-delete FROM ttrss_prefs WHERE pref_name = 'ENABLE_SEARCH_TOOLBAR';
-delete FROM ttrss_prefs WHERE pref_name = 'USE_COMPACT_STYLESHEET';
-
-insert into ttrss_themes (theme_name, theme_path) values ('Graycube', 'graycube');
-insert into ttrss_themes (theme_name, theme_path) values ('Default (Compact)', 'compact');
-
-update ttrss_version set schema_version = 11;
-
-commit;
diff --git a/schema/obsolete/upgrade-1.2.3-1.2.4-pgsql.sql b/schema/obsolete/upgrade-1.2.3-1.2.4-pgsql.sql
deleted file mode 100644
index 690b978eb..000000000
--- a/schema/obsolete/upgrade-1.2.3-1.2.4-pgsql.sql
+++ /dev/null
@@ -1,18 +0,0 @@
-begin;
-
-delete FROM ttrss_user_prefs WHERE pref_name = 'DISPLAY_HEADER';
-delete FROM ttrss_user_prefs WHERE pref_name = 'DISPLAY_FOOTER';
-delete FROM ttrss_user_prefs WHERE pref_name = 'ENABLE_SEARCH_TOOLBAR';
-delete FROM ttrss_user_prefs WHERE pref_name = 'USE_COMPACT_STYLESHEET';
-
-delete FROM ttrss_prefs WHERE pref_name = 'DISPLAY_HEADER';
-delete FROM ttrss_prefs WHERE pref_name = 'DISPLAY_FOOTER';
-delete FROM ttrss_prefs WHERE pref_name = 'ENABLE_SEARCH_TOOLBAR';
-delete FROM ttrss_prefs WHERE pref_name = 'USE_COMPACT_STYLESHEET';
-
-insert into ttrss_themes (theme_name, theme_path) values ('Graycube', 'graycube');
-insert into ttrss_themes (theme_name, theme_path) values ('Default (Compact)', 'compact');
-
-update ttrss_version set schema_version = 11;
-
-commit;
diff --git a/schema/obsolete/upgrade-1.2.4-1.2.6-mysql.sql b/schema/obsolete/upgrade-1.2.4-1.2.6-mysql.sql
deleted file mode 100644
index 73af4e375..000000000
--- a/schema/obsolete/upgrade-1.2.4-1.2.6-mysql.sql
+++ /dev/null
@@ -1,12 +0,0 @@
-alter table ttrss_filters add column action_param varchar(200);
-
-update ttrss_filters set action_param = '';
-
-alter table ttrss_filters change action_param action_param varchar(200) not null;
-alter table ttrss_filters alter column action_param set default '';
-
-insert into ttrss_filter_actions (id,name,description) values (4, 'tag',
- 'Assign tags');
-
-update ttrss_version set schema_version = 12;
-
diff --git a/schema/obsolete/upgrade-1.2.4-1.2.6-pgsql.sql b/schema/obsolete/upgrade-1.2.4-1.2.6-pgsql.sql
deleted file mode 100644
index 6de90f1ab..000000000
--- a/schema/obsolete/upgrade-1.2.4-1.2.6-pgsql.sql
+++ /dev/null
@@ -1,15 +0,0 @@
-begin;
-
-alter table ttrss_filters add column action_param varchar(200);
-
-update ttrss_filters set action_param = '';
-
-alter table ttrss_filters alter column action_param set not null;
-alter table ttrss_filters alter column action_param set default '';
-
-insert into ttrss_filter_actions (id,name,description) values (4, 'tag',
- 'Assign tags');
-
-update ttrss_version set schema_version = 12;
-
-commit;
diff --git a/schema/upgrade-1.2.6-1.2.8-mysql.sql b/schema/upgrade-1.2.6-1.2.8-mysql.sql
deleted file mode 100644
index ad068c8a2..000000000
--- a/schema/upgrade-1.2.6-1.2.8-mysql.sql
+++ /dev/null
@@ -1,6 +0,0 @@
-alter table ttrss_filters add column inverse bool;
-update ttrss_filters set inverse = false;
-alter table ttrss_filters change inverse inverse bool not null;
-alter table ttrss_filters alter column inverse set default false;
-
-update ttrss_version set schema_version = 13;
diff --git a/schema/upgrade-1.2.6-1.2.8-pgsql.sql b/schema/upgrade-1.2.6-1.2.8-pgsql.sql
deleted file mode 100644
index bf2a2b438..000000000
--- a/schema/upgrade-1.2.6-1.2.8-pgsql.sql
+++ /dev/null
@@ -1,10 +0,0 @@
-begin;
-
-alter table ttrss_filters add column inverse boolean;
-update ttrss_filters set inverse = false;
-alter table ttrss_filters alter column inverse set not null;
-alter table ttrss_filters alter column inverse set default false;
-
-update ttrss_version set schema_version = 13;
-
-commit;