From 160daae4c26d74497e39c6c2d43058abd13e0132 Mon Sep 17 00:00:00 2001 From: Nicolas Boisselier Date: Tue, 9 Jan 2018 03:45:34 +0000 Subject: [PATCH] lib/postgres/mime.sql --- lib/postgres/mime.sql | 2 +- www/dbq/html/default.css | 1 + 2 files changed, 2 insertions(+), 1 deletion(-) diff --git a/lib/postgres/mime.sql b/lib/postgres/mime.sql index 270f5f53..e9f2535c 100644 --- a/lib/postgres/mime.sql +++ b/lib/postgres/mime.sql @@ -721,6 +721,6 @@ https://gist.githubusercontent.com/electerious/3d5a31a73cfd6423f835c074ab25fc06/ ' WITH (format 'text', NULL ''); INSERT INTO mime SELECT * FROM tmp_mime ON CONFLICT DO NOTHING; -DELETE FROM mime WHERE LENGTH(ext)>4; +-- DELETE FROM mime WHERE LENGTH(ext)>6; UPDATE mime AS m1 SET name=(SELECT name FROM mime AS m2 WHERE m2.name<>'' AND m2.type=m1.type ORDER BY name LIMIT 1) WHERE COALESCE(name,'')=''; COMMIT; diff --git a/www/dbq/html/default.css b/www/dbq/html/default.css index 844abd7a..3ae37870 100644 --- a/www/dbq/html/default.css +++ b/www/dbq/html/default.css @@ -76,6 +76,7 @@ table { border-collapse: collapse; } td, th { padding: 0.2em 0.7em; } /* th a.sort { padding: 0 0.3em; } +th a.sort.sel { color: green; } */ th a.sort { float: left; margin-right: 0.1em; } -- 2.47.3