...
mysql> describe itemData;
+------------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------+-------------+------+-----+---------+-------+
| analyticPosition | int(11) | YES | | NULL | |
| circNote | mediumtext | YES | | NULL | |
| publicNote | mediumtext | YES | | NULL | |
| staffNote | mediumtext | YES | | NULL | |
| itemCat1 | varchar(10) | YES | | NULL | |
| itemCat2 | varchar(10) | YES | | NULL | |
| barcode | varchar(16) | NO | PRI | NULL | |
+------------------+-------------+------+-----+---------+-------+
The next step will be to write loadMARCrecords.pl and loadItemData.pl...