maintenance/archives/patch-user_properties.sql

   1 -- Table for holding user properties.
   2
   3 CREATE TABLE /*_*/user_properties(
   4   up_user bigint not null,
   5   up_property varbinary(32) not null,
   6   up_value blob
   7 ) /*$wgDBTableOptions*/;
   8
   9 CREATE UNIQUE INDEX /*i*/user_properties_user_property on user_properties (up_user,up_property);
  10 CREATE INDEX /*i*/user_properties_property on user_properties (up_property);