.mode insert invTypes
.schema invTypes
select typeID,typeName from invTypes where published = 1;