Fix database table name, it is 'profiling', not 'profileinfo'

[mediawiki.git] / maintenance / postgres / archives / patch-user_properties.sql

CREATE TABLE user_properties(
  up_user   INTEGER      NULL  REFERENCES mwuser(user_id) ON DELETE CASCADE,
  up_property TEXT NOT NULL,
  up_value TEXT
);

CREATE UNIQUE INDEX user_properties_user_property on user_properties (up_user,up_property);
CREATE INDEX user_properties_property on user_properties (up_property);