upgrade/0.9.17/00_password.sql

   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: