ALTER TABLE `shop` CHANGE `item` `item` VARCHAR(100) NOT NULL DEFAULT '', CHANGE `category` `category` VARCHAR(20) NULL DEFAULT 'misc', CHANGE `price` `price` INT(11) NULL DEFAULT '50', CHANGE `stock` `stock` INT(11) NULL DEFAULT '50', CHANGE `idx` `idx` INT(11) NULL DEFAULT '0', CHANGE `maxStock` `maxStock` INT(11) NULL DEFAULT '50', CHANGE `variation` `variation` INT(11) NULL DEFAULT '0', CHANGE `special` `special` INT(11) NULL DEFAULT '0', CHANGE `validated` `validated` TINYINT(1) NULL DEFAULT '1', CHANGE `units` `units` INT(11) NULL DEFAULT '1', CHANGE `quality` `quality` INT(11) NULL DEFAULT '3'