数据库：ucs
表名：trusted_goods
sql:
ALTER TABLE `trusted_goods` ADD `tmp_goods_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '商品名 - 备份' AFTER `goods_name`;
ALTER TABLE `trusted_goods` ADD `tmp_goods_img` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '商品封面图 = 备份' AFTER `goods_img`;
ALTER TABLE `trusted_goods` ADD `tmp_goods_p_cate` INT(10) null COMMENT '商品一级分类编号 - 备份' AFTER `goods_p_cate`;
ALTER TABLE `trusted_goods` ADD `tmp_goods_c_cate` int(10) null COMMENT '商品二级分类编号 - 备份' AFTER `goods_c_cate`;
ALTER TABLE `trusted_goods` ADD `tmp_goods_num` VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '商品数量 - 备份' AFTER `goods_num`;
ALTER TABLE `trusted_goods` ADD `tmp_goods_price` VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '商品价格 - 备份' AFTER `goods_price`;
ALTER TABLE `trusted_goods` ADD `tmp_goods_detail` text COMMENT '商品介绍 - 备份' AFTER `goods_detail`;
ALTER TABLE `trusted_goods` ADD `tmp_send_date` varchar(20) null COMMENT '发货期限 - 备份' AFTER `send_date`;
ALTER TABLE `trusted_goods` ADD `tmp_order_num` varchar(20) null COMMENT '起订量 - 备份' AFTER `order_num`;
ALTER TABLE `trusted_goods` ADD `tmp_status` tinyint(1) null COMMENT '状态 - 备份 ：1待审，2审核通过，3不通过' AFTER `status`;
ALTER TABLE `trusted_goods` CHANGE `goods_num` `goods_num` VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ' ' COMMENT '商品数量';
ALTER TABLE `trusted_goods` CHANGE `goods_price` `goods_price` VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品价格';
ALTER TABLE `trusted_goods` ADD `goods_flag` VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ' ' COMMENT '供应量的单位' AFTER `tmp_goods_num`;
ALTER TABLE `trusted_goods` ADD `tmp_goods_flag` VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备份-供应量（商品数量）的单位' AFTER `goods_flag`;
ALTER TABLE `trusted_goods` CHANGE `send_date` `send_date` VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '发货期限（用var类型的原因：原型上该字段填的面议）';
ALTER TABLE `trusted_goods` CHANGE `order_num` `order_num` VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '起订量（用var类型的原因：原型上该字段填的200套,描述单位不确定）';
