1CREATE TABLE collected_contacts (
2  contact_id integer NOT NULL PRIMARY KEY,
3  user_id integer NOT NULL,
4  changed datetime NOT NULL default '0000-00-00 00:00:00',
5  del tinyint NOT NULL default '0',
6  name varchar(128) NOT NULL default '',
7  email text NOT NULL default '',
8  firstname varchar(128) NOT NULL default '',
9  surname varchar(128) NOT NULL default '',
10  vcard text NOT NULL default '',
11  words text NOT NULL default ''
12);
13
14CREATE INDEX ix_collected_contacts_user_id ON collected_contacts(user_id, del);
15