table('coupon_activity_join', array('id' => true, 'primary_key' => ['id'], 'engine' => 'InnoDB', 'comment' => '裂变活动用户发起表')) ->addColumn('coupon_activity_id', 'integer', array('limit' => 11, 'signed' => false, 'default' => 0, 'comment' => '裂变活动ID')) ->addColumn('user_id', 'integer',array('limit' => 10, 'default'=> 0,'comment'=>'发起人id')) ->addColumn('extend_num', 'integer',array('limit' => 10, 'signed' => false, 'default'=> 0,'comment'=>'推广达标人数')) ->addColumn('have_extend_num', 'integer',array('limit' => 10, 'signed' => false, 'default'=> 0,'comment'=>'已推广达标人数')) ->addColumn('extend_success', 'integer',array('limit' => 10, 'signed' => false, 'default'=> 0,'comment'=>'是否已达标 0 否 1 是')) ->addColumn('create_time', 'integer', array('limit' => 10,'signed' => false, 'default' => 0, 'comment' => '创建时间')) ->addColumn('update_time', 'integer', array('limit' => 10,'signed' => false, 'default' => 0, 'comment' => '更新时间')) ->addIndex(['user_id']) ->create(); } }