X-Git-Url: https://git.heureux-cyclage.org/?a=blobdiff_plain;f=maintenance%2Farchives%2Fpatch-user_rights.sql;h=4947cb1f782126207cccce672bfea79344e4c551;hb=71f7726fe040329f0261c3f874da1044ebbb9e39;hp=36f0102a78271bbe365afa53acfb7c2409269f05;hpb=fa8603c521f98bce49daeebdb7c4a4ca0f494a44;p=lhc%2Fweb%2Fwiklou.git diff --git a/maintenance/archives/patch-user_rights.sql b/maintenance/archives/patch-user_rights.sql index 36f0102a78..4947cb1f78 100644 --- a/maintenance/archives/patch-user_rights.sql +++ b/maintenance/archives/patch-user_rights.sql @@ -7,14 +7,14 @@ CREATE TABLE /*$wgDBprefix*/user_rights ( -- Key to user_id - ur_user int(5) unsigned NOT NULL, - + ur_user int unsigned NOT NULL, + -- Comma-separated list of permission keys - ur_rights tinyblob NOT NULL default '', - + ur_rights tinyblob NOT NULL, + UNIQUE KEY ur_user (ur_user) -) TYPE=InnoDB; +) /*$wgDBTableOptions*/; INSERT INTO /*$wgDBprefix*/user_rights SELECT user_id,user_rights FROM /*$wgDBprefix*/user;