 
 -- pig_pn
 -- use Unix EOL (created by mdbtools)
-LOAD DATA INFILE '/usr/home/samba/epd2/csv/pig_pn.csv'
+LOAD DATA INFILE '/usr/home/samba/maestro/csv/pig_pn.csv'
 INTO TABLE epd2.tbl_pig_pn
 CHARACTER SET ascii
 FIELDS

(TYPEID,TYPEType);

-- pig_un
-- units of measure
-- use Unix EOL (created by mdbtools)
LOAD DATA INFILE '/usr/home/samba/epd2/csv/pig_un.csv'
INTO TABLE epd2.tbl_pig_un
CHARACTER SET ascii
FIELDS

(serial_number,part_number,description,version,status)
SET id = NULL;

-- stock_location spreadsheet
-- use Windows EOL (CSV created by Excel)
LOAD DATA INFILE '/usr/home/samba/maestro/csv/partloc_location.csv'
INTO TABLE epd2.tbl_partloc_location
CHARACTER SET ascii
FIELDS
	TERMINATED BY ','
	OPTIONALLY ENCLOSED BY '"'
	ESCAPED BY '"'
LINES
	TERMINATED BY '\r\n'
IGNORE 1 LINES
(name,use_sublocation,sublocation_min,sublocation_max)
SET id = NULL;

-- Parts&Vendors database
-- primary keys retained from Parts&Vendors tables
-- pig_al
-- no data expected when importing from PV6SE
-- use Unix EOL (created by mdbtools)
LOAD DATA INFILE '/usr/home/samba/maestro/csv/pig_al.csv'
INTO TABLE epd2.tbl_pig_al
CHARACTER SET ascii
FIELDS
