ALTER TABLE `memShop` CHANGE `item` `item` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, CHANGE `code` `code` VARCHAR(10) NULL DEFAULT '', CHANGE `category` `category` VARCHAR(20) NULL DEFAULT '', 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 `units` `units` INT(11) NULL DEFAULT '1', CHANGE `quality` `quality` INT(11) NULL DEFAULT '0'