<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Support\Facades\DB;

class FixClaims extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        DB::statement("UPDATE user_claims LEFT JOIN clicks on clicks.id = user_claims.click_id LEFT JOIN users on users.user_id = clicks.user_id
SET user_claims.user_id      = clicks.user_id,
    user_claims.currency_iso = users.currency_code,
    user_claims.store_id     = clicks.store_id,
    user_claims.network_id     = clicks.network_id
WHERE user_claims.user_id is null or user_claims.currency_iso is null or user_claims.store_id is null or user_claims.network_id is null");
        DB::statement("ALTER TABLE user_claims modify user_id int not null,
                                                    modify store_id bigint unsigned not null,
                                                    modify network_id int not null,
                                                    modify currency_iso char(3) not null");
    }
}