<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateNetworksTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::dropIfExists('networks');
        Schema::create('networks', function (Blueprint $table) {
            $table->id();
            $table->string('prefix', 100)->nullable(false)->default('02');
            $table->string('name', 100)->nullable(false)->default('Network');
            $table->double('setup', 15, 8)->nullable(false)->default(0.0);
            $table->double('minute', 15, 8)->nullable(false)->default(0.0);
            $table->double('tax', 15, 8)->nullable(false)->default(0.0);
            $table->timestamps();
        });

        $insertions             = [
            [
                'prefix'        => '010',
                'name'          => 'Vodafone',
                'setup'         => 0.1,
                'minute'        => 0.3,
                'tax'           => 14,
            ],
            [
                'prefix'        => '012',
                'name'          => 'Orange',
                'setup'         => 0.1,
                'minute'        => 0.3,
                'tax'           => 14,
            ],
            [
                'prefix'        => '011',
                'name'          => 'Etisalat',
                'setup'         => 0.1,
                'minute'        => 0.3,
                'tax'           => 14,
            ],
            [
                'prefix'        => '015',
                'name'          => 'WE',
                'setup'         => 0.1,
                'minute'        => 0.3,
                'tax'           => 14,
            ],
            [
                'prefix'        => '02',
                'name'          => 'We Landline',
                'setup'         => 0.1,
                'minute'        => 0.3,
                'tax'           => 23.17,
            ],
            [
                'prefix'        => '03',
                'name'          => 'We Landline',
                'setup'         => 0.1,
                'minute'        => 0.3,
                'tax'           => 23.17,
            ],
            [
                'prefix'        => '04',
                'name'          => 'We Landline',
                'setup'         => 0.1,
                'minute'        => 0.3,
                'tax'           => 23.17,
            ],
            [
                'prefix'        => '05',
                'name'          => 'We Landline',
                'setup'         => 0.1,
                'minute'        => 0.3,
                'tax'           => 23.17,
            ],
            [
                'prefix'        => '06',
                'name'          => 'We Landline',
                'setup'         => 0.1,
                'minute'        => 0.3,
                'tax'           => 23.17,
            ],
            [
                'prefix'        => '07',
                'name'          => 'We Landline',
                'setup'         => 0.1,
                'minute'        => 0.3,
                'tax'           => 23.17,
            ],
            [
                'prefix'        => '08',
                'name'          => 'We Landline',
                'setup'         => 0.1,
                'minute'        => 0.3,
                'tax'           => 23.17,
            ],
            [
                'prefix'        => '09',
                'name'          => 'We Landline',
                'setup'         => 0.1,
                'minute'        => 0.3,
                'tax'           => 23.17,
            ],
            [
                'prefix'        => '15',
                'name'          => 'Hotline',
                'setup'         => 0.1,
                'minute'        => 0.3,
                'tax'           => 23.17,
            ],
            [
                'prefix'        => '16',
                'name'          => 'Hotline',
                'setup'         => 0.1,
                'minute'        => 0.3,
                'tax'           => 23.17,
            ],
            [
                'prefix'        => '19',
                'name'          => 'Hotline',
                'setup'         => 0.1,
                'minute'        => 0.3,
                'tax'           => 23.17,
            ],
 
        ];
        \DB::table('networks')->insert($insertions);
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        
    }
}