maintenance/archives/patch-user_nameindex.sql


1
2
3
4
5
6
7
8
9
10
11
12
13

--
-- Change the index on user_name to a unique index to prevent
-- duplicate registrations from creeping in.
--
-- Run maintenance/userDupes.php or through the updater first
-- to clean up any prior duplicate accounts.
--
-- Added 2005-06-05
--

     ALTER TABLE /*$wgDBprefix*/user
      DROP INDEX user_name,
ADD UNIQUE INDEX user_name(user_name);