mardi 19 mars 2019

A space in front of column in table when created from Laravel migration

Does anyone run into an issue like me, have extra spaces when I created a table via Laravel migration?

And I'd re-ran couples of time for this migration file and still created extra spaces.

My environment.

  • Laravel 5.6
  • PHP 7.2
  • MySQL 5.7.23

Here are my pictures and migration content.

enter image description here

enter image description here

Schema::create('plugin_packages', function (Blueprint $table) {
            $table->char('id', 36)->primary();
            $table->char('plugin_id', 36)->nullable();
            $table->char('plugin_package_device_model_id', 36)->nullable();
            $table->char('plugin_package_os_version_id', 36)->nullable();
            $table->string('version_number');
            $table->string('file');
            $table->timestamps();
            $table->softDeletes();

            $table->foreign('plugin_id')->references('id')->on('plugins')->onUpdate('cascade')->onDelete('cascade');
            $table->foreign('plugin_package_device_model_id', 'ppdm_id_foreign')->references('id')->on('plugin_package_device_models')->onUpdate('cascade')->onDelete('cascade');
            $table->foreign('plugin_package_os_version_id', 'ppov_id_foreign')->references('id')->on('plugin_package_os_versions')->onUpdate('cascade')->onDelete('cascade');
        });

Thank you.



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire