Request Tokens primary key exceeds 1000 bytes limit

[MichelleBlanchette]

A client reached out with an issue and gave me access to their staging site.

Using Query Monitor, I could see that the Request Tokens database table was failing to be installed:

Specified key was too long; max key length is 1000 bytes

MD5 always produces a string of length 32, so varchar(255) is quite excessive anyways (which is indexed as 1020 bytes).

Update the table schema to use char(32) since a token should always exist and is always MD5-hashed. (link)

[MichelleBlanchette]

Also, please trigger a PHP error every time the database tables fail to be installed. The user had debug log display enabled which only showed an error that the database table was missing.

It'd be good to report the actual SQL error when the database tables fail to be installed or upgraded so I don't need to install Query Monitor to debug issues.