aboutsummaryrefslogtreecommitdiffhomepage
path: root/database
diff options
context:
space:
mode:
authorGravatar Frédéric Guillot <fred@miniflux.net>2019-09-21 19:10:08 -0700
committerGravatar Frédéric Guillot <fred@miniflux.net>2019-09-21 20:04:42 -0700
commitafe1faf2141ef9cd3a5564fa33646b821ae5162b (patch)
treeca3fbbea8236154aabeedd54c05775e7f4fcbf35 /database
parentd610d091fed6dbac3a7ae7e6a67e6e8455b77755 (diff)
Add theme variants
- Use CSS variables instead of inherence - Rename default theme to "Light - Serif" - Rename Black theme to "Dark - Serif" - Rename "Sans-Serif" theme to "Light - Sans Serif" - Add "System" theme that use system preferences: Dark or Light - Add Serif and Sans-Serif variants for each color theme
Diffstat (limited to 'database')
-rw-r--r--database/migration.go2
-rw-r--r--database/sql.go6
-rw-r--r--database/sql/schema_version_25.sql4
3 files changed, 11 insertions, 1 deletions
diff --git a/database/migration.go b/database/migration.go
index 399c11b..0d9dc51 100644
--- a/database/migration.go
+++ b/database/migration.go
@@ -12,7 +12,7 @@ import (
"miniflux.app/logger"
)
-const schemaVersion = 24
+const schemaVersion = 25
// Migrate executes database migrations.
func Migrate(db *sql.DB) {
diff --git a/database/sql.go b/database/sql.go
index c8d7042..76d1d31 100644
--- a/database/sql.go
+++ b/database/sql.go
@@ -148,6 +148,11 @@ create index document_vectors_idx on entries using gin(document_vectors);`,
"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_24": `alter table feeds add column disabled boolean default 'f';`,
+ "schema_version_25": `ALTER TABLE users ALTER COLUMN theme SET DEFAULT 'light_serif';
+UPDATE users SET theme='light_serif' WHERE theme='default';
+UPDATE users SET theme='light_sans_serif' WHERE theme='sansserif';
+UPDATE users SET theme='dark_serif' WHERE theme='black';
+`,
"schema_version_3": `create table tokens (
id text not null,
value text not null,
@@ -200,6 +205,7 @@ var SqlMapChecksums = map[string]string{
"schema_version_22": "51ed5fbcae9877e57274511f0ef8c61d254ebd78dfbcbc043a2acd30f4c93ca3",
"schema_version_23": "cb3512d328436447f114e305048c0daa8af7505cfe5eab02778b0de1156081b2",
"schema_version_24": "1224754c5b9c6b4038599852bbe72656d21b09cb018d3970bd7c00f0019845bf",
+ "schema_version_25": "5262d2d4c88d637b6603a1fcd4f68ad257bd59bd1adf89c58a18ee87b12050d7",
"schema_version_3": "a54745dbc1c51c000f74d4e5068f1e2f43e83309f023415b1749a47d5c1e0f12",
"schema_version_4": "216ea3a7d3e1704e40c797b5dc47456517c27dbb6ca98bf88812f4f63d74b5d9",
"schema_version_5": "46397e2f5f2c82116786127e9f6a403e975b14d2ca7b652a48cd1ba843e6a27c",
diff --git a/database/sql/schema_version_25.sql b/database/sql/schema_version_25.sql
new file mode 100644
index 0000000..e0b6342
--- /dev/null
+++ b/database/sql/schema_version_25.sql
@@ -0,0 +1,4 @@
+ALTER TABLE users ALTER COLUMN theme SET DEFAULT 'light_serif';
+UPDATE users SET theme='light_serif' WHERE theme='default';
+UPDATE users SET theme='light_sans_serif' WHERE theme='sansserif';
+UPDATE users SET theme='dark_serif' WHERE theme='black';