I'm currently running Workbench 8.0.13, and on the readme.md file it says:

Open a model in MySQL Workbench Tools > Catalog > Export Laravel 5 Migration

But this option is no longer under tools in the latest version of Workbench.

I've installed the plugin (and it shows as enabled in Scripting -> Plugin Manager), but there is no Catalog menu option under Tools.

I've restarted Workbench several times, and rebooted my computer.

Linux Ubuntu 14.04 and Workbench 6.2

Hi, I'm using Laragon for local development, which is shipped with MariaDB instead of MySQL. MySQL Benchmark is warning me about "incompatible/nonstandard server version or connection protocol detected" (see attachments), but I want to try anyway. The connection is successful and I can install the plugin, but I don't see the "Catalog" submenu under "Tools"... Is this a MySQL Benchmark issue or a plugin one? Can this be fixed somehow? Thank you :-)

I have just installed the plugin into MySQL WorkBench 6.3 ce and when I try do an export it will export the objects but the filenames will not be match the object inside the file. So TableA's migration will be called 2017_11_30_000012_create_TableB_table.php and TableC's migration might be called 2017_11_30_000012_create_TableF_table.php

Hi there. Performing the export laravel 5 migration brings up the export dialog and shows me the review of what it's going to create, but I only get what I've attached in the screenshot. I don't get any options for where to save the generated migration scripts and it also never saves anything.

Additionally, none of the foreign keys and references, nor indexes, are being included in the generated scripts

Hello,

thank you once again for a terrific package!!

Is it possible to create the laravel 8 version of this plugin with namespaces? Or can i add it manually?

Using MySQL Workbench latest (6.3.9) on Windows 10 and the latest version of the script on master the generated migrations do not contain any column definitions.

With the MWB file linked here: https://dl.dropboxusercontent.com/u/12420042/test.mwb (which is just a simple test with a single table with a PK and varchar field) the resulting migration is:

<?php

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

class CreateTracksTable extends Migration
{
    /**
     * Run the migrations.
     * @table tracks
     *
     * @return void
     */
    public function up()
    {
        Schema::create('tracks', function (Blueprint $table) {
            $table->engine = 'InnoDB';
        });
    }

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

I thought that maybe the MWB application version was too new so tried downgrading from 6.3.8 progressively to 6.3.5 but the migration generated was the same in each version. So either there's a bug or I'm missing something obvious on my end.

Hey, I tested the plugin for my model and I came across a problem. When I try export my migrations the program is not responding and RAM consumption is growing very rapidly in time. Unfortunately, the application log is empty and the application even after a long time does not turn off. Can I provide some additional information to help solve the problem? Here is my model: database_model.zip

Hi, I just installed the plugin (seemed to install cleanly!), and I'm getting the following error

Error during "Export Laravel 5 Migration" error calling Python module function GenerateLaravel5Migration.generateLaravel5Migration

I've done some digging but can't find any info on what may be causing this - not sure if it's an problem on the plugin side, mysql workbench side, or other. Any hints on this? (note: I'm not very familiar with mysql workbench...)

Thanks!

Don't ask me why but for some reason the following did not work even though the col had a name attribute: if hasattr(col, 'name'): continue So i switched it out for a try catch, which will catch the error if there is no name attribute.

I had the issue that the indices are not generated at all, neither for MyISAM, nor InnoDB tables.

The indices are generated correctly now, at least for MyISAM tables. The issue still exists for InnoDB tables, because no columns are assigned to the index.

Does anyone know how to solve this?

C:\Users\xxxx\AppData\Roaming\MySQL\Workbench\log

shows

10:05:09 [ERR][      Workbench]: Console redirection failed.
10:05:09 [INF][      Workbench]: Starting up Workbench
10:05:09 [INF][      Workbench]: Current environment:
	Command line: "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\MySQLWorkbench.exe" 
	CurrentDirectory: C:\Program Files\MySQL\MySQL Workbench 8.0 CE
	HasShutdownStarted: False
	OSVersion: Microsoft Windows NT 6.2.9200.0
	SystemDirectory: C:\Windows\system32
	TickCount: 29625
	UserInteractive: True
	Version: 4.0.30319.42000
	WorkingSet: 41918464
