maintenance/postgres/archives/patch-user_properties.sql


1
2
3
4
5
6
7
8

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);