二次元发卡解决卡密长度问题

打开数据库phpmyadmin工具，执行sql命令

例子一

SHOW INDEX FROM acg_card WHERE Column_name = 'secret';

ALTER TABLE acg_card 
  DROP INDEX secret, 
  MODIFY secret LONGTEXT NOT NULL,
  ADD COLUMN secret_hash CHAR(64) NOT NULL DEFAULT '',
  ADD INDEX idx_secret_hash (secret_hash);

UPDATE acg_card 
SET secret_hash = SHA2(secret, 256) 
WHERE secret_hash = '';

例子二

ALTER TABLE acg_card
DROP INDEX secret,
DROP INDEX secret_2,
MODIFY secret LONGTEXT NOT NULL,
ADD COLUMN secret_hash CHAR(64) NOT NULL DEFAULT '',
ADD INDEX idx_secret_hash (secret_hash);

UPDATE acg_card 
SET secret_hash = SHA2(secret, 256) 
WHERE secret_hash = '';

看不懂自己问ai