PATH:
home
/
lab2454c
/
costbloc.com
/
Modules
/
GeoLocale
/
Database
/
Migrations
<?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; class CreateGeoLocaleDivisionsTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('geolocale_divisions', function(Blueprint $table) { $table->bigIncrements('id')->comment('Auto Increase ID'); $table->bigInteger('country_id')->unsigned()->comment('Country ID'); $table->string('name', 191)->default('')->comment('Division Common Name'); $table->string('full_name', 191)->nullable()->comment('Division Full Name'); $table->string('code', 64)->nullable()->comment('ISO 3166-2 Code'); $table->boolean('has_city')->default(0)->comment('Has city?'); $table->unique(['country_id','name'], 'uniq_division'); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('geolocale_divisions'); } }
[-] 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]