Create New Item
Item Type
File
Folder
Item Name
Search file in folder and subfolders...
Are you sure want to rename?
gilour
/
database
/
migrations
:
2015_05_18_041236_create_country_table.php
Advanced Search
Upload
New Item
Settings
Back
Back Up
Advanced Editor
Save
<?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; class CreateCountryTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { DB::statement('CREATE TABLE IF NOT EXISTS `countries` ( `id_countries` int(3) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(200) DEFAULT NULL, `iso_alpha2` varchar(2) DEFAULT NULL, `iso_alpha3` varchar(3) DEFAULT NULL, `iso_numeric` int(11) DEFAULT NULL, `currency_code` char(3) DEFAULT NULL, `currency_name` varchar(32) DEFAULT NULL, `currency_symbol` varchar(3) DEFAULT NULL, `flag` varchar(6) DEFAULT NULL, PRIMARY KEY (`id_countries`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=240'); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('countries'); } }