diff options
Diffstat (limited to 'SQL/postgres.initial.sql')
| -rw-r--r-- | SQL/postgres.initial.sql | 16 |
1 files changed, 1 insertions, 15 deletions
diff --git a/SQL/postgres.initial.sql b/SQL/postgres.initial.sql index e12a9978a..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); -- @@ -160,23 +158,11 @@ CREATE TABLE contactgroupmembers ( CREATE INDEX contactgroupmembers_contact_id_idx ON contactgroupmembers (contact_id); -- --- Sequence "cache_ids" --- Name: cache_ids; Type: SEQUENCE; Schema: public; Owner: postgres --- - -CREATE SEQUENCE cache_ids - INCREMENT BY 1 - NO MAXVALUE - NO MINVALUE - CACHE 1; - --- -- Table "cache" -- Name: cache; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE "cache" ( - cache_id integer DEFAULT nextval('cache_ids'::text) PRIMARY KEY, user_id integer NOT NULL REFERENCES users (user_id) ON DELETE CASCADE ON UPDATE CASCADE, cache_key varchar(128) DEFAULT '' NOT NULL, |