1 CREATE TABLE /*_*/user_properties_tmp (
2 -- Foreign key to user.user_id
5 -- Name of the option being saved. This is indexed for bulk lookup.
6 up_property
varbinary(255) NOT NULL,
8 -- Property value as a string.
10 PRIMARY KEY (up_user
,up_property
)
11 ) /*$wgDBTableOptions*/;
13 INSERT INTO /*_*/user_properties_tmp
14 SELECT * FROM /*_*/user_properties
;
16 DROP TABLE /*_*/user_properties
;
18 ALTER TABLE /*_*/user_properties_tmp
RENAME TO /*_*/user_properties
;
20 CREATE INDEX /*i*/user_properties_property
ON /*_*/user_properties (up_property
);