From f07ac5eab7543f4e68d0632d68f960f025bb1dc8 Mon Sep 17 00:00:00 2001 From: olivier Date: Fri, 23 Jan 2009 16:41:26 +0000 Subject: [PATCH] turn mucem_import into a temporary table git-svn-id: http://svn.parisson.org/svn/crem@56 3bf09e05-f825-4182-b9bc-eedd7160adf0 --- trunk/import/prototype/scripts/mucem-import.sql | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) diff --git a/trunk/import/prototype/scripts/mucem-import.sql b/trunk/import/prototype/scripts/mucem-import.sql index 1db0ae8..f8b11ba 100644 --- a/trunk/import/prototype/scripts/mucem-import.sql +++ b/trunk/import/prototype/scripts/mucem-import.sql @@ -1,8 +1,7 @@ SET NAMES 'utf8'; -DROP TABLE IF EXISTS mucem_import; -CREATE TABLE mucem_import ( +CREATE TEMPORARY TABLE mucem_import ( f1 VARCHAR (255) NOT NULL, f2 VARCHAR (255) NOT NULL, f3 VARCHAR (255) NOT NULL, f4 VARCHAR (255) NOT NULL, f5 VARCHAR (255) NOT NULL, f6 VARCHAR (255) NOT NULL, f7 VARCHAR (255) NOT NULL, f8 VARCHAR (255) NOT NULL, f9 VARCHAR (255) NOT NULL, -- 2.39.5