maintenance/archives/patch-actor-table.sql

   1 --
   2 -- patch-actor-table.sql
   3 --
   4 -- T167246. Add an `actor` table.
   5
   6 CREATE TABLE /*_*/actor (
   7   actor_id bigint unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
   8   actor_user int unsigned,
   9   actor_name varchar(255) binary NOT NULL
  10 ) /*$wgDBTableOptions*/;
  11 CREATE UNIQUE INDEX /*i*/actor_user ON /*_*/actor (actor_user);
  12 CREATE UNIQUE INDEX /*i*/actor_name ON /*_*/actor (actor_name);