From 35aba6f75c7ee0747036b6671d7850c9cbbb8634 Mon Sep 17 00:00:00 2001 From: Nicolas Boisselier Date: Tue, 9 Jan 2018 03:38:59 +0000 Subject: [PATCH] lib/postgres/mime.sql --- lib/postgres/mime.sql | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) diff --git a/lib/postgres/mime.sql b/lib/postgres/mime.sql index 6ca0a66b..270f5f53 100644 --- a/lib/postgres/mime.sql +++ b/lib/postgres/mime.sql @@ -8,6 +8,7 @@ CREATE TABLE IF NOT EXISTS mime ( CREATE INDEX IF NOT EXISTS mime_ext_idx ON mime (ext); BEGIN TRANSACTION; CREATE TEMPORARY TABLE tmp_mime ON COMMIT DROP AS SELECT * FROM mime LIMIT 0; +DELETE FROM mime; COPY mime FROM STDIN WITH (format 'text', NULL ''); x3d application/vnd.hzn-3d-crossword 3D Crossword Plugin @@ -690,6 +691,7 @@ xul application/vnd.mozilla.xul+xml XUL - XML User Interface Language xwd image/x-xwindowdump X Window Dump xyz chemical/x-xyz XYZ File Format yaml text/yaml YAML Ain't Markup Language / Yet Another Markup Language +yml text/yaml yang application/yang YANG Data Modeling Language yin application/yin+xml YIN (YANG - XML) zip application/zip Zip Archive @@ -708,6 +710,7 @@ https://developer.mozilla.org/en-US/docs/Web/HTTP/Basics_of_HTTP/MIME_types/Comp | sed "s,,\t,g" \ | sed -E -e "s/ *]*> */,/g" -e "s/,[^\t]+//" -e "s, *<[^>]+> *,,g" -e "s/^[\t ]*//" -e "s/([^\t]+)\t([^\t]+)$/\2\t\1/" \ | perl -pe "0 and /^([^\t]+,[^\t]+)/ and @_=split(qq|,|,\$_) and s/^[^\t]+/join(qq|,|,sort {length(\$b)<=>length(\$a)} @_)/e" \ +| sed -e "s/^\.//" ' WITH (format 'text', NULL ''); INSERT INTO mime SELECT * FROM tmp_mime ON CONFLICT DO NOTHING; @@ -716,6 +719,8 @@ COPY tmp_mime FROM PROGRAM 'true && curl -s \ https://gist.githubusercontent.com/electerious/3d5a31a73cfd6423f835c074ab25fc06/raw/d48b8410e9aa6746cfd946bca21a1bb54c351c4e/Caddyfile \ | sed -e "s/^ *//" -e "/^[^\.]/d" -e "s/ /\t/" -e "s/$/\t/" -e "s/^\.//" \ ' WITH (format 'text', NULL ''); -DELETE FROM tmp_mime WHERE LENGTH(ext)>4; INSERT INTO mime SELECT * FROM tmp_mime ON CONFLICT DO NOTHING; + +DELETE FROM mime WHERE LENGTH(ext)>4; +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; -- 2.47.3