CreateMasterCitiesTable::up()

Complexity

Conditions	1
Paths	1

Size

Total Lines	16
Code Lines	12

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	1

<?php
    public function up()
    {
        Schema::create('tm_cities', function (Blueprint $table) {
            $table->bigIncrements('id');
            $table->string('name');
            $table->string('postal_code')->nullable();
            $table->string('latitude')->nullable();
            $table->string('longitude')->nullable();
            $table->unsignedBigInteger('state_id');
            $table->timestamps();
        });

        Schema::table('tm_cities', function (Blueprint $table) {
            $table->foreign('state_id')
                ->references('id')->on('tm_states')
                ->onDelete('cascade');
        });