table('shop_goods_sku', array('id' => true, 'primary_key' => ['id'], 'engine' => 'InnoDB', 'comment' => '门店自提商品SKU表')); $table->addColumn('shop_id', 'integer', array('limit' => 11, 'signed' => false, 'default' => 0, 'comment' => '门店id')) ->addColumn('shop_goods_id', 'integer', array('limit' => 11, 'signed' => false, 'default' => 0, 'comment' => '门店商品id')) ->addColumn('goods_sku_id', 'string', array('limit' => 255, 'default' => '', 'comment' => '商品sku唯一标识 (由规格id组成)')) ->addColumn('goods_id', 'integer', array('limit' => 11, 'signed' => false, 'default' => 0, 'comment' => '商品id')) ->addColumn('stock_num', 'integer', array('limit' => 11, 'signed' => false, 'default' => 0, 'comment' => '当前库存数量')) ->addColumn('alarm_stock_num', 'integer', array('limit' => 11, 'signed' => false, 'default' => 0, 'comment' => '库存预警值')) ->addColumn('create_time', 'datetime', array('null' => true, 'comment' => '创建时间')) ->addColumn('update_time', 'datetime', array('null' => true, 'comment' => '更新时间')) ->create(); } }