ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / lab2454c / costbloc.com / Modules / GeoLocale / Database / Migrations

<?php

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

class CreateGeoLocaleCountriesTable extends Migration {

/**
	 * Run the migrations.
	 *
	 * @return void
	 */
	public function up()
	{
		Schema::create('geolocale_countries', function(Blueprint $table)
		{
			$table->bigIncrements('id')->comment('Auto increase ID');
			$table->bigInteger('continent_id')->unsigned()->comment('Continent ID');
			$table->string('name', 191)->default('')->comment('Country Common Name');
			$table->string('full_name', 191)->nullable()->comment('Country Fullname');
			$table->string('capital', 191)->nullable()->comment('Capital Common Name');
			$table->string('code', 4)->nullable()->comment('ISO3166-1-Alpha-2');
			$table->string('code_alpha3', 6)->nullable()->comment('ISO3166-1-Alpha-3');
			$table->string('emoji', 16)->nullable()->comment('Country Emoji');
			$table->boolean('has_division')->default(0)->comment('Has Division');
			$table->string('currency_code', 3)->nullable()->comment('iso_4217_code');
			$table->string('currency_name', 128)->nullable()->comment('iso_4217_name');
			$table->string('currency_symbol')->nullable();
			$table->string('tld', 8)->nullable()->comment('Top level domain');
			$table->string('callingcode', 8)->nullable()->comment('Calling prefix');
			$table->unique(['continent_id','name'], 'uniq_country');
		});
	}

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

}

[-] 2017_04_08_163453_create_geolocale_countries_locale_table.php [edit]
[-] 2017_04_08_163453_create_geolocale_cities_locale_table.php [edit]
[-] 2017_04_08_163453_create_geolocale_cities_table.php [edit]
[+] ..
[-] 2017_04_08_163453_create_geolocale_countries_table.php [edit]
[-] 2017_04_08_163453_create_geolocale_continents_locale_table.php [edit]
[-] 2017_04_08_163453_create_geolocale_divisions_table.php [edit]
[-] 2017_04_08_163454_add_foreign_keys_to_geolocale_divisions_table.php [edit]
[-] 2017_04_08_163454_add_foreign_keys_to_geolocale_countries_locale_table.php [edit]
[-] 2017_04_08_163454_add_foreign_keys_to_geolocale_continents_locale_table.php [edit]
[-] 2021_07_22_221136_add_code_numeric_to_geolocale_countries.php [edit]
[-] 2021_07_22_172545_add_timezone_to_geolocale_cities_table.php [edit]
[-] 2017_04_08_163454_add_foreign_keys_to_geolocale_cities_table.php [edit]
[-] 2017_04_08_163453_create_geolocale_divisions_locale_table.php [edit]
[-] 2019_12_23_153024_create_geolocale_languages_table.php [edit]
[-] 2017_04_08_163454_add_foreign_keys_to_geolocale_divisions_locale_table.php [edit]
[-] 2017_04_08_163454_add_foreign_keys_to_geolocale_cities_locale_table.php [edit]
[-] 2017_04_08_163454_add_foreign_keys_to_geolocale_countries_table.php [edit]
[-] 2017_04_08_163453_create_geolocale_continents_table.php [edit]