Laravel US migration and seed

gistfile1.txt

/**
 * Laravel US migration and seed.
 */
# command to create migration file
php artisan make:migration create_states_table

# migration file
<?php

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

class CreateStatesTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('states', function (Blueprint $table)
        {
            $table->increments('id');
            $table->string('name', 100)
                ->unique();
            $table->string('abbreviation', 2)
                ->unique();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::drop('states');
    }
}

# seed
DB::table('states')->insert(
[
    [
        'id'            => 1,
        'name'          => 'Alabama',
        'abbreviation'  => 'AL'
    ],
    [
        'id'            => 2,
        'name'          => 'Alaska',
        'abbreviation'  => 'AK'
    ],
    [
        'id'            => 3,
        'name'          => 'Arizona',
        'abbreviation'  => 'AZ'
    ],
    [
        'id'            => 4,
        'name'          => 'Arkansas',
        'abbreviation'  => 'AR'
    ],
    [
        'id'            => 5,
        'name'          => 'California',
        'abbreviation'  => 'CA'
    ],
    [
        'id'            => 6,
        'name'          => 'Colorado',
        'abbreviation'  => 'CO'
    ],
    [
        'id'            => 7,
        'name'          => 'Connecticut',
        'abbreviation'  => 'CT'
    ],
    [
        'id'            => 8,
        'name'          => 'Delaware',
        'abbreviation'  => 'DE'
    ],
    [
        'id'            => 9,
        'name'          => 'Florida',
        'abbreviation'  => 'FL'
    ],
    [
        'id'            => 10,
        'name'          => 'Georgia',
        'abbreviation'  => 'GA'
    ],
    [
        'id'            => 11,
        'name'          => 'Hawaii',
        'abbreviation'  => 'HI'
    ],
    [
        'id'            => 12,
        'name'          => 'Idaho',
        'abbreviation'  => 'ID'
    ],
    [
        'id'            => 13,
        'name'          => 'Illinois',
        'abbreviation'  => 'IL'
    ],
    [
        'id'            => 14,
        'name'          => 'Indiana',
        'abbreviation'  => 'IN'
    ],
    [
        'id'            => 15,
        'name'          => 'Iowa',
        'abbreviation'  => 'IA'
    ],
    [
        'id'            => 16,
        'name'          => 'Kansas',
        'abbreviation'  => 'KS'
    ],
    [
        'id'            => 17,
        'name'          => 'Kentucky',
        'abbreviation'  => 'KY'
    ],
    [
        'id'            => 18,
        'name'          => 'Louisiana',
        'abbreviation'  => 'LA'
    ],
    [
        'id'            => 19,
        'name'          => 'Maine',
        'abbreviation'  => 'ME'
    ],
    [
        'id'            => 20,
        'name'          => 'Maryland',
        'abbreviation'  => 'MD'
    ],
    [
        'id'            => 21,
        'name'          => 'Massachusetts',
        'abbreviation'  => 'MA'
    ],
    [
        'id'            => 22,
        'name'          => 'Michigan',
        'abbreviation'  => 'MI'
    ],
    [
        'id'            => 23,
        'name'          => 'Minnesota',
        'abbreviation'  => 'MN'
    ],
    [
        'id'            => 24,
        'name'          => 'Mississippi',
        'abbreviation'  => 'MS'
    ],
    [
        'id'            => 25,
        'name'          => 'Missouri',
        'abbreviation'  => 'MO'
    ],
    [
        'id'            => 26,
        'name'          => 'Montana',
        'abbreviation'  => 'MT'
    ],
    [
        'id'            => 27,
        'name'          => 'Nebraska',
        'abbreviation'  => 'NE'
    ],
    [
        'id'            => 28,
        'name'          => 'Nevada',
        'abbreviation'  => 'NV'
    ],
    [
        'id'            => 29,
        'name'          => 'New Hampshire',
        'abbreviation'  => 'NH'
    ],
    [
        'id'            => 30,
        'name'          => 'New Jersey',
        'abbreviation'  => 'NJ'
    ],
    [
        'id'            => 31,
        'name'          => 'New Mexico',
        'abbreviation'  => 'NM'
    ],
    [
        'id'            => 32,
        'name'          => 'New York',
        'abbreviation'  => 'NY'
    ],
    [
        'id'            => 33,
        'name'          => 'North Carolina',
        'abbreviation'  => 'NC'
    ],
    [
        'id'            => 34,
        'name'          => 'North Dakota',
        'abbreviation'  => 'ND'
    ],
    [
        'id'            => 35,
        'name'          => 'Ohio',
        'abbreviation'  => 'OH'
    ],
    [
        'id'            => 36,
        'name'          => 'Oklahoma',
        'abbreviation'  => 'OK'
    ],
    [
        'id'            => 37,
        'name'          => 'Oregon',
        'abbreviation'  => 'OR'
    ],
    [
        'id'            => 38,
        'name'          => 'Pennsylvania',
        'abbreviation'  => 'PA'
    ],
    [
        'id'            => 39,
        'name'          => 'Rhode Island',
        'abbreviation'  => 'RI'
    ],
    [
        'id'            => 40,
        'name'          => 'South Carolina',
        'abbreviation'  => 'SC'
    ],
    [
        'id'            => 41,
        'name'          => 'South Dakota',
        'abbreviation'  => 'SD'
    ],
    [
        'id'            => 42,
        'name'          => 'Tennesse',
        'abbreviation'  => 'TN'
    ],
    [
        'id'            => 43,
        'name'          => 'Texas',
        'abbreviation'  => 'TX'
    ],
    [
        'id'            => 44,
        'name'          => 'Utah',
        'abbreviation'  => 'UT'
    ],
    [
        'id'            => 45,
        'name'          => 'Vermont',
        'abbreviation'  => 'VT'
    ],
    [
        'id'            => 46,
        'name'          => 'Virginia',
        'abbreviation'  => 'VA'
    ],
    [
        'id'            => 47,
        'name'          => 'Washington',
        'abbreviation'  => 'WA'
    ],
    [
        'id'            => 48,
        'name'          => 'West Virignia',
        'abbreviation'  => 'WV'
    ],
    [
        'id'            => 49,
        'name'          => 'Wisconsin',
        'abbreviation'  => 'WI'
    ],
    [
        'id'            => 50,
        'name'          => 'Wyoming',
        'abbreviation'  => 'WY'
    ],
    [
        'id'            => 51,
        'name'          => 'District of Columbia',
        'abbreviation'  => 'DC'
    ]
]
);