DELETE FROM test01 ;
DELETE FROM test02 ;
DELETE FROM test03 ;
DELETE FROM test04 ;
DELETE FROM test05 ;

COPY 10000 RECORDS INTO test01 FROM '/tmp/1.txt' USING DELIMITERS '|','\n' ;
COPY 10000 RECORDS INTO test02 FROM '/tmp/2.txt' USING DELIMITERS '|','\n' ;
COPY 10000 RECORDS INTO test03 FROM '/tmp/3.txt' USING DELIMITERS '|','\n' ;
COPY 10000 RECORDS INTO test04 FROM '/tmp/4.txt' USING DELIMITERS '|','\n' ;
COPY 10000 RECORDS INTO test05 FROM '/tmp/5.txt' USING DELIMITERS '|','\n' ;

ALTER TABLE test01 ADD COLUMN id INT AUTO_INCREMENT NOT NULL PRIMARY KEY ;
ALTER TABLE test02 ADD COLUMN id INT AUTO_INCREMENT NOT NULL PRIMARY KEY ;
