gplx/mediawiki/maintenance/postgres/archives/patch-user_properties-pk.sql

4 lines
121 B
SQL

DROP INDEX IF EXISTS user_properties_user_property;
ALTER TABLE user_properties
ADD PRIMARY KEY (up_user, up_property);