<?php
namespace Datacake\Core\Migration;
use Datacake\Core\Models\IspCity;
use Datacake\Core\Includes\DatacakeCoreActivator;

global $wpdb;

// Had to change the name
// Creating City Table
$CityEntity = new IspCity();
$cityTableName = $CityEntity->getTable();
$sql = "ALTER TABLE  `$cityTableName` 
    ADD `is_neighborhood` varchar(255) DEFAULT NULL AFTER `short_name`,
    ADD `neighborhood_name` varchar(255) DEFAULT NULL AFTER `is_neighborhood`;";
if($wpdb->query($sql)){
    // Adding Foreing key contrains
    update_option(DatacakeCoreActivator::$config_name,'1.1.2');
}