20170728074757_create_geo_cache_table.php

Go to the documentation of this file.

<?php

use Phinx\Migration\AbstractMigration;
use Phinx\Db\Adapter\MysqlAdapter;

class CreateGeoCacheTable extends AbstractMigration {
    public function change() {

        if ($this->hasTable("geocode_cache")) {
            return;
        }

        $table = $this->table("geocode_cache", [
            'engine' => "MEMORY",
            'encoding' => "utf8mb4",
            'collation' => "utf8mb4_general_ci",
        ]);

        $table->addColumn('location', 'string', [
            'null' => true,
            'limit' => 128,
        ]);

        $table->addColumn('lat', 'string', [
            'null' => true,
            'limit' => 20,
        ]);

        $table->addColumn('long', 'string', [
            'null' => true,
            'limit' => 20,
        ]);

        $table->addIndex(['location'], [
            'name' => "location",
            'unique' => true
        ]);

        $table->save();

    }
}