From f05cbc00197193adeb3af9c5836840dcd914e5d0 Mon Sep 17 00:00:00 2001 From: Nicolas Boisselier Date: Wed, 7 Feb 2018 20:22:14 +0000 Subject: [PATCH] lib/postgres/mime.sql --- lib/postgres/mime.sql | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/lib/postgres/mime.sql b/lib/postgres/mime.sql index 48463ed5..06e85d43 100644 --- a/lib/postgres/mime.sql +++ b/lib/postgres/mime.sql @@ -724,7 +724,10 @@ https://gist.githubusercontent.com/electerious/3d5a31a73cfd6423f835c074ab25fc06/ INSERT INTO mime SELECT * FROM tmp_mime ON CONFLICT DO NOTHING; DELETE FROM tmp_mime; -COPY tmp_mime FROM PROGRAM 'curl -s http://svn.apache.org/repos/asf/httpd/httpd/trunk/docs/conf/mime.types | egrep "^\w"| sed -E "s/^([^\t ]+)[\t ]+([^\t ]+)/\2\t\1/"' WITH (format 'text', NULL ''); +COPY tmp_mime FROM PROGRAM 'curl -s \ +http://svn.apache.org/repos/asf/httpd/httpd/trunk/docs/conf/mime.types \ +| egrep "^\w" \ +| sed -E "s/^([^\t ]+)[\t ]+([^\t ]+)/\2\t\1\t2/"' WITH (format 'text', NULL ''); INSERT INTO mime SELECT * FROM tmp_mime ON CONFLICT DO NOTHING; -- DELETE FROM mime WHERE LENGTH(ext)>6; -- 2.47.3