maintenance/postgres/archives/patch-user_properties.sql

   1 CREATE TABLE user_properties(
   2   up_user   INTEGER      NULL  REFERENCES mwuser(user_id) ON DELETE CASCADE,
   3   up_property TEXT NOT NULL,
   4   up_value TEXT
   5 );
   6
   7 CREATE UNIQUE INDEX user_properties_user_property on user_properties (up_user,up_property);
   8 CREATE INDEX user_properties_property on user_properties (up_property);