1. Queue table
php artisan queue:failed-table
php artisan migrate


FOR DEPLOYMENT
1. DB::table("dictionaries")->truncate();
2. dictionaries migration
3. importing dictionary
LOAD DATA LOCAL INFILE 'dict_blacklistapidata_13_07_2020.txt' INTO TABLE dictionaries FIELDS TERMINATED BY '|' LINES TERMINATED BY '\r\n' IGNORE 1 LINES; \n for linux

LOAD DATA LOCAL INFILE 'dict_blacklistapidata_13_07_2020.txt' INTO TABLE dictionaries FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' IGNORE 1 LINES;

SHOW INDEX FROM dictionaries;
DROP INDEX index_name ON dictionaries;
ALTER TABLE dictionaries ADD INDEX(original);

alter table dictionaries drop column id
alter table dictionaries add column `id` int(10) unsigned primary KEY AUTO_INCREMENT FIRST;

SELECT DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'dictionaries' AND COLUMN_NAME = 'original';