+plugins/acl/ usr/share/roundcube/plugins
plugins/additional_message_headers/ usr/share/roundcube/plugins
plugins/archive/ usr/share/roundcube/plugins
plugins/autologon/ usr/share/roundcube/plugins
plugins/database_attachments/ usr/share/roundcube/plugins
plugins/debug_logger/ usr/share/roundcube/plugins
plugins/emoticons/ usr/share/roundcube/plugins
+plugins/enigma/ usr/share/roundcube/plugins
plugins/help/ usr/share/roundcube/plugins
plugins/http_authentication/ usr/share/roundcube/plugins
plugins/managesieve/ usr/share/roundcube/plugins
plugins/markasjunk/ usr/share/roundcube/plugins
plugins/new_user_dialog/ usr/share/roundcube/plugins
plugins/new_user_identity/ usr/share/roundcube/plugins
+plugins/newmail_notifier/ usr/share/roundcube/plugins
plugins/password /usr/share/roundcube/plugins
plugins/show_additional_headers/ usr/share/roundcube/plugins
plugins/squirrelmail_usercopy/ usr/share/roundcube/plugins
--- /dev/null
+CREATE TABLE contacts_tmp (
+ contact_id integer NOT NULL PRIMARY KEY,
+ user_id integer NOT NULL default '0',
+ changed datetime NOT NULL default '0000-00-00 00:00:00',
+ del tinyint NOT NULL default '0',
+ name varchar(128) NOT NULL default '',
+ email varchar(255) NOT NULL default '',
+ firstname varchar(128) NOT NULL default '',
+ surname varchar(128) NOT NULL default '',
+ vcard text NOT NULL default ''
+);
+
+INSERT INTO contacts_tmp (contact_id, user_id, changed, del, name, email, firstname, surname, vcard)
+ SELECT contact_id, user_id, changed, del, name, email, firstname, surname, vcard FROM contacts;
+
+DROP TABLE contacts;
+CREATE TABLE contacts (
+ contact_id integer NOT NULL PRIMARY KEY,
+ user_id integer NOT NULL default '0',
+ changed datetime NOT NULL default '0000-00-00 00:00:00',
+ del tinyint NOT NULL default '0',
+ name varchar(128) NOT NULL default '',
+ email varchar(255) NOT NULL default '',
+ firstname varchar(128) NOT NULL default '',
+ surname varchar(128) NOT NULL default '',
+ vcard text NOT NULL default '',
+ words text NOT NULL default ''
+);
+
+INSERT INTO contacts (contact_id, user_id, changed, del, name, email, firstname, surname, vcard)
+ SELECT contact_id, user_id, changed, del, name, email, firstname, surname, vcard FROM contacts_tmp;
+
+CREATE INDEX ix_contacts_user_id ON contacts(user_id, email);
+DROP TABLE contacts_tmp;
+
+DELETE FROM messages;
+DELETE FROM cache;
+CREATE INDEX ix_contactgroupmembers_contact_id ON contactgroupmembers (contact_id);