mekici
Hata
SQL sorgusu:
CREATE TABLE banned_ips (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
creator_id int(10) unsigned NOT NULL,
address varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
reason varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
user_id int(10) unsigned DEFAULT NULL,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (id),
UNIQUE KEY banned_ips_address_unique (address),
KEY banned_ips_user_id_foreign (user_id),
CONSTRAINT banned_ips_user_id_foreign FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
MySQL çıktısı: Belgeler
#1071 - Specified key was too long; max key length is 767 bytes
sql dosyasını yüklerken bu hatayı aldım yardımcı olabilir misiniz?
