MYSQL Bypass errors?

Question

MySQL

Good morning guys when I load the tables into the database it comes out.

ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `notifications_notifiable_id_notifiable_type_index` (`notifiable_id`,`notifiable_type`);

#1071 - Specified key was too long; max key length is 767 bytes
How can I get around these errors? I really need help please!

Answer 1

If I understand correctly, this is Laravel.
in AppServiceProvider.php - add the following line:

public function boot() {
        Schema::defaultStringLength(191);
    }

Answer 2

Yevgeny Samoylenko I think you are a little mistaken. The key name notifications_notifiable_id_notifiable_type_index is far from being 767 bytes. But its value, consisting of the values ​​of the two columns `notifiable_id`,`notifiable_type`, is probably longer.