maintenance/archives/patch-user_nameindex.sql

   1 --
   2 -- Change the index on user_name to a unique index to prevent
   3 -- duplicate registrations from creeping in.
   4 --
   5 -- Run maintenance/userDupes.php or through the updater first
   6 -- to clean up any prior duplicate accounts.
   7 --
   8 -- Added 2005-06-05
   9 --
  10
  11      ALTER TABLE /*$wgDBprefix*/user
  12       DROP INDEX user_name,
  13 ADD UNIQUE INDEX user_name(user_name);