/** * Run the migrations. * * @return void */ public function up() { Schema::create('destiny_data', function (Blueprint $table) { $table->increments('id'); $table->integer('account_id', false, true); $table->string('membershipId', 64)->unique(); $table->string('clanName', 32)->nullable(); $table->string('clanTag', 6)->nullable(); $table->mediumInteger('glimmer', false, true); $table->mediumInteger('grimoire', false, true); $table->mediumInteger('legendary_marks', false, true); $table->string('character_1', 32)->nullable(); $table->string('character_2', 32)->nullable(); $table->string('character_3', 32)->nullable(); $table->tinyInteger('inactiveCounter', false, true); $table->timestamps(); }); \Onyx\Account::chunk(100, function ($accounts) { foreach ($accounts as $account) { $data = new \Onyx\Destiny\Objects\Data($account->toArray()); $data->account_id = $account->id; $data->save(); } }); }
/** * Run the migrations. * * @return void */ public function up() { Schema::table('accounts', function (Blueprint $table) { $table->string('destiny_membershipId', 64); $table->dropIndex('accounts_id_index'); $table->index('destiny_membershipId'); }); \Onyx\Account::chunk(100, function ($accounts) { foreach ($accounts as $account) { $data = \Onyx\Destiny\Objects\Data::where('account_id', $account->id)->first(); $account->destiny_membershipId = $data->membershipId; $account->save(); } }); }