mirror of
https://github.com/roundcube/roundcubemail.git
synced 2025-12-28 07:55:07 +00:00
9713ce364c
Added configurable Collected Recipients addressbook source (#4971) Added configurable Trusted Senders addressbook source (#5046) Added 'contact_exists' hook
11 lines
366 B
SQL
11 lines
366 B
SQL
CREATE TABLE collected_addresses (
|
|
address_id integer NOT NULL PRIMARY KEY,
|
|
user_id integer NOT NULL,
|
|
changed datetime NOT NULL default '0000-00-00 00:00:00',
|
|
name varchar(255) NOT NULL default '',
|
|
email varchar(255) NOT NULL,
|
|
"type" integer NOT NULL
|
|
);
|
|
|
|
CREATE UNIQUE INDEX ix_collected_addresses_user_id ON collected_addresses(user_id, "type", email);
|