no indices in postgres database schema bug + DDL improvements

[alec]

1. postgres is not creating indices for "REFERENCES" columns, so we must to create them explicitly:

CREATE INDEX contacts_user_id_idx ON contacts (user_id);
CREATE INDEX identities_user_id_idx ON identities (user_id);
CREATE INDEX cache_user_id_idx ON cache (user_id);
CREATE INDEX cache_session_id_idx ON cache (session_id);

2. also I think that few indices defined in mysql ddl script aren't used at all and can be removed, i.e. messages/uid, message/idx, also cache/cache_key

3. Proposition for new indices:

CREATE INDEX users_username_id_idx ON users (username);
CREATE INDEX users_alias_id_idx ON users (alias);
they are used by query in function rcube_user::query()

[alec]

Also ON DELETE CASCADE should be used, because when I delete user (remove account from mail server), all referenced data should be deleted automatically.

[till]

Can you supply a patch for your requests?

[thomasb]

2. is fixed in [ac26b964]

[alec]

Fixed in [6cb77869]