diff options
Diffstat (limited to 'src/mailman/database/mailman.sql')
| -rw-r--r-- | src/mailman/database/mailman.sql | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/src/mailman/database/mailman.sql b/src/mailman/database/mailman.sql index 9d2b015b7..8d5a424a3 100644 --- a/src/mailman/database/mailman.sql +++ b/src/mailman/database/mailman.sql @@ -252,10 +252,15 @@ CREATE TABLE user ( id INTEGER NOT NULL, real_name TEXT, password TEXT, + _user_id TEXT, preferences_id INTEGER, PRIMARY KEY (id), - CONSTRAINT user_preferences_id_fk FOREIGN KEY(preferences_id) REFERENCES preferences (id) + CONSTRAINT user_preferences_id_fk + FOREIGN KEY(preferences_id) + REFERENCES preferences (id) ); +CREATE INDEX ix_user_user_id ON user (_user_id); + CREATE TABLE version ( id INTEGER NOT NULL, component TEXT, |