LaraGeoData\Database\MigrationHelper::geonamesDefaultColumns()

Complexity

Conditions	1
Paths	1

Size

Total Lines	23
Code Lines	20

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	21
CRAP Score	1

Importance

Changes	1
Bugs	0	Features	0

<?php
    public static function geonamesDefaultColumns(Blueprint $table): void
    {
        $table->unsignedInteger('id');
        $table->string('name', 200)->nullable()->index();
        $table->string('ascii_name', 200)->nullable()->index();
        $table->text('alternate_names')->nullable();
        $table->decimal('lat', 10, 7)->nullable()->index();
        $table->decimal('lng', 10, 7)->nullable()->index();
        $table->char('fclass', 1)->nullable()->index();
        $table->string('fcode', 10)->nullable()->index();
        $table->string('country', 2)->nullable()->index();
        $table->string('cc2', 200)->nullable()->index();
        $table->string('admin1', 20)->nullable()->index();
        $table->string('admin2', 80)->nullable()->index();
        $table->string('admin3', 20)->nullable()->index();
        $table->string('admin4', 20)->nullable()->index();
        $table->unsignedInteger('population')->nullable()->index();
        $table->integer('elevation')->nullable()->index();
        $table->integer('gtopo30')->nullable()->index();
        $table->string('timezone', 40)->nullable()->index();
        $table->dateTime('moddate', 40)->nullable()->index();

        $table->primary('geonameid');
    }