aboutsummaryrefslogtreecommitdiffhomepage
path: root/database
diff options
context:
space:
mode:
authorGravatar Frédéric Guillot <fred@miniflux.net>2019-04-28 18:20:46 -0700
committerGravatar fguillot <fred@miniflux.net>2019-04-28 18:35:58 -0700
commit4295a86e55e765e3e396a03c090bd08be9e0a390 (patch)
tree77b388feb1ec345c3823b7c7338ab8d293ff3b77 /database
parent3c8cc0b2b69c8de7343dfbec0e22934c954487df (diff)
Add option to enable/disable keyboard shortcuts
Diffstat (limited to 'database')
-rw-r--r--database/migration.go2
-rw-r--r--database/sql.go2
-rw-r--r--database/sql/schema_version_23.sql1
3 files changed, 4 insertions, 1 deletions
diff --git a/database/migration.go b/database/migration.go
index 7e37dc6..b48fbf6 100644
--- a/database/migration.go
+++ b/database/migration.go
@@ -12,7 +12,7 @@ import (
"miniflux.app/logger"
)
-const schemaVersion = 22
+const schemaVersion = 23
// Migrate executes database migrations.
func Migrate(db *sql.DB) {
diff --git a/database/sql.go b/database/sql.go
index d4002c8..b7acfc5 100644
--- a/database/sql.go
+++ b/database/sql.go
@@ -146,6 +146,7 @@ update entries set document_vectors = to_tsvector(substring(title || ' ' || coal
create index document_vectors_idx on entries using gin(document_vectors);`,
"schema_version_21": `alter table feeds add column user_agent text default '';`,
"schema_version_22": `update entries set document_vectors = setweight(to_tsvector(substring(coalesce(title, '') for 1000000)), 'A') || setweight(to_tsvector(substring(coalesce(content, '') for 1000000)), 'B');`,
+ "schema_version_23": `alter table users add column keyboard_shortcuts boolean default 't';`,
"schema_version_3": `create table tokens (
id text not null,
value text not null,
@@ -196,6 +197,7 @@ var SqlMapChecksums = map[string]string{
"schema_version_20": "5d414c0cfc0da2863c641079afa58b7ff42dccb0f0e01c822ad435c3e3aa9201",
"schema_version_21": "77da01ee38918ff4fe33985fbb20ed3276a717a7584c2ca9ebcf4d4ab6cb6910",
"schema_version_22": "51ed5fbcae9877e57274511f0ef8c61d254ebd78dfbcbc043a2acd30f4c93ca3",
+ "schema_version_23": "cb3512d328436447f114e305048c0daa8af7505cfe5eab02778b0de1156081b2",
"schema_version_3": "a54745dbc1c51c000f74d4e5068f1e2f43e83309f023415b1749a47d5c1e0f12",
"schema_version_4": "216ea3a7d3e1704e40c797b5dc47456517c27dbb6ca98bf88812f4f63d74b5d9",
"schema_version_5": "46397e2f5f2c82116786127e9f6a403e975b14d2ca7b652a48cd1ba843e6a27c",
diff --git a/database/sql/schema_version_23.sql b/database/sql/schema_version_23.sql
new file mode 100644
index 0000000..2afb962
--- /dev/null
+++ b/database/sql/schema_version_23.sql
@@ -0,0 +1 @@
+alter table users add column keyboard_shortcuts boolean default 't'; \ No newline at end of file