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