diff options
| author | Barry Warsaw | 2011-03-18 15:01:57 -0400 |
|---|---|---|
| committer | Barry Warsaw | 2011-03-18 15:01:57 -0400 |
| commit | dee26f391da59c68a23f8fb960dff9ebd879e916 (patch) | |
| tree | 9ca545beecf73f7cdaeff7ffd065ccb4dafd72ee /src/mailman/database/mailman.sql | |
| parent | ef3a4a87e2c0f4b640e31afc4828d2edbd005846 (diff) | |
| download | mailman-dee26f391da59c68a23f8fb960dff9ebd879e916.tar.gz mailman-dee26f391da59c68a23f8fb960dff9ebd879e916.tar.zst mailman-dee26f391da59c68a23f8fb960dff9ebd879e916.zip | |
* Give users a unique, random, immutable user id.
* Find users by user_id via the user manager.
* Extend the repr of users to include the user id.
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, |