INDEX_SPEC table=book_chapters name=book_chapters_book_id_slug_unique unique=True type=BTREE estimated_bytes=1032 columns=book_id(len=0,sub=0,cs=); slug(len=255,sub=0,cs=utf8mb4)
BEFORE index=book_chapters_book_id_slug_unique table=book_chapters unique=True cols=book_id,slug
AFTER index=book_chapters_book_id_slug_unique table=book_chapters unique=True cols=`book_id`, `slug`(191)
INDEX_SPEC table=cms_books name=books_language_code_slug_unique unique=True type=BTREE estimated_bytes=1084 columns=language_code(len=16,sub=0,cs=utf8mb4); slug(len=255,sub=0,cs=utf8mb4)
BEFORE index=books_language_code_slug_unique table=cms_books unique=True cols=language_code,slug
AFTER index=books_language_code_slug_unique table=cms_books unique=True cols=`language_code`(16), `slug`(191)
INDEX_SPEC table=cms_contents name=cms_contents_slug_index unique=False type=BTREE estimated_bytes=1020 columns=slug(len=255,sub=0,cs=utf8mb4)
BEFORE index=cms_contents_slug_index table=cms_contents unique=False cols=slug
AFTER index=cms_contents_slug_index table=cms_contents unique=False cols=`slug`(191)
INDEX_SPEC table=cms_contents name=cms_contents_language_slug_unique unique=True type=BTREE estimated_bytes=1084 columns=language(len=16,sub=0,cs=utf8mb4); slug(len=255,sub=0,cs=utf8mb4)
BEFORE index=cms_contents_language_slug_unique table=cms_contents unique=True cols=language,slug
AFTER index=cms_contents_language_slug_unique table=cms_contents unique=True cols=`language`(16), `slug`(191)
INDEX_SPEC table=cms_media name=cms_media_disk_path_unique unique=True type=BTREE estimated_bytes=2128 columns=disk(len=32,sub=0,cs=utf8mb4); path(len=500,sub=0,cs=utf8mb4)
BEFORE index=cms_media_disk_path_unique table=cms_media unique=True cols=disk,path
AFTER index=cms_media_disk_path_unique table=cms_media unique=True cols=`disk`(32), `path`(191)
INDEX_SPEC table=cms_media name=cms_media_disk_path_index unique=False type=BTREE estimated_bytes=2128 columns=disk(len=32,sub=0,cs=utf8mb4); path(len=500,sub=0,cs=utf8mb4)
BEFORE index=cms_media_disk_path_index table=cms_media unique=False cols=disk,path
AFTER index=cms_media_disk_path_index table=cms_media unique=False cols=`disk`(32), `path`(191)
INDEX_SPEC table=email_logs name=email_logs_status_index unique=False type=BTREE estimated_bytes=1020 columns=status(len=255,sub=0,cs=utf8mb4)
BEFORE index=email_logs_status_index table=email_logs unique=False cols=status
AFTER index=email_logs_status_index table=email_logs unique=False cols=`status`(191)
INDEX_SPEC table=failed_jobs name=failed_jobs_uuid_unique unique=True type=BTREE estimated_bytes=1020 columns=uuid(len=255,sub=0,cs=utf8mb4)
BEFORE index=failed_jobs_uuid_unique table=failed_jobs unique=True cols=uuid
AFTER index=failed_jobs_uuid_unique table=failed_jobs unique=True cols=`uuid`(191)
INDEX_SPEC table=password_resets name=password_resets_email_index unique=False type=BTREE estimated_bytes=1020 columns=email(len=255,sub=0,cs=utf8mb4)
BEFORE index=password_resets_email_index table=password_resets unique=False cols=email
AFTER index=password_resets_email_index table=password_resets unique=False cols=`email`(191)
INDEX_SPEC table=permissions name=permissions_name_unique unique=True type=BTREE estimated_bytes=1020 columns=name(len=255,sub=0,cs=utf8mb4)
BEFORE index=permissions_name_unique table=permissions unique=True cols=name
AFTER index=permissions_name_unique table=permissions unique=True cols=`name`(191)
INDEX_SPEC table=personal_access_tokens name=personal_access_tokens_tokenable_type_tokenable_id_index unique=False type=BTREE estimated_bytes=1032 columns=tokenable_type(len=255,sub=0,cs=utf8mb4); tokenable_id(len=0,sub=0,cs=)
BEFORE index=personal_access_tokens_tokenable_type_tokenable_id_index table=personal_access_tokens unique=False cols=tokenable_type,tokenable_id
AFTER index=personal_access_tokens_tokenable_type_tokenable_id_index table=personal_access_tokens unique=False cols=`tokenable_type`(191), `tokenable_id`
INDEX_SPEC table=roles name=roles_name_unique unique=True type=BTREE estimated_bytes=1020 columns=name(len=255,sub=0,cs=utf8mb4)
BEFORE index=roles_name_unique table=roles unique=True cols=name
AFTER index=roles_name_unique table=roles unique=True cols=`name`(191)
INDEX_SPEC table=seed_fingerprints name=seed_fingerprints_model_lookup_hash_unique unique=True type=BTREE estimated_bytes=1020 columns=model(len=191,sub=0,cs=utf8mb4); lookup_hash(len=64,sub=0,cs=utf8mb4)
BEFORE index=seed_fingerprints_model_lookup_hash_unique table=seed_fingerprints unique=True cols=model,lookup_hash
AFTER index=seed_fingerprints_model_lookup_hash_unique table=seed_fingerprints unique=True cols=`model`(191), `lookup_hash`(59)
INDEX_SPEC table=settings name=settings_key_unique unique=True type=BTREE estimated_bytes=1020 columns=key(len=255,sub=0,cs=utf8mb4)
BEFORE index=settings_key_unique table=settings unique=True cols=key
AFTER index=settings_key_unique table=settings unique=True cols=`key`(191)
INDEX_SPEC table=users name=users_email_unique unique=True type=BTREE estimated_bytes=1020 columns=email(len=255,sub=0,cs=utf8mb4)
BEFORE index=users_email_unique table=users unique=True cols=email
AFTER index=users_email_unique table=users unique=True cols=`email`(191)