"Fossies" - the Fresh Open Source Software Archive

Member "roundcubemail-1.4.2/SQL/sqlite/2009090400.sql" (1 Jan 2020, 343 Bytes) of package /linux/www/roundcubemail-1.4.2.tar.gz:


As a special service "Fossies" has tried to format the requested source page into HTML format using (guessed) PL/SQL source code syntax highlighting (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 -- Updates from version 0.3-stable
    2 
    3 DELETE FROM messages;
    4 DROP INDEX ix_messages_user_cache_uid;
    5 CREATE UNIQUE INDEX ix_messages_user_cache_uid ON messages (user_id,cache_key,uid);
    6 CREATE INDEX ix_messages_index ON messages (user_id,cache_key,idx);
    7 DROP INDEX ix_contacts_user_id;
    8 CREATE INDEX ix_contacts_user_id ON contacts(user_id, email);