| 1 | -- Switches to SHA1 password storage for register_pending. |
| 2 | ALTER TABLE register_pending CHANGE COLUMN password password VARCHAR(40) NOT NULL; |
| 3 | |
| 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"); |
| 7 | |
| 8 | -- vim:set syntax=mysql: |