patch-user_properties.sql 320 B

123456789
  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. CREATE UNIQUE INDEX user_properties_user_property on user_properties (up_user,up_property);
  7. CREATE INDEX user_properties_property on user_properties (up_property);