1 CREATE TABLE user_properties(
2 up_user
INTEGER NULL REFERENCES mwuser(user_id
) ON DELETE CASCADE,
3 up_property
TEXT NOT NULL,
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
);