[Summary view] [Print] [Text view]

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