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



create table cemipat.ctry_names (
ctry_code char(2),
ctry_name varchar(100)
);

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


create table cemipat.ctry_geog (
ctry_code char(2),
ctry_name varchar(100),
lat_grad smallint,
lat_min smallint,
lat_hem char(1),
lon_grad smallint,
lon_min smallint,
lon_hem char(1),
latnorm	int,
longnorm int
);

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