<?php

use Illuminate\Database\Seeder;

class NetworkTableSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        $country_id = DB::table('countries')->where('name', 'ghana')->first()->id;
        DB::table('networks')->insert([
            'full_name' => 'Scancom Ltd',
            'nice_name' => 'MTN',
            'code' => '0.0425',
            'country_id' => $country_id,
            'sms_price' => '0.032',
            'prefix' => '23324, 23354, 23355',
        ]);
        DB::table('networks')->insert([
            'full_name' => 'Mobitel',
            'nice_name' => 'Tigo',
            'code' => '0.0025',
            'country_id' => $country_id,
            'sms_price' => '0.032',
            'prefix' => '23327, 23357',
        ]);
        DB::table('networks')->insert([
            'full_name' => 'Ghana Telecom',
            'nice_name' => 'Vodafone',
            'code' => '0.0340',
            'country_id' => $country_id,
            'sms_price' => '0.032',
            'prefix' => '23320, 23350',
        ]);
        DB::table('networks')->insert([
            'full_name' => 'Zain',
            'nice_name' => 'Airtel',
            'code' => '0.0390',
            'country_id' => $country_id,
            'sms_price' => '0.032',
            'prefix' => '23326',
        ]);
        DB::table('networks')->insert([
            'full_name' => 'Glo Mobile',
            'nice_name' => 'Glo',
            'code' => '0.0025',
            'country_id' => $country_id,
            'sms_price' => '0.032',
            'prefix' => '23323',
        ]);
        DB::table('networks')->insert([
            'full_name' => 'Kasapa Telecom Ltd',
            'nice_name' => 'Espresso',
            'code' => '0.0060',
            'country_id' => $country_id,
            'sms_price' => '0.032',
            'prefix' => '23328',
        ]);
    }
}