table('real_rice_card_list', array('id' => true, 'primary_key' => ['id'], 'engine' => 'InnoDB', 'comment' => '米卡生成兑换码表')); $table->addColumn('gen_real_rice_card_id', 'integer', array('limit' => 11, 'signed' => false, 'default' => 0, 'comment' => '生成实体米卡记录id')) ->addColumn('rice_card_id', 'integer', array('limit' => 11, 'signed' => false, 'default' => 0, 'comment' => '米卡id')) ->addColumn('card_number', 'integer', array('limit' => 10, 'signed' => false, 'default' => 0, 'comment' => '卡号')) ->addColumn('redeem_code', 'string',array('limit' => 36,'default'=>'','comment'=>'激活码')) ->addColumn('been_exported', 'integer',array('limit' => 2,'signed'=>false,'default'=>0,'comment'=>'已导出0未导出,1已导')) ->addColumn('been_active', 'integer',array('limit' => 2,'signed'=>false,'default'=>0,'comment'=>'是否激活0未激活,1已激活')) ->addColumn('active_time', 'integer', array('limit' => 10,'signed' => false, 'default' => 0, 'comment' => '激活时间')) ->addColumn('frozen_status', 'integer',array('limit' => 2,'signed'=>false,'default'=>0,'comment'=>'冻结状态0未冻,1已冻')) ->addColumn('is_delete', 'integer',array('limit' => 3,'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(array('redeem_code'), array('unique' => true)) ->addIndex(array('card_number'), array('unique' => true)) ->create(); } }