Updated SWITCH to use CHAR(15)
Consolidate item types with data types and mysql types for store/query