table('shop_goods', array('id' => true, 'primary_key' => ['id'], 'engine' => 'InnoDB', 'comment' => '门店自提商品表')); $table->addColumn('shop_id', 'integer', array('limit' => 11, 'signed' => false, 'default' => 0, 'comment' => '门店id')) ->addColumn('goods_id', 'integer', array('limit' => 11, 'signed' => false, 'default' => 0, 'comment' => '商品id')) ->addColumn('stock_total', 'integer', array('limit' => 11, 'signed' => false, 'default' => 0, 'comment' => '库存总量(包含所有sku)')) ->addColumn('alarm_stock_total', 'integer', array('limit' => 11, 'signed' => false, 'default' => 0, 'comment' => '库存预警值(包含所有sku)')) ->addColumn('sale_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(); } }