diff options
| author | Aleksander Machniak <alec@alec.pl> | 2012-08-06 11:08:58 +0200 |
|---|---|---|
| committer | Aleksander Machniak <alec@alec.pl> | 2012-08-06 11:08:58 +0200 |
| commit | 565c472918e7f9707cd8d7909ad5dbcc5a921fdf (patch) | |
| tree | 8c4c40ab241766d931c69ee3ddcca5b3511cc800 /SQL/postgres.initial.sql | |
| parent | 83121ece3348bfe09bb1026eace79a74a5ccf2c9 (diff) | |
Removed users.alias column, added option ('user_aliases')
to use email address from identities as username (#1488581)
Diffstat (limited to 'SQL/postgres.initial.sql')
| -rw-r--r-- | SQL/postgres.initial.sql | 4 |
1 files changed, 1 insertions, 3 deletions
diff --git a/SQL/postgres.initial.sql b/SQL/postgres.initial.sql index a47bec2ca..f7b2d96d9 100644 --- a/SQL/postgres.initial.sql +++ b/SQL/postgres.initial.sql @@ -20,7 +20,6 @@ CREATE TABLE users ( user_id integer DEFAULT nextval('user_ids'::text) PRIMARY KEY, username varchar(128) DEFAULT '' NOT NULL, mail_host varchar(128) DEFAULT '' NOT NULL, - alias varchar(128) DEFAULT '' NOT NULL, created timestamp with time zone DEFAULT now() NOT NULL, last_login timestamp with time zone DEFAULT NULL, "language" varchar(5), @@ -28,9 +27,7 @@ CREATE TABLE users ( CONSTRAINT users_username_key UNIQUE (username, mail_host) ); -CREATE INDEX users_alias_id_idx ON users (alias); - -- -- Table "session" -- Name: session; Type: TABLE; Schema: public; Owner: postgres @@ -81,6 +78,7 @@ CREATE TABLE identities ( ); CREATE INDEX identities_user_id_idx ON identities (user_id, del); +CREATE INDEX identities_email_idx ON identities (email, del); -- |