patch-user_nameindex.sql

来自「php 开发的内容管理系统」· SQL 代码 · 共 14 行

--
-- 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);