创建商品基础表

CREATE TABLE `goods_baseX` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘数据标识ID‘,
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘数据创建时间‘,
  `modify_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT ‘数据修改时间‘,
  `is_deleted` tinyint(1) NOT NULL DEFAULT ‘0‘ COMMENT ‘数据是否删除‘,
  `remark` varchar(255) NOT NULL DEFAULT ‘‘ COMMENT ‘备注‘,
  `purchase_man` varchar(20) NOT NULL DEFAULT ‘‘ COMMENT ‘采购负责人‘,
  `sort` varchar(255) NOT NULL DEFAULT ‘‘ COMMENT ‘分类‘,
  `mb_code` varchar(64) NOT NULL DEFAULT ‘‘ COMMENT ‘妈宝编码‘,
    `yz_code` varchar(64) NOT NULL DEFAULT ‘‘ COMMENT ‘有赞编码‘,
    `hc_code` varchar(64) NOT NULL DEFAULT ‘‘ COMMENT ‘华创编码‘,
    `goods_name` varchar(255) NOT NULL DEFAULT ‘‘ COMMENT ‘外部商品名称‘,
    `brand` varchar(20) NOT NULL DEFAULT ‘‘ COMMENT ‘品牌‘,
  `supplier` varchar(64) NOT NULL DEFAULT ‘‘ COMMENT ‘供应商‘,
  `specification    ` varchar(20) NOT NULL DEFAULT ‘‘ COMMENT ‘规格‘ ,  
    `shipping methods` varchar(20) NOT NULL DEFAULT ‘‘ COMMENT ‘物流方式‘,
    `purchase_price` decimal(18,2) NOT NULL COMMENT ‘采购进价‘,
    `delivery_price` decimal(18,2) NOT NULL COMMENT ‘配送价‘,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=15120 DEFAULT CHARSET=utf8mb4;