From 12124198493e6c71f02033aebf85838e4f862598 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Sat, 24 Feb 2007 17:45:27 +0100 Subject: [PATCH] remove old-style schema upgrade files --- schema/obsolete/upgrade-1.0.6-1.0.7-pgsql.sql | 24 ----------- schema/obsolete/upgrade-1.1-1.1.1-mysql.sql | 43 ------------------- schema/obsolete/upgrade-1.1-1.1.1-pgsql.sql | 43 ------------------- schema/obsolete/upgrade-1.1.1-1.1.2-mysql.sql | 17 -------- schema/obsolete/upgrade-1.1.1-1.1.2-pgsql.sql | 17 -------- schema/obsolete/upgrade-1.1.2-1.1.3-mysql.sql | 12 ------ schema/obsolete/upgrade-1.1.2-1.1.3-pgsql.sql | 10 ----- schema/obsolete/upgrade-1.1.3-1.1.4-mysql.sql | 20 --------- schema/obsolete/upgrade-1.1.3-1.1.4-pgsql.sql | 24 ----------- schema/obsolete/upgrade-1.1.4-1.1.5-mysql.sql | 19 -------- schema/obsolete/upgrade-1.1.4-1.1.5-pgsql.sql | 22 ---------- schema/obsolete/upgrade-1.1.5-1.1.7-mysql.sql | 14 ------ schema/obsolete/upgrade-1.1.5-1.1.7-pgsql.sql | 17 -------- schema/obsolete/upgrade-1.1.7-1.2.2-mysql.sql | 29 ------------- schema/obsolete/upgrade-1.1.7-1.2.2-pgsql.sql | 33 -------------- schema/obsolete/upgrade-1.2.2-1.2.3-mysql.sql | 12 ------ schema/obsolete/upgrade-1.2.2-1.2.3-pgsql.sql | 12 ------ schema/obsolete/upgrade-1.2.3-1.2.4-mysql.sql | 18 -------- schema/obsolete/upgrade-1.2.3-1.2.4-pgsql.sql | 18 -------- schema/obsolete/upgrade-1.2.4-1.2.6-mysql.sql | 12 ------ schema/obsolete/upgrade-1.2.4-1.2.6-pgsql.sql | 15 ------- schema/upgrade-1.2.6-1.2.8-mysql.sql | 6 --- schema/upgrade-1.2.6-1.2.8-pgsql.sql | 10 ----- 23 files changed, 447 deletions(-) delete mode 100644 schema/obsolete/upgrade-1.0.6-1.0.7-pgsql.sql delete mode 100644 schema/obsolete/upgrade-1.1-1.1.1-mysql.sql delete mode 100644 schema/obsolete/upgrade-1.1-1.1.1-pgsql.sql delete mode 100644 schema/obsolete/upgrade-1.1.1-1.1.2-mysql.sql delete mode 100644 schema/obsolete/upgrade-1.1.1-1.1.2-pgsql.sql delete mode 100644 schema/obsolete/upgrade-1.1.2-1.1.3-mysql.sql delete mode 100644 schema/obsolete/upgrade-1.1.2-1.1.3-pgsql.sql delete mode 100644 schema/obsolete/upgrade-1.1.3-1.1.4-mysql.sql delete mode 100644 schema/obsolete/upgrade-1.1.3-1.1.4-pgsql.sql delete mode 100644 schema/obsolete/upgrade-1.1.4-1.1.5-mysql.sql delete mode 100644 schema/obsolete/upgrade-1.1.4-1.1.5-pgsql.sql delete mode 100644 schema/obsolete/upgrade-1.1.5-1.1.7-mysql.sql delete mode 100644 schema/obsolete/upgrade-1.1.5-1.1.7-pgsql.sql delete mode 100644 schema/obsolete/upgrade-1.1.7-1.2.2-mysql.sql delete mode 100644 schema/obsolete/upgrade-1.1.7-1.2.2-pgsql.sql delete mode 100644 schema/obsolete/upgrade-1.2.2-1.2.3-mysql.sql delete mode 100644 schema/obsolete/upgrade-1.2.2-1.2.3-pgsql.sql delete mode 100644 schema/obsolete/upgrade-1.2.3-1.2.4-mysql.sql delete mode 100644 schema/obsolete/upgrade-1.2.3-1.2.4-pgsql.sql delete mode 100644 schema/obsolete/upgrade-1.2.4-1.2.6-mysql.sql delete mode 100644 schema/obsolete/upgrade-1.2.4-1.2.6-pgsql.sql delete mode 100644 schema/upgrade-1.2.6-1.2.8-mysql.sql delete mode 100644 schema/upgrade-1.2.6-1.2.8-pgsql.sql 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 7f0cfaac..00000000 --- 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 79860a29..00000000 --- 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 5b23f336..00000000 --- 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 6dfc5f82..00000000 --- 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 1f926eae..00000000 --- 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 e3ddb035..00000000 --- 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 1292daa3..00000000 --- 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 1018bcf4..00000000 --- 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 6c406495..00000000 --- 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 bee13598..00000000 --- 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 51437e4f..00000000 --- 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 39100450..00000000 --- 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 ab7a7df3..00000000 --- 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 546adc2d..00000000 --- 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 9624403a..00000000 --- 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 e951f482..00000000 --- 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 764b4b76..00000000 --- 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 690b978e..00000000 --- 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 690b978e..00000000 --- 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 73af4e37..00000000 --- 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 6de90f1a..00000000 --- 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 ad068c8a..00000000 --- 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 bf2a2b43..00000000 --- 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; -- 2.39.5