ALTER TABLE `catalogue_items` CHANGE `typeid` `typeid` INT( 1 ) NOT NULL DEFAULT '0', 
CHANGE `length` `length` INT( 2 ) NOT NULL DEFAULT '0', 
CHANGE `width` `width` INT( 2 ) NOT NULL DEFAULT '0', 
CHANGE `door` `door` ENUM( '0', '1' ) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '0', 
CHANGE `tradeable` `tradeable` ENUM( '0', '1' ) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '0', 
CHANGE `recycleable` `recycleable` ENUM( '0', '1' ) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '0'