From 1c69f24acd43927ac98234f2f5f1d3bbde5c2e73 Mon Sep 17 00:00:00 2001 From: Nicolas Boisselier Date: Tue, 9 Jan 2018 04:27:35 +0000 Subject: [PATCH] lib/postgres/mime.sql --- lib/postgres/mime.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/lib/postgres/mime.sql b/lib/postgres/mime.sql index e9f2535c..d9a1fdb3 100644 --- a/lib/postgres/mime.sql +++ b/lib/postgres/mime.sql @@ -7,8 +7,8 @@ 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; +CREATE TEMPORARY TABLE tmp_mime ON COMMIT DROP AS SELECT * FROM mime LIMIT 0; COPY mime FROM STDIN WITH (format 'text', NULL ''); x3d application/vnd.hzn-3d-crossword 3D Crossword Plugin -- 2.47.3