10:05:09 [INF][      Workbench]: Environment variables:
	OneDriveConsumer = C:\Users\xxxx\OneDrive
	ProgramFiles(x86) = C:\Program Files (x86)
	ProgramW6432 = C:\Program Files
	ChocolateyInstall = C:\ProgramData\chocolatey
	PROCESSOR_IDENTIFIER = Intel64 Family 6 Model 60 Stepping 3, GenuineIntel
	TMP = C:\Users\xxxx\AppData\Local\Temp
	PROCESSOR_ARCHITECTURE = AMD64
	Path = C:\Python39\Scripts\;C:\Python39\;C:\Program Files\Common Files\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Program Files (x86)\PuTTY\;C:\ProgramData\chocolatey\bin;C:\Program Files\Git\cmd;C:\php-7.4.14-nts-Win32-vc15-x64;C:\ProgramData\ComposerSetup\bin;C:\Program Files\nodejs\;C:\Users\xxxx\AppData\Roaming\MySQL\Workbench\modules;C:\Users\xxxx\AppData\Local\Microsoft\WindowsApps;C:\Users\xxxx\AppData\Local\Programs\Microsoft VS Code\bin;C:\Program Files\heroku\bin;C:\apache-maven-3.6.3\bin;C:\Users\xxxx\AppData\Roaming\Composer\vendor\bin;C:\php-7.4.14-nts-Win32-vc15-x64;D:\xampp\mysql\bin;C:\Users\xxxx\AppData\Roaming\npm;C:\Users\xxxx\AppData\Roaming\MySQL\Workbench\modules;
	USERPROFILE = C:\Users\xxxx
	PROCESSOR_REVISION = 3c03
	TEMP = C:\Users\xxxx\AppData\Local\Temp
	FPS_BROWSER_APP_PROFILE_STRING = Internet Explorer
	FPS_BROWSER_USER_PROFILE_STRING = Default
	LOGONSERVER = \\DESKTOP-28IRB1E
	USERNAME = xxxx
	SystemRoot = C:\Windows
	OneDrive = C:\Users\xxxx\OneDrive
	CommonProgramFiles = C:\Program Files\Common Files
	ProgramData = C:\ProgramData
	HOMEPATH = \Users\xxxx
	COMPUTERNAME = DESKTOP-28IRB1E
	CommonProgramFiles(x86) = C:\Program Files (x86)\Common Files
	ALLUSERSPROFILE = C:\ProgramData
	CommonProgramW6432 = C:\Program Files\Common Files
	MAVEN_HOME = C:\Apache_Maven\apache-maven-3.6.3
	SESSIONNAME = Console
	DriverData = C:\Windows\System32\Drivers\DriverData
	HOMEDRIVE = C:
	windir = C:\Windows
	SystemDrive = C:
	NUMBER_OF_PROCESSORS = 8
	OS = Windows_NT
	ProgramFiles = C:\Program Files
	ComSpec = C:\Windows\system32\cmd.exe
	M2_HOME = C:\Apache_Maven\apache-maven-3.6.3
	PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC;.PY;.PYW
	JAVA_HOME = c:\Progra~1\Java\jdk-15.0.1
	PSModulePath = C:\Program Files\WindowsPowerShell\Modules;C:\Windows\system32\WindowsPowerShell\v1.0\Modules
	APPDATA = C:\Users\xxxx\AppData\Roaming
	USERDOMAIN = DESKTOP-28IRB1E
	PROCESSOR_LEVEL = 6
	LOCALAPPDATA = C:\Users\xxxx\AppData\Local
	ChocolateyLastPathUpdate = 132507832696870653
	USERDOMAIN_ROAMINGPROFILE = DESKTOP-28IRB1E
	PUBLIC = C:\Users\Public
10:05:09 [INF][      Workbench]: Current version given by meta info is: 8.0.25
10:05:10 [INF][      Workbench]: Setting PATH to: C:\Windows\system32;C:\Program Files\Common Files\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Program Files (x86)\PuTTY\;C:\ProgramData\chocolatey\bin;C:\Program Files\Git\cmd;C:\php-7.4.14-nts-Win32-vc15-x64;C:\ProgramData\ComposerSetup\bin;C:\Program Files\nodejs\;C:\Users\xxxx\AppData\Roaming\MySQL\Workbench\modules;C:\Users\xxxx\AppData\Local\Microsoft\WindowsApps;C:\Users\xxxx\AppData\Local\Programs\Microsoft VS Code\bin;C:\Program Files\heroku\bin;C:\apache-maven-3.6.3\bin;C:\Users\xxxx\AppData\Roaming\Composer\vendor\bin;C:\php-7.4.14-nts-Win32-vc15-x64;D:\xampp\mysql\bin;C:\Users\xxxx\AppData\Roaming\npm;C:\Users\xxxx\AppData\Roaming\MySQL\Workbench\modules;
10:05:10 [INF][ mforms managed]: Initializing mforms wrapper
10:05:10 [INF][   WBContext UI]: Initializing workbench context UI with these values:
	base dir: C:\Program Files\MySQL\MySQL Workbench 8.0 CE
	plugin path: C:\Program Files\MySQL\MySQL Workbench 8.0 CE
	struct path: 
	module path: C:\Program Files\MySQL\MySQL Workbench 8.0 CE/modules
	library path: C:\Program Files\MySQL\MySQL Workbench 8.0 CE
	user data dir: C:\Users\xxxx\AppData\Roaming\MySQL\Workbench
	open at start: 
	open type: 
	run at startup: 
	run type: 
	Force SW rendering: No
	Force OpenGL: No
	quit when done: No
10:05:10 [INF][      WBContext]: WbContext::init

Event viewer Information:

Fault bucket 2044772393984538788, type 4
Event Name: APPCRASH
Response: Not available
Cab Id: 0

Problem signature:
P1: MySQLWorkbench.exe
P2: 8.0.25.0
P3: 6089097e
P4: python37.dll
P5: 3.7.7150.1013
P6: 5f8050b5
P7: c0000005
P8: 000000000013c7d4
P9: 
P10: 

Event viewer error:

Faulting application name: MySQLWorkbench.exe, version: 8.0.25.0, time stamp: 0x6089097e
Faulting module name: python37.dll, version: 3.7.7150.1013, time stamp: 0x5f8050b5
Exception code: 0xc0000005
Fault offset: 0x000000000013c7d4
Faulting process id: 0x1b78
Faulting application start time: 0x01d752cfadb80b31
Faulting application path: C:\Program Files\MySQL\MySQL Workbench 8.0 CE\MySQLWorkbench.exe
Faulting module path: C:\Program Files\MySQL\MySQL Workbench 8.0 CE\python37.dll
Report Id: 5a137757-619e-464b-b13d-826e4a7be169
Faulting package full name: 
Faulting package-relative application ID: 

If I have two tables that reference each other and try to export the migration it just hangs and my laptop fans spin up very fast and I need to force quit Workbench. I'm guessing an infinite loop somewhere?

My scenario (see image below) is if you have a company that has many employees, but one employee (usually the owner) has to take responsibility for the company.

when a foreign column create it must have same type

table a id => unsigned and integer

table b parent (foreign key with table a)

parent => integer

*** parent must unsignedInteger