The two primary ways developers create their database scheme is either by building migrations first or building out their database structure in a tool like Sequel Pro first, then once they are happy, create the migrations.
If you are in the second camp and use Sequel Pro, Colin Viebrock created a Laravel Migration exporter tool that hooks right into the app.
It works by cloning or downloading the package and then installing by double clicking on the included “ExportToLaravelMigration.spBundle” file.
Next, connect to a database, and select a table in the left-hand column. From the application menu, choose Bundles › Export › Export to Laravel Migration, or use the keyboard shortcut ⌃⌥⌘M
(CTRL + OPTION + CMD + M).
Here is an example of a migration it created for a category table:
1<?php 2 3use Illuminate\Support\Facades\Schema; 4use Illuminate\Database\Schema\Blueprint; 5use Illuminate\Database\Migrations\Migration; 6 7/** 8 * Migration auto-generated by Sequel Pro Laravel Export 9 * @see https://github.com/cviebrock/sequel-pro-laravel-export10 */11class CreateCategoriesTable extends Migration12{13 /**14 * Run the migrations.15 *16 * @return void17 */18 public function up()19 {20 Schema::create('categories', function (Blueprint $table) {21 $table->increments('id');22 $table->integer('wp_id');23 $table->string('name', 255);24 $table->string('slug', 255);25 $table->text('description');26 $table->nullableTimestamps();2728 $table->unique('slug', 'categories_slug_unique');29 });30 }3132 /**33 * Reverse the migrations.34 *35 * @return void36 */37 public function down()38 {39 Schema::dropIfExists('categories');40 }41}
The migration file will then be saved to your desktop, and you can move it to your projects migrations directory, so it’s ready to be used through the Artisan command.
Filed in: