From a7c7e16dbe2f918ca90eaf92e135241b3e4785c1 Mon Sep 17 00:00:00 2001 From: Nicolas Boisselier Date: Fri, 1 Nov 2019 15:23:11 +0000 Subject: [PATCH] /opt/nb/lib/postgres/mime.sql --- lib/postgres/mime.sql | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/lib/postgres/mime.sql b/lib/postgres/mime.sql index 5b7a5495..0a32b9c5 100644 --- a/lib/postgres/mime.sql +++ b/lib/postgres/mime.sql @@ -12,6 +12,7 @@ BEGIN TRANSACTION; DELETE FROM mime; CREATE TEMPORARY TABLE tmp_mime ON COMMIT DROP AS SELECT * FROM mime LIMIT 0; +SELECT '>Stdin' as 'log'; COPY mime (ext,type,name) FROM STDIN WITH (format 'text', NULL ''); x3d application/vnd.hzn-3d-crossword 3D Crossword Plugin 3g2 video/3gpp2 3GP2 @@ -702,6 +703,7 @@ zmm application/vnd.handheld-entertainment+xml ZVUE Media Manager zaz application/vnd.zzazz.deck+xml Zzazz Deck \. +SELECT '>developer.mozilla.org' as 'log'; DELETE FROM tmp_mime; COPY tmp_mime FROM PROGRAM 'true && curl -s \ https://developer.mozilla.org/en-US/docs/Web/HTTP/Basics_of_HTTP/MIME_types/Complete_list_of_MIME_types \ @@ -717,6 +719,7 @@ https://developer.mozilla.org/en-US/docs/Web/HTTP/Basics_of_HTTP/MIME_types/Comp ' WITH (format 'text', NULL ''); INSERT INTO mime SELECT * FROM tmp_mime ON CONFLICT DO NOTHING; +SELECT '>gist.githubusercontent.com' as 'log'; DELETE FROM tmp_mime; COPY tmp_mime FROM PROGRAM 'true && curl -s \ https://gist.githubusercontent.com/electerious/3d5a31a73cfd6423f835c074ab25fc06/raw/d48b8410e9aa6746cfd946bca21a1bb54c351c4e/Caddyfile \ @@ -724,6 +727,7 @@ https://gist.githubusercontent.com/electerious/3d5a31a73cfd6423f835c074ab25fc06/ ' WITH (format 'text', NULL ''); INSERT INTO mime SELECT * FROM tmp_mime ON CONFLICT DO NOTHING; +SELECT '>svn.apache.org' as 'log'; DELETE FROM tmp_mime; COPY tmp_mime FROM PROGRAM 'curl -s \ http://svn.apache.org/repos/asf/httpd/httpd/trunk/docs/conf/mime.types \ -- 2.47.3