-- Last update: Oct 18, 2007
-- Database: `cemipat`
--
-- BY JULIO RAFFO (EPFL/CEMI)
--
-- --------------------------------------------------------

create table cemipat.naceipc_dgr (
dgrfield smallint,
IPC varchar(4),
NACE varchar(11)
);

LOAD DATA INFILE 'E:/scripts/patstat/sector/IPC_NACE_DGR.txt'
INTO TABLE cemipat.naceipc_dgr
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES ;


create table cemipat.isicipc_merit (
ISIC varchar(40),
IPC varchar(4)
);

LOAD DATA INFILE 'E:/scripts/patstat/sector/IPC_ISIC_MERIT.txt'
INTO TABLE cemipat.isicipc_merit
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES ;