schema: add fulltext indexes for mysql to support af_psql_trgm and possibly future fulltext search

4 files changed, 10 insertions, 1 deletions

diff --git a/classes/config.php b/classes/config.php
index 74546e3f2..6ebe31e2d 100644
--- a/classes/config.php
+++ b/classes/config.php
@@ -6,7 +6,7 @@ class Config {
 	const T_STRING = 2;
 	const T_INT = 3;
 
-	const SCHEMA_VERSION = 146;
+	const SCHEMA_VERSION = 147;
 
 	/** override default values, defined below in _DEFAULTS[], prefixing with _ENVVAR_PREFIX:
 	 *
diff --git a/sql/mysql/migrations/147.sql b/sql/mysql/migrations/147.sql
new file mode 100644
index 000000000..6bd4b59c9
--- /dev/null
+++ b/sql/mysql/migrations/147.sql
@@ -0,0 +1,2 @@
+create fulltext index if not exists ttrss_entries_title_search_idx on ttrss_entries(title);
+create fulltext index if not exists ttrss_entries_combined_search_idx on ttrss_entries(title, content);
diff --git a/sql/mysql/schema.sql b/sql/mysql/schema.sql
index 589d1013a..4f9203ed2 100644
--- a/sql/mysql/schema.sql
+++ b/sql/mysql/schema.sql
@@ -169,6 +169,9 @@ create table ttrss_entries (id integer not null primary key auto_increment,
 create index ttrss_entries_date_entered_index on ttrss_entries(date_entered);
 create index ttrss_entries_updated_idx on ttrss_entries(updated);
 
+create fulltext index if not exists ttrss_entries_title_search_idx on ttrss_entries(title);
+create fulltext index if not exists ttrss_entries_combined_search_idx on ttrss_entries(title, content);
+
 create table ttrss_user_entries (
 	int_id integer not null primary key auto_increment,
 	ref_id integer not null,
diff --git a/sql/pgsql/migrations/147.sql b/sql/pgsql/migrations/147.sql
new file mode 100644
index 000000000..00ce22962
--- /dev/null
+++ b/sql/pgsql/migrations/147.sql
@@ -0,0 +1,4 @@
+-- no-op, 147 is mysql-specific.
+-- the following dummy query is added because migration engine doesn't support empty schema files.
+
+select true;