From afe1faf2141ef9cd3a5564fa33646b821ae5162b Mon Sep 17 00:00:00 2001 From: Frédéric Guillot Date: Sat, 21 Sep 2019 19:10:08 -0700 Subject: 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 --- database/migration.go | 2 +- database/sql.go | 6 ++++++ database/sql/schema_version_25.sql | 4 ++++ 3 files changed, 11 insertions(+), 1 deletion(-) create mode 100644 database/sql/schema_version_25.sql (limited to 'database') 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'; -- cgit v1.2.3