1 -- Switches to SHA1 password storage for register_pending.
2 ALTER TABLE register_pending CHANGE
COLUMN password password VARCHAR(40) NOT NULL;
4 -- Disables MD5(""), SHA1("") and LEFT(SHA1(""), 32) as password.
5 UPDATE register_pending
SET password = "" WHERE password IN ("d41d8cd98f00b204e9800998ecf8427e", "da39a3ee5e6b4b0d3255bfef95601890afd80709", "da39a3ee5e6b4b0d3255bfef95601890");
6 UPDATE auth_user_md5
SET password = "" WHERE password IN ("d41d8cd98f00b204e9800998ecf8427e", "da39a3ee5e6b4b0d3255bfef95601890afd80709", "da39a3ee5e6b4b0d3255bfef95601890");
8 -- vim:set syntax=mysql: