Updated hard-coded string lengths for indexed columns

Since this is what's causing issues for people during migration due to max
key lengths.
Related to #2710.

diff --git a/database/migrations/2017_03_19_091553_create_search_index_table.php b/database/migrations/2017_03_19_091553_create_search_index_table.php
index 7398ed39885cedde9655f9fb06783016e6c6b75e..a066fb1309445e378f7880457bfd57fceac28498 100644 (file)
--- a/database/migrations/2017_03_19_091553_create_search_index_table.php
+++ b/database/migrations/2017_03_19_091553_create_search_index_table.php
@@ -15,7 +15,7 @@ class CreateSearchIndexTable extends Migration
     {
         Schema::create('search_terms', function (Blueprint $table) {
             $table->increments('id');
     {
         Schema::create('search_terms', function (Blueprint $table) {
             $table->increments('id');

-            $table->string('term', 200);
+            $table->string('term', 180);

             $table->string('entity_type', 100);
             $table->integer('entity_id');
             $table->integer('score');
             $table->string('entity_type', 100);
             $table->integer('entity_id');
             $table->integer('score');

diff --git a/database/migrations/2018_07_15_173514_add_role_external_auth_id.php b/database/migrations/2018_07_15_173514_add_role_external_auth_id.php
index 706a883a387d996055eebc7742ebb3e56f003fe3..0778e8762dd245e1855c675bf48e4de74bad1621 100644 (file)
--- a/database/migrations/2018_07_15_173514_add_role_external_auth_id.php
+++ b/database/migrations/2018_07_15_173514_add_role_external_auth_id.php
@@ -14,7 +14,7 @@ class AddRoleExternalAuthId extends Migration
     public function up()
     {
         Schema::table('roles', function (Blueprint $table) {
     public function up()
     {
         Schema::table('roles', function (Blueprint $table) {

-            $table->string('external_auth_id', 200)->default('');
+            $table->string('external_auth_id', 180)->default('');

             $table->index('external_auth_id');
         });
     }
             $table->index('external_auth_id');
         });
     }

diff --git a/database/migrations/2018_08_04_115700_create_bookshelves_table.php b/database/migrations/2018_08_04_115700_create_bookshelves_table.php
index 9efba0071c3689c6fe5ce13cdc8faa59ae0f7142..488c6196830c4549b43b8a3d9fb4517eef7704fc 100644 (file)
--- a/database/migrations/2018_08_04_115700_create_bookshelves_table.php
+++ b/database/migrations/2018_08_04_115700_create_bookshelves_table.php
@@ -37,8 +37,8 @@ class CreateBookshelvesTable extends Migration
 
         Schema::create('bookshelves', function (Blueprint $table) {
             $table->increments('id');
 
         Schema::create('bookshelves', function (Blueprint $table) {
             $table->increments('id');

-            $table->string('name', 200);
-            $table->string('slug', 200);
+            $table->string('name', 180);
+            $table->string('slug', 180);

             $table->text('description');
             $table->integer('created_by')->nullable()->default(null);
             $table->integer('updated_by')->nullable()->default(null);
             $table->text('description');
             $table->integer('created_by')->nullable()->default(null);
             $table->integer('updated_by')->nullable()->default(null);

diff --git a/database/migrations/2021_03_08_215138_add_user_slug.php b/database/migrations/2021_03_08_215138_add_user_slug.php
index 906e06b952297e2e5a3557f9ee8d3273c20811f6..dad1e42273c29d551b6be14bf14db25a1b3132eb 100644 (file)
--- a/database/migrations/2021_03_08_215138_add_user_slug.php
+++ b/database/migrations/2021_03_08_215138_add_user_slug.php
@@ -15,7 +15,7 @@ class AddUserSlug extends Migration
     public function up()
     {
         Schema::table('users', function (Blueprint $table) {
     public function up()
     {
         Schema::table('users', function (Blueprint $table) {

-            $table->string('slug', 250);
+            $table->string('slug', 180);

         });
 
         $slugMap = [];
         });
 
         $slugMap = [];