text: CREATE TABLE `pms_sku_stock` (
    `id` bigint(20) unsigned NOT NULL,
    `app_id` bigint(20) unsigned NULL DEFAULT NULL ,
    `product_id` bigint(20) DEFAULT NULL,
    `sku_code` varchar(64) NOT NULL COMMENT 'sku编码',
    `price` decimal(10,2) DEFAULT NULL,
    `stock` int(11) DEFAULT '0' COMMENT '库存',
    `low_stock` int(11) DEFAULT NULL COMMENT '预警库存',
    `pic` varchar(255) DEFAULT NULL COMMENT '展示图片',
    `sale` int(11) DEFAULT NULL COMMENT '销量',
    `promotion_price` decimal(10,2) DEFAULT NULL COMMENT '单品促销价格',
    `lock_stock` int(11) DEFAULT '0' COMMENT '锁定库存',
    `sp_data` varchar(500) DEFAULT NULL COMMENT '商品销售属性，json格式',
    `create_by` bigint(20) DEFAULT NULL,
    `update_by` bigint(20) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=190 DEFAULT CHARSET=utf8 COMMENT='sku的库存';
